contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2128404 | 2128404 | PRJNA876641_P_NODE_1302_length_582_cov_1.622790_g1229_i0 | PRJNA876641 | 1302 | 582 | 1.62279 | 9.4446378 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 1.83e-65 | NR | MES1912193.1 | 1215613 | g1229 | i0 | 58.9 | 3.60824742268041 | 175 | 72 | 90.2 | 0 | 525 | 1 | 31 | 205 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 2100 | 211 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 9781034 | 9781034 | PRJNA876641_P_NODE_1788_length_514_cov_1.882086_g1714_i0 | PRJNA876641 | 1788 | 514 | 1.882086 | 9.67392204 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 6.41e-82 | NR | MES1911029.1 | 1215613 | g1714 | i0 | 75 | 8.91828793774319 | 168 | 42 | 98.1 | 0 | 506 | 3 | 1 | 168 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 4584 | 254 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 13992331 | 13992331 | PRJNA876641_P_NODE_12231_length_269_cov_1.571429_g12157_i0 | PRJNA876641 | 12231 | 269 | 1.571429 | 4.22714401 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 4.95e-7 | NR | MES1912041.1 | 1215613 | g12157 | i0 | 44.3 | 2.25278810408922 | 70 | 36 | 78.1 | 1 | 214 | 5 | 143 | 209 | MES1912041.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 606 | 57 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27244849 | 27244849 | PRJNA876641_P_NODE_22763_length_242_cov_0.911243_g22689_i0 | PRJNA876641 | 22763 | 242 | 0.911243 | 2.20520806 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 1.29e-13 | NR | MES1916397.1 | 1215613 | g22689 | i0 | 70.3 | 0.793388429752066 | 64 | 17 | 79.3 | 1 | 51 | 242 | 316 | 377 | MES1916397.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 192 | 75.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27750447 | 27750447 | PRJNA876641_P_NODE_15424_length_252_cov_1.357542_g15350_i0 | PRJNA876641 | 15424 | 252 | 1.357542 | 3.42100584 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 5.48e-24 | NR | MES1912414.1 | 1215613 | g15350 | i0 | 57.6 | 2 | 85 | 34 | 98.8 | 1 | 250 | 2 | 76 | 160 | MES1912414.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 504 | 101 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27971193 | 27971193 | PRJNA876641_P_NODE_13785_length_261_cov_1.127660_g13711_i0 | PRJNA876641 | 13785 | 261 | 1.12766 | 2.9431926 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 2.01e-39 | NR | BAJ14652.1 | 717846 | g13711 | i0 | 78.2 | 1 | 87 | 19 | 100 | 0 | 1 | 261 | 250 | 336 | BAJ14652.1 elongation factor like, partial [Thaumatomastix sp. NIES-2378] | diamond | 261 | 144 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 | ||
| 27971210 | 27971210 | PRJNA876641_P_NODE_2685_length_439_cov_1.262295_g2611_i0 | PRJNA876641 | 2685 | 439 | 1.262295 | 5.54147505 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.35e-9 | NR | MES1910790.1 | 1215613 | g2611 | i0 | 46.8 | 1.6879271070615 | 79 | 34 | 54 | 2 | 10 | 246 | 80 | 150 | MES1910790.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 741 | 66.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28729084 | 28729084 | PRJNA876641_P_NODE_5007_length_352_cov_0.949821_g4933_i0 | PRJNA876641 | 5007 | 352 | 0.949821 | 3.34336992 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 4.8999999999999995e-49 | NR | ADK26624.1 | 323453 | g4933 | i0 | 70.1 | 0.997159090909091 | 117 | 35 | 99.7 | 0 | 351 | 1 | 154 | 270 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 351 | 167 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 28981817 | 28981817 | PRJNA876641_P_NODE_11608_length_273_cov_1.350000_g11534_i0 | PRJNA876641 | 11608 | 273 | 1.35 | 3.6855 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 3.12e-17 | NR | MES1908571.1 | 1215613 | g11534 | i0 | 55.8 | 0.945054945054945 | 86 | 37 | 94.5 | 1 | 4 | 261 | 64 | 148 | MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 258 | 83.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29494840 | 29494840 | PRJNA876641_P_NODE_16090_length_251_cov_0.865169_g16016_i0 | PRJNA876641 | 16090 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.65e-5 | NR | MES1907382.1 | 1215613 | g16016 | i0 | 43.6 | 1.70916334661355 | 55 | 31 | 65.7 | 0 | 5 | 169 | 431 | 485 | MES1907382.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 429 | 51.2 | 0.9921875 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31477502 | 31477502 | PRJNA876641_P_NODE_7356_length_308_cov_1.310638_g7282_i0 | PRJNA876641 | 7356 | 308 | 1.310638 | 4.03676504 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 3.22e-6 | NR | MES1913617.1 | 1215613 | g7282 | i0 | 40 | 0.681818181818182 | 70 | 31 | 63.3 | 2 | 68 | 262 | 111 | 174 | MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 210 | 53.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31920207 | 31920207 | PRJNA876641_P_NODE_6037_length_329_cov_1.503906_g5963_i0 | PRJNA876641 | 6037 | 329 | 1.503906 | 4.94785074 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.9e-43 | NR | ADK26624.1 | 323453 | g5963 | i0 | 67.9 | 0.993920972644377 | 109 | 35 | 99.4 | 0 | 1 | 327 | 86 | 194 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 327 | 152 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 |
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);;