{ "_id": "6a1018fdacfb0bcc41c85cc6", "Package": "GO.ddb", "Title": "Tidy Interface to GO Semantic SQL via DuckDB", "Version": "0.99.4", "Authors@R": "c(person(\"Vincent\", \"Carey\", email = \"stvjc@channing.harvard.edu\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0003-4046-0063\")), person(\"Claude\", \"Sonnet46\", role=\"eng\"))", "Description": "Provides a tidyverse-oriented user interface to Gene\nOntology data via the Semantic SQL representation, accessed\nthrough DuckDB. Replaces the GO.db + AnnotationDbi::select\nnexus with lazy tibble-based operations for term lookup,\nancestor/descendant traversal, and gene-GO annotation queries.\nThe Semantic SQL resource is managed by the ontoProc2 package\nvia BiocFileCache.", "License": "Artistic-2.0", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "biocViews": "Annotation, GO, Ontology", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Config/pak/sysreqs": "libicu-dev libssl-dev xz-utils zlib1g-dev", "Repository": "https://biocstaging.r-universe.dev", "Date/Publication": "2026-05-14 18:25:07 UTC", "RemoteUrl": "https://github.com/BiocStaging/GO.ddb", "RemoteRef": "HEAD", "RemoteSha": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-14 19:40:17 UTC", "User": "root" }, "Author": "Vincent Carey [aut, cre] (ORCID:\n),\nClaude Sonnet46 [eng]", "Maintainer": "Vincent Carey ", "MD5sum": "6f3801b3f970e68142400737228c1ed3", "_user": "biocstaging", "_type": "src", "_file": "GO.ddb_0.99.4.tar.gz", "_fileid": "2e80eb200bb1d22b520fb63dc712a7f7df7e845c4c7dc66571e1326734d406ae", "_filesize": 347977, "_sha256": "2e80eb200bb1d22b520fb63dc712a7f7df7e845c4c7dc66571e1326734d406ae", "_created": "2026-05-14T19:40:17.000Z", "_published": "2026-05-22T08:51:09.288Z", "_jobs": [ { "job": 77347007112, "time": 172, "config": "bioc-checks", "r": "4.6.0", "check": "WARNING", "artifact": "7003237199" }, { "job": 77347001252, "time": 307, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "WARNING", "artifact": "7003282650" }, { "job": 77346998056, "time": 322, "config": "linux-release-x86_64", "r": "4.6.0", "check": "WARNING", "artifact": "7003284706" }, { "job": 77347006916, "time": 174, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "WARNING", "artifact": "7003244362" }, { "job": 77346984572, "time": 216, "config": "macos-release-arm64", "r": "4.6.0", "check": "WARNING", "artifact": "7003288400" }, { "job": 77347002863, "time": 282, "config": "source", "r": "4.6.0", "check": "ERROR", "artifact": "7003177412" }, { "job": 77346983911, "time": 143, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7156558345" }, { "job": 77346984584, "time": 452, "config": "windows-devel", "r": "4.7.0", "check": "WARNING", "artifact": "7003319215" }, { "job": 77346984597, "time": 490, "config": "windows-oldrel", "r": "4.5.3", "check": "ERROR", "artifact": "7003338800" }, { "job": 77346984529, "time": 452, "config": "windows-release", "r": "4.6.0", "check": "WARNING", "artifact": "7003326258" } ], "_bioccheck": { "error": 0, "warning": 1, "note": 11 }, "_buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685", "_status": "failure", "_host": "GitHub-Actions", "_upstream": "https://github.com/BiocStaging/GO.ddb", "_commit": { "id": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "author": "vjcitn ", "committer": "vjcitn ", "message": "update the vignette\n", "time": 1778783107 }, "_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.1.0", "role": "Depends" }, { "package": "ontoProc2", "role": "Imports" }, { "package": "duckdb", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "BiocFileCache", "role": "Imports" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "DT", "role": "Suggests" }, { "package": "BiocStyle", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "withr", "role": "Suggests" }, { "package": "hedgehog", "role": "Suggests" }, { "package": "GO.db", "role": "Suggests" } ], "_owner": "biocstaging", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-17", "n": 8 }, { "week": "2026-20", "n": 10 } ], "_tags": [], "_topics": [ "annotation", "go", "ontology" ], "_stars": 0, "_contributors": [ { "user": "vjcitn", "count": 22, "uuid": 4624066 } ], "_userbio": { "uuid": 278472782, "type": "organization", "name": "BiocStaging" }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/GO.ddb" }, "_devurl": "https://github.com/biocstaging/go.ddb", "_searchresults": 2, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/GO.ddb.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_exports": [ "build_parquet_cache", "disconnect_go", "get_go_con", "go_ancestors", "go_connection_active", "go_descendants", "go_entailed_edges", "GO_RELATIONS", "go_statements", "go_synonyms", "go_terms", "has_parquet_cache", "lookup_curie", "make_go_con", "select_go" ], "_help": [ { "page": "build_parquet_cache", "title": "Populate the local parquet cache from a semsql SQLite file", "topics": [ "build_parquet_cache" ] }, { "page": "disconnect_go", "title": "Close the cached GO semsql connection", "topics": [ "disconnect_go" ] }, { "page": "get_go_con", "title": "Return the raw DuckDB connection from the package cache", "topics": [ "get_go_con" ] }, { "page": "go_ancestors", "title": "Retrieve ancestors of GO terms", "topics": [ "go_ancestors" ] }, { "page": "go_connection_active", "title": "Report whether a live GO connection is cached", "topics": [ "go_connection_active" ] }, { "page": "go_descendants", "title": "Retrieve descendants of GO terms", "topics": [ "go_descendants" ] }, { "page": "go_entailed_edges", "title": "Lazy tbl for the semsql entailed_edge table", "topics": [ "go_entailed_edges" ] }, { "page": "GO_RELATIONS", "title": "Curated GO relation CURIEs for ontology traversal", "topics": [ "GO_RELATIONS" ] }, { "page": "go_statements", "title": "Lazy tbl for the semsql statements table", "topics": [ "go_statements" ] }, { "page": "go_synonyms", "title": "Lazy tbl of GO term synonyms", "topics": [ "go_synonyms" ] }, { "page": "go_terms", "title": "Lazy tbl of GO term metadata", "topics": [ "go_terms" ] }, { "page": "has_parquet_cache", "title": "Test whether a local parquet cache exists for an ontology Checks that the parquet cache directory exists and contains at least the two required files: 'statements.parquet' and 'entailed_edge.parquet'.", "topics": [ "has_parquet_cache" ] }, { "page": "lookup_curie", "title": "Look up GO term metadata by CURIE", "topics": [ "lookup_curie" ] }, { "page": "make_go_con", "title": "Establish a connection to the GO semsql database", "topics": [ "make_go_con" ] }, { "page": "select_go", "title": "Emulate AnnotationDbi::select for GO.db users", "topics": [ "select_go" ] } ], "_readme": "https://github.com/BiocStaging/GO.ddb/raw/HEAD/README.md", "_rundeps": [ "askpass", "BiocFileCache", "BiocGenerics", "bit", "bit64", "blob", "cachem", "cli", "cpp11", "curl", "DBI", "dbplyr", "dplyr", "duckdb", "fastmap", "filelock", "generics", "glue", "graph", "httr2", "lifecycle", "magrittr", "memoise", "ontologyIndex", "ontologyPlot", "ontoProc2", "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" ], "_score": 2, "_indexed": true, "_nocasepkg": "go.ddb", "_universes": [ "biocstaging", "vjcitn" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.99.4", "date": "2026-05-14T19:43:03.000Z", "distro": "noble", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "0c19af9ab34c3100f54c3c037be8b0f6586b7c8ad392cb05ef4b000437b3908c", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.6.0", "os": "linux", "version": "0.99.4", "date": "2026-05-14T19:43:04.000Z", "distro": "noble", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "8fc37e078ee0eb6fcb7f06768cb360e7f6661fe7b445ca217a1c6a129fc10641", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.5.3", "os": "mac", "version": "0.99.4", "date": "2026-05-14T19:42:14.000Z", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "ef6f9c5aab40323e42fc66a1b9c8f0e047d5f3a0f61aa700be7545502a492f52", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.6.0", "os": "mac", "version": "0.99.4", "date": "2026-05-14T19:44:16.000Z", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "886b5eee567e54a130a678bbbb65a668b1ce4f96aa3eecf1419b854eaec05fb1", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.7.0", "os": "win", "version": "0.99.4", "date": "2026-05-14T19:44:34.000Z", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "2b247615d007db0a422ad4c44ee7996fba33ef5b60a3da587b1e2a77ae0b5a85", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.5.3", "os": "win", "version": "0.99.4", "date": "2026-05-14T19:45:32.000Z", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "3a40a1c4fcdea7350770fb7de982d230ed2ebd5d610c5ec1f75f3b16edbf2e88", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.6.0", "os": "win", "version": "0.99.4", "date": "2026-05-14T19:44:38.000Z", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "30ff80e1b6c91f4ccd48ba4e0cea330b985e744718c11f0c8436a583d52364bc", "status": "success", "check": "WARNING", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" }, { "r": "4.6.0", "os": "wasm", "version": "0.99.4", "date": "2026-05-22T08:50:50.000Z", "commit": "2bab8f8a71eb02741709a92b819b72b987f90bd2", "fileid": "b67c76ee60eca387e58810596dae38c7f3a3bc5611a380d91df799216d10a6f1", "status": "success", "buildurl": "https://github.com/r-universe/biocstaging/actions/runs/25881234685" } ] }