WashU Epigenome Browser

-- ------------------

--

--     WashUGb

--

-- ------------------

drop table if exists dbTable;

create table dbTable (

  dbName varchar(255) not null,

  dbLabel varchar(255) not null,

  organism varchar(255) not null,

  -- font color to be used in genome list

  fontcolor char(10) not null,

  -- major reference genome of this species

  isMajor boolean not null,

  ToL text null

);

insert into dbTable values("hg19", "Human hg19", "human", 'white', true, 'Animalia');

insert into dbTable values("hg18", "Human hg18", "human", 'white', false, \N);

insert into dbTable values("danRer7", "Zebrafish danRer7", "zebrafish", 'white', true, 'Animalia');

insert into dbTable values("mm9", "Mouse mm9", "mouse", 'white', true, 'Animalia');

insert into dbTable values("mm10", "Mouse mm10", "mouse", 'white', false, \N);

insert into dbTable values("rn4", "Rat rn4", "rat", 'white', true, 'Animalia');

insert into dbTable values("dm3", "Fruit fly dm3", "fruit fly", 'white', true, 'Animalia');

insert into dbTable values("tair10", "Arabidopsis tair10", "arabidopsis", 'white', true, 'Plantae');

insert into dbTable values("AGPv2", "Maize AGPv2", "maize", 'white', true, 'Plantae');

insert into dbTable values("Gmax_189", "Soybean 189", "soybean", 'black', true, 'Plantae');

insert into dbTable values("Pvulgaris_218", "Common bean 218", "common bean", 'black', true, 'Plantae');

insert into dbTable values("rapa1_1", "Chinese cabbage v1.1", "cabbage", 'black', true, 'Plantae');

insert into dbTable values("spombe201203", "S. pombe 2012-03", "spombe", 'white', true, 'Fungi');

insert into dbTable values("AcNPV", "Autographa californica NPV", "AcNPV", 'white', true, 'Virus');

insert into dbTable values("temporal_day", "Temporal data at day precision", "temporal_day", 'white', true, 'Others');

-- insert into dbTable values("Am1", "Am1.0", "arabidopsis", 'white', true);