Filters
This instance of LAPIS supports the following sequence filters:
| Name | Type | Description |
|---|---|---|
| ace2Binding | float | Filters the "ace2Binding" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| authors.regex | string | Filters the "authors" column using a regular expression, see string search |
| country | string | Filters the "country" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| country.regex | string | Filters the "country" column using a regular expression, see string search |
| countryExposure | string | Filters the "countryExposure" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| countryExposure.regex | string | Filters the "countryExposure" column using a regular expression, see string search |
| database | string | Filters the "database" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| database.regex | string | Filters the "database" column using a regular expression, see string search |
| date | date | Filters the "date" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| dateOriginalValue.regex | string | Filters the "dateOriginalValue" column using a regular expression, see string search |
| dateSubmitted | date | Filters the "dateSubmitted" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| dateSubmittedOriginalValue.regex | string | Filters the "dateSubmittedOriginalValue" column using a regular expression, see string search |
| dateSubmittedYear | int | Filters the "dateSubmittedYear" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| dateUpdatedOriginalValue.regex | string | Filters the "dateUpdatedOriginalValue" column using a regular expression, see string search |
| dateUpdatedYear | int | Filters the "dateUpdatedYear" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| division.regex | string | Filters the "division" column using a regular expression, see string search |
| divisionExposure | string | Filters the "divisionExposure" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| divisionExposure.regex | string | Filters the "divisionExposure" column using a regular expression, see string search |
| genbankAccession | string | Filters the "genbankAccession" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| genbankAccession.regex | string | Filters the "genbankAccession" column using a regular expression, see string search |
| genbankAccessionRev | string | Filters the "genbankAccessionRev" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| genbankAccessionRev.regex | string | Filters the "genbankAccessionRev" column using a regular expression, see string search |
| gisaidClade | string | Filters the "gisaidClade" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| gisaidClade.regex | string | Filters the "gisaidClade" column using a regular expression, see string search |
| gisaidEpiIsl | string | Filters the "gisaidEpiIsl" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| gisaidEpiIsl.regex | string | Filters the "gisaidEpiIsl" column using a regular expression, see string search |
| host | string | Filters the "host" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| host.regex | string | Filters the "host" column using a regular expression, see string search |
| immuneEscape | float | Filters the "immuneEscape" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| location.regex | string | Filters the "location" column using a regular expression, see string search |
| nextcladeCoverage | float | Filters the "nextcladeCoverage" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| nextcladePangoLineage.regex | string | Filters the "nextcladePangoLineage" column using a regular expression, see string search |
| nextcladeQcFrameShiftsScore | float | Filters the "nextcladeQcFrameShiftsScore" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| nextstrainClade.regex | string | Filters the "nextstrainClade" column using a regular expression, see string search |
| originatingLab | string | Filters the "originatingLab" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| originatingLab.regex | string | Filters the "originatingLab" column using a regular expression, see string search |
| pangoLineage | string | Filters the "pangoLineage" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| pangoLineage.regex | string | Filters the "pangoLineage" column using a regular expression, see string search |
| region | string | Filters the "region" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| region.regex | string | Filters the "region" column using a regular expression, see string search |
| regionExposure | string | Filters the "regionExposure" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| regionExposure.regex | string | Filters the "regionExposure" column using a regular expression, see string search |
| samplingStrategy | string | Filters the "samplingStrategy" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| samplingStrategy.regex | string | Filters the "samplingStrategy" column using a regular expression, see string search |
| sex | string | Filters the "sex" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| sex.regex | string | Filters the "sex" column using a regular expression, see string search |
| sraAccession | string | Filters the "sraAccession" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| strain.regex | string | Filters the "strain" column using a regular expression, see string search |
| submittingLab | string | Filters the "submittingLab" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| submittingLab.regex | string | Filters the "submittingLab" column using a regular expression, see string search |
| whoClade | string | Filters the "whoClade" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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. You can also supply an array of values - they will be combined with logical OR. |
| nextcladeDatasetVersion.regex | string | Filters the "nextcladeDatasetVersion" column using a regular expression, see string search |
| usherTree | string | Filters the "usherTree" column with exact match. You can also supply an array of values - they will be combined with logical OR. |
| 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 |