Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mld_fish
Defines FISH (Fluorescence In Situ Hybridization) Experiment. FISH Experiments use fluorescein tags to detect the hybridization of probes with metaphase chromosomes. This suggests the chromosome and band assignment of the marker to which the probe hybrdizes.

Master of MLD_FISH_Region.

 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_expt_marker_view._expt_key Implied Constraint R
mld_expt_view._expt_key Implied Constraint R
mld_expts._expt_key mld_fish__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_fish__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
label text 2147483647  √  null type of fluorescence on probe
nummetaphase int4 10  √  null # of metaphase spreads analyzed in experiment
totalsingle int4 10  √  null # of single flourescent signals indicating presence of marker
totaldouble int4 10  √  null # of double fluorescent signals indicating presence of marker
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 1,429 rows at Mon Sep 11 06:12 EDT 2023

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

Close relationships  within of separation: