c295ff853919b7046caca525927f4856ff775622 chinhli Wed Dec 12 11:19:34 2012 -0800 Track #9269 ExonJunction Primers displayed as a bedDetail track. diff --git src/hg/lib/exonJunctionPrimers.sql src/hg/lib/exonJunctionPrimers.sql new file mode 100644 index 0000000..62bd27a --- /dev/null +++ src/hg/lib/exonJunctionPrimers.sql @@ -0,0 +1,24 @@ +# exonJunctionPrimers.sql was originally generated by the autoSql program, which also +# generated exonJunctionPrimers.c and exonJunctionPrimers.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Browser extensible data, with extended fields for detail page +CREATE TABLE exonJunctionPrimers ( + chrom varchar(255) not null, # Reference sequence chromosome or scaffold + chromStart int unsigned not null, # Start position in chromosome + chromEnd int unsigned not null, # End position in chromosome + name varchar(255) not null, # Short Name of item + score int unsigned not null, # Score from 0-1000 + strand char(1) not null, # + or - + thickStart int unsigned not null, # Start of where display should be thick (start codon) + thickEnd int unsigned not null, # End of where display should be thick (stop codon) + reserved int unsigned not null, # Used as itemRgb as of 2004-11-22 + blockCount int not null, # Number of blocks + blockSizes longblob not null, # Comma separated list of block sizes + chromStarts longblob not null, # Start positions relative to chromStart + id varchar(255) not null, # ID to bed used in URL to link back + description longblob not null, # Long description of item for the details page + #Indices + PRIMARY KEY(chrom) +);