Statistics
| Branch: | Revision:

root / dbTable.sql @ 8c368a17

History | View | Annotate | Download (1.2 kB)

1 8c368a17 Daofeng Li 
-- ------------------
2 8c368a17 Daofeng Li 
--
3 8c368a17 Daofeng Li 
--     WashUGb
4 8c368a17 Daofeng Li 
--
5 8c368a17 Daofeng Li 
-- ------------------
6 8c368a17 Daofeng Li 
drop table if exists dbTable;
7 8c368a17 Daofeng Li 
create table dbTable (
8 8c368a17 Daofeng Li 
  dbName varchar(255) not null,
9 8c368a17 Daofeng Li 
  dbLabel varchar(255) not null,
10 8c368a17 Daofeng Li 
  organism varchar(255) not null,
11 8c368a17 Daofeng Li 
  -- font color to be used in genome list
12 8c368a17 Daofeng Li 
  fontcolor char(10) not null,
13 8c368a17 Daofeng Li 
  -- major reference genome of this species
14 8c368a17 Daofeng Li 
  isMajor boolean not null
15 8c368a17 Daofeng Li 
);
16 8c368a17 Daofeng Li 

      

      
    
      
      

        17
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("hg19", "Human hg19", "human", 'white', true);


      

      
    
      
      

        18
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("hg18", "Human hg18", "human", 'white', false);


      

      
    
      
      

        19
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("danRer7", "Zebrafish danRer7", "zebrafish", 'white', true);


      

      
    
      
      

        20
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("mm9", "Mouse mm9", "mouse", 'white', true);


      

      
    
      
      

        21
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("rn4", "Rat rn4", "rat", 'white', true);


      

      
    
      
      

        22
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("dm3", "Fruit fly dm3", "fruit fly", 'white', true);


      

      
    
      
      

        23
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("tair10", "Arabidopsis tair10", "arabidopsis", 'white', true);


      

      
    
      
      

        24
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("AGPv2", "Maize AGPv2", "maize", 'white', true);


      

      
    
      
      

        25
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("spombe201203", "S. pombe 2012-03", "spombe", 'white', true);


      

      
    
      
      

        26
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("temporal_day", "Temporal data at day precision", "temporal_day", 'white', true);


      

      
    
      
      

        27
        
        8c368a17
        Daofeng Li
        
insert into dbTable values("Am1", "Am1.0", "arabidopsis", 'white', true);