Exome Aggregation Consortium (ExAC) database ?
1
3
Entering edit mode
6.5 years ago

Dear lazyweb,

I wonder how data are stored behind the Exac server http://exac.broadinstitute.org/ :

  • SQL only ?
  • SQL+tabix/VCF ?
  • Gemini ?
  • ...

Thanks.

Pierre

exac sql variants vcf database • 6.1k views
ADD COMMENT
1
Entering edit mode

"Dear lazyweb": Yet another indicator that Pierre *owns* BioStars :)

ADD REPLY
3
Entering edit mode
6.5 years ago

Pierre;

The source code is here:

https://github.com/konradjk/exac_browser

It looks like a MongoDB database and Python Flask webserver. It also builds on xBrowse:

https://github.com/xbrowse/xbrowse

ADD COMMENT
2
Entering edit mode

ah yes thank you Brad, there's even a python script to load the tabix+vcf files: https://github.com/konradjk/exac_browser/blob/master/exac.py

(...)
def load_variants_file():
def load_variants(sites_file, i, n, db):
variants_generator = parse_tabix_file_subset([sites_file], i, n, get_variants_from_sites_vcf)
try:
db.variants.insert(variants_generator, w=0)
except pymongo.errors.InvalidOperation:
pass # handle error when variant_generator is empty
ADD REPLY

Login before adding your answer.

Traffic: 2607 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