GUS Schema >> DoTS::Gene

A central dogma (GENE->RNA->PROTEIN) table containing gene information for the genes in GUS

column nulls? type description
GENE_ID no NUMBER(10,0) primary key Edit
NAME STRING(255) The HUGO approved full gene name for human genes or the MGI approved full gene name for mouse genes Edit
GENE_SYMBOL STRING(50) "The HUGO or MGI approved abbreviated gene name or symbol (e.g., Kit)" Edit
GENE_CATEGORY_ID DoTS::GeneCategory (NUMBER(10,0) )The identifier of a gene category that has been assigned to the gene Edit
REVIEW_STATUS_ID SRes::ReviewStatus (NUMBER(12,0) )The identifier of the review status that has been assigned to the gene Edit
DESCRIPTION STRING(500) A description of the gene Edit
REVIEWER_SUMMARY STRING(4000) Annotator comments regarding the gene Edit
SEQUENCE_ONTOLOGY_ID SRes::SequenceOntology (NUMBER(10,0) ) 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:

Central Dogma
     DoTS::GeneChromosomalLocation
     DoTS::GeneInstance
     DoTS::GeneSynonym
     DoTS::RNA
Variation
     DoTS::Allele
Uncategorized
     DoTS::FamilyGene
     DoTS::GeneFamilyRelation

Subclasses: