ABL_GEN_SALMON_BYCATCH
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:27651 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |