Hi Capece, Our mysql server is designed to download small parts of tables; if you are downloading the entire SNP table, we recommend using our download server instead. To get to our download server, go to our home page http://genome.ucsc.edu/ and click on "Downloads" in the left side blue bar. From there click on your organism of interest, scroll down to your desired assembly and click on "Annotation database". This folder contains a dump of every table in that database as a .txt.gz as well as the .sql file required to load it into a database of your own, if desired.
Finally, select whichever SNP table you would like from the list, which should be in the form snp###.txt.gz. Pleas keep in mind that not all assemblies have SNP tracks. I hope this information is helpful. Please feel free to contact the mail list again if you require further assistance. Best, Mary ------------------ Mary Goldman UCSC Bioinformatics Group On 6/14/11 12:09 AM, Vincenzo Capece wrote: > Dear all, > i am a beginner and i hope you can help me. > Have you a list of all snps for each genome? > For instance, i know that to list the human snps from *UCSC server *i have > launch this input string: > > mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -D hg19 -e ' > select * from snp131 where...." > > > > In few words, i need a list like this (if it exist): > rn4 --> snptable > mm9 --> snptable > genomex --> snptable > .... > I hope i am clear. > Thanks a lot and good work. > > > _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
