src/hg/hgGene/hgGeneData/links.ra 1.38

1.38 2009/04/28 16:29:12 fanhsu
Updated idSql for links to Stanford Source to bypass non-coding genes.

Index: src/hg/hgGene/hgGeneData/links.ra
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/hgGene/hgGeneData/links.ra,v
retrieving revision 1.37
retrieving revision 1.38
diff -b -B -U 4 -r1.37 -r1.38
--- src/hg/hgGene/hgGeneData/links.ra	30 Jan 2009 23:32:28 -0000	1.37
+++ src/hg/hgGene/hgGeneData/links.ra	28 Apr 2009 16:29:12 -0000	1.38
@@ -104,9 +104,9 @@
 
 name stanfordSource
 shortLabel Stanford SOURCE
 tables kgXref
-idSql select mRNA from kgXref where kgID = '%s'
+idSql select geneSymbol from kgXref x, knownGene k where kgID = '%s' and name= kgID and cdsStart <> cdsEnd
 url http://genome-www5.stanford.edu/cgi-bin/SMD/source/sourceResult?option=Number&criteria=%s&choice=Gene
 priority 10
 
 name ensembl