Schema for omimGene2
  Database: hg38    Primary Table: omimGene2    Row Count: 19,892   Data last updated: 2025-04-30
Format description: Browser extensible data
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 592smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 923922int(10) unsigned range Start position in chromosome
chromEnd 944574int(10) unsigned range End position in chromosome
name 616765varchar(255) values Name of item

Connected Tables and Joining Fields
        hg38.ncbiRefSeqLink.omimId (via omimGene2.name)
      hg38.omim2gene.omimId (via omimGene2.name)
      hg38.omimAv.omimId (via omimGene2.name)
      hg38.omimGeneMap.omimId (via omimGene2.name)
      hg38.omimGeneMap2.omimId (via omimGene2.name)
      hg38.omimGeneSymbol.omimId (via omimGene2.name)
      hg38.omimPhenotype.omimId (via omimGene2.name)
      hgFixed.refLink.omimId (via omimGene2.name)

Sample Rows
 
binchromchromStartchromEndname
592chr1923922944574616765
592chr1944202959256610770
592chr1960583965719619262
592chr1966481975865621052
592chr1975197982093615921
592chr19989631000097608060
592chr110134961014540147571
9chr110201191056116103320
593chr111671031167198612091
593chr111678621167952612090

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