SPARQLthon26/CyanoBase

提供:TogoWiki

(版間での差分)
移動: 案内, 検索
(CyanoBase更新系)
39行: 39行:
  #FILTER(?predicate != asm:sequnece)
  #FILTER(?predicate != asm:sequnece)
  FILTER(?taxon_root = <http://identifiers.org/taxonomy/1117>).
  FILTER(?taxon_root = <http://identifiers.org/taxonomy/1117>).
-
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/1117>). #Cyanobacteria
+
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/1117>). #Cyanobacteria
-
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/3041>). #Chlorophyta
+
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/3041>). #Chlorophyta
-
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/2763>). #Rhodophyta
+
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/2763>). #Rhodophyta
-
FILTER(?taxon_root = <http://identifiers.org/taxonomy/33090>). #Viridiplantae
+
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/33090>). #Viridiplantae
  ?lineage rdfs:subClassOf* ?taxon_root.
  ?lineage rdfs:subClassOf* ?taxon_root.

2014年11月17日 (月) 08:34時点における版

CyanoBase更新系

NCBI assembly_reportsにおいてtaxonomy id = 1117以下のゲノムプロジェクトを取得するSPARQL

PREFIX asm: <http://www.ncbi.nlm.nih.gov/assembly/>

select 
*
#?predicate ?object
FROM <http://togogenome.org/graph/taxonomy>
FROM <http://togogenome.org/graph/assembly_report>
WHERE
{
#?assembly ?predicate ?object.
?assembly asm:refseq_category ?category;
 asm:asm_name ?name;
 asm:assembly_id ?id;
 asm:assembly_level ?level;
 asm:bioproject ?bioproject;
 asm:bioproject_accession ?bioproject_accession;
 asm:biosample_accession ?biosample_accession;
 asm:gbrs_paired_asm ?gbrs_paired_asm;
 asm:genome_rep ?rep;
 asm:infraspecific_name ?infraspecific_name;
 asm:isolate ?isolate;
 asm:organism_name ?organism_name;
 asm:paired_asm_comp ?paired_asm_comp;
 asm:release_date ?release_date;
 asm:release_type ?release_type;
 asm:species_taxid ?species_taxid;
 asm:submitter ?submitter;
 asm:tax_id ?tax_id;
 asm:taxon ?taxon;
 asm:version_status ?version_status;
 asm:wgs_master ?wgs_master;
 rdfs:seeAlso ?link.

values ?category {"representative-genome"}.
values ?version_status {"latest"}.
#FILTER(?predicate != asm:sequnece)
FILTER(?taxon_root = <http://identifiers.org/taxonomy/1117>).
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/1117>). #Cyanobacteria
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/3041>). #Chlorophyta
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/2763>). #Rhodophyta
#FILTER(?taxon_root = <http://identifiers.org/taxonomy/33090>). #Viridiplantae
?lineage rdfs:subClassOf* ?taxon_root.
FILTER(?lineage = ?taxon).

#FILTER(?link = <http://www.ncbi.nlm.nih.gov/assembly/GCF_000009725.1>).
#FILTER(?taxon = <http://identifiers.org/taxonomy/1148>).

}
#LIMIT 1000
#ORDER BY ?predicate


==

個人用ツール