contig_metadata
18 rows where bioproject = "PRJNA561212", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10749715 | 10749715 | PRJNA561212_P_NODE_21429_length_251_cov_0.876404_g21218_i0 | PRJNA561212 | 21429 | 251 | 0.876404 | 2.19977404 | Bdellovibrio bacteriovorus | 959 | Bacteria | Bacteria | 298 | 2.65e-76 | NTclustered | gi|578016248|gb|CP002190.1| | 765869 | g21218 | i0 | 89.451 | 541.629482071713 | 237 | 24 | 94 | 1 | 10 | 245 | 610539 | 610303 | Bdellovibrio bacteriovorus W, complete genome | blastn | 135949 | 298 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 18397445 | 18397445 | PRJNA561212_P_NODE_7035_length_415_cov_1.251462_g6824_i0 | PRJNA561212 | 7035 | 415 | 1.251462 | 5.1935673 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 182 | 2.4499999999999998e-54 | NR | MCB0368864.1 | 2053517 | g6824 | i0 | 65.2 | 0.975903614457831 | 135 | 42 | 97.6 | 2 | 1 | 405 | 64 | 193 | MCB0368864.1 C1 family peptidase [Bdellovibrionales bacterium] | diamond | 405 | 182 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 22222365 | 22222365 | PRJNA561212_P_NODE_14578_length_293_cov_3.522727_g14367_i0 | PRJNA561212 | 14578 | 293 | 3.522727 | 10.32159011 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 420 | 6.469999999999998e-113 | NTclustered | gi|1950812799|gb|CP066681.1| | 349221 | g14367 | i0 | 94.505 | 263.184300341297 | 273 | 13 | 93 | 2 | 14 | 285 | 658548 | 658277 | Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome | blastn | 77113 | 420 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 22807829 | 22807829 | PRJNA561212_P_NODE_14458_length_294_cov_4.108597_g14247_i0 | PRJNA561212 | 14458 | 294 | 4.108597 | 12.07927518 | Halobacteriovorax | 1652133 | Bacteria | Bacteria | 510 | 3.74e-140 | NTclustered | gi|1249980216|gb|CP017414.1| | 97084 | g14247 | i0 | 100 | 308.676870748299 | 276 | 0 | 94 | 0 | 10 | 285 | 235265 | 234990 | Halobacteriovorax marinus strain BE01 chromosome, complete genome | blastn | 90751 | 510 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovorax | Halobacteriovorax marinus | ||
| 26635837 | 26635837 | PRJNA561212_P_NODE_11921_length_321_cov_1.774194_g11710_i0 | PRJNA561212 | 11921 | 321 | 1.774194 | 5.69516274 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 90.1 | 2.26e-18 | NR | MEZ4704431.1 | 3034175 | g11710 | i0 | 52.5 | 1.82242990654206 | 99 | 38 | 92.5 | 3 | 306 | 10 | 694 | 783 | MEZ4704431.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 585 | 90.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 26649665 | 26649665 | PRJNA561212_P_NODE_23581_length_246_cov_1.676301_g23370_i0 | PRJNA561212 | 23581 | 246 | 1.676301 | 4.12370046 | Bacteria | 2 | Bacteria | Bacteria | 55.1 | 1.77e-6 | NR | MBL7689555.1 | 2026715 | g23370 | i0 | 52.8 | 2.15853658536585 | 53 | 24 | 64.6 | 1 | 236 | 78 | 1277 | 1328 | MBL7689555.1 putative Ig domain-containing protein [Pseudobdellovibrionaceae bacterium] | diamond | 531 | 55.5 | 0.992792792792793 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27173728 | 27173728 | PRJNA561212_P_NODE_26082_length_242_cov_0.881657_g25871_i0 | PRJNA561212 | 26082 | 242 | 0.881657 | 2.13360994 | Pigmentibacter ruber | 2683196 | Bacteria | Bacteria | 65.1 | 3.57e-10 | NR | BFD32711.1 | 2683196 | g25871 | i0 | 43.7 | 0.880165289256198 | 71 | 34 | 80.6 | 1 | 204 | 10 | 55 | 125 | BFD32711.1 hypothetical protein GTC16762_23290 [Pigmentibacter ruber] | diamond | 213 | 65.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Pigmentibacter | Pigmentibacter ruber | ||
| 27237079 | 27237079 | PRJNA561212_P_NODE_17923_length_268_cov_2.297436_g17712_i0 | PRJNA561212 | 17923 | 268 | 2.297436 | 6.15712848 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 79.3 | 6.65e-15 | NR | MCC7442433.1 | 2053517 | g17712 | i0 | 54.5 | 0.861940298507463 | 77 | 33 | 85.1 | 2 | 257 | 30 | 675 | 750 | MCC7442433.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 231 | 79.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27584572 | 27584572 | PRJNA561212_P_NODE_24344_length_245_cov_0.906977_g24133_i0 | PRJNA561212 | 24344 | 245 | 0.906977 | 2.22209365 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 81.6 | 2.42e-17 | NR | MCB0371231.1 | 2053517 | g24133 | i0 | 81.6 | 0.6 | 49 | 9 | 60 | 0 | 48 | 194 | 112 | 160 | MCB0371231.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 147 | 81.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 28405599 | 28405599 | PRJNA561212_P_NODE_6826_length_422_cov_0.787966_g6615_i0 | PRJNA561212 | 6826 | 422 | 0.78796600000000006 | 3.32521652 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 70.5 | 5.33e-11 | NR | MDB9786543.1 | 2081706 | g6615 | i0 | 32.5 | 0.895734597156398 | 126 | 71 | 88.9 | 4 | 382 | 8 | 74 | 186 | MDB9786543.1 S8 family peptidase [Bacteriovoracaceae bacterium] | diamond | 378 | 70.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29605030 | 29605030 | PRJNA561212_P_NODE_22930_length_248_cov_0.891429_g22719_i0 | PRJNA561212 | 22930 | 248 | 0.891429 | 2.21074392 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 92.8 | 9.51e-20 | NR | MBT3983814.1 | 2081706 | g22719 | i0 | 59.2 | 2.78225806451613 | 76 | 30 | 91.9 | 1 | 239 | 12 | 334 | 408 | MBT3983814.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 690 | 92.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29650413 | 29650413 | PRJNA561212_P_NODE_16970_length_275_cov_1.519802_g16759_i0 | PRJNA561212 | 16970 | 275 | 1.519802 | 4.1794555 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.2 | 1.11e-12 | NR | OFZ31872.1 | 1797389 | g16759 | i0 | 49.3 | 2.38909090909091 | 73 | 36 | 79.6 | 1 | 23 | 241 | 987 | 1058 | OFZ31872.1 MAG: hypothetical protein A2622_11675 [Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29] | diamond | 657 | 73.9 | 0.990527740189445 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29 | ||||
| 30078957 | 30078957 | PRJNA561212_P_NODE_25532_length_243_cov_0.917647_g25321_i0 | PRJNA561212 | 25532 | 243 | 0.917647 | 2.22988221 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 83.6 | 1.19e-17 | NR | MCB0369273.1 | 2053517 | g25321 | i0 | 75 | 0.592592592592593 | 48 | 12 | 59.3 | 0 | 57 | 200 | 35 | 82 | MCB0369273.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 144 | 83.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31248130 | 31248130 | PRJNA561212_P_NODE_12435_length_315_cov_1.789256_g12224_i0 | PRJNA561212 | 12435 | 315 | 1.789256 | 5.6361564 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 57.4 | 4.34e-7 | NR | MBX2833619.1 | 2024841 | g12224 | i0 | 51.9 | 1.16190476190476 | 54 | 25 | 50.5 | 1 | 83 | 241 | 212 | 265 | MBX2833619.1 carbonic anhydrase family protein [Micavibrio sp.] | diamond | 366 | 57.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 32007367 | 32007367 | PRJNA561212_P_NODE_24818_length_244_cov_0.912281_g24607_i0 | PRJNA561212 | 24818 | 244 | 0.912281 | 2.22596564 | Bdellovibrionales bacterium RIFOXYD1_FULL_55_31 | 1797404 | Bacteria | Bacteria | 61.6 | 8.64e-9 | NR | OFZ83107.1 | 1797404 | g24607 | i0 | 51.5 | 0.811475409836066 | 66 | 30 | 81.1 | 2 | 37 | 234 | 1082 | 1145 | OFZ83107.1 MAG: hypothetical protein A2603_05625 [Bdellovibrionales bacterium RIFOXYD1_FULL_55_31] | diamond | 198 | 61.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYD1_FULL_55_31 | ||||
| 32306338 | 32306338 | PRJNA561212_P_NODE_22339_length_249_cov_0.886364_g22128_i0 | PRJNA561212 | 22339 | 249 | 0.886364 | 2.20704636 | Bacteria | 2 | Bacteria | Bacteria | 54.7 | 2.48e-6 | NR | MBU6154217.1 | 2053517 | g22128 | i0 | 46.1 | 2.75903614457831 | 76 | 40 | 91.6 | 1 | 11 | 238 | 808 | 882 | MBU6154217.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 687 | 54.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32324078 | 32324078 | PRJNA561212_P_NODE_17259_length_273_cov_1.475000_g17048_i0 | PRJNA561212 | 17259 | 273 | 1.475 | 4.02675 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 136 | 1.5e-38 | NR | MCB0369646.1 | 2053517 | g17048 | i0 | 90 | 0.769230769230769 | 70 | 7 | 76.9 | 0 | 9 | 218 | 29 | 98 | MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium] | diamond | 210 | 136 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32734399 | 32734399 | PRJNA561212_P_NODE_17760_length_270_cov_1.071066_g17549_i0 | PRJNA561212 | 17760 | 270 | 1.071066 | 2.8918782 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 86.3 | 2.56e-17 | NR | MEC7275530.1 | 3034175 | g17549 | i0 | 53.2 | 0.877777777777778 | 79 | 35 | 87.8 | 2 | 15 | 251 | 857 | 933 | MEC7275530.1 choice-of-anchor D domain-containing protein [Bdellovibrionota bacterium] | diamond | 237 | 86.3 | 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);;