NEWS (6/9/2014): We added two new datasets: "Mouse Macrophages" and "Mouse Heart LD"
- Simple Search
- Advanced Search
- Probability
- Phase range
- Plots
- p-Value
- q-Value
- Period
- Phase


Welcome to the CIRCA help page. Here you will find all the information you need for a successful search.

Querying CircaDB

There are three modes of querying CircaDB: By gene symbol, Simple and Advanced. In all three modes using the wildcard character "*" is possible.

Simple Query Mode

This is the default. Simply enter a set of terms and the engine will query for each term separately, then join all of the results from each separate term together into the final result. In other words a query for kinase inhibitor will return all entries with the word kinase together with any entry that has inhibitor in their respective annotations.

This is usually not what one would want returned from such a query. This is where the advanced query mode comes in.

Advanced Query Mode

Once the "advanced query mode" check-box has been selected, the query strings are no longer simply split into individual queries. As the saying goes "with great power comes great responsibility". In a nutshell, you must now use the underlying Sphinx search engine's extended syntax query mode.

Briefly, the default behavior of the query kinase inhibitor would bring back all entries that match both kinase AND inhibitor. Instead of an implicit OR between terms, there is now an implicit AND between terms.

To bring back the OR behavior you would need to separate terms with a | (a vertical bar, or "pipe") character. E.g. kinase | inhibitor.

To bring back the specific phrase "kinase inhibitor", you would need to surround both words with quotes. E.g. "kinase inhibitor"

More examples

Query for the exact phrase "kinase inhibitor" that also make mention of "mitochondrial"
"kinase inhibitor" mitochondrial

Query for kinases, but not any entry with "inhibitor" in the record
kinase !inhibitor

Even more examples

Sphinx is a large a powerful system. You can review all of the various ways to use the extended syntax at the Sphinx extended query syntax help page

CircaDB Query Fields

Having read the above, you may be wondering what fields you can use to query CircaDB. The annotation is straight from the Affymetrix annotation files. We have pulled out certain columns from that file and indexed them as follows:

Field Description
probeset_name The Affymetrix probeset name
transcript_id The transcript ID
unigene_id Unigene ID
gene_symbol NCBI gene symbol
gene_title Full gene title
entrez_gene The Entrez gene ID
swissprot The SwisProt accession
refseq_protein_id The RefSeq protein accession
refseq_transcript_id The RefSeq NA sequence accession
target_description The description from the Affymetrix annotation file

Probability filter

The probability filter can be used to narrow the output to the most significant results. The database can be filtered for p-values and q-values produced by the different algorithms. The given value is used as the upper cutoff.

Phase range

The here specified range can be used to filter for genes that share the same phase. Only the phases computed by JTK are considered during this filter step.

Understanding the results

There are three different algorithms to statistically test if a dataset is cyclic or not. More information about these algorithms can be found in the About tab.

Note: For all the algorithms we tested cyclic behavior for a range of different periods, except for the DeLichtenberg were we only looked for a period of 24 hours.


As result we will see a plot, where the X-axis is the time in hours and the Y-axis reflects the expression levels measured on the individual gene chips. The background shaded areas represent the cycle of light and dark conditions based on CT times.



This statistical size, is the estimated probability of rejecting the null hypothesis. Here the null hypothesis is a dataset not being cyclic. The lower the p-value the more significant is the test result.


The q-value of a test is the minimum false discovery rate at which a gene is mistakenly called cyclic.


This value gives information on how often the cycle is repeated. Is the period 24 , the pattern reoccurs every 24 hours.


The phase reflects the timing in the individual tissues. The DeLichtenberg algorithm does not provide this value in its output.

Frequently asked questions

How do I select more than one experiment? "Ctrl+Right Click" lets you select multiple experiments ("Command+Right Click" for mac users)
How do I request a data set be added to CircaDB? Researchers can request that a particular data set be added by submitting an issue at our project page hosted at Github.

back to the top