Schema for omimGeneMap2
  Database: hg18    Primary Table: omimGeneMap2    Row Count: 18,715   Data last updated: 2025-04-30
Format description: This table contains the same data as the genemap2.txt file downloaded from OMIM
On download server: MariaDB table dump directory
fieldexampleSQL type info description
location 1p36varchar(255) values Cyto Location
compCtyoLoc  varchar(255) values Computed Cyto Location
omimId 612367int(11) range Mim Number
geneSymbol ALPQTL2varchar(255) values Gene Symbol(s)
geneName Alkaline phosphatase, plasm...longblob   Gene Name
approvedSymbol  varchar(255) values Approved Symbol
entrez 100196914varchar(255) values Entrez Gene ID
ensGeneId  varchar(255) values Ensembl Gene ID
comments linkage with rs1780324longblob   Comments
phenotypes {Alkaline phosphatase, plas...longblob   Phenotypes
mmGeneId  longblob   Mouse Gene Symbol/ID

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

Sample Rows
 
locationcompCtyoLocomimIdgeneSymbolgeneNameapprovedSymbolentrezensGeneIdcommentsphenotypesmmGeneId
1p36612367ALPQTL2Alkaline phosphatase, plasma level of, QTL 2100196914linkage with rs1780324{Alkaline phosphatase, plasma level of, QTL 2}, 612367 (2)
1p606788ANON1Anorexia nervosa, susceptibility to, 1171514{Anorexia nervosa, susceptibility to, 1}, 606788 (2)
1p36605462BCC1Basal cell carcinoma, susceptibility to, 1100307118associated with rs7538876{Basal cell carcinoma, susceptibility to, 1}, 605462 (2)
1p36606928BMND3Bone mineral density QTL 3246259?another locus at 3p21[Bone mineral density QTL 3], 606928 (2)
1p36.33618815C1DUPp36.33, DUP1p36.33Chromosome 1p36.33 duplication syndrome, ATAD3 gene clusterChromosome 1p36.33 duplication syndrome, ATAD3 gene cluster, 618815 (4), Autosomal dominant
1p36155600CMM, MLM, DNSCutaneous malignant melanoma/dysplastic nevus1243some linkage studies negative; see 9p{Melanoma, cutaneous malignant, 1}, 155600 (2), Autosomal dominant
1pter-p36.13115665CTRCT8, CCVCataract, congenital, Volkmann type7792linked to Rh in Scottish familyCataract 8, multiple types, 115665 (2), Autosomal dominant
1p36607872DEL1p36, C1DELp36Chromosome 1p36 deletion syndrome, distalcontiguous gene deletion syndromeChromosome 1p36 deletion syndrome, distal, 607872 (4), Isolated cases
1p36619343DEL1p36, C1DELp36Chromosome 1p36 deletion syndrome, proximalChromosome 1p36 deletion syndrome, proximal, 619343 (4), Autosomal dominant
1p36-p34608995DYX8Dyslexia, susceptibility to, 8406874between D1S552 and D1S1622{Dyslexia, susceptibility to, 8}, 608995 (2), Multifactorial, Autosomal dominant

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