{"id":30,"date":"2012-04-17T15:14:36","date_gmt":"2012-04-17T15:14:36","guid":{"rendered":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/?page_id=30"},"modified":"2015-06-27T20:57:17","modified_gmt":"2015-06-27T20:57:17","slug":"pb-pentapept-help","status":"publish","type":"page","link":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/?page_id=30","title":{"rendered":"PB-PENTAdb help"},"content":{"rendered":"<p>The general scheme used to build <a href=\"..\/pentapept\/?page_id=4\">PB-PENTAdb<\/a> is summarized in the diagram below :<\/p>\n<p><a href=\"..\/pentapept\/wp-content\/uploads\/2010\/08\/pentapeptide_database_construction_process_Aug2011.png\"><img loading=\"lazy\" decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2010\/08\/pentapeptide_database_construction_process_Aug2011.png\" alt=\"pentapeptide database construction process\" title=\"pentapeptide database construction process\" width=\"640\" height=\"450\" class=\"aligncenter size-full wp-image-1835\" \/><\/a><\/p>\n<p>The database hence contains the following features for each pentapeptide :<\/p>\n<ul>\n<li>protein id<\/li>\n<li>the PB class<\/li>\n<li>the position of the first residue of the pentapeptide in the pdb-style SCOP file<\/li>\n<li>the dihedral angles (phi and psi values)<\/li>\n<li>the lowest angular rmsd (rmsda) between pentapeptide&#8217;s dihedral angles and standard dihedral angles of PBs<\/li>\n<li>the secondary structure assignments (from DSSP)<\/li>\n<li>a series of 5 values corresponding to the &#8220;all atoms&#8221; relative solvent accessibility for all 5 residues<\/li>\n<li>a series of 5 values corresponding to backbone B factors of 5 residues<\/li>\n<\/ul>\n<h2>Simplified query tool<\/h2>\n<p><strong>Input:<\/strong> Enter a valid pentapeptide sequence (5 residues long) in the text area with no space between the residues. You can use the underscore &#8220;_&#8221; sign to specify &#8220;any&#8221; residue. You can choose to search in datasets filtered at different sequence similarity cutoffs.<\/p>\n<p><a href=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/simple_query.png\" target=\"_blank\"><img decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/simple_query.png\" alt=\"Simple Query Form\" \/><\/a><\/p>\n<p>The results are delivered as followed : <\/p>\n<p><a href=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/simple_query_result.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/simple_query_result.png\" alt=\"Simple Query Result\" width=\"700\" height=\"600\"\/><\/a><\/p>\n<p>Different links provided on the result page are described in the following figure<br \/>\n<a href=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/link.png\" target=\"_blank\"><img decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/link.png\" alt=\"Links\" \/><\/a>\n<\/p>\n<h2> SQL Advanced Query<\/h2>\n<p>The user can also provide <strong>more elaborated queries<\/strong> to the database in the second section of the tool :<\/p>\n<p><a href=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/sql_query.png\" target=\"_blank\"><img decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/sql_query.png\" alt=\"SQL Query\" \/><\/a><\/p>\n<p><strong>Input: <\/strong>Enter a mysql command. DO NOT put a semi colon (;) at the end of your command line.<br \/>\n<em>example :<\/em> SELECT pb, COUNT(*) AS number FROM mapping100 GROUP BY pb<br \/>\nThe table containing the data is called <em>mapping100<\/em>.<br \/>\nThe structure of the table is as follows :<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Field<\/strong><\/td>\n<td>id_protein<\/td>\n<td>pb<\/td>\n<td>aaseq<\/td>\n<td>pos<\/td>\n<td>psi1<\/td>\n<td>phi2<\/td>\n<td>psi2<\/td>\n<td>phi3<\/td>\n<td>psi3<\/td>\n<td>phi4<\/td>\n<td>psi4<\/td>\n<td>phi5<\/td>\n<\/tr>\n<tr>\n<td><strong>Type<\/strong><\/td>\n<td>varchar(20)<\/td>\n<td>varchar(4)<\/td>\n<td>varchar(9)<\/td>\n<td>int(11)<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>int(11)<\/td>\n<\/tr>\n<tr>\n<td><strong>Field<\/strong><\/td>\n<td>rmsda<\/td>\n<td>sec_str<\/td>\n<td>rsa1<\/td>\n<td>rsa3<\/td>\n<td>rsa3<\/td>\n<td>rsa4<\/td>\n<td>rsa5<\/td>\n<\/tr>\n<tr>\n<td><strong>Type<\/strong><\/td>\n<td>float<\/td>\n<td>varchar(5)<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\nDescription of the <em>rmsda100<\/em> table in our database :<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Field<\/strong><\/td>\n<td>id_protein<\/td>\n<td>pb<\/td>\n<td>aaseq<\/td>\n<td>pos<\/td>\n<td>CA_Bfac1<\/td>\n<td>CA_Bfac2<\/td>\n<td>CA_Bfac3<\/td>\n<td>CA_Bfac4<\/td>\n<\/tr>\n<tr>\n<td><strong>Type<\/strong><\/td>\n<td>varchar(20)<\/td>\n<td>varchar(4)<\/td>\n<td>varchar(9)<\/td>\n<td>int(11)<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<\/tr>\n<tr>\n<td><strong>Field<\/strong><\/td>\n<td>CA_Bfac5<\/td>\n<td>Bkbone_Bfac1<\/td>\n<td>Bkbone_Bfac2<\/td>\n<td>Bkbone_Bfac3<\/td>\n<td>Bkbone_Bfac4<\/td>\n<td>Bkbone_Bfac5<\/td>\n<td>pb1<\/td>\n<td>rmsda1<\/td>\n<\/tr>\n<tr>\n<td><strong>Type<\/strong><\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>float<\/td>\n<td>varchar(4)<\/td>\n<td>float<\/td>\n<\/tr>\n<tr>\n<td><strong>Field<\/strong><\/td>\n<td>pb2<\/td>\n<td>rmsda2<\/td>\n<\/tr>\n<tr>\n<td><strong>Type<\/strong><\/td>\n<td>varchar(4)<\/td>\n<td>float<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><\/p>\n<p><strong>Results:<\/strong> output is according to user&#8217;s query and is downloadable.<\/p>\n<h2> Advanced Query <\/h2>\n<p>User can choose to fill required fields and leave the other fields which are not required as they are. User can get help about a particular field if he gets the mouse pointer over that field&#8217;s text box. e.g. Help about sequence field is shown in the image below.<br \/>\n<a href=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/adv_search.png\" target=\"_blank\"><img decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/adv_search.png\" alt=\"Advanced Search\" \/><\/a><\/p>\n<p>\nUser can also choose the fields to be displayed in the result.<br \/>\n<a href=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/adv_display.png\" target=\"_blank\"><img decoding=\"async\" src=\"..\/pentapept\/wp-content\/uploads\/2012\/02\/adv_display.png\" alt=\"Output Fields\" \/><\/a><br \/>\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The general scheme used to build PB-PENTAdb is summarized in the diagram below : The database hence contains the following features for each pentapeptide : protein id the PB class the position of the first residue of the pentapeptide in the pdb-style SCOP file the dihedral angles (phi and psi values) the lowest angular rmsd [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":15,"menu_order":2,"comment_status":"closed","ping_status":"open","template":"page-without-sidebar.php","meta":{"footnotes":""},"class_list":["post-30","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/pages\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=30"}],"version-history":[{"count":7,"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/pages\/30\/revisions"}],"predecessor-version":[{"id":79,"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/pages\/30\/revisions\/79"}],"up":[{"embeddable":true,"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=\/wp\/v2\/pages\/15"}],"wp:attachment":[{"href":"https:\/\/pbpred-us2b.univ-nantes.fr\/pbe\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}