Hello Everyone,
I have an issue regarding the attributes.
A far as I know, the query engine uses the filters to restrict the output and attributes
are only used to display the values.

From the same filter (restriction on the chromosome 2), This query returns no results :

PREFIX accesspoint: <http://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology#>
PREFIX class: <biomart://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/class#>
PREFIX dataset: <biomart://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/dataset#>
PREFIX attribute: <biomart://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/attribute#>

SELECT ?a0 ?a1 ?a2 ?a3 ?a4
FROM dataset:public
WHERE {
  ?mart attribute:process__simplemut_analysis__chr_106 "2" .
  ?mart attribute:process__simplemut_analysis__end_pos_106 ?a0 .
  ?mart attribute:process__simplemut_analysis__chr_106 ?a1 .
  ?mart attribute:process__simplemut_analysis__start_pos_106 ?a2 .
  ?mart attribute:sample__acc_1040 ?a3 .
  ?mart attribute:file__library_sequence_file__run_acc_1018 ?a4
}



Otherwise,I get results if I remove the attribute sample__acc_1040


PREFIX accesspoint: <http://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology#>
PREFIX class: <biomart://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/class#>
PREFIX dataset: <biomart://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/dataset#>
PREFIX attribute: <biomart://lumiere.lyon.fnclcc.fr/ICGC/martsemantics/genomicdb_process_test_config/ontology/attribute#>

SELECT ?a0 ?a1 ?a2 ?a3
FROM dataset:public
WHERE {
  ?mart attribute:process__simplemut_analysis__chr_106 "2" .
  ?mart attribute:process__simplemut_analysis__end_pos_106 ?a0 .
  ?mart attribute:process__simplemut_analysis__chr_106 ?a1 .
  ?mart attribute:process__simplemut_analysis__start_pos_106 ?a2 .
  ?mart attribute:file__library_sequence_file__run_acc_1018 ?a3
}


I have three datasets (genomicDB, SampleTraker Sample and SampleTracker File). I made a link from
GenomicDB to SampleTraker Sample and GenomicDB to SampleTracker File (The links are correct).
From GenomicDB :
If I use attributes only from SampleTraker Sample or SampleTracker File, I'll get the expected result.
If I use attributes from SampleTraker Sample (attribute sample__acc_1040) and SampleTracker File (file__library_sequence_file__run_acc_1018), I'll get no results.

Any ideas ? I am a bit lost with that !


--
_______________________________________________
Users mailing list
[email protected]
https://lists.biomart.org/mailman/listinfo/users

Reply via email to