6031d05b102c1cb34c9e8394a8acf5809a8eca8f angie Mon Jan 31 16:19:37 2011 -0800 Track #34 (dbVar for human): Added new track type gvf with basichandlers in hgTracks and hgc. dbVar's GVF attributes are recognized, esp. var_type is used to color items, and items are sorted using the Parent keyword so that parents appear immediately before their children, and children are sorted by var_type. Attributes are displayed in hgc; need to do a bit better for the Start_range and End_range (e.g. translate "." to "inner start unknown" etc.). diff --git src/hg/lib/bed8Attrs.sql src/hg/lib/bed8Attrs.sql new file mode 100644 index 0000000..f926b1e --- /dev/null +++ src/hg/lib/bed8Attrs.sql @@ -0,0 +1,23 @@ +# bed8Attrs.sql was originally generated by the autoSql program, which also +# generated bed8Attrs.c and bed8Attrs.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Items with thin (outer) and/or thick (inner) regions and an arbitrary set of attributes +CREATE TABLE bed8Attrs ( + bin smallint not null, # Bin number for browser speedup + 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, # Name of item + score int unsigned not null, # Score from 0-1000 (might not be applicable) + strand char(1) not null, # +, - or . for unknown + thickStart int unsigned not null, # Start of where display should be thick + thickEnd int unsigned not null, # End of where display should be thick + attrCount int not null, # Number of attributes + attrTags longblob not null, # Attribute tags/keys + attrVals longblob not null, # Attribute values + #Indices + INDEX(chrom(8),bin), + INDEX(name(20)) +);