Description of database fields

Order columns by clicking their headings. Reset default order.

field namecommentsdata typeallowed valuesrequiredmaximum length (characters)
idprimary key integer - yes 5
isolateisolate name text - yes 20
aliasesalternative names for isolatetext (multiple)-no-
referencesPubMed ids that link to publications that describe or include recordinteger (multiple)-no-
yearyear of isolation integer min: 1900; max: 2020 no 4
location text - no 32
latitude text - no 12
longitude text - no 12
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
commentsany other comments text - no 1000
sendersender unique name, link to users integer Click for list of sender ids yes 4
curatorcurator who entered data,link to users integer Click for list of curator ids yes 4
date_entereddate first entered date - yes 10
datestampdate last modified date - yes 10