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