contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2177751 | 2177751 | PRJNA928559_P_NODE_137862_length_301_cov_4.877193_g136293_i0 | PRJNA928559 | 137862 | 301 | 4.877193 | 14.68035093 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 2.66e-21 | NR | YP_009118058.1 | 372086 | g136293 | i0 | 95.6 | 0.897009966777409 | 45 | 2 | 44.9 | 0 | 301 | 167 | 346 | 390 | YP_009118058.1 NADH dehydrogenase subunit 7 [Paracercomonas marina] | diamond | 270 | 97.1 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 2179471 | 2179471 | PRJNA928559_P_NODE_51202_length_479_cov_3.830049_g49640_i0 | PRJNA928559 | 51202 | 479 | 3.830049 | 18.34593471 | Thaumatomonas sp. TMT | 45100 | SAR_Eukaryotes | SAR_Eukaryotes | 253 | 1e-81 | NR | ACF24486.1 | 407209 | g49640 | i0 | 77.8 | 2.9812108559499 | 158 | 35 | 99 | 0 | 475 | 2 | 23 | 180 | ACF24486.1 70 kDa heat shock protein, partial [Thaumatomonas sp. TMT002] | diamond | 1428 | 253 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 2179733 | 2179733 | PRJNA928559_P_NODE_72102_length_415_cov_2.204678_g70533_i0 | PRJNA928559 | 72102 | 415 | 2.204678 | 9.1494137 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 218 | 1.09e-70 | NR | ADK26622.1 | 323453 | g70533 | i0 | 79.2 | 1.87951807228916 | 130 | 27 | 94 | 0 | 405 | 16 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 780 | 218 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 3454927 | 3454927 | PRJNA928559_P_NODE_44963_length_505_cov_4.277778_g43403_i0 | PRJNA928559 | 44963 | 505 | 4.277778 | 21.6027789 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 7.6e-63 | NR | YP_009118065.1 | 372086 | g43403 | i0 | 77.7 | 0.718811881188119 | 121 | 27 | 71.9 | 0 | 1 | 363 | 9 | 129 | YP_009118065.1 apocytochrome b [Paracercomonas marina] | diamond | 363 | 207 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 7282212 | 7282212 | PRJNA928559_P_NODE_54026_length_469_cov_2.212121_g52460_i0 | PRJNA928559 | 54026 | 469 | 2.212121 | 10.37484749 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 184 | 2.6e-51 | NR | YP_009118074.1 | 372086 | g52460 | i0 | 70.2 | 0.901918976545842 | 141 | 37 | 87.6 | 3 | 413 | 3 | 332 | 471 | YP_009118074.1 NADH dehydrogenase subunit 5 [Paracercomonas marina] | diamond | 423 | 184 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 8554913 | 8554913 | PRJNA928559_P_NODE_113227_length_335_cov_1.961832_g111658_i0 | PRJNA928559 | 113227 | 335 | 1.961832 | 6.5721372 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 3.169999999999999e-55 | NR | YP_009118058.1 | 372086 | g111658 | i0 | 85.6 | 0.994029850746269 | 111 | 16 | 99.4 | 0 | 3 | 335 | 82 | 192 | YP_009118058.1 NADH dehydrogenase subunit 7 [Paracercomonas marina] | diamond | 333 | 186 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 8556846 | 8556846 | PRJNA928559_P_NODE_39247_length_534_cov_1.336226_g37692_i0 | PRJNA928559 | 39247 | 534 | 1.336226 | 7.13544684 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 7.19e-51 | NR | ACF24562.1 | 67809 | g37692 | i0 | 65 | 3.14606741573034 | 137 | 48 | 77 | 0 | 532 | 122 | 105 | 241 | ACF24562.1 proteasome alpha 5 subunit [Gymnochlora stellata] | diamond | 1680 | 173 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 8556990 | 8556990 | PRJNA928559_P_NODE_49507_length_486_cov_3.602906_g47945_i0 | PRJNA928559 | 49507 | 486 | 3.602906 | 17.51012316 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 212 | 9.07e-65 | NR | YP_009118065.1 | 372086 | g47945 | i0 | 79.7 | 0.851851851851852 | 138 | 28 | 85.2 | 0 | 485 | 72 | 165 | 302 | YP_009118065.1 apocytochrome b [Paracercomonas marina] | diamond | 414 | 212 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 14930654 | 14930654 | PRJNA928559_P_NODE_159832_length_277_cov_21.328431_g158263_i0 | PRJNA928559 | 159832 | 277 | 21.328431 | 59.07975387 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.38e-34 | NR | YP_009118053.1 | 372086 | g158263 | i0 | 89.2 | 0.8014440433213 | 74 | 8 | 80.1 | 0 | 222 | 1 | 1 | 74 | YP_009118053.1 ATP synthase F0 subunit c [Paracercomonas marina] | diamond | 222 | 123 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 19104515 | 19104515 | PRJNA928559_P_NODE_33635_length_568_cov_3.482828_g32097_i0 | PRJNA928559 | 33635 | 568 | 3.482828 | 19.78246304 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 4.63e-49 | NR | YP_009118054.1 | 372086 | g32097 | i0 | 58.7 | 0.818661971830986 | 155 | 46 | 81.9 | 3 | 468 | 4 | 646 | 782 | YP_009118054.1 cytochrome c oxidase subunit 1 and subunit 2 fusion protein [Paracercomonas marina] | diamond | 465 | 180 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 21305321 | 21305321 | PRJNA928559_P_NODE_196757_length_249_cov_1.482955_g195188_i0 | PRJNA928559 | 196757 | 249 | 1.482955 | 3.69255795 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 1.72e-38 | NR | ACF24565.1 | 67809 | g195188 | i0 | 84.1 | 1.97590361445783 | 82 | 13 | 98.8 | 0 | 4 | 249 | 41 | 122 | ACF24565.1 proteasome alpha 4 subunit [Gymnochlora stellata] | diamond | 492 | 138 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 25128882 | 25128882 | PRJNA928559_P_NODE_162840_length_275_cov_1.133663_g161271_i0 | PRJNA928559 | 162840 | 275 | 1.133663 | 3.11757325 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 3e-30 | NR | BBE07975.1 | 1928728 | g161271 | i0 | 70.3 | 0.992727272727273 | 91 | 27 | 99.3 | 0 | 274 | 2 | 115 | 205 | BBE07975.1 GTPase Rab11/YPT3 [Paulinella micropora] | diamond | 273 | 116 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 26961345 | 26961345 | PRJNA928559_P_NODE_196802_length_249_cov_1.426136_g195233_i0 | PRJNA928559 | 196802 | 249 | 1.426136 | 3.55107864 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 9.04e-12 | NR | MES1914144.1 | 1215613 | g195233 | i0 | 53.6 | 1.3855421686747 | 56 | 26 | 67.5 | 0 | 175 | 8 | 27 | 82 | MES1914144.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 345 | 70.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27056453 | 27056453 | PRJNA928559_P_NODE_105682_length_347_cov_1.689781_g104113_i0 | PRJNA928559 | 105682 | 347 | 1.689781 | 5.86354007 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0343 | NR | YP_009118074.1 | 372086 | g104113 | i0 | 36.7 | 0.518731988472622 | 60 | 38 | 51.9 | 0 | 38 | 217 | 1 | 60 | YP_009118074.1 NADH dehydrogenase subunit 5 [Paracercomonas marina] | diamond | 180 | 44.3 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 27182598 | 27182598 | PRJNA928559_P_NODE_123122_length_320_cov_7.797571_g121553_i0 | PRJNA928559 | 123122 | 320 | 7.797571 | 24.9522272 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 2.3e-47 | NR | MES1911029.1 | 1215613 | g121553 | i0 | 72.4 | 0.984375 | 105 | 29 | 98.4 | 0 | 318 | 4 | 18 | 122 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 315 | 163 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27404264 | 27404264 | PRJNA928559_P_NODE_71323_length_417_cov_2.104651_g69754_i0 | PRJNA928559 | 71323 | 417 | 2.104651 | 8.77639467 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 3.2299999999999997e-24 | NR | YP_009118076.1 | 372086 | g69754 | i0 | 54.2 | 0.690647482014389 | 96 | 44 | 69.1 | 0 | 34 | 321 | 239 | 334 | YP_009118076.1 NADH dehydrogenase subunit 2 [Paracercomonas marina] | diamond | 288 | 107 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 28193263 | 28193263 | PRJNA928559_P_NODE_47706_length_494_cov_1.560570_g46144_i0 | PRJNA928559 | 47706 | 494 | 1.56057 | 7.7092158 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 2.64e-25 | NR | MES1910716.1 | 1215613 | g46144 | i0 | 49.6 | 0.759109311740891 | 125 | 57 | 72.3 | 1 | 3 | 359 | 587 | 711 | MES1910716.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 375 | 112 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28667137 | 28667137 | PRJNA928559_P_NODE_107667_length_344_cov_1.000000_g106098_i0 | PRJNA928559 | 107667 | 344 | 1 | 3.44 | Cercomonas sp. ATCC 5 | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 1.46e-39 | NR | AAM45153.1 | 45113 | g106098 | i0 | 74.7 | 0.793604651162791 | 91 | 23 | 79.4 | 0 | 342 | 70 | 418 | 508 | AAM45153.1 RNA polymerase II largest subunit, partial [Cercomonas sp. ATCC 50319] | diamond | 273 | 150 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50319 | |||
| 29298617 | 29298617 | PRJNA928559_P_NODE_87389_length_380_cov_2.755700_g85820_i0 | PRJNA928559 | 87389 | 380 | 2.7557 | 10.47166 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 2.76e-33 | NR | YP_009118062.1 | 372086 | g85820 | i0 | 84.2 | 0.6 | 76 | 12 | 60 | 0 | 66 | 293 | 28 | 103 | YP_009118062.1 NADH dehydrogenase subunit 1 [Paracercomonas marina] | diamond | 228 | 129 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 29645368 | 29645368 | PRJNA928559_P_NODE_132950_length_307_cov_4.623932_g131381_i0 | PRJNA928559 | 132950 | 307 | 4.623932 | 14.19547124 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 8.639999999999999e-23 | NR | AAY21202.1 | 227086 | g131381 | i0 | 55.1 | 2.68729641693811 | 89 | 33 | 87 | 1 | 274 | 8 | 1 | 82 | AAY21202.1 Rpl7A, partial [Bigelowiella natans] | diamond | 825 | 96.7 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 30119480 | 30119480 | PRJNA928559_P_NODE_212012_length_243_cov_0.917647_g210443_i0 | PRJNA928559 | 212012 | 243 | 0.917647 | 2.22988221 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 6.34e-7 | NR | MES1910277.1 | 1215613 | g210443 | i0 | 55.3 | 0.580246913580247 | 47 | 21 | 58 | 0 | 146 | 6 | 4 | 50 | MES1910277.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 141 | 56.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31510284 | 31510284 | PRJNA928559_P_NODE_166096_length_271_cov_4.808081_g164527_i0 | PRJNA928559 | 166096 | 271 | 4.808081 | 13.02989951 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 7.4e-13 | NR | YP_009118060.1 | 372086 | g164527 | i0 | 54 | 0.697416974169742 | 63 | 28 | 69.7 | 1 | 235 | 47 | 10 | 71 | YP_009118060.1 cytochrome c oxidase subunit 3 [Paracercomonas marina] | diamond | 189 | 72.8 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 31794557 | 31794557 | PRJNA928559_P_NODE_127577_length_314_cov_3.796680_g126008_i0 | PRJNA928559 | 127577 | 314 | 3.79668 | 11.9215752 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 5.49e-6 | NR | YP_009118054.1 | 372086 | g126008 | i0 | 63.6 | 0.420382165605096 | 44 | 16 | 42 | 0 | 143 | 12 | 557 | 600 | YP_009118054.1 cytochrome c oxidase subunit 1 and subunit 2 fusion protein [Paracercomonas marina] | diamond | 132 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 32016223 | 32016223 | PRJNA928559_P_NODE_185518_length_254_cov_2.662983_g183949_i0 | PRJNA928559 | 185518 | 254 | 2.662983 | 6.76397682 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 1.92e-33 | NR | YP_009118074.1 | 372086 | g183949 | i0 | 83.1 | 0.909448818897638 | 77 | 13 | 90.9 | 0 | 16 | 246 | 221 | 297 | YP_009118074.1 NADH dehydrogenase subunit 5 [Paracercomonas marina] | diamond | 231 | 131 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 32047933 | 32047933 | PRJNA928559_P_NODE_138738_length_300_cov_2.748899_g137169_i0 | PRJNA928559 | 138738 | 300 | 2.748899 | 8.246697 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 4.75e-6 | NR | MES1908431.1 | 1215613 | g137169 | i0 | 42.9 | 0.95 | 56 | 31 | 56 | 1 | 275 | 108 | 928 | 982 | MES1908431.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 285 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32333081 | 32333081 | PRJNA928559_P_NODE_36179_length_551_cov_7.887029_g34629_i0 | PRJNA928559 | 36179 | 551 | 7.887029 | 43.45752979 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 9.68e-54 | NR | MES1911029.1 | 1215613 | g34629 | i0 | 54.6 | 2.02540834845735 | 185 | 78 | 98.5 | 2 | 4 | 546 | 112 | 294 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1116 | 183 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32806056 | 32806056 | PRJNA928559_P_NODE_172620_length_265_cov_4.718750_g171051_i0 | PRJNA928559 | 172620 | 265 | 4.71875 | 12.5046875 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 5.9400000000000005e-33 | NR | YP_009118055.1 | 372086 | g171051 | i0 | 61.4 | 0.99622641509434 | 88 | 34 | 99.6 | 0 | 265 | 2 | 101 | 188 | YP_009118055.1 NADH dehydrogenase subunit 9 [Paracercomonas marina] | diamond | 264 | 123 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina |
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);;