ABL_GEN_SALMON_BYCATCH
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:27651 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Genetic data of salmon bycatch samples used for mixed-stock analyses to determine geographic region of origin.
DescriptionThese 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
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 |