Schema for snp142Seq
  Database: hg38    Primary Table: snp142Seq    Row Count: 112,736,766   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 13116903030bigint(20) byte offset of sequence in file

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

Sample Rows
 
accfile_offset
rs1013116903030
rs10015617287043
rs100012154315851
rs1000013117053313
rs10000002817456007
rs1000000010249308787
rs1000000110249308858
rs1000000217291623272
rs1000000310249309534
rs1000000410249309605

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