GUS Schema >> DoTS::AssemblyAnatomyPercent

Materialized view that maps Assemblies to the Anatomy ontology based on source library of the contained sequences

column nulls? type description
ASSEMBLY_ANATOMY_PERCENT_ID no NUMBER(10,0) primary key Edit
NA_SEQUENCE_ID no DoTS::NASequence (NUMBER(10,0) )FK to the Assembly Edit
TAXON_ID SRes::Taxon (NUMBER(12,0) ) Edit
ANATOMY_ID no SRes::Anatomy (NUMBER(4,0) )FK to the Anatomy table Edit
PERCENT no FLOATPercent of informative AssemblySequences that come from this anatomy Edit
ANATOMY_ESTS no NUMBER(5,0) Edit
EST_COUNT no NUMBER(5,0) number of informative sequences (have a library anatomy assignment) in this assembly 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:

Subclasses: