Hello Elize, I see the same results. The seq table is very large and a query will often time out in a browser (not giving complete results).The rows that are returned before the time-out are all n/a because they represent data not in the UCSC Gene track. The only data in kgXref is from the UCSC Genes track.
Is there a reason why you are not starting with the kgXref table directly? To do this, set the track to UCSC Genes, scroll down in the table's menu to kgXref. The kgSpAlias table also has the UniprotID linked to many aliases, including the HGNC gene symbols. Export the complete tables joined or individually to see the data range. You can also ftp the file(s) from the Downloads area in the folder goldenPath//hg18/database/ http://genome.ucsc.edu/FAQ/FAQdownloads#download1 Try this and if you do not get the expected result, please email back and include an example input & expected output, Thanks, Jennifer Jackson UCSC Genome Bioinformatics Group [email protected] wrote: > hi, > i'm trying to get a table out of the table browser that maps Unigene IDs to > Hugo IDs. i started with the Unigene -unigene3 table (under mRNA and ESTs) > in the mar 2006 release. when i get fields from this tabel and selected > other tables - i have to go through another table to get to the kgXref table > that i really want to join to - i end up with the gene Symbol column > containing only n/a's. can you shed some light on this for me? > thanks, > elize > > _______________________________________________ > Genome maillist - [email protected] > https://lists.soe.ucsc.edu/mailman/listinfo/genome > _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
