VirtualFlyBrain / VFB_reporting

Scripts for reporting on the state of VFB content and pipeline
https://github.com/VirtualFlyBrain/VFB_reporting_results
0 stars 0 forks source link

Make report of all painted regions on each adult brain region #37

Open Clare72 opened 3 years ago

Clare72 commented 3 years ago
MATCH (p:pub { short_form: 'FBrf0224194'})<-[r:has_reference]-(c:Class)<-[:INSTANCEOF]-(i:Individual) where r.cat = 'BrainName official abbreviation' return distinct r.synonym
Clare72 commented 3 years ago

The above query no longer yields any results. Also some regions e.g. 'adult round body' do not have a BrainName abbreviation ('round body' does not seem to be mentioned in the BrainName paper.

This seems to pick up the right kind of stuff, but 420 results seems kind of low(?): MATCH p = (d:Class)<-[:SUBCLASSOF*]-(c:Class)<-[:INSTANCEOF]-(:Individual)<-[:depicts]-()-[:in_register_with]->(t:Template) WHERE c.short_form =~ 'FBbt.+' AND d.short_form in ['FBbt_00007060', 'FBbt_00007010', 'FBbt_00051068', 'FBbt_00051069'] RETURN distinct c.label, t.label ORDER BY t.label

Is there a better way?