1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
--
-- Add extra terms used by Artemis with Chado
--
--
-- add term for evidence codes
--
INSERT INTO dbxref
( db_id, accession )
VALUES
( (SELECT db_id FROM db WHERE name = 'null'), 'Typically an evidence code' );
INSERT INTO cvterm
( cv_id, name, dbxref_id )
VALUES
( (SELECT cv_id FROM cv WHERE name ='feature_property'), 'evidence',
(SELECT dbxref_id FROM dbxref WHERE accession='Typically an evidence code') );
--
-- database used for controlled curation terms
--
INSERT INTO db ( name ) VALUES ( 'CCGEN' );
--
-- add terms for literature
--
INSERT INTO cv
( name, definition)
VALUES
( 'genedb_literature', 'terms for literature' );
INSERT INTO dbxref
( db_id, accession )
VALUES
( (SELECT db_id FROM db WHERE name = 'null'), 'unfetched literature type');
INSERT INTO dbxref
( db_id, accession )
VALUES
( (SELECT db_id FROM db WHERE name = 'null'), 'journal literature type' );
INSERT INTO dbxref
( db_id, accession )
VALUES
( (SELECT db_id FROM db WHERE name = 'null'), 'unknown literature type' );
INSERT INTO cvterm
( cv_id, name, dbxref_id )
VALUES
( (SELECT cv_id FROM cv WHERE name = 'genedb_literature'), 'unfetched',
(SELECT dbxref_id FROM dbxref WHERE accession='unfetched literature type') );
INSERT INTO cvterm
( cv_id, name, dbxref_id )
VALUES
( (SELECT cv_id FROM cv WHERE name = 'genedb_literature'), 'journal',
(SELECT dbxref_id FROM dbxref WHERE accession='journal literature type') );
INSERT INTO cvterm
( cv_id, name, dbxref_id )
VALUES
( (SELECT cv_id FROM cv WHERE name = 'genedb_literature'), 'unknown',
(SELECT dbxref_id FROM dbxref WHERE accession='unknown literature type') );
|
