Schema for omimGeneMap
  Database: hg18    Primary Table: omimGeneMap    Row Count: 18,715   Data last updated: 2025-04-30
Format description: This table contains the same data as the genemap file downloaded from OMIM
On download server: MariaDB table dump directory
fieldexampleSQL type info description
numbering 1.1varchar(10) values Numbering system, in the format Chromosome.Map_Entry_Number
month 5int(11) range Month entered
day 13int(11) range Day entered
year 13int(11) range Year entered
location 1pter-p36.13varchar(40) values Location
geneSymbol CTRCT8, CCVvarchar(255) values Gene Symbol(s)
geneStatus  char(1) values Gene Status
title1 Cataract, congenital, Volkm...blob values Title line1
title2  blob values Title line 2
omimId 115665int(11) range MIM Number
method  blob values Method
comment1 linked to Rh in Scottish fa...blob values Comments line 1
comment2  blob values Comments line 2
disorders1 Cataract 8, multiple types (2)blob values Disorders line 1
disorders2  blob values Disorders line 2
disorders3  blob values Disorders line 3
mouseCorrelate  blob values Mouse correlate
reference  blob values Reference

Connected Tables and Joining Fields
        hg18.kgXref.geneSymbol (via omimGeneMap.geneSymbol)
      hg18.omimGeneMap2.geneSymbol (via omimGeneMap.geneSymbol)
      hgFixed.ggGeneClass.gene (via omimGeneMap.geneSymbol)
      hgFixed.ggGeneName.gene (via omimGeneMap.geneSymbol)
      hgFixed.ggLink.gene1 (via omimGeneMap.geneSymbol)
      hgFixed.ggLink.gene2 (via omimGeneMap.geneSymbol)
      hg18.omim2gene.omimId (via omimGeneMap.omimId)
      hg18.omimGene2.name (via omimGeneMap.omimId)
      hg18.omimGeneMap2.omimId (via omimGeneMap.omimId)
      hg18.omimLocation.name (via omimGeneMap.omimId)
      hg18.omimPhenotype.omimId (via omimGeneMap.omimId)
      hgFixed.refLink.omimId (via omimGeneMap.omimId)

Sample Rows
 
numberingmonthdayyearlocationgeneSymbolgeneStatustitle1title2omimIdmethodcomment1comment2disorders1disorders2disorders3mouseCorrelatereference
1.1513131pter-p36.13CTRCT8, CCVCataract, congenital, Volkmann type115665linked to Rh in Scottish familyCataract 8, multiple types (2)
1.21222871pter-p36ERPL1, HLM2Endogenous retroviral pol gene-like sequence 1 (oncogene HLM2)131190
1.3414111p36.11HMGCL3-hydroxy-3-methylglutaryl-Coenzyme A lyase613898HMG-CoA lyase deficiency, 246450 (3)4(Hmgcl)
1.4430151p36.33AGRN, CMS8Agrin103320Myasthenic syndrome, congenital, 8, with pre- and postsynaptic defects, 615120 (3)4(Agrn)
1.5113211p36.33GNB1, MRD42, MDSGuanine nucleotide-binding protein, beta polypeptide-1139380Intellectual developmental disorder, autosomal dominant 42, 616973 (3); Leukemia, acute lymphoblastic, somatic, 613065 (3); Myel ...4(Gnb1)
1.610271p35.2SDC3, SYND3, SDCNSyndecan 3186357{Obesity, association with}, 601665 (3)4(Synd3)
1.7828981pter-p22.1SAI1, MTS1, TFS1Suppression of anchorage independence-1 (malignant transformation suppression-1)1542804(Tfs1)
1.8527201p36.33ATAD3A, HAYOS, PHRINLATPase family, AAA domain-containing, member 3A612316Harel-Yoon syndrome, 617183 (3); Pontocerebellar hypoplasia, hypotonia, and respiratory insufficiency syndrome, neonatal lethal, ...4(Atad3)
1.910681p36.33ATAD3B, TOB3, KIAA1273ATPase family, AAA domain-containing, member 3B612317
1.101129161p36.33ATAD3CATPase family, AAA domain-containing, member 3C617227

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.