Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.mrk_marker
A record in this table represents a Marker (gene, dna segment, complex/cluster). Mouse Markers have MGI Accession IDs. Non-mouse Markers (human, rat, etc.) are also stored in this table.

 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
_marker_key serial 10  √  nextval('mrk_marker_seq'::regclass)
all_allele._marker_key all_allele__marker_key_fkey R
all_knockout_cache._marker_key all_knockout_cache__marker_key_fkey C
crs_matrix._marker_key crs_matrix__marker_key_fkey R
crs_references._marker_key crs_references__marker_key_fkey R
go_tracking._marker_key go_tracking__marker_key_fkey C
gxd_allelegenotype._marker_key gxd_allelegenotype__marker_key_fkey R
gxd_allelepair._marker_key gxd_allelepair__marker_key_fkey R
gxd_antibodymarker._marker_key gxd_antibodymarker__marker_key_fkey R
gxd_assay._marker_key gxd_assay__marker_key_fkey R
gxd_expression._marker_key gxd_expression__marker_key_fkey R
gxd_htsample_rnaseq._marker_key gxd_htsample_rnaseq__marker_key_fkey R
gxd_htsample_rnaseqcombined._marker_key gxd_htsample_rnaseqcombined__marker_key_fkey R
gxd_index._marker_key gxd_index__marker_key_fkey R
mld_concordance._marker_key mld_concordance__marker_key_fkey R
mld_expt_marker._marker_key mld_expt_marker__marker_key_fkey R
mld_mc2point._marker_key_1 mld_mc2point__marker_key_1_fkey R
mld_mc2point._marker_key_2 mld_mc2point__marker_key_2_fkey R
mld_ri2point._marker_key_1 mld_ri2point__marker_key_1_fkey R
mld_ri2point._marker_key_2 mld_ri2point__marker_key_2_fkey R
mld_ridata._marker_key mld_ridata__marker_key_fkey R
mld_statistics._marker_key_1 mld_statistics__marker_key_1_fkey R
mld_statistics._marker_key_2 mld_statistics__marker_key_2_fkey R
mrk_clustermember._marker_key mrk_clustermember__marker_key_fkey R
mrk_current._current_key mrk_current__current_key_fkey C
mrk_current._marker_key mrk_current__marker_key_fkey C
mrk_do_cache._marker_key mrk_do_cache__marker_key_fkey C
mrk_history._history_key mrk_history__history_key_fkey C
mrk_history._marker_key mrk_history__marker_key_fkey C
mrk_label._marker_key mrk_label__marker_key_fkey C
mrk_location_cache._marker_key mrk_location_cache__marker_key_fkey C
mrk_mcv_cache._marker_key mrk_mcv_cache__marker_key_fkey C
mrk_notes._marker_key mrk_notes__marker_key_fkey C
mrk_reference._marker_key mrk_reference__marker_key_fkey C
mrk_strainmarker._marker_key mrk_strainmarker__marker_key_fkey C
prb_marker._marker_key prb_marker__marker_key_fkey R
prb_rflv._marker_key prb_rflv__marker_key_fkey R
prb_strain_marker._marker_key prb_strain_marker__marker_key_fkey R
ri_summary._marker_key ri_summary__marker_key_fkey R
seq_marker_cache._marker_key seq_marker_cache__marker_key_fkey C
voc_marker_cache._marker_key voc_marker_cache__marker_key_fkey C
wks_rosetta._marker_key wks_rosetta__marker_key_fkey R
primary key
_organism_key int4 10
mgi_organism._organism_key mrk_marker__organism_key_fkey R
foreign key to MGI_Organism
_marker_status_key int4 10
mrk_status._marker_status_key mrk_marker__marker_status_key_fkey R
foreign key to MRK_Status
_marker_type_key int4 10
mrk_types._marker_type_key mrk_marker__marker_type_key_fkey R
foreign key to MRK_Types
symbol text 2147483647 official symbol of marker
name text 2147483647 official name of marker
chromosome text 2147483647 chromosome
cytogeneticoffset text 2147483647  √  null cytogenetic band
cmoffset float8 17,17  √  null approximate centimorgan (cM) position on chromosome
_createdby_key int4 10 1001
mgi_user._user_key mrk_marker__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key mrk_marker__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

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

Indexes:
Column(s) Type Sort Constraint Name
_marker_key Primary key Asc mrk_marker_pkey
_marker_key + _organism_key Must be unique Asc/Asc mrk_marker_idx_marker_key
chromosome Performance Asc mrk_marker_idx_clustered
_createdby_key Performance Asc mrk_marker_idx_createdby_key
creation_date Performance Asc mrk_marker_idx_creation_date
_marker_status_key Performance Asc mrk_marker_idx_marker_status_key
_marker_type_key + _marker_key Performance Asc/Asc mrk_marker_idx_marker_type_key
modification_date Performance Asc mrk_marker_idx_modification_date
_modifiedby_key Performance Asc mrk_marker_idx_modifiedby_key
_organism_key Performance Asc mrk_marker_idx_organism_key
symbol Performance Asc mrk_marker_idx_symbol

Close relationships  within of separation: