CATMA: A Complete Arabidopsis transcriptome Microarray

Simple search | Advanced search | Multiple search | Homology search | Multiple homology search | Help

Advanced database search

You may construct your own SQL database queries for more flexible searches via this page. Queries can be made specific or general, and may return multiple records unlike some of the other search pages. Interactive queries will be returned as a table on the result web page with a maximum of 100 lines per page. E-mail queries will return all matched lines as a tab-delimited text file. Please note that only SELECT statements are allowed (i.e. you are be able to search the database, not to alter it). A diagram of the database structure is displayed in the Help page to help you phrase your queries.
 

Enter your query term here ( for example: * from complete_sequence LIMIT 100 ) SELECT Return results as web page Send results by e-mail (please specify address) E-mail:  Submit

Warnings

• Very big searches may cause the server to run out of memory and to return an error message. In that case, split your search up, by chromosome for example. You may also want to use a 'LIMIT 100' clause in your SQL statement.
• Using wildcards for field names means that the fields will be returned in a strange order (although column titles will still correspond to their contents).

SQL tutorials

If you're not familiar with SQL queries, the following links may help you to get started: http://www.sqlcourse.com, a good site to learn SQL; the list of tutorials at the MySQL links page; or  the full MySQL documentation..

---

Layout of the CATMA database

For explanations of the contents of the tables and fields, please look here.