Find Data on CGC via Data Exploerer, SPARQL, and Datasets API

Tengfei Yin <tengfei.yin@sevenbridges.com>

2017-02-26

1 Introdution

There are currently three ways to find the data you need on CGC:

2 Quick Start

2.1 Graphical data explorer

Please read the tutorial here.

2.2 SPARQL examples

Seven Bridges’ SPARQL console, available at https://opensparql.sbgenomics.com.

Please read following tutorials first

Let’s see an example here, you will need the R package SPARQL:

library("SPARQL")
endpoint = "https://opensparql.sbgenomics.com/blazegraph/namespace/tcga_metadata_kb/sparql"
query = "
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix tcga: <https://www.sbgenomics.com/ontologies/2014/11/tcga#>

select distinct ?case ?sample ?file_name ?path ?xs_label ?subtype_label
where
{
 ?case a tcga:Case .
 ?case tcga:hasDiseaseType ?disease_type .
 ?disease_type rdfs:label 'Lung Adenocarcinoma' .

 ?case tcga:hasHistologicalDiagnosis ?hd .
 ?hd rdfs:label 'Lung Adenocarcinoma Mixed Subtype' .

 ?case tcga:hasFollowUp ?follow_up .
 ?follow_up tcga:hasDaysToLastFollowUp ?days_to_last_follow_up .
 filter(?days_to_last_follow_up>550)

 ?follow_up tcga:hasVitalStatus ?vital_status .
 ?vital_status rdfs:label ?vital_status_label .
 filter(?vital_status_label='Alive')

 ?case tcga:hasDrugTherapy ?drug_therapy .
 ?drug_therapy tcga:hasPharmaceuticalTherapyType ?pt_type .
 ?pt_type rdfs:label ?pt_type_label .
 filter(?pt_type_label='Chemotherapy')

 ?case tcga:hasSample ?sample .
 ?sample tcga:hasSampleType ?st .
 ?st rdfs:label ?st_label
 filter(?st_label='Primary Tumor')

 ?sample tcga:hasFile ?file .
 ?file rdfs:label ?file_name .

 ?file tcga:hasStoragePath ?path.

 ?file tcga:hasExperimentalStrategy ?xs.
 ?xs rdfs:label ?xs_label .
 filter(?xs_label='WXS')

 ?file tcga:hasDataSubtype ?subtype .
 ?subtype rdfs:label ?subtype_label

}

"
qd <- SPARQL(endpoint, query)
df <- qd$results
head(df)

You can use the CGC API to access the TCGA files found via SPARQL queries. To get files that have download links, you will need to use the SPARQL variable path in your query.

# api(api_url = base, auth_token = auth_token, path = "action/files/get_ids",
#     method = "POST", query = None, data = filelist)
df.path <- df[,"path"]
df.path

You can directly copy those files to a project, make sure if the files is controlled access

library("sevenbridges")
a = Auth(platform = "cgc", token = "your_cgc_token")
# get id (only works for CGC platform)
ids = a$get_id_from_path(df.path)
# copy file from id to project with controlled access
(p = a$project(id = "tengfei/control-test"))
a$copyFile(ids, p$id)

Now have fun with more examples in this tutorial.

2.3 Datasets API examples

Please read the tutorials.

2.3.1 Browse TCGA via the Datasets API

Doing a HTTP GET on this endpoint one will get a resource with links to all entities in the dataset. Following these links (doing an HTTP GET on them) one will go to a list of entities (for example /files) from TCGA dataset identified with their proper URL. Further following one of these links you’ll get a particular resource (if we went to /files, we’ll get a description of a particular file) with all specific properties like id, label, etc. and links to other entities that are connected to a specific resource (for example /cases) that you can explore further. From there on, the process repeats as long as you follow the links.

2.3.1.1 Return datasets accessible trough the CGC

Create an Auth object with your token, make sure you are using the correct URL.

  • https://cgc-datasets-api.sbgenomics.com/

use Auth$api() method so there is no need to type base URL or token again.

library("sevenbridges")
# create an Auth object
a = Auth(url = "https://cgc-datasets-api.sbgenomics.com/",
         token = "your_cgc_token")
a$api(path = "datasets")

2.3.1.2 Return list of all TCGA entities

You can issue another GET request to the href of the tcga object, if you want to access TCGA data.

