forked from ktym/d3sparql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
d3sparql-htmltable.html
80 lines (78 loc) · 2.47 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
75
76
77
78
79
80
<!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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix up: <http://purl.uniprot.org/core/>
prefix obo: <http://purl.obolibrary.org/obo/>
prefix tax: <http://purl.uniprot.org/taxonomy/>
prefix insdc: <http://ddbj.nig.ac.jp/ontologies/sequence#>
select distinct ?length ?genes ?hks ?taxid ?label
where {
# Cyanobacteria (1117)
?taxid rdfs:subClassOf+ <http://identifiers.org/taxonomy/1117> .
?taxid rdf:type <http://identifiers.org/taxonomy/> .
?s rdfs:seeAlso ?taxid .
?s rdfs:label ?label .
?s rdf:type obo:SO_0000340 . # chromosome
?s insdc:sequence_length ?length .
{
select ?s (count(?gene) as ?genes)
where {
?gene obo:so_part_of ?s .
?gene rdf:type obo:SO_0000704 . # gene
}
group by ?s
}
{
select ?s (count(?cds) as ?hks)
where {
# Signal transduction histidine kinase (IPR005467)
?cds rdfs:seeAlso <http://identifiers.org/interpro/IPR005467> .
?cds obo:so_part_of+ ?s .
}
group by ?s
}
} order by desc(?genes) limit 100
</textarea>
</div>
<div id="result"></div>
</body>
</html>