contig_metadata
18 rows where bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1082842 | 1082842 | PRJNA414036_P_NODE_25521_length_299_cov_6.500000_g23787_i0 | PRJNA414036 | 25521 | 299 | 6.5 | 19.435 | Micavibrio | 213485 | Bacteria | Bacteria | 191 | 5.65e-44 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g23787 | i0 | 81.435 | 30.0869565217391 | 237 | 40 | 79 | 4 | 6 | 240 | 463852 | 463618 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 8996 | 191 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 1082987 | 1082987 | PRJNA414036_P_NODE_67401_length_190_cov_7.296774_g65662_i0 | PRJNA414036 | 67401 | 190 | 7.296774 | 13.8638706 | Bacteriovorax | 146784 | Bacteria | Bacteria | 187 | 4.29e-43 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g65662 | i0 | 100 | 96.9526315789474 | 101 | 0 | 88 | 0 | 10 | 110 | 1660365 | 1660465 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 18421 | 187 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 4910908 | 4910908 | PRJNA414036_P_NODE_29344_length_277_cov_11.231405_g27609_i0 | PRJNA414036 | 29344 | 277 | 11.231405 | 31.11099185 | Bdellovibrio | 958 | Bacteria | Bacteria | 302 | 2.29e-77 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g27609 | i0 | 98.817 | 183.909747292419 | 169 | 2 | 84 | 0 | 101 | 269 | 816490 | 816322 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 50943 | 302 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 6186020 | 6186020 | PRJNA414036_P_NODE_58465_length_222_cov_32.085561_g56726_i0 | PRJNA414036 | 58465 | 222 | 32.085561 | 71.22994542 | Bdellovibrio | 958 | Bacteria | Bacteria | 379 | 7.949999999999998e-101 | NTclustered | gi|2800948966|gb|CP168973.1| | 959 | g56726 | i0 | 99.519 | 308.846846846847 | 208 | 1 | 94 | 0 | 7 | 214 | 816529 | 816322 | Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome | blastn | 68564 | 379 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 7460848 | 7460848 | PRJNA414036_P_NODE_40806_length_231_cov_5.897959_g39067_i0 | PRJNA414036 | 40806 | 231 | 5.897959 | 13.62428529 | Bacteriovorax | 146784 | Bacteria | Bacteria | 122 | 1.55e-23 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g39067 | i0 | 92.857 | 5.74025974025974 | 84 | 6 | 65 | 0 | 139 | 222 | 1661747 | 1661830 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 1326 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 7460922 | 7460922 | PRJNA414036_P_NODE_68506_length_187_cov_5.111842_g66767_i0 | PRJNA414036 | 68506 | 187 | 5.111842 | 9.55914454 | Bdellovibrio | 958 | Bacteria | Bacteria | 117 | 5.600000000000001e-22 | NTclustered | gi|2801803968|gb|CP169237.1| | 959 | g66767 | i0 | 93.59 | 2.0855614973262 | 78 | 5 | 42 | 0 | 101 | 178 | 945130 | 945207 | Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome | blastn | 390 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 8072104 | 8072104 | PRJNA414036_P_NODE_65427_length_196_cov_27.409938_g63688_i0 | PRJNA414036 | 65427 | 196 | 27.409938 | 53.72347848 | Bdellovibrio sp. NC01 | 2220073 | Bacteria | Bacteria | 292 | 9.18e-75 | NTclustered | gi|1700686220|gb|CP030034.1| | 2220073 | g63688 | i0 | 96.591 | 78.3163265306122 | 176 | 6 | 90 | 0 | 10 | 185 | 861324 | 861499 | Bdellovibrio sp. NC01 chromosome, complete genome | blastn | 15350 | 292 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 8735695 | 8735695 | PRJNA414036_P_NODE_12287_length_408_cov_10.865952_g10682_i0 | PRJNA414036 | 12287 | 408 | 10.865952 | 44.33308416 | Bdellovibrio | 958 | Bacteria | Bacteria | 252 | 3.6e-62 | NTclustered | gi|2800917394|gb|CP168972.1| | 959 | g10682 | i0 | 88.208 | 37.3039215686275 | 212 | 24 | 69 | 1 | 94 | 305 | 750244 | 750454 | Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome | blastn | 15220 | 252 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 10010925 | 10010925 | PRJNA414036_P_NODE_15068_length_380_cov_11.055072_g13387_i0 | PRJNA414036 | 15068 | 380 | 11.055072 | 42.0092736 | Bdellovibrio | 958 | Bacteria | Bacteria | 241 | 7.2e-59 | NTclustered | gi|2800917394|gb|CP168972.1| | 959 | g13387 | i0 | 88.208 | 101.802631578947 | 212 | 11 | 71 | 6 | 79 | 277 | 750244 | 750454 | Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome | blastn | 38685 | 241 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 11897664 | 11897664 | PRJNA414036_P_NODE_67510_length_190_cov_2.703226_g65771_i0 | PRJNA414036 | 67510 | 190 | 2.703226 | 5.1361294 | Bdellovibrio sp. HCB337 | 3394358 | Bacteria | Bacteria | 178 | 2.58e-40 | NTclustered | gi|2895525383|gb|CP178621.1| | 3394358 | g65771 | i0 | 86.792 | 5.82105263157895 | 159 | 21 | 84 | 0 | 27 | 185 | 3446858 | 3446700 | Bdellovibrio sp. HCB337 chromosome, complete genome | blastn | 1106 | 178 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB337 | ||
| 12561631 | 12561631 | PRJNA414036_P_NODE_40990_length_231_cov_5.535714_g39251_i0 | PRJNA414036 | 40990 | 231 | 5.535714 | 12.78749934 | Bacteriovorax | 146784 | Bacteria | Bacteria | 122 | 1.55e-23 | NTclustered | gi|1700689994|gb|CP030035.1| | 960 | g39251 | i0 | 100 | 138.761904761905 | 66 | 0 | 58 | 0 | 157 | 222 | 1662149 | 1662214 | Bacteriovorax stolpii strain AC01 chromosome, complete genome | blastn | 32054 | 122 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 16996113 | 16996113 | PRJNA414036_P_NODE_1674_length_658_cov_400.528090_g1327_i0 | PRJNA414036 | 1674 | 658 | 400.52809 | 2635.4748322 | Halobacteriovorax sp. BALOs_7 | 2109558 | Bacteria | Bacteria | 156 | 4.85e-33 | NTclustered | gi|1486380477|gb|CP027772.1| | 2109558 | g1327 | i0 | 82.258 | 100.969604863222 | 186 | 28 | 28 | 5 | 161 | 344 | 250102 | 250284 | Halobacteriovorax sp. BALOs_7 chromosome, complete genome | blastn | 66438 | 156 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. BALOs_7 | ||
| 18270277 | 18270277 | PRJNA414036_P_NODE_1675_length_658_cov_393.850722_g1328_i0 | PRJNA414036 | 1675 | 658 | 393.850722 | 2591.53775076 | Halobacteriovorax sp. BALOs_7 | 2109558 | Bacteria | Bacteria | 156 | 4.85e-33 | NTclustered | gi|1486380477|gb|CP027772.1| | 2109558 | g1328 | i0 | 82.258 | 94.1884498480243 | 186 | 28 | 28 | 5 | 315 | 498 | 250284 | 250102 | Halobacteriovorax sp. BALOs_7 chromosome, complete genome | blastn | 61976 | 156 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax sp. BALOs_7 | ||
| 22759895 | 22759895 | PRJNA414036_P_NODE_36098_length_246_cov_9.924171_g34362_i0 | PRJNA414036 | 36098 | 246 | 9.924171 | 24.41346066 | Micavibrio | 213485 | Bacteria | Bacteria | 121 | 6.01e-23 | NTclustered | gi|469926873|gb|CP003538.1| | 349215 | g34362 | i0 | 95.946 | 87.3455284552846 | 74 | 3 | 30 | 0 | 10 | 83 | 464682 | 464755 | Micavibrio aeruginosavorus EPB, complete genome | blastn | 21487 | 121 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 29128448 | 29128448 | PRJNA414036_P_NODE_67709_length_189_cov_18.272727_g65970_i0 | PRJNA414036 | 67709 | 189 | 18.272727 | 34.53545403 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 41.2 | 0.0133 | NR | MDB5491878.1 | 2024841 | g65970 | i0 | 67.7 | 0.492063492063492 | 31 | 10 | 49.2 | 0 | 2 | 94 | 53 | 83 | MDB5491878.1 uncharacterized protein [Micavibrio sp.] | diamond | 93 | 41.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 29191452 | 29191452 | PRJNA414036_P_NODE_47709_length_231_cov_2.653061_g45970_i0 | PRJNA414036 | 47709 | 231 | 2.653061 | 6.12857091 | Bacteriovorax antarcticus | 3088717 | Bacteria | Bacteria | 50.8 | 4.22e-5 | NR | WP_323574562.1 | 3088717 | g45970 | i0 | 95.5 | 0.285714285714286 | 22 | 1 | 28.6 | 0 | 9 | 74 | 213 | 234 | WP_323574562.1 homogentisate 1,2-dioxygenase [Bacteriovorax antarcticus] | diamond | 66 | 50.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax antarcticus | ||
| 30580856 | 30580856 | PRJNA414036_P_NODE_45893_length_231_cov_3.061224_g44154_i0 | PRJNA414036 | 45893 | 231 | 3.061224 | 7.07142744 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 43.1 | 0.0237 | NR | MBC7659921.1 | 1971216 | g44154 | i0 | 85.7 | 0.272727272727273 | 21 | 3 | 27.3 | 0 | 160 | 222 | 38 | 58 | MBC7659921.1 trypsin-like serine protease [Oligoflexus sp.] | diamond | 63 | 43.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 32305506 | 32305506 | PRJNA414036_P_NODE_42199_length_231_cov_4.418367_g40460_i0 | PRJNA414036 | 42199 | 231 | 4.418367 | 10.20642777 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.1 | 0.00182 | NR | MBC7531827.1 | 1971216 | g40460 | i0 | 86.4 | 1.14285714285714 | 22 | 3 | 28.6 | 0 | 157 | 222 | 44 | 65 | MBC7531827.1 hypothetical protein [Oligoflexus sp.] | diamond | 264 | 45.1 | 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);;