GUS Schema >> SRes::Anatomy

Stores anatomy terms in a hierarchical manner through the use of the parent_id, which refers to a row in the same table that is one level closer to the root of the tree

column nulls? type description
ANATOMY_ID no NUMBER(4,0) Primary key Edit
NAME no STRING(80) Anatomy term as determined by the source. Most commonly an organ, tissue, or cell type. Edit
HIER_LEVEL NUMBER(3,0) The number of steps from a root node of the anatomy tree. For example, "1" indicates that a row is a root node. "2" is a child of a root node. The parent of a row with hier_level of 2 has a hier_level of 1 Edit
PARENT_ID SRes::Anatomy (NUMBER(4,0) )The primary key of a row in the same table that is one hier_level closer to 1. This attribute is key for the hierarchical structure of this table as it allows for distinguishing parent-child relationships between anatomy entries. The parent_id of a root node is 0 for organism Edit
SOURCE STRING(20) Source of the anatomy term. Sources from which terms were drawn include: GXD (Jackson Labs Mouse Gene Expression Database), GRAYS (Gray's Anatomy, 37th edtition), STEDMAN (Stedman's Medical Dictionary, 24th edition), CBIL (Computational Biology and Informatics Laboratory, UPENN), NISSANOV (Dr. Jonathan Nissanov, Drexel University) Edit
DESCRIPTION STRING(255) An optional description of the anatomy term. Edit
LEVEL_1 STRING(80) Each level up to the hier_level of an entry contains the name attribute of that level of the hierarchy. For example, lymphatic vessel has a hier_level of 3, level_1 = organ system, level_2 = cardiovascular system, level_3 = lymphatic vessel. Edit
LEVEL_2 STRING(80) Edit
LEVEL_3 STRING(80) Edit
LEVEL_4 STRING(80) Edit
LEVEL_5 STRING(80) Edit
LEVEL_6 STRING(80) Edit
LEVEL_7 STRING(80) Edit
LEVEL_8 STRING(80) Edit
LEVEL_9 STRING(80) Edit
LEVEL_10 STRING(80) Edit
LEVEL_11 STRING(80) Edit
LEVEL_12 STRING(80) Edit
LEVEL_13 STRING(80) Edit
LEVEL_14 STRING(80) 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:

Assembly
     DoTS::AssemblyAnatomyPercent
Central Dogma
     DoTS::RNAAnatomy
Clones
     DoTS::AnatomyLibrary
     DoTS::Library
Interaction
     DoTS::ComplexAnatomy
Regulatory Activities
     TESS::ActivityConditions
Anatomy Vocabulary
     SRes::Anatomy
     SRes::AnatomyLineage
     DoTS::IsExpressed
Phenotype Vocabulary
     SRes::Phenotype
Uncategorized
     SRes::AnatomySAEL

Subclasses: