Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mld_insitu
Defines IN SITU Experiment. In Situ Experiments use a DNA or RNA probe to detect the presence of the complementary DNA sequence in cloned bacterial or cultured eukaryotic cells. This suggests the chromosome and band assignment of the marker to which the probe hybridizes.

Master of MLD_ISRegion.

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_insitu__expt_key_fkey C
foreign key to MLD_Expts
band text 2147483647  √  null cytogenetic position on chromosome to which marker is assigned
_strain_key int4 10
prb_strain._strain_key mld_insitu__strain_key_fkey R
foreign key to PRB_Strain
cellorigin text 2147483647  √  null cell type from which analyzed metaphase spreads were derived
karyotype text 2147483647  √  null method used to identify chromosome bands
robertsonians text 2147483647  √  null chromosomal aberration used to identify marker assignment
nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
totalgrains int4 10  √  null # of grains observed in experiment
grainsonchrom int4 10  √  null # of grains hybridizing to correct chromosomal location
grainsotherchrom int4 10  √  null # of grains hybridizing to other chromosomal locations
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 449 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_expt_key Primary key, Used to cluster data Asc mld_insitu_pkey
_strain_key Performance Asc mld_insitu_idx_strain_key

Close relationships  within of separation: