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

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

Sample Rows
 
binchromchromStartchromEndname
591chr1849165869817616765
591chr1869445884499610770
591chr1885826890962619262
591chr1891724901108621052
591chr1900440907336615921
592chr1924206925340608060
592chr1938739939782147571
592chr1945362981357103320
593chr110923461092441612091
593chr110931051093195612090

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