How to insert dbSNP in a database?
1
0
Entering edit mode
6 weeks ago
magnolia ▴ 10

Hi everyone,

I want to insert the whole dbSNP VCF files (both grch37 and 38) into database. Postgres, or MySQL.

Has anyone done this?

How do you deal with the size of the table?

All in one table or partition it?

If partitioned, how do you query?

Thank you in advance!

dbsnp database • 431 views
ADD COMMENT
1
0
Entering edit mode

Thank you!

1) I need this because I want to connect all the data I need query via SQL.

2) Thanks a lot but this file only has 200 million rows whereas dbSNP VCF has more than 1 billion rows. Why is that?

ADD REPLY
0
Entering edit mode

2) not the same version of dbsnp, not the same build

ADD REPLY
0
Entering edit mode

Oh so, there is 800 million rsid difference between 150 and 155? That's very interesting. Also another reason that I had to create a db table from VCF.

ADD REPLY

Login before adding your answer.

Traffic: 1195 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6