{"id":82,"date":"2013-05-15T11:17:00","date_gmt":"2013-05-15T11:17:00","guid":{"rendered":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/?page_id=82"},"modified":"2016-01-04T10:25:35","modified_gmt":"2016-01-04T10:25:35","slug":"advanced-search","status":"publish","type":"page","link":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/?page_id=82","title":{"rendered":"Advanced Search"},"content":{"rendered":"<p>Advanced querying of mosquito odorant binding proteins database is offered for users with basic expertise in MySQL querying.<\/p>\n<p><strong>Query form<\/strong><\/p>\n<p>Type in your query in the text area below (see examples below)<\/p>\n<p><form action=\"\/cgi-bin\/mobpdb\/resultat_sql.cgi\" method=\"post\"><textarea cols=\"65\" name=\"sql_query\" rows=\"3\"><\/textarea><br \/>\n<input type=\"submit\" value=\"Submit SQL Query\" \/><br \/>\n<\/form>\n<\/p>\n<p><strong>How to use<\/strong><\/p>\n<p>You can only use <em>SELECT<\/em> commands.<\/p>\n<p>There are 2 available tables :<\/p>\n<ul>\n<li>Table of genomic data: proteins_v3<\/li>\n<li>Table of docking results: complexes_v3<\/li>\n<\/ul>\n<p><strong><\/p>\n<p>The detailed description of the tables are the following:<\/p>\n<p><\/strong><\/p>\n<table>\n<tr>\n<td><strong>Table of genomic data<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\n<p><pre>\r\n<strong>Table proteins_v3<\/strong>\r\n +----------------+-------------+------+-----+---------+-------+\r\n | Field          | Type        | Null | Key | Default | Extra |\r\n +----------------+-------------+------+-----+---------+-------+\r\n | ID             | varchar(10) | YES  |     | NULL    |       |\r\n | Name           | varchar(10) | YES  |     | NULL    |       |\r\n | Uniprot        | varchar(6)  | YES  |     | NULL    |       |\r\n | Length         | int(11)     | YES  |     | NULL    |       |\r\n | Chr            | varchar(8)  | YES  |     | NULL    |       |\r\n | Start          | int(11)     | YES  |     | NULL    |       |\r\n | End            | int(11)     | YES  |     | NULL    |       |\r\n | Class          | varchar(15) | YES  |     | NULL    |       |\r\n | Cluster        | varchar(25) | YES  |     | NULL    |       |\r\n | Orth_Anopheles | varchar(10) | YES  |     | NULL    |       |\r\n | Orth_Aedes     | varchar(10) | YES  |     | NULL    |       |\r\n | Orth_Culex     | varchar(10) | YES  |     | NULL    |       |\r\n +----------------+-------------+------+-----+---------+-------+\r\n<\/pre>\n<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Table of docking results<\/strong><\/td>\n<\/tr>\n<tr>\n<td>\n<p><pre>\r\n<strong>Table complexes_v3<\/strong>\r\n+----------+--------------+------+-----+---------+-------+\r\n| Field    | Type         | Null | Key | Default | Extra |\r\n+----------+--------------+------+-----+---------+-------+\r\n| ligand   | int(11)      | YES  |     | NULL    |       |\r\n| odorant  | varchar(255) | YES  |     | NULL    |       |\r\n| compound | varchar(255) | YES  |     | NULL    |       |\r\n| mw       | float(6,2)   | YES  |     | NULL    |       |\r\n| ha       | int(11)      | YES  |     | NULL    |       |\r\n| xlogp    | double(4,2)  | YES  |     | NULL    |       |\r\n| protein  | varchar(10)  | YES  |     | NULL    |       |\r\n| FEB      | float(6,2)   | YES  |     | NULL    |       |\r\n| Ki       | float(8,6)   | YES  |     | NULL    |       |\r\n| pKi      | float(6,3)   | YES  |     | NULL    |       |\r\n| LE       | float(6,4)   | YES  |     | NULL    |       |\r\n| FQ       | float(6,4)   | YES  |     | NULL    |       |\r\n| SILE     | float(6,4)   | YES  |     | NULL    |       |\r\n+----------+--------------+------+-----+---------+-------+\r\n<\/pre>\n<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Examples of advanced queries on our database:<\/strong><\/p>\n<blockquote>\n<p><pre>select * from proteins_v3 where Name like \"agamobp%\"<\/pre>\n<\/p>\n<p>This prints all data for OBPs with names starting with agamobp, i.e all OBPs from <em>Anopheles gambiae<\/em>.<\/p>\n<form action=\"\/cgi-bin\/mobpdb\/resultat_sql.cgi\" method=\"post\">\n<pre><textarea cols=\"80\" name=\"sql_query\" rows=\"2\">select * from proteins_v3 where Name like \"agamobp%\"<\/textarea><\/pre>\n<p><input type=\"submit\" value=\"Submit SQL Query\" \/><\/form>\n<\/p>\n<\/blockquote>\n<blockquote>\n<p><pre>select Class, count(*) from proteins_v3 where Name like \"cquiobp%\" group by Cluster<\/pre>\n<\/p>\n<p>This counts the number of OBPs with names starting with cquiobp (i.e all OBPs from <em>Culex quinquefasciatus<\/em>) in each OBP gene family.<\/p>\n<form action=\"\/cgi-bin\/mobpdb\/resultat_sql.cgi\" method=\"post\">\n<pre><textarea cols=\"80\" name=\"sql_query\" rows=\"2\">select Class, count(*) as count from proteins_v3 where Name like \"cquiobp%\" group by Class<\/textarea><\/pre>\n<p><input type=\"submit\" value=\"Submit SQL Query\" \/><\/form>\n<\/p>\n<\/blockquote>\n<blockquote>\n<p><pre>select * from complexes_v3 where protein = \"agamobp2\"<\/pre>\n<\/p>\n<p>This prints all docking data (i.e for 129 ligands) for a specific OBP (here agamobp2) from <em>Anopheles gambiae<\/em>.<\/p>\n<form action=\"\/cgi-bin\/mobpdb\/resultat_sql.cgi\" method=\"post\">\n<pre><textarea cols=\"80\" name=\"sql_query\" rows=\"2\">select * from complexes_v3 where protein = \"agamobp2\"<\/textarea><\/pre>\n<p><input type=\"submit\" value=\"Submit SQL Query\" \/><\/form>\n<\/p>\n<\/blockquote>\n<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"parent":0,"menu_order":5,"comment_status":"closed","ping_status":"open","template":"page-without-sidebar.php","meta":{"footnotes":""},"class_list":["post-82","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=\/wp\/v2\/pages\/82","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=82"}],"version-history":[{"count":47,"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=\/wp\/v2\/pages\/82\/revisions"}],"predecessor-version":[{"id":369,"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=\/wp\/v2\/pages\/82\/revisions\/369"}],"wp:attachment":[{"href":"https:\/\/protsci-us2b.univ-nantes.fr\/mobpdb\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}