Add SPARQL queries to get stats for manuscript

[shawntanzk]

In the BDSO manuscript

The current release (date) of the BDSO component (which PCL imports) contains X number of individuals, out of which X are clusters (individuals also include datasets), and X number of classes, out of which X have PCL namespace and X are cell types (classes also include genes and ns forest sets).

We need the following SPARQL queries:

• number of individuals with PCL namespace (pcl_individual.sparql)
• individuals that are clusters (pcl_cluster.sparql)
• number classes (class-count-by-prefix.sparql)
• number classes with PCL namespace (class-count-by-prefix.sparql)
• number of cell types with PCL namespace (for this I assume that all cell types are subclassof native cell) [pcl-celltypes-count.sparql]

[shawntanzk]

need help with individuals that are clusters
I think the way to do it is to select only those that have cluster ids (obo:PCL_0010059)
I've tried:

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX obo: <http://purl.obolibrary.org/obo/PCL_>

SELECT (COUNT (DISTINCT ?ind) as ?indcount)
WHERE {
    ?ind a owl:NamedIndividual ;
    <obo:PCL_0010059> ?cluster </obo:PCL_0010059>
  FILTER(isIRI(?ind) && (STRSTARTS(str(?ind), "http://purl.obolibrary.org/obo/PCL_")))
}

and

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX obo: <http://purl.obolibrary.org/obo/PCL_>

SELECT (COUNT (DISTINCT ?ind) as ?indcount)
WHERE {
    ?ind a owl:NamedIndividual ;
    ?ind obo:PCL_0010059 ?cluster
  FILTER(isIRI(?ind) && (STRSTARTS(str(?ind), "http://purl.obolibrary.org/obo/PCL_")))
}

and both don't work - I can copy the whole list of stuff with individuals, but im sure there is a better way?

[hkir-dev]

Is this what we expect?

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX pcl: <http://purl.obolibrary.org/obo/PCL_>

SELECT (COUNT (DISTINCT ?ind) as ?indcount)
WHERE {
    ?ind a owl:NamedIndividual ;
    pcl:0010059 ?cluster.
  FILTER(isIRI(?ind) && (STRSTARTS(str(?ind), "http://purl.obolibrary.org/obo/PCL_")))
}

[shawntanzk]

lol ok, that makes sense, probably right, will change and do a test. Thanks :)

done, looks right

[shawntanzk]

will keep this ticket till inserted into manuscript