{scrollbar:icons=false} |
Topic: caArray Usage
Release: Up to caArray 2.2
Date entered: 03/06/2009
I did not see my sample organism on the Organism list. How can I add mine to the list?
"Organism" represents the source of sample biomaterial used in an experiment. It is one of the mandatory fields describing each caArray experiment. An initialization script, which is part of the caArray installation package, will insert the most commonly used organisms into caArray's database table: Organism. The organisms can then be selected from two drop-down lists in following sections:
If the organism list in caArray does not contain the organism for your samples, there are two other ways to add new organisms into caArray.
insert into organism (ncbi_taxonomy_id, common_name, scientific_name, taxonomy_rank, term_source) select 9606, 'human', 'Homo sapiens', 'species', id from term_source where term_source.name='ncbitax'; |
There are two fields that need to be clarified in this SQL statement:
Prior to any database modification, a database backup is highly recommended.
Please leave your comment in the caArray End User Forum.
{scrollbar:icons=false} |