Schema for snp130Seq

Database: hg18 Primary Table: snp130Seq Row Count: 17,804,034 Data last updated: 2009-07-07
Format description: Contains file offsets for reference SNP flanking sequences in a single fasta file.
On download server: MariaDB table dump directory

field	example	SQL type	description
`acc`	rs242	`varchar(255)`	rsId of sequence
`file_offset`	0	`bigint(20)`	byte offset of sequence in file

Connected Tables and Joining Fields


	hg18.gwasCatalog.name (via snp130Seq.acc) hg18.snp130.name (via snp130Seq.acc) hg18.snp130CodingDbSnp.name (via snp130Seq.acc) hg18.snp130Exceptions.name (via snp130Seq.acc) hg18.snp130OrthoPt2Pa2Rm2.name (via snp130Seq.acc)

Sample Rows

acc	file_offset
rs242	0
rs538	291
rs546	1181
rs549	2071
rs568	2822
rs665	3384
rs672	3646
rs677	3919
rs685	4809
rs699	5620

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