Advanced search

June 27th, 2015

Advanced search using SQL query

Use the inputbox below to write your own MySQL requests for searching in PB-PENTAdb database.
You can access to the tables called mapping100, mapping95, mapping90, mapping70, mapping40, mapping30 for respective SCOP sequence identity cutoff of 100%, 95%, 90%, 70%, 40% and 30%. You can also access a table named rmsda100 for C-alpha and backbone temperature factors.
Your request :

(Do not put a semicolon (;) at the end of your command)

Here is the description of the mapping100 table in the database :

Field id_protein pb aaseq pos psi1 phi2 psi2 phi3 psi3 phi4 psi4 phi5
Type varchar(20) varchar(4) varchar(9) int(11) float float float float float float float int(11)
Field rmsda sec_str rsa1 rsa2 rsa3 rsa4 rsa5
Type float varchar(5) float float float float float

Description of the rmsda100 table in our database :

Field id_protein pb aaseq pos CA_Bfac1 CA_Bfac2 CA_Bfac3 CA_Bfac4
Type varchar(20) varchar(4) varchar(9) int(11) float float float float
Field CA_Bfac5 Bkbone_Bfac1 Bkbone_Bfac2 Bkbone_Bfac3 Bkbone_Bfac4 Bkbone_Bfac5 pb1 rmsda1
Type float float float float float float varchar(4) float
Field pb2 rmsda2
Type varchar(4) float

Advanced search for PB-PENTAdb

Pentapeptide Sequence
Choose Database Identity Cutoff
Protein Block(PB)
Secondary Structure
Structural Variability Index (SVI)
RMSDa
Relative Surface Accessibility 1
Relative Surface Accessibility 2
Relative Surface Accessibility 3
Relative Surface Accessibility 4
Relative Surface Accessibility 5
Backbone B factor 1
Backbone B factor 2
Backbone B factor 3
Backbone B factor 4
Backbone B factor 5

Select the fields that you want in the output:

Domain ID Position
Protein Block Secondary Structure
Dihedral angles Pentapeptide sequence
RSA SVI
RMSDa Backbone B facotrs

Last updated on Saturday, June 27, 2015
Comments are closed.