95efc27edf24bba8d0c7e53d2ef4aead59982826 braney Mon Jun 15 18:29:39 2020 -0700 Merging in our gencode merge code to master branch diff --git src/hg/lib/gencodeAttrs.sql src/hg/lib/gencodeAttrs.sql new file mode 100644 index 0000000..c2bd3fd --- /dev/null +++ src/hg/lib/gencodeAttrs.sql @@ -0,0 +1,24 @@ +# gencodeAttrs.sql was originally generated by the autoSql program, which also +# generated gencodeAttrs.c and gencodeAttrs.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Basic set of attributes associated with all Gencode transcripts. +CREATE TABLE gencodeAttrs ( + geneId varchar(255) not null, # Gene identifier + geneName varchar(255) not null, # Gene name + geneType varchar(255) not null, # BioType of gene + transcriptId varchar(255) not null, # Transcript identifier + transcriptName varchar(255) not null, # Transcript name + transcriptType varchar(255) not null, # BioType of transcript + ccdsId varchar(255) not null, # CCDS identifier if transcript is in CCDS + level int not null, # GENCODE level: 1 = experimental confirmed, 2 = manual, 3 = automated + proteinId varchar(255) not null, # Protein identifier (not loaded on many older versions of GENCODE) + transcriptClass varchar(255) not null, # high level type of transcript + #Indices + index(geneId), + index(geneName), + PRIMARY KEY(transcriptId), + index(ccdsId), + index(proteinId) +);