Noel Southall

Can you provide an example URL that demonstrates the kind of filtering that you are doing? Simple stuff like http://stitcher.ncats.io/api/stitches/latest?skip=10&top=5 seems to be working

OK. What is going on here is a little complicated. Let me try and break that down as best I can. TLDR = we run out of memory on the...

Maybe we should start by separating previously marketed versus previously approved

[development status breakdown v3 (1).xlsx](https://github.com/ncats/stitcher/files/4820688/development.status.breakdown.v3.1.xlsx)

Lemon oil seems problematic ... https://stitcher-dev.ncats.io/api/stitches/latest/ET5GD00TRP

source: "03635f758", id: "ACETYL CERAMIDE", COMPOUND_QCD: [ "false" ], CompoundName: [ "ACETYL CERAMIDE" ], CompoundSynonym: [ "C2 ceramide", "N-[(2R,3S,4E)-1,3-Dihydroxy-4-octadecen-2-yl]acetamide", "N-acetylsphingosine", "C2-ceramide", "N-(acetyl)-sphing-4-enine", "C2 Ceramide (d18:1/2:0)", "N-Acetyl-D-sphingosine" ], CompoundSmiles: [ "CCCCCCCCCCCCCC=C[C@H](O)[C@@H](CO)NC(C)=O"...

https://stitcher-dev.ncats.io/app/stitches/v1/ACETYL%20CERAMIDE

Definition of reconcilitation by others: https://github.com/OpenRefine/OpenRefine/wiki/Reconciliation Other initiatives: https://microsoft.github.io/BLURB/

Definition of drug and, for example, active moiety https://pubmed.ncbi.nlm.nih.gov/21347074/ https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5111807/ https://bitbucket.org/uamsdbmi/dron/src/master/dron-hand.owl https://www.nlm.nih.gov/research/umls/rxnorm/docs/appendix1.html https://biolink.github.io/biolink-model/docs/subclass_of.html

just download the owl file from here https://www.ebi.ac.uk/ols/ontologies/chebi , then add this to the build script sbt -Djdk.xml.entityExpansionLimit=0 stitcher/"runMain ncats.stitcher.impl.OntEntityFactory STITCHER_DB hash.db $owl_path/chebi.owl.gz"