Cunha Lab · Specimen Database

Events

—

Specimens

—

Extractions

—

Libraries

—

Loans

—

Quick browse

By Phylum

By Country

By Year

By Collector

Advanced Search

Identification

Collection

Record

User Management

Assign role

Run in Supabase SQL Editor after creating the user:

INSERT INTO public.user_roles (user_id, role, email)
SELECT id, 'viewer', email
FROM auth.users
WHERE email = 'user@email.com';

Update user access

Change an existing user's role:

UPDATE public.user_roles
SET role = 'editor'
WHERE email = 'user@email.com';

Remove access

Revoke a user's access entirely:

DELETE FROM public.user_roles
WHERE email = 'user@email.com';

Roles

Two access levels:

viewerRead-only, export CSV

editorFull read/write + admin panel

Data Upload

Steps

1 Download a template below

2 Fill in the Data sheet from row 3 onward

3 Upload in order: EventData → SpecimenData → DNAExtractions → GenomicLibraries
Loans can be uploaded at any time — no dependencies

4 Select table + file below → Preview → Save

Rules

• Leave cells blank if unknown (not N/A or -)
• Do not edit or rename column headers
• Dates in YYYY-MM-DD format
• Taxonomy fields can be auto-filled via GBIF tool
• Duplicate IDs are skipped, not overwritten

Controlled fields

dna_extracted
Only use: YES or NO — leave blank if unknown

environment
Only use: marine, freshwater, terrestrial, brackish

development
Only use: adult, juvenile, larva, egg

status (Loans)
Only use: active, returned, overdue

qubit_dna_ng_ul / qubit_after_speedvac
Numeric value or leave blank — do not enter text like "too low" or "too high"

Required IDs

EventData
event_code: PA24E001

SpecimenData
lot_id: PA24E001S001 · event_code must exist

DNAExtractions
extraction_id: gDNA-0817 · lot_id must exist

GenomicLibraries
library_id: LIB-001 · extraction_id must exist

Loans
loan_id: LN-24-001 · no dependencies, upload any time

Download templates

Generated live from the current database schema — always up to date.

Upload filled template

Select table and your filled .xlsx — the app validates before saving.

Taxonomy Lookup — GBIF

Looks up missing phylum, class, subclass, family, and order fields using the GBIF taxonomic database. Results are shown for your review — nothing is saved until you approve it.

Loan Specimens