Hi,
I have been looking at your database without success and I was hoping
you could help me. I am trying to get a list of all of the CCDS gene
IDs along with the gene names and gene descriptions. I thought that a
merge of ccdsInfo and refSeqSummary would allow be to link up the mRNA
description with the summary, but the following MySQL query on your
server turned up nothing:
select ccdsInfo.ccds, refSeqSummary.summary from ccdsInfo, refSeqSummary
where ccdsInfo.mrnaAcc = refSeqSummary.mrnaAcc;
Empty set (1.11 sec)
indicating that there is a disconnect between the tables. Is there a
proper way to perform this query, or could you just send me a table?
Thank you for the help,
Jeff
--
Jeffrey Rosenfeld Ph. D.
Research Scientist
Laboratory of Analytic Genomics, Division of Psychiatry Research,
The Zucker Hillside Hospital;
North Shore - Long Island Jewish Health System;
Mailing Address:
The Zucker Hillside Hospital
Psychiatry Research
75-59 263rd Street
Glen Oaks, NY 11004
718-470-8836 (ph)
718-343-1659 (fax)
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
