Add MIE-to-AO Path Length Distribution visualization

[marvinm2]

Description

Analyze and visualize the distribution of pathway lengths (number of Key Events) from Molecular Initiating Events to Adverse Outcomes across all AOPs. Longer pathways indicate more complex biological mechanisms, while shorter pathways represent simpler causal chains.

Visualization Types

• Latest snapshot: Current distribution of pathway lengths
• Historical trends: Evolution of pathway complexity over time

Value & Priority

• Priority: Phase 1 - High Priority
• Value: High
• Complexity: Medium

Implementation Details

Key Data Requirements

• Query AOPs with both MIE and AO defined
• Count intermediate KEs between MIE and AO for each AOP
• Group by pathway length categories:
  • 2-3 KEs (simple pathways)
  • 4-5 KEs (moderate pathways)
  • 6-8 KEs (complex pathways)
  • 9+ KEs (highly complex pathways)

SPARQL Query Pattern

SELECT ?aop (COUNT(DISTINCT ?ke) AS ?ke_count)
WHERE {
  GRAPH ?graph {
    ?aop a aopo:AdverseOutcomePathway ;
         aopo:has_molecular_initiating_event ?mie ;
         aopo:has_adverse_outcome ?ao ;
         aopo:has_key_event ?ke .
  }
  FILTER(STRSTARTS(STR(?graph), "http://aopwiki.org/graph/"))
}
GROUP BY ?aop

Visualization Format

• Latest view: Box plot or histogram showing pathway length distribution
• Trends view: Violin plot over time showing distribution evolution

Expected Insights

• Understand structural complexity patterns across AOPs
• Identify simple vs. complex biological mechanisms
• Track AOP development maturity (incomplete AOPs may have fewer KEs)
• Guide curation efforts for pathway completeness
• Support OECD evaluation of pathway characterization

Performance Notes

• Medium complexity - requires joining MIE, AO, and KE relationships
• Should be performant with GROUP BY aggregation
• May need optimization if pathway traversal becomes complex