contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;