Difference between revisions of "Template:ChadoTable analysis"
From GMOD
(Table definition for Chado on 2010/11/24) |
(Table definition for Chado on 2010/11/24) |
||
| Line 29: | Line 29: | ||
{{ChadoTablesReferencingHeader|analysis}} | {{ChadoTablesReferencingHeader|analysis}} | ||
| − | + | {{ChadoReferencingTable|Companalysis|analysisfeature}} | |
| − | + | {{ChadoReferencingTable|Companalysis|analysisprop}} | |
| − | + | {{ChadoReferencingTable|Phylogeny|phylotree}} | |
| − | + | {{ChadoReferencingTable|Mage|quantification}} | |
</protect> | </protect> | ||
Latest revision as of 19:59, 24 November 2010
This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:
- The module page for the module the table is a part of. This is where updates and comments should be posted.
- The Chado Tables page, which lists all tables.
You can include this template anywhere you want to show the table description.
| Table: | analysis |
| Module: | Companalysis |
An analysis is a particular type of a
computational analysis; it may be a blast of one sequence against another, or an all by all blast, or a different kind of analysis altogether. It is a single unit of computation.
| FK | Name | Type | Description |
|---|---|---|---|
| analysis_id | serial | PRIMARY KEY | |
| name | character varying(255) | A way of grouping analyses. This
should be a handy short identifier that can help people find an analysis they want. For instance "tRNAscan", "cDNA", "FlyPep", "SwissProt", and it should not be assumed to be unique. For instance, there may be lots of separate analyses done against a cDNA database. | |
| description | text | ||
| program | character varying(255) | UNIQUE#1 NOT NULL | |
| programversion | character varying(255) | UNIQUE#1 NOT NULL | |
| algorithm | character varying(255) | Algorithm name, e.g. blast. | |
| sourcename | character varying(255) | UNIQUE#1 Source name, e.g. cDNA, SwissProt. | |
| sourceversion | character varying(255) | ||
| sourceuri | text | 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). | |
| timeexecuted | timestamp without time zone | NOT NULL DEFAULT now()
|
Tables referencing analysis via foreign key constraints:
