ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/msatfinder/schema.sql
Revision: 1.1.1.1 (vendor branch)
Committed: Mon Mar 7 15:34:46 2005 UTC (11 years, 5 months ago) by knirirr
Branch: MAIN
CVS Tags: HEAD, HEAD
Changes since 1.1: +0 -0 lines
Log Message:
First import

Line File contents
1 drop table if exists genomes;
2 create table genomes (
3 genome varchar(15) NOT NULL,
4 PRIMARY KEY (genome),
5 specific_taxon text,
6 generic_taxon text,
7 division varchar(3),
8 strand varchar(2),
9 alphabet varchar(4),
10 circular varchar(8),
11 submit_date text,
12 binomial text,
13 genus text,
14 species text,
15 strain_or_subspecies text,
16 specific_host text,
17 lab_host text,
18 taxid varchar(15),
19 notes text,
20 common_name text,
21 organism text,
22 definition text,
23 genome_length Integer default NULL,
24 total_nt_coding Integer default NULL,
25 percent_coding float default NULL,
26 GC_content float default NULL,
27 No_of_coding_regions Integer,
28 A Integer,
29 T Integer,
30 G Integer,
31 C Integer,
32 Askew float default NULL,
33 Cskew float default NULL,
34 total_rep_length Integer,
35 pc_repeats float default NULL,
36 msats integer,
37 No_of_msats Integer,
38 percent_coding_msats float default NULL
39 );
40 drop table if exists repeats;
41 create table repeats (
42 repeat_name varchar(30) NOT NULL,
43 PRIMARY KEY (repeat_name),
44 genome text,
45 specific_taxon text,
46 generic_taxon text,
47 division varchar(3),
48 strand varchar(2),
49 alphabet varchar(4),
50 circular varchar(8),
51 submit_date text,
52 binomial text,
53 genus text,
54 species text,
55 strain_or_subspecies text,
56 specific_host text,
57 lab_host text,
58 taxid varchar(15),
59 notes text,
60 common_name text,
61 organism text,
62 definition text,
63 genome_length Integer default NULL,
64 flank_length Integer default NULL,
65 repeat_plus_flank Integer default NULL,
66 rep_start Integer default NULL,
67 rep_stop Integer default NULL,
68 repeat varchar(12),
69 motif varchar(6),
70 motif_revcom varchar(6),
71 footprint Integer,
72 repeat_units Integer,
73 dist_from_left Integer,
74 pc_from_left float,
75 dist_from_right Integer,
76 pc_from_right float,
77 repeat_type text,
78 total_nt_coding Integer default NULL,
79 percent_coding float default NULL,
80 coding_repeat text,
81 gene text,
82 protein text,
83 product text,
84 reverse Integer default NULL,
85 primers Integer default NULL,
86 GC_content_genome float default NULL,
87 GC_content_flank float default NULL,
88 GC_content_repeat float default NULL,
89 No_of_coding_regions Integer
90 );
91 drop table if exists artemis;
92 create table artemis (
93 filename varchar(36) NOT NULL,
94 PRIMARY KEY (filename),
95 genome text,
96 data text
97 );
98 drop table if exists mine;
99 create table mine (
100 filename varchar(36) NOT NULL,
101 PRIMARY KEY (filename),
102 genome text,
103 data text
104 );
105 drop table if exists primers;
106 create table primers (
107 filename varchar(36) NOT NULL,
108 PRIMARY KEY (filename),
109 genome text,
110 data text
111 );
112 drop table if exists fasta;
113 create table fasta (
114 filename varchar(36) NOT NULL,
115 PRIMARY KEY (filename),
116 genome text,
117 data text
118 );
119 drop table if exists repeatfiles;
120 create table repeatfiles (
121 filename varchar(36) NOT NULL,
122 PRIMARY KEY (filename),
123 data text
124 );