contig_metadata
29 rows where bioproject = "PRJNA986481", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 974051 | 974051 | PRJNA986481_P_NODE_8641_length_553_cov_5.037698_g8131_i0 | PRJNA986481 | 8641 | 553 | 5.037698 | 27.85846994 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 3.5500000000000004e-123 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g8131 | i0 | 86.538 | 61.1971066907776 | 416 | 52 | 75 | 3 | 4 | 419 | 43 | 454 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 33842 | 455 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 2249228 | 2249228 | PRJNA986481_P_NODE_63282_length_204_cov_11.722581_g62757_i0 | PRJNA986481 | 63282 | 204 | 11.722581 | 23.91406524 | Cercozoa sp. Panama112 | 563759 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.59e-100 | NTclustered | gi|219524795|gb|EU709158.1| | 563759 | g62757 | i0 | 100 | 99.9656862745098 | 204 | 0 | 100 | 0 | 1 | 204 | 1563 | 1360 | Cercozoa sp. Panama112 18S ribosomal RNA gene, partial sequence | blastn | 20393 | 377 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. Panama112 | ||||||
| 3524037 | 3524037 | PRJNA986481_P_NODE_2723_length_899_cov_1877.987059_g855_i4 | PRJNA986481 | 2723 | 899 | 1877.987059 | 16883.10366041 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 6.18e-93 | NTclustered | gi|220983371|dbj|AB453007.1| | 1561963 | g855 | i4 | 78.957 | 46.0856507230256 | 556 | 92 | 61 | 21 | 184 | 730 | 1231 | 692 | Amorphochlora amoebiformis gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 41431 | 355 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 4801895 | 4801895 | PRJNA986481_P_NODE_6544_length_630_cov_2.089501_g6066_i0 | PRJNA986481 | 6544 | 630 | 2.089501 | 13.1638563 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 780 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g6066 | i0 | 89.155 | 98.1015873015873 | 627 | 66 | 99 | 2 | 3 | 628 | 659 | 34 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 61804 | 780 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9901502 | 9901502 | PRJNA986481_P_NODE_20128_length_365_cov_2.632911_g19603_i0 | PRJNA986481 | 20128 | 365 | 2.632911 | 9.61012515 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.5e-53 | NTclustered | gi|300676723|gb|GQ377712.1| | 323453 | g19603 | i0 | 82.558 | 4.73150684931507 | 258 | 39 | 70 | 6 | 111 | 365 | 4 | 258 | Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds | blastn | 1727 | 222 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 12453245 | 12453245 | PRJNA986481_P_NODE_7530_length_591_cov_4.245387_g7030_i0 | PRJNA986481 | 7530 | 591 | 4.245387 | 25.09023717 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 4.41e-118 | NR | ADK26624.1 | 323453 | g7030 | i0 | 89.3 | 0.949238578680203 | 187 | 20 | 94.9 | 0 | 2 | 562 | 90 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 561 | 346 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 13727230 | 13727230 | PRJNA986481_P_NODE_3831_length_784_cov_10.468027_g3443_i0 | PRJNA986481 | 3831 | 784 | 10.468027 | 82.06933168 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g3443 | i0 | 91.219 | 61 | 558 | 43 | 77 | 3 | 233 | 784 | 1895 | 1338 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 47824 | 754 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 15001694 | 15001694 | PRJNA986481_P_NODE_48012_length_254_cov_1.697561_g47487_i0 | PRJNA986481 | 48012 | 254 | 1.697561 | 4.31180494 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 5.37e-128 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g47487 | i0 | 100 | 100.291338582677 | 254 | 0 | 100 | 0 | 1 | 254 | 728 | 475 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25474 | 470 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15001936 | 15001936 | PRJNA986481_P_NODE_6812_length_619_cov_6.331579_g6328_i0 | PRJNA986481 | 6812 | 619 | 6.331579 | 39.19247401 | Hondaea | 2315209 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 5.38e-85 | NR | MES1912193.1 | 1215613 | g6328 | i0 | 61.7 | 4.78836833602585 | 196 | 75 | 95 | 0 | 19 | 606 | 43 | 238 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 2964 | 261 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 16276189 | 16276189 | PRJNA986481_P_NODE_18553_length_380_cov_1.945619_g18028_i0 | PRJNA986481 | 18553 | 380 | 1.945619 | 7.3933522 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 3.3299999999999997e-62 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g18028 | i0 | 79.57 | 94.3289473684211 | 372 | 60 | 96 | 11 | 2 | 365 | 100 | 463 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 35845 | 252 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 16276198 | 16276198 | PRJNA986481_P_NODE_19033_length_375_cov_1.858896_g18508_i0 | PRJNA986481 | 19033 | 375 | 1.858896 | 6.97086 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 3.42e-38 | NR | MES1911029.1 | 1215613 | g18508 | i0 | 58.1 | 1.976 | 124 | 48 | 96 | 2 | 1 | 360 | 152 | 275 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 741 | 140 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 20100194 | 20100194 | PRJNA986481_P_NODE_44676_length_258_cov_0.966507_g44151_i0 | PRJNA986481 | 44676 | 258 | 0.966507 | 2.49358806 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 2.77e-66 | NTclustered | gi|300676750|gb|GQ377668.1| | 45107 | g44151 | i0 | 85.214 | 97.515503875969 | 257 | 38 | 99 | 0 | 1 | 257 | 984 | 728 | Heteromita globosa actin gene, partial cds | blastn | 25159 | 265 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20100198 | 20100198 | PRJNA986481_P_NODE_4496_length_738_cov_8.277213_g4080_i0 | PRJNA986481 | 4496 | 738 | 8.277213 | 61.08583194 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 4.96e-103 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g4080 | i0 | 85.417 | 58.0731707317073 | 384 | 45 | 84 | 10 | 358 | 738 | 4039 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 42858 | 388 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 21674461 | 21674461 | PRJNA986481_P_NODE_37797_length_266_cov_9.377880_g37272_i0 | PRJNA986481 | 37797 | 266 | 9.37788 | 24.9451608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.5900000000000002e-123 | NTclustered | gi|512134093|gb|KC575317.1| | 175275 | g37272 | i0 | 100 | 92.4661654135338 | 246 | 0 | 92 | 0 | 21 | 266 | 149 | 394 | Uncultured cercozoan clone B.17.1 18S ribosomal RNA gene, partial sequence | blastn | 24596 | 455 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 22650707 | 22650707 | PRJNA986481_P_NODE_4018_length_770_cov_9.486824_g3622_i0 | PRJNA986481 | 4018 | 770 | 9.486824 | 73.0485448 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 2.8499999999999995e-165 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g3622 | i0 | 86.679 | 58.3922077922078 | 548 | 59 | 77 | 10 | 1 | 538 | 1338 | 1881 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 44962 | 595 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 25199537 | 25199537 | PRJNA986481_P_NODE_20220_length_364_cov_3.841270_g19695_i0 | PRJNA986481 | 20220 | 364 | 3.84127 | 13.9822228 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 628 | 1.2499999999999999e-175 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g19695 | i0 | 97.802 | 2 | 364 | 8 | 100 | 0 | 1 | 364 | 350 | 713 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 728 | 628 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 25199888 | 25199888 | PRJNA986481_P_NODE_42900_length_260_cov_1.308057_g42375_i0 | PRJNA986481 | 42900 | 260 | 1.308057 | 3.4009482 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.83e-62 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g42375 | i0 | 84.03 | 1.01153846153846 | 263 | 39 | 100 | 2 | 1 | 260 | 25398 | 25660 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 263 | 250 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 27058012 | 27058012 | PRJNA986481_P_NODE_28102_length_309_cov_2.369231_g27577_i0 | PRJNA986481 | 28102 | 309 | 2.369231 | 7.32092379 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 4.21e-10 | NR | MES1911029.1 | 1215613 | g27577 | i0 | 50 | 0.737864077669903 | 76 | 38 | 73.8 | 0 | 308 | 81 | 225 | 300 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 228 | 65.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27279341 | 27279341 | PRJNA986481_P_NODE_22823_length_343_cov_2.540816_g22298_i0 | PRJNA986481 | 22823 | 343 | 2.540816 | 8.71499888 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 1.43e-16 | NR | MES1913050.1 | 1215613 | g22298 | i0 | 41.4 | 0.865889212827988 | 99 | 57 | 86.6 | 1 | 302 | 6 | 190 | 287 | MES1913050.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 297 | 85.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27879302 | 27879302 | PRJNA986481_P_NODE_52165_length_250_cov_1.004975_g51640_i0 | PRJNA986481 | 52165 | 250 | 1.004975 | 2.5124375 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 1.26e-8 | NR | MES1907871.1 | 1215613 | g51640 | i0 | 34.9 | 1.032 | 86 | 53 | 99.6 | 3 | 1 | 249 | 66 | 151 | MES1907871.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 258 | 61.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28573828 | 28573828 | PRJNA986481_P_NODE_31027_length_293_cov_3.413934_g30502_i0 | PRJNA986481 | 31027 | 293 | 3.413934 | 10.00282662 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 7.65e-4 | NR | ADK47156.1 | 323453 | g30502 | i0 | 91.3 | 0.235494880546075 | 23 | 2 | 23.5 | 0 | 10 | 78 | 123 | 145 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 69 | 47 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29836790 | 29836790 | PRJNA986481_P_NODE_33091_length_284_cov_1.719149_g32566_i0 | PRJNA986481 | 33091 | 284 | 1.719149 | 4.88238316 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 6.63e-17 | NR | MES1911029.1 | 1215613 | g32566 | i0 | 52.7 | 1.95422535211268 | 91 | 41 | 96.1 | 1 | 1 | 273 | 206 | 294 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 555 | 84 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30089546 | 30089546 | PRJNA986481_P_NODE_9572_length_528_cov_4.283925_g9053_i0 | PRJNA986481 | 9572 | 528 | 4.283925 | 22.619124 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 6.82e-29 | NR | MES1907871.1 | 1215613 | g9053 | i0 | 40.7 | 0.852272727272727 | 150 | 87 | 85.2 | 1 | 51 | 500 | 305 | 452 | MES1907871.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 450 | 123 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31100487 | 31100487 | PRJNA986481_P_NODE_12695_length_460_cov_2.722628_g12171_i0 | PRJNA986481 | 12695 | 460 | 2.722628 | 12.5240888 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 2.49e-53 | NR | MES1911029.1 | 1215613 | g12171 | i0 | 57.7 | 7.53260869565217 | 156 | 62 | 99.1 | 1 | 2 | 457 | 113 | 268 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 3465 | 181 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31290191 | 31290191 | PRJNA986481_P_NODE_24775_length_330_cov_1.323843_g24250_i0 | PRJNA986481 | 24775 | 330 | 1.323843 | 4.3686819 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.14e-50 | NR | ADK26624.1 | 323453 | g24250 | i0 | 73.6 | 1 | 110 | 29 | 100 | 0 | 330 | 1 | 161 | 270 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 330 | 171 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 31321886 | 31321886 | PRJNA986481_P_NODE_45335_length_257_cov_2.086538_g44810_i0 | PRJNA986481 | 45335 | 257 | 2.086538 | 5.36240266 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 74.3 | 7.67e-14 | NR | MES1913771.1 | 1215613 | g44810 | i0 | 39.5 | 1.93774319066148 | 81 | 44 | 94.6 | 1 | 3 | 245 | 89 | 164 | MES1913771.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 498 | 74.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31764740 | 31764740 | PRJNA986481_P_NODE_47297_length_255_cov_0.980583_g46772_i0 | PRJNA986481 | 47297 | 255 | 0.980583 | 2.50048665 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 9.84e-12 | NR | MES1909875.1 | 1215613 | g46772 | i0 | 40.2 | 2.2 | 92 | 48 | 100 | 1 | 255 | 1 | 268 | 359 | MES1909875.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 561 | 70.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31859555 | 31859555 | PRJNA986481_P_NODE_62257_length_229_cov_2.211111_g61732_i0 | PRJNA986481 | 62257 | 229 | 2.211111 | 5.06344419 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 4.92e-5 | NR | MES1912234.1 | 1215613 | g61732 | i0 | 61.3 | 0.812227074235808 | 31 | 12 | 40.6 | 0 | 136 | 228 | 85 | 115 | MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 186 | 48.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32081092 | 32081092 | PRJNA986481_P_NODE_55978_length_245_cov_5.382653_g55453_i0 | PRJNA986481 | 55978 | 245 | 5.382653 | 13.18749985 | Lotharella oceanica | 641309 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 6.67e-13 | NR | AIB09582.1 | 641309 | g55453 | i0 | 57.4 | 0.661224489795918 | 54 | 23 | 66.1 | 0 | 206 | 45 | 1 | 54 | AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] | diamond | 162 | 67.4 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Lotharella | Lotharella oceanica |
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);;