Revision 4bbad921 dbTable.sql

b/dbTable.sql
11 11
  -- font color to be used in genome list
12 12
  fontcolor char(10) not null,
13 13
  -- major reference genome of this species
14
  isMajor boolean not null
14
  isMajor boolean not null,
15
  ToL text null
15 16
);
16 17

  
17
insert into dbTable values("hg19", "Human hg19", "human", 'white', true);
18
insert into dbTable values("hg18", "Human hg18", "human", 'white', false);
19
insert into dbTable values("danRer7", "Zebrafish danRer7", "zebrafish", 'white', true);
20
insert into dbTable values("mm9", "Mouse mm9", "mouse", 'white', true);
21
insert into dbTable values("mm10", "Mouse mm10", "mouse", 'white', false);
22
insert into dbTable values("rn4", "Rat rn4", "rat", 'white', true);
23
insert into dbTable values("dm3", "Fruit fly dm3", "fruit fly", 'white', true);
24
insert into dbTable values("tair10", "Arabidopsis tair10", "arabidopsis", 'white', true);
25
insert into dbTable values("AGPv2", "Maize AGPv2", "maize", 'white', true);
26
insert into dbTable values("spombe201203", "S. pombe 2012-03", "spombe", 'white', true);
27
-- insert into dbTable values("temporal_day", "Temporal data at day precision", "temporal_day", 'white', true);
18
insert into dbTable values("hg19", "Human hg19", "human", 'white', true, 'Animalia');
19
insert into dbTable values("hg18", "Human hg18", "human", 'white', false, \N);
20
insert into dbTable values("danRer7", "Zebrafish danRer7", "zebrafish", 'white', true, 'Animalia');
21
insert into dbTable values("mm9", "Mouse mm9", "mouse", 'white', true, 'Animalia');
22
insert into dbTable values("mm10", "Mouse mm10", "mouse", 'white', false, \N);
23
insert into dbTable values("rn4", "Rat rn4", "rat", 'white', true, 'Animalia');
24
insert into dbTable values("dm3", "Fruit fly dm3", "fruit fly", 'white', true, 'Animalia');
25
insert into dbTable values("tair10", "Arabidopsis tair10", "arabidopsis", 'white', true, 'Plantae');
26
insert into dbTable values("AGPv2", "Maize AGPv2", "maize", 'white', true, 'Plantae');
27
insert into dbTable values("Gmax_189", "Soybean 189", "soybean", 'black', true, 'Plantae');
28
insert into dbTable values("Pvulgaris_218", "Common bean 218", "common bean", 'black', true, 'Plantae');
29
insert into dbTable values("rapa1_1", "Chinese cabbage v1.1", "cabbage", 'black', true, 'Plantae');
30
insert into dbTable values("spombe201203", "S. pombe 2012-03", "spombe", 'white', true, 'Fungi');
31
insert into dbTable values("AcNPV", "Autographa californica NPV", "AcNPV", 'white', true, 'Virus');
32

  
33
insert into dbTable values("temporal_day", "Temporal data at day precision", "temporal_day", 'white', true, 'Others');
28 34
-- insert into dbTable values("Am1", "Am1.0", "arabidopsis", 'white', true);

Also available in: Unified diff