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 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 |
|