Table cxgn.phenome.genotype_region

polymorphic regions from a genotype, delineated by markers in a certain linkage group on a certain map

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
genotype_region_id serial 10  √  nextval('genotype_region_genotype_region_id_seq'::regclass)
genotype_id int4 10  √  null
genotype.genotype_id genotype_region_genotype_id_fkey
optional genotype this region belongs to.  some regions are artificial, arising from combinations of other regions, and thus do not have an associated genotype
marker_id_nn int8 19  √  null the north marker in the pair of markers bracketing the north end of this region. this may be null for regions at the north end of a linkage group
marker_id_ns int8 19 the south marker in the pair of markers bracketing the north end of this region
marker_id_sn int8 19 the north marker in the pair of markers bracketing the south end of this region
marker_id_ss int8 19  √  null the south marker in the pair of markers bracketing the south end of this region. this may be null for regions at the south end of a linkage group.
zygocity_code varchar 1  √  null
lg_id int4 10  √  null the linkage group in a specific version of a specific map where this region is located
type varchar 32 the type of polymorphic region this is.  map is mapping experiment data, inbred is IL lines segments, and bin is a derived region based on a boolean combination of inbred fragments.  For bin regions, the specific boolean combination of fragments that make the bin is not stored.
name varchar 32  √  null special name for this region, if any.  optional
sp_person_id int4 10  √  null the person who loaded this datum.  optional
modified_date timestamptz 35,6 now()
create_date timestamptz 35,6 now()
obsolete bool 1 false

Table contained 79,717 rows at Wed May 20 01:35 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
genotype_region_id Primary key Asc genotype_region_pkey
marker_id_nn Performance Asc phenome_genotype_marker_id_nn_idx
marker_id_ns Performance Asc phenome_genotype_marker_id_ns_idx
marker_id_sn Performance Asc phenome_genotype_marker_id_sn_idx
marker_id_ss Performance Asc phenome_genotype_marker_id_ss_idx
genotype_id Performance Asc phenome_genotype_region_genotype_id_idx
name Performance Asc phenome_genotype_region_name
Performance phenome_genotype_region_type
zygocity_code Performance Asc phenome_genotype_region_zygocity_code

Close relationships  within one two degrees of separation :