fc11798dce2b6c7c91a787af64599331226ebedc hiram Fri Feb 17 12:44:44 2012 -0800 to supply a description for rn4 table kgXrefPrevious diff --git src/hg/lib/kgXrefPrevious.sql src/hg/lib/kgXrefPrevious.sql new file mode 100644 index 0000000..187fcb0 --- /dev/null +++ src/hg/lib/kgXrefPrevious.sql @@ -0,0 +1,22 @@ +# this is a copy from kgXref.sql to supply a description for the rn4 +# table kgXrefPrevious + +#Link together a Known Gene ID and a gene alias +CREATE TABLE kgXrefPrevious ( + kgID varchar(40) not null, # Known Gene ID + mRNA varchar(40), # mRNA ID + spID varchar(40), # UniProt protein Accession number + spDisplayID varchar(40), # UniProt display ID + geneSymbol varchar(40), # Gene Symbol + refseq varchar(40), # RefSeq ID + protAcc varchar(40), # NCBI protein Accession number + description varchar(255), # Description + #Indices + KEY(kgID), + KEY(mRNA), + KEY(spID), + KEY(spDisplayID), + KEY(geneSymbol), + KEY(refseq), + KEY(protAcc), +);