56dbb89571a671f50fb7723ff0e0f828baa98c1b braney Tue Apr 28 13:48:45 2015 -0700 collect CDS frame information for Gencode knownGene refs #14639 diff --git src/hg/lib/knownCds.sql src/hg/lib/knownCds.sql new file mode 100644 index 0000000..e96c0d7 --- /dev/null +++ src/hg/lib/knownCds.sql @@ -0,0 +1,15 @@ +# knownCds.sql was originally generated by the autoSql program, which also +# generated knownCds.c and knownCds.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#The CDS part of a genePredExt. +CREATE TABLE knownCds ( + name varchar(255) not null, # Name of gene + cdsStartStat varchar(255) not null, # enum('none','unk','incmpl','cmpl') + cdsEndStat varchar(255) not null, # enum('none','unk','incmpl','cmpl') + exonCount int unsigned not null, # number of exons + exonFrames longblob not null, # Exon frame {0,1,2}, or -1 if no frame for exon + #Indices + PRIMARY KEY(name) +);