Filters
This instance of LAPIS supports the following sequence filters:
| Name | Type | Description |
|---|---|---|
| ace2Binding | float | Filters the "ace2Binding" column" with exact match |
| ace2BindingFrom | float | Filters the "ace2Binding" column (including the boundary) |
| ace2BindingTo | float | Filters the "ace2Binding" column (including the boundary) |
| age | int | Filters the "age" column" with exact match |
| ageFrom | int | Filters the "age" column (including the boundary) |
| ageTo | int | Filters the "age" column (including the boundary) |
| authors | string | Filters the "authors" column" with exact match |
| authors.regex | string | Filters the "authors" column using a regular expression, see string search |
| country | string | Filters the "country" column" with exact match |
| country.regex | string | Filters the "country" column using a regular expression, see string search |
| countryExposure | string | Filters the "countryExposure" column" with exact match |
| countryExposure.regex | string | Filters the "countryExposure" column using a regular expression, see string search |
| database | string | Filters the "database" column" with exact match |
| database.regex | string | Filters the "database" column using a regular expression, see string search |
| date | date | Filters the "date" column" with exact match |
| dateFrom | date | Filters the "date" column (including the boundary) |
| dateTo | date | Filters the "date" column (including the boundary) |
| dateDay | int | Filters the "dateDay" column" with exact match |
| dateDayFrom | int | Filters the "dateDay" column (including the boundary) |
| dateDayTo | int | Filters the "dateDay" column (including the boundary) |
| dateMonth | int | Filters the "dateMonth" column" with exact match |
| dateMonthFrom | int | Filters the "dateMonth" column (including the boundary) |
| dateMonthTo | int | Filters the "dateMonth" column (including the boundary) |
| dateOriginalValue | string | Filters the "dateOriginalValue" column" with exact match |
| dateOriginalValue.regex | string | Filters the "dateOriginalValue" column using a regular expression, see string search |
| dateSubmitted | date | Filters the "dateSubmitted" column" with exact match |
| dateSubmittedFrom | date | Filters the "dateSubmitted" column (including the boundary) |
| dateSubmittedTo | date | Filters the "dateSubmitted" column (including the boundary) |
| dateSubmittedDay | int | Filters the "dateSubmittedDay" column" with exact match |
| dateSubmittedDayFrom | int | Filters the "dateSubmittedDay" column (including the boundary) |
| dateSubmittedDayTo | int | Filters the "dateSubmittedDay" column (including the boundary) |
| dateSubmittedMonth | int | Filters the "dateSubmittedMonth" column" with exact match |
| dateSubmittedMonthFrom | int | Filters the "dateSubmittedMonth" column (including the boundary) |
| dateSubmittedMonthTo | int | Filters the "dateSubmittedMonth" column (including the boundary) |
| dateSubmittedOriginalValue | string | Filters the "dateSubmittedOriginalValue" column" with exact match |
| dateSubmittedOriginalValue.regex | string | Filters the "dateSubmittedOriginalValue" column using a regular expression, see string search |
| dateSubmittedYear | int | Filters the "dateSubmittedYear" column" with exact match |
| dateSubmittedYearFrom | int | Filters the "dateSubmittedYear" column (including the boundary) |
| dateSubmittedYearTo | int | Filters the "dateSubmittedYear" column (including the boundary) |
| dateUpdated | date | Filters the "dateUpdated" column" with exact match |
| dateUpdatedFrom | date | Filters the "dateUpdated" column (including the boundary) |
| dateUpdatedTo | date | Filters the "dateUpdated" column (including the boundary) |
| dateUpdatedDay | int | Filters the "dateUpdatedDay" column" with exact match |
| dateUpdatedDayFrom | int | Filters the "dateUpdatedDay" column (including the boundary) |
| dateUpdatedDayTo | int | Filters the "dateUpdatedDay" column (including the boundary) |
| dateUpdatedMonth | int | Filters the "dateUpdatedMonth" column" with exact match |
| dateUpdatedMonthFrom | int | Filters the "dateUpdatedMonth" column (including the boundary) |
| dateUpdatedMonthTo | int | Filters the "dateUpdatedMonth" column (including the boundary) |
| dateUpdatedOriginalValue | string | Filters the "dateUpdatedOriginalValue" column" with exact match |
| dateUpdatedOriginalValue.regex | string | Filters the "dateUpdatedOriginalValue" column using a regular expression, see string search |
| dateUpdatedYear | int | Filters the "dateUpdatedYear" column" with exact match |
| dateUpdatedYearFrom | int | Filters the "dateUpdatedYear" column (including the boundary) |
| dateUpdatedYearTo | int | Filters the "dateUpdatedYear" column (including the boundary) |
| dateYear | int | Filters the "dateYear" column" with exact match |
| dateYearFrom | int | Filters the "dateYear" column (including the boundary) |
| dateYearTo | int | Filters the "dateYear" column (including the boundary) |
| division | string | Filters the "division" column" with exact match |
| division.regex | string | Filters the "division" column using a regular expression, see string search |
| divisionExposure | string | Filters the "divisionExposure" column" with exact match |
| divisionExposure.regex | string | Filters the "divisionExposure" column using a regular expression, see string search |
| genbankAccession | string | Filters the "genbankAccession" column" with exact match |
| genbankAccession.regex | string | Filters the "genbankAccession" column using a regular expression, see string search |
| genbankAccessionRev | string | Filters the "genbankAccessionRev" column" with exact match |
| genbankAccessionRev.regex | string | Filters the "genbankAccessionRev" column using a regular expression, see string search |
| gisaidClade | string | Filters the "gisaidClade" column" with exact match |
| gisaidClade.regex | string | Filters the "gisaidClade" column using a regular expression, see string search |
| gisaidEpiIsl | string | Filters the "gisaidEpiIsl" column" with exact match |
| gisaidEpiIsl.regex | string | Filters the "gisaidEpiIsl" column using a regular expression, see string search |
| host | string | Filters the "host" column" with exact match |
| host.regex | string | Filters the "host" column using a regular expression, see string search |
| immuneEscape | float | Filters the "immuneEscape" column" with exact match |
| immuneEscapeFrom | float | Filters the "immuneEscape" column (including the boundary) |
| immuneEscapeTo | float | Filters the "immuneEscape" column (including the boundary) |
| location | string | Filters the "location" column" with exact match |
| location.regex | string | Filters the "location" column using a regular expression, see string search |
| nextcladeCoverage | float | Filters the "nextcladeCoverage" column" with exact match |
| nextcladeCoverageFrom | float | Filters the "nextcladeCoverage" column (including the boundary) |
| nextcladeCoverageTo | float | Filters the "nextcladeCoverage" column (including the boundary) |
| nextcladePangoLineage | string | Filters the "nextcladePangoLineage" column" with exact match |
| nextcladePangoLineage.regex | string | Filters the "nextcladePangoLineage" column using a regular expression, see string search |
| nextcladeQcFrameShiftsScore | float | Filters the "nextcladeQcFrameShiftsScore" column" with exact match |
| nextcladeQcFrameShiftsScoreFrom | float | Filters the "nextcladeQcFrameShiftsScore" column (including the boundary) |
| nextcladeQcFrameShiftsScoreTo | float | Filters the "nextcladeQcFrameShiftsScore" column (including the boundary) |
| nextcladeQcMissingDataScore | float | Filters the "nextcladeQcMissingDataScore" column" with exact match |
| nextcladeQcMissingDataScoreFrom | float | Filters the "nextcladeQcMissingDataScore" column (including the boundary) |
| nextcladeQcMissingDataScoreTo | float | Filters the "nextcladeQcMissingDataScore" column (including the boundary) |
| nextcladeQcMixedSitesScore | float | Filters the "nextcladeQcMixedSitesScore" column" with exact match |
| nextcladeQcMixedSitesScoreFrom | float | Filters the "nextcladeQcMixedSitesScore" column (including the boundary) |
| nextcladeQcMixedSitesScoreTo | float | Filters the "nextcladeQcMixedSitesScore" column (including the boundary) |
| nextcladeQcOverallScore | float | Filters the "nextcladeQcOverallScore" column" with exact match |
| nextcladeQcOverallScoreFrom | float | Filters the "nextcladeQcOverallScore" column (including the boundary) |
| nextcladeQcOverallScoreTo | float | Filters the "nextcladeQcOverallScore" column (including the boundary) |
| nextcladeQcPrivateMutationsScore | float | Filters the "nextcladeQcPrivateMutationsScore" column" with exact match |
| nextcladeQcPrivateMutationsScoreFrom | float | Filters the "nextcladeQcPrivateMutationsScore" column (including the boundary) |
| nextcladeQcPrivateMutationsScoreTo | float | Filters the "nextcladeQcPrivateMutationsScore" column (including the boundary) |
| nextcladeQcSnpClustersScore | float | Filters the "nextcladeQcSnpClustersScore" column" with exact match |
| nextcladeQcSnpClustersScoreFrom | float | Filters the "nextcladeQcSnpClustersScore" column (including the boundary) |
| nextcladeQcSnpClustersScoreTo | float | Filters the "nextcladeQcSnpClustersScore" column (including the boundary) |
| nextcladeQcStopCodonsScore | float | Filters the "nextcladeQcStopCodonsScore" column" with exact match |
| nextcladeQcStopCodonsScoreFrom | float | Filters the "nextcladeQcStopCodonsScore" column (including the boundary) |
| nextcladeQcStopCodonsScoreTo | float | Filters the "nextcladeQcStopCodonsScore" column (including the boundary) |
| nextstrainClade | string | Filters the "nextstrainClade" column" with exact match |
| nextstrainClade.regex | string | Filters the "nextstrainClade" column using a regular expression, see string search |
| originatingLab | string | Filters the "originatingLab" column" with exact match |
| originatingLab.regex | string | Filters the "originatingLab" column using a regular expression, see string search |
| pangoLineage | string | Filters the "pangoLineage" column" with exact match |
| pangoLineage.regex | string | Filters the "pangoLineage" column using a regular expression, see string search |
| region | string | Filters the "region" column" with exact match |
| region.regex | string | Filters the "region" column using a regular expression, see string search |
| regionExposure | string | Filters the "regionExposure" column" with exact match |
| regionExposure.regex | string | Filters the "regionExposure" column using a regular expression, see string search |
| samplingStrategy | string | Filters the "samplingStrategy" column" with exact match |
| samplingStrategy.regex | string | Filters the "samplingStrategy" column using a regular expression, see string search |
| sex | string | Filters the "sex" column" with exact match |
| sex.regex | string | Filters the "sex" column using a regular expression, see string search |
| sraAccession | string | Filters the "sraAccession" column" with exact match |
| sraAccession.regex | string | Filters the "sraAccession" column using a regular expression, see string search |
| strain | string (primary key) | Filters the "strain" column" with exact match |
| strain.regex | string | Filters the "strain" column using a regular expression, see string search |
| submittingLab | string | Filters the "submittingLab" column" with exact match |
| submittingLab.regex | string | Filters the "submittingLab" column using a regular expression, see string search |
| whoClade | string | Filters the "whoClade" column" with exact match |
| whoClade.regex | string | Filters the "whoClade" column using a regular expression, see string search |
| died | boolean | Filters the "died" column for a boolean value |
| fullyVaccinated | boolean | Filters the "fullyVaccinated" column for a boolean value |
| hospitalized | boolean | Filters the "hospitalized" column for a boolean value |
| nextcladeDatasetVersion | string | Filters the "nextcladeDatasetVersion" column" with exact match |
| nextcladeDatasetVersion.regex | string | Filters the "nextcladeDatasetVersion" column using a regular expression, see string search |
| usherTree | string | Filters the "usherTree" column" with exact match |
| usherTree.regex | string | Filters the "usherTree" column using a regular expression, see string search |
| nucleotideMutations | list of strings | Filters for nucleotide mutations, see mutation filters |
| aminoAcidMutations | list of strings | Filters for amino acid mutations, see mutation filters |
| nucleotideInsertions | list of strings | In the format ins_false{'<position>:<insertion>'}. Example: ins_100:AGG |
| aminoAcidInsertions | list of strings | In the format ins_<sequenceName>:<position><insertion>. Example: ins_E:100:DEF |