Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.gxd_gellane
Defines a Gel Lane. A Gel Assay is represented as a 2-D matrix with some number of columns (GXD_GelLane) and some number of rows (GXD_GelRow, GXD_GelBand). Lanes have sequence numbers for ordering and labels to describe lane content. The information associated with a Gel Lane corresponds to the way the gel was prepared in the lab. Source material is derived from one or more tissues in an animal. Tissues are described through reference to the anatomical dictionary. Animals are described via their genotype, age and sex. Minimal information is recorded for control lanes.

See GXD_Assay, GXD_Genotype, GXD_GelLaneStructure, GXD_GelRNAType.

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
_gellane_key int4 10
gxd_expression._gellane_key gxd_expression__gellane_key_fkey C
gxd_gelband._gellane_key gxd_gelband__gellane_key_fkey C
gxd_gelband_view._gellane_key Implied Constraint R
gxd_gellane_view._gellane_key Implied Constraint R
gxd_gellanestructure._gellane_key gxd_gellanestructure__gellane_key_fkey C
gxd_gellanestructure_view._gellane_key Implied Constraint R
primary key
_assay_key int4 10
gxd_assay._assay_key gxd_gellane__assay_key_fkey C
foreign key to GXD_Assay
_genotype_key int4 10
gxd_genotype._genotype_key gxd_gellane__genotype_key_fkey R
foreign key to GXD_Genotype
_gelrnatype_key int4 10
gxd_gelrnatype._gelrnatype_key gxd_gellane__gelrnatype_key_fkey R
foreign key to GXD_GelRNAType
_gelcontrol_key int4 10
gxd_gelcontrol._gelcontrol_key gxd_gellane__gelcontrol_key_fkey R
foreign key to GXD_GelControl
sequencenum int4 10 sequence number for ordering records
lanelabel text 2147483647  √  null lane label to describe lane contents
sampleamount text 2147483647  √  null amount of source material for RNA gels
sex text 2147483647 sex of animal (Female, Male, Pooled)
age text 2147483647 age of animal
agemin numeric 131089  √  null minimum age range determined by age field; system calculated
agemax numeric 131089  √  null maximum age range determined by age field; system calculated
agenote text 2147483647  √  null age notes
lanenote text 2147483647  √  null notes for entire lane
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 249,556 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_gellane_key Primary key, Used to cluster data Asc gxd_gellane_pkey
_assay_key Performance Asc gxd_gellane_idx_clustered
_gelcontrol_key Performance Asc gxd_gellane_idx_gelcontrol_key
_gelrnatype_key Performance Asc gxd_gellane_idx_gelrnatype_key
_genotype_key Performance Asc gxd_gellane_idx_genotype_key

Close relationships  within of separation: