Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mld_concordance
Defines Concordance values for Hybrid Experiment. The Concordance table contains results for either Markers or Chromosomes. Concordance values are stored as integers which represent the number of Hybrid cells recording the presence/absence of a particular Marker/Chromosome in the Concordance table vs. the presence/absence of the Marker being tested for linkage: -/- (neither present), -/+ (linkage Marker present), +/- (Marker/Chromosome present), +/+ (both present).

Detail of MLD_Hybrid.

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
_expt_key int4 10
mld_expts._expt_key mld_concordance__expt_key_fkey C
foreign key to MLD_Expts
sequencenum int4 10 sequence number for ordering records
_marker_key int4 10  √  null
mrk_marker._marker_key mld_concordance__marker_key_fkey R
foreign key to MRK_Marker
chromosome text 2147483647  √  null chromosome value; is NULL if _Marker_key is not NULL
cpp int4 10 +/+; number of Hybrid cells where both the Concordance Marker/Chromosome and the linkage Marker are present
cpn int4 10 +/-; number of Hybrid cells where the Concordance Marker/Chromosome is present, but the linkage Marker is not present
cnp int4 10 -/+; number of Hybrid cells where the Concordance Marker/Chromosome is not present, but the linkage Marker is present
cnn int4 10 -/-; number of Hybrid cells where neither the Concordance Marker/Chromosome nor the linkage Marker is present
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 11,827 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_expt_key + sequencenum Primary key, Used to cluster data Asc/Asc mld_concordance_pkey
_marker_key Performance Asc mld_concordance_idx_marker_key

Close relationships  within of separation: