Skip to main content

Table 5 SPARQL query to extract EGFR related information

From: PO2RDF: representation of real-world data for precision oncology using resource description framework

SPARQL query

Results

SELECT distinct ?Gene ?property ?hasValue

WHERE {

?Gene a po2rdf:Gene. FILTER regex(str(?Gene), "EGFR") ?Gene ?property ?hasValue

}

Gene_Name: EGFR. UMLS_CUI: C1414313. OMIM_ID: 131550. CIViC_Gene_ID: 1956. OncoKB_Gene_ID: 2. PharmGKB_Gene_ID: PA7360

Disease_Name: 1. Lung cancer, 2. Colorectal cancer, 3. Melanoma, 4. Esophagus adenocarcinoma, 5. Glioma

Drugs_Name: 1. Gefitinib, 2. Osimertinib, 3. Afatinib, 4. Erlotinib, 5. Dacomitinib

Patient_ID: 3, 15, 21, 44, 65, 73…