7ae4a70c26c3414a34b262329b2f7febe831923c hiram Thu Jul 18 10:26:34 2013 -0700 checking in Robert's code refs #9741 diff --git src/hg/lib/rmskOut2.sql src/hg/lib/rmskOut2.sql new file mode 100644 index 0000000..2fb5c37 --- /dev/null +++ src/hg/lib/rmskOut2.sql @@ -0,0 +1,26 @@ +# rmskOut2.sql was originally generated by the autoSql program, which also +# generated rmskOut2.c and rmskOut2.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#RepeatMasker .out record +CREATE TABLE rmskOut2 ( + swScore int unsigned not null, # Smith Waterman alignment score + milliDiv int unsigned not null, # Base mismatches in parts per thousand + milliDel int unsigned not null, # Bases deleted in parts per thousand + milliIns int unsigned not null, # Bases inserted in parts per thousand + genoName varchar(255) not null, # Genomic sequence name + genoStart int unsigned not null, # Start in genomic sequence + genoEnd int unsigned not null, # End in genomic sequence + genoLeft int not null, # -#bases after match in genomic sequence + strand char(1) not null, # Relative orientation + or - + repName varchar(255) not null, # Name of repeat + repClass varchar(255) not null, # Class of repeat + repFamily varchar(255) not null, # Family of repeat + repStart int not null, # Start in repeat sequence - regardless of orient. + repEnd int unsigned not null, # End in repeat sequence - reglardless of orient. + repLeft int not null, # -#bases after match in repeat sequence - regardless of orient + id int unsigned not null, # The ID of the hit. Used to link related fragments + #Indices + PRIMARY KEY(swScore) +);