f09e062ead54042b3f2b20ea4f4addc21633625e
cline
  Mon Sep 19 17:16:29 2011 -0700
Changed in response to Redmine #5290 (tRNA and Rfam genes being represented poorly by kgXref).  The kgXref table now has two new fields: one for the tRNA name (which can be used to cross-reference the track items to tRNA Genes items), and one for the Rfam accession (which can be used for links to the appropriate Rfam model page).  txGeneXref fills in both of these fields, and splices the sequence names appropriately to pull out half-meaningful gene symbols and descriptions
diff --git src/hg/lib/kgXref.sql src/hg/lib/kgXref.sql
index f8db7f8..4d32dc8 100644
--- src/hg/lib/kgXref.sql
+++ src/hg/lib/kgXref.sql
@@ -2,18 +2,19 @@
 # generated kgXref.c and kgXref.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Link together a Known Gene ID and a gene alias
 CREATE TABLE kgXref (
     kgID varchar(255) not null,	# Known Gene ID
     mRNA varchar(255) not null,	# mRNA ID
     spID varchar(255) not null,	# SWISS-PROT protein Accession number
     spDisplayID varchar(255) not null,	# SWISS-PROT display ID
     geneSymbol varchar(255) not null,	# Gene Symbol
     refseq varchar(255) not null,	# RefSeq ID
     protAcc varchar(255) not null,	# NCBI protein Accession number
     description longblob not null,	# Description
     rfamAcc varchar(255) not null,	# Rfam accession number
+    tRnaName varchar(255) not null,	# Name from the tRNA track
               #Indices
     PRIMARY KEY(kgID)
 );