contig_metadata
15 rows where bioproject = "PRJNA437204", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8085173 | 8085173 | PRJNA437204_P_NODE_123747_length_242_cov_0.911243_g123448_i0 | PRJNA437204 | 123747 | 242 | 0.911243 | 2.20520806 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|578016248|gb|CP002190.1| | 765869 | g123448 | i0 | 92.308 | 0.557851239669422 | 39 | 1 | 16 | 2 | 4 | 41 | 2960384 | 2960421 | Bdellovibrio bacteriovorus W, complete genome | blastn | 135 | 54.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 8742763 | 8742763 | PRJNA437204_P_NODE_42847_length_317_cov_1.262295_g42548_i0 | PRJNA437204 | 42847 | 317 | 1.262295 | 4.00147515 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 107 | 4.410000000000001e-27 | NR | MBP9675022.1 | 2081706 | g42548 | i0 | 80.3 | 3.95583596214511 | 66 | 13 | 62.5 | 0 | 35 | 232 | 61 | 126 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 1254 | 107 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 11912403 | 11912403 | PRJNA437204_P_NODE_96510_length_248_cov_0.880000_g96211_i0 | PRJNA437204 | 96510 | 248 | 0.88 | 2.1824 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 95.5 | 8.489999999999999e-23 | NR | MES2615336.1 | 3034175 | g96211 | i0 | 90.6 | 1.27016129032258 | 53 | 5 | 64.1 | 0 | 6 | 164 | 105 | 157 | MES2615336.1 30S ribosomal protein S7 [Bdellovibrionota bacterium] | diamond | 315 | 95.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 26695916 | 26695916 | PRJNA437204_P_NODE_110881_length_244_cov_1.801170_g110582_i0 | PRJNA437204 | 110881 | 244 | 1.80117 | 4.3948548 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 70.1 | 2.02e-12 | NR | WP_324950130.1 | 1971216 | g110582 | i0 | 59.3 | 0.725409836065574 | 59 | 22 | 71.3 | 2 | 70 | 243 | 47 | 104 | WP_324950130.1 peptidylprolyl isomerase [Oligoflexus sp.] | diamond | 177 | 70.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 27771052 | 27771052 | PRJNA437204_P_NODE_124144_length_242_cov_0.911243_g123845_i0 | PRJNA437204 | 124144 | 242 | 0.911243 | 2.20520806 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 118 | 2.76e-29 | NR | MES2613796.1 | 3034175 | g123845 | i0 | 72.4 | 0.942148760330578 | 76 | 21 | 94.2 | 0 | 237 | 10 | 17 | 92 | MES2613796.1 MFS transporter [Bdellovibrionota bacterium] | diamond | 228 | 118 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 27771054 | 27771054 | PRJNA437204_P_NODE_125644_length_241_cov_0.916667_g125345_i0 | PRJNA437204 | 125644 | 241 | 0.916667 | 2.20916747 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 45.4 | 0.00311 | NR | MDH5581725.1 | 2053517 | g125345 | i0 | 33.3 | 0.933609958506224 | 75 | 49 | 93.4 | 1 | 241 | 17 | 97 | 170 | MDH5581725.1 START domain-containing protein [Bdellovibrionales bacterium] | diamond | 225 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28197566 | 28197566 | PRJNA437204_P_NODE_80946_length_251_cov_0.865169_g80647_i0 | PRJNA437204 | 80946 | 251 | 0.865169 | 2.17157419 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 158 | 2.1699999999999998e-47 | NR | HLW57606.1 | 2081706 | g80647 | i0 | 100 | 2.97609561752988 | 83 | 0 | 99.2 | 0 | 2 | 250 | 39 | 121 | HLW57606.1 type II secretion system F family protein [Bacteriovoracaceae bacterium] | diamond | 747 | 158 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 28749674 | 28749674 | PRJNA437204_P_NODE_86067_length_250_cov_0.870056_g85768_i0 | PRJNA437204 | 86067 | 250 | 0.870056 | 2.17514 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 73.2 | 6.22e-13 | NR | HLW55810.1 | 2081706 | g85768 | i0 | 85 | 0.48 | 40 | 6 | 48 | 0 | 3 | 122 | 338 | 377 | HLW55810.1 type IV pilus twitching motility protein PilT [Bacteriovoracaceae bacterium] | diamond | 120 | 73.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29791403 | 29791403 | PRJNA437204_P_NODE_17631_length_432_cov_1.587744_g17332_i0 | PRJNA437204 | 17631 | 432 | 1.587744 | 6.85905408 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 166 | 1.76e-49 | NR | MBP9675022.1 | 2081706 | g17332 | i0 | 83.8 | 0.6875 | 99 | 16 | 68.8 | 0 | 17 | 313 | 13 | 111 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 297 | 166 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29822924 | 29822924 | PRJNA437204_P_NODE_25871_length_375_cov_1.274834_g25572_i0 | PRJNA437204 | 25871 | 375 | 1.274834 | 4.7806275 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 135 | 8.3e-35 | NR | MCB0370360.1 | 2053517 | g25572 | i0 | 58.2 | 0.976 | 122 | 44 | 94.4 | 3 | 2 | 355 | 190 | 308 | MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium] | diamond | 366 | 135 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29949563 | 29949563 | PRJNA437204_P_NODE_20971_length_404_cov_1.858006_g20672_i0 | PRJNA437204 | 20971 | 404 | 1.858006 | 7.50634424 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 164 | 1.1799999999999999e-48 | NR | MCB0368045.1 | 2053517 | g20672 | i0 | 66.4 | 2.71782178217822 | 122 | 41 | 90.6 | 0 | 404 | 39 | 55 | 176 | MCB0368045.1 EF-hand domain-containing protein [Bdellovibrionales bacterium] | diamond | 1098 | 164 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31909193 | 31909193 | PRJNA437204_P_NODE_123097_length_242_cov_0.911243_g122798_i0 | PRJNA437204 | 123097 | 242 | 0.911243 | 2.20520806 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 106 | 6.62e-27 | NR | MBP9675022.1 | 2081706 | g122798 | i0 | 84.1 | 0.78099173553719 | 63 | 10 | 78.1 | 0 | 28 | 216 | 20 | 82 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 189 | 106 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31972419 | 31972419 | PRJNA437204_P_NODE_106638_length_245_cov_0.982558_g106339_i0 | PRJNA437204 | 106638 | 245 | 0.982558 | 2.4072671 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 65.5 | 3.59e-10 | NR | MCB0371130.1 | 2053517 | g106339 | i0 | 40.7 | 0.991836734693878 | 81 | 47 | 99.2 | 1 | 2 | 244 | 336 | 415 | MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium] | diamond | 243 | 65.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32225719 | 32225719 | PRJNA437204_P_NODE_121478_length_242_cov_0.911243_g121179_i0 | PRJNA437204 | 121478 | 242 | 0.911243 | 2.20520806 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 60.1 | 2.45e-8 | NR | MBX9702590.1 | 2654442 | g121179 | i0 | 40.9 | 0.818181818181818 | 66 | 33 | 74.4 | 1 | 237 | 58 | 259 | 324 | MBX9702590.1 serine/threonine-protein kinase [Silvanigrellaceae bacterium] | diamond | 198 | 60.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 32415594 | 32415594 | PRJNA437204_P_NODE_91439_length_249_cov_0.875000_g91140_i0 | PRJNA437204 | 91439 | 249 | 0.875 | 2.17875 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 113 | 6.640000000000001e-27 | NR | WP_321396741.1 | 28202 | g91140 | i0 | 68.3 | 1.86746987951807 | 82 | 25 | 98.8 | 1 | 248 | 3 | 1037 | 1117 | WP_321396741.1 FHA domain-containing protein [Peredibacter starrii] | diamond | 465 | 113 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii |
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);;