contig_metadata
8 rows where bioproject = "PRJEB76780" and tax_phylum = "Bdellovibrionota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7791051 | 7791051 | PRJEB76780_P_NODE_5967_length_331_cov_1.112403_g5867_i0 | PRJEB76780 | 5967 | 331 | 1.112403 | 3.68205393 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 155 | 8.629999999999998e-42 | NR | MBD64553.1 | 2026745 | g5867 | i0 | 69.7 | 4.93051359516616 | 109 | 33 | 98.8 | 0 | 2 | 328 | 452 | 560 | MBD64553.1 urocanate hydratase [Halobacteriovoraceae bacterium] | diamond | 1632 | 155 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 27128628 | 27128628 | PRJEB76780_P_NODE_3742_length_422_cov_0.893983_g3642_i0 | PRJEB76780 | 3742 | 422 | 0.893983 | 3.77260826 | Silvanigrellales bacterium | 2767476 | Bacteria | Bacteria | 117 | 3.56e-28 | NR | MCA2961534.1 | 2767476 | g3642 | i0 | 51.7 | 0.853080568720379 | 120 | 50 | 83.2 | 4 | 420 | 70 | 146 | 260 | MCA2961534.1 VCBS repeat-containing protein [Silvanigrellales bacterium] | diamond | 360 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellales bacterium | ||||
| 28360577 | 28360577 | PRJEB76780_P_NODE_1746_length_628_cov_3.018018_g1649_i0 | PRJEB76780 | 1746 | 628 | 3.018018 | 18.95315304 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 94.4 | 2.31e-18 | NR | MFK7827240.1 | 2687297 | g1649 | i0 | 40.4 | 1.39490445859873 | 136 | 73 | 64 | 4 | 30 | 431 | 510 | 639 | MFK7827240.1 hypothetical protein [Oligoflexales bacterium] | diamond | 876 | 94.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 28424008 | 28424008 | PRJEB76780_P_NODE_9566_length_262_cov_2.201058_g9466_i0 | PRJEB76780 | 9566 | 262 | 2.201058 | 5.76677196 | Bdellovibrionales bacterium RBG_16_4 | 2053517 | Bacteria | Bacteria | 124 | 1.2e-31 | NR | OFZ10838.1 | 1797388 | g9466 | i0 | 75.6 | 0.984732824427481 | 86 | 21 | 98.5 | 0 | 260 | 3 | 5 | 90 | OFZ10838.1 MAG: hypothetical protein A2Z20_03765 [Bdellovibrionales bacterium RBG_16_40_8] | diamond | 258 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RBG_16_40_8 | ||||
| 28455624 | 28455624 | PRJEB76780_P_NODE_5146_length_357_cov_1.876761_g5046_i0 | PRJEB76780 | 5146 | 357 | 1.876761 | 6.70003677 | Bdellovibrio sp. CG22_combo_CG1 | 28201 | Bacteria | Bacteria | 61.6 | 3.44e-8 | NR | PIP93190.1 | 1975529 | g5046 | i0 | 35.8 | 2.00840336134454 | 123 | 63 | 98.3 | 4 | 355 | 5 | 868 | 980 | PIP93190.1 MAG: hypothetical protein COW78_16385 [Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27] | diamond | 717 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. CG22_combo_CG10-13_8_21_14_all_39_27 | ||
| 29654835 | 29654835 | PRJEB76780_P_NODE_11210_length_250_cov_0.881356_g11110_i0 | PRJEB76780 | 11210 | 250 | 0.881356 | 2.20339 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 152 | 8.86e-41 | NR | WP_321393864.1 | 28202 | g11110 | i0 | 96.3 | 0.984 | 82 | 3 | 98.4 | 0 | 3 | 248 | 440 | 521 | WP_321393864.1 ATP-dependent Clp protease ATP-binding subunit ClpA [Peredibacter starrii] | diamond | 246 | 152 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 31234744 | 31234744 | PRJEB76780_P_NODE_315_length_1351_cov_1.449922_g270_i0 | PRJEB76780 | 315 | 1351 | 1.449922 | 19.58844622 | Oligoflexales bacterium | 2687297 | Bacteria | Bacteria | 131 | 1.13e-28 | NR | MFK7827240.1 | 2687297 | g270 | i0 | 36 | 0.506291635825315 | 228 | 119 | 48.4 | 8 | 1080 | 427 | 723 | 933 | MFK7827240.1 hypothetical protein [Oligoflexales bacterium] | diamond | 684 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexales bacterium | ||||
| 31923428 | 31923428 | PRJEB76780_P_NODE_9377_length_265_cov_1.625000_g9277_i0 | PRJEB76780 | 9377 | 265 | 1.625 | 4.30625 | Micavibrio | 213485 | Bacteria | Bacteria | 61.2 | 9.06e-9 | NR | PZP56489.1 | 349221 | g9277 | i0 | 70.7 | 0.950943396226415 | 41 | 12 | 46.4 | 0 | 252 | 130 | 211 | 251 | PZP56489.1 MAG: hypothetical protein DI586_03610 [Micavibrio aeruginosavorus] | diamond | 252 | 61.6 | 0.993506493506494 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus |
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);;