SQLite PR2 reference database

File provided

Each version has a 3 number code: version_x.y.z, e.g. 4.12.0

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


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…)

Using the DBeaver interface to read the PR2 SQLite database.
Daniel Vaulot
CNRS, France

Focusing on marine (pico)phytoplankton .