CHRONO Marine Database
Type in a query here, following the example syntax
Help with Syntax
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