Thanks Greg for your infos. I will try sql. D.
On 3/27/12 6:47 PM, Greg Roe wrote: > 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
