GUS Schema >> DoTS::Library

Stores clone library information

column nulls? type description
LIBRARY_ID no NUMBER(5,0) Primary key column Edit
TAXON_ID no SRes::Taxon (NUMBER(12,0) )FK to Taxon (Parsed from dbEST.LIBRARY.organism) Edit
ANATOMY_ID SRes::Anatomy (NUMBER(4,0) )FK to Anatomy (Parsed from dbEST.LIBRARY.organ) Edit
DBEST_ID NUMBER(12,0) The dbEST library id (dbEST.LIBRARY.id_lib) Edit
DBEST_NAME STRING(120) The name according to dbEST (dbEST.LIBRARY.name) Edit
IS_IMAGE no NUMBER(1,0) Whether this is an IMAGE library Edit
IMAGE_ID NUMBER(12,0) The IMAGE Consortium library id Edit
GDB_ID NUMBER(12,0) GDB library id Edit
GDB_NAME STRING(100) The name according to GDB Edit
LLNL_NAME STRING(100) The name according to LLNL Edit
WASHU_NAME STRING(100) The name according to WashU Edit
TISSUE_TYPE STRING(156) The tissue type of the library (dbEST.LIBRARY.tissue_type) Edit
STRAIN STRING(156) Organism strain (dbEST.LIBRARY.strain) Edit
CULTIVAR STRING(156) Plant cultivar (dbEST.LIBRARY.cultivar) Edit
STAGE STRING(100) Developmental stage (dbEST.LIBRARY.stage) Edit
SEX CHARACTER(1) Sex of organism (female, male, hermaphrodite) (parsed from dbEST.LIBRARY.sex) (values are currently = [S,-,?,B,M,F,n]) Edit
CELL_TYPE STRING(156) Cell type (dbEST.LIBRARY.cell_type) Edit
CELL_LINE STRING(156) Name of cell line (dbEST.LIBRARY.cell_line) Edit
NORMALIZED CHARACTER(1) Whether the library was normalized Edit
VECTOR STRING(156) Name of the vector (dbEST.LIBRARY.vector) Edit
VECTOR_TYPE STRING(64) Type of the vector (dbEST.LIBRARY.v_type) Edit
HOST STRING(80) Name of the host Edit
RE_1 STRING(35) Restriction enzyme at site1 of vector (dbEST.LIBRARY.re_1) Edit
RE_2 STRING(35) Restriction enzyme at site2 of vector (dbEST.LIBRARY.re_2) Edit
COMMENT_STRING CLOB Edit
DBEST_ORGANISM STRING(300) We store dbEST.LIBRARY.organism for debugging Edit
DBEST_ORGAN STRING(300) We store dbEST.LIBRARY.organ for debugging 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:

Clones
     DoTS::Clone
     DoTS::DevStageLibrary
     DoTS::EST

Subclasses: