GUS Schema >> SRes::Taxon

Holds information from the NCBI Taxonomy.

column nulls? type description
TAXON_ID no NUMBER(10,0) Primary key. Edit
NCBI_TAX_ID NUMBER(10,0) Primary taxon identifier used by NCBI. Edit
PARENT_ID SRes::Taxon (NUMBER(10,0) )Pointer to SRes.Taxon. Edit
RANK no STRING(255) Scientific classification category e.g.species, genus, kindom, etc. Edit
GENETIC_CODE_ID SRes::GeneticCode (NUMBER(10,0) )Foreign key to SRes.GeneticCode Edit
MITOCHONDRIAL_GENETIC_CODE_ID SRes::GeneticCode (NUMBER(10,0) )Foreign key to SRes.GeneticCode, refers to mitochondrial genome Edit
MODIFICATION_DATE no DATE Edit
USER_READ no NUMBER(1,0) Edit
USER_WRITE no NUMBER(1,0) Edit
GROUP_READ no NUMBER(1,0) Edit
GROUP_WRITE no NUMBER(1,0) Edit
OTHER_READ no NUMBER(1,0) Edit
OTHER_WRITE no NUMBER(1,0) Edit
ROW_USER_ID no NUMBER(12,0) Edit
ROW_GROUP_ID no NUMBER(4,0) Edit
ROW_PROJECT_ID no NUMBER(4,0) Edit
ROW_ALG_INVOCATION_ID no NUMBER(12,0) Edit

Child tables:

NA Sequence
     DoTS::NASequence
AA Sequence
     DoTS::AASequence
     DoTS::NRDBEntry
GenBank Sequence Record
     DoTS::AASequenceTaxon
Similarity
     DoTS::BLATAlignment
Assembly
     DoTS::AssemblyAnatomyPercent
Mapping
     DoTS::EndSequencePairMap
     DoTS::MicroSatelliteMap
     DoTS::RHMap
     DoTS::RHMarker
Clones
     DoTS::Library
Variation
     DoTS::Complementation
Regulatory Moieties
     TESS::Moiety
Regulatory Activities
     TESS::ActivityConditions
Taxon Vocabulary
     SRes::Taxon
     SRes::TaxonName
Developmental Stage Vocabulary
     SRes::DevelopmentalStage
Uncategorized
     Study::BioMaterial
     DoTS::OpticalMap
     DoTS::PhylogeneticProfileMember

Subclasses: