Debian Codegraph @

modules/companalysis/companalysis.html

raw
1 <!DOCTYPE html
2 PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4 <html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
5 <head>
6 <title>Description of Schema</title>
7 <meta name="generator" content="SQL::Translator::Producer::HTML" />
8 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
9 </head>
10 <body>
11
12
13 <h1 class="SchemaDescription">
14 Description of Schema
15 </h1>
16
17 <hr />
18
19 <!--
20 Table listing (8 tables)
21 -->
22
23 <a name="top" />
24
25 <table width="100%" class="LinkTable">
26
27 <tr>
28 <td class="LinkTableCell"><h2 class="LinkTableTitle">
29 Tables
30 </h2></td>
31 </tr>
32
33 <!--
34 Start link to table 'analysis'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="analysis-link" href="#analysis">analysis</a></td>
39 </tr>
40
41 <!--
42 End link to table 'analysis'
43 -->
44
45 <!--
46 Start link to table 'analysisprop'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="analysisprop-link" href="#analysisprop">analysisprop</a></td>
51 </tr>
52
53 <!--
54 End link to table 'analysisprop'
55 -->
56
57 <!--
58 Start link to table 'analysisfeature'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="analysisfeature-link" href="#analysisfeature">analysisfeature</a></td>
63 </tr>
64
65 <!--
66 End link to table 'analysisfeature'
67 -->
68
69 <!--
70 Start link to table 'analysisfeatureprop'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="analysisfeatureprop-link" href="#analysisfeatureprop">analysisfeatureprop</a></td>
75 </tr>
76
77 <!--
78 End link to table 'analysisfeatureprop'
79 -->
80
81 <!--
82 Start link to table 'analysis_dbxref'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="analysis_dbxref-link" href="#analysis_dbxref">analysis_dbxref</a></td>
87 </tr>
88
89 <!--
90 End link to table 'analysis_dbxref'
91 -->
92
93 <!--
94 Start link to table 'analysis_cvterm'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="analysis_cvterm-link" href="#analysis_cvterm">analysis_cvterm</a></td>
99 </tr>
100
101 <!--
102 End link to table 'analysis_cvterm'
103 -->
104
105 <!--
106 Start link to table 'analysis_relationship'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="analysis_relationship-link" href="#analysis_relationship">analysis_relationship</a></td>
111 </tr>
112
113 <!--
114 End link to table 'analysis_relationship'
115 -->
116
117 <!--
118 Start link to table 'analysis_pub'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="analysis_pub-link" href="#analysis_pub">analysis_pub</a></td>
123 </tr>
124
125 <!--
126 End link to table 'analysis_pub'
127 -->
128
129 </table>
130
131 <!--
132 Starting table 'analysis'
133 -->
134
135 <a name="analysis" />
136
137 <table width="100%" class="TableHeader">
138 <tr class="TableHeaderRow">
139 <td class="TableHeaderCell"><h3>
140 analysis
141 </h3></td> <a name="analysis"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
142 </tr>
143 </table>
144
145 <b>
146 Comments:
147 </b>
148
149 <br />
150
151 <em>
152 <br />
153 $Id: companalysis.sql,v 1.37 2007-03-23 15:18:02 scottcain Exp $ <br />
154 ========================================== <br />
155 Chado companalysis module <br />
156 ================================================================= <br />
157 Dependencies: <br />
158 :import feature from sequence <br />
159 :import cvterm from cv <br />
160 :import dbxref from db <br />
161 :import pub from pub <br />
162 ================================================================= <br />
163 ================================================ <br />
164 TABLE: analysis <br />
165 ================================================ <br />
166 An analysis is a particular type of a
167 computational analysis; it may be a blast of one sequence against
168 another, or an all by all blast, or a different kind of analysis
169 altogether. It is a single unit of computation.
170 </em>
171
172 <table border="1">
173
174 <tr>
175 <th class="FieldHeader">
176 Field Name
177 </th>
178 <th class="FieldHeader">
179 Data Type
180 </th>
181 <th class="FieldHeader">
182 Size
183 </th>
184 <th class="FieldHeader">
185 Default Value
186 </th>
187 <th class="FieldHeader">
188 Other
189 </th>
190 <th class="FieldHeader">
191 Foreign Key
192 </th>
193 </tr>
194
195 <tr class="tr-odd">
196 <td class="FieldCellName"><a name="analysis-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
197 </tr>
198
199 <tr class="tr-even">
200 <td class="FieldCellName"><a name="analysis-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">A way of grouping analyses. This
201 should be a handy short identifier that can help people find an
202 analysis they want. For instance "tRNAscan", "cDNA", "FlyPep",
203 "SwissProt", and it should not be assumed to be unique. For instance, there may be lots of separate analyses done against a cDNA database. </td> <td class="FieldCellFK"></td>
204 </tr>
205
206 <tr class="tr-odd">
207 <td class="FieldCellName"><a name="analysis-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
208 </tr>
209
210 <tr class="tr-even">
211 <td class="FieldCellName"><a name="analysis-program">program</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, Program name, e.g. blastx, blastp, sim4, genscan. </td> <td class="FieldCellFK"></td>
212 </tr>
213
214 <tr class="tr-odd">
215 <td class="FieldCellName"><a name="analysis-programversion">programversion</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, Version description, e.g. TBLASTX 2.0MP-WashU [09-Nov-2000]. </td> <td class="FieldCellFK"></td>
216 </tr>
217
218 <tr class="tr-even">
219 <td class="FieldCellName"><a name="analysis-algorithm">algorithm</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Algorithm name, e.g. blast. </td> <td class="FieldCellFK"></td>
220 </tr>
221
222 <tr class="tr-odd">
223 <td class="FieldCellName"><a name="analysis-sourcename">sourcename</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, Source name, e.g. cDNA, SwissProt. </td> <td class="FieldCellFK"></td>
224 </tr>
225
226 <tr class="tr-even">
227 <td class="FieldCellName"><a name="analysis-sourceversion">sourceversion</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
228 </tr>
229
230 <tr class="tr-odd">
231 <td class="FieldCellName"><a name="analysis-sourceuri">sourceuri</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">This is an optional, permanent URL or URI for the source of the analysis. The idea is that someone could recreate the analysis directly by going to this URI and fetching the source data (e.g. the blast database, or the training model). </td> <td class="FieldCellFK"></td>
232 </tr>
233
234 <tr class="tr-even">
235 <td class="FieldCellName"><a name="analysis-timeexecuted">timeexecuted</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
236 </tr>
237
238 </table>
239
240 <h3>
241 Constraints
242 </h3>
243
244 <table border="1">
245
246 <tr class="IndexRow">
247 <th>
248 Type
249 </th>
250 <th>
251 Fields
252 </th>
253 </tr>
254
255 <tr class="IndexCell">
256 <td>NOT NULL</td><td>analysis_id</td>
257 </tr>
258
259 <tr class="IndexCell">
260 <td>NOT NULL</td><td>program</td>
261 </tr>
262
263 <tr class="IndexCell">
264 <td>NOT NULL</td><td>programversion</td>
265 </tr>
266
267 <tr class="IndexCell">
268 <td>NOT NULL</td><td>timeexecuted</td>
269 </tr>
270
271 <tr class="IndexCell">
272 <td>UNIQUE</td><td>program, programversion, sourcename</td>
273 </tr>
274
275 </table>
276
277 <hr />
278
279 <!--
280 Starting table 'analysisprop'
281 -->
282
283 <a name="analysisprop" />
284
285 <table width="100%" class="TableHeader">
286 <tr class="TableHeaderRow">
287 <td class="TableHeaderCell"><h3>
288 analysisprop
289 </h3></td> <a name="analysisprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
290 </tr>
291 </table>
292
293 <b>
294 Comments:
295 </b>
296
297 <br />
298
299 <em>
300 <br />
301 ================================================ <br />
302 TABLE: analysisprop <br />
303 ================================================
304 </em>
305
306 <table border="1">
307
308 <tr>
309 <th class="FieldHeader">
310 Field Name
311 </th>
312 <th class="FieldHeader">
313 Data Type
314 </th>
315 <th class="FieldHeader">
316 Size
317 </th>
318 <th class="FieldHeader">
319 Default Value
320 </th>
321 <th class="FieldHeader">
322 Other
323 </th>
324 <th class="FieldHeader">
325 Foreign Key
326 </th>
327 </tr>
328
329 <tr class="tr-odd">
330 <td class="FieldCellName"><a name="analysisprop-analysisprop_id">analysisprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
331 </tr>
332
333 <tr class="tr-even">
334 <td class="FieldCellName"><a name="analysisprop-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
335 </tr>
336
337 <tr class="tr-odd">
338 <td class="FieldCellName"><a name="analysisprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
339 </tr>
340
341 <tr class="tr-even">
342 <td class="FieldCellName"><a name="analysisprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
343 </tr>
344
345 <tr class="tr-odd">
346 <td class="FieldCellName"><a name="analysisprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
347 </tr>
348
349 </table>
350
351 <h3>
352 Indices
353 </h3>
354
355 <table border="1">
356
357 <tr class="IndexRow">
358 <th>
359 Name
360 </th>
361 <th>
362 Fields
363 </th>
364 </tr>
365
366 <tr class="IndexCell">
367 <td>analysisprop_idx1</td><td>analysis_id</td>
368 </tr>
369
370 <tr class="IndexCell">
371 <td>analysisprop_idx2</td><td>type_id</td>
372 </tr>
373
374 </table>
375
376 <h3>
377 Constraints
378 </h3>
379
380 <table border="1">
381
382 <tr class="IndexRow">
383 <th>
384 Type
385 </th>
386 <th>
387 Fields
388 </th>
389 </tr>
390
391 <tr class="IndexCell">
392 <td>NOT NULL</td><td>analysisprop_id</td>
393 </tr>
394
395 <tr class="IndexCell">
396 <td>NOT NULL</td><td>analysis_id</td>
397 </tr>
398
399 <tr class="IndexCell">
400 <td>FOREIGN KEY</td><td>analysis_id</td>
401 </tr>
402
403 <tr class="IndexCell">
404 <td>NOT NULL</td><td>type_id</td>
405 </tr>
406
407 <tr class="IndexCell">
408 <td>FOREIGN KEY</td><td>type_id</td>
409 </tr>
410
411 <tr class="IndexCell">
412 <td>NOT NULL</td><td>rank</td>
413 </tr>
414
415 <tr class="IndexCell">
416 <td>UNIQUE</td><td>analysis_id, type_id, rank</td>
417 </tr>
418
419 </table>
420
421 <hr />
422
423 <!--
424 Starting table 'analysisfeature'
425 -->
426
427 <a name="analysisfeature" />
428
429 <table class="TableHeader" width="100%">
430 <tr class="TableHeaderRow">
431 <td class="TableHeaderCell"><h3>
432 analysisfeature
433 </h3></td> <a name="analysisfeature"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
434 </tr>
435 </table>
436
437 <b>
438 Comments:
439 </b>
440
441 <br />
442
443 <em>
444 <br />
445 ================================================ <br />
446 TABLE: analysisfeature <br />
447 ================================================ <br />
448 Computational analyses generate features (e.g. Genscan generates transcripts and exons; sim4 alignments generate similarity/match features). analysisfeatures are stored using the feature table from the sequence module. The analysisfeature table is used to decorate these features, with analysis specific attributes. A feature is an analysisfeature if and only if there is a corresponding entry in the analysisfeature table. analysisfeatures will have two or more featureloc entries,
449 with rank indicating query/subject
450 </em>
451
452 <table border="1">
453
454 <tr>
455 <th class="FieldHeader">
456 Field Name
457 </th>
458 <th class="FieldHeader">
459 Data Type
460 </th>
461 <th class="FieldHeader">
462 Size
463 </th>
464 <th class="FieldHeader">
465 Default Value
466 </th>
467 <th class="FieldHeader">
468 Other
469 </th>
470 <th class="FieldHeader">
471 Foreign Key
472 </th>
473 </tr>
474
475 <tr class="tr-odd">
476 <td class="FieldCellName"><a name="analysisfeature-analysisfeature_id">analysisfeature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
477 </tr>
478
479 <tr class="tr-even">
480 <td class="FieldCellName"><a name="analysisfeature-feature_id">feature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
481 </tr>
482
483 <tr class="tr-odd">
484 <td class="FieldCellName"><a name="analysisfeature-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
485 </tr>
486
487 <tr class="tr-even">
488 <td class="FieldCellName"><a name="analysisfeature-rawscore">rawscore</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">This is the native score generated by the program; for example, the bitscore generated by blast, sim4 or genscan scores. One should not assume that high is necessarily better than low. </td> <td class="FieldCellFK"></td>
489 </tr>
490
491 <tr class="tr-odd">
492 <td class="FieldCellName"><a name="analysisfeature-normscore">normscore</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">This is the rawscore but
493 semi-normalized. Complete normalization to allow comparison of
494 features generated by different programs would be nice but too
495 difficult. Instead the normalization should strive to enforce the
496 following semantics: * normscores are floating point numbers >= 0,
497 * high normscores are better than low one. For most programs, it would be sufficient to make the normscore the same as this rawscore, providing these semantics are satisfied. </td> <td class="FieldCellFK"></td>
498 </tr>
499
500 <tr class="tr-even">
501 <td class="FieldCellName"><a name="analysisfeature-significance">significance</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">This is some kind of expectation or probability metric, representing the probability that the analysis would appear randomly given the model. As such, any program or person querying this table can assume the following semantics:
502 * 0 <= significance <= n, where n is a positive number, theoretically unbounded but unlikely to be more than 10
503 * low numbers are better than high numbers. </td> <td class="FieldCellFK"></td>
504 </tr>
505
506 <tr class="tr-odd">
507 <td class="FieldCellName"><a name="analysisfeature-identity">identity</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Percent identity between the locations compared. Note that these 4 metrics do not cover the full range of scores possible; it would be undesirable to list every score possible, as this should be kept extensible. instead, for non-standard scores, use the analysisprop table. </td> <td class="FieldCellFK"></td>
508 </tr>
509
510 </table>
511
512 <h3>
513 Indices
514 </h3>
515
516 <table border="1">
517
518 <tr class="IndexRow">
519 <th>
520 Name
521 </th>
522 <th>
523 Fields
524 </th>
525 </tr>
526
527 <tr class="IndexCell">
528 <td>analysisfeature_idx1</td><td>feature_id</td>
529 </tr>
530
531 <tr class="IndexCell">
532 <td>analysisfeature_idx2</td><td>analysis_id</td>
533 </tr>
534
535 </table>
536
537 <h3>
538 Constraints
539 </h3>
540
541 <table border="1">
542
543 <tr class="IndexRow">
544 <th>
545 Type
546 </th>
547 <th>
548 Fields
549 </th>
550 </tr>
551
552 <tr class="IndexCell">
553 <td>NOT NULL</td><td>analysisfeature_id</td>
554 </tr>
555
556 <tr class="IndexCell">
557 <td>NOT NULL</td><td>feature_id</td>
558 </tr>
559
560 <tr class="IndexCell">
561 <td>FOREIGN KEY</td><td>feature_id</td>
562 </tr>
563
564 <tr class="IndexCell">
565 <td>NOT NULL</td><td>analysis_id</td>
566 </tr>
567
568 <tr class="IndexCell">
569 <td>FOREIGN KEY</td><td>analysis_id</td>
570 </tr>
571
572 <tr class="IndexCell">
573 <td>UNIQUE</td><td>feature_id, analysis_id</td>
574 </tr>
575
576 </table>
577
578 <hr />
579
580 <!--
581 Starting table 'analysisfeatureprop'
582 -->
583
584 <a name="analysisfeatureprop" />
585
586 <table width="100%" class="TableHeader">
587 <tr class="TableHeaderRow">
588 <td class="TableHeaderCell"><h3>
589 analysisfeatureprop
590 </h3></td> <a name="analysisfeatureprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
591 </tr>
592 </table>
593
594 <b>
595 Comments:
596 </b>
597
598 <br />
599
600 <em>
601 <br />
602 ================================================ <br />
603 TABLE: analysisfeatureprop <br />
604 ================================================
605 </em>
606
607 <table border="1">
608
609 <tr>
610 <th class="FieldHeader">
611 Field Name
612 </th>
613 <th class="FieldHeader">
614 Data Type
615 </th>
616 <th class="FieldHeader">
617 Size
618 </th>
619 <th class="FieldHeader">
620 Default Value
621 </th>
622 <th class="FieldHeader">
623 Other
624 </th>
625 <th class="FieldHeader">
626 Foreign Key
627 </th>
628 </tr>
629
630 <tr class="tr-odd">
631 <td class="FieldCellName"><a name="analysisfeatureprop-analysisfeatureprop_id">analysisfeatureprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
632 </tr>
633
634 <tr class="tr-even">
635 <td class="FieldCellName"><a name="analysisfeatureprop-analysisfeature_id">analysisfeature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysisfeature-analysisfeature_id">analysisfeature.analysisfeature_id</a></td>
636 </tr>
637
638 <tr class="tr-odd">
639 <td class="FieldCellName"><a name="analysisfeatureprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
640 </tr>
641
642 <tr class="tr-even">
643 <td class="FieldCellName"><a name="analysisfeatureprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
644 </tr>
645
646 <tr class="tr-odd">
647 <td class="FieldCellName"><a name="analysisfeatureprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
648 </tr>
649
650 </table>
651
652 <h3>
653 Indices
654 </h3>
655
656 <table border="1">
657
658 <tr class="IndexRow">
659 <th>
660 Name
661 </th>
662 <th>
663 Fields
664 </th>
665 </tr>
666
667 <tr class="IndexCell">
668 <td>analysisfeatureprop_idx1</td><td>analysisfeature_id</td>
669 </tr>
670
671 <tr class="IndexCell">
672 <td>analysisfeatureprop_idx2</td><td>type_id</td>
673 </tr>
674
675 </table>
676
677 <h3>
678 Constraints
679 </h3>
680
681 <table border="1">
682
683 <tr class="IndexRow">
684 <th>
685 Type
686 </th>
687 <th>
688 Fields
689 </th>
690 </tr>
691
692 <tr class="IndexCell">
693 <td>NOT NULL</td><td>analysisfeature_id</td>
694 </tr>
695
696 <tr class="IndexCell">
697 <td>FOREIGN KEY</td><td>analysisfeature_id</td>
698 </tr>
699
700 <tr class="IndexCell">
701 <td>NOT NULL</td><td>type_id</td>
702 </tr>
703
704 <tr class="IndexCell">
705 <td>FOREIGN KEY</td><td>type_id</td>
706 </tr>
707
708 <tr class="IndexCell">
709 <td>NOT NULL</td><td>rank</td>
710 </tr>
711
712 <tr class="IndexCell">
713 <td>UNIQUE</td><td>analysisfeature_id, type_id, rank</td>
714 </tr>
715
716 <tr class="IndexCell">
717 <td>FOREIGN KEY</td><td>analysisfeature_id</td>
718 </tr>
719
720 <tr class="IndexCell">
721 <td>FOREIGN KEY</td><td>type_id</td>
722 </tr>
723
724 </table>
725
726 <hr />
727
728 <!--
729 Starting table 'analysis_dbxref'
730 -->
731
732 <a name="analysis_dbxref" />
733
734 <table class="TableHeader" width="100%">
735 <tr class="TableHeaderRow">
736 <td class="TableHeaderCell"><h3>
737 analysis_dbxref
738 </h3></td> <a name="analysis_dbxref"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
739 </tr>
740 </table>
741
742 <b>
743 Comments:
744 </b>
745
746 <br />
747
748 <em>
749 <br />
750 ================================================ <br />
751 TABLE: analysis_dbxref <br />
752 ================================================ <br />
753 Links an analysis to dbxrefs.
754 </em>
755
756 <table border="1">
757
758 <tr>
759 <th class="FieldHeader">
760 Field Name
761 </th>
762 <th class="FieldHeader">
763 Data Type
764 </th>
765 <th class="FieldHeader">
766 Size
767 </th>
768 <th class="FieldHeader">
769 Default Value
770 </th>
771 <th class="FieldHeader">
772 Other
773 </th>
774 <th class="FieldHeader">
775 Foreign Key
776 </th>
777 </tr>
778
779 <tr class="tr-odd">
780 <td class="FieldCellName"><a name="analysis_dbxref-analysis_dbxref_id">analysis_dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
781 </tr>
782
783 <tr class="tr-even">
784 <td class="FieldCellName"><a name="analysis_dbxref-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
785 </tr>
786
787 <tr class="tr-odd">
788 <td class="FieldCellName"><a name="analysis_dbxref-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
789 </tr>
790
791 <tr class="tr-even">
792 <td class="FieldCellName"><a name="analysis_dbxref-is_current">is_current</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">true</td> <td class="FieldCellOther">NOT NULL, True if this dbxref
793 is the most up to date accession in the corresponding db. Retired
794 accessions should set this field to false </td> <td class="FieldCellFK"></td>
795 </tr>
796
797 </table>
798
799 <h3>
800 Indices
801 </h3>
802
803 <table border="1">
804
805 <tr class="IndexRow">
806 <th>
807 Name
808 </th>
809 <th>
810 Fields
811 </th>
812 </tr>
813
814 <tr class="IndexCell">
815 <td>analysis_dbxref_idx1</td><td>analysis_id</td>
816 </tr>
817
818 <tr class="IndexCell">
819 <td>analysis_dbxref_idx2</td><td>dbxref_id</td>
820 </tr>
821
822 </table>
823
824 <h3>
825 Constraints
826 </h3>
827
828 <table border="1">
829
830 <tr class="IndexRow">
831 <th>
832 Type
833 </th>
834 <th>
835 Fields
836 </th>
837 </tr>
838
839 <tr class="IndexCell">
840 <td>NOT NULL</td><td>analysis_dbxref_id</td>
841 </tr>
842
843 <tr class="IndexCell">
844 <td>NOT NULL</td><td>analysis_id</td>
845 </tr>
846
847 <tr class="IndexCell">
848 <td>NOT NULL</td><td>dbxref_id</td>
849 </tr>
850
851 <tr class="IndexCell">
852 <td>NOT NULL</td><td>is_current</td>
853 </tr>
854
855 <tr class="IndexCell">
856 <td>FOREIGN KEY</td><td>analysis_id</td>
857 </tr>
858
859 <tr class="IndexCell">
860 <td>FOREIGN KEY</td><td>dbxref_id</td>
861 </tr>
862
863 <tr class="IndexCell">
864 <td>UNIQUE</td><td>analysis_id, dbxref_id</td>
865 </tr>
866
867 </table>
868
869 <hr />
870
871 <!--
872 Starting table 'analysis_cvterm'
873 -->
874
875 <a name="analysis_cvterm" />
876
877 <table width="100%" class="TableHeader">
878 <tr class="TableHeaderRow">
879 <td class="TableHeaderCell"><h3>
880 analysis_cvterm
881 </h3></td> <a name="analysis_cvterm"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
882 </tr>
883 </table>
884
885 <b>
886 Comments:
887 </b>
888
889 <br />
890
891 <em>
892 <br />
893 ================================================ <br />
894 TABLE: analysis_cvterm <br />
895 ================================================ <br />
896 Associate a term from a cv with an analysis.
897 </em>
898
899 <table border="1">
900
901 <tr>
902 <th class="FieldHeader">
903 Field Name
904 </th>
905 <th class="FieldHeader">
906 Data Type
907 </th>
908 <th class="FieldHeader">
909 Size
910 </th>
911 <th class="FieldHeader">
912 Default Value
913 </th>
914 <th class="FieldHeader">
915 Other
916 </th>
917 <th class="FieldHeader">
918 Foreign Key
919 </th>
920 </tr>
921
922 <tr class="tr-odd">
923 <td class="FieldCellName"><a name="analysis_cvterm-analysis_cvterm_id">analysis_cvterm_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
924 </tr>
925
926 <tr class="tr-even">
927 <td class="FieldCellName"><a name="analysis_cvterm-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
928 </tr>
929
930 <tr class="tr-odd">
931 <td class="FieldCellName"><a name="analysis_cvterm-cvterm_id">cvterm_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
932 </tr>
933
934 <tr class="tr-even">
935 <td class="FieldCellName"><a name="analysis_cvterm-is_not">is_not</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, If this is set to true, then this
936 annotation is interpreted as a NEGATIVE annotation - i.e. the analysis does
937 NOT have the specified term. </td> <td class="FieldCellFK"></td>
938 </tr>
939
940 <tr class="tr-odd">
941 <td class="FieldCellName"><a name="analysis_cvterm-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
942 </tr>
943
944 </table>
945
946 <h3>
947 Indices
948 </h3>
949
950 <table border="1">
951
952 <tr class="IndexRow">
953 <th>
954 Name
955 </th>
956 <th>
957 Fields
958 </th>
959 </tr>
960
961 <tr class="IndexCell">
962 <td>analysis_cvterm_idx1</td><td>analysis_id</td>
963 </tr>
964
965 <tr class="IndexCell">
966 <td>analysis_cvterm_idx2</td><td>cvterm_id</td>
967 </tr>
968
969 </table>
970
971 <h3>
972 Constraints
973 </h3>
974
975 <table border="1">
976
977 <tr class="IndexRow">
978 <th>
979 Type
980 </th>
981 <th>
982 Fields
983 </th>
984 </tr>
985
986 <tr class="IndexCell">
987 <td>NOT NULL</td><td>analysis_cvterm_id</td>
988 </tr>
989
990 <tr class="IndexCell">
991 <td>NOT NULL</td><td>analysis_id</td>
992 </tr>
993
994 <tr class="IndexCell">
995 <td>NOT NULL</td><td>cvterm_id</td>
996 </tr>
997
998 <tr class="IndexCell">
999 <td>NOT NULL</td><td>is_not</td>
1000 </tr>
1001
1002 <tr class="IndexCell">
1003 <td>NOT NULL</td><td>rank</td>
1004 </tr>
1005
1006 <tr class="IndexCell">
1007 <td>FOREIGN KEY</td><td>analysis_id</td>
1008 </tr>
1009
1010 <tr class="IndexCell">
1011 <td>FOREIGN KEY</td><td>cvterm_id</td>
1012 </tr>
1013
1014 <tr class="IndexCell">
1015 <td>UNIQUE</td><td>analysis_id, cvterm_id, rank</td>
1016 </tr>
1017
1018 </table>
1019
1020 <hr />
1021
1022 <!--
1023 Starting table 'analysis_relationship'
1024 -->
1025
1026 <a name="analysis_relationship" />
1027
1028 <table class="TableHeader" width="100%">
1029 <tr class="TableHeaderRow">
1030 <td class="TableHeaderCell"><h3>
1031 analysis_relationship
1032 </h3></td> <a name="analysis_relationship"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1033 </tr>
1034 </table>
1035
1036 <b>
1037 Comments:
1038 </b>
1039
1040 <br />
1041
1042 <em>
1043 <br />
1044 ================================================ <br />
1045 TABLE: analysis_relationship <br />
1046 ================================================
1047 </em>
1048
1049 <table border="1">
1050
1051 <tr>
1052 <th class="FieldHeader">
1053 Field Name
1054 </th>
1055 <th class="FieldHeader">
1056 Data Type
1057 </th>
1058 <th class="FieldHeader">
1059 Size
1060 </th>
1061 <th class="FieldHeader">
1062 Default Value
1063 </th>
1064 <th class="FieldHeader">
1065 Other
1066 </th>
1067 <th class="FieldHeader">
1068 Foreign Key
1069 </th>
1070 </tr>
1071
1072 <tr class="tr-odd">
1073 <td class="FieldCellName"><a name="analysis_relationship-analysis_relationship_id">analysis_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1074 </tr>
1075
1076 <tr class="tr-even">
1077 <td class="FieldCellName"><a name="analysis_relationship-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, analysis_relationship.subject_id i
1078 s the subject of the subj-predicate-obj sentence. </td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
1079 </tr>
1080
1081 <tr class="tr-odd">
1082 <td class="FieldCellName"><a name="analysis_relationship-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, analysis_relationship.object_id
1083 is the object of the subj-predicate-obj sentence. </td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
1084 </tr>
1085
1086 <tr class="tr-even">
1087 <td class="FieldCellName"><a name="analysis_relationship-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, analysis_relationship.type_id
1088 is relationship type between subject and object. This is a cvterm, typically
1089 from the OBO relationship ontology, although other relationship types are allowed. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1090 </tr>
1091
1092 <tr class="tr-odd">
1093 <td class="FieldCellName"><a name="analysis_relationship-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">analysis_relationship.value
1094 is for additional notes or comments. </td> <td class="FieldCellFK"></td>
1095 </tr>
1096
1097 <tr class="tr-even">
1098 <td class="FieldCellName"><a name="analysis_relationship-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL, analysis_relationship.rank is
1099 the ordering of subject analysiss with respect to the object analysis may be
1100 important where rank is used to order these; starts from zero. </td> <td class="FieldCellFK"></td>
1101 </tr>
1102
1103 </table>
1104
1105 <h3>
1106 Indices
1107 </h3>
1108
1109 <table border="1">
1110
1111 <tr class="IndexRow">
1112 <th>
1113 Name
1114 </th>
1115 <th>
1116 Fields
1117 </th>
1118 </tr>
1119
1120 <tr class="IndexCell">
1121 <td>analysis_relationship_idx1</td><td>subject_id</td>
1122 </tr>
1123
1124 <tr class="IndexCell">
1125 <td>analysis_relationship_idx2</td><td>object_id</td>
1126 </tr>
1127
1128 <tr class="IndexCell">
1129 <td>analysis_relationship_idx3</td><td>type_id</td>
1130 </tr>
1131
1132 </table>
1133
1134 <h3>
1135 Constraints
1136 </h3>
1137
1138 <table border="1">
1139
1140 <tr class="IndexRow">
1141 <th>
1142 Type
1143 </th>
1144 <th>
1145 Fields
1146 </th>
1147 </tr>
1148
1149 <tr class="IndexCell">
1150 <td>NOT NULL</td><td>analysis_relationship_id</td>
1151 </tr>
1152
1153 <tr class="IndexCell">
1154 <td>NOT NULL</td><td>subject_id</td>
1155 </tr>
1156
1157 <tr class="IndexCell">
1158 <td>NOT NULL</td><td>object_id</td>
1159 </tr>
1160
1161 <tr class="IndexCell">
1162 <td>NOT NULL</td><td>type_id</td>
1163 </tr>
1164
1165 <tr class="IndexCell">
1166 <td>NOT NULL</td><td>rank</td>
1167 </tr>
1168
1169 <tr class="IndexCell">
1170 <td>FOREIGN KEY</td><td>subject_id</td>
1171 </tr>
1172
1173 <tr class="IndexCell">
1174 <td>FOREIGN KEY</td><td>object_id</td>
1175 </tr>
1176
1177 <tr class="IndexCell">
1178 <td>FOREIGN KEY</td><td>type_id</td>
1179 </tr>
1180
1181 <tr class="IndexCell">
1182 <td>UNIQUE</td><td>subject_id, object_id, type_id, rank</td>
1183 </tr>
1184
1185 </table>
1186
1187 <hr />
1188
1189 <!--
1190 Starting table 'analysis_pub'
1191 -->
1192
1193 <a name="analysis_pub" />
1194
1195 <table class="TableHeader" width="100%">
1196 <tr class="TableHeaderRow">
1197 <td class="TableHeaderCell"><h3>
1198 analysis_pub
1199 </h3></td> <a name="analysis_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1200 </tr>
1201 </table>
1202
1203 <b>
1204 Comments:
1205 </b>
1206
1207 <br />
1208
1209 <em>
1210 <br />
1211 ================================================ <br />
1212 TABLE: analysis_pub <br />
1213 ================================================ <br />
1214 Provenance. Linking table between analyses and the publications that mention them.
1215 </em>
1216
1217 <table border="1">
1218
1219 <tr>
1220 <th class="FieldHeader">
1221 Field Name
1222 </th>
1223 <th class="FieldHeader">
1224 Data Type
1225 </th>
1226 <th class="FieldHeader">
1227 Size
1228 </th>
1229 <th class="FieldHeader">
1230 Default Value
1231 </th>
1232 <th class="FieldHeader">
1233 Other
1234 </th>
1235 <th class="FieldHeader">
1236 Foreign Key
1237 </th>
1238 </tr>
1239
1240 <tr class="tr-odd">
1241 <td class="FieldCellName"><a name="analysis_pub-analysis_pub_id">analysis_pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1242 </tr>
1243
1244 <tr class="tr-even">
1245 <td class="FieldCellName"><a name="analysis_pub-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
1246 </tr>
1247
1248 <tr class="tr-odd">
1249 <td class="FieldCellName"><a name="analysis_pub-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
1250 </tr>
1251
1252 </table>
1253
1254 <h3>
1255 Indices
1256 </h3>
1257
1258 <table border="1">
1259
1260 <tr class="IndexRow">
1261 <th>
1262 Name
1263 </th>
1264 <th>
1265 Fields
1266 </th>
1267 </tr>
1268
1269 <tr class="IndexCell">
1270 <td>analysis_pub_idx1</td><td>analysis_id</td>
1271 </tr>
1272
1273 <tr class="IndexCell">
1274 <td>analysis_pub_idx2</td><td>pub_id</td>
1275 </tr>
1276
1277 </table>
1278
1279 <h3>
1280 Constraints
1281 </h3>
1282
1283 <table border="1">
1284
1285 <tr class="IndexRow">
1286 <th>
1287 Type
1288 </th>
1289 <th>
1290 Fields
1291 </th>
1292 </tr>
1293
1294 <tr class="IndexCell">
1295 <td>NOT NULL</td><td>analysis_pub_id</td>
1296 </tr>
1297
1298 <tr class="IndexCell">
1299 <td>NOT NULL</td><td>analysis_id</td>
1300 </tr>
1301
1302 <tr class="IndexCell">
1303 <td>FOREIGN KEY</td><td>analysis_id</td>
1304 </tr>
1305
1306 <tr class="IndexCell">
1307 <td>NOT NULL</td><td>pub_id</td>
1308 </tr>
1309
1310 <tr class="IndexCell">
1311 <td>FOREIGN KEY</td><td>pub_id</td>
1312 </tr>
1313
1314 <tr class="IndexCell">
1315 <td>UNIQUE</td><td>analysis_id, pub_id</td>
1316 </tr>
1317
1318 </table>
1319
1320 <hr />
1321
1322 Created by <a href="http://sqlfairy.sourceforge.net">
1323 SQL::Translator 0.11020</a>
1324
1325 </body>
1326 </html>