6b29a9f398148d8623c624dd4906d8e3087905c1
jcasper
  Fri Nov 4 13:34:18 2022 -0700
Should be checking human IDs against the human Xref table, refs #30231

diff --git src/hg/hgGene/hgGeneData/otherOrgs.ra src/hg/hgGene/hgGeneData/otherOrgs.ra
index 56c0fdc..0ff6c0a 100644
--- src/hg/hgGene/hgGeneData/otherOrgs.ra
+++ src/hg/hgGene/hgGeneData/otherOrgs.ra
@@ -1,27 +1,27 @@
 # This file contains info to process the homologous genes
 # in other species links.
 
 name human
 shortLabel Human
 tables hgBlastTab 
 idSql select target from hgBlastTab where query = '%s'
 pepTable knownGenePep
 geneTable knownGene
 genomeUrl ../cgi-bin/hgTracks?org=Human&position=%s
 otherUrl https://www.ncbi.nlm.nih.gov/nuccore/%s?report=GenBank
-otherIdSql select mRNA from KNOWNDB.kgXref where kgID='%s'
+otherIdSql select mRNA from kgXref where kgID='%s'
 otherName GenBank
 priority 10
 
 name mouse
 shortLabel Mouse
 tables mmBlastTab 
 idSql select target from mmBlastTab where query = '%s'
 pepTable knownGenePep
 geneTable knownGene
 genomeUrl ../cgi-bin/hgTracks?org=Mouse&position=%s
 otherName MGI
 otherUrl http://www.informatics.jax.org/marker/%s
 otherIdSql select uniProt.extDbRef.extAcc1 from uniProt.extDbRef,uniProt.extDb,kgXref where uniProt.extDb.val = 'MGI' and uniProt.extDb.id = uniProt.extDbRef.extDb and uniProt.extDbRef.acc = kgXref.spID and kgXref.kgID = '%s' 
 otherIdSql2 select kgXref.mRNA from kgXref where kgID='%s'
 priority 20