tblInfaunalAbundance
PURPOSE: The purpose of the infaunal abundance table is to document the numerical presence of all infaunal animals collected at a station. Each record represents the abundance of a particular infaunal species in an individual sample and the agency that collected the species.
The exclude code is explained below. If the agency wishes to separate adults and juveniles of the same species, the number of juveniles can be carried in the comments field, but the abundance number will reflect the total number of animals of that species at that station.
The species field should contain genus and species names free of any punctuation, including, periods, commas, and quotation marks. The ScreenSize field refers to the size screen used to process the sample on board ship and is carried for historical purposes.
Exclude Notation
Purpose: Provides an aid to data analysis when calculating metrics using the number of taxa present (e.g., diversity, species richness). This field in the final data set represents the taxonomist’s recommendation that the reported taxon be excluded from counts of the number of taxa reported in the sample.
Rule of Use: The Exclude annotation is made on the bench sheet whenever a taxon should be excluded from counts of the number of taxa reported in the sample. This annotation is employed when three conditions co-exist:
The identification is not at the species-level (e.g., Pleustidae or Polydora sp).
And
The reported taxon is represented in the sample by other members of its taxon, which have been identified at lower levels.
And
The taxonomist cannot determine if the specimen is distinct from the other members of its taxon represented in the sample.
It is necessary that the taxonomists make this evaluation during sample analysis (i.e., by annotation of the bench sheet). It cannot be effectively applied after the fact, as there is no way of determining later whether the third criterion for use was met.
TABLE GUIDELINES:
-
The combination of StationID, Replicate, SampleDate, Subcore, Species, and LabCode will ensure that each record in the table is unique.
-
This file can be named at the discretion of the user; however the excel sheet tab must be named tblInfaunalAbundance for submission to the Bight’08 online system.
EXAMPLE DATA:
Table Structure:
tblInfaunalAbundance
Field Name
|
Type
|
Required
|
Size
|
Description
|
StationID
|
Text
|
Y
|
25
|
A geographic location label from tblStations.
|
SampleID
|
Text
|
N
|
10
|
The laboratory internal sample identifier if any.
|
Replicate
|
Integer
|
Y
|
|
The sequential number of the grab. The field may contain a one if there are no replicates.
|
SampleDate
|
Date/Time
|
Y
|
|
The date the sample was collected expressed as dd-mmm-yyyy
|
Subcore
|
Text
|
Y
|
10
|
The subcore the sample represents (A, B or C). The default is “None”.
|
Species
|
Text
|
Y
|
50
|
The species of infauna collected from luList09_SpeciesList.
|
Qualifier
|
Text
|
N
|
10
|
Any qualifier pertaining to the abundance from luList11_QualifierCodes (special case p for colonials to indicate their presence only).
|
Abundance
|
Integer
|
Y
|
|
The number of individuals (0 for colonials).
|
Exclude
|
Yes/No
|
Y
|
|
Flag to exclude from the analysis.
|
LabCode
|
Text
|
Y
|
15
|
The agency code from luList01_AgencyCodes.
|
ScreenSize
|
Text
|
Y
|
3
|
Sieve size in mm. The default for this project is 1.0.
|
ScreenSizeUnits
|
Text
|
Y
|
15
|
From luList28_units. The default will be millimeters (mm)
|
Voucher
|
Integer
|
N
|
|
The number of animals vouchered of this species from this station.
|
Comments
|
Text
|
N
|
100
|
Additional comments.
|
****************************************************************************************************
|