Hello MXMiao-Xin, Programming this way against the Table browser is not really recommended, especially for entire tables. However, if you do want to do a subset, some API help is here (in particular, please note that you should exclude the hgsid variable): http://genomewiki.ucsc.edu/index.php/Table_Browser_URL
The public MySQL server would be much better to fetch parts of data automatically: http://genomewiki.ucsc.edu/index.php/Finding_nearby_genes And the third option is to obtain the flat files from the downloads server and use them locally. http://hgdownload.cse.ucsc.edu/downloads.html Hopefully one of these solutions will work for you. Please feel free to contact the mailing list support team again if you would like more assistance. Warm regards, Jen UCSC Genome Browser Support On 8/14/10 6:54 PM, Miaoxin Li wrote: > I wrote a Java program to automatically retrieve a subset of data through > http://genome.ucsc.edu/cgi-bin/hgTables. > > But I failed and it always returned me a page with a message “Search terms are > not very specific, only showing first 500 matching known genes.” The following > are the term I specified: ("hgsid", "167501411"), ("clade", "mammal"), ("org", > "Human"), ("db", "hg18"), ("hgta_group", "genes"), ("hgta_track", > "knownGene"), > ("hgta_table", "knownGene"), ("hgta_regionType", "genome"), ("hgta_doSchema", > "describe table schema"), ("position", "position"), ("hgta_outputType", > "gzip"), > ("hgta_outFileName", “test”), ("hgta_doTopSubmit", "get output"), > ("boolshad.sendToGreat", "0") and ("boolshad.sendToGalaxy", "0"). > > > I will be very grateful to you if you could provide some suggestions about > this > problem. > > > Regards, > > MXMiao-Xin (Marcy) Li, PhD > L10-64, Dept of Psychiatry > Laboratory Block, Faculty of Medicine Building > The University of Hong Kong > 21 Sasson Road, PokFuLam, Hong Kong > Tel: +852-2819-9559 (Office) > Tel: +852-3751-8744 (Dormitory) > Mailto: [email protected], [email protected] > > > > > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
