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

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

Focusing on marine (pico)phytoplankton .

Related