Question: How do I add an organism to the Organism List in caArray?

Topic: caArray Usage

Release: Up to caArray 2.2

Date entered: 03/06/2009

Details about the Question

I did not see my sample organism on the Organism list. How can I add mine to the list?

Answer

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

Manually Adding Organism

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.

Have a comment?

Please leave your comment in the caArray End User Forum.