Tutorial

Tutorial at a glance

• Online Query
• Coding by yourself
• SPARQL Query Examples

Our data set provides the sparql endpoint, so you can use any programming language to query, based on the HTTP protocol.

Here, we provide examples of online queries or queries using a programming language such as Python, Java ...

Online Query

First, Open the website

Second, Enter your own query statement in the input box. By the way, you can use the examples we provide at the bottom.

Next, you can get the results below.

Coding by yourself

No matter what language you use, you can send a post request to the endpoint with the unique parameter query, and you can get the answer.

Python example:

SPARQL Query Examples

1. The amount of patients who suffered from Sepsis (ICD9CM ID: 995.91)

        SELECT  (COUNT (?subject) AS ?amount)
        WHERE {
            ?subject ?predicate <http://purl.bioontology.org/ontology/ICD9CM/995.91>
        }
    

2. Returning drugs that Sepsis patients had taken

    SELECT ?subject ?drugid
    WHERE {
      ?subject ?predicate <http://purl.bioontology.org/ontology/ICD9CM/995.91>.
      ?subject <http://pdd.wangmengsd.com/property/take_drugbank_id> ?drugid
    }
    

3. Return patients that suffered from Sepsis and took Insulin Human (DrugBank ID: DB00030)

    SELECT ?subject
    WHERE {
      ?subject ?predicate <http://purl.bioontology.org/ontology/ICD9CM/995.91>.
      ?subject <http://pdd.wangmengsd.com/property/take_drugbank_id> <http://bio2rdf.org/drugbank:DB00030>
    }
    

4. The amount of drugs that each patient Sepsis suffered had taken

    SELECT ?subject (COUNT (?drugid)AS ?amount)
    WHERE {
      ?subject ?predicate <http://purl.bioontology.org/ontology/ICD9CM/995.91>.
      ?subject <http://pdd.wangmengsd.com/property/take_drugbank_id> ?drugid
    }
    GROUP BY ?subject
    

5. Drug-drug interactions taken records with the same start date

SELECT *
WHERE {
  ?patient <http://pdd.wangmengsd.com/property/has_prescription> ?pres1.
  ?patient <http://pdd.wangmengsd.com/property/has_prescription> ?pres2.
  ?pres1 <http://pdd.wangmengsd.com/property/start_date> ?date1.
  ?pres2 <http://pdd.wangmengsd.com/property/start_date> ?date2.
  ?pres1 <http://pdd.wangmengsd.com/property/take_drugbank_id> ?drug1.	
  ?pres2 <http://pdd.wangmengsd.com/property/take_drugbank_id> ?drug2.
  ?drug1 <http://pdd.wangmengsd.com/property/interact> ?drug2
  filter(?date1=?date2 && ?pres1!=?pres2).
}
limit 30