Skip to content

Filters

This instance of LAPIS supports the following sequence filters:

NameTypeDescription
ace2BindingfloatFilters the "ace2Binding" column with exact match. You can also supply an array of values - they will be combined with logical OR.
ace2BindingFromfloatFilters the "ace2Binding" column (including the boundary)
ace2BindingTofloatFilters the "ace2Binding" column (including the boundary)
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)
authorsstringFilters the "authors" column with exact match. You can also supply an array of values - they will be combined with logical OR.
authors.regexstringFilters the "authors" 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
countryExposurestringFilters the "countryExposure" column with exact match. You can also supply an array of values - they will be combined with logical OR.
countryExposure.regexstringFilters the "countryExposure" column using a regular expression,seestring search
databasestringFilters the "database" column with exact match. You can also supply an array of values - they will be combined with logical OR.
database.regexstringFilters the "database" 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)
dateDayintFilters the "dateDay" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateDayFromintFilters the "dateDay" column (including the boundary)
dateDayTointFilters the "dateDay" column (including the boundary)
dateMonthintFilters the "dateMonth" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateMonthFromintFilters the "dateMonth" column (including the boundary)
dateMonthTointFilters the "dateMonth" column (including the boundary)
dateOriginalValuestringFilters the "dateOriginalValue" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateOriginalValue.regexstringFilters the "dateOriginalValue" column using a regular expression,seestring search
dateSubmitteddateFilters the "dateSubmitted" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateSubmittedFromdateFilters the "dateSubmitted" column (including the boundary)
dateSubmittedTodateFilters the "dateSubmitted" column (including the boundary)
dateSubmittedDayintFilters the "dateSubmittedDay" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateSubmittedDayFromintFilters the "dateSubmittedDay" column (including the boundary)
dateSubmittedDayTointFilters the "dateSubmittedDay" column (including the boundary)
dateSubmittedMonthintFilters the "dateSubmittedMonth" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateSubmittedMonthFromintFilters the "dateSubmittedMonth" column (including the boundary)
dateSubmittedMonthTointFilters the "dateSubmittedMonth" column (including the boundary)
dateSubmittedOriginalValuestringFilters the "dateSubmittedOriginalValue" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateSubmittedOriginalValue.regexstringFilters the "dateSubmittedOriginalValue" column using a regular expression,seestring search
dateSubmittedYearintFilters the "dateSubmittedYear" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateSubmittedYearFromintFilters the "dateSubmittedYear" column (including the boundary)
dateSubmittedYearTointFilters the "dateSubmittedYear" column (including the boundary)
dateUpdateddateFilters the "dateUpdated" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateUpdatedFromdateFilters the "dateUpdated" column (including the boundary)
dateUpdatedTodateFilters the "dateUpdated" column (including the boundary)
dateUpdatedDayintFilters the "dateUpdatedDay" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateUpdatedDayFromintFilters the "dateUpdatedDay" column (including the boundary)
dateUpdatedDayTointFilters the "dateUpdatedDay" column (including the boundary)
dateUpdatedMonthintFilters the "dateUpdatedMonth" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateUpdatedMonthFromintFilters the "dateUpdatedMonth" column (including the boundary)
dateUpdatedMonthTointFilters the "dateUpdatedMonth" column (including the boundary)
dateUpdatedOriginalValuestringFilters the "dateUpdatedOriginalValue" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateUpdatedOriginalValue.regexstringFilters the "dateUpdatedOriginalValue" column using a regular expression,seestring search
dateUpdatedYearintFilters the "dateUpdatedYear" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateUpdatedYearFromintFilters the "dateUpdatedYear" column (including the boundary)
dateUpdatedYearTointFilters the "dateUpdatedYear" column (including the boundary)
dateYearintFilters the "dateYear" column with exact match. You can also supply an array of values - they will be combined with logical OR.
dateYearFromintFilters the "dateYear" column (including the boundary)
dateYearTointFilters the "dateYear" column (including the boundary)
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
divisionExposurestringFilters the "divisionExposure" column with exact match. You can also supply an array of values - they will be combined with logical OR.
divisionExposure.regexstringFilters the "divisionExposure" column using a regular expression,seestring search
genbankAccessionstringFilters the "genbankAccession" column with exact match. You can also supply an array of values - they will be combined with logical OR.
genbankAccession.regexstringFilters the "genbankAccession" column using a regular expression,seestring search
genbankAccessionRevstringFilters the "genbankAccessionRev" column with exact match. You can also supply an array of values - they will be combined with logical OR.
genbankAccessionRev.regexstringFilters the "genbankAccessionRev" column using a regular expression,seestring search
gisaidCladestringFilters the "gisaidClade" column with exact match. You can also supply an array of values - they will be combined with logical OR.
gisaidClade.regexstringFilters the "gisaidClade" column using a regular expression,seestring search
gisaidEpiIslstringFilters the "gisaidEpiIsl" column with exact match. You can also supply an array of values - they will be combined with logical OR.
gisaidEpiIsl.regexstringFilters the "gisaidEpiIsl" column using a regular expression,seestring search
hoststringFilters the "host" column with exact match. You can also supply an array of values - they will be combined with logical OR.
host.regexstringFilters the "host" column using a regular expression,seestring search
immuneEscapefloatFilters the "immuneEscape" column with exact match. You can also supply an array of values - they will be combined with logical OR.
immuneEscapeFromfloatFilters the "immuneEscape" column (including the boundary)
immuneEscapeTofloatFilters the "immuneEscape" column (including the boundary)
locationstringFilters the "location" column with exact match. You can also supply an array of values - they will be combined with logical OR.
location.regexstringFilters the "location" column using a regular expression,seestring search
nextcladeCoveragefloatFilters the "nextcladeCoverage" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeCoverageFromfloatFilters the "nextcladeCoverage" column (including the boundary)
nextcladeCoverageTofloatFilters the "nextcladeCoverage" column (including the boundary)
nextcladePangoLineagestringFilters the "nextcladePangoLineage" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladePangoLineage.regexstringFilters the "nextcladePangoLineage" column using a regular expression,seestring search
nextcladeQcFrameShiftsScorefloatFilters the "nextcladeQcFrameShiftsScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcFrameShiftsScoreFromfloatFilters the "nextcladeQcFrameShiftsScore" column (including the boundary)
nextcladeQcFrameShiftsScoreTofloatFilters the "nextcladeQcFrameShiftsScore" column (including the boundary)
nextcladeQcMissingDataScorefloatFilters the "nextcladeQcMissingDataScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcMissingDataScoreFromfloatFilters the "nextcladeQcMissingDataScore" column (including the boundary)
nextcladeQcMissingDataScoreTofloatFilters the "nextcladeQcMissingDataScore" column (including the boundary)
nextcladeQcMixedSitesScorefloatFilters the "nextcladeQcMixedSitesScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcMixedSitesScoreFromfloatFilters the "nextcladeQcMixedSitesScore" column (including the boundary)
nextcladeQcMixedSitesScoreTofloatFilters the "nextcladeQcMixedSitesScore" column (including the boundary)
nextcladeQcOverallScorefloatFilters the "nextcladeQcOverallScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcOverallScoreFromfloatFilters the "nextcladeQcOverallScore" column (including the boundary)
nextcladeQcOverallScoreTofloatFilters the "nextcladeQcOverallScore" column (including the boundary)
nextcladeQcPrivateMutationsScorefloatFilters the "nextcladeQcPrivateMutationsScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcPrivateMutationsScoreFromfloatFilters the "nextcladeQcPrivateMutationsScore" column (including the boundary)
nextcladeQcPrivateMutationsScoreTofloatFilters the "nextcladeQcPrivateMutationsScore" column (including the boundary)
nextcladeQcSnpClustersScorefloatFilters the "nextcladeQcSnpClustersScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcSnpClustersScoreFromfloatFilters the "nextcladeQcSnpClustersScore" column (including the boundary)
nextcladeQcSnpClustersScoreTofloatFilters the "nextcladeQcSnpClustersScore" column (including the boundary)
nextcladeQcStopCodonsScorefloatFilters the "nextcladeQcStopCodonsScore" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeQcStopCodonsScoreFromfloatFilters the "nextcladeQcStopCodonsScore" column (including the boundary)
nextcladeQcStopCodonsScoreTofloatFilters the "nextcladeQcStopCodonsScore" column (including the boundary)
nextstrainCladestringFilters the "nextstrainClade" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextstrainClade.regexstringFilters the "nextstrainClade" column using a regular expression,seestring search
originatingLabstringFilters the "originatingLab" column with exact match. You can also supply an array of values - they will be combined with logical OR.
originatingLab.regexstringFilters the "originatingLab" 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
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
regionExposurestringFilters the "regionExposure" column with exact match. You can also supply an array of values - they will be combined with logical OR.
regionExposure.regexstringFilters the "regionExposure" column using a regular expression,seestring search
samplingStrategystringFilters the "samplingStrategy" column with exact match. You can also supply an array of values - they will be combined with logical OR.
samplingStrategy.regexstringFilters the "samplingStrategy" column using a regular expression,seestring search
sexstringFilters the "sex" column with exact match. You can also supply an array of values - they will be combined with logical OR.
sex.regexstringFilters the "sex" column using a regular expression,seestring search
sraAccessionstringFilters the "sraAccession" column with exact match. You can also supply an array of values - they will be combined with logical OR.
sraAccession.regexstringFilters the "sraAccession" column using a regular expression,seestring search
strainstring (primary key)Filters the "strain" column with exact match. You can also supply an array of values - they will be combined with logical OR.
strain.regexstringFilters the "strain" column using a regular expression,seestring search
submittingLabstringFilters the "submittingLab" column with exact match. You can also supply an array of values - they will be combined with logical OR.
submittingLab.regexstringFilters the "submittingLab" column using a regular expression,seestring search
whoCladestringFilters the "whoClade" column with exact match. You can also supply an array of values - they will be combined with logical OR.
whoClade.regexstringFilters the "whoClade" column using a regular expression,seestring search
diedbooleanFilters the "died" column for a boolean value
fullyVaccinatedbooleanFilters the "fullyVaccinated" column for a boolean value
hospitalizedbooleanFilters the "hospitalized" column for a boolean value
nextcladeDatasetVersionstringFilters the "nextcladeDatasetVersion" column with exact match. You can also supply an array of values - they will be combined with logical OR.
nextcladeDatasetVersion.regexstringFilters the "nextcladeDatasetVersion" 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
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