95efc27edf24bba8d0c7e53d2ef4aead59982826 braney Mon Jun 15 18:29:39 2020 -0700 Merging in our gencode merge code to master branch diff --git src/hg/lib/gencodeToPubMed.sql src/hg/lib/gencodeToPubMed.sql new file mode 100644 index 0000000..7386e6e --- /dev/null +++ src/hg/lib/gencodeToPubMed.sql @@ -0,0 +1,12 @@ +# gencodeToPubMed.sql was originally generated by the autoSql program, which also +# generated gencodeToPubMed.c and gencodeToPubMed.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Gencode metadata table of PubMed identifier of published experimental data associated with Gencode Genes +CREATE TABLE gencodeToPubMed ( + transcriptId varchar(255) not null, # GENCODE transcript identifier + pubMedId int not null, # PubMed identifier of supporting literature + #Indices + index(transcriptId) +);