Skip to content

Instantly share code, notes, and snippets.

@wstrinz
Created July 8, 2013 20:36
Show Gist options
  • Save wstrinz/5952273 to your computer and use it in GitHub Desktop.
Save wstrinz/5952273 to your computer and use it in GitHub Desktop.
################# MARKER/LOD/GENE FOR A GIVEN PROBE ###############################
PREFIX f2gns: <http://www.rqtl.org/ns/dataset/f2g#>
PREFIX phenons: <http://www.rqtl.org/ns/dataset/islet_mlratio#>
PREFIX scanns: <http://www.rqtl.org/ns/dataset/scan_islet#>
PREFIX annons: <http://www.rqtl.org/ns/#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX prop: <http://www.rqtl.org/dc/properties/>
PREFIX cs: <http://www.rqtl.org/dc/cs/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT ?marker ?lod ?gene WHERE {
?s qb:dataSet scanns:dataset-scan_islet;
prop:probe "497638"^^<http://www.w3.org/2001/XMLSchema#integer>;
prop:marker ?marker;
prop:lod ?lod.
?t qb:dataSet annons:dataset-annot;
rdfs:label "497638";
prop:gene ?gene.
}
LIMIT 250
################## ALL PHENO/GENO FOR EACH MOUSE on a given probe/marker ######################
PREFIX f2gns: <http://www.rqtl.org/ns/dataset/f2g#>
PREFIX phenons: <http://www.rqtl.org/ns/dataset/islet_mlratio#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX prop: <http://www.rqtl.org/dc/properties/>
PREFIX cs: <http://www.rqtl.org/dc/cs/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT DISTINCT ?mouse ?pheno ?geno WHERE {
?s qb:dataSet phenons:dataset-islet_mlratio;
prop:individual ?mouse;
prop:probe "511932"^^<http://www.w3.org/2001/XMLSchema#integer>;
prop:pheno ?pheno.
?t qb:dataSet f2gns:dataset-f2g;
prop:marker "rs13475697";
prop:MouseNum ?mouse2;
prop:genotype ?geno.
FILTER(?mouse2 = ?mouse)
}
LIMIT 175
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment