contig_metadata
21 rows where bioproject = "PRJEB75017", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4823609 | 4823609 | PRJEB75017_P_NODE_14324_length_252_cov_0.871508_g14195_i0 | PRJEB75017 | 14324 | 252 | 0.871508 | 2.19620016 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 422 | 1.51e-113 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g14195 | i0 | 96.825 | 88.8174603174603 | 252 | 8 | 100 | 0 | 1 | 252 | 1553 | 1804 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 22382 | 422 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 9923589 | 9923589 | PRJEB75017_P_NODE_13488_length_255_cov_1.368132_g13359_i0 | PRJEB75017 | 13488 | 255 | 1.368132 | 3.4887366 | Bdellovibrio | 958 | Bacteria | Bacteria | 342 | 1.2299999999999997e-89 | NTclustered | gi|2800920897|gb|CP168968.1| | 959 | g13359 | i0 | 93.833 | 81.4980392156863 | 227 | 14 | 89 | 0 | 16 | 242 | 1607718 | 1607492 | Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome | blastn | 20782 | 342 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 20122094 | 20122094 | PRJEB75017_P_NODE_7336_length_330_cov_1.214008_g7207_i0 | PRJEB75017 | 7336 | 330 | 1.214008 | 4.0062264 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 191 | 3.8699999999999996e-60 | NR | MCB0369869.1 | 2053517 | g7207 | i0 | 85.3 | 1.98181818181818 | 109 | 16 | 99.1 | 0 | 328 | 2 | 7 | 115 | MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium] | diamond | 654 | 191 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27192040 | 27192040 | PRJEB75017_P_NODE_12722_length_262_cov_1.640212_g12593_i0 | PRJEB75017 | 12722 | 262 | 1.640212 | 4.29735544 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 131 | 1.12e-37 | NR | MCB0368788.1 | 2053517 | g12593 | i0 | 69 | 0.961832061068702 | 84 | 26 | 96.2 | 0 | 10 | 261 | 1 | 84 | MCB0368788.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 252 | 131 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27445287 | 27445287 | PRJEB75017_P_NODE_2603_length_545_cov_1.332627_g2474_i0 | PRJEB75017 | 2603 | 545 | 1.332627 | 7.26281715 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 92 | 4.7e-18 | NR | MBS1972054.1 | 2053517 | g2474 | i0 | 34.1 | 1.01834862385321 | 185 | 110 | 99.1 | 7 | 5 | 544 | 241 | 418 | MBS1972054.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 555 | 92 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27603052 | 27603052 | PRJEB75017_P_NODE_8704_length_306_cov_1.004292_g8575_i0 | PRJEB75017 | 8704 | 306 | 1.004292 | 3.07313352 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 134 | 5.41e-39 | NR | MCB0368227.1 | 2053517 | g8575 | i0 | 88 | 0.735294117647059 | 75 | 9 | 73.5 | 0 | 27 | 251 | 1 | 75 | MCB0368227.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 225 | 134 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27824049 | 27824049 | PRJEB75017_P_NODE_18104_length_243_cov_0.917647_g17975_i0 | PRJEB75017 | 18104 | 243 | 0.917647 | 2.22988221 | Bdellovibrio sp. KM | 28201 | Bacteria | Bacteria | 64.7 | 6.29e-10 | NR | WP_181604190.1 | 2748865 | g17975 | i0 | 39.8 | 1.02469135802469 | 83 | 46 | 97.5 | 2 | 3 | 239 | 29 | 111 | WP_181604190.1 hypothetical protein [Bdellovibrio sp. KM01] | diamond | 249 | 64.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. KM01 | ||
| 28265729 | 28265729 | PRJEB75017_P_NODE_17686_length_244_cov_0.912281_g17557_i0 | PRJEB75017 | 17686 | 244 | 0.912281 | 2.22596564 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 145 | 9.44e-41 | NR | MCB0369784.1 | 2053517 | g17557 | i0 | 80.2 | 0.995901639344262 | 81 | 16 | 99.6 | 0 | 243 | 1 | 20 | 100 | MCB0369784.1 insulinase family protein [Bdellovibrionales bacterium] | diamond | 243 | 145 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28518594 | 28518594 | PRJEB75017_P_NODE_12767_length_262_cov_1.238095_g12638_i0 | PRJEB75017 | 12767 | 262 | 1.238095 | 3.2438089 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 93.2 | 2.18e-22 | NR | MCB0368049.1 | 2053517 | g12638 | i0 | 71.2 | 0.755725190839695 | 66 | 19 | 75.6 | 0 | 29 | 226 | 42 | 107 | MCB0368049.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 198 | 93.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28708103 | 28708103 | PRJEB75017_P_NODE_14087_length_252_cov_1.659218_g13958_i0 | PRJEB75017 | 14087 | 252 | 1.659218 | 4.18122936 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 61.2 | 2.39e-10 | NR | MCB0370383.1 | 2053517 | g13958 | i0 | 50.8 | 0.702380952380952 | 59 | 28 | 69 | 1 | 177 | 4 | 1 | 59 | MCB0370383.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 177 | 61.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29907972 | 29907972 | PRJEB75017_P_NODE_5471_length_376_cov_1.026403_g5342_i0 | PRJEB75017 | 5471 | 376 | 1.026403 | 3.85927528 | Halobacteriovorax sp. GB3 | 2719615 | Bacteria | Bacteria | 44.7 | 0.0325 | NR | WP_273871301.1 | 2719615 | g5342 | i0 | 39.1 | 0.51063829787234 | 64 | 36 | 51.1 | 2 | 234 | 43 | 174 | 234 | WP_273871301.1 GNAT family N-acetyltransferase [Halobacteriovorax sp. GB3] | diamond | 192 | 44.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. GB3 | ||
| 29970989 | 29970989 | PRJEB75017_P_NODE_9371_length_296_cov_1.399103_g9242_i0 | PRJEB75017 | 9371 | 296 | 1.399103 | 4.14134488 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 153 | 3.63e-44 | NR | MCB0368225.1 | 2053517 | g9242 | i0 | 71.4 | 1.98648648648649 | 98 | 28 | 99.3 | 0 | 295 | 2 | 65 | 162 | MCB0368225.1 HAD family hydrolase [Bdellovibrionales bacterium] | diamond | 588 | 153 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30192059 | 30192059 | PRJEB75017_P_NODE_8532_length_308_cov_2.587234_g8403_i0 | PRJEB75017 | 8532 | 308 | 2.587234 | 7.96868072 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 159 | 2.52e-48 | NR | MCB0371361.1 | 2053517 | g8403 | i0 | 83.1 | 0.866883116883117 | 89 | 15 | 86.7 | 0 | 39 | 305 | 7 | 95 | MCB0371361.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 267 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30413589 | 30413589 | PRJEB75017_P_NODE_12253_length_267_cov_1.206186_g12124_i0 | PRJEB75017 | 12253 | 267 | 1.206186 | 3.22051662 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 164 | 7.87e-50 | NR | MBP9675022.1 | 2081706 | g12124 | i0 | 90.9 | 0.98876404494382 | 88 | 8 | 98.9 | 0 | 2 | 265 | 26 | 113 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 264 | 164 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 30855598 | 30855598 | PRJEB75017_P_NODE_2214_length_586_cov_2.499025_g2086_i0 | PRJEB75017 | 2214 | 586 | 2.499025 | 14.6442865 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 189 | 3.0299999999999997e-56 | NR | MBL7554791.1 | 2026715 | g2086 | i0 | 98.9 | 0.455631399317406 | 89 | 1 | 45.6 | 0 | 3 | 269 | 209 | 297 | MBL7554791.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] | diamond | 267 | 189 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 31013596 | 31013596 | PRJEB75017_P_NODE_7795_length_321_cov_2.201613_g7666_i0 | PRJEB75017 | 7795 | 321 | 2.201613 | 7.06717773 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 188 | 1.4899999999999995e-55 | NR | MCB0368368.1 | 2053517 | g7666 | i0 | 82.1 | 0.990654205607477 | 106 | 19 | 99.1 | 0 | 2 | 319 | 36 | 141 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 318 | 188 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31266509 | 31266509 | PRJEB75017_P_NODE_8435_length_310_cov_1.578059_g8306_i0 | PRJEB75017 | 8435 | 310 | 1.578059 | 4.8919829 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 154 | 1.27e-45 | NR | MCB0370127.1 | 2053517 | g8306 | i0 | 93.7 | 0.764516129032258 | 79 | 5 | 76.5 | 0 | 238 | 2 | 31 | 109 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 237 | 154 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32183912 | 32183912 | PRJEB75017_P_NODE_13098_length_258_cov_2.508108_g12969_i0 | PRJEB75017 | 13098 | 258 | 2.508108 | 6.47091864 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 164 | 1.03e-49 | NR | MCB0369646.1 | 2053517 | g12969 | i0 | 90.7 | 1 | 86 | 8 | 100 | 0 | 258 | 1 | 34 | 119 | MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] | diamond | 258 | 164 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32342274 | 32342274 | PRJEB75017_P_NODE_8699_length_306_cov_1.004292_g8570_i0 | PRJEB75017 | 8699 | 306 | 1.004292 | 3.07313352 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 98.6 | 1.5099999999999998e-23 | NR | MBC7742984.1 | 28201 | g8570 | i0 | 87.7 | 1.67647058823529 | 57 | 7 | 55.9 | 0 | 3 | 173 | 113 | 169 | MBC7742984.1 OmpH family outer membrane protein [Bdellovibrio sp.] | diamond | 513 | 98.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 32626404 | 32626404 | PRJEB75017_P_NODE_2160_length_593_cov_1.915385_g2033_i0 | PRJEB75017 | 2160 | 593 | 1.915385 | 11.35823305 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 56.2 | 1.85e-5 | NR | MCB0368268.1 | 2053517 | g2033 | i0 | 23.9 | 2.0893760539629 | 213 | 112 | 95.6 | 7 | 20 | 586 | 1 | 187 | MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium] | diamond | 1239 | 56.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32720988 | 32720988 | PRJEB75017_P_NODE_11480_length_274_cov_3.114428_g11351_i0 | PRJEB75017 | 11480 | 274 | 3.114428 | 8.53353272 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 145 | 4.839999999999999e-42 | NR | MBP9675022.1 | 2081706 | g11351 | i0 | 87.7 | 0.886861313868613 | 81 | 10 | 88.7 | 0 | 245 | 3 | 6 | 86 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 243 | 145 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae 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);;