Connected to marine database as query
Reset

detailstimedeptaxaclassrefs
MapNo
Lon
Lat
DeltaR
DeltaRErr
Reference
Locality
Subregion
Notes
CollectionYear
ReservoirAge
ReservoirErr
C14age
C14err
LabID
Delta13C
TaxaNo
RefNo
nextime
MapNo
Lon
Lat
DeltaR
DeltaRErr
Reference
Locality
Subregion
Notes
CollectionYear
ReservoirAge
ReservoirErr
C14age
C14err
LabID
Delta13C
TaxaNo
RefNo
nextime
TaxaNo
Genus
Species
Feeding
ClassNo
ClassNo
Name
refno
authors
title
journal
year_published
doi

Type in a query here, following the example syntax

Help with Syntax

Examples:
Select * from class
Select * from details where mapno=600
select deltar,genus,species from details join taxa using (taxano) join class using (classno) where name='algae'
select locality,subregion,feeding,name from details join taxa using (taxano) join class using (classno) where reference like 'mcneely%'
select deltar,lon,lat from details where deltar>500 order by deltar
select mapno,labid,count(labid) from details group by labid having count(labid)>1 order by mapno
select avg(deltar),stddev_pop(deltar) from details where lat<-40 and lon between 0 and 180
select journal from refs order by journal