PubMLST Database home Contents
Log in

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-
countrycountry where sample isolated or detected text - no 30
region text - no 30
yearyear of isolation integer - no 4
host_type text human
non-human primate
non-primate and non-rodent mammal
rodent
no -
host_species text - no 60
source text axenic culture
xenic culture
faecal DNA
no -
disease_symptoms text - no 128
successful_treatment text - no 128
treatment_failures text - no 128
culture_available text yes
no
no -
SSU_rDNA_accession 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