SQLite PR2 reference database
File provided
Each version has a 3 number code: version_x.y.z, e.g. 4.12.0
- pr2_version_x.y.z.sqlite.gz: compressed version of the PR2 database under SQLite.
Database structure
Four tables are provided
- pr2_main
- pr2_sequence
- pr2_metadata
- pr2_taxonomy
Please see here for the detailed structure of the database
Using the database
R
You can use the package RSQLite to interact with the database.
DBeaver database interface
We recommend using DBeaver, an open source Universal database interface that can read a variety of database formats (MySQL, MariaSQL, SQlite…)
