Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Genetic data of salmon bycatch samples used for mixed-stock analyses to determine geographic region of origin.

Description

These data are the output of genetics analysis of tissues collected by observers at sea.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SAL_BYCATCH_SEQ
Number
Oracle Generated Unique Identifier of a record
CRUISE
Number
Observer Cruise Inherited from debriefed_age
PERMIT
VARCHAR2
Vessel federal fisheries permit Inherited from debriefed_age
SPECIMEN_NUMBER
NUMBER
Inherited from debriefed_age, a specimen number is unique within a cruise, permit, length and specimen type. It is a user defined identifier.
HAUL_OFFLOAD
NUMBER
Haul or offload from which the genetics specimen was collected.
SPECIMEN_TYPE
NUMBER
Specimen type code. This references the definition about what is being measured or commented.
SEX
VARCHAR2
Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
SPECIES
NUMBER
Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
PORT_JOIN
NUMBER
Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port.
HAUL_JOIN
NUMBER
Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
SPECIMEN_SEQ
NUMBER
Oracle Generated Unique Identifier of a specimen record from the Observer database entered into record by a before insert record trigger on the table.
SAMPLE_ID
VARCHAR2
Intelligent key assigned by staff uniquely identifying this record.
YEAR
NUMBER
Year that the genetic sample was collected and analysis done.
OKI100_1
NUMBER
First allele at genetic marker OKI100
OKI100_2
NUMBER
Second allele at genetic marker OKI100
OMM1070_1
NUMBER
First allele at genetic marker OMM1070
OMM1070_2
NUMBER
Second allele at genetic marker OMM 1070
OMY1011_1
NUMBER
First allele at genetic marker OMY1011
OMY1011_2
NUMBER
Second allele at genetic marker OMY1011
ONE101_1
NUMBER
First allele at genetic marker ONE101
ONE101_2
NUMBER
Second allele at genetic marker ONE102
ONE102_1
NUMBER
First allele at genetic marker ONE102
ONE102_2
NUMBER
Second allele at genetic marker ONE102
ONE104_1
NUMBER
First allele at genetic marker ONE104
ONE104_2
NUMBER
Second allele at genetic marker ONE104
ONE114_1
NUMBER
First allele at genetic marker ONE114
ONE114_2
NUMBER
Second allele at genetic marker ONE114
OTS103_1
NUMBER
First allele at genetic marker OTS103
OTS103_2
NUMBER
Second allele at genetic marker OTS103
OTS3_1
NUMBER
First allele at genetic marker OTS3
OTS3_2
NUMBER
Second allele at genetic marker OTS3
OTSG68_1
NUMBER
First allele at genetic marker OTSG68
OTSG68_2
NUMBER
Second allele at genetic marker OTSG68
SSA419_1
NUMBER
First allele at genetic marker SSA419
SSA419_2
NUMBER
Second allele at genetic marker SSA 419
BINARY
VARCHAR2
Binary format of alleles at each genetic marker.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: ABL_GEN_SALMON_BYCATCH
Short Name: Salmon Genetics
Status: In Work
Abstract:

Genetic data of salmon bycatch samples used for mixed-stock analyses to determine geographic region of origin.

Keywords

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None Annual Assessment

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None Region of origin

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None Salmon

Physical Location

Organization: Alaska Fisheries Science Center
City: Seattle
State/Province: WA
Country: USA
Location Description:

The data is compiled and analysis done at TSMRI. It is ultimately archived with observer derived fishery statistics at the AFSC in Seattle.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: Salmon Genetics
Schema Name: obsint
Description:

These data are the output of genetics analysis of tissues collected by observers at sea.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SAL_BYCATCH_SEQ Number Oracle Generated Unique Identifier of a record
100
CRUISE Number Observer Cruise Inherited from debriefed_age
100
PERMIT VARCHAR2 Vessel federal fisheries permit Inherited from debriefed_age
100
SPECIMEN_NUMBER NUMBER Inherited from debriefed_age, a specimen number is unique within a cruise, permit, length and specimen type. It is a user defined identifier.
100
HAUL_OFFLOAD NUMBER Haul or offload from which the genetics specimen was collected.
100
SPECIMEN_TYPE NUMBER Specimen type code. This references the definition about what is being measured or commented.
100
SEX VARCHAR2 Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
100
SPECIES NUMBER Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
100
PORT_JOIN NUMBER Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port.
100
HAUL_JOIN NUMBER Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.
100
SPECIMEN_SEQ NUMBER Oracle Generated Unique Identifier of a specimen record from the Observer database entered into record by a before insert record trigger on the table.
100
SAMPLE_ID VARCHAR2 Intelligent key assigned by staff uniquely identifying this record.
100
YEAR NUMBER Year that the genetic sample was collected and analysis done.
100
OKI100_1 NUMBER First allele at genetic marker OKI100
100
OKI100_2 NUMBER Second allele at genetic marker OKI100
100
OMM1070_1 NUMBER First allele at genetic marker OMM1070
100
OMM1070_2 NUMBER Second allele at genetic marker OMM 1070
100
OMY1011_1 NUMBER First allele at genetic marker OMY1011
100
OMY1011_2 NUMBER Second allele at genetic marker OMY1011
100
ONE101_1 NUMBER First allele at genetic marker ONE101
100
ONE101_2 NUMBER Second allele at genetic marker ONE102
100
ONE102_1 NUMBER First allele at genetic marker ONE102
100
ONE102_2 NUMBER Second allele at genetic marker ONE102
100
ONE104_1 NUMBER First allele at genetic marker ONE104
100
ONE104_2 NUMBER Second allele at genetic marker ONE104
100
ONE114_1 NUMBER First allele at genetic marker ONE114
100
ONE114_2 NUMBER Second allele at genetic marker ONE114
100
OTS103_1 NUMBER First allele at genetic marker OTS103
100
OTS103_2 NUMBER Second allele at genetic marker OTS103
100
OTS3_1 NUMBER First allele at genetic marker OTS3
100
OTS3_2 NUMBER Second allele at genetic marker OTS3
100
OTSG68_1 NUMBER First allele at genetic marker OTSG68
100
OTSG68_2 NUMBER Second allele at genetic marker OTSG68
100
SSA419_1 NUMBER First allele at genetic marker SSA419
100
SSA419_2 NUMBER Second allele at genetic marker SSA 419
100
BINARY VARCHAR2 Binary format of alleles at each genetic marker.

