Table: TAXON_* or REPORT_*
COLUMN_NAME DATATYPOE NULLABLE COMMENTS
----------------------- --------------- -------------- -------------------------------------------------------------
TAX_UID NUMBER(6,0) No 1 Primary Key
TXRNK_UID NUMBER(6,0) No 2 Taxon Rank Foreign Key
TAX_NAME VARCHAR2(120 BYTE) No 3 The name of the organism from which a tissue sample was taken
TAX_EXTRNL_ID NUMBER(12,0) Yes 4 The ID for this taxon in the Integrated Taxonomic Information System (ITIS)
TAX_STORET_ID NUMBER(12,0) Yes 5 The ID for this taxon in the Modernized STORET System (which was replaced by WQX)
TAX_SRS_ID NUMBER(12,0) Yes 6 The ID for this taxon in the Substance Registry System (SRS)
TAX_RETIRED_NAME VARCHAR2(120 BYTE) Yes 7 The legacy name for a taxon that has been retired
TAX_RETIRED_EXTRNL_ID NUMBER(12,0) Yes 8 The legacy ID for a taxon that has been retired
TAX_LAST_CHANGE_DATE DATE No SYSTIMESTAMP 9 The date of the last change to data in this row
TAX_DESCRIPTION VARCHAR2(1000 BYTE) Yes 10 The description for this taxon or the URL for it in the Integrated Taxonomic Information System (ITIS)
TAX_EXTRNL_ID_PARENT NUMBER(12,0) Yes 11 Registered ITIS Parent Taxanomic Serial Number (PARENT_TSN)
TAX_UID_KINGDOM NUMBER(6,0) Yes 12 Taxon Kingdom Foreign Key
TAX_UID_NAME VARCHAR2(120 BYTE) Yes 13 Taxon Name Primary Unique Key.
USR_UID_LAST_CHANGE NUMBER(6,0) No 1 14 The Unique ID for the user responsible for the last change to data in this row
TAXGRP_UID NUMBER(6,0) Yes 1 15
DVSTA_UID NUMBER(6,0) Yes 1 16
Table: TAXON_ALIAS*
COLUMN_NAME DATATYPOE NULLABLE COMMENTS
----------------------- --------------- -------------- -------------------------------------------------------------
TAXALS_UID NUMBER(6,0) No 1 Primary unique identifier
ALSTYP_UID NUMBER(6,0) No 2 Alias type foreign key
TAXALS_NAME VARCHAR2(120 BYTE) No 3 ALIAS NAME
TAX_UID NUMBER(6,0) No 4 Taxon identifier foreign key
TAXALS_DESCRIPTION VARCHAR2(400 BYTE) Yes 5 Taxon alias description for additional metadata
TAXALS_LAST_CHANGE_DATE DATE No sysdate 6 The date of the last change to data in this row
USR_UID_LAST_CHANGE NUMBER(6,0) No 1 7 The Unique ID for the user responsible for the last change to data in this row
Table: ALIAS_TYPE
COLUMN_NAME DATATYPOE NULLABLE COMMENTS
----------------------- --------------- -------------- -------------------------------------------------------------
ALSTYP_UID NUMBER(6,0) No 1
ALSTYP_NAME VARCHAR2(60 BYTE) No 2
ALSTYP_LAST_CHANGE_DATE DATE No "sysdate
" 3
USR_UID_LAST_CHANGE NUMBER(6,0) No 1 4
Content:
1 STANDARDIZE NAME (Normalized) 11-JUN-18 1
2 CAS NUMBER 11-JUN-18 1
3 SYSTEMATIC NAME 11-JUN-18 1
4 EPA ID (SUBSTANCE REGISTRY #) 11-JUN-18 1
5 ITIS TAXON SERIAL NUMBER 11-JUN-18 1
6 TAXON COMMON NAME 11-JUN-18 1
7 STORET CHARACTERISTIC NAME 11-JUN-18 1
8 STORET PARM CODE 11-JUN-18 1
9 NWIS PARM CODE 11-JUN-18 1
10 RETIRED NAME 11-JUN-18 1
11 MOLECULAR WEIGHT 11-JUN-18 1
.....
01 BenchTaxonName
02 BenchTaxonNameReferenceCode
03 BioDataTaxonName
04 BioDataCommonName
05 PublishedTaxonName
06 PublishedSortOrder
Table: ALIAS_TYPE
COLUMN_NAME DATATYPOE NULLABLE COMMENTS
----------------------- --------------- -------------- -------------------------------------------------------------
DVSTA_UID NUMBER(6,0) No 1
DVSTA_NAME VARCHAR2(35 BYTE) No 2
Content:
1 Accepted
2 Deprecated
3 Rejected
Data Dictionary for BioData to WQX Data Sets at http://aquatic.biodata.usgs.gov
downloaded on: 20171219.1155
===================================
FILE: 20171219.1155.taxon
===================================
Taxonomy Domain Data Set Description
-------------------------------------------------------------
List of taxa in the BioData Taxonomy Domain. Fish and Invertebrate domains
contain all columns in the BioData system, and therefore columns are not
necessarily applicable for all communities (fish, invertebrates, algae).
The algae domain is a subset of relevant columns
Column Definitions
------------------
Column: TAX_UID
Description: The unique identifier for each registered taxon record in the WQX taxonomic systems.
Column: BenchTaxonName
Description: The taxon name assigned by a taxonomist in the lab (at the
"bench") or in the field. May be a conditional, provisional, or operational
name. Serves as root name for crosswalks to other taxonomic systems.
Column: BenchTaxonNameReferenceCode
Description: Code for the reference having the taxonomic description of
BenchName. In combination with BenchName it forms a composite logical key
that uniquely identifies a Taxon Concept.
Column: BioDataTaxonName
Description: Taxon according to BioData current taxonomic system
Column: BioDataCommonName
Description: Common or vernacular name of taxon
Column: PublishedTaxonName
Description: The "nearest" TaxonName that has been published following
International Commission of Zoological Nomenclature (ICZN) for inverts and
fish or International Code of Botanical Nomenclature (ICBN) for algae,
convention; authority is not included. Provisional names cannot be used in
this field.
Column: PublishedTaxonNameAuthority
Description: Taxonomic authority for HierarchyTaxonName
Column: ITIS_MatchCode
Description: How well the PublishedName corresponds to the ITIS name <
http://www.itis.gov > represented by the ITIS_TSN.
Column: BioDataTaxonName
Description: Taxon according to BioData current taxonomic system
Column: TAX_EXTRNL_ID
Description: Integrated Taxonomic Information System (ITIS) Taxonomic
Serial Number (TSN). A TSN is a unique, persistent, non-intelligent
identifier for a scientific name in the context of ITIS <
http://www.itis.gov >.
Column: ScientificName
Description: Complete name of the Taxon, with Authority.
Column: PublishedSortOrder
Description: Numeric code used to sort data according to taxonomic order
Column: BU_ID
Description: Identifier used in USGS National Water Quality Lab, Biological
Unit
Column: NADED_ID
Description: North American Diatom Ecological Database ID; master list of
names maintained by the Academy of Natural Sciences of Drexel University;
http://diatom.acnatsci.org/
Column: BioDataShortName
Description: Short, coded version of a TaxonName useful for column headers
in a table or when graphing
Column: TaxonGroup
Description: Taxon membership (algae only) in one of the following:
Blue-Green Algae; Brown Algae; Cryptophytes; Diatoms; Dinoflagellates;
Euglenoids; Green Algae; Red Algae; Unknown Phyla; Yellow-Green Algae; Red
Algae; Yellow-Green Algae; Green Algae; Blue-Green Algae; Unknown Phyla;
Euglenoids; Cryptophytes; Dinoflagellates
Column: TaxonConceptState
Description: Field that determines if a taxon concept (combination of
BenchTaxonName and BenchTaxonNameReferenceCode) will be accepted in data
upload
* Current: considered up-to-date and will be accepted in data
* Deprecated: accepted in data but may be rejected in the near future,
and may be reported under a different name in data retrievals
* Retired: retired from use and will be rejected if used for incoming
data
Column: TAXON_ALIAS_DESCRIPTION
Description: Appended Columns as follows separated by demiliter pipe "|"
|
Column: BiologicalCommunity
Description: Taxon membership in one of the following: Fish, Invertebrate,
Algae
|
Column: BioDataTaxonProvisional
Description: Indicates if taxon conforms to ICZN or ICBN standards (yes,
no)
|
Column: BioDataTaxonHybrid
Description: "Yes" indicates taxon is a hybrid
|
Column: BenchTaxonProvisional
Description: Indicates if taxon conforms to ICZN or ICBN standards (yes,
no) Column: BenchTaxonHybrid
Description: "Yes" indicates taxon is a hybrid
|
Column: PublishedTaxonLevel
Description: The taxonomic rank of the HierarchyTaxonName (e.g. Phylum,
Class, Order, Genus, etc.)
|
Column: TaxonVersionNumber
Description: Version of the taxonomic system represented in the retrieval
dataset. BioData maintains separate Taxonomic Systems for each community
(fish, invertebrate, algae) to manage taxonomic data.
Column: PublishedTaxonLevel
Description: Taxon Rank Foreign Key DECODE List as follows: The taxonomic rank of the HierarchyTaxonName (e.g. Phylum,
Class, Order, Genus, etc.)
10 Kingdom 190 Suborder 370 Subform
20 Subkingdom 200 Infraorder 380 Race
30 Infrakingdom 210 SectionA 390 Stirp
40 Superphylum 220 SubsectionA 400 Morph
50 Phylum 230 Superfamily 410 Aberration
60 Subphylum 240 Family
70 Infraphylum 250 Subfamily
80 Superdivision 260 Tribe
90 Division 270 Subtribe
100 Subdivision 280 Genus
110 Infradivision 290 Subgenus
120 Parvdivision 300 Section
130 Superclass 310 Subsection
140 Class 320 Species
150 Subclass 330 Subspecies
160 Infraclass 340 Variety
170 Superorder 350 Subvariety
180 Order 360 Form
Column: TAX_NAME
Description: Taxon according to WQX current taxonomic system
Column: TAX_EXTRNL_ID
Description: Integrated Taxonomic Information System (ITIS) Taxonomic
Serial Number (TSN). A TSN is a unique, persistent, non-intelligent
identifier for a scientific name in the context of ITIS <
http://www.itis.gov >.
Column: TAX_EXTRNL_ID_PARENT
Description: Integrated Taxonomic Information System (ITIS) PARENT Taxonomic
Serial Number (PARENT_TSN). A PARENT_TSN is a unique, persistent, non-intelligent
identifier for a scientific name in the context of ITIS <
http://www.itis.gov >.
Column: TAXON.TAX_UID_KINGDOM,
Description: Taxon Kingdom Foreign Key
1 Bacteria
2 Protozoa
3 Plantae
4 Fungi
5 Animalia
6 Chromista
Column: TAXON.TAX_STORET_ID,
Description: The ID for this taxon in the Modernized STORET System (which was replaced by WQX)
Column: TAXON.TAX_SRS_ID,
Description: The ID for this taxon in the Substance Registry System (SRS)
Column: TAXON.TAX_LAST_CHANGE_DATE,
Description: The date of the last change to data in this row
Column: TAXON.TAX_DESCRIPTION,
Description: The description for this taxon or the URL for it in the Integrated Taxonomic Information System (ITIS)
Column: TAXON.USR_UID_LAST_CHANGE,
Description: The Unique ID for the user responsible for the last change to data in this row
Column: Phylum
Description: Taxonomic Phylum name
Column: Subphylum
Description: Taxonomic subphylum name
Column: Superclass
Description: Taxonomic Class
Column: Class
Description: Taxonomic Class
Column: Subclass
Description: Taxonomic subclass name
Column: Infraclass
Description: Taxonomic infraclass name
Column: Superorder
Description: Taxonomic Superorder name
Column: Order
Description: Taxonomic Order name
Column: Suborder
Description: Taxonomic suborder name
Column: Infraorder
Description: Taxonomic infraorder name
Column: Superfamily
Description: Taxonomic Superfamily name
Column: Family
Description: Taxonomic Family
Column: Subfamily
Description: Taxonomic subfamily name
Column: Tribe
Description: Taxonomic Tribe name
Column: Genus
Description: Taxonomic Genus name
Column: Subgenus
Description: Taxonomic genus name
Column: Species
Description: Taxonomic species name
Column: Subspecies
Description: Taxonomic subspecies name
Column: Variety
Description: Taxonomic variety name
Column: Form
Description: Taxonomic form name