semantic-sql
semantic-sql copied to clipboard
INCATools
SQL and SQLite builds of OWL ontologies
We use S3 URLs a lot in OAK code and docs: https://github.com/INCATools/ontology-access-kit/search?q=https%3A%2F%2Fs3.amazonaws.com%2Fbbop-sqlite%2F We should create w3id.org/semsql/ to have a PURL for the downloads OR we include this with OBO PURLs
See https://github.com/OBOFoundry/OBOFoundry.github.io/issues/2307#issuecomment-2287584654
### KEGG Ontology Prefix Handling We are currently using two KEGG prefixes: - **kegg.reaction** ([KEGG Reaction](https://bioregistry.io/registry/kegg.reaction)) - **kegg.pathway** ([KEGG Pathway](https://bioregistry.io/registry/kegg.pathway)) Both of these prefixes resolve to the same base URL:...
We wanted to avoid it going into the SQL models, because that would cause errors on older sqlite builds when using that version of semsql (e.g. in OAK). This has...
As part of KBase's work with ontologies in semsql, it would be very handy to be able to export as DSV directly, rather than going via the sqlite database. We...
the skos predicate for "has exact match" should be [_skos:exactMatch_](https://movielabs.com/cwontology/htmldoc/skos_exactMatch.html), not skos:hasExactMatch see for example: https://github.com/INCATools/semantic-sql/blob/fca69e0604f60722a9a4927836dd55e4f88d2f91/src/semsql/builder/sql_schema/semsql.sql#L1451 (and so forth for [broad](https://movielabs.com/cwontology/htmldoc/skos_broadMatch.html), [narrow](https://movielabs.com/cwontology/htmldoc/skos_narrowMatch.html), [related](https://movielabs.com/cwontology/htmldoc/skos_relatedMatch.html) matches) Is this done this way for...
