The current GATK version is 3.2-2

#### Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Bug Bulletin: The GenomeLocPArser error in SplitNCigarReads has been fixed; if you encounter it, use the latest nightly build.

# dbSNP - ancestral_allele and gene_name data missing in SubSNP table

Skaneateles, nyPosts: 3Member
edited January 17

Question on the dbSNP database. Looks like the SubSNP table is the only location for ancestral_allele and gene_name information for a given snp_id/subsnp_id. However, these fields in SubSNP are very sparsely populated. For example, if you search the dbSNP web page :

you can see the ancestral allele for rs5 is G. However, if you search snp_id=5 in the SubSNP table, both ancestral_allele and gene_name are null:

mysql> select gene_name,ancestral_allele from SubSNP where snp_id=5;
+-----------+------------------+
| gene_name | ancestral_allele |
+-----------+------------------+
|           |                  |
+-----------+------------------+
1 row in set (0.00 sec)


Can anyone explain this discrepancy or know where I can get ancestral_allele or gene_name if not in SubSNP directly ?

Post edited by Geraldine_VdAuwera on
Tagged: