Write Neo4J queries & schema for VFB content report.

[dosumis]

Draft report content & queries

Number of neuron types + number of refs

MATCH (c:Class:Neuron) where c.short_form =~ 'FBbt.+'  
WITH c OPTIONAL MATCH (c)-[]->(p:pub) 
RETURN count(distinct c), count (distinct p)

Number of nervous system regions + number of refs

MATCH (c:Class) WHERE c.short_form =~ 'FBbt.+' 
AND ANY(x IN['Synaptic_neuropil', 'Neuron_projection_bundle', 'Ganglion', 'Neuromere']
                  WHERE x in labels(c)) 
WITH c OPTIONAL MATCH (c)-[]->(p:pub) 
RETURN count(distinct c), count (distinct p)

Number of images & datasets (in production)

MATCH (i:Individual)-[]->(n:DataSet) WHERE n.production 
 RETURN count distinct(i) count distinct(n)

Number of split types and images:

MATCH (i:Split)-[:INSTANCEOF]->(c:Class) 
RETURN count (distinct i), count (distinct c)

...or more elaborate, with dataset pub check & annotation count:

MATCH (ds:DataSet)<-[]-(i:Split)-[:INSTANCEOF]->(c:Class) 
WHERE ds.production
WITH i, c OPTIONAL MATCH (anoni:Individual)-[r]->(c) 
WHERE exists(r.pub) 
RETURN count (distinct i), count (distinct c), count (distinct r)

[dosumis]

All of these queries should go into a script that generates a report node every time pdb is built.

How to put version information on node?

1. Datestamp release
2. Would be good to get ontology and FlyBase IDs in .... (investigate getting ontology version iri in through KB update. Easy if in JSON).