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
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
gxd_assaynote
gxd_expression
gxd_gellane
gxd_gelrow
gxd_specimen
primary key
_assaytype_key int4 10
gxd_assaytype
foreign key to GXD_AssayType
_refs_key int4 10
bib_refs
foreign key to BIB_Refs
_marker_key int4 10
mrk_marker
foreign key to MRK_Marker
_probeprep_key int4 10  √  null
gxd_probeprep
foreign key to GXD_ProbePrep
_antibodyprep_key int4 10  √  null
gxd_antibodyprep
foreign key to GXD_AntibodyPrep
_imagepane_key int4 10  √  null
img_imagepane
foreign key to IMG_ImagePane
_reportergene_key int4 10  √  null
voc_term
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 who created the record
_modifiedby_key int4 10 1001
mgi_user
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
_assay_key Primary key Asc
_antibodyprep_key Performance Asc
_assaytype_key Performance Asc
_marker_key Performance Asc
_createdby_key Performance Asc
creation_date Performance Asc
_imagepane_key Performance Asc
modification_date Performance Asc
_modifiedby_key Performance Asc
_probeprep_key Performance Asc
_refs_key Performance Asc
_reportergene_key Performance Asc

Close relationships  within of separation: