contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA666695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13386713 | 13386713 | PRJNA666695_S_NODE_53091_length_287_cov_1.308943_g51997_i0 | PRJNA666695 | 53091 | 287 | 1.308943 | 3.75666641 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 6.18e-17 | NR | MES1912744.1 | 1215613 | g51997 | i0 | 74.2 | 0.64808362369338 | 62 | 16 | 64.8 | 0 | 2 | 187 | 359 | 420 | MES1912744.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 186 | 85.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 15933861 | 15933861 | PRJNA666695_S_NODE_15253_length_460_cov_12.579952_g14162_i0 | PRJNA666695 | 15253 | 460 | 12.579952 | 57.8677792 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.0799999999999999e-32 | NR | MES1911029.1 | 1215613 | g14162 | i0 | 53.7 | 0.873913043478261 | 134 | 56 | 84.8 | 3 | 458 | 69 | 163 | 294 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 402 | 127 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 18482770 | 18482770 | PRJNA666695_S_NODE_12155_length_504_cov_35.930886_g11082_i0 | PRJNA666695 | 12155 | 504 | 35.930886 | 181.09166544 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 5.13e-32 | NR | MES1911029.1 | 1215613 | g11082 | i0 | 53.7 | 0.797619047619048 | 134 | 56 | 77.4 | 3 | 3 | 392 | 163 | 294 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 402 | 126 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 19758201 | 19758201 | PRJNA666695_S_NODE_16836_length_443_cov_12.945274_g15745_i0 | PRJNA666695 | 16836 | 443 | 12.945274 | 57.34756382 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 3.39e-44 | NR | ADK26622.1 | 323453 | g15745 | i0 | 82.4 | 0.575620767494357 | 85 | 13 | 56.2 | 1 | 426 | 178 | 46 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 255 | 151 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 21564968 | 21564968 | PRJNA666695_S_NODE_30517_length_354_cov_4.629393_g29423_i0 | PRJNA666695 | 30517 | 354 | 4.629393 | 16.38805122 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 4.72e-27 | NR | MES1908053.1 | 1215613 | g29423 | i0 | 58.2 | 0.771186440677966 | 91 | 35 | 77.1 | 2 | 4 | 276 | 261 | 348 | MES1908053.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 273 | 112 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 22307280 | 22307280 | PRJNA666695_S_NODE_102558_length_217_cov_1.965909_g101464_i0 | PRJNA666695 | 102558 | 217 | 1.965909 | 4.26602253 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 1.03e-17 | NR | MES1915545.1 | 1215613 | g101464 | i0 | 67.8 | 4.06451612903226 | 59 | 19 | 81.6 | 0 | 2 | 178 | 184 | 242 | MES1915545.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 882 | 84.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26765056 | 26765056 | PRJNA666695_S_NODE_53921_length_285_cov_2.073770_g52827_i0 | PRJNA666695 | 53921 | 285 | 2.07377 | 5.9102445 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 9.77e-15 | NR | MES1912384.1 | 1215613 | g52827 | i0 | 51.5 | 0.694736842105263 | 66 | 31 | 68.4 | 1 | 1 | 195 | 241 | 306 | MES1912384.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 198 | 78.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26765064 | 26765064 | PRJNA666695_S_NODE_63061_length_268_cov_1.823789_g61967_i0 | PRJNA666695 | 63061 | 268 | 1.823789 | 4.88775452 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 9.17e-21 | NR | MES1908186.1 | 1215613 | g61967 | i0 | 50.6 | 0.996268656716418 | 89 | 44 | 99.6 | 0 | 2 | 268 | 207 | 295 | MES1908186.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 267 | 95.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27061966 | 27061966 | PRJNA666695_S_NODE_157882_length_172_cov_2.106870_g156788_i0 | PRJNA666695 | 157882 | 172 | 2.10687 | 3.6238164 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 3.26e-4 | NR | MES1916699.1 | 1215613 | g156788 | i0 | 38.8 | 2.31976744186047 | 49 | 28 | 85.5 | 1 | 22 | 168 | 177 | 223 | MES1916699.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 399 | 47.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27271208 | 27271208 | PRJNA666695_S_NODE_94483_length_225_cov_5.663043_g93389_i0 | PRJNA666695 | 94483 | 225 | 5.663043 | 12.74184675 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 9.26e-12 | NR | MES1906893.1 | 1215613 | g93389 | i0 | 65.4 | 0.693333333333333 | 52 | 18 | 69.3 | 0 | 225 | 70 | 431 | 482 | MES1906893.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 156 | 69.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27536054 | 27536054 | PRJNA666695_S_NODE_13223_length_487_cov_29.580717_g12140_i0 | PRJNA666695 | 13223 | 487 | 29.580717 | 144.05809179 | Polycystinea | 65582 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 8.729999999999999e-28 | NR | ADK26624.1 | 323453 | g12140 | i0 | 73.4 | 0.973305954825462 | 79 | 21 | 48.7 | 0 | 1 | 237 | 198 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 474 | 115 | 0.991304347826087 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 27745143 | 27745143 | PRJNA666695_S_NODE_141004_length_184_cov_1.608392_g139910_i0 | PRJNA666695 | 141004 | 184 | 1.608392 | 2.95944128 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1e-11 | NR | MES1910123.1 | 1215613 | g139910 | i0 | 52.5 | 4.97282608695652 | 61 | 29 | 99.5 | 0 | 1 | 183 | 3467 | 3527 | MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 915 | 68.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28123870 | 28123870 | PRJNA666695_S_NODE_73045_length_252_cov_2.616114_g71951_i0 | PRJNA666695 | 73045 | 252 | 2.616114 | 6.59260728 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 8.07e-26 | NR | MES1909176.1 | 1215613 | g71951 | i0 | 58.5 | 10.8571428571429 | 82 | 34 | 97.6 | 0 | 251 | 6 | 198 | 279 | MES1909176.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2736 | 110 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28609527 | 28609527 | PRJNA666695_S_NODE_85987_length_235_cov_2.845361_g84893_i0 | PRJNA666695 | 85987 | 235 | 2.845361 | 6.68659835 | root | 1 | Root_unresolved | Root_unresolved | 64.3 | 2.33e-11 | NR | MES1916862.1 | 1215613 | g84893 | i0 | 50 | 1.71063829787234 | 66 | 32 | 84.3 | 1 | 2 | 199 | 17 | 81 | MES1916862.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 402 | 64.7 | 0.993817619783617 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29670586 | 29670586 | PRJNA666695_S_NODE_47950_length_298_cov_4.023346_g46856_i0 | PRJNA666695 | 47950 | 298 | 4.023346 | 11.98957108 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 2.38e-15 | NR | MES1912744.1 | 1215613 | g46856 | i0 | 72.6 | 3.04026845637584 | 62 | 17 | 62.4 | 0 | 1 | 186 | 357 | 418 | MES1912744.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 906 | 80.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29892177 | 29892177 | PRJNA666695_S_NODE_37091_length_329_cov_3.458333_g35997_i0 | PRJNA666695 | 37091 | 329 | 3.458333 | 11.37791557 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 7.1e-13 | NR | MES1915609.1 | 1215613 | g35997 | i0 | 45.5 | 0.802431610942249 | 88 | 42 | 74.8 | 1 | 3 | 248 | 95 | 182 | MES1915609.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 264 | 72 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30207652 | 30207652 | PRJNA666695_S_NODE_71652_length_254_cov_3.014085_g70558_i0 | PRJNA666695 | 71652 | 254 | 3.014085 | 7.6557759 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 8.74e-5 | NR | AAT09059.1 | 227086 | g70558 | i0 | 71.4 | 0.413385826771654 | 35 | 10 | 41.3 | 0 | 1 | 105 | 210 | 244 | AAT09059.1 translation initiation factor 6 [Bigelowiella natans] | diamond | 105 | 50.1 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 30239507 | 30239507 | PRJNA666695_S_NODE_178612_length_159_cov_2.728814_g177518_i0 | PRJNA666695 | 178612 | 159 | 2.728814 | 4.33881426 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00168 | NR | MES1912234.1 | 1215613 | g177518 | i0 | 45.1 | 1.92452830188679 | 51 | 23 | 94.3 | 2 | 5 | 154 | 65 | 111 | MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 306 | 43.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30315285 | 30315285 | PRJNA666695_S_NODE_55432_length_282_cov_2.161826_g54338_i0 | PRJNA666695 | 55432 | 282 | 2.161826 | 6.09634932 | Chrysophaeum | 2483199 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 1.5e-10 | NR | MES1912974.1 | 1215613 | g54338 | i0 | 44.2 | 1.54255319148936 | 77 | 37 | 81.9 | 2 | 38 | 268 | 23 | 93 | MES1912974.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 435 | 65.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30366292 | 30366292 | PRJNA666695_S_NODE_39992_length_320_cov_2.756272_g38898_i0 | PRJNA666695 | 39992 | 320 | 2.756272 | 8.8200704 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 4.99e-10 | NR | MES1912100.1 | 1215613 | g38898 | i0 | 40.3 | 0.721875 | 77 | 46 | 72.2 | 0 | 3 | 233 | 444 | 520 | MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 231 | 66.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31092564 | 31092564 | PRJNA666695_S_NODE_160215_length_171_cov_1.061538_g159121_i0 | PRJNA666695 | 160215 | 171 | 1.061538 | 1.81522998 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 6.52e-6 | NR | MES1908801.1 | 1215613 | g159121 | i0 | 46.9 | 0.859649122807018 | 49 | 25 | 86 | 1 | 164 | 18 | 102 | 149 | MES1908801.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 147 | 51.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31092572 | 31092572 | PRJNA666695_S_NODE_172775_length_163_cov_1.508197_g171681_i0 | PRJNA666695 | 172775 | 163 | 1.508197 | 2.45836111 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 5.74e-5 | NR | MES1907854.1 | 1215613 | g171681 | i0 | 69.2 | 5.5398773006135 | 26 | 8 | 47.9 | 0 | 161 | 84 | 282 | 307 | MES1907854.1 serine threonine-protein phosphatase [Cercozoa sp. M6MM] | diamond | 903 | 49.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31282175 | 31282175 | PRJNA666695_S_NODE_90735_length_230_cov_1.460317_g89641_i0 | PRJNA666695 | 90735 | 230 | 1.460317 | 3.3587291 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 7.93e-19 | NR | MES1908053.1 | 1215613 | g89641 | i0 | 58.3 | 0.939130434782609 | 72 | 27 | 93.9 | 2 | 216 | 1 | 276 | 344 | MES1908053.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 216 | 89 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31377276 | 31377276 | PRJNA666695_S_NODE_36816_length_330_cov_3.024221_g35722_i0 | PRJNA666695 | 36816 | 330 | 3.024221 | 9.9799293 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 4.05e-17 | NR | MES1912234.1 | 1215613 | g35722 | i0 | 42.4 | 1.58181818181818 | 92 | 50 | 81.8 | 3 | 22 | 291 | 28 | 118 | MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 522 | 81.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31535448 | 31535448 | PRJNA666695_S_NODE_156676_length_173_cov_1.704545_g155582_i0 | PRJNA666695 | 156676 | 173 | 1.704545 | 2.94886285 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 8.52e-19 | NR | MES1912552.1 | 1215613 | g155582 | i0 | 88.9 | 0.780346820809249 | 45 | 5 | 78 | 0 | 137 | 3 | 47 | 91 | MES1912552.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 135 | 87.8 | 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);;