contig_metadata
22 rows where bioproject = "PRJNA1020854", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6538898 | 6538898 | PRJNA1020854_S_NODE_13646_length_324_cov_16.847458_g10882_i0 | PRJNA1020854 | 13646 | 324 | 16.847458 | 54.58576392 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 427 | 4.33e-115 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g10882 | i0 | 90.432 | 211.296296296296 | 324 | 31 | 100 | 0 | 1 | 324 | 1292764 | 1292441 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 68460 | 427 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 7381091 | 7381091 | PRJNA1020854_S_NODE_42386_length_152_cov_3.300813_g39622_i0 | PRJNA1020854 | 42386 | 152 | 3.300813 | 5.01723576 | Bacteriovorax | 146784 | Bacteria | Bacteria | 220 | 3.22e-53 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g39622 | i0 | 92.81 | 11.4210526315789 | 153 | 10 | 100 | 1 | 1 | 152 | 1661722 | 1661874 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 1736 | 220 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 11206432 | 11206432 | PRJNA1020854_S_NODE_17409_length_271_cov_10.400826_g14645_i0 | PRJNA1020854 | 17409 | 271 | 10.400826 | 28.18623846 | Bacteriovorax | 146784 | Bacteria | Bacteria | 320 | 6.17e-83 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g14645 | i0 | 88.192 | 268.317343173432 | 271 | 29 | 99 | 3 | 3 | 271 | 1660852 | 1660583 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 72714 | 320 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 12915080 | 12915080 | PRJNA1020854_S_NODE_8471_length_482_cov_1108.328918_g5795_i0 | PRJNA1020854 | 8471 | 482 | 1108.328918 | 5342.14538476 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 99.8 | 1.7700000000000003e-21 | NR | HEY8278957.1 | 3034175 | g5795 | i0 | 58.9 | 0.560165975103734 | 90 | 37 | 56 | 0 | 164 | 433 | 1 | 90 | HEY8278957.1 flagellar hook capping FlgD N-terminal domain-containing protein [Bdellovibrionota bacterium] | diamond | 270 | 99.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 15463466 | 15463466 | PRJNA1020854_S_NODE_16173_length_287_cov_3.697674_g13409_i0 | PRJNA1020854 | 16173 | 287 | 3.697674 | 10.61232438 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 470 | 6.18e-128 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g13409 | i0 | 96.167 | 2 | 287 | 11 | 100 | 0 | 1 | 287 | 537635 | 537921 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 574 | 470 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 25229306 | 25229306 | PRJNA1020854_S_NODE_13940_length_319_cov_1075.093103_g11176_i0 | PRJNA1020854 | 13940 | 319 | 1075.093103 | 3429.54699857 | Bacteriovorax | 146784 | Bacteria | Bacteria | 399 | 9.269999999999998e-107 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g11176 | i0 | 93.939 | 251.736677115987 | 264 | 16 | 83 | 0 | 56 | 319 | 1660347 | 1660610 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 80304 | 399 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 27446013 | 27446013 | PRJNA1020854_S_NODE_36303_length_167_cov_3.318841_g33539_i0 | PRJNA1020854 | 36303 | 167 | 3.318841 | 5.54246447 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 56.6 | 1.67e-7 | NR | HEY8278958.1 | 3034175 | g33539 | i0 | 65.5 | 0.988023952095808 | 55 | 17 | 95.2 | 2 | 9 | 167 | 119 | 173 | HEY8278958.1 flagellar hook-length control protein FliK [Bdellovibrionota bacterium] | diamond | 165 | 56.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 28424644 | 28424644 | PRJNA1020854_S_NODE_34706_length_172_cov_2.342657_g31942_i0 | PRJNA1020854 | 34706 | 172 | 2.342657 | 4.02937004 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 127 | 3.33e-33 | NR | HEY8280555.1 | 3034175 | g31942 | i0 | 94.7 | 0.994186046511628 | 57 | 3 | 99.4 | 0 | 2 | 172 | 334 | 390 | HEY8280555.1 asparagine--tRNA ligase [Bdellovibrionota bacterium] | diamond | 171 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29466076 | 29466076 | PRJNA1020854_S_NODE_33190_length_177_cov_2.500000_g30426_i0 | PRJNA1020854 | 33190 | 177 | 2.5 | 4.425 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 79.3 | 1.89e-15 | NR | PZP56634.1 | 349221 | g30426 | i0 | 68 | 0.847457627118644 | 50 | 16 | 84.7 | 0 | 5 | 154 | 220 | 269 | PZP56634.1 MAG: hypothetical protein DI586_02940 [Micavibrio aeruginosavorus] | diamond | 150 | 79.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 29718805 | 29718805 | PRJNA1020854_S_NODE_32310_length_180_cov_2.596026_g29546_i0 | PRJNA1020854 | 32310 | 180 | 2.596026 | 4.6728468 | Bdellovibrio sp. | 28201 | Bacteria | Bacteria | 68.6 | 1.24e-11 | NR | HWU42144.1 | 28201 | g29546 | i0 | 88.9 | 0.6 | 36 | 4 | 60 | 0 | 71 | 178 | 453 | 488 | HWU42144.1 reverse transcriptase family protein [Bdellovibrio sp.] | diamond | 108 | 68.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 29782195 | 29782195 | PRJNA1020854_S_NODE_7771_length_530_cov_4.079840_g5129_i0 | PRJNA1020854 | 7771 | 530 | 4.07984 | 21.623152 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 115 | 3.24e-28 | NR | MEW6057922.1 | 3034175 | g5129 | i0 | 44.2 | 0.832075471698113 | 147 | 81 | 83.2 | 1 | 506 | 66 | 79 | 224 | MEW6057922.1 response regulator [Bdellovibrionota bacterium] | diamond | 441 | 115 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29813677 | 29813677 | PRJNA1020854_S_NODE_37431_length_164_cov_2.800000_g34667_i0 | PRJNA1020854 | 37431 | 164 | 2.8 | 4.592 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 45.4 | 0.00135 | NR | MBS1958356.1 | 2053517 | g34667 | i0 | 52.2 | 0.841463414634146 | 46 | 22 | 84.1 | 0 | 164 | 27 | 50 | 95 | MBS1958356.1 TIGR02147 family protein [Bdellovibrionales bacterium] | diamond | 138 | 45.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29877061 | 29877061 | PRJNA1020854_S_NODE_32271_length_180_cov_3.026490_g29507_i0 | PRJNA1020854 | 32271 | 180 | 3.02649 | 5.447682 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 61.6 | 2.33e-9 | NR | MCK5072915.1 | 2081706 | g29507 | i0 | 48.2 | 1.85 | 56 | 29 | 93.3 | 0 | 6 | 173 | 4 | 59 | MCK5072915.1 TIGR02147 family protein [Bacteriovoracaceae bacterium] | diamond | 333 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29971683 | 29971683 | PRJNA1020854_S_NODE_11391_length_373_cov_3.488372_g8637_i0 | PRJNA1020854 | 11391 | 373 | 3.488372 | 13.01162756 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 172 | 1.13e-51 | NR | MDR3607798.1 | 2599941 | g8637 | i0 | 71.6 | 0.932975871313673 | 116 | 33 | 93.3 | 0 | 372 | 25 | 98 | 213 | MDR3607798.1 carbonic anhydrase [Oligoflexia bacterium] | diamond | 348 | 172 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30445791 | 30445791 | PRJNA1020854_S_NODE_10413_length_401_cov_3.516129_g7673_i0 | PRJNA1020854 | 10413 | 401 | 3.516129 | 14.09967729 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 66.2 | 1e-9 | NR | MBX3020050.1 | 2053517 | g7673 | i0 | 45.1 | 0.531172069825436 | 71 | 39 | 53.1 | 0 | 151 | 363 | 3 | 73 | MBX3020050.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 213 | 66.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30603505 | 30603505 | PRJNA1020854_S_NODE_20333_length_244_cov_3.306977_g17569_i0 | PRJNA1020854 | 20333 | 244 | 3.306977 | 8.06902388 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 73.2 | 7.26e-13 | NR | HEY8279616.1 | 3034175 | g17569 | i0 | 79.1 | 0.528688524590164 | 43 | 9 | 52.9 | 0 | 243 | 115 | 667 | 709 | HEY8279616.1 GGDEF domain-containing protein [Bdellovibrionota bacterium] | diamond | 129 | 73.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30824735 | 30824735 | PRJNA1020854_S_NODE_12354_length_350_cov_3.376947_g9591_i0 | PRJNA1020854 | 12354 | 350 | 3.376947 | 11.8193145 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 108 | 1.96e-25 | NR | MBA2404814.1 | 2053517 | g9591 | i0 | 46.2 | 1.00285714285714 | 117 | 62 | 99.4 | 1 | 348 | 1 | 81 | 197 | MBA2404814.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 351 | 108 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31393875 | 31393875 | PRJNA1020854_S_NODE_13856_length_321_cov_3.931507_g11092_i0 | PRJNA1020854 | 13856 | 321 | 3.931507 | 12.62013747 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 159 | 1.95e-44 | NR | HEY8278958.1 | 3034175 | g11092 | i0 | 80 | 0.981308411214953 | 105 | 20 | 98.1 | 1 | 3 | 317 | 282 | 385 | HEY8278958.1 flagellar hook-length control protein FliK [Bdellovibrionota bacterium] | diamond | 315 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31773169 | 31773169 | PRJNA1020854_S_NODE_36697_length_166_cov_2.948905_g33933_i0 | PRJNA1020854 | 36697 | 166 | 2.948905 | 4.8951823 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 62 | 2.1e-9 | NR | HEY8280482.1 | 3034175 | g33933 | i0 | 52.7 | 0.993975903614458 | 55 | 26 | 99.4 | 0 | 1 | 165 | 238 | 292 | HEY8280482.1 ATP-binding protein [Bdellovibrionota bacterium] | diamond | 165 | 62 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32121483 | 32121483 | PRJNA1020854_S_NODE_35698_length_169_cov_2.521429_g32934_i0 | PRJNA1020854 | 35698 | 169 | 2.521429 | 4.26121501 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 65.1 | 1.8e-10 | NR | HEY8280482.1 | 3034175 | g32934 | i0 | 58.9 | 0.994082840236686 | 56 | 23 | 99.4 | 0 | 1 | 168 | 191 | 246 | HEY8280482.1 ATP-binding protein [Bdellovibrionota bacterium] | diamond | 168 | 65.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 32753201 | 32753201 | PRJNA1020854_S_NODE_7980_length_513_cov_6.526860_g5329_i0 | PRJNA1020854 | 7980 | 513 | 6.52686 | 33.4827918 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 45.8 | 0.0335 | NR | MFT6071456.1 | 2081706 | g5329 | i0 | 21.3 | 0.988304093567251 | 169 | 133 | 98.8 | 0 | 509 | 3 | 145 | 313 | MFT6071456.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 507 | 45.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32784556 | 32784556 | PRJNA1020854_S_NODE_25040_length_212_cov_3.524590_g22276_i0 | PRJNA1020854 | 25040 | 212 | 3.52459 | 7.4721308 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 63.5 | 8.97e-10 | NR | HEY8280188.1 | 3034175 | g22276 | i0 | 68.9 | 0.636792452830189 | 45 | 14 | 63.7 | 0 | 77 | 211 | 1 | 45 | HEY8280188.1 NADH-quinone oxidoreductase subunit H [Bdellovibrionota bacterium] | diamond | 135 | 63.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota 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);;