Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mld_statistics
Defines Statistics generated from Haplotype and 2 Point data. Generated automatically based on Experiment Type (CROSS or RI) and Cross Type (if Experiment is a CROSS).

See MLD_Expts.

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_statistics__expt_key_fkey C
foreign key to MLD_Expts
sequencenum int4 10 sequence number for ordering records
_marker_key_1 int4 10
mrk_marker._marker_key mld_statistics__marker_key_1_fkey R
foreign key to MRK_Marker
_marker_key_2 int4 10
mrk_marker._marker_key mld_statistics__marker_key_2_fkey R
foreign key to MRK_Marker
recomb int4 10 number of mice which recombined for Marker pair
total int4 10 total number of mice typed for Marker pair
pcntrecomb numeric 131089 percentage of recombination per number of mice
stderr numeric 131089 standard error of the recombination percentage
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 27,147 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_statistics_pkey
_marker_key_1 Performance Asc mld_statistics_idx_marker_key_1
_marker_key_2 Performance Asc mld_statistics_idx_marker_key_2

Close relationships  within of separation: