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

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

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

Focusing on marine (pico)phytoplankton .

Related