Advanced Search

January 4th, 2016

Advanced querying of mosquito odorant binding proteins database is offered for users with basic expertise in MySQL querying.

Query form

Type in your query in the text area below (see examples below)



How to use

You can only use SELECT commands.

There are 2 available tables :

  • Table of genomic data: proteins_v3
  • Table of docking results: complexes_v3

The detailed description of the tables are the following:

Table of genomic data 

Table proteins_v3
 +----------------+-------------+------+-----+---------+-------+
 | Field          | Type        | Null | Key | Default | Extra |
 +----------------+-------------+------+-----+---------+-------+
 | ID             | varchar(10) | YES  |     | NULL    |       |
 | Name           | varchar(10) | YES  |     | NULL    |       |
 | Uniprot        | varchar(6)  | YES  |     | NULL    |       |
 | Length         | int(11)     | YES  |     | NULL    |       |
 | Chr            | varchar(8)  | YES  |     | NULL    |       |
 | Start          | int(11)     | YES  |     | NULL    |       |
 | End            | int(11)     | YES  |     | NULL    |       |
 | Class          | varchar(15) | YES  |     | NULL    |       |
 | Cluster        | varchar(25) | YES  |     | NULL    |       |
 | Orth_Anopheles | varchar(10) | YES  |     | NULL    |       |
 | Orth_Aedes     | varchar(10) | YES  |     | NULL    |       |
 | Orth_Culex     | varchar(10) | YES  |     | NULL    |       |
 +----------------+-------------+------+-----+---------+-------+

Table of docking results 

Table complexes_v3
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| ligand   | int(11)      | YES  |     | NULL    |       |
| odorant  | varchar(255) | YES  |     | NULL    |       |
| compound | varchar(255) | YES  |     | NULL    |       |
| mw       | float(6,2)   | YES  |     | NULL    |       |
| ha       | int(11)      | YES  |     | NULL    |       |
| xlogp    | double(4,2)  | YES  |     | NULL    |       |
| protein  | varchar(10)  | YES  |     | NULL    |       |
| FEB      | float(6,2)   | YES  |     | NULL    |       |
| Ki       | float(8,6)   | YES  |     | NULL    |       |
| pKi      | float(6,3)   | YES  |     | NULL    |       |
| LE       | float(6,4)   | YES  |     | NULL    |       |
| FQ       | float(6,4)   | YES  |     | NULL    |       |
| SILE     | float(6,4)   | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+

Examples of advanced queries on our database:

select * from proteins_v3 where Name like "agamobp%"

This prints all data for OBPs with names starting with agamobp, i.e all OBPs from Anopheles gambiae.

select Class, count(*) from proteins_v3 where Name like "cquiobp%" group by Cluster

This counts the number of OBPs with names starting with cquiobp (i.e all OBPs from Culex quinquefasciatus) in each OBP gene family.

select * from complexes_v3 where protein = "agamobp2"

This prints all docking data (i.e for 129 ligands) for a specific OBP (here agamobp2) from Anopheles gambiae.
Comments are closed.