-
Notifications
You must be signed in to change notification settings - Fork 1
/
index.php
66 lines (64 loc) · 2.45 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
include_once('common.php');
include_once('partials/header.php');
?>
<div class="container">
<div class="row">
<div class="col-md-8 col-md-offset-2">
<div class="well">
<?php
$query = "SELECT COUNT(`Protein_Name`) AS A,
COUNT(DISTINCT `Domain_Group`) AS B,
COUNT(DISTINCT `Uniprot_ID`) AS C FROM proteins";
$stmt = $dbh->prepare($query);
$stmt->execute();
$ar = $stmt->fetch();
$query = "SELECT DISTINCT `Domain_Group` FROM proteins";
$stmt = $dbh->prepare($query);
$stmt->execute();
$all_families = [];
while ($row = $stmt->fetch()) {
$all_families = array_merge($all_families, explode('+', $row['Domain_Group']));
}
$all_families = array_unique($all_families);
?>
<h4 class="text-primary">
<strong>
PRM database contains <?=$ar['A']?> domains from <?=count($all_families)?> PRM families and <?=$ar['C']?> proteins.
</strong>
</h4>
</div>
</div>
</div>
<div class="row">
<div class="col-md-8 col-md-offset-2">
<h4>Search for a domain or protein by name, all domains from a given species, all members of a domain family, or search for combinations of these criteria.</h4>
<?php include_once('partials/search.php'); ?>
<p>
<h4><strong>Load Examples:</strong></h4>
<h4>Protein Name: <a class="example">VASP</a> | <a class="example">SPSB2</a></h4>
<h4>Domain Group: <a class="example">SH3</a> | <a class="example">IRS</a></h4>
<h4>Uniprot ID: <a class="example">O75791</a> | <a class="example">Q99619</a></h4>
</p>
</div>
</div>
<div class="row">
<div class="col-md-8 col-md-offset-2">
<h4>
<u>Please cite:</u>
<p>Teyra J. et al, Large-scale survey and database of high affinity ligands for peptide recognition modules, Molecular Systems Biology (2020) 16:e9310</p>
<p>DOI: <a target="_blank" href="https://doi.org/10.15252/msb.20199310">10.15252/msb.20199310</a></p>
</h4>
</div>
</div>
</div>
<?php include_once('partials/footer.php'); ?>
<script>
$(function() {
$('.example').click(function() {
$('input[type="search"]').val($(this).text());
});
});
</script>
</body>
</html>