contig_metadata
17 rows where bioproject = "PRJNA700095", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5012448 | 5012448 | PRJNA700095_P_NODE_24744_length_346_cov_1.663004_g23480_i0 | PRJNA700095 | 24744 | 346 | 1.663004 | 5.75399384 | Bdellovibrio | 958 | Bacteria | Bacteria | 424 | 6.02e-114 | NTclustered | gi|2313021230|gb|CP102930.1| | 959 | g23480 | i0 | 88.986 | 142.884393063584 | 345 | 34 | 99 | 4 | 5 | 346 | 2386487 | 2386144 | Bdellovibrio bacteriovorus strain kdesi chromosome, complete genome | blastn | 49438 | 424 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 10112850 | 10112850 | PRJNA700095_P_NODE_53148_length_249_cov_1.806818_g51884_i0 | PRJNA700095 | 53148 | 249 | 1.806818 | 4.49897682 | Bdellovibrio | 958 | Bacteria | Bacteria | 449 | 6.840000000000001e-122 | NTclustered | gi|2771112236|gb|CP160486.1| | 959 | g51884 | i0 | 99.197 | 173.461847389558 | 249 | 2 | 100 | 0 | 1 | 249 | 823700 | 823452 | Bdellovibrio bacteriovorus strain MHI39 chromosome | blastn | 43192 | 449 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 10887431 | 10887431 | PRJNA700095_P_NODE_69289_length_226_cov_2.888889_g68024_i0 | PRJNA700095 | 69289 | 226 | 2.888889 | 6.52888914 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 287 | 5.059999999999999e-73 | NTclustered | gi|2258818259|gb|CP060220.1| | 2026715 | g68024 | i0 | 89.868 | 220.101769911504 | 227 | 17 | 100 | 6 | 1 | 226 | 3250546 | 3250767 | MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome | blastn | 49743 | 287 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 19810088 | 19810088 | PRJNA700095_P_NODE_31716_length_303_cov_3.404348_g30452_i0 | PRJNA700095 | 31716 | 303 | 3.404348 | 10.31517444 | Bdellovibrio sp. HCB-162 | 3394234 | Bacteria | Bacteria | 527 | 3.8499999999999985e-145 | NTclustered | gi|2898207634|gb|CP178861.1| | 3394234 | g30452 | i0 | 98.02 | 87.3267326732673 | 303 | 6 | 100 | 0 | 1 | 303 | 843042 | 842740 | Bdellovibrio sp. HCB-162 chromosome, complete genome | blastn | 26460 | 527 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB-162 | ||
| 19810226 | 19810226 | PRJNA700095_P_NODE_57696_length_246_cov_1.150289_g56432_i0 | PRJNA700095 | 57696 | 246 | 1.150289 | 2.82971094 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 110 | 1.3e-19 | NTclustered | gi|578016248|gb|CP002190.1| | 765869 | g56432 | i0 | 83.193 | 2.32926829268293 | 119 | 20 | 48 | 0 | 117 | 235 | 609805 | 609687 | Bdellovibrio bacteriovorus W, complete genome | blastn | 573 | 110 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 21586525 | 21586525 | PRJNA700095_P_NODE_68637_length_229_cov_2.782051_g67372_i0 | PRJNA700095 | 68637 | 229 | 2.782051 | 6.37089679 | Halobacteriovorax | 1652133 | Bacteria | Bacteria | 58.4 | 4.39e-4 | NTclustered | gi|1249980216|gb|CP017414.1| | 97084 | g67372 | i0 | 94.595 | 0.323144104803493 | 37 | 2 | 16 | 0 | 193 | 229 | 626819 | 626855 | Halobacteriovorax marinus strain BE01 chromosome, complete genome | blastn | 74 | 58.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 21586532 | 21586532 | PRJNA700095_P_NODE_70057_length_214_cov_4.943262_g68792_i0 | PRJNA700095 | 70057 | 214 | 4.943262 | 10.57858068 | Pseudobdellovibrio | 2862745 | Bacteria | Bacteria | 396 | 7.559999999999996e-106 | NTclustered | gi|507148233|ref|NR_103040.1| | 453816 | g68792 | i0 | 100 | 305.018691588785 | 214 | 0 | 100 | 0 | 1 | 214 | 2650 | 2863 | Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence | blastn | 65274 | 396 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio exovorus | ||
| 23636302 | 23636302 | PRJNA700095_P_NODE_8559_length_675_cov_3.501661_g7374_i0 | PRJNA700095 | 8559 | 675 | 3.501661 | 23.63621175 | Bdellovibrio sp. HCB-162 | 3394234 | Bacteria | Bacteria | 1168 | 0 | NTclustered | gi|2898207634|gb|CP178861.1| | 3394234 | g7374 | i0 | 97.923 | 211.185185185185 | 674 | 14 | 99 | 0 | 1 | 674 | 841994 | 842667 | Bdellovibrio sp. HCB-162 chromosome, complete genome | blastn | 142550 | 1168 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB-162 | ||
| 24909707 | 24909707 | PRJNA700095_P_NODE_69880_length_217_cov_5.277778_g68615_i0 | PRJNA700095 | 69880 | 217 | 5.277778 | 11.45277826 | Bdellovibrio sp. HCB-162 | 3394234 | Bacteria | Bacteria | 270 | 4.86e-68 | NTclustered | gi|2898207634|gb|CP178861.1| | 3394234 | g68615 | i0 | 89.498 | 3.02764976958525 | 219 | 15 | 99 | 7 | 1 | 214 | 1071383 | 1071598 | Bdellovibrio sp. HCB-162 chromosome, complete genome | blastn | 657 | 270 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. HCB-162 | ||
| 30240759 | 30240759 | PRJNA700095_P_NODE_26152_length_335_cov_2.637405_g24888_i0 | PRJNA700095 | 26152 | 335 | 2.6374050000000002 | 8.83530675 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 70.9 | 1.07e-13 | NR | MBX9703359.1 | 2654442 | g24888 | i0 | 64.3 | 0.376119402985075 | 42 | 15 | 37.6 | 0 | 293 | 168 | 1 | 42 | MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium] | diamond | 126 | 70.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 30335923 | 30335923 | PRJNA700095_P_NODE_4512_length_928_cov_17.304094_g3582_i0 | PRJNA700095 | 4512 | 928 | 17.304094 | 160.58199232 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 375 | 4.78e-129 | NR | MBX9767865.1 | 2053517 | g3582 | i0 | 90.5 | 0.649784482758621 | 201 | 19 | 65 | 0 | 261 | 863 | 1 | 201 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 603 | 375 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30462310 | 30462310 | PRJNA700095_P_NODE_14893_length_480_cov_3.137592_g13632_i0 | PRJNA700095 | 14893 | 480 | 3.137592 | 15.0604416 | Bdellovibrionia bacterium | 3034169 | Bacteria | Bacteria | 140 | 1.69e-39 | NR | MEO5970318.1 | 3034169 | g13632 | i0 | 57.8 | 3.15625 | 128 | 48 | 79.4 | 2 | 381 | 1 | 2 | 124 | MEO5970318.1 hotdog fold thioesterase [Bdellovibrionia bacterium] | diamond | 1515 | 140 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionia bacterium | |||||
| 30493574 | 30493574 | PRJNA700095_P_NODE_58893_length_245_cov_1.691860_g57629_i0 | PRJNA700095 | 58893 | 245 | 1.69186 | 4.145057 | Bdellovibrio sp. GT3 | 3136282 | Bacteria | Bacteria | 42.4 | 0.0495 | NR | WP_340596188.1 | 3136282 | g57629 | i0 | 37.9 | 0.710204081632653 | 58 | 36 | 71 | 0 | 6 | 179 | 75 | 132 | WP_340596188.1 hypothetical protein [Bdellovibrio sp. GT3] | diamond | 174 | 42.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. GT3 | ||
| 30651210 | 30651210 | PRJNA700095_P_NODE_8173_length_692_cov_4.179321_g7006_i0 | PRJNA700095 | 8173 | 692 | 4.179321 | 28.92090132 | Pigmentibacter ruber | 2683196 | Bacteria | Bacteria | 90.5 | 1.37e-19 | NR | WP_158998151.1 | 2683196 | g7006 | i0 | 52.4 | 1.4393063583815 | 84 | 40 | 36.4 | 0 | 208 | 459 | 2 | 85 | WP_158998151.1 30S ribosomal protein S15 [Pigmentibacter ruber] | diamond | 996 | 90.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Pigmentibacter | Pigmentibacter ruber | ||
| 30915568 | 30915568 | PRJNA700095_P_NODE_49494_length_254_cov_1.801105_g48230_i0 | PRJNA700095 | 49494 | 254 | 1.801105 | 4.5748067 | Bdellovibrio | 958 | Bacteria | Bacteria | 64.7 | 4.36e-11 | NR | WP_246845325.1 | 2220073 | g48230 | i0 | 44.6 | 7.88976377952756 | 56 | 31 | 66.1 | 0 | 253 | 86 | 65 | 120 | WP_246845325.1 DOPA 4,5-dioxygenase family protein [Bdellovibrio sp. NC01] | diamond | 2004 | 65.1 | 0.993855606758833 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. NC01 | ||
| 32528653 | 32528653 | PRJNA700095_P_NODE_15139_length_475_cov_3.256219_g13878_i0 | PRJNA700095 | 15139 | 475 | 3.256219 | 15.46704025 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 78.6 | 1.48e-13 | NR | MBC77950.1 | 2026745 | g13878 | i0 | 40.4 | 7.95789473684211 | 99 | 40 | 62.5 | 2 | 174 | 470 | 808 | 887 | MBC77950.1 hypothetical protein [Halobacteriovoraceae bacterium] | diamond | 3780 | 78.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 32863804 | 32863804 | PRJNA700095_P_NODE_16940_length_440_cov_2.264305_g15677_i0 | PRJNA700095 | 16940 | 440 | 2.264305 | 9.962942 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 213 | 1.4e-66 | NR | MBX9767866.1 | 2053517 | g15677 | i0 | 71.4 | 1.00227272727273 | 147 | 41 | 99.5 | 1 | 3 | 440 | 2 | 148 | MBX9767866.1 GTP-binding protein [Bdellovibrionales bacterium] | diamond | 441 | 213 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales 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);;