Schema for omim2gene
  Database: hg19    Primary Table: omim2gene    Row Count: 29,152   Data last updated: 2025-04-30
Format description: OMIM omim2gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
omimId 100050int(10) unsigned range MIM ID
entryType predominantly phenotypesvarchar(40) values entry type (gene or phenotype)
geneId 0int(10) unsigned range ENTREZ gene ID
approvedGeneSymbol  varchar(40) values  

Connected Tables and Joining Fields
        hg19.keggPathway.locusID (via omim2gene.geneId)
      hg19.knownToLocusLink.value (via omim2gene.geneId)
      hgFixed.refLink.locusLinkId (via omim2gene.geneId)
      knownGeneV39.knownToLocusLink.value (via omim2gene.geneId)
      hg19.ncbiRefSeqLink.omimId (via omim2gene.omimId)
      hg19.omimAv.omimId (via omim2gene.omimId)
      hg19.omimGene2.name (via omim2gene.omimId)
      hg19.omimGeneMap.omimId (via omim2gene.omimId)
      hg19.omimGeneMap2.omimId (via omim2gene.omimId)
      hg19.omimGeneSymbol.omimId (via omim2gene.omimId)
      hg19.omimPhenotype.omimId (via omim2gene.omimId)
      hgFixed.refLink.omimId (via omim2gene.omimId)

Sample Rows
 
omimIdentryTypegeneIdapprovedGeneSymbol
100050predominantly phenotypes0
100070phenotype100329167
100100phenotype0
100200predominantly phenotypes0
100300phenotype0
100500moved/removed0
100600phenotype0
100640gene216ALDH1A1
100650gene217ALDH2
100650phenotype217ALDH2

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