There are two tables in the BOG database containing taxonomic data, TAXA and TAXA_AL.  The table TAXA contains derived data from the counts in the TAXA_AL table.  Table 1 describes the fields in the TAXA table; Table 2 describes the TAXA_AL groups that make up the taxa fields in TAXA. Table 3 contains group summation calculations. The counts were made by Kurt Buck (1988-1999), Roman Marin (2000-2004), Sara Tanner (2005-2014).  The PI for this data is Francisco Chavez, database administrator is Reiko Michisaki .  Tim Pennington collects the water samples from the BOG cruises.

Back to BOG web or Site map

Table 1. TAXA fields

Field	Description	Notes
cruise	cruise id
date_time	gmt
year_date	yyyyddd where ddd is day of year
ctrb_id	station name
seq	station number
depth	meters
dec_lat	decimal latitude
dec_long	decimal longitude
allp	Units are mg C m-3 for all taxa	sum of carb_perliter for groups<130
allhet	all heterotrophic phytoplankton	sum of groups>129 and groups<175
syn	Synechococcus	sum of groups 10 & 11
rfp	red fluorescing picoplankton	sum of group 20
prym	haptophytes	sum of groups>49 and groups<60
aflag	autotrophic flagellates	sum of groups>59 and groups<70
adino	autotrophic dinoflagellates	sum of groups>69 and groups<80
cryp	cryptomonad	sum of groups>79 and groups<90
prasy	prasinophytes	sum of groups>89 and groups<100
phaeo	phaeocystsis	sum of group=100
pen	pennate diatoms	sum of groups>109 and groups<120
cen	centric diatoms	sum of groups>119 and groups<130
hdino	heterotrophic dinoflagellates	sum of groups>129 and groups<140
hflag	heterotrophic flagellates	sum of groups>139 and groups<150
choano	choanoflagellates	sum of group 150
hcryp	Leucocryptos	sum of group 160
hcil	heterotrophic ciliates	sum of groups>169 and groups<175
acil	autotrophic ciliates	sum of groups>174 and groups<180

Table 2 TAXA_AL groups

code	taxa
10	Synechococcus
11	Synechococcus dividing
20	Red Fluorescing Picoplankton
50	Prymnesiophyte
55	Coccolithophorids
60	Autotrophic Flagellates Misc.
61	Autotrophic Euglenoids
62	Distephanus
63	Dinobryon
70	Autotrophic Dinoflagellates Misc.
70.5	Cochlodinium
71	Ceratium
72	Amphidinium
73	Prorocentrum
74	Gyrodinium Sanguinium
75	Lingulodinium
76	Dinophysis
77	Datodinium
78	Akashiwo sanguinea
79	Odd dino
80	Cryptomonads
90	Prasinophytes
100	Phaeocystis
110	Pennate Diatoms Unidentified
111	Pseudo-nitzschia Australis
112	Nitzschia Closterium
113	Pseudo-nitzschia spp.
114	Thalassionema
115	Tropidoneis
116	Asterionella
117	Thalassiothrix
118	Fragillariopsis
119	Pleurosigma
120	Centric Diatoms Unidentified
120.5	Large Diatom
121	Chaetoceros
121.5	Minidiscus
122	Skeletonema
122.5	Minutocellus
123	Eucampia
124	Rhizosolenia
125	Thalassiosira
126	Lennoxia
127	Ditylum
128	Leptocylindrus
129	Odontella
129.5	Odd diatom
130	Heterotrophic Dinoflagellates Misc.
131	Protoperidinium
132	Green Heterotrophic Dinoflagellates
133	Gyrodinium
133.5	P. americana
136	Solenicola w/o Synochococcus
140	Heterotrophic Flagellates Unidenified
141	Bodo
141.5	Solenicola
142	Amoebae
143	Heliozoans
145	Solenicola w/ Synochococcus
146	Rhizomonos
150	Choanoflagellates
160	Leucocryptos
167	Mesodinium
170	Heterotrophic Ciliates Misc.
171	Strombidium
172	Holotrich
173	Euplotes
174	Tintinnid
175	Plastidic Ciliates Misc.
176	Mesodinium
177	Laboea

Table 3. Summed groups are calculated as follows, where units are mg C m-3:

Field	Definition
allp	sum of carb_perliter for groups<130
allhet	all heterotrophic phytoplankton, sum of groups>129 and groups<175
syn	Synechococcus, sum of groups 10 & 11
rfp	red fluorescing picoplankton, sum of group 20
prym	haptophytes, sum of groups>49 and groups<60
aflag	autotrophic flagellates, sum of groups>59 and groups<70
adino	autotrophic dinoflagellates, sum of groups>69 and groups<80
cryp	cryptomonad, sum of groups>79 and groups<90
prasy	prasinophytes, sum of groups>89 and groups<100
phaeo	phaeocystsis, sum of group=100
pen	pennate diatoms, sum of groups>109 and groups<120
cen	centric diatoms, sum of groups>119 and groups<130
hdino	heterotrophic dinoflagellates, sum of groups>129 and groups<140
hflag	heterotrophic flagellates, sum of groups>139 and groups<150
choano	choanoflagellates, sum of group 150
hcryp	Leucocryptos, sum of group 160
hcil	heterotrophic cillates, sum of groups>169 and groups<175
acil	autotrophic cillates, sum of groups>174 and groups<180

Table 4. TAXA_AL fields

Field	Description	Notes
cruise	cruise id	i.e. CANON11, S497, PP15, 16512, 33192
date_time	gmt
project	project id	i.e. CANON, SECRET,PTLO,PP
year_date	yyyyddd where ddd is day of year      i.e. 2013005, 2012358
ctrb_id	station name  i.e. mooring1, mooring2, c1, h3, 67-50, 67-55
seq	station number
depth	meters	Target depth
platform	ship
VF	volume filtered
groups	taxa id code, see table 2
shape	1=sphere, 2=prolate ellipsoid, 3=cylinder, 4=diatom like Chaetoceros
length	units=microns
width	&units=microns;
thick	&units=microns;
perliter	number per liter
N	count
area	area of count
volcell	volume per cell
voliter	volume per liter
carbcell	carbon per cell
carblit	carbon per liter