0b81078213eff40174d357fbc8632ed7077baec4
braney
  Fri Aug 21 09:47:38 2020 -0700
changes to support the lack of native knownGene tables in an assembly.

diff --git src/hg/hgGene/hgGeneData/otherOrgs.ra src/hg/hgGene/hgGeneData/otherOrgs.ra
index 64da1ed..56c0fdc 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 kgXref.mRNA from kgXref where kgID='%s'
+otherIdSql select mRNA from KNOWNDB.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