Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_assay
A record in this table represents the high level definition of a Gene Expression experiment; the type of Assay, the Reference, the Marker of interest, the Probe used to detect the Marker or Reporter Gene, the Antibody used to detect the Marker or Reporter Gene, the Reporter Gene, and the Image Pane. A Reporter Gene is a benign gene which is knocked-in to report the expression of the mouse gene. It is only applicable when Assay Type is "In situ reporter (knock in)", "In situ reporter (transgenic)" and "Recombinase reporter". These three assay types may use a nucleotide probe (has a Probe Prep), an antibody (has an Antibody Prep) or direct detection (has neither a Probe Prep nor an Antibody prep). Not all records in this table are in the GXD_Expression table. Assay Type "In situ reporter (transgenic)" assays are excluded because they do not examine the expression of endogenous genes. Assay Type "Recombinase reporter" assays are excluded because they do not examine gene expression. See GXD_Specimen, GXD_GelLane.

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_assay_key serial 10  √  nextval('gxd_assay_seq'::regclass)
all_cre_cache._assay_key all_cre_cache__assay_key_fkey C
gxd_assaynote._assay_key gxd_assaynote__assay_key_fkey C
gxd_expression._assay_key gxd_expression__assay_key_fkey C
gxd_gellane._assay_key gxd_gellane__assay_key_fkey C
gxd_gelrow._assay_key gxd_gelrow__assay_key_fkey C
gxd_specimen._assay_key gxd_specimen__assay_key_fkey C
primary key
_assaytype_key int4 10
gxd_assaytype._assaytype_key gxd_assay__assaytype_key_fkey R
foreign key to GXD_AssayType
_refs_key int4 10
bib_refs._refs_key gxd_assay__refs_key_fkey R
foreign key to BIB_Refs
_marker_key int4 10
mrk_marker._marker_key gxd_assay__marker_key_fkey R
foreign key to MRK_Marker
_probeprep_key int4 10  √  null
gxd_probeprep._probeprep_key gxd_assay__probeprep_key_fkey R
foreign key to GXD_ProbePrep
_antibodyprep_key int4 10  √  null
gxd_antibodyprep._antibodyprep_key gxd_assay__antibodyprep_key_fkey R
foreign key to GXD_AntibodyPrep
_imagepane_key int4 10  √  null
img_imagepane._imagepane_key gxd_assay__imagepane_key_fkey R
foreign key to IMG_ImagePane
_reportergene_key int4 10  √  null
voc_term._term_key gxd_assay__reportergene_key_fkey R
foreign key to VOC_Term where _Vocab_key = 14 (GXD Reporter Gene); 'hemagglutinin', 'lacZ', 'GFP', 'Cre', 'FLP', etc.
_createdby_key int4 10 1001
mgi_user._user_key gxd_assay__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key gxd_assay__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 132,158 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_assay_key Primary key Asc gxd_assay_pkey
_antibodyprep_key Performance Asc gxd_assay_idx_antibodyprep_key
_assaytype_key Performance Asc gxd_assay_idx_assaytype_key
_marker_key Performance Asc gxd_assay_idx_clustered
_createdby_key Performance Asc gxd_assay_idx_createdby_key
creation_date Performance Asc gxd_assay_idx_creation_date
_imagepane_key Performance Asc gxd_assay_idx_imagepane_key
modification_date Performance Asc gxd_assay_idx_modification_date
_modifiedby_key Performance Asc gxd_assay_idx_modifiedby_key
_probeprep_key Performance Asc gxd_assay_idx_probeprep_key
_refs_key Performance Asc gxd_assay_idx_refs_key
_reportergene_key Performance Asc gxd_assay_idx_reportergene_key

Close relationships  within of separation: