| 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> |