# Pharma intelligence: an Omnigraph use case

Competitive intelligence for a biotech program: the compounds, trials and deals around it, the program's own assumptions, and which signals contradict them.

| | |
|---|---|
| Category | Research |
| Graph ID | pharma |
| Sample data | Viking Therapeutics' obesity program, from public sources: 113 nodes, 200 edges |
| Schema | 15 node types, 38 edge types |
| Stored queries | 70 reads, 35 writes |
| Source | https://github.com/ModernRelay/omnigraph-cookbooks/tree/main/pharma-intel |

## Node types

### Compound

- `slug: String` (key)
- `name: String`
- `generic_name: String?`
- `brief: String?`
- `description: String?`
- `modality: enum(small-molecule, peptide, biologic, antibody, gene-therapy, cell-therapy)?`
- `phase: enum(preclinical, phase-1, phase-2, phase-3, approved, discontinued, withdrawn)`
- `indication: String?`
- `moa_summary: String?`
- `route: enum(oral, subcutaneous, iv, intranasal, other)?`
- `first_in_human: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Mechanism

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `description: String?`
- `target: String?`
- `pathway: String?`
- `validation: enum(preclinical, clinical, approved, questioned)?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Trial

- `slug: String` (key)
- `name: String`
- `nct_id: String?`
- `phase: enum(phase-1, phase-2, phase-3, phase-4)?`
- `status: enum(not-started, enrolling, ongoing, completed, terminated, discontinued)`
- `design: String?`
- `primary_endpoint: String?`
- `enrollment: I32?`
- `readout_date: String?`
- `brief: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Company

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `ticker: String?`
- `type: enum(pharma, biotech, cro, academic, regulator, payer, investor, association)?`
- `hq: String?`
- `site: String?`

### Deal

- `slug: String` (key)
- `name: String`
- `type: enum(acquisition, license, collaboration, option, asset-purchase)?`
- `brief: String?`
- `value_usd_m: F64?`
- `upfront_usd_m: F64?`
- `announced_date: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### RegulatoryAction

- `slug: String` (key)
- `name: String`
- `agency: enum(fda, ema, pmda, mhra, nmpa, other)?`
- `type: enum(approval, crl, advisory-committee, guidance, warning-letter, withdrawal, priority-review, breakthrough, fast-track, label-change)?`
- `brief: String?`
- `description: String?`
- `action_date: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Signal

- `slug: String` (key)
- `name: String`
- `brief: String`
- `description: String?`
- `domain: enum(obesity, t2d, nash, cardiovascular, neuro, oncology, rare, payer, regulatory, manufacturing)?`
- `stagingTimestamp: DateTime`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Pattern

- `slug: String` (key)
- `name: String`
- `kind: enum(challenge, disruption, dynamic)`
- `brief: String?`
- `description: String?`
- `evolution: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Insight

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `description: String?`
- `importance: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### SourceEntity

- `slug: String` (key)
- `name: String`
- `type: enum(newswire, journal, regulatory-feed, company-press, earnings-call, analyst-report, conference, sec-filing, blog)?`
- `url: String?`

### InformationArtifact

- `slug: String` (key)
- `name: String`
- `artifactType: enum(press-release, sec-filing, trial-registration, fda-letter, article, paper, slide-deck, earnings-transcript, advisory-committee-doc)`
- `link: String?`
- `stagingTimestamp: DateTime`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Program

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `description: String?`
- `phase: enum(preclinical, phase-1, phase-2, phase-3, approved, discontinued)?`
- `indication: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Assumption

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `statement: String?`
- `level: enum(investment, scientific, competitive, strategic)`
- `established_date: String?`
- `source_url: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### Decision

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `description: String?`
- `decision_date: String?`
- `status: enum(upcoming, decided, deferred)`
- `decider: String?`
- `outcome: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

### OpenQuestion

- `slug: String` (key)
- `name: String`
- `brief: String?`
- `description: String?`
- `status: enum(open, resolved)`
- `asked_by: String?`
- `createdAt: DateTime`
- `updatedAt: DateTime`

