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

);

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

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

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

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

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

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

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

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

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

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

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