Hi Carsten, Yes, this is possible. In the table browser, after you've selected the assembly, the table "all_mrna", etc:
- For output format, select: selected fields from primary and related tables. Then, get output. - On the next page under the Linked Tables, select "gbCdnaInfo" and click "Allow Selection From Checked Tables". - Now that that table's checked, again under Linked Tables, select the table named "tissue" and click "Allow Selection From Checked Tables". Finally, you can now select the fields you need from the main table "hg19.all_mrna" that you want, plus select the "name/Associated text" frield from the "hg19.tissue" table. "Get output" will now display the data with the tissue field. Please let us know if you have any additional questions: [email protected] - Greg Roe UCSC Genome Bioinformatics Group On 8/22/11 9:08 AM, Carsten Raabe wrote: > Dear all, > > My name Carsten and I am interested in the human all_mRNA table. I would > like to know whether it is possible not only to receive the coordinates > of the corresponding mRNA via table browser or mysql database provided > by the UCSC browser, but in addition information on the corresponding > tissue/cell line the cDNA is cloned from. I saw there is a link to the > tissue table providing some kind of id, however I am not clear of how to > use this information. > > I am thankful for any kind of help in this regard, > > cheers > > C > > PS the browser is a very useful tool in many aspects of my daily work. > Thanks a lot for it !! > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
