Hey,
I need to assign RefSeq transcripts to their respective genes and did this by joining the primary table refGene to refFlat. I encountered two problems here: a) There seem to be RefSeq transcripts with identical RefSeq ids, but differing chromosome positions (for mm9 e.g. NM_011253). How can that be? b) In the secondary table (refFlat) the RefSeqID as a foreign key is not unique either, so I get duplicate results in the final view (that is duplicates for each single occurrence of the id in the primary table) Is there a better table from which to retrieve the gene names for the refGene transcripts (in which the RefSeqID is unique)? I tried the table kgXref as well but in that one there doesn't even seem to be a gene symbol for every RefSeqID. Greetz _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
