Schema for snp142Seq
  Database: hg19    Primary Table: snp142Seq    Row Count: 112,736,765   Data last updated: 2014-11-19
Format description: Contains file offsets for reference SNP flanking sequences in a single fasta file.
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc rs10varchar(255) rsId of sequence
file_offset 13144220102bigint(20) byte offset of sequence in file

Connected Tables and Joining Fields
        hg19.snp142.name (via snp142Seq.acc)
      hg19.snp142CodingDbSnp.name (via snp142Seq.acc)
      hg19.snp142Common.name (via snp142Seq.acc)
      hg19.snp142Flagged.name (via snp142Seq.acc)
      hg19.snp142Mult.name (via snp142Seq.acc)
      hg19.snp142OrthoPt4Pa2Rm3.name (via snp142Seq.acc)

Sample Rows
 
accfile_offset
rs1013144220102
rs10015674066914
rs100015663116875
rs1000013144372500
rs10000002862520169
rs1000000010290748696
rs1000000110290748767
rs1000000217291157776
rs1000000310290749443
rs1000000410290749514

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