## Edge types

- `Signal -[FormsPattern]-> Pattern`
- `Signal -[ContradictsPattern]-> Pattern`
- `Insight -[HighlightsPattern]-> Pattern`
- `Pattern -[DrivesPattern]-> Pattern`
- `Pattern -[ContradictsToPattern]-> Pattern`
- `Insight -[ReliesOnCompound]-> Compound`
- `Insight -[ReliesOnMechanism]-> Mechanism`
- `Signal -[AboutCompound]-> Compound`
- `Signal -[AboutMechanism]-> Mechanism`
- `Signal -[AboutTrial]-> Trial`
- `Signal -[AboutRegulatoryAction]-> RegulatoryAction`
- `Signal -[AboutDeal]-> Deal`
- `Signal -[RelevantCompany]-> Company`
- `Compound -[TargetsMechanism]-> Mechanism`
- `Compound -[DevelopedByCompany]-> Company`
- `Trial -[InvestigatesCompound]-> Compound`
- `Trial -[SponsoredByCompany]-> Company`
- `Deal -[DealLeadParty]-> Company`
- `Deal -[DealCounterParty]-> Company`
- `RegulatoryAction -[TargetsCompound]-> Compound`
- `RegulatoryAction -[TargetsMechanismReg]-> Mechanism`
- `Program -[ProgramDevelopsCompound]-> Compound`
- `Program -[ProgramTargetsMechanism]-> Mechanism`
- `Program -[ProgramOwnedByCompany]-> Company`
- `Program -[ProgramCompetesInMechanism]-> Mechanism`
- `Signal -[SupportsAssumption]-> Assumption`
- `Signal -[ContradictsAssumption]-> Assumption`
- `Signal -[InformsQuestion]-> OpenQuestion`
- `Program -[ProgramDependsOnAssumption]-> Assumption`
- `Decision -[DecisionRegardingProgram]-> Program`
- `Decision -[DecisionNeedsAnswer]-> OpenQuestion`
- `Decision -[DecisionBasedOnAssumption]-> Assumption`
- `OpenQuestion -[QuestionRegardingProgram]-> Program`
- `OpenQuestion -[QuestionRegardingMechanism]-> Mechanism`
- `OpenQuestion -[QuestionRegardingCompound]-> Compound`
- `InformationArtifact -[PublishedBySource]-> SourceEntity`
- `Signal -[SpottedInArtifact]-> InformationArtifact`
- `Signal -[SourcedFromSource]-> SourceEntity`

Full schema: https://github.com/ModernRelay/omnigraph-cookbooks/blob/main/pharma-intel/schema.pg

## Questions it answers

### Which signals contradict an assumption the program relies on?

```graphql
query assumption_contradicting_signals($slug: String) {
    match {
        $a: Assumption { slug: $slug }
        $s contradictsAssumption $a
    }
    return { $s.slug, $s.name, $s.brief, $s.stagingTimestamp }
    order { $s.stagingTimestamp desc }
}
```

### Which decisions are coming up?

```graphql
query decisions_upcoming() {
    match {
        $d: Decision { status: "upcoming" }
    }
    return { $d.slug, $d.name, $d.decision_date, $d.decider, $d.brief }
    order { $d.decision_date }
}
```

### Which compounds compete with the program?

```graphql
query program_competitors($slug: String) {
    match {
        $p: Program { slug: $slug }
        $p programCompetesInMechanism $m
        $c targetsMechanism $m
    }
    return { $c.slug, $c.name, $c.phase, $c.route, $c.moa_summary }
    order { $c.phase }
}
```

### Which compounds target a mechanism?

```graphql
query compounds_by_mechanism($mechanism: String) {
    match {
        $m: Mechanism { slug: $mechanism }
        $c targetsMechanism $m
    }
    return { $c.slug, $c.name, $c.phase, $c.route, $c.moa_summary }
    order { $c.phase }
}
```

