Schema for omim2gene
  Database: hg38    Primary Table: omim2gene    Row Count: 27,824   Data last updated: 2022-06-15
Format description: OMIM omim2gene
Note: genome-wide queries are not available for this table.
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
        hg38.keggPathway.locusID (via omim2gene.geneId)
      hg38.knownToLocusLink.value (via omim2gene.geneId)
      hgFixed.refLink.locusLinkId (via omim2gene.geneId)
      hg38.omimAv.omimId (via omim2gene.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGene2.name (via omim2gene.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGeneMap.omimId (via omim2gene.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGeneMap2.omimId (via omim2gene.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimGeneSymbol.omimId (via omim2gene.omimId) Note: genome-wide queries are not available for this table.
      hg38.omimPhenotype.omimId (via omim2gene.omimId) Note: genome-wide queries are not available for this table.
      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.