Template:ChadoTable analysis

From GMOD
Jump to: navigation, search

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:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. 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.
analysis columns
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
Program name, e.g. blastx, blastp, sim4, genscan.

programversion character varying(255) UNIQUE#1

NOT NULL
Version description, e.g. TBLASTX 2.0MP-WashU [09-Nov-2000].

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: