contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5964040 | 5964040 | PRJNA884104_S_NODE_4225_length_981_cov_5.561674_g3720_i0 | PRJNA884104 | 4225 | 981 | 5.561674 | 54.56002194 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 373 | 3.22e-126 | NR | MES1911029.1 | 1215613 | g3720 | i0 | 63.6 | 0.932721712538226 | 305 | 107 | 92 | 2 | 973 | 71 | 1 | 305 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 915 | 373 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 7239299 | 7239299 | PRJNA884104_S_NODE_6106_length_822_cov_4.823765_g5500_i0 | PRJNA884104 | 6106 | 822 | 4.823765 | 39.6513483 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 7.17e-91 | NR | MES1912193.1 | 1215613 | g5500 | i0 | 57.7 | 8.72627737226277 | 234 | 99 | 85.4 | 0 | 31 | 732 | 6 | 239 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 7173 | 279 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 9788205 | 9788205 | PRJNA884104_S_NODE_17148_length_486_cov_1.915254_g16409_i0 | PRJNA884104 | 17148 | 486 | 1.915254 | 9.30813444 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 246 | 2.13e-81 | NR | ADK26622.1 | 323453 | g16409 | i0 | 88.5 | 0.802469135802469 | 130 | 15 | 80.2 | 0 | 31 | 420 | 1 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 390 | 246 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 9789257 | 9789257 | PRJNA884104_S_NODE_6968_length_767_cov_16.242075_g6324_i0 | PRJNA884104 | 6968 | 767 | 16.242075 | 124.57671525 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 271 | 5.479999999999998e-88 | NR | MES1912193.1 | 1215613 | g6324 | i0 | 56.8 | 21.0704041720991 | 234 | 101 | 91.5 | 0 | 25 | 726 | 5 | 238 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 16161 | 271 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 13613900 | 13613900 | PRJNA884104_S_NODE_1771_length_1478_cov_16.377224_g1507_i0 | PRJNA884104 | 1771 | 1478 | 16.377224 | 242.05537072 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 1.3399999999999998e-175 | NR | MES1909605.1 | 1215613 | g1507 | i0 | 73.4 | 2.79296346414073 | 334 | 89 | 67.8 | 0 | 2 | 1003 | 100 | 433 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 4128 | 512 | 0.99609375 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 16164357 | 16164357 | PRJNA884104_S_NODE_85613_length_241_cov_0.958333_g84870_i0 | PRJNA884104 | 85613 | 241 | 0.958333 | 2.30958253 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.4e-10 | NR | MES1914669.1 | 1215613 | g84870 | i0 | 54 | 0.784232365145228 | 63 | 28 | 78.4 | 1 | 2 | 190 | 509 | 570 | MES1914669.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 189 | 66.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26683373 | 26683373 | PRJNA884104_S_NODE_35281_length_346_cov_1.223443_g34538_i0 | PRJNA884104 | 35281 | 346 | 1.223443 | 4.23311278 | root | 1 | Root_unresolved | Root_unresolved | 136 | 2.8499999999999995e-35 | NR | MES1916046.1 | 1215613 | g34538 | i0 | 62.2 | 3.88439306358381 | 111 | 42 | 96.2 | 0 | 1 | 333 | 203 | 313 | MES1916046.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1344 | 136 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26706936 | 26706936 | PRJNA884104_S_NODE_37261_length_337_cov_6.363636_g36518_i0 | PRJNA884104 | 37261 | 337 | 6.363636 | 21.44545332 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 7.66e-18 | NR | MES1912234.1 | 1215613 | g36518 | i0 | 54.7 | 1.3353115727003 | 75 | 31 | 66.8 | 2 | 315 | 91 | 49 | 120 | MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 450 | 83.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 26865887 | 26865887 | PRJNA884104_S_NODE_71761_length_249_cov_1.295455_g71018_i0 | PRJNA884104 | 71761 | 249 | 1.295455 | 3.22568295 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.26e-4 | NR | MES1913219.1 | 1215613 | g71018 | i0 | 58.5 | 1.56626506024096 | 65 | 27 | 78.3 | 0 | 35 | 229 | 148 | 212 | MES1913219.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 390 | 48.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27023769 | 27023769 | PRJNA884104_S_NODE_74982_length_247_cov_1.890805_g74239_i0 | PRJNA884104 | 74982 | 247 | 1.890805 | 4.67028835 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 2.7e-18 | NR | MES1912635.1 | 1215613 | g74239 | i0 | 63.1 | 3.14574898785425 | 65 | 23 | 78.9 | 1 | 246 | 52 | 238 | 301 | MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 777 | 87 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27347996 | 27347996 | PRJNA884104_S_NODE_4303_length_974_cov_2.976693_g3794_i0 | PRJNA884104 | 4303 | 974 | 2.976693 | 28.99298982 | root | 1 | Root_unresolved | Root_unresolved | 224 | 1.52e-68 | NR | MES1915483.1 | 1215613 | g3794 | i0 | 48.3 | 8.59650924024641 | 236 | 117 | 72.4 | 2 | 53 | 757 | 2 | 233 | MES1915483.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 8373 | 225 | 0.995555555555556 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27411272 | 27411272 | PRJNA884104_S_NODE_47283_length_304_cov_1.000000_g46540_i0 | PRJNA884104 | 47283 | 304 | 1 | 3.04 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.00233 | NR | MES1914827.1 | 1215613 | g46540 | i0 | 35.9 | 9.22697368421053 | 78 | 39 | 74 | 2 | 303 | 79 | 71 | 140 | MES1914827.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2805 | 47 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27884573 | 27884573 | PRJNA884104_S_NODE_53065_length_287_cov_1.439252_g52322_i0 | PRJNA884104 | 53065 | 287 | 1.439252 | 4.13065324 | root | 1 | Root_unresolved | Root_unresolved | 111 | 2.21e-26 | NR | MES1916046.1 | 1215613 | g52322 | i0 | 59.1 | 7.93379790940767 | 93 | 36 | 97.2 | 1 | 279 | 1 | 252 | 342 | MES1916046.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2277 | 112 | 0.991071428571429 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28476629 | 28476629 | PRJNA884104_S_NODE_46966_length_305_cov_0.978448_g46223_i0 | PRJNA884104 | 46966 | 305 | 0.978448 | 2.9842664 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 9.67e-22 | NR | MES1907088.1 | 1215613 | g46223 | i0 | 47.1 | 1.00327868852459 | 102 | 52 | 98.4 | 1 | 5 | 304 | 26 | 127 | MES1907088.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 306 | 99.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29392348 | 29392348 | PRJNA884104_S_NODE_47849_length_302_cov_1.314410_g47106_i0 | PRJNA884104 | 47849 | 302 | 1.31441 | 3.9695182 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 4.21e-36 | NR | ACF24601.1 | 67809 | g47106 | i0 | 68.6 | 1.8476821192053 | 86 | 27 | 85.4 | 0 | 259 | 2 | 48 | 133 | ACF24601.1 translation initiation factor 1 [Gymnochlora stellata] | diamond | 558 | 129 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 29455000 | 29455000 | PRJNA884104_S_NODE_32830_length_358_cov_0.838596_g32087_i0 | PRJNA884104 | 32830 | 358 | 0.838596 | 3.00217368 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.62e-27 | NR | MES1913088.1 | 1215613 | g32087 | i0 | 57.3 | 0.745810055865922 | 89 | 38 | 74.6 | 0 | 10 | 276 | 66 | 154 | MES1913088.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 267 | 108 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29834290 | 29834290 | PRJNA884104_S_NODE_46011_length_307_cov_2.260684_g45268_i0 | PRJNA884104 | 46011 | 307 | 2.260684 | 6.94029988 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 6.47e-33 | NR | ADK26624.1 | 323453 | g45268 | i0 | 78.7 | 0.732899022801303 | 75 | 16 | 73.3 | 0 | 4 | 228 | 202 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 225 | 125 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 30181701 | 30181701 | PRJNA884104_S_NODE_27692_length_386_cov_4.722045_g26949_i0 | PRJNA884104 | 27692 | 386 | 4.722045 | 18.2270937 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 194 | 2.05e-61 | NR | ADK26622.1 | 323453 | g26949 | i0 | 80.3 | 0.909326424870466 | 117 | 23 | 90.9 | 0 | 352 | 2 | 1 | 117 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 351 | 194 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 30340326 | 30340326 | PRJNA884104_S_NODE_34972_length_347_cov_1.492701_g34229_i0 | PRJNA884104 | 34972 | 347 | 1.492701 | 5.17967247 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 4.13e-18 | NR | MES1906886.1 | 1215613 | g34229 | i0 | 50 | 2.3342939481268 | 90 | 45 | 77.8 | 0 | 345 | 76 | 122 | 211 | MES1906886.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 810 | 86.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30750643 | 30750643 | PRJNA884104_S_NODE_9674_length_649_cov_2.631944_g8967_i0 | PRJNA884104 | 9674 | 649 | 2.631944 | 17.08131656 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 184 | 2.2499999999999995e-55 | NR | AAT09077.1 | 227086 | g8967 | i0 | 62.2 | 0.721109399075501 | 156 | 57 | 72.1 | 1 | 19 | 486 | 1 | 154 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 468 | 184 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 31035190 | 31035190 | PRJNA884104_S_NODE_48075_length_301_cov_1.688596_g47332_i0 | PRJNA884104 | 48075 | 301 | 1.688596 | 5.08267396 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 5.4e-18 | NR | MES1912635.1 | 1215613 | g47332 | i0 | 46.6 | 3.0797342192691 | 103 | 49 | 97.7 | 2 | 1 | 294 | 10 | 111 | MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 927 | 87 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31168965 | 31168965 | PRJNA884104_S_NODE_64215_length_260_cov_1.235294_g63472_i0 | PRJNA884104 | 64215 | 260 | 1.235294 | 3.2117644 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00336 | NR | MES1910030.1 | 1215613 | g63472 | i0 | 51.1 | 1.5 | 45 | 22 | 51.9 | 0 | 10 | 144 | 16 | 60 | MES1910030.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 390 | 45.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31351096 | 31351096 | PRJNA884104_S_NODE_44156_length_313_cov_1.283333_g43413_i0 | PRJNA884104 | 44156 | 313 | 1.283333 | 4.01683229 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 2.04e-6 | NR | MES1911260.1 | 1215613 | g43413 | i0 | 42 | 0.843450479233227 | 88 | 43 | 78.6 | 3 | 281 | 36 | 521 | 606 | MES1911260.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 264 | 55.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31667184 | 31667184 | PRJNA884104_S_NODE_30877_length_367_cov_2.380952_g30134_i0 | PRJNA884104 | 30877 | 367 | 2.380952 | 8.73809384 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 7.67e-18 | NR | MES1913935.1 | 1215613 | g30134 | i0 | 66.7 | 0.613079019073569 | 75 | 25 | 61.3 | 0 | 366 | 142 | 139 | 213 | MES1913935.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 225 | 86.7 | 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);;