Hello Pete, The query is too large to run with the Table browser since the genbank tables are too large to link. Pretty much any query that passes through gbCndaInfo to the linked normalized data (such as tissue) will fail in the Table browser. You will need to obtain the files from the downloads server and merge using your own tools or use the public mySQL server if you are able to create a query (use the Table browser's "describe table schema" button to learn the linking keys to join on).
Once you have the file, you can upload to Galaxy directly. Or load as a custom track at UCSC and send that over via the Table browser (if under 100k lines and if the file format is accepted). Both help contacts are a fine place to ask questions that bridge the two products. Since this was a UCSC query issue, contacting us was a good choice this time. Your query would have failed whether you were sending it to Galaxy or creating a regular download file or saving as a custom track. Thanks, jen --------------------------------- Jennifer Jackson UCSC Genome Informatics Group http://genome.ucsc.edu/ On 6/3/10 6:35 AM, Pete Shepard wrote: > Hello, > > I am trying to extract all est information for hg18. I can do this for all > all_est information ~8X10^6 lines of I send query to Galaxy. However, if I > try to link this table to another one eg cDNA table in order to get tissue > information, I get this error: > > Stopping after 1000000 rows, try restricting region or adding filter > > Is there a way to successfully complete this query? > > If this is not the right formum for Galaxy questions, could you please > point me in the right direction? > > Thanks > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
