detecting SNP allele and genotype frequencies from 1000 genomes at ensembl
2
0
Entering edit mode
8.0 years ago

For each variation name (e.g. rs2242480) i would like to get data for table like this which was taken from here

Here is one sample that i have to get for one subpopulation:

Population: ACB;1000GENOMES:phase_3:ACB

Allele: frequency (count) C: 0.208 (40) T: 0.792 (152)

Genotype: frequency (count) C|C: 0.418 (1047) C|T: 0.320 (802) T|T: 0.262 (655)

I have connected to homo_sapiens_variation_84_38 database at ensembl mysql server. Then I have been searching through alleles joining with variations and populations, but i cannot find any of those populations enlisted in table. I have also used population_structure table, but it didnt help. So i wanted to ask if anyone can help me with info how to extract this data. Thanx in advance

population genotype frequency allele mysql • 1.9k views
ADD COMMENT
3
Entering edit mode
8.0 years ago
Denise CS ★ 5.2k

The genotype and allele frequency data from the 1000 Genomes project is far too large to be stored efficiently in the Ensembl MySQL schema. You would need to get that information via the Variation API, which uses a custom VCF backend to retrieve the data and return it on the web interface (as you linked out to). So you can only access this data via the Ensembl API or through the VCF files directly. More details can be found in Will McLaren's post

ADD COMMENT
0
Entering edit mode
8.0 years ago

thank you very much

ADD COMMENT

Login before adding your answer.

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