# How do I filter to a one megabase range of a matrix table

**URL:** <https://discuss.hail.is/t/how-do-i-filter-to-a-one-megabase-range-of-a-matrix-table/1463>\
**Category:** Hail Query & hailctl\
**Created:** [June 13, 2020, 4:38pm UTC](https://discuss.hail.is/t/how-do-i-filter-to-a-one-megabase-range-of-a-matrix-table/1463 "2020-06-13T16:38:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vb-csg](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/vb-csg/32/387_2.png) [@vb-csg](https://discuss.hail.is/u/vb-csg)\
**Post date:** [June 13, 2020, 4:38pm UTC](https://discuss.hail.is/t/how-do-i-filter-to-a-one-megabase-range-of-a-matrix-table/1463/1 "2020-06-13T16:38:49Z")

</div>

How would you extend this to a 1 megabase region centered on 1:139120?

---

<div class="post-metadata">

**Author:** ![tpoterba](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/tpoterba/32/61_2.png) [@tpoterba](https://discuss.hail.is/u/tpoterba)\
**Post date:** [June 13, 2020, 4:40pm UTC](https://discuss.hail.is/t/how-do-i-filter-to-a-one-megabase-range-of-a-matrix-table/1463/2 "2020-06-13T16:40:59Z")

</div>

Could do:

```python
interval_of_interest = hl.locus('1', 139120).window(1_000_000, 1_000_000)
filter_rows(interval_of_interest.contains(mt.locus))

```

---

<div class="post-metadata">

**Author:** ![vb-csg](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/vb-csg/32/387_2.png) [@vb-csg](https://discuss.hail.is/u/vb-csg)\
**Post date:** [June 13, 2020, 4:41pm UTC](https://discuss.hail.is/t/how-do-i-filter-to-a-one-megabase-range-of-a-matrix-table/1463/3 "2020-06-13T16:41:24Z")

</div>

Thanks so much!