src/hg/makeDb/doc/hg18.txt 1.351
1.351 2009/02/24 00:14:48 fanhsu
Fixed the 2nd part of a typo in omimGene build.
Index: src/hg/makeDb/doc/hg18.txt
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/makeDb/doc/hg18.txt,v
retrieving revision 1.350
retrieving revision 1.351
diff -b -B -U 4 -r1.350 -r1.351
--- src/hg/makeDb/doc/hg18.txt 23 Feb 2009 23:43:20 -0000 1.350
+++ src/hg/makeDb/doc/hg18.txt 24 Feb 2009 00:14:48 -0000 1.351
@@ -26670,9 +26670,9 @@
hgsql hg18 -N -e 'select * from omimToKnownCanonical' |sort -u >j.tmp
hgsql hg18 -N -e \
'select n.name, c.transcript from omimGeneNR n, knownCanonical c,
knownToRefSeq r, refLink l, knownIsoforms i where l.mrnaAcc=r.value and
-binary(n.name)=l.omimId and c.transcript=r.name and c.clusterId=i.clusterId
+binary(n.name)=l.omimId and i.transcript=r.name and c.clusterId=i.clusterId
and omimId <>0 '\
|sort -u >omimToKnownGeneNR.tab
cat j.tmp omimToKnownGeneNR.tab |sort -u >omimToKnownCanonicalNew.tab