src/hg/makeDb/doc/hg19.txt 1.48

Index: src/hg/makeDb/doc/hg19.txt
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/makeDb/doc/hg19.txt,v
retrieving revision 1.47
retrieving revision 1.48
diff -b -B -U 4 -r1.47 -r1.48
--- src/hg/makeDb/doc/hg19.txt	15 Oct 2009 22:36:03 -0000	1.47
+++ src/hg/makeDb/doc/hg19.txt	16 Oct 2009 17:17:44 -0000	1.48
@@ -6599,9 +6599,9 @@
     hgsql hg19 -e 'load data local infile "hprdToUniProt.tab" into table hprdToUniProt'
 
 # build knownToHprd table
 
-    hgsql hg19 -N -e 'select kgId,hprdId from hprdToCdna, kgXref where cdnaId=kgId' >j.kg1
+    hgsql hg19 -N -e 'select kgId,hprdId from hprdToCdna, kgXref where cdnaId=refseq' >j.kg1
     hgsql hg19 -N -e 'select kgId,hprdId from hprdToUniProt, kgXref where uniProtId=spId' >j.kg2
 
     cat j.kg1 j.kg2 | sed 's/_.//' | sort -u >knownToHprd.tab
     wc knownToHprd.tab