ABotSamples
Records of all taxa. Four columns of Anatomy (1,2,3,4) exist as a convenience for rare occasions where more than one plant part is identified. Overwhelmingly only a single ANatomy is required (in Anatomy1) therefore the other three are ussually left blank. Similarly, two columns of TypeOfPreservation are available for the occasions where a sample falls into more than one category, such as 'charred' and 'waterlogged'. There are several ways the data are quantified: 1) 'TotalCount' is simply the total count of specimens. This cannot be zero. 2) NULL values in 'TotalCount' signify the presence of the taxon code. 3) Ubiquity is a statistic giving the percentage of contexts in which the taxa was present. It is possible to have a value for TotalCount, but not for ubiquity, since ubiquity is sometimes not available. It is possble to have a ubiquity of zero (since it was not present in any of the contexts) but still have a TotalCount (some number at the sitephase, outside the specific contexts). It is also posstible to have a ubiquity of zero, and a NULL TotalCount, signifying it was present at the sitephase, outside the specific contexts.
Column name	Data type	Column description
Anatomy1	varchar	Anatomical component of the plant, look up from zoptions_AbotAnatomy.
Anatomy2	varchar
Anatomy3	varchar
Anatomy4	varchar
NumberOfContexts	int	Number of contexts the taxon was found in, out of the total number archaeobotanical contexts at the phase (see ABotNumberOfContexts in the ABotPhases table).
PhaseID	varchar	Please see the detailed description of the 'Phases' table.
preservation_type_1	varchar	Description of type of preservation, e.g., charring, waterlogging, mineralisation, impressions, etc.
preservation_type_2	varchar
SampleID	int	Unique identification number for each taxon record
TaxonCode	varchar	Unique code to identify the full taxonomic name; this usually consists of the first four letters of the genus and first three letters of the species
TaxonCodeConfidence	varchar	Either 'yes' the researcher was confident in the identification (to the level of species, genus or family), or 'no' there is some uncertainty (identification as cf. (confer), or genus/genus or species/species)
TotalCount	int	Number of taxon records per phase/cultural unit
Ubiquity	decimal	Percentage of the total number of contexts (ABotTotalNumberOfContexts). Do not manually add value. This entry is triggered by the value in 'NumberOfContexts' and 'ABotPhases: ABotNumberOfContexts'