SQLite database

File provided

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
NTU, Singapore

Focusing on marine (pico)phytoplankton .