# After Filtering out FeatureData\[Sequence\] from DADA2 based on length, how to match FeatureTable\[Frequency\] with FeatureData\[Sequence\]
**URL:** https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185
**Category:** User Support
**Created:** [July 14, 2021, 3:16am UTC](https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185 "2021-07-14T03:16:36Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@RitaHou2018](https://forum.qiime2.org/u/RitaHou2018)
#### Post date: [July 14, 2021, 3:16am UTC](https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185/1 "2021-07-14T03:16:36Z")
I filtered out asv’s below a certain length using the elegant solution posted here by @thermokarst,[Trying to filter asv's based on length](https://forum.qiime2.org/t/trying-to-filter-asvs-based-on-length/10690).
rep-seqs.qza is FeatureData[Sequence], how to filter the FeatureTable[Frequency]?
Namely how to match the (Feature table)`FeatureTable[Frequency] with (300-seqs.qza ) then FeatureData[Sequence]
qiime feature-table filter-seqs
--i-data rep-seqs.qza
--m-metadata-file rep-seqs.qza
--p-where 'length(sequence) \> 300’
--o-filtered-data 300-seqs.qza
---
### Author:  [@ChrisKeefe](https://forum.qiime2.org/u/ChrisKeefe)
#### Post date: [July 14, 2021, 4:49pm UTC](https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185/2 "2021-07-14T16:49:52Z")
Have you looked at [filter-features](https://docs.qiime2.org/2021.4/plugins/available/feature-table/filter-features/), @RitaHou2018 ?
There are a couple ways to do this. The [filtering tutorial](https://docs.qiime2.org/2021.4/tutorials/filtering/#metadata-based-filtering) discusses approaches like the one you used with `filter-seqs`, but you might be able to filter more simply by taking advantage of your already-filtered FeatureData[Sequences] and the property described in the last sentence here:
```
--p-where TEXT SQLite WHERE clause specifying feature metadata
criteria that must be met to be included in the
filtered feature table. If not provided, all features
in `metadata` that are also in the feature table will
be retained.
```
Good luck!
CK
---
### Author:  [@ChrisKeefe](https://forum.qiime2.org/u/ChrisKeefe)
#### Post date: [July 14, 2021, 9:41pm UTC](https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185/6 "2021-07-14T21:41:38Z")
In case my response wasn't clear enough, @RitaHou2018, what I'm suggesting looks like this:
- Filter `FeatureData[Sequence]` based on length (using `--p-where` param) (you did this already!)
- Filter `FeatureTable[Frequency]` using the filtered file from step one. No `--p-where` param required - simply provide the filtered `FeatureData[Sequence]` as input and an ID-based filter is applied by default.
---
### Author:  [@RitaHou2018](https://forum.qiime2.org/u/RitaHou2018)
#### Post date: [July 15, 2021, 2:41am UTC](https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185/8 "2021-07-15T02:41:14Z")
Brilliant!
Thank you so much @ChrisKeefe .
It works!
> qiime feature-table filter-features
> --i-table table-dada0.qza
> --m-metadata-file 300-seqs.qza
> --o-filtered-table table-dada0-filter300.qza
---
### Author:  [@system](https://forum.qiime2.org/u/system)
#### Post date: [August 15, 2021, 8:41am UTC](https://forum.qiime2.org/t/after-filtering-out-featuredata-sequence-from-dada2-based-on-length-how-to-match-featuretable-frequency-with-featuredata-sequence/20185/9 "2021-08-15T08:41:38Z")
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.