Schema for omimGene2
  Database: hg19    Primary Table: omimGene2    Row Count: 19,276   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 859302int(10) unsigned range Start position in chromosome
chromEnd 879954int(10) unsigned range End position in chromosome
name 616765varchar(255) values Name of item

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

Sample Rows
 
binchromchromStartchromEndname
591chr1859302879954616765
591chr1879582894636610770
591chr1895963901099619262
591chr1901861911245621052
591chr1910577917473615921
592chr1934343935477608060
592chr1948876949920147571
592chr1955499991496103320
593chr111024831102578612091
593chr111032421103332612090

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