I need to download the the following attributes for all entries in dbSNP Build 131 via BioMart
Ensembl Transcript ID, Variation start in translation (aa) Variation end in translation (aa)
I can get this information for all dbSNP entries along with other attributes in "SEQUENCE VARIATION:" section of Biomart. But when I tried my query and it was giving proper results for 100 entries, but when I tried with "All" with email option, I never got an email from BioMart. I repeated the search again and I finally an email with an error message that
Your results file FAILED. Here is the reason why: Error during query execution: Lost connection to MySQL server during query
I would like to know if any one of you had similar problem with BioMart while trying for large queries ?
Is there any other way to download SEQUENCE VARIATION information for SNPs from dbSNPs ?
Thanks Keith. I will split the queries and try it.