contig_metadata
18 rows where bioproject = "PRJNA667863", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 634136 | 634136 | PRJNA667863_P_NODE_3621_length_331_cov_7.050388_g3587_i0 | PRJNA667863 | 3621 | 331 | 7.050388 | 23.33678428 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 1.22e-120 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g3587 | i0 | 90.937 | 77.1812688821752 | 331 | 30 | 100 | 0 | 1 | 331 | 523 | 193 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 25547 | 446 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 9562524 | 9562524 | PRJNA667863_P_NODE_5948_length_288_cov_2.339535_g5914_i0 | PRJNA667863 | 5948 | 288 | 2.339535 | 6.7378608 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.83e-88 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g5914 | i0 | 87.847 | 95.1597222222222 | 288 | 35 | 100 | 0 | 1 | 288 | 285 | 572 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 27406 | 339 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 10838057 | 10838057 | PRJNA667863_P_NODE_13029_length_248_cov_0.880000_g12995_i0 | PRJNA667863 | 13029 | 248 | 0.88 | 2.1824 | Cercomonas sp. ATCC 5 | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 6.1e-29 | NR | CAE46439.1 | 45112 | g12995 | i0 | 69.1 | 1.95967741935484 | 81 | 25 | 98 | 0 | 247 | 5 | 127 | 207 | CAE46439.1 RNA polymerase II largest subunit, partial [Cercomonas sp. ATCC 50318] | diamond | 486 | 117 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50318 | |||
| 14662953 | 14662953 | PRJNA667863_P_NODE_2092_length_390_cov_5.791798_g2058_i0 | PRJNA667863 | 2092 | 390 | 5.791798 | 22.5880122 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 2.11e-75 | NR | ADK26622.1 | 323453 | g2058 | i0 | 94.1 | 0.915384615384615 | 119 | 7 | 91.5 | 0 | 34 | 390 | 1 | 119 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 357 | 229 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 14662981 | 14662981 | PRJNA667863_P_NODE_3692_length_330_cov_1.311284_g3658_i0 | PRJNA667863 | 3692 | 330 | 1.311284 | 4.3272372 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 4.58e-90 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g3658 | i0 | 85.672 | 63.5727272727273 | 335 | 38 | 100 | 10 | 1 | 330 | 3665 | 3994 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20979 | 344 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17212131 | 17212131 | PRJNA667863_P_NODE_9494_length_260_cov_4.069519_g9460_i0 | PRJNA667863 | 9494 | 260 | 4.069519 | 10.5807494 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 164 | 1.57e-48 | NR | ADK26624.1 | 323453 | g9460 | i0 | 88.4 | 0.992307692307692 | 86 | 10 | 99.2 | 0 | 260 | 3 | 57 | 142 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 258 | 164 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 19015181 | 19015181 | PRJNA667863_P_NODE_3115_length_346_cov_1.575092_g3081_i0 | PRJNA667863 | 3115 | 346 | 1.575092 | 5.44981832 | Thaumatomonas sp. TMT | 45100 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 6.23e-65 | NR | ACF24486.1 | 407209 | g3081 | i0 | 88.6 | 0.988439306358382 | 114 | 13 | 98.8 | 0 | 4 | 345 | 13 | 126 | ACF24486.1 70 kDa heat shock protein, partial [Thaumatomonas sp. TMT002] | diamond | 342 | 209 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 23586597 | 23586597 | PRJNA667863_P_NODE_10299_length_256_cov_1.535519_g10265_i0 | PRJNA667863 | 10299 | 256 | 1.535519 | 3.93092864 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 2.05e-92 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g10265 | i0 | 91.406 | 29.0234375 | 256 | 22 | 100 | 0 | 1 | 256 | 630 | 375 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 7430 | 351 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 23586848 | 23586848 | PRJNA667863_P_NODE_859_length_531_cov_5.058952_g826_i0 | PRJNA667863 | 859 | 531 | 5.058952 | 26.86303512 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 286 | 8.999999999999998e-97 | NR | ADK47156.1 | 323453 | g826 | i0 | 96.6 | 0.819209039548023 | 145 | 5 | 81.9 | 0 | 46 | 480 | 1 | 145 | ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] | diamond | 435 | 286 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 24860210 | 24860210 | PRJNA667863_P_NODE_2120_length_388_cov_8.146032_g2086_i0 | PRJNA667863 | 2120 | 388 | 8.146032 | 31.60660416 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 5.58e-75 | NTclustered | gi|160337323|gb|EF455755.1| | 188939 | g2086 | i0 | 80.84 | 94.1572164948454 | 381 | 67 | 97 | 6 | 1 | 378 | 355 | 732 | Thaumatomonas seravini actin gene, partial cds | blastn | 36533 | 294 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 26891974 | 26891974 | PRJNA667863_P_NODE_3021_length_349_cov_2.170290_g2987_i0 | PRJNA667863 | 3021 | 349 | 2.17029 | 7.5743121 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 4.8899999999999997e-39 | NR | MES1906958.1 | 1215613 | g2987 | i0 | 67.8 | 0.773638968481375 | 90 | 29 | 77.4 | 0 | 272 | 3 | 393 | 482 | MES1906958.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 270 | 148 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26891979 | 26891979 | PRJNA667863_P_NODE_8061_length_270_cov_1.563452_g8027_i0 | PRJNA667863 | 8061 | 270 | 1.563452 | 4.2213204 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.54e-29 | NR | BBE07971.1 | 1928728 | g8027 | i0 | 70.5 | 0.977777777777778 | 88 | 24 | 96.7 | 2 | 1 | 261 | 117 | 203 | BBE07971.1 GTP-binding protein [Paulinella micropora] | diamond | 264 | 114 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 27618806 | 27618806 | PRJNA667863_P_NODE_17304_length_240_cov_2.245509_g17270_i0 | PRJNA667863 | 17304 | 240 | 2.245509 | 5.3892216 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 7.46e-4 | NR | MES1916146.1 | 1215613 | g17270 | i0 | 37.9 | 0.825 | 66 | 39 | 82.5 | 2 | 2 | 199 | 3 | 66 | MES1916146.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 198 | 44.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28976512 | 28976512 | PRJNA667863_P_NODE_9708_length_259_cov_2.419355_g9674_i0 | PRJNA667863 | 9708 | 259 | 2.419355 | 6.26612945 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 6.25e-27 | NR | MES1909879.1 | 1215613 | g9674 | i0 | 63.5 | 0.984555984555985 | 85 | 31 | 98.5 | 0 | 258 | 4 | 121 | 205 | MES1909879.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 255 | 110 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29260332 | 29260332 | PRJNA667863_P_NODE_2109_length_389_cov_3.490506_g2075_i0 | PRJNA667863 | 2109 | 389 | 3.490506 | 13.57806834 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.439999999999999e-23 | NR | MES1912552.1 | 1215613 | g2075 | i0 | 74.6 | 0.455012853470437 | 59 | 15 | 45.5 | 0 | 3 | 179 | 291 | 349 | MES1912552.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 177 | 102 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29670647 | 29670647 | PRJNA667863_P_NODE_6450_length_283_cov_3.066667_g6416_i0 | PRJNA667863 | 6450 | 283 | 3.066667 | 8.67866761 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 3.64e-19 | NR | BBE07976.1 | 1928728 | g6416 | i0 | 47.5 | 0.848056537102474 | 80 | 35 | 77.4 | 1 | 26 | 244 | 5 | 84 | BBE07976.1 LIM and SH3 domain protein [Paulinella micropora] | diamond | 240 | 85.9 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 30523905 | 30523905 | PRJNA667863_P_NODE_11993_length_250_cov_0.870056_g11959_i0 | PRJNA667863 | 11993 | 250 | 0.870056 | 2.17514 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 5.070000000000001e-29 | NR | MES1912265.1 | 1215613 | g11959 | i0 | 65.1 | 2.988 | 83 | 29 | 99.6 | 0 | 2 | 250 | 68 | 150 | MES1912265.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 747 | 116 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32673596 | 32673596 | PRJNA667863_P_NODE_7320_length_275_cov_4.188119_g7286_i0 | PRJNA667863 | 7320 | 275 | 4.188119 | 11.51732725 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 1.15e-5 | NR | MES1916909.1 | 1215613 | g7286 | i0 | 43.8 | 1.27636363636364 | 64 | 31 | 64.4 | 1 | 225 | 49 | 12 | 75 | MES1916909.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 351 | 50.1 | 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);;