contig_metadata
18 rows where bioproject = "PRJNA407087", tax_clade = "Sar" and tax_phylum = "Cercozoa"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4242060 | 4242060 | PRJNA407087_S_NODE_5584_length_215_cov_48.801075_g5121_i0 | PRJNA407087 | 5584 | 215 | 48.801075 | 104.92231125 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 2.929999999999999e-55 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5121 | i0 | 86.175 | 14.3627906976744 | 217 | 23 | 99 | 7 | 1 | 212 | 2163 | 2377 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 3088 | 228 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 4242062 | 4242062 | PRJNA407087_S_NODE_5764_length_211_cov_8.060440_g5301_i0 | PRJNA407087 | 5764 | 211 | 8.06044 | 17.0075284 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 3.709999999999999e-54 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5301 | i0 | 85.78 | 40.914691943128 | 218 | 24 | 100 | 3 | 1 | 211 | 1659 | 1876 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 8633 | 224 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 5518751 | 5518751 | PRJNA407087_S_NODE_8865_length_160_cov_23.290076_g8402_i0 | PRJNA407087 | 8865 | 160 | 23.290076 | 37.2641216 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 3.44e-53 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g8402 | i0 | 91.772 | 100.15625 | 158 | 13 | 99 | 0 | 3 | 160 | 1029 | 1186 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 16025 | 220 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 6792709 | 6792709 | PRJNA407087_S_NODE_9286_length_156_cov_9.141732_g8823_i0 | PRJNA407087 | 9286 | 156 | 9.141732 | 14.26110192 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 5.41e-71 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g8823 | i0 | 99.351 | 99.6474358974359 | 154 | 1 | 99 | 0 | 3 | 156 | 1029 | 1182 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15545 | 279 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 7459595 | 7459595 | PRJNA407087_S_NODE_6046_length_204_cov_47.400000_g5583_i0 | PRJNA407087 | 6046 | 204 | 47.4 | 96.696 | Cercomonas | 45109 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 3.39e-89 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g5583 | i0 | 96.602 | 101.799019607843 | 206 | 5 | 100 | 1 | 1 | 204 | 2936 | 2731 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 20767 | 340 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 | |||
| 9343137 | 9343137 | PRJNA407087_S_NODE_7008_length_185_cov_27.442308_g6545_i0 | PRJNA407087 | 7008 | 185 | 27.442308 | 50.7682698 | Bodomorpha sp. HFCC56 | 352464 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 3.07e-74 | NTclustered | gi|83034974|gb|DQ211603.1| | 352464 | g6545 | i0 | 95.161 | 100.648648648649 | 186 | 5 | 99 | 4 | 1 | 184 | 290 | 473 | Bodomorpha sp. HFCC56 28S ribosomal RNA gene, partial sequence | blastn | 18620 | 291 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC56 | |||
| 10618874 | 10618874 | PRJNA407087_S_NODE_2669_length_384_cov_23.698592_g2208_i0 | PRJNA407087 | 2669 | 384 | 23.698592 | 91.00259328 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 1.51e-85 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2208 | i0 | 82.99 | 49.5989583333333 | 388 | 43 | 99 | 18 | 1 | 383 | 3661 | 4030 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19046 | 329 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 11893781 | 11893781 | PRJNA407087_S_NODE_3050_length_348_cov_21.335423_g2587_i0 | PRJNA407087 | 3050 | 348 | 21.335423 | 74.24727204 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 6.279999999999999e-89 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2587 | i0 | 84.659 | 55.0431034482759 | 352 | 42 | 100 | 11 | 1 | 348 | 4004 | 3661 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19155 | 340 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 11893792 | 11893792 | PRJNA407087_S_NODE_4590_length_250_cov_26.837104_g4127_i0 | PRJNA407087 | 4590 | 250 | 26.837104 | 67.09276 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 6.87e-122 | NTclustered | gi|219524910|gb|EU709273.1| | 175275 | g4127 | i0 | 99.593 | 99.5 | 246 | 1 | 98 | 0 | 2 | 247 | 62 | 307 | Uncultured cercozoan isolate AH44p78p118t17 18S ribosomal RNA gene, partial sequence | blastn | 24875 | 449 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 12560345 | 12560345 | PRJNA407087_S_NODE_5830_length_209_cov_29.188889_g5367_i0 | PRJNA407087 | 5830 | 209 | 29.188889 | 61.00477801 | Cercomonadida | 188941 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.18e-61 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5367 | i0 | 88.095 | 100.866028708134 | 210 | 23 | 100 | 2 | 1 | 209 | 1441 | 1649 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 21081 | 248 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 16992516 | 16992516 | PRJNA407087_S_NODE_9634_length_153_cov_4.250000_g9171_i0 | PRJNA407087 | 9634 | 153 | 4.25 | 6.5025 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 2.69e-4 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g9171 | i0 | 100 | 19.437908496732 | 31 | 0 | 20 | 0 | 123 | 153 | 2795 | 2825 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 2974 | 58.4 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 20207845 | 20207845 | PRJNA407087_S_NODE_5636_length_214_cov_21.351351_g5173_i0 | PRJNA407087 | 5636 | 214 | 21.351351 | 45.69189114 | root | 1 | Root_unresolved | Root_unresolved | 73.1 | 1.45e-8 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g5173 | i0 | 92.157 | 19.4672897196262 | 51 | 4 | 24 | 0 | 1 | 51 | 2240 | 2190 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 4166 | 73.1 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo | ||
| 20816582 | 20816582 | PRJNA407087_S_NODE_2177_length_442_cov_12.939467_g1717_i0 | PRJNA407087 | 2177 | 442 | 12.939467 | 57.19244414 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 7.279999999999997e-169 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g1717 | i0 | 91.441 | 99.8552036199095 | 444 | 34 | 100 | 4 | 1 | 442 | 1472 | 1031 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 44136 | 606 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20816616 | 20816616 | PRJNA407087_S_NODE_6237_length_200_cov_15.064327_g5774_i0 | PRJNA407087 | 6237 | 200 | 15.064327 | 30.128654 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 9.27e-85 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5774 | i0 | 96 | 99.355 | 200 | 8 | 100 | 0 | 1 | 200 | 1649 | 1450 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 19871 | 326 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23367036 | 23367036 | PRJNA407087_S_NODE_2699_length_381_cov_32.795455_g2237_i0 | PRJNA407087 | 2699 | 381 | 32.795455 | 124.95068355 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 5.470000000000001e-75 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2237 | i0 | 81.152 | 49.9343832020997 | 382 | 58 | 99 | 11 | 1 | 380 | 3661 | 4030 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19025 | 294 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24033373 | 24033373 | PRJNA407087_S_NODE_4679_length_246_cov_36.608295_g4216_i0 | PRJNA407087 | 4679 | 246 | 36.608295 | 90.0564057 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 3.1799999999999995e-110 | NTclustered | gi|219524797|gb|EU709160.1| | 175275 | g4216 | i0 | 96.748 | 100 | 246 | 8 | 100 | 0 | 1 | 246 | 675 | 920 | Uncultured cercozoan isolate HetChi41 18S ribosomal RNA gene, partial sequence | blastn | 24600 | 411 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 24641357 | 24641357 | PRJNA407087_S_NODE_2220_length_435_cov_29.379310_g1759_i0 | PRJNA407087 | 2220 | 435 | 29.37931 | 127.7999985 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 6.37e-70 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g1759 | i0 | 80.051 | 43.7563218390805 | 391 | 64 | 89 | 11 | 47 | 435 | 4039 | 3661 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19034 | 278 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 29980707 | 29980707 | PRJNA407087_S_NODE_5791_length_210_cov_28.154696_g5328_i0 | PRJNA407087 | 5791 | 210 | 28.154696 | 59.1248616 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 2.56e-20 | NR | MES1909697.1 | 1215613 | g5328 | i0 | 66.1 | 5.05714285714286 | 59 | 20 | 84.3 | 0 | 177 | 1 | 4 | 62 | MES1909697.1 40S ribosomal protein S9 [Cercozoa sp. M6MM] | diamond | 1062 | 89.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;