Home>Aquaculture>Aquaculture pathogen isolates>Plugins>Description of database fields

Description of database fields

Order columns by clicking their headings. Reset default order.

field name	comments	data type	allowed values	required	maximum length (characters)
id	primary key	integer	-	yes	5
isolate	isolate name	text	-	yes	20
aliases	alternative names for isolate	text (multiple)	-	no	-
references	PubMed ids that link to publications that describe or include record	integer (multiple)	-	no	-
year	year of isolation	integer	min: 1900; max: 2023	no	4
location		text	-	no	32
gps_location	GPS coordinate	geography_point	latitude [min: -90; max: 90], longitude [min: -180; max: 180]	no	-
species		text	Abalone herpesvirus (AbHV) Aeromonas salmonicida Aeromonas sp. Aliivibrio logei Aliivibrio Wodanis Allivibrio sp. Aphanomyces astaci (crayfish plague) Aphanomyces invadans (epizootic ulcerative syndrome) Batrachochytrium dendrobatidis Batrachochytrium salamandrivorans Bonamia exitiosa Bonamia ostreae Channel catfish virus (CCV) Cyprinid herpesvirus 3 (CyHV-3) Enterovibrio sp. Epizootic haematopoietic necrosis virus (EHNV) Flavobacterium columnare Flavobacterium psychrophilum Flavobacterium sp. Francisella noatunensis Gyrodactylus salaris Hepatobacter penaei (necrotising hepatopancreatitis) HPR-deleted or HPRO infectious salmon anaemia virus (ISA) Infectious hematopoietic necrosis virus (IHNV) Infectious hypodermal and haematopoietic necrosis virus (IHHNV) Infectious myonecrosis virus Infectious pancreatic necrosis virus (IPNV) Lactococcus garvieae Macrobrachium rosenbergii nodavirus (white tail disease) Marteilia refringens Perkinsus marinus Perkinsus olseni Pseudoalteromonas sp. Pseudomonas anguilliseptica Pseudomonas sp. Ranavirus Red sea bream iridovirus (RSIV) Renibacterium salmoninarum Rhabdovirus carpio (Spring viraemia of carp) Salmon anemia virus (ISAV) Salmonid alphavirus (SAV) Streptococcus agalactiae Streptococcus iniae Streptococcus phocae Streptococcus sp. Taura syndrome virus Tenacibaculum spp. Vibrio aestuarianus Vibrio anguillarum Vibrio ordalii Vibrio parahaemolyticus Vibrio sp. Viral hemorrhagic septicemia virus (VHSV) White spot syndrome virus Xenohaliotis californiensis Yellow head virus Yersinia ruckeri other	yes	-
disease		text	disease commensal unknown	yes	-
epidemiology		text	environmental farmed environment pathogen other	no	-
source		text	farmed wild other	no	-
source_water		text	brackish freshwater saltwater other	no	-
temperature		text	cold warm	no	-
host_species		text	Agemaki clam Akiami paste shrimp Alaska pollock Albacore American sea scallop Amur catfish Antarctic krill Araucanian herring Argentine hake Argentine shortfin squid Asari Asian swamp eel Asian tiger shrimp Atlantic cod Atlantic herring Atlantic horse mackerel Atlantic mackerel Atlantic menhaden Atlantic salmon Bigeye scad Bigeye tuna Bighead carp Black carp Blood cockle Blue swimming crab Blue whiting Bombay-duck Bonga shad California pilchard Cape horse mackerel Capelin Catla Channel catfish Chilean jack mackerel Chinese mitten crab Chinese perch Chinese razor clam Chinese softshell turtle Chub mackerel Chum salmon Common carp Crucian carp Daggertooth pike conger European anchovy European pilchard European sprat Filipino Venus Gazami crab Giant tiger prawn Giant tiger prawn Goldstripe sardinella Grass carp Gulf menhaden Haddock Hilsa shad Indian mackerel Indian oil sardine Iridescent shark Japanese anchovy Japanese carpet shell Japanese cockle Japanese common catfish Japanese flying squid Japanese jack mackerel Japanese littleneck Japanese oyster Japanese pilchard Jumbo flying squid Kawakawa Korean bullhead Largehead hairtail Longtail tuna Louisiana crawfish Madeiran sardinella Mandarin fish Manila clam Milkfish Miyagi oyster Mrigal carp Narrow-barred Spanish mackerel Nile perch Nile tilapia North Pacific hake Northern prawn Northern snakehead Pacific anchoveta Pacific cod Pacific herring Pacific oyster Pacific sand lance Pacific sandlance Pacific saury Pacific thread herring Peruvian anchoveta Pink salmon Pollock Pond loach Rainbow trout Red swamp crawfish Rohu Round sardinella Short mackerel Silver carp Silver cyprinid Skipjack tuna Southern African anchovy Southern rough shrimp Whiteleg shrimp Wuchang bream Yellow croaker Yellowfin tuna Yellowhead catfish Yellowstripe scad Yesso scallop	no	-
host_tissue		text	-	no	20
comments	any other comments	text	-	no	1000
sender	sender unique name, link to users	integer	Click for list of sender ids	yes	4
curator	curator who entered data,link to users	integer	Click for list of curator ids	yes	4
date_entered	date first entered	date	-	yes	10
datestamp	date last modified	date	-	yes	10