To filter rows you can use a query based on named columns.
For example, to filter for rows where shape
is greater than 7225833 add
?query=shape>7225833
to the URL.
For a more complex example, try
?query=(shape>7225833)&(shape<7225836)
Query "shape>7225832" returned
38/6220 rows.
roi | shape | Image | Spot_ID | Chrom | Chrom_Start | Chrom_End | X | Y | Z | FoV | Nucleus_ID | Image Name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2372875 | 7225833 | 13965906 | 7225833 | chr2 | 158286571 | 158352358 | 499.0 | 896.0 | 28.0 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225834 | 13965906 | 7225834 | chr2 | 180707464 | 180773245 | 501.0 | 889.0 | 24.0 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225835 | 13965906 | 7225835 | chr2 | 183648104 | 183713699 | 495.2884056 | 883.8836693 | 28.134148600000003 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225836 | 13965906 | 7225836 | chr2 | 187022561 | 187095365 | 492.0 | 885.0 | 27.0 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225837 | 13965906 | 7225837 | chr2 | 189698368 | 189767443 | 486.48488889999993 | 894.0725631000001 | 24.84689109 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225838 | 13965906 | 7225838 | chr2 | 192700456 | 192763963 | 495.0 | 898.0 | 24.0 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225839 | 13965906 | 7225839 | chr2 | 196320065 | 196387628 | 490.18565430000007 | 893.2087521 | 25.85721905 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225840 | 13965906 | 7225840 | chr2 | 198802304 | 198867783 | 491.36184689999993 | 901.9013062000001 | 28.0 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225841 | 13965906 | 7225841 | chr2 | 201616162 | 201682961 | 498.125941 | 887.0471738 | 27.45593974 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225842 | 13965906 | 7225842 | chr2 | 210830897 | 210898218 | 499.89626569999996 | 891.2478077 | 24.34221103 | 25 | 16 | Dataset1.companion.ome [025] |
2372875 | 7225843 | 13965906 | 7225843 | chr2 | 231221646 | 231288393 | 490.6151676 | 903.5134091 | 23.54520867 | 25 | 16 | Dataset1.companion.ome [025] |
2372876 | 7225844 | 13965906 | 7225844 | chr2 | 118138644 | 118204055 | 761.0 | 730.0 | 24.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225845 | 13965906 | 7225845 | chr2 | 137737263 | 137803380 | 741.0 | 741.0 | 26.76401094 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225846 | 13965906 | 7225846 | chr2 | 158286571 | 158352358 | 745.0 | 746.0 | 23.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225847 | 13965906 | 7225847 | chr2 | 180707464 | 180773245 | 737.808052 | 738.8762481000001 | 23.98935516 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225848 | 13965906 | 7225848 | chr2 | 183648104 | 183713699 | 753.2961633 | 785.3266278 | 23.89706462 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225849 | 13965906 | 7225849 | chr2 | 187022561 | 187095365 | 730.0 | 743.0 | 21.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225850 | 13965906 | 7225850 | chr2 | 189698368 | 189767443 | 740.0 | 739.0 | 22.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225851 | 13965906 | 7225851 | chr2 | 192700456 | 192763963 | 746.0991596 | 745.0016304 | 19.87935105 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225852 | 13965906 | 7225852 | chr2 | 196320065 | 196387628 | 740.5912807 | 743.3906775 | 23.40789391 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225853 | 13965906 | 7225853 | chr2 | 198802304 | 198867783 | 746.680461 | 737.643154 | 25.38807679 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225854 | 13965906 | 7225854 | chr2 | 201616162 | 201682961 | 747.4414435 | 727.1369977 | 14.3821761 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225855 | 13965906 | 7225855 | chr2 | 210830897 | 210898218 | 733.3442668 | 750.3487215 | 28.16949594 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225856 | 13965906 | 7225856 | chr2 | 231221646 | 231288393 | 730.0 | 749.0 | 26.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225857 | 13965906 | 7225857 | chr2 | 118138644 | 118204055 | 794.0 | 734.0 | 26.12608305 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225858 | 13965906 | 7225858 | chr2 | 137737263 | 137803380 | 787.0 | 741.0 | 26.48315585 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225859 | 13965906 | 7225859 | chr2 | 158286571 | 158352358 | 784.8369936 | 749.993695 | 26.48365882 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225860 | 13965906 | 7225860 | chr2 | 177676147 | 177739905 | 792.0 | 739.0 | 28.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225861 | 13965906 | 7225861 | chr2 | 180707464 | 180773245 | 781.9578634 | 750.4089907 | 20.97074492 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225862 | 13965906 | 7225862 | chr2 | 183648104 | 183713699 | 783.3539412 | 745.0530797 | 26.88341478 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225863 | 13965906 | 7225863 | chr2 | 189698368 | 189767443 | 782.0 | 750.0 | 21.0 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225864 | 13965906 | 7225864 | chr2 | 196320065 | 196387628 | 787.8345365 | 747.5789042 | 22.21193523 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225865 | 13965906 | 7225865 | chr2 | 198802304 | 198867783 | 782.2565167 | 750.4869827 | 21.13097465 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225866 | 13965906 | 7225866 | chr2 | 201616162 | 201682961 | 790.1938851 | 750.491934 | 23.30392702 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225867 | 13965906 | 7225867 | chr2 | 205087694 | 205149345 | 781.7958376 | 756.5232136 | 20.92092334 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225868 | 13965906 | 7225868 | chr2 | 208067715 | 208129451 | 801.9721322 | 744.2638449 | 21.68948175 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225869 | 13965906 | 7225869 | chr2 | 210830897 | 210898218 | 804.3705617 | 750.4108813999999 | 26.63471664 | 25 | 17 | Dataset1.companion.ome [025] |
2372876 | 7225870 | 13965906 | 7225870 | chr2 | 231221646 | 231288393 | 776.7703369 | 772.192475 | 25.62345602 | 25 | 17 | Dataset1.companion.ome [025] |