95efc27edf24bba8d0c7e53d2ef4aead59982826 braney Mon Jun 15 18:29:39 2020 -0700 Merging in our gencode merge code to master branch diff --git src/hg/lib/gencodeToGeneSymbol.sql src/hg/lib/gencodeToGeneSymbol.sql new file mode 100644 index 0000000..ebc6ab8 --- /dev/null +++ src/hg/lib/gencodeToGeneSymbol.sql @@ -0,0 +1,13 @@ +# gencodeToGeneSymbol.sql was originally generated by the autoSql program, which also +# generated gencodeToGeneSymbol.c and gencodeToGeneSymbol.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 official gene symbol. For human, this is the HUGO Gene Nomenclature Committee (HGNC) gene symbo. For mouse, this is the Mouse Genome Informatics (MGI) gene symbol. +CREATE TABLE gencodeToGeneSymbol ( + transcriptId varchar(255) not null, # GENCODE transcript identifier + symbol varchar(255) not null, # HGNC/MGI gene symbol + geneId varchar(255) not null, # HGNC/MGI symbol id used by database + #Indices + index(transcriptId) +);