contig_metadata
19 rows where bioproject = "PRJNA753704", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5834741 | 5834741 | PRJNA753704_P_NODE_29985_length_229_cov_2.141026_g29624_i0 | PRJNA753704 | 29985 | 229 | 2.141026 | 4.90294954 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 254 | 5.22e-63 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g29624 | i0 | 88.208 | 107.423580786026 | 212 | 25 | 93 | 0 | 18 | 229 | 512268 | 512479 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 24600 | 254 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 9659452 | 9659452 | PRJNA753704_P_NODE_12828_length_332_cov_1.992278_g12467_i0 | PRJNA753704 | 12828 | 332 | 1.992278 | 6.61436296 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 326 | 1.67e-84 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g12467 | i0 | 84.478 | 152.668674698795 | 335 | 46 | 99 | 6 | 1 | 331 | 510700 | 511032 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 50686 | 326 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 9659474 | 9659474 | PRJNA753704_P_NODE_14188_length_317_cov_1.897541_g13827_i0 | PRJNA753704 | 14188 | 317 | 1.897541 | 6.01520497 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 267 | 9.74e-67 | NTclustered | gi|578016248|gb|CP002190.1| | 765869 | g13827 | i0 | 83.391 | 9.85488958990536 | 289 | 47 | 91 | 1 | 20 | 307 | 2300060 | 2299772 | Bdellovibrio bacteriovorus W, complete genome | blastn | 3124 | 267 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 10130648 | 10130648 | PRJNA753704_P_NODE_14228_length_316_cov_11.382716_g13867_i0 | PRJNA753704 | 14228 | 316 | 11.382716 | 35.96938256 | Bdellovibrio | 958 | Bacteria | Bacteria | 435 | 2.5100000000000003e-117 | NTclustered | gi|2800924434|gb|CP168967.1| | 959 | g13867 | i0 | 91.772 | 44.7310126582278 | 316 | 21 | 99 | 5 | 3 | 316 | 3504404 | 3504716 | Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome | blastn | 14135 | 435 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 12681792 | 12681792 | PRJNA753704_P_NODE_7450_length_426_cov_3.390935_g7089_i0 | PRJNA753704 | 7450 | 426 | 3.390935 | 14.4453831 | Bdellovibrio | 958 | Bacteria | Bacteria | 259 | 2.25e-64 | NTclustered | gi|2801803968|gb|CP169237.1| | 959 | g7089 | i0 | 79.545 | 7.37793427230047 | 396 | 55 | 90 | 23 | 13 | 395 | 1189662 | 1189280 | Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome | blastn | 3143 | 259 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 15230551 | 15230551 | PRJNA753704_P_NODE_17792_length_286_cov_2.164319_g17431_i0 | PRJNA753704 | 17792 | 286 | 2.164319 | 6.18995234 | Bdellovibrio | 958 | Bacteria | Bacteria | 239 | 1.89e-58 | NTclustered | gi|2801803968|gb|CP169237.1| | 959 | g17431 | i0 | 89.84 | 20.0174825174825 | 187 | 18 | 65 | 1 | 84 | 269 | 3754561 | 3754747 | Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome | blastn | 5725 | 239 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 18583043 | 18583043 | PRJNA753704_P_NODE_6235_length_460_cov_7.400517_g5874_i0 | PRJNA753704 | 6235 | 460 | 7.400517 | 34.0423782 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 217 | 1.5e-51 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g5874 | i0 | 75.862 | 138.845652173913 | 493 | 81 | 100 | 19 | 1 | 460 | 1676368 | 1676855 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 63869 | 217 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 19857987 | 19857987 | PRJNA753704_P_NODE_14316_length_316_cov_1.283951_g13955_i0 | PRJNA753704 | 14316 | 316 | 1.283951 | 4.05728516 | Bdellovibrio | 958 | Bacteria | Bacteria | 174 | 3.95e-50 | NR | WP_340597006.1 | 3136282 | g13955 | i0 | 81.6 | 5.88607594936709 | 103 | 19 | 97.8 | 0 | 311 | 3 | 336 | 438 | WP_340597006.1 MFS transporter [Bdellovibrio sp. GT3] | diamond | 1860 | 174 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. GT3 | ||
| 26863404 | 26863404 | PRJNA753704_P_NODE_2281_length_724_cov_3.503840_g1946_i0 | PRJNA753704 | 2281 | 724 | 3.50384 | 25.3678016 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 319 | 8.71e-108 | NR | MBX9767865.1 | 2053517 | g1946 | i0 | 89.6 | 0.716850828729282 | 173 | 18 | 71.7 | 0 | 206 | 724 | 1 | 173 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 519 | 319 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27031084 | 27031084 | PRJNA753704_P_NODE_27842_length_243_cov_0.917647_g27481_i0 | PRJNA753704 | 27842 | 243 | 0.917647 | 2.22988221 | Bdellovibrio | 958 | Bacteria | Bacteria | 102 | 3.6899999999999996e-23 | NR | WP_284608231.1 | 3044166 | g27481 | i0 | 69.6 | 1.7037037037037 | 69 | 21 | 85.2 | 0 | 9 | 215 | 876 | 944 | WP_284608231.1 hypothetical protein [Bdellovibrio sp. 22V] | diamond | 414 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. 22V | ||
| 27084566 | 27084566 | PRJNA753704_P_NODE_23802_length_252_cov_1.402235_g23441_i0 | PRJNA753704 | 23802 | 252 | 1.402235 | 3.5336322 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 71.6 | 8.3e-14 | NR | MBX3041714.1 | 2026715 | g23441 | i0 | 91.4 | 0.416666666666667 | 35 | 3 | 41.7 | 0 | 147 | 251 | 1 | 35 | MBX3041714.1 DUF1428 domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 105 | 71.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27811230 | 27811230 | PRJNA753704_P_NODE_15744_length_302_cov_3.820961_g15383_i0 | PRJNA753704 | 15744 | 302 | 3.820961 | 11.53930222 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 78.2 | 2.55e-14 | NR | MFN8944049.1 | 2026715 | g15383 | i0 | 70.2 | 3.47682119205298 | 57 | 17 | 56.6 | 0 | 172 | 2 | 32 | 88 | MFN8944049.1 F0F1 ATP synthase subunit alpha [Pseudobdellovibrionaceae bacterium] | diamond | 1050 | 78.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27915470 | 27915470 | PRJNA753704_P_NODE_23505_length_253_cov_0.866667_g23144_i0 | PRJNA753704 | 23505 | 253 | 0.866667 | 2.19266751 | Bdellovibrio | 958 | Bacteria | Bacteria | 122 | 2.48e-32 | NR | WP_063244176.1 | 959 | g23144 | i0 | 68.6 | 10.1857707509881 | 86 | 25 | 99.6 | 1 | 253 | 2 | 175 | 260 | WP_063244176.1 GYF domain-containing protein [Bdellovibrio bacteriovorus] | diamond | 2577 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 28284426 | 28284426 | PRJNA753704_P_NODE_12586_length_335_cov_1.507634_g12225_i0 | PRJNA753704 | 12586 | 335 | 1.507634 | 5.0505739 | Pigmentibacter ruber | 2683196 | Bacteria | Bacteria | 70.1 | 2.46e-11 | NR | WP_158999410.1 | 2683196 | g12225 | i0 | 40.8 | 0.877611940298507 | 98 | 51 | 85.1 | 3 | 12 | 296 | 114 | 207 | WP_158999410.1 YcaO-like family protein [Pigmentibacter ruber] | diamond | 294 | 70.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Pigmentibacter | Pigmentibacter ruber | ||
| 28632183 | 28632183 | PRJNA753704_P_NODE_9487_length_381_cov_1.772727_g9126_i0 | PRJNA753704 | 9487 | 381 | 1.772727 | 6.75408987 | Bdellovibrio sp. NC | 28201 | Bacteria | Bacteria | 87.8 | 2.98e-18 | NR | WP_246845436.1 | 2220073 | g9126 | i0 | 44 | 0.78740157480315 | 100 | 55 | 78 | 1 | 377 | 81 | 90 | 189 | WP_246845436.1 substrate-binding periplasmic protein [Bdellovibrio sp. NC01] | diamond | 300 | 87.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 29389878 | 29389878 | PRJNA753704_P_NODE_23449_length_253_cov_0.866667_g23088_i0 | PRJNA753704 | 23449 | 253 | 0.866667 | 2.19266751 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 153 | 9.559999999999998e-42 | NR | MBK9323180.1 | 2026715 | g23088 | i0 | 94 | 12.9486166007905 | 84 | 5 | 99.6 | 0 | 252 | 1 | 464 | 547 | MBK9323180.1 flagellar M-ring protein FliF [Pseudobdellovibrionaceae bacterium] | diamond | 3276 | 153 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30432456 | 30432456 | PRJNA753704_P_NODE_20073_length_271_cov_2.484848_g19712_i0 | PRJNA753704 | 20073 | 271 | 2.484848 | 6.73393808 | Pseudobdellovibrio sp. | 2862747 | Bacteria | Bacteria | 169 | 3.3999999999999997e-48 | NR | MFN3698126.1 | 2862747 | g19712 | i0 | 92.2 | 0.996309963099631 | 90 | 7 | 99.6 | 0 | 270 | 1 | 160 | 249 | MFN3698126.1 chemotaxis protein CheW [Pseudobdellovibrio sp.] | diamond | 270 | 169 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. | ||
| 31136692 | 31136692 | PRJNA753704_P_NODE_11915_length_344_cov_1.439114_g11554_i0 | PRJNA753704 | 11915 | 344 | 1.439114 | 4.95055216 | Bdellovibrio | 958 | Bacteria | Bacteria | 89 | 8.27e-19 | NR | WP_415062242.1 | 28201 | g11554 | i0 | 39.5 | 2.98255813953488 | 114 | 69 | 99.4 | 0 | 344 | 3 | 11 | 124 | WP_415062242.1 chemotaxis protein CheW [Bdellovibrio sp.] | diamond | 1026 | 89.7 | 0.992196209587514 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 32180933 | 32180933 | PRJNA753704_P_NODE_24038_length_252_cov_0.871508_g23677_i0 | PRJNA753704 | 24038 | 252 | 0.871508 | 2.19620016 | Bdellovibrio | 958 | Bacteria | Bacteria | 104 | 5.67e-24 | NR | MFM6928398.1 | 28201 | g23677 | i0 | 61.4 | 3.95238095238095 | 83 | 32 | 98.8 | 0 | 4 | 252 | 381 | 463 | MFM6928398.1 RIP metalloprotease RseP [Bdellovibrio sp.] | diamond | 996 | 105 | 0.990476190476191 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. |
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);;