{
  "_id": "6a103a91acfb0bcc41c9b3e1",
  "Package": "ontoProc2",
  "Date": "2026-03-16",
  "Title": "Ontology Facilities Based on INCAtools Semantic SQL",
  "Version": "0.99.20",
  "Authors@R": "c(person(\n\"Vincent\", \"Carey\", role = c(\"aut\", \"cre\"),\nemail = \"stvjc@channing.harvard.edu\",\ncomment = c(ORCID = \"0000-0003-4046-0063\")),\nperson(\"Anthropic-Claude\", \"Sonnet4.6\", role=\"eng\"),\nperson(\n\"NIH NHGRI 2U24HG004059-17\",\nrole = \"fnd\"\n)\n)",
  "Description": "This package provides ontology facilities based on\nINCAtools Semantic SQL.  Tooling is provided to retrieve and\ncache SQLite databases representing curated ontologies.\nontologyIndex ontology_index instances can be produced.\nAnthropic's Claude was used in the development of S7 classes\nand methods and in the production of documentation.",
  "License": "Artistic-2.0",
  "Encoding": "UTF-8",
  "VignetteBuilder": "knitr",
  "biocViews": "Infrastructure, DataRepresentation, Pathways, SingleCell",
  "URL": "https://github.com/vjcitn/ontoProc2",
  "BugReports": "https://github.com/vjcitn/ontoProc2/issues",
  "Config/roxygen2/version": "8.0.0",
  "Roxygen": "list(markdown = TRUE)",
  "Config/pak/sysreqs": "libicu-dev libssl-dev zlib1g-dev",
  "Repository": "https://biocstaging.r-universe.dev",
  "Date/Publication": "2026-05-11 23:01:49 UTC",
  "RemoteUrl": "https://github.com/BiocStaging/ontoProc2",
  "RemoteRef": "HEAD",
  "RemoteSha": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-12 00:05:59 UTC",
    "User": "root"
  },
  "Author": "Vincent Carey [aut, cre] (ORCID:\n<https://orcid.org/0000-0003-4046-0063>),\nAnthropic-Claude Sonnet4.6 [eng],\nNIH NHGRI 2U24HG004059-17 [fnd]",
  "Maintainer": "Vincent Carey <stvjc@channing.harvard.edu>",
  "MD5sum": "4195703cb21af0ba48ccc100c192d5ed",
  "_user": "biocstaging",
  "_type": "src",
  "_file": "ontoProc2_0.99.20.tar.gz",
  "_fileid": "2308929b3ea4b193094ba8c90ee181c24c66dbacabb26c51de9e1590bc305c2f",
  "_filesize": 1029683,
  "_sha256": "2308929b3ea4b193094ba8c90ee181c24c66dbacabb26c51de9e1590bc305c2f",
  "_created": "2026-05-12T00:05:59.000Z",
  "_published": "2026-05-22T11:14:25.137Z",
  "_jobs": [
    {
      "job": 77368363926,
      "time": 186,
      "config": "bioc-checks",
      "r": "4.6.0",
      "check": "NOTE",
      "artifact": "6932734006"
    },
    {
      "job": 77368364020,
      "time": 283,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6932752762"
    },
    {
      "job": 77368364421,
      "time": 278,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6932751791"
    },
    {
      "job": 77368364395,
      "time": 192,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6932735289"
    },
    {
      "job": 77368364339,
      "time": 250,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6932746432"
    },
    {
      "job": 77368363758,
      "time": 362,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6932698174"
    },
    {
      "job": 77368363648,
      "time": 142,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7159148060"
    },
    {
      "job": 77368363977,
      "time": 453,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6932784265"
    },
    {
      "job": 77368364383,
      "time": 405,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6932775662"
    },
    {
      "job": 77368364304,
      "time": 280,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6932752078"
    }
  ],
  "_bioccheck": {
    "error": 0,
    "warning": 0,
    "note": 9
  },
  "_buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/BiocStaging/ontoProc2",
  "_commit": {
    "id": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
    "author": "vjcitn <stvjc@channing.harvard.edu>",
    "committer": "vjcitn <stvjc@channing.harvard.edu>",
    "message": "remove swap file\n",
    "time": 1778540509
  },
  "_maintainer": {
    "name": "Vincent Carey",
    "email": "stvjc@channing.harvard.edu",
    "login": "vjcitn",
    "uuid": 4624066,
    "orcid": "0000-0003-4046-0063"
  },
  "_distro": "noble",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.5.0",
      "role": "Depends"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "BiocFileCache",
      "role": "Imports"
    },
    {
      "package": "R.utils",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "ontologyIndex",
      "role": "Imports"
    },
    {
      "package": "ontologyPlot",
      "role": "Imports"
    },
    {
      "package": "graph",
      "role": "Imports"
    },
    {
      "package": "Rgraphviz",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "S7",
      "role": "Imports"
    },
    {
      "package": "utils",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    },
    {
      "package": "BiocStyle",
      "role": "Suggests"
    },
    {
      "package": "DT",
      "role": "Suggests"
    },
    {
      "package": "GO.db",
      "role": "Suggests"
    },
    {
      "package": "AnnotationDbi",
      "role": "Suggests"
    },
    {
      "package": "stringr",
      "role": "Suggests"
    }
  ],
  "_owner": "biocstaging",
  "_selfowned": true,
  "_usedby": 1,
  "_updates": [
    {
      "week": "2025-44",
      "n": 8
    },
    {
      "week": "2026-08",
      "n": 5
    },
    {
      "week": "2026-12",
      "n": 13
    },
    {
      "week": "2026-13",
      "n": 5
    },
    {
      "week": "2026-14",
      "n": 5
    },
    {
      "week": "2026-15",
      "n": 2
    },
    {
      "week": "2026-16",
      "n": 2
    },
    {
      "week": "2026-19",
      "n": 2
    },
    {
      "week": "2026-20",
      "n": 5
    }
  ],
  "_tags": [],
  "_topics": [
    "infrastructure",
    "datarepresentation",
    "pathways",
    "singlecell"
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "vjcitn",
      "count": 58,
      "uuid": 4624066
    }
  ],
  "_userbio": {
    "uuid": 278472782,
    "type": "organization",
    "name": "BiocStaging"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ontoProc2"
  },
  "_devurl": "https://github.com/vjcitn/ontoproc2",
  "_searchresults": 16,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/ontoProc2.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "cells_with_pmp",
    "count_by_prefix",
    "count_descendants",
    "describe_table",
    "disconnect",
    "find_by_restriction",
    "find_intersection",
    "get_ancestors",
    "get_ancestors_partonomy",
    "get_definition",
    "get_descendants",
    "get_descendants_partonomy",
    "get_direct_edges",
    "get_direct_subclasses",
    "get_direct_superclasses",
    "get_label",
    "get_prefix",
    "get_present_pmp",
    "get_restrictions",
    "get_synonyms",
    "get_term_info",
    "improve_nodes",
    "is_connected",
    "list_tables",
    "make_graphNEL_from_ontology_plot",
    "onto_plot2",
    "PREDICATES",
    "reconnect",
    "report",
    "retrieve_semsql_conn",
    "run_query",
    "search_labels",
    "semsql_connect",
    "semsql_to_oi",
    "semsql_url",
    "SemsqlConn",
    "with_connection"
  ],
  "_datasets": [
    {
      "name": "cn2tag",
      "title": "a named vector with mapping from cell type phrase to CURIE for CL.owl of 2025-12-17",
      "object": "cn2tag",
      "file": "cn2tag.rda",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "ncit_map",
      "title": "a named vector with values rdfs labels in NCI thesaurus, and names the corresponding formal ontology tags",
      "object": "ncit_map",
      "file": "ncit_map.rda",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    },
    {
      "name": "tag2cn",
      "title": "a named vector with mapping from CURIE to cell type phrase for CL.owl of 2025-12-17",
      "object": "tag2cn",
      "file": "tag2cn.rda",
      "class": [
        "character"
      ],
      "fields": [],
      "table": false,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "cells_with_pmp",
      "title": "produce a table with cells exhibiting given proteins on plasma membrane according to CL",
      "topics": [
        "cells_with_pmp"
      ]
    },
    {
      "page": "cn2tag",
      "title": "a named vector with mapping from cell type phrase to CURIE for CL.owl of 2025-12-17",
      "topics": [
        "cn2tag"
      ]
    },
    {
      "page": "count_by_prefix",
      "title": "Count labeled terms grouped by CURIE prefix",
      "topics": [
        "count_by_prefix"
      ]
    },
    {
      "page": "count_descendants",
      "title": "Count the number of descendants of a term",
      "topics": [
        "count_descendants"
      ]
    },
    {
      "page": "describe_table",
      "title": "Describe the columns of a table in a SemsqlConn database",
      "topics": [
        "describe_table"
      ]
    },
    {
      "page": "disconnect",
      "title": "Disconnect a SemsqlConn from its database",
      "topics": [
        "disconnect"
      ]
    },
    {
      "page": "find_by_restriction",
      "title": "Find terms that have a given OWL someValuesFrom restriction",
      "topics": [
        "find_by_restriction"
      ]
    },
    {
      "page": "find_intersection",
      "title": "Find terms that are descendants of a superclass and have a given restriction",
      "topics": [
        "find_intersection"
      ]
    },
    {
      "page": "get_ancestors",
      "title": "Get all ancestors of a term via entailed edges",
      "topics": [
        "get_ancestors"
      ]
    },
    {
      "page": "get_ancestors_partonomy",
      "title": "Get ancestors traversing both is-a and part-of relationships",
      "topics": [
        "get_ancestors_partonomy"
      ]
    },
    {
      "page": "get_definition",
      "title": "Get the text definition for a term",
      "topics": [
        "get_definition"
      ]
    },
    {
      "page": "get_descendants",
      "title": "Get all descendants of a term via entailed edges",
      "topics": [
        "get_descendants"
      ]
    },
    {
      "page": "get_descendants_partonomy",
      "title": "Get descendants traversing both is-a and has-part relationships",
      "topics": [
        "get_descendants_partonomy"
      ]
    },
    {
      "page": "get_direct_edges",
      "title": "Get direct edges in the ontology graph for a term",
      "topics": [
        "get_direct_edges"
      ]
    },
    {
      "page": "get_direct_subclasses",
      "title": "Get direct subclasses of a term",
      "topics": [
        "get_direct_subclasses"
      ]
    },
    {
      "page": "get_direct_superclasses",
      "title": "Get direct superclasses of a term",
      "topics": [
        "get_direct_superclasses"
      ]
    },
    {
      "page": "get_label",
      "title": "Get the rdfs:label for a term",
      "topics": [
        "get_label"
      ]
    },
    {
      "page": "get_prefix",
      "title": "Retrieve the ontology prefix from a SemsqlConn",
      "topics": [
        "get_prefix"
      ]
    },
    {
      "page": "get_present_pmp",
      "title": "produce a table with list of proteins from protein ontology identified as present on cell membranes for input cell type CURIEs",
      "topics": [
        "get_present_pmp"
      ]
    },
    {
      "page": "get_restrictions",
      "title": "Get OWL someValuesFrom restrictions for a term",
      "topics": [
        "get_restrictions"
      ]
    },
    {
      "page": "get_synonyms",
      "title": "Get synonyms for a term",
      "topics": [
        "get_synonyms"
      ]
    },
    {
      "page": "get_term_info",
      "title": "Retrieve a summary of information about a term",
      "topics": [
        "get_term_info"
      ]
    },
    {
      "page": "improve_nodes",
      "title": "inject linefeeds for node names for graph, with textual annotation from ontology",
      "topics": [
        "improve_nodes"
      ]
    },
    {
      "page": "is_connected",
      "title": "Test whether a SemsqlConn has a valid open connection",
      "topics": [
        "is_connected"
      ]
    },
    {
      "page": "list_tables",
      "title": "List tables in a SemsqlConn database",
      "topics": [
        "list_tables"
      ]
    },
    {
      "page": "make_graphNEL_from_ontology_plot",
      "title": "obtain graphNEL from ontology_plot instance of ontologyPlot",
      "topics": [
        "make_graphNEL_from_ontology_plot"
      ]
    },
    {
      "page": "ncit_map",
      "title": "a named vector with values rdfs labels in NCI thesaurus, and names the corresponding formal ontology tags",
      "topics": [
        "ncit_map"
      ]
    },
    {
      "page": "onto_plot2",
      "title": "high-level use of graph/Rgraphviz for rendering ontology relations",
      "topics": [
        "onto_plot2"
      ]
    },
    {
      "page": "PREDICATES",
      "title": "Standard predicate CURIEs used in OBO ontologies",
      "topics": [
        "PREDICATES"
      ]
    },
    {
      "page": "print",
      "title": "Show method for SemsqlConn. Concise one-line summary displayed when a 'SemsqlConn' object is auto-printed at the R prompt.",
      "topics": [
        "print"
      ]
    },
    {
      "page": "reconnect",
      "title": "Reconnect a SemsqlConn to its database",
      "topics": [
        "reconnect"
      ]
    },
    {
      "page": "report",
      "title": "Display a detailed report of a SemsqlConn object",
      "topics": [
        "report",
        "report,ontoProc2::SemsqlConn-method"
      ]
    },
    {
      "page": "retrieve_semsql_conn",
      "title": "return a SQLite connection (read only) to an INCAtools Semantic SQL ontology",
      "topics": [
        "retrieve_semsql_conn"
      ]
    },
    {
      "page": "run_query",
      "title": "Run an arbitrary SQL query against a SemsqlConn database",
      "topics": [
        "run_query"
      ]
    },
    {
      "page": "search_labels",
      "title": "Search term labels in a SemsqlConn database",
      "topics": [
        "search_labels"
      ]
    },
    {
      "page": "semsql_connect",
      "title": "Create a SemsqlConn connection",
      "topics": [
        "semsql_connect"
      ]
    },
    {
      "page": "semsql_to_oi",
      "title": "produce an ontology_index instance from semantic sql sqlite connection",
      "topics": [
        "semsql_to_oi"
      ]
    },
    {
      "page": "semsql_url",
      "title": "produce INCAtools distribution URL",
      "topics": [
        "semsql_url"
      ]
    },
    {
      "page": "SemsqlConn",
      "title": "SemsqlConn: S7 connection wrapper for SemanticSQL databases",
      "topics": [
        "SemsqlConn"
      ]
    },
    {
      "page": "tag2cn",
      "title": "a named vector with mapping from CURIE to cell type phrase for CL.owl of 2025-12-17",
      "topics": [
        "tag2cn"
      ]
    },
    {
      "page": "with_connection",
      "title": "Execute code with an automatically managed SemsqlConn",
      "topics": [
        "with_connection"
      ]
    }
  ],
  "_readme": "https://github.com/BiocStaging/ontoProc2/raw/HEAD/README.md",
  "_rundeps": [
    "askpass",
    "BiocFileCache",
    "BiocGenerics",
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "curl",
    "DBI",
    "dbplyr",
    "dplyr",
    "fastmap",
    "filelock",
    "generics",
    "glue",
    "graph",
    "httr2",
    "lifecycle",
    "magrittr",
    "memoise",
    "ontologyIndex",
    "ontologyPlot",
    "openssl",
    "paintmap",
    "pillar",
    "pkgconfig",
    "purrr",
    "R.methodsS3",
    "R.oo",
    "R.utils",
    "R6",
    "rappdirs",
    "Rgraphviz",
    "rlang",
    "RSQLite",
    "S7",
    "stringi",
    "stringr",
    "sys",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "celltoprotein.Rmd",
      "filename": "celltoprotein.html",
      "title": "celltoprotein -- connecting Cell and Protein Ontologies",
      "author": "Vincent J. Carey, stvjc at channing.harvard.edu",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Given a cell type, what proteins are noted as parts of its plasma membrane?",
        "Given a protein, what cell types are asserted to possess it as a membrane part?",
        "Some details",
        "Session information"
      ],
      "created": "2026-03-25 10:00:26",
      "modified": "2026-03-31 20:21:25",
      "commits": 6
    },
    {
      "source": "ontoProc2.Rmd",
      "filename": "ontoProc2.html",
      "title": "ontoProc2 -- leveraging semantic SQL for ontology analysis in Bioconductor",
      "author": "Vincent J. Carey, stvjc at channing.harvard.edu",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Installation",
        "Acquiring ontologies",
        "Make a connection",
        "Make a report",
        "Probe the back end",
        "Use tidy methods",
        "Transformation to ontology_index instances",
        "Background",
        "Searching in label text",
        "Exploring concept properties with 'edge tables'",
        "Generalizing a concept: Ancestors",
        "Working with multiple ontologies",
        "Session information"
      ],
      "created": "2025-10-27 12:07:10",
      "modified": "2026-05-11 21:17:14",
      "commits": 9
    },
    {
      "source": "uberonpeek.Rmd",
      "filename": "uberonpeek.html",
      "title": "uberonpeek -- a look at UBERON ontology, etc., with ontoProc2",
      "author": "Vincent J. Carey, stvjc at channing.harvard.edu",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Introduction",
        "Parent-child relations",
        "EFO and NCI thesaurus",
        "Session information"
      ],
      "created": "2023-09-07 20:03:53",
      "modified": "2026-03-31 18:12:14",
      "commits": 6
    }
  ],
  "_score": 4.811575005870593,
  "_indexed": true,
  "_nocasepkg": "ontoproc2",
  "_universes": [
    "biocstaging",
    "vjcitn"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.99.20",
      "date": "2026-05-12T00:08:44.000Z",
      "distro": "noble",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "b208b63397d97a72ae6a463bb76323d4aa567c55fdd4ccf4de0af4b3f1656f34",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.99.20",
      "date": "2026-05-12T00:08:41.000Z",
      "distro": "noble",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "61183223ef3c617bd8ca2231809c3545b1731fbdbfa6725c9bf2e1d43918ef8a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.99.20",
      "date": "2026-05-12T00:07:41.000Z",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "296414994e5cf29ddb5c9df973b9871737d6b10cd5eb90769078791a1c01825c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.99.20",
      "date": "2026-05-12T00:08:02.000Z",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "f921d13440483c949216317befded7408951b4f5666bfb68d94e79eb8917799d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.99.20",
      "date": "2026-05-12T00:10:17.000Z",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "6797221f43e387345d027294d8bc232cb586fb58f341f5ce51c5018941aca918",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.99.20",
      "date": "2026-05-12T00:09:56.000Z",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "39221fdd9c5ef69f36991a9d9316e13cc97b5e601ed880e6bfa1b77487b1da5f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.99.20",
      "date": "2026-05-12T00:07:35.000Z",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "7f8bdfecea908735f8450aa8abf18e7e87535c971110cd0977daf3f9a7461f3f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.99.20",
      "date": "2026-05-22T11:14:06.000Z",
      "commit": "afb9147c1cd4341a4f5ed2b76d32e4f688b3cf10",
      "fileid": "343b3287985b3c386c90d3652faa55ebc346a983575bea2e3530fe94fbdcdd9c",
      "status": "success",
      "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25704579127"
    }
  ]
}