a = Auth(url = "https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0",
         token = "your_cgc_token")
(res = a$api())  # default method is GET
# list all resources/entities
names(res$"_links")

2.3.1.3 Interpreting the list of all entities

For example, to see a list of all TCGA files, send the request:

(res = a$api(path = "files"))

For example, to see the metadata schema for files send the request:

a$api(path = "files/schema")

2.3.1.4 Copy files to you project

Get file id from Datasets API, then use public API to copy files. Make sure your project is “TCGA” compatible, otherwise if you are trying to copy controlled access data to your non-TCGA project, you will get

"HTTP Status 403: Insufficient privileges to access the requested file."
(res = a$api(path = "files"))
get_id = function(obj){
   sapply(obj$"_embedded"$files, function(x) x$id)
}
ids = get_id(res)
# create CGC auth
a_cgc = Auth(platform = "cgc", token = a$token)
a_cgc$copyFile(id = ids, project = "tengfei/tcga-demo")

2.3.2 Post with query

endpoint user can filter collection resources by using a DSL in JSON format that translates as a subset of SPARQL. Main advantage here is that an end user gets the subset SPARQL expressiveness without the need to learn SPARQL specification.

2.3.2.1 Find samples connected to a case

body = list(
    entity = "samples",
    hasCase = "0004D251-3F70-4395-B175-C94C2F5B1B81"
)
a$api(path = "query", body = body, method = "POST")

Count samples connected to a case

a$api(path = "query/total", body = body, method = "POST")

Issuing a GET request to the href path will return the following data:

Note: api function is a light layer of httr package, it’s different from Auth$api call.

httr::content(
    api(token = a$token,
        base_url = "https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/samples/9259E9EE-7279-4B62-8512-509CB705029C"))

2.3.2.2 Find cases with given age at diagnosis

Suppose you want to see all cases for which the age at diagnosis is between 10 and 50. Then, you use the following query.

Note that the value of the metadata field hasAgeAtDiagnosis is a dictionary containing the keyfilter, whose value is a further dictionary with keysgt(greater than) and lt (less than) for the upper and lower bounds to filter by.

body = list(
   "entity" = "cases",
   "hasAgeAtDiagnosis" = list(
       "filter" = list(
           "gt" = 10,
           "lt" = 50
       )
   )
)
a$api(path = "query", body = body, method = "POST")

2.3.2.3 Find cases with a given age at diagnosis and disease

Suppose you want to see all cases that, as in the example, (Find cases with given age at diagnosis)(doc:find-all-cases-with-a-given-age-at-diagnosis), have an age at diagnosis of between 10 and 50, but that also have the disease “Kidney Chromophobe”. Then, use the following query:

body = list(
   "entity" = "cases",
   "hasAgeAtDiagnosis" = list(
       "filter" = list(
           "gt" = 10,
           "lt" = 50
       )
   ),
   "hasDiseaseType" = "Kidney Chromophobe"
)
a$api(path = "query", body = body, method = "POST")

2.3.2.4 Complex example for filtering TCGA data

body = list(
    "entity" = "cases",
    "hasSample" = list(
        "hasSampleType" = "Primary Tumor",
        "hasPortion" = list(
            "hasPortionNumber" = 11
        )
        ),
    "hasNewTumorEvent" = list(
        "hasNewTumorAnatomicSite" = c("Liver", "Pancreas"),
        "hasNewTumorEventType" = list(
            "filter" = list(
                "contains" = "Recurrence"
            )
        )
    )
)
a$api(path = "query", body = body, method = "POST")

Issuing a GET request to the href path

httr::content(
    api(token = a$token,
        base_url = "https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/0004D251-3F70-4395-B175-C94C2F5B1B81"))

2.3.2.5 Query with multiple filters on a case

get_id = function(obj) sapply(obj$"_embedded"$files, function(x) x$id)
names(res)
body = list("entity" = "cases",
            "hasSample" = list(
                "hasSampleType" = "Primary Tumor",
                "hasPortion" = list(
                    "hasPortionNumber" = 11,
                    "hasID" = "TCGA-DD-AAVP-01A-11"
                )
            ),
            "hasNewTumorEvent" = list(
                "hasNewTumorAnatomicSite" = "Liver",
                "hasNewTumorEventType" = "Intrahepatic Recurrence"
            )
)
(res = a$api(path = "files", body = body))
get_id(res)