BH12.12/stanza titech/Disease Information

提供:TogoWiki

(版間での差分)
移動: 案内, 検索
(Disease Information)
(Disease Information)
 
29行: 29行:
*使用グラフ----------------------------
*使用グラフ----------------------------
-
*:PDO_ver0.2.owl
+
*:PDO_ver0.1.owl
*:CSSO_ver0.1.owl
*:CSSO_ver0.1.owl
*:mapping_ver2.ttl
*:mapping_ver2.ttl
41行: 41行:
SELECT ?diseaseName  ?synonymList  ?def  ?class ?symptomList
SELECT ?diseaseName  ?synonymList  ?def  ?class ?symptomList
-
FROM <http://localhost:8890/PDO/test/PDO_ver0.2.owl>
+
FROM <http://localhost:8890/PDO/test/PDO_ver0.1.owl>
FROM <http://localhost:8890/PDO/test/CSSO_ver0.1.owl>
FROM <http://localhost:8890/PDO/test/CSSO_ver0.1.owl>
FROM <http://localhost:8890/PDO/test/mapping_ver2.ttl>
FROM <http://localhost:8890/PDO/test/mapping_ver2.ttl>
70行: 70行:
}
}
}</pre>
}</pre>
-
[http://evolve.bio.titech.ac.jp/sparql?default-graph-uri=&query=prefix+pdo%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F11%2Fpdo%2F%3E+%0D%0Aprefix+obo%3A+%3Chttp%3A%2F%2Fpurl.obolibrary.org%2Fobo%2F%3E%0D%0Aprefix+csso%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F11%2Fcsso%2F%3E+%0D%0ASELECT+%3FdiseaseName++%3FsynonymList++%3Fdef++%3Fclass+%3FsymptomList%0D%0AFROM+%3Chttp%3A%2F%2Flocalhost%3A8890%2FPDO%2Ftest%2FPDO_ver0.2.owl%3E%0D%0AFROM+%3Chttp%3A%2F%2Flocalhost%3A8890%2FPDO%2Ftest%2FCSSO_ver0.1.owl%3E%0D%0AFROM+%3Chttp%3A%2F%2Flocalhost%3A8890%2FPDO%2Ftest%2Fmapping_ver2.ttl%3E%0D%0A%0D%0AWHERE+%0D%0A{%0D%0A%09pdo%3APDO_000173%09rdfs%3Alabel%09%3FdiseaseName.%0D%0A%09{%0D%0A%09%09SELECT+%28GROUP_CONCAT%28%3Fsynonym%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3FsynonymList%29%0D%0A%09%09%09WHERE{%0D%0A%09%09%09%09pdo%3APDO_000173%09skos%3AaltLabel%09%3Fsynonym.%0D%0A%09%09%09}%0D%0A%09}%0D%0A%09{%0D%0A%09%09SELECT++%28GROUP_CONCAT%28%3Fsymptoms%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3FsymptomList%29%0D%0A%09%09%09WHERE{%0D%0A%09%09%09%09pdo%3APDO_000173%09pdo%3AhasSymptomOf%09%3Fsymptom.%0D%0A%09%09%09%09%3Fsymptom%09rdfs%3Alabel%09%3Fsymptoms.%0D%0A%09%09%09}%0D%0A%09}%0D%0A%09OPTIONAL{%0D%0A%09%09pdo%3APDO_000173%09obo%3AIAO_0000115%09%3Fdef.%0D%0A%09}%0D%0A%09OPTIONAL{%0D%0A%09%09pdo%3APDO_000173%09rdfs%3AsubClassOf%2B%09%3FupperClass.%0D%0A%09%09%3FupperClass+rdfs%3AsubClassOf+pdo%3APDO_000001.%0D%0A%09%09%3FupperClass%09rdfs%3Alabel%09%3Fclass.%0D%0A%09}%0D%0A}&format=text%2Fhtml&timeout=0&debug=on 実行結果]
+
[http://evolve.bio.titech.ac.jp/sparql?default-graph-uri=&query=prefix+pdo%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F11%2Fpdo%2F%3E+%0D%0Aprefix+obo%3A+%3Chttp%3A%2F%2Fpurl.obolibrary.org%2Fobo%2F%3E%0D%0Aprefix+csso%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F11%2Fcsso%2F%3E+%0D%0ASELECT+%3FdiseaseName++%3FsynonymList++%3Fdef++%3Fclass+%3FsymptomList%0D%0AFROM+%3Chttp%3A%2F%2Flocalhost%3A8890%2FPDO%2Ftest%2FPDO_ver0.1.owl%3E%0D%0AFROM+%3Chttp%3A%2F%2Flocalhost%3A8890%2FPDO%2Ftest%2FCSSO_ver0.1.owl%3E%0D%0AFROM+%3Chttp%3A%2F%2Flocalhost%3A8890%2FPDO%2Ftest%2Fmapping_ver2.ttl%3E%0D%0A%0D%0AWHERE+%0D%0A%7B%0D%0Apdo%3APDO_000173%09rdfs%3Alabel%09%3FdiseaseName.%0D%0A%7BSELECT+%28GROUP_CONCAT%28%3Fsynonym%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3FsynonymList%29%0D%0AWHERE%7B%0D%0Apdo%3APDO_000173%09skos%3AaltLabel%09%3Fsynonym.%0D%0A%7D%7D%0D%0A%0D%0A%7BSELECT++%28GROUP_CONCAT%28%3Fsymptoms%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3FsymptomList%29%0D%0AWHERE%7B%0D%0Apdo%3APDO_000173%09pdo%3AhasSymptomOf%09%3Fsymptom.%0D%0A%3Fsymptom%09rdfs%3Alabel%09%3Fsymptoms.%0D%0A%7D%7D%0D%0AOPTIONAL%7B%0D%0Apdo%3APDO_000173%09obo%3AIAO_0000115%09%3Fdef.%0D%0A%7D%0D%0AOPTIONAL%7B%0D%0Apdo%3APDO_000173%09rdfs%3AsubClassOf%2B%09%3FupperClass.%0D%0A%3FupperClass+rdfs%3AsubClassOf+pdo%3APDO_000001.%0D%0A%3FupperClass%09rdfs%3Alabel%09%3Fclass.%0D%0A%7D%0D%0A%7D&format=text%2Fhtml&timeout=0&debug=on 実行結果]

2013年5月31日 (金) 02:11時点における最新版

Disease Information

  • スタンザ概要--------------------------
    ある病気の基本情報を取得
  • 入力----------------------------------
    PDO ID
  • 出力----------------------------------
変数名説明URI or literal
?diseaseName病名literal
?synonymList同義語のリストliteral
?def病気の定義literal
?class病気のクラスliteral
?symptomList症状のリストliteral
  • 使用グラフ----------------------------
    PDO_ver0.1.owl
    CSSO_ver0.1.owl
    mapping_ver2.ttl
  • メモ----------------------------------
  • SPARQL query--------------------------

例:Myocarditis(pdo:PDO_000173)に関する情報

PREFIX pdo: <http://purl.jp/bio/11/pdo/> 
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX csso: <http://purl.jp/bio/11/csso/> 

SELECT ?diseaseName  ?synonymList  ?def  ?class ?symptomList
FROM <http://localhost:8890/PDO/test/PDO_ver0.1.owl>
FROM <http://localhost:8890/PDO/test/CSSO_ver0.1.owl>
FROM <http://localhost:8890/PDO/test/mapping_ver2.ttl>

WHERE 
{
	pdo:PDO_000173	rdfs:label	?diseaseName.
	{
		SELECT (GROUP_CONCAT(?synonym; SEPARATOR = " , ") AS ?synonymList)
			WHERE{
				pdo:PDO_000173	skos:altLabel	?synonym.
			}
	}
	{
		SELECT  (GROUP_CONCAT(?symptoms; SEPARATOR = " , ") AS ?symptomList)
			WHERE{
				pdo:PDO_000173	pdo:hasSymptomOf	?symptom.
				?symptom	rdfs:label	?symptoms.
			}
	}
	OPTIONAL{
		pdo:PDO_000173	obo:IAO_0000115	?def.
	}
	OPTIONAL{
		pdo:PDO_000173	rdfs:subClassOf+	?upperClass.
		?upperClass rdfs:subClassOf pdo:PDO_000001.
		?upperClass	rdfs:label	?class.
	}
}

実行結果