Revision 4bbad921 hg19/makeDb.sql

b/hg19/makeDb.sql
30 30 
"GSM959044_1,GSM521901,GSM469970,GSM521897,GSM521895,GSM521913,GSM469974,GSM521889,GSM469968,E12_25_bothAc_dense",
31 31 
"Assay,Sample,Institution",
32 32 
"CYP4Z1\\nCYP2A7\\nCYP2A6\\nCYP3A4\\nCYP1A1\\nCYP4V2\\nCYP51A1\\nCYP2C19\\nCYP26B1\\nCYP11B2\\nCYP24A1\\nCYP4B1\\nCYP2C8",
33 
"3,http://vizhub.wustl.edu/hubSample/hg19/qual3.gz,1,http://vizhub.wustl.edu/hubSample/hg19/bed.gz,10,http://vizhub.wustl.edu/hubSample/hg19/K562POL2.gz,15,http://vizhub.wustl.edu/hubSample/hg19/sample.bigWig,100,http://vizhub.wustl.edu/hubSample/hg19/hub2.txt,18,http://vizhub.wustl.edu/hubSample/hg19/bam1.bam",
33 
"3,http://vizhub.wustl.edu/hubSample/hg19/qual3.gz,1,http://vizhub.wustl.edu/hubSample/hg19/bed.gz,10,http://vizhub.wustl.edu/hubSample/hg19/K562POL2.gz,15,http://vizhub.wustl.edu/hubSample/hg19/sample.bigWig,100,http://vizhub.wustl.edu/hubSample/hg19/hub.json,18,http://vizhub.wustl.edu/hubSample/hg19/bam1.bam",
34 34 
"chr7,27053398,chr7,27373766",
35 35 
"roadmapepigenome,longrange",
36 36 
"refGene,rmsk_ensemble",
......
282 282 
load data local infile "cytoband" into table cytoband;
283 283 

  		





  284
  284
  
    

  		





  285
  
  
    
drop table if exists publichub;


  		





  286
  
  
    
create table publichub (


  		





  287
  
  
    
  name varchar(255) not null,


  		





  288
  
  
    
  logo text null,


  		





  289
  
  
    
  url text not null,


  		





  290
  
  
    
  institution text not null,


  		





  291
  
  
    
  description text not null


  		





  292
  
  
    
);


  		





  293
  
  
    
-- load data local infile "publichub" into table publichub;


  		





  294
  285
  
    
/*


  		





  295
  286
  
    
DROP TABLE IF EXISTS `rmsk`;


  		





  296
  287
  
    
CREATE TABLE `rmsk` (


  		












Also available in:
  Unified diff