95efc27edf24bba8d0c7e53d2ef4aead59982826 braney Mon Jun 15 18:29:39 2020 -0700 Merging in our gencode merge code to master branch diff --git src/hg/lib/gencodeToUniProt.sql src/hg/lib/gencodeToUniProt.sql new file mode 100644 index 0000000..52e7725 --- /dev/null +++ src/hg/lib/gencodeToUniProt.sql @@ -0,0 +1,14 @@ +# gencodeToUniProt.sql was originally generated by the autoSql program, which also +# generated gencodeToUniProt.c and gencodeToUniProt.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#GENCODE transcript to UniProt peptide mapping +CREATE TABLE gencodeToUniProt ( + transcriptId varchar(255) not null, # GENCODE transcript identifier + acc varchar(255) not null, # UniProt/Swiss-Prot accession + name varchar(255) not null, # UniProt/Swiss-Prot entry name + dataset enum("SwissProt", "TrEMBL") not null, # UniProt dataset + #Indices + index(transcriptId) +);