Schema for omimGeneMap
  Database: hg38    Primary Table: omimGeneMap    Row Count: 18,440   Data last updated: 2024-04-17
Format description: This table contains the same data as the genemap file downloaded from OMIM
Note: genome-wide queries are not available for this table.
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
        hg38.kgXref.geneSymbol (via omimGeneMap.geneSymbol)
      hg38.omimGeneMap2.geneSymbol (via omimGeneMap.geneSymbol) Note: genome-wide queries are not available for this table.
      hgFixed.ggGeneClass.gene (via omimGeneMap.geneSymbol)
      hgFixed.ggGeneName.gene (via omimGeneMap.geneSymbol)
      hgFixed.ggLink.gene1 (via omimGeneMap.geneSymbol)
      hgFixed.ggLink.gene2 (via omimGeneMap.geneSymbol)
      hg38.omim2gene.omimId (via omimGeneMap.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGene2.name (via omimGeneMap.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGeneMap2.omimId (via omimGeneMap.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimLocation.name (via omimGeneMap.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimPhenotype.omimId (via omimGeneMap.omimId) Note: genome-wide queries are not available for this table.
      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.