Attribute Details

SAL_BYCATCH_SEQ

CC ID: 233506
Seq. Order: 1
Data Storage Type: Number
Max Length: 9
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Oracle Generated Unique Identifier of a record

CRUISE

CC ID: 233507
Seq. Order: 5
Data Storage Type: Number
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Observer Cruise Inherited from debriefed_age

PERMIT

CC ID: 233508
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Vessel federal fisheries permit Inherited from debriefed_age

SPECIMEN_NUMBER

CC ID: 233509
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 6
Required: Yes
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Inherited from debriefed_age, a specimen number is unique within a cruise, permit, length and specimen type. It is a user defined identifier.

HAUL_OFFLOAD

CC ID: 233510
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 6
Required: Yes
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Haul or offload from which the genetics specimen was collected.

SPECIMEN_TYPE

CC ID: 233511
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Specimen type code. This references the definition about what is being measured or commented.

SEX

CC ID: 233513
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.

SPECIES

CC ID: 233514
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 4
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.

PORT_JOIN

CC ID: 233515
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port.

HAUL_JOIN

CC ID: 233516
Seq. Order: 45
Data Storage Type: NUMBER
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul.

SPECIMEN_SEQ

CC ID: 233517
Seq. Order: 50
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Oracle Generated Unique Identifier of a specimen record from the Observer database entered into record by a before insert record trigger on the table.

SAMPLE_ID

CC ID: 233518
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Intelligent key assigned by staff uniquely identifying this record.

YEAR

CC ID: 233519
Seq. Order: 60
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Year that the genetic sample was collected and analysis done.

OKI100_1

CC ID: 233520
Seq. Order: 65
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

First allele at genetic marker OKI100

OKI100_2

CC ID: 233521
Seq. Order: 70
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker OKI100

OMM1070_1

CC ID: 233523
Seq. Order: 73
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker OMM1070

OMM1070_2

CC ID: 233522
Seq. Order: 75
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker OMM 1070

OMY1011_1

CC ID: 233524
Seq. Order: 80
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker OMY1011

OMY1011_2

CC ID: 233525
Seq. Order: 85
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker OMY1011

ONE101_1

CC ID: 233526
Seq. Order: 90
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker ONE101

ONE101_2

CC ID: 233527
Seq. Order: 100
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker ONE102

ONE102_1

CC ID: 233528
Seq. Order: 105
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker ONE102

ONE102_2

CC ID: 233530
Seq. Order: 107
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker ONE102

ONE104_1

CC ID: 233529
Seq. Order: 110
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker ONE104

ONE104_2

CC ID: 261800
Seq. Order: 112
Data Storage Type: NUMBER
Max Length: 3
Min Length: 0
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker ONE104

ONE114_1

CC ID: 233531
Seq. Order: 115
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker ONE114

ONE114_2

CC ID: 233532
Seq. Order: 120
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker ONE114

OTS103_1

CC ID: 233533
Seq. Order: 125
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker OTS103

OTS103_2

CC ID: 233534
Seq. Order: 130
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker OTS103

OTS3_1

CC ID: 233535
Seq. Order: 135
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker OTS3

OTS3_2

CC ID: 233536
Seq. Order: 140
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker OTS3

OTSG68_1

CC ID: 233537
Seq. Order: 145
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker OTSG68

OTSG68_2

CC ID: 233538
Seq. Order: 150
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker OTSG68

SSA419_1

CC ID: 233539
Seq. Order: 155
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

First allele at genetic marker SSA419

SSA419_2

CC ID: 233540
Seq. Order: 160
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Second allele at genetic marker SSA 419

BINARY

CC ID: 233541
Seq. Order: 165
Data Storage Type: VARCHAR2
Max Length: 1062
Required: Yes
Primary Key: No
Status: Active
Description:

Binary format of alleles at each genetic marker.

Catalog Details

Catalog Item ID: 27651
GUID: gov.noaa.nmfs.inport:27651
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-10-02 18:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18