Hello, Starting with the RefSeq Genes track's primary table (refGene) in the Table browser, click on "view table schema", the associated tables can be seen (along with connecting keys).
For gene symbol - link to the table refFlat For the NM -> NP protein sequence relationship - link to the table refLink The other table's route the query through the UCSC Genes track, which is good for many queries, but perhaps not this one. If a sequence is non-coding (click through the sequenceID in the browser to NCBI to see the datasheet), then there will be no protein. Thanks, Jennifer ------------------------------------------------ Jennifer Jackson UCSC Genome Bioinformatics Group ----- "Katherine Siddle" <[email protected]> wrote: > From: "Katherine Siddle" <[email protected]> > To: "[email protected]" <[email protected]> > Sent: Friday, November 13, 2009 6:46:36 AM GMT -08:00 US/Canada Pacific > Subject: [Genome] Comparing tables on RefSeq Genes track > > To whom it may concern. > > I am trying to convert RefSeq IDs to Protein IDs using the refgene, > knownToRefseq and kgXref tables in the RefSeq genes track. I have > noticed that some of the refseqs in the refgene table are not present > in either of the other two tables. Is there a reason for their not > being included in the knownToRefseq and kgXref tables? Is there > another way which I could access protein IDs for these refseqs? > > Many thanks, > > Katie Siddle. > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
