Basic Search | Intermediate Search | Advanced SQL Search | Gene Image Map |
Advanced SQL Search for Chlamydia pneumoniae
If you are not familiar with Structured Query Language (SQL), and you would like to use this page, please follow the SQL tutorial link provided above and take some time to read about SQL. Use of this page requires knowledge of both the database and SQL. A list of tables and fields within each table can be found by following the "Table and Field List" link near the top of the page. Searches are case insensitive.
Example 1: List all the IDs for all of the trna sequences in the database
SELECT trna_id from trna_table
Example 2: List all fields for trnas in the first 250,000 bases of the genome
SELECT * from trna_table where trna_start>0 and trna_stop<250001
Example 3: Hypothetical query with 2D SDS-PAGE data
SELECT * from gene_table where mol_wt < 75000 and mol_wt > 65000 and pI < 9.5 and pI > 8.5
NOTE:If you are unable for some reason to execute a search, feel free to send us (by way of comments) a description of what is wanted and we'll provide the appropriate search command.
Operated by the University of California
for the National Nuclear Security Administration,
of the US Department of Energy. Copyright © 2001 UC | Disclaimer/Privacy