Skip to content

Filters

This instance of LAPIS supports the following sequence filters:

NameTypeDescription
primaryKeystring (primary key)Filters the "primaryKey" column with exact match. You can also supply an array of values - they will be combined with logical OR.
primaryKey.regexstringFilters the "primaryKey" column using a regular expression,seestring search
usherTreestringFilters the "usherTree" column with exact match. You can also supply an array of values - they will be combined with logical OR.
usherTree.regexstringFilters the "usherTree" column using a regular expression,seestring search
datedateFilters the "date" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateFromdateFilters the "date" column (including the boundary)
dateTodateFilters the "date" column (including the boundary)
regionstringFilters the "region" column with exact match. You can also supply an array of values - they will be combined with logical OR.
region.regexstringFilters the "region" column using a regular expression,seestring search
countrystringFilters the "country" column with exact match. You can also supply an array of values - they will be combined with logical OR.
country.regexstringFilters the "country" column using a regular expression,seestring search
pangoLineagestringFilters the "pangoLineage" column with exact match. You can also supply an array of values - they will be combined with logical OR.
pangoLineage.regexstringFilters the "pangoLineage" column using a regular expression,seestring search
divisionstringFilters the "division" column with exact match. You can also supply an array of values - they will be combined with logical OR.
division.regexstringFilters the "division" column using a regular expression,seestring search
ageintFilters the "age" column with exact match. You can also supply an array of values - they will be combined with logical OR.
ageFromintFilters the "age" column (including the boundary)
ageTointFilters the "age" column (including the boundary)
qc_valuefloatFilters the "qc_value" column with exact match. You can also supply an array of values - they will be combined with logical OR.
qc_valueFromfloatFilters the "qc_value" column (including the boundary)
qc_valueTofloatFilters the "qc_value" column (including the boundary)
test_boolean_columnbooleanFilters the "test_boolean_column" column for a boolean value
nucleotideMutationslist of stringsFilters for nucleotide mutations,seemutation filters
aminoAcidMutationslist of stringsFilters for amino acid mutations,seemutation filters
nucleotideInsertionslist of stringsIn the format ins_false{'<position>:<insertion>'}. Example: ins_100:AGG
aminoAcidInsertionslist of stringsIn the format ins_<sequenceName>:<position><insertion>. Example: ins_E:100:DEF