Statistics of ProTherm

Statistics of ProTherm

Index

Summary of data in ProTherm
List of Protein Names
List of Protein Names with Mutants
Frequency of Amino Acids in Mutation Sites
List of Sources
Number of references by year
List of References
List of Authors

Summary of data in ProTherm

"; echo ""; echo ""; echo ""; ########## Number of unique proteins ############ $sql = "select distinct protein from protherm order by protein"; $result_protein = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of all proteins ############ $sql = "select distinct protein,source from protherm"; $result = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of Proteins with mutants ############ $sql = "select distinct protein from protherm where mut_no > 0 order by protein"; $result_prtmut = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of Single Mutations ############ $sql = "select protein from protherm where mut_no = 1"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of Double Mutations ############ $sql = "select protein from protherm where mut_no = 2"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of Multiple Mutations ############ $sql = "select protein from protherm where mut_no > 2"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of wild Type ############ $sql = "select protein from protherm where mut_no = 0"; $result = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of Mutation on Helix ############ $sql = "select protein from protherm where sec_str like '%H%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of Mutation on Sheet ############ $sql = "select protein from protherm where sec_str like '%S%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of Mutation on Turn ############ $sql = "select protein from protherm where sec_str like '%T%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of Mutation on Coil ############ $sql = "select protein from protherm where sec_str like '%C%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of entries of Buried ############ $sql = "select protein from protherm where ASA2_min < 20.0"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of Partially Buried ############ $sql = "select protein from protherm where ( ASA2_min >=20 and ASA2_min <= 50 ) or (ASA2_max >=20 and ASA2_max <= 50)"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of Exposed ############ $sql = "select protein from protherm where ASA2_max > 50.0"; $result = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of entries by Absorbance ############ $sql = "select protein from protherm where measure like '%Abs%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of CD ############ $sql = "select protein from protherm where measure like '%CD%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of DSC ############ $sql = "select protein from protherm where measure like '%DSC%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of Fluorescence ############ $sql = "select protein from protherm where measure like '%Flu%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of NMR ############ $sql = "select protein from protherm where measure like '%NMR%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of Others ############ $sql = "select protein from protherm where (measure not like '%CD%') and (measure not like '%Abs%') and (measure not like '%DSC%') and (measure not like '%NMR%') and (measure not like '%Flu%')"; $result = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Number of entries of Thermal ############ $sql = "select protein from protherm where method like '%The%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of GdnHCl ############ $sql = "select protein from protherm where method like '%GdnH%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of Urea ############ $sql = "select protein from protherm where method like '%Urea%'"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## Number of entries of Others ############ $sql = "select protein from protherm where (method not like '%The%') and (method not like '%GdnH%') and (method not like '%Urea%')"; $result = mysql_query($sql); echo ""; echo ""; echo ""; echo ""; ########## Total Number of References ############ $sql = "select distinct reference from protherm"; $result = mysql_query($sql); echo ""; echo ""; echo ""; ########## protein list ####################### ?>
Total number of entries".$current_entry_number."
======================================
Number of unique proteins".mysql_num_rows($result_protein)."
======================================
Number of all proteins".mysql_num_rows($result)."
======================================
Number of Proteins with mutants".mysql_num_rows($result_prtmut)."
======================================
Number of Single Mutations".mysql_num_rows($result)."
Number of Double Mutations".mysql_num_rows($result)."
Number of Multiple Mutations".mysql_num_rows($result)."
Number of Wild Type".mysql_num_rows($result)."
======================================
Number of Mutation on Helix".mysql_num_rows($result)."
Number of Mutation on Sheet".mysql_num_rows($result)."
Number of Mutation on Turn".mysql_num_rows($result)."
Number of Mutation on Coil".mysql_num_rows($result)."
======================================
Number of entries of Buried".mysql_num_rows($result)."
Number of entries of Partially Buried".mysql_num_rows($result)."
Number of entries of Exposed".mysql_num_rows($result)."
======================================
Number of entries by Absorbance".mysql_num_rows($result)."
Number of entries of CD".mysql_num_rows($result)."
Number of entries of DSC".mysql_num_rows($result)."
Number of entries of Fluorescence".mysql_num_rows($result)."
Number of entries of NMR".mysql_num_rows($result)."
Number of entries of Others".mysql_num_rows($result)."
======================================
Number of entries of Thermal".mysql_num_rows($result)."
Number of entries of GdnHCl".mysql_num_rows($result)."
Number of entries of Urea".mysql_num_rows($result)."
Number of entries of Others".mysql_num_rows($result)."
======================================
Total Number of References".mysql_num_rows($result)."

List of Protein Names


======================================";


########## protein list with mutation #######################
?>

List of Protein Names with Mutants


======================================";

########## source list  #######################
?>

List of Sources


======================================";

########## reference year list #######################
?>

Number of references by year



======================================";
?>