61b98e84a58f8049465452e435fa9b6048777bf5 kate Thu May 16 11:52:43 2019 -0700 Add track tables for ENCODE 3 TFBS Clusters track. refs #21139 diff --git src/hg/lib/clusterInputTrackTableEncode3Tfbs.sql src/hg/lib/clusterInputTrackTableEncode3Tfbs.sql new file mode 100644 index 0000000..f77c28a --- /dev/null +++ src/hg/lib/clusterInputTrackTableEncode3Tfbs.sql @@ -0,0 +1,17 @@ +# clusterInputTrackTableEncode3Tfbs.sql was originally generated by the autoSql program, which also +# generated clusterInputTrackTableEncode3Tfbs.c and clusterInputTrackTableEncode3Tfbs.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Information on tracks used as input for ENCODE 3 TFBS clusters track +CREATE TABLE clusterInputTrackTableEncode3Tfbs ( + tableName varchar(255) not null, # Name of table used as an input + source varchar(255) not null, # Unique identifier for source + factor varchar(255) not null, # Name of factor (gene) + antibody varchar(255) not null, # Antibody id (ENCABNNNXXX) + cellType varchar(255) not null, # Name of cell type + experiment varchar(255) not null, # Experiment id (ENCSRNNNXXX) + lab varchar(255) not null, # Lab where experiment performed + #Indices + PRIMARY KEY(tableName) +);