ecfd33824b0553d60a898c114fe1e6e3f8326ec1 braney Wed Apr 15 14:47:32 2020 -0700 tweak Jacob's rna structure code to be used on wuhCor1 diff --git src/hg/lib/rnaStruct.sql src/hg/lib/rnaStruct.sql new file mode 100644 index 0000000..32af2a2 --- /dev/null +++ src/hg/lib/rnaStruct.sql @@ -0,0 +1,11 @@ +CREATE TABLE rnaStruct ( + chrom varchar(255) not null, # Chromosome or FPC contig + chromStart int unsigned not null, # Start position in chromosome + chromEnd int unsigned not null, # End position in chromosome + name varchar(255) not null, # Name of item + score int unsigned not null, # Score from 0-1000 + strand char(1) not null, # + or - + size int unsigned not null, # Size of element. + secStr longblob not null, # Parentheses and '.'s which define the secondary structure + conf longblob # Confidence of secondary-structure annotation per position (0.0-1.0). or empty +);