-
Notifications
You must be signed in to change notification settings - Fork 76
/
d3sparql-htmltable.html
74 lines (72 loc) · 2.42 KB
/
d3sparql-htmltable.html
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
67
68
69
70
71
72
73
74
<!DOCTYPE html>
<meta charset="utf-8">
<html>
<head>
<link rel="stylesheet" type="text/css" href="lib/bootstrap/css/bootstrap.css"/>
<script src="lib/d3/d3.v3.min.js"></script>
<script src="d3sparql.js"></script>
<script>
function exec() {
var endpoint = d3.select("#endpoint").property("value")
var sparql = d3.select("#sparql").property("value")
d3sparql.query(endpoint, sparql, render)
}
function render(json) {
var config = {
"selector": "#result"
}
d3sparql.htmltable(json, config)
}
function exec_offline() {
d3.json("cache/interpro/1117-hk.json", render)
}
function toggle() {
d3sparql.toggle()
}
</script>
</head>
<body>
<div id="query" style="margin: 10px">
<h1>d3htmltable</h1>
<form class="form-inline">
<label>SPARQL endpoint:</label>
<div class="input-append">
<input id="endpoint" class="span5" value="http://togostanza.org/sparql" type="text">
<button class="btn" type="button" onclick="exec()">Query</button>
<button class="btn" type="button" onclick="exec_offline()">Use cache</button>
<button class="btn" type="button" onclick="toggle()"><i id="button" class="icon-chevron-up"></i></button>
</div>
</form>
<textarea id="sparql" class="span9" rows=15>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX id_tax:<http://identifiers.org/taxonomy/>
PREFIX tax: <http://ddbj.nig.ac.jp/ontologies/taxonomy/>
PREFIX stats: <http://togogenome.org/stats/>
PREFIX up: <http://purl.uniprot.org/core/>
PREFIX ipr: <http://purl.uniprot.org/interpro/>
SELECT DISTINCT ?organism ?label ?length ?genes (COUNT(DISTINCT ?protein) AS ?hks)
{
{
SELECT DISTINCT ?organism ?up_tax ?label ?length ?genes
WHERE
{
# Cyanobacteria (1117)
?organism a tax:Taxon ;
rdfs:subClassOf+ id_tax:1117 ;
stats:sequence_length ?length ;
stats:gene ?genes ;
tax:scientificName ?label .
BIND (IRI(REPLACE(STR(?organism), "http://identifiers.org/taxonomy/", "http://purl.uniprot.org/taxonomy/")) AS ?up_tax)
}
}
?up_tax a up:Taxon .
?protein up:organism ?up_tax ;
a up:Protein .
# Signal transduction histidine kinase (IPR005467)
?protein rdfs:seeAlso ipr:IPR005467 .
} GROUP BY ?organism ?label ?length ?genes ORDER BY ?length
</textarea>
</div>
<div id="result"></div>
</body>
</html>