contig_metadata
24 rows where bioproject = "PRJNA493632" and tax_phylum = "candidate division WWE3"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1100985 | 1100985 | PRJNA493632_P_NODE_199701_length_345_cov_1.687500_g196266_i0 | PRJNA493632 | 199701 | 345 | 1.6875 | 5.821875 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 212 | 4.2e-61 | NR | MBE7526021.1 | 2053526 | g196266 | i0 | 100 | 0.991304347826087 | 114 | 0 | 99.1 | 0 | 343 | 2 | 2815 | 2928 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 342 | 212 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 13220743 | 13220743 | PRJNA493632_P_NODE_61531_length_555_cov_1.871369_g58230_i0 | PRJNA493632 | 61531 | 555 | 1.871369 | 10.38609795 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 226 | 1.4e-64 | NR | MBE7526021.1 | 2053526 | g58230 | i0 | 98.8 | 0.908108108108108 | 168 | 2 | 90.8 | 0 | 551 | 48 | 2983 | 3150 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 504 | 226 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 15762746 | 15762746 | PRJNA493632_P_NODE_234713_length_323_cov_1.232000_g231277_i0 | PRJNA493632 | 234713 | 323 | 1.232 | 3.97936 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 177 | 9.88e-51 | NR | MBE7524955.1 | 2053526 | g231277 | i0 | 89.7 | 0.993808049535604 | 107 | 11 | 99.4 | 0 | 322 | 2 | 45 | 151 | MBE7524955.1 hypothetical protein [candidate division WWE3 bacterium] | diamond | 321 | 177 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 22136452 | 22136452 | PRJNA493632_P_NODE_23058_length_840_cov_2.095176_g20411_i0 | PRJNA493632 | 23058 | 840 | 2.095176 | 17.5994784 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 529 | 7.839999999999996e-169 | NR | MBE7526021.1 | 2053526 | g20411 | i0 | 100 | 1 | 280 | 0 | 100 | 0 | 840 | 1 | 418 | 697 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 840 | 529 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 22779458 | 22779458 | PRJNA493632_P_NODE_386358_length_275_cov_1.504950_g382919_i0 | PRJNA493632 | 386358 | 275 | 1.50495 | 4.1386125 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 167 | 1.27e-45 | NR | MBE7526021.1 | 2053526 | g382919 | i0 | 100 | 0.992727272727273 | 91 | 0 | 99.3 | 0 | 1 | 273 | 3292 | 3382 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 273 | 167 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 27581950 | 27581950 | PRJNA493632_P_NODE_143424_length_393_cov_1.893750_g140003_i0 | PRJNA493632 | 143424 | 393 | 1.89375 | 7.4424375 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 234 | 1.73e-68 | NR | MBE7526021.1 | 2053526 | g140003 | i0 | 100 | 0.99236641221374 | 130 | 0 | 99.2 | 0 | 2 | 391 | 166 | 295 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 390 | 234 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 27582177 | 27582177 | PRJNA493632_P_NODE_83204_length_490_cov_1.477218_g79826_i0 | PRJNA493632 | 83204 | 490 | 1.477218 | 7.2383682 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 316 | 1.99e-96 | NR | MBE7526021.1 | 2053526 | g79826 | i0 | 100 | 0.997959183673469 | 163 | 0 | 99.8 | 0 | 2 | 490 | 711 | 873 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 489 | 316 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 27645366 | 27645366 | PRJNA493632_P_NODE_153424_length_383_cov_1.622581_g150000_i0 | PRJNA493632 | 153424 | 383 | 1.622581 | 6.21448523 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 172 | 5.389999999999999e-47 | NR | MBE7526021.1 | 2053526 | g150000 | i0 | 99 | 0.767624020887728 | 98 | 1 | 76.8 | 0 | 90 | 383 | 1 | 98 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 294 | 172 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 28024382 | 28024382 | PRJNA493632_P_NODE_8845_length_1240_cov_5.167095_g7204_i0 | PRJNA493632 | 8845 | 1240 | 5.167095 | 64.071978 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 565 | 5.39e-201 | NR | MBE7525021.1 | 2053526 | g7204 | i0 | 99.7 | 0.696774193548387 | 288 | 1 | 69.7 | 0 | 327 | 1190 | 1 | 288 | MBE7525021.1 hypothetical protein [candidate division WWE3 bacterium] | diamond | 864 | 565 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 28181655 | 28181655 | PRJNA493632_P_NODE_137746_length_399_cov_3.024540_g134326_i0 | PRJNA493632 | 137746 | 399 | 3.02454 | 12.0679146 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 243 | 1.1e-71 | NR | MBE7526021.1 | 2053526 | g134326 | i0 | 100 | 0.992481203007519 | 132 | 0 | 99.2 | 0 | 3 | 398 | 1950 | 2081 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 396 | 243 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 28245026 | 28245026 | PRJNA493632_P_NODE_578906_length_246_cov_1.335260_g575465_i0 | PRJNA493632 | 578906 | 246 | 1.33526 | 3.2847396 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 169 | 1.5099999999999998e-47 | NR | MBE7525317.1 | 2053526 | g575465 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 3 | 245 | 62 | 142 | MBE7525317.1 hypothetical protein [candidate division WWE3 bacterium] | diamond | 243 | 169 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 28497804 | 28497804 | PRJNA493632_P_NODE_14467_length_1017_cov_3.864407_g12331_i0 | PRJNA493632 | 14467 | 1017 | 3.864407 | 39.30101919 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 561 | 2.4699999999999995e-200 | NR | MBE7525872.1 | 2053526 | g12331 | i0 | 100 | 0.893805309734513 | 303 | 0 | 89.4 | 0 | 2 | 910 | 1 | 303 | MBE7525872.1 porin family protein [candidate division WWE3 bacterium] | diamond | 909 | 561 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 29413218 | 29413218 | PRJNA493632_P_NODE_159749_length_377_cov_1.519737_g156325_i0 | PRJNA493632 | 159749 | 377 | 1.519737 | 5.72940849 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 235 | 5.53e-69 | NR | MBE7526021.1 | 2053526 | g156325 | i0 | 100 | 0.994694960212202 | 125 | 0 | 99.5 | 0 | 377 | 3 | 3549 | 3673 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 375 | 235 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 29855421 | 29855421 | PRJNA493632_P_NODE_122791_length_418_cov_2.107246_g119378_i0 | PRJNA493632 | 122791 | 418 | 2.107246 | 8.80828828 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 268 | 3.58e-80 | NR | MBE7526021.1 | 2053526 | g119378 | i0 | 99.3 | 0.997607655502392 | 139 | 1 | 99.8 | 0 | 417 | 1 | 1058 | 1196 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 417 | 268 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 30108086 | 30108086 | PRJNA493632_P_NODE_362732_length_280_cov_1.487923_g359293_i0 | PRJNA493632 | 362732 | 280 | 1.487923 | 4.1661844 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 179 | 9.15e-50 | NR | MBE7526021.1 | 2053526 | g359293 | i0 | 100 | 0.996428571428571 | 93 | 0 | 99.6 | 0 | 279 | 1 | 2067 | 2159 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 279 | 179 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 31340520 | 31340520 | PRJNA493632_P_NODE_33536_length_717_cov_3.585404_g30538_i0 | PRJNA493632 | 33536 | 717 | 3.585404 | 25.70734668 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 418 | 1.0299999999999996e-130 | NR | MBE7526021.1 | 2053526 | g30538 | i0 | 100 | 1 | 239 | 0 | 100 | 0 | 1 | 717 | 2154 | 2392 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 717 | 418 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 31593686 | 31593686 | PRJNA493632_P_NODE_119616_length_423_cov_1.025714_g116205_i0 | PRJNA493632 | 119616 | 423 | 1.025714 | 4.33877022 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 253 | 6.62e-75 | NR | MBE7526021.1 | 2053526 | g116205 | i0 | 98.6 | 0.99290780141844 | 140 | 2 | 99.3 | 0 | 421 | 2 | 1205 | 1344 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 420 | 253 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 31656767 | 31656767 | PRJNA493632_P_NODE_69557_length_528_cov_1.690110_g66213_i0 | PRJNA493632 | 69557 | 528 | 1.69011 | 8.9237808 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 283 | 6.770000000000001e-85 | NR | MBE7526021.1 | 2053526 | g66213 | i0 | 100 | 1 | 176 | 0 | 100 | 0 | 1 | 528 | 2640 | 2815 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 528 | 283 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 31814923 | 31814923 | PRJNA493632_P_NODE_28497_length_770_cov_1.915352_g25633_i0 | PRJNA493632 | 28497 | 770 | 1.915352 | 14.7482104 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 467 | 1.75e-147 | NR | MBE7526021.1 | 2053526 | g25633 | i0 | 100 | 0.997402597402597 | 256 | 0 | 99.7 | 0 | 3 | 770 | 1705 | 1960 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 768 | 467 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 32036526 | 32036526 | PRJNA493632_P_NODE_616198_length_244_cov_0.900585_g612757_i0 | PRJNA493632 | 616198 | 244 | 0.900585 | 2.1974274 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 158 | 2.3e-45 | NR | MBE7525389.1 | 2053526 | g612757 | i0 | 100 | 0.983606557377049 | 80 | 0 | 98.4 | 0 | 242 | 3 | 200 | 279 | MBE7525389.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [candidate division WWE3 bacterium] | diamond | 240 | 158 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 32290102 | 32290102 | PRJNA493632_P_NODE_77599_length_504_cov_2.204176_g74232_i0 | PRJNA493632 | 77599 | 504 | 2.204176 | 11.10904704 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 319 | 1.51e-97 | NR | MBE7526021.1 | 2053526 | g74232 | i0 | 99.4 | 1 | 168 | 1 | 100 | 0 | 1 | 504 | 3716 | 3883 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 504 | 319 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 32511344 | 32511344 | PRJNA493632_P_NODE_268719_length_310_cov_0.974684_g265283_i0 | PRJNA493632 | 268719 | 310 | 0.974684 | 3.0215204 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 192 | 2.47e-58 | NR | MBE7525255.1 | 2053526 | g265283 | i0 | 100 | 0.987096774193548 | 102 | 0 | 98.7 | 0 | 3 | 308 | 60 | 161 | MBE7525255.1 hypothetical protein [candidate division WWE3 bacterium] | diamond | 306 | 192 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 32511424 | 32511424 | PRJNA493632_P_NODE_499479_length_252_cov_1.675978_g496040_i0 | PRJNA493632 | 499479 | 252 | 1.675978 | 4.22346456 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 149 | 1.1e-39 | NR | MBE7526021.1 | 2053526 | g496040 | i0 | 98.8 | 1 | 84 | 1 | 100 | 0 | 252 | 1 | 289 | 372 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 252 | 149 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium | ||||||
| 32857682 | 32857682 | PRJNA493632_P_NODE_416060_length_269_cov_1.178571_g412621_i0 | PRJNA493632 | 416060 | 269 | 1.178571 | 3.17035599 | candidate division WWE3 bacterium | 2053526 | Bacteria | Bacteria | 168 | 4.59e-46 | NR | MBE7526021.1 | 2053526 | g412621 | i0 | 100 | 0.992565055762082 | 89 | 0 | 99.3 | 0 | 268 | 2 | 1388 | 1476 | MBE7526021.1 tandem-95 repeat protein [candidate division WWE3 bacterium] | diamond | 267 | 168 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium |
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);;