| 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 |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 164,273 rows at Tue Feb 17 06:11 EST 2026 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
|