## Stored queries

### queries/compounds.gq

- `get_compound`
- `compounds_all`
- `compounds_by_phase`
- `compounds_by_mechanism`
- `compound_sponsor`
- `compound_trials`
- `compound_signals`
- `get_mechanism`
- `mechanisms_all`
- `mechanism_compounds`
- `mechanism_signals`
- `mechanism_signals_via_compound`: All signals about ANY compound targeting this mechanism — wider rollup than aboutMechanism alone.

### queries/mutations.gq

- `add_compound` (write)
- `add_mechanism` (write)
- `add_trial` (write)
- `add_company` (write)
- `add_deal` (write)
- `add_regulatory` (write)
- `add_signal` (write)
- `add_pattern` (write)
- `add_insight` (write)
- `add_source` (write)
- `add_artifact` (write)
- `add_program` (write)
- `add_assumption` (write)
- `add_decision` (write)
- `add_question` (write)
- `link_forms_pattern` (write)
- `link_contradicts_pattern` (write)
- `link_highlights_pattern` (write)
- `link_drives_pattern` (write)
- `link_about_compound` (write)
- `link_about_mechanism` (write)
- `link_about_trial` (write)
- `link_relevant_company` (write)
- `link_compound_mechanism` (write)
- `link_compound_company` (write)
- `link_trial_compound` (write)
- `link_signal_supports_assumption` (write)
- `link_signal_contradicts_assumption` (write)
- `link_signal_informs_question` (write)
- `link_program_assumption` (write)
- `link_decision_program` (write)
- `link_decision_question` (write)
- `link_decision_assumption` (write)
- `link_artifact_source` (write)
- `link_signal_artifact` (write)

### queries/patterns.gq

- `get_pattern`
- `patterns_all`
- `patterns_by_kind`
- `pattern_signals`
- `pattern_contradictions`
- `pattern_drives`
- `pattern_contradicts_patterns`
- `pattern_insights`

### queries/pipeline.gq

- `get_trial`
- `trials_by_status`
- `trial_sponsor`
- `get_deal`
- `deals_all`
- `deal_parties`
- `get_regulatory`
- `regulatory_recent`
- `regulatory_compound`
- `get_company`
- `company_compounds`
- `get_insight`
- `insights_all`
- `insight_patterns`

### queries/programs.gq

- `get_program`
- `programs_all`
- `program_compound`
- `program_mechanism`
- `program_assumptions`
- `program_decisions`
- `program_competitors`
- `program_signals`: Signals about the program's compound — "what just happened on my asset".
- `program_landscape_signals`: Signals about ANY compound targeting the program's mechanism — competitive landscape feed.
- `get_assumption`
- `assumptions_all`
- `assumption_supporting_signals`
- `assumption_contradicting_signals`
- `get_decision`
- `decisions_upcoming`
- `decisions_all`
- `decision_program`
- `decision_questions`
- `decision_assumptions`
- `get_question`
- `questions_open`
- `question_signals`

### queries/signals.gq

- `get_signal`
- `recent_signals`
- `search_signals`
- `signals_by_domain`
- `signal_patterns`
- `signal_contradictions`
- `signal_compound`
- `signal_mechanism`
- `signal_trial`
- `signal_companies`
- `signal_supports_assumptions`
- `signal_contradicts_assumptions`
- `signal_informs_questions`
- `signal_artifacts`

## Run it

```bash
git clone https://github.com/ModernRelay/omnigraph-cookbooks
cd omnigraph-cookbooks
export COOKBOOK=$PWD/pharma-intel
omnigraph cluster validate --config "$COOKBOOK"
omnigraph cluster apply --target "$COOKBOOK" --config "$COOKBOOK" --as act-admin --json
```

The full local setup (server, sample data, queries): https://github.com/ModernRelay/omnigraph-cookbooks#local-setup

Source: https://www.omnigraph.dev/use-cases/pharma-intel
