Hi Duke, You can query this data from our public MySQL server. Instructions are here:
http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29 If you have any additional questions, please reply to: [email protected] - Greg Roe UCSC Genome Bioinformatics Group On 3/27/12 11:46 AM, Duke wrote: > Hi UCSC Staffs, > > I am trying to download intersection of hg19.description and > hg19.refGene following these below steps: > > * On http://genome.ucsc.edu/cgi-bin/hgTables > + clade: Mammal; genome: Human; assembly: Feb. 2009; group: All > Tables; database: hg19; table: description; output format: seleteced > fields from primary and related tables; output file: test; file type > returned: gzip compressed > + Hit "get output" > > * On next page > + Linked Tables: check hg19.gbCdnaInfo > + Hit "Allow Selection From Checked Tables" > > * On next page > + Linked Tables: uncheck hg19.gbCdnaInfo; then check hg19.refGene > + Hit "Allow Selection From Checked Tables" > + On Select Fields from hg19.description: check name > + On hg19.refGene fields: check name, chrom, strand, txStart, > txEnd, cdsStart, cdsEnd, exonCount, exonStarts, exonEnds, name2 > + Hit "get output" > > It takes a while, then askes me location to save, but the saved file has > an error: > --------------------------------------------------------------------------- > Stopping after 1000000 rows, try restricting region or adding filter > --------------------------------------------------------------------------- > --------------------------------------------------------------------------- > carefulAlloc: Allocated too much memory - more than 6,442,450,941 bytes > (6,442,487,599) > --------------------------------------------------------------------------- > > I understand that this might be because the data is too big to be > handled by the browser. Please advise me if there is any alternative > ways of getting what I want? > > Thank you in advance, > > D. > > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
