Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_expression
A cache table of redundant Assay results whose purpose is to make the most common kinds of queries more efficient. Primarily used by the Web interface. Loaded by a stored procedure which is executed from the GXD_Assay insert/update triggers.

See GXD_Assay.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_expression_key int4 10 primary key
_assay_key int4 10
gxd_assay
foreign key to GXD_Assay
_refs_key int4 10
bib_refs
foreign key to BIB_Refs
_assaytype_key int4 10
gxd_assaytype
foreign key to GXD_AssayType
_genotype_key int4 10
gxd_genotype
foreign key to GXD_Genotype
_marker_key int4 10
mrk_marker
foreign key to MRK_Marker
_emapa_term_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 90 (EMAPA)
_celltype_term_key int4 10  √  null
voc_term
foreign key to VOC_Term where _Vocab_key = 102 (Cell Ontology)
_stage_key int4 10
gxd_theilerstage
foreign key to GXD_TheilerStage
_specimen_key int4 10  √  null
gxd_specimen
foreign key to GXD_Specimen
_gellane_key int4 10  √  null
gxd_gellane
foreign key to GXD_GelLane
resultnote text 2147483647  √  null result notes
expressed int2 5 is Marker expressed in Structure? yes (1), no (0)
strength text 2147483647  √  null strength
age text 2147483647 age of anatomical structure
agemin numeric 131089  √  null minimum age value determined by age field
agemax numeric 131089  √  null maximum age value determined by age field
isrecombinase int2 5 if 1 (true), then this Assay has a Recombinase Reporter Gene (VOC_Term._Vocab_key = 14)
isforgxd int2 5 if 1 (true), then this Assay will appear in GXD counts and queries (in front-end)
hasimage int2 5 if 1 (true), the this Assay contains an Image
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 2,000,464 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_expression_key Primary key, Used to cluster data Asc
_assay_key Performance Asc
_assaytype_key Performance Asc
_celltype_term_key Performance Asc
_marker_key + _emapa_term_key + _stage_key + isforgxd Performance Asc/Asc/Asc/Asc
_emapa_term_key + _stage_key + _expression_key + isforgxd Performance Asc/Asc/Asc/Asc
_emapa_term_key Performance Asc
_gellane_key Performance Asc
_genotype_key Performance Asc
_genotype_key + isforgxd Performance Asc/Asc
_marker_key Performance Asc
_refs_key + _emapa_term_key + _stage_key + isforgxd Performance Asc/Asc/Asc/Asc
_refs_key Performance Asc
_specimen_key Performance Asc
_stage_key Performance Asc

Close relationships  within of separation: