contig_metadata
19 rows where bioproject = "PRJNA1073183", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2737966 | 2737966 | PRJNA1073183_P_NODE_33023_length_243_cov_0.905882_g32928_i0 | PRJNA1073183 | 33023 | 243 | 0.905882 | 2.20129326 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 57 | 3.49e-8 | NR | MCM2283060.1 | 2026715 | g32928 | i0 | 96.6 | 0.358024691358025 | 29 | 1 | 35.8 | 0 | 1 | 87 | 86 | 114 | MCM2283060.1 kinase/pyrophosphorylase [Pseudobdellovibrionaceae bacterium] | diamond | 87 | 57 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 18038975 | 18038975 | PRJNA1073183_P_NODE_27235_length_250_cov_0.870056_g27140_i0 | PRJNA1073183 | 27235 | 250 | 0.870056 | 2.17514 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 141 | 8.819999999999999e-37 | NR | MCM2282276.1 | 2026715 | g27140 | i0 | 80.7 | 5.976 | 83 | 16 | 99.6 | 0 | 1 | 249 | 254 | 336 | MCM2282276.1 heavy metal translocating P-type ATPase [Pseudobdellovibrionaceae bacterium] | diamond | 1494 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 21863887 | 21863887 | PRJNA1073183_P_NODE_13138_length_357_cov_2.154930_g13043_i0 | PRJNA1073183 | 13138 | 357 | 2.15493 | 7.6931001 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 222 | 1.2e-68 | NR | MCB0368368.1 | 2053517 | g13043 | i0 | 91.5 | 0.991596638655462 | 118 | 10 | 99.2 | 0 | 356 | 3 | 257 | 374 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 354 | 222 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 26655634 | 26655634 | PRJNA1073183_P_NODE_25821_length_254_cov_1.469613_g25726_i0 | PRJNA1073183 | 25821 | 254 | 1.469613 | 3.73281702 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 78.2 | 6.93e-15 | NR | MCB0369725.1 | 2053517 | g25726 | i0 | 81.3 | 1.13385826771654 | 48 | 9 | 56.7 | 0 | 147 | 4 | 10 | 57 | MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 288 | 78.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27478180 | 27478180 | PRJNA1073183_P_NODE_12743_length_363_cov_1.062069_g12648_i0 | PRJNA1073183 | 12743 | 363 | 1.062069 | 3.85531047 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 134 | 7.27e-35 | NR | MCB0369454.1 | 2053517 | g12648 | i0 | 53.3 | 0.991735537190083 | 120 | 50 | 94.2 | 1 | 350 | 9 | 20 | 139 | MCB0369454.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 360 | 134 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27762616 | 27762616 | PRJNA1073183_P_NODE_14404_length_342_cov_2.089219_g14309_i0 | PRJNA1073183 | 14404 | 342 | 2.089219 | 7.14512898 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 155 | 1.56e-46 | NR | MCB0370850.1 | 2053517 | g14309 | i0 | 67.5 | 1 | 114 | 36 | 100 | 1 | 1 | 342 | 3 | 115 | MCB0370850.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 342 | 155 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27920162 | 27920162 | PRJNA1073183_P_NODE_19705_length_294_cov_2.018100_g19610_i0 | PRJNA1073183 | 19705 | 294 | 2.0181 | 5.933214 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 127 | 9.14e-33 | NR | MCB0369454.1 | 2053517 | g19610 | i0 | 59.8 | 0.989795918367347 | 97 | 39 | 99 | 0 | 3 | 293 | 141 | 237 | MCB0369454.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 291 | 127 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29025655 | 29025655 | PRJNA1073183_P_NODE_33608_length_242_cov_0.911243_g33513_i0 | PRJNA1073183 | 33608 | 242 | 0.911243 | 2.20520806 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 144 | 5.9899999999999996e-43 | NR | MCB0368228.1 | 2053517 | g33513 | i0 | 92.5 | 0.991735537190083 | 80 | 6 | 99.2 | 0 | 241 | 2 | 9 | 88 | MCB0368228.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 240 | 144 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29111697 | 29111697 | PRJNA1073183_P_NODE_13768_length_350_cov_1.021661_g13673_i0 | PRJNA1073183 | 13768 | 350 | 1.021661 | 3.5758135 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 118 | 1.15e-30 | NR | OFZ01981.1 | 1797385 | g13673 | i0 | 50.9 | 13.0971428571429 | 110 | 54 | 94.3 | 0 | 343 | 14 | 74 | 183 | OFZ01981.1 MAG: NAD(P)H:quinone oxidoreductase, type IV [Bdellovibrionales bacterium GWB1_52_6] | diamond | 4584 | 119 | 0.991596638655462 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium GWB1_52_6 | ||||
| 29561947 | 29561947 | PRJNA1073183_P_NODE_27490_length_250_cov_0.870056_g27395_i0 | PRJNA1073183 | 27490 | 250 | 0.870056 | 2.17514 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 142 | 1.07e-40 | NR | MCB0369154.1 | 2053517 | g27395 | i0 | 84.1 | 0.984 | 82 | 13 | 98.4 | 0 | 246 | 1 | 60 | 141 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 246 | 142 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29593265 | 29593265 | PRJNA1073183_P_NODE_27010_length_251_cov_0.865169_g26915_i0 | PRJNA1073183 | 27010 | 251 | 0.865169 | 2.17157419 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 148 | 1.43e-41 | NR | MES2965979.1 | 3034175 | g26915 | i0 | 89.2 | 1.9840637450199201 | 83 | 9 | 99.2 | 0 | 1 | 249 | 153 | 235 | MES2965979.1 Holliday junction branch migration DNA helicase RuvB [Bdellovibrionota bacterium] | diamond | 498 | 148 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29616447 | 29616447 | PRJNA1073183_P_NODE_2510_length_782_cov_2.314528_g2431_i0 | PRJNA1073183 | 2510 | 782 | 2.314528 | 18.09960896 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 209 | 2.8699999999999997e-62 | NR | PZQ44194.1 | 349221 | g2431 | i0 | 42.6 | 12.2340153452685 | 265 | 141 | 99.7 | 6 | 781 | 2 | 44 | 302 | PZQ44194.1 MAG: hydroxyacid dehydrogenase [Micavibrio aeruginosavorus] | diamond | 9567 | 211 | 0.990521327014218 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30193667 | 30193667 | PRJNA1073183_P_NODE_23992_length_266_cov_1.595855_g23897_i0 | PRJNA1073183 | 23992 | 266 | 1.595855 | 4.2449743 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 57.8 | 1.56e-8 | NR | MCB0368989.1 | 2053517 | g23897 | i0 | 61.9 | 0.473684210526316 | 42 | 16 | 47.4 | 0 | 133 | 258 | 1 | 42 | MCB0368989.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 126 | 57.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31172891 | 31172891 | PRJNA1073183_P_NODE_13775_length_350_cov_0.963899_g13680_i0 | PRJNA1073183 | 13775 | 350 | 0.963899 | 3.3736465 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 192 | 3.91e-60 | NR | MBP9675022.1 | 2081706 | g13680 | i0 | 88.9 | 0.925714285714286 | 108 | 12 | 92.6 | 0 | 27 | 350 | 6 | 113 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 324 | 192 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31489729 | 31489729 | PRJNA1073183_P_NODE_11156_length_385_cov_1.961538_g11061_i0 | PRJNA1073183 | 11156 | 385 | 1.961538 | 7.5519213 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 159 | 6.889999999999999e-47 | NR | MCB0369154.1 | 2053517 | g11061 | i0 | 65.6 | 1.02077922077922 | 131 | 34 | 98.2 | 5 | 378 | 1 | 4 | 128 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 393 | 159 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31616002 | 31616002 | PRJNA1073183_P_NODE_13516_length_353_cov_1.100000_g13421_i0 | PRJNA1073183 | 13516 | 353 | 1.1 | 3.883 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 180 | 2.1199999999999996e-55 | NR | MBP9675022.1 | 2081706 | g13421 | i0 | 90.7 | 0.824362606232295 | 97 | 9 | 82.4 | 0 | 62 | 352 | 16 | 112 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 291 | 180 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 31995666 | 31995666 | PRJNA1073183_P_NODE_25398_length_257_cov_1.364130_g25303_i0 | PRJNA1073183 | 25398 | 257 | 1.36413 | 3.5058141 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 87.8 | 6.110000000000001e-21 | NR | MCB0367907.1 | 2053517 | g25303 | i0 | 76.5 | 0.595330739299611 | 51 | 12 | 59.5 | 0 | 93 | 245 | 1 | 51 | MCB0367907.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 153 | 87.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32185549 | 32185549 | PRJNA1073183_P_NODE_22998_length_273_cov_1.155000_g22903_i0 | PRJNA1073183 | 22998 | 273 | 1.155 | 3.15315 | Halobacteriovorax marinus | 97084 | Bacteria | Bacteria | 137 | 2.64e-37 | NR | OUR94148.1 | 97084 | g22903 | i0 | 74.2 | 4.89010989010989 | 89 | 23 | 97.8 | 0 | 3 | 269 | 51 | 139 | OUR94148.1 ribonucleoside-diphosphate reductase [Halobacteriovorax marinus] | diamond | 1335 | 137 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 32438839 | 32438839 | PRJNA1073183_P_NODE_27419_length_250_cov_0.870056_g27324_i0 | PRJNA1073183 | 27419 | 250 | 0.870056 | 2.17514 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 134 | 9.19e-38 | NR | MBP9675022.1 | 2081706 | g27324 | i0 | 85.5 | 0.912 | 76 | 11 | 91.2 | 0 | 229 | 2 | 6 | 81 | MBP9675022.1 EF-hand domain-containing protein [Bacteriovoracaceae bacterium] | diamond | 228 | 134 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae 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);;