Schema for decipher
  Database: hg19    Primary Table: decipher    Row Count: 38,339   Data last updated: 2020-08-10
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 8231945int(10) unsigned range End position in chromosome
name 263986varchar(255) values Name of item

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

Sample Rows
 
binchromchromStartchromEndname
9chr108231945263986
9chr106172148402035
9chr104944170283601
9chr104458152286391
9chr104087397272172
9chr102957600400937
9chr102938093283043
9chr102558883268586
9chr102553982300695
9chr101497592266575

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