contig_metadata
17 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6062228 | 6062228 | PRJNA980839_P_NODE_225325_length_244_cov_0.900585_g221541_i0 | PRJNA980839 | 225325 | 244 | 0.900585 | 2.1974274 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 134 | 1.75e-34 | NR | HEY8279362.1 | 3034175 | g221541 | i0 | 79 | 2.98770491803279 | 81 | 17 | 99.6 | 0 | 243 | 1 | 307 | 387 | HEY8279362.1 vitamin B12-dependent ribonucleotide reductase [Bdellovibrionota bacterium] | diamond | 729 | 134 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 11474110 | 11474110 | PRJNA980839_P_NODE_247669_length_203_cov_4.238462_g243885_i0 | PRJNA980839 | 247669 | 203 | 4.238462 | 8.60407786 | Halobacteriovorax | 1652133 | Bacteria | Bacteria | 58.4 | 3.8e-4 | NTclustered | gi|1249980216|gb|CP017414.1| | 97084 | g243885 | i0 | 97.059 | 0.660098522167488 | 34 | 1 | 17 | 0 | 134 | 167 | 52430 | 52463 | Halobacteriovorax marinus strain BE01 chromosome, complete genome | blastn | 134 | 58.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 20085649 | 20085649 | PRJNA980839_P_NODE_237976_length_241_cov_0.916667_g234192_i0 | PRJNA980839 | 237976 | 241 | 0.916667 | 2.20916747 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 147 | 1.07e-39 | NR | MBX3020797.1 | 2053517 | g234192 | i0 | 97.5 | 2.98755186721992 | 80 | 2 | 99.6 | 0 | 241 | 2 | 471 | 550 | MBX3020797.1 ABC transporter ATP-binding protein [Bdellovibrionales bacterium] | diamond | 720 | 147 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27221722 | 27221722 | PRJNA980839_P_NODE_177042_length_265_cov_1.333333_g173258_i0 | PRJNA980839 | 177042 | 265 | 1.333333 | 3.53333245 | Bacteria | 2 | Bacteria | Bacteria | 74.7 | 9.56e-14 | NR | HVK60776.1 | 2053517 | g173258 | i0 | 46.5 | 1.94716981132075 | 86 | 46 | 97.4 | 0 | 263 | 6 | 60 | 145 | HVK60776.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 516 | 74.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27632670 | 27632670 | PRJNA980839_P_NODE_237844_length_241_cov_0.916667_g234060_i0 | PRJNA980839 | 237844 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 92 | 1.55e-19 | NR | MBK9324498.1 | 2026715 | g234060 | i0 | 58.8 | 2.95020746887967 | 80 | 32 | 98.3 | 1 | 4 | 240 | 224 | 303 | MBK9324498.1 type IV secretory system conjugative DNA transfer family protein [Pseudobdellovibrionaceae bacterium] | diamond | 711 | 92 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27816207 | 27816207 | PRJNA980839_P_NODE_225344_length_244_cov_0.900585_g221560_i0 | PRJNA980839 | 225344 | 244 | 0.900585 | 2.1974274 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 93.6 | 8.92e-22 | NR | MDZ4084765.1 | 2053517 | g221560 | i0 | 51.7 | 1.06967213114754 | 87 | 33 | 95.9 | 1 | 236 | 3 | 62 | 148 | MDZ4084765.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 261 | 93.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28005654 | 28005654 | PRJNA980839_P_NODE_225345_length_244_cov_0.900585_g221561_i0 | PRJNA980839 | 225345 | 244 | 0.900585 | 2.1974274 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 100 | 1.21e-22 | NR | MCO5144355.1 | 2599941 | g221561 | i0 | 64.8 | 0.872950819672131 | 71 | 25 | 87.3 | 0 | 234 | 22 | 305 | 375 | MCO5144355.1 diaminopimelate decarboxylase [Oligoflexia bacterium] | diamond | 213 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 28321120 | 28321120 | PRJNA980839_P_NODE_221346_length_245_cov_0.895349_g217562_i0 | PRJNA980839 | 221346 | 245 | 0.895349 | 2.19360505 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 102 | 1.1199999999999999e-23 | NR | WP_324950757.1 | 1971216 | g217562 | i0 | 58.8 | 0.979591836734694 | 80 | 33 | 98 | 0 | 244 | 5 | 227 | 306 | WP_324950757.1 FIST N-terminal domain-containing protein [Oligoflexus sp.] | diamond | 240 | 102 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 29053562 | 29053562 | PRJNA980839_P_NODE_235328_length_242_cov_0.911243_g231544_i0 | PRJNA980839 | 235328 | 242 | 0.911243 | 2.20520806 | Micavibrio | 213485 | Bacteria | Bacteria | 101 | 2.13e-23 | NR | MDE1153873.1 | 2024841 | g231544 | i0 | 64.1 | 6.76859504132231 | 78 | 28 | 96.7 | 0 | 8 | 241 | 241 | 318 | MDE1153873.1 ATP-binding protein [Micavibrio sp.] | diamond | 1638 | 102 | 0.990196078431373 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 29931679 | 29931679 | PRJNA980839_P_NODE_186571_length_258_cov_1.567568_g182787_i0 | PRJNA980839 | 186571 | 258 | 1.567568 | 4.04432544 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 74.3 | 2.75e-14 | NR | MBC7385590.1 | 2599941 | g182787 | i0 | 49.3 | 1.75581395348837 | 67 | 34 | 77.9 | 0 | 56 | 256 | 1 | 67 | MBC7385590.1 hypothetical protein [Oligoflexia bacterium] | diamond | 453 | 74.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30342780 | 30342780 | PRJNA980839_P_NODE_79492_length_423_cov_2.382857_g75708_i0 | PRJNA980839 | 79492 | 423 | 2.382857 | 10.07948511 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 61.2 | 2.79e-9 | NR | MCB0310233.1 | 2053517 | g75708 | i0 | 50.6 | 0.546099290780142 | 77 | 37 | 53.9 | 1 | 234 | 7 | 7 | 83 | MCB0310233.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 231 | 61.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30443195 | 30443195 | PRJNA980839_P_NODE_205653_length_249_cov_0.875000_g201869_i0 | PRJNA980839 | 205653 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 143 | 1.56e-37 | NR | MCO5144381.1 | 2599941 | g201869 | i0 | 84.1 | 1.97590361445783 | 82 | 13 | 98.8 | 0 | 3 | 248 | 228 | 309 | MCO5144381.1 serine protein kinase PrkA [Oligoflexia bacterium] | diamond | 492 | 144 | 0.993055555555556 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30500230 | 30500230 | PRJNA980839_P_NODE_206453_length_249_cov_0.875000_g202669_i0 | PRJNA980839 | 206453 | 249 | 0.875 | 2.17875 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 96.7 | 6.6e-22 | NR | MCX7978398.1 | 2026715 | g202669 | i0 | 49.4 | 1.02409638554217 | 85 | 41 | 100 | 1 | 1 | 249 | 41 | 125 | MCX7978398.1 DUF4007 family protein [Pseudobdellovibrionaceae bacterium] | diamond | 255 | 96.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 30847783 | 30847783 | PRJNA980839_P_NODE_234714_length_242_cov_0.911243_g230930_i0 | PRJNA980839 | 234714 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 139 | 1.81e-36 | NR | MBS1983691.1 | 2053517 | g230930 | i0 | 84.8 | 5.91322314049587 | 79 | 12 | 97.9 | 0 | 1 | 237 | 50 | 128 | MBS1983691.1 type IV secretory system conjugative DNA transfer family protein [Bdellovibrionales bacterium] | diamond | 1431 | 139 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31543310 | 31543310 | PRJNA980839_P_NODE_237856_length_241_cov_0.916667_g234072_i0 | PRJNA980839 | 237856 | 241 | 0.916667 | 2.20916747 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 94 | 1.32e-20 | NR | MCM2321642.1 | 2599941 | g234072 | i0 | 61.3 | 0.995850622406639 | 80 | 31 | 99.6 | 0 | 2 | 241 | 3 | 82 | MCM2321642.1 pilus assembly protein PilM [Oligoflexia bacterium] | diamond | 240 | 94 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 32744716 | 32744716 | PRJNA980839_P_NODE_205200_length_249_cov_0.875000_g201416_i0 | PRJNA980839 | 205200 | 249 | 0.875 | 2.17875 | Bacteriovorax sp. | 2608087 | Bacteria | Bacteria | 112 | 1.6700000000000002e-26 | NR | MBC7712141.1 | 2608087 | g201416 | i0 | 71.6 | 1.79518072289157 | 74 | 21 | 89.2 | 0 | 244 | 23 | 449 | 522 | MBC7712141.1 DNA ligase D [Bacteriovorax sp.] | diamond | 447 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. | ||
| 32870512 | 32870512 | PRJNA980839_P_NODE_227080_length_244_cov_0.900585_g223296_i0 | PRJNA980839 | 227080 | 244 | 0.900585 | 2.1974274 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 125 | 1.89e-32 | NR | WP_325143727.1 | 1971216 | g223296 | i0 | 66.7 | 1.99180327868852 | 81 | 27 | 99.6 | 0 | 244 | 2 | 61 | 141 | WP_325143727.1 glycosyltransferase family 1 protein [Oligoflexus sp.] | diamond | 486 | 125 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus 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);;