Schema for decipher
  Database: hg18    Primary Table: decipher    Row Count: 4,227   Data last updated: 2011-01-11
Format description: Browser extensible data
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 9smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 0int(10) unsigned range Start position in chromosome
chromEnd 3765501int(10) unsigned range End position in chromosome
name 2246varchar(255) values Name of item

Connected Tables and Joining Fields
        hg18.decipherRaw.id (via decipher.name)
      hg18.knownCanonToDecipher.value (via decipher.name)
      hg18.knownToDecipher.value (via decipher.name)

Sample Rows
 
binchromchromStartchromEndname
9chr1037655012246
9chr137633550421481
73chr13075826328951989
73chr13075826328951986
73chr13075826328951985
73chr15112316328951988
73chr1554267751852249267
9chr15542672847437248968
9chr17496216700000250648
9chr17496216369647252415

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