contig_metadata
27 rows where bioproject = "PRJNA1022139", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2712193 | 2712193 | PRJNA1022139_P_NODE_5503_length_552_cov_5.394572_g5399_i0 | PRJNA1022139 | 5503 | 552 | 5.394572 | 29.77803744 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 309 | 3.89e-103 | NR | MCB0369725.1 | 2053517 | g5399 | i0 | 81.4 | 2.91847826086957 | 183 | 34 | 99.5 | 0 | 551 | 3 | 11 | 193 | MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 1611 | 309 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 3988211 | 3988211 | PRJNA1022139_P_NODE_2364_length_800_cov_3.020633_g2279_i0 | PRJNA1022139 | 2364 | 800 | 3.020633 | 24.165064 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 453 | 1.09e-156 | NR | MCB0368368.1 | 2053517 | g2279 | i0 | 83.3 | 0.99 | 264 | 44 | 99 | 0 | 1 | 792 | 45 | 308 | MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 792 | 453 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 9089105 | 9089105 | PRJNA1022139_P_NODE_11968_length_388_cov_2.438095_g11863_i0 | PRJNA1022139 | 11968 | 388 | 2.438095 | 9.4598086 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 130 | 8.990000000000001e-36 | NR | MCB0370127.1 | 2053517 | g11863 | i0 | 90.5 | 0.572164948453608 | 74 | 7 | 57.2 | 0 | 167 | 388 | 72 | 145 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 222 | 130 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 14190173 | 14190173 | PRJNA1022139_P_NODE_12892_length_377_cov_0.868421_g12787_i0 | PRJNA1022139 | 12892 | 377 | 0.868421 | 3.27394717 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 477 | 5e-130 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g12787 | i0 | 95.623 | 86.1803713527851 | 297 | 13 | 100 | 0 | 81 | 377 | 511926 | 512222 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 32490 | 477 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 18013407 | 18013407 | PRJNA1022139_P_NODE_18895_length_320_cov_2.441296_g18790_i0 | PRJNA1022139 | 18895 | 320 | 2.441296 | 7.8121472 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 177 | 1.0799999999999999e-54 | NR | MCB0370127.1 | 2053517 | g18790 | i0 | 86.6 | 0.909375 | 97 | 13 | 90.9 | 0 | 30 | 320 | 33 | 129 | MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium] | diamond | 291 | 177 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 19287406 | 19287406 | PRJNA1022139_P_NODE_3636_length_662_cov_1.769100_g3533_i0 | PRJNA1022139 | 3636 | 662 | 1.7691 | 11.711442 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 71.2 | 1.39e-12 | NR | MBX9703359.1 | 2654442 | g3533 | i0 | 60.9 | 0.208459214501511 | 46 | 18 | 20.8 | 0 | 285 | 422 | 1 | 46 | MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium] | diamond | 138 | 71.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 23113985 | 23113985 | PRJNA1022139_P_NODE_36739_length_248_cov_1.760000_g36634_i0 | PRJNA1022139 | 36739 | 248 | 1.76 | 4.3648 | Peredibacter starrii | 28202 | Bacteria | Bacteria | 311 | 3.35e-80 | NTclustered | gi|2631252187|gb|CP139487.1| | 28202 | g36634 | i0 | 89.474 | 86.633064516129 | 247 | 25 | 99 | 1 | 1 | 247 | 511219 | 510974 | Peredibacter starrii strain A3.12 chromosome, complete genome | blastn | 21485 | 311 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter starrii | ||
| 24387785 | 24387785 | PRJNA1022139_P_NODE_32200_length_258_cov_1.664865_g32095_i0 | PRJNA1022139 | 32200 | 258 | 1.664865 | 4.2953517 | Peredibacter sp. HCB2-198 | 3383025 | Bacteria | Bacteria | 305 | 1.63e-78 | NTclustered | gi|2867657404|gb|CP174607.1| | 3383025 | g32095 | i0 | 88.213 | 183.232558139535 | 263 | 22 | 100 | 9 | 1 | 258 | 1292298 | 1292556 | Peredibacter sp. HCB2-198 chromosome, complete genome | blastn | 47274 | 305 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Peredibacter | Peredibacter sp. HCB2-198 | ||
| 26837361 | 26837361 | PRJNA1022139_P_NODE_24461_length_286_cov_2.892019_g24356_i0 | PRJNA1022139 | 24461 | 286 | 2.892019 | 8.27117434 | Bacteria | 2 | Bacteria | Bacteria | 66.6 | 1.86e-10 | NR | MFN8791299.1 | 2053517 | g24356 | i0 | 52.9 | 8.89510489510489 | 70 | 32 | 73.4 | 1 | 1 | 210 | 32 | 100 | MFN8791299.1 DnaJ C-terminal domain-containing protein [Bdellovibrionales bacterium] | diamond | 2544 | 67 | 0.994029850746269 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27034926 | 27034926 | PRJNA1022139_P_NODE_32122_length_258_cov_2.464865_g32017_i0 | PRJNA1022139 | 32122 | 258 | 2.464865 | 6.3593517 | Bacteriovorax sp. | 2608087 | Bacteria | Bacteria | 112 | 5.2e-27 | NR | MBC7539925.1 | 2608087 | g32017 | i0 | 64.6 | 3.7093023255814 | 79 | 28 | 91.9 | 0 | 240 | 4 | 129 | 207 | MBC7539925.1 glutamine synthetase [Bacteriovorax sp.] | diamond | 957 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax sp. | ||
| 27540559 | 27540559 | PRJNA1022139_P_NODE_16304_length_341_cov_2.074627_g16199_i0 | PRJNA1022139 | 16304 | 341 | 2.074627 | 7.07447807 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 110 | 1.26e-27 | NR | MCB0369154.1 | 2053517 | g16199 | i0 | 58 | 1.69794721407625 | 100 | 35 | 88 | 3 | 14 | 313 | 3 | 95 | MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium] | diamond | 579 | 110 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27730275 | 27730275 | PRJNA1022139_P_NODE_30444_length_265_cov_1.604167_g30339_i0 | PRJNA1022139 | 30444 | 265 | 1.604167 | 4.25104255 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 126 | 3.9e-34 | NR | PZP55032.1 | 349221 | g30339 | i0 | 74 | 0.871698113207547 | 77 | 20 | 87.2 | 0 | 6 | 236 | 149 | 225 | PZP55032.1 MAG: orotate phosphoribosyltransferase [Micavibrio aeruginosavorus] | diamond | 231 | 126 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 27887720 | 27887720 | PRJNA1022139_P_NODE_32585_length_257_cov_1.255435_g32480_i0 | PRJNA1022139 | 32585 | 257 | 1.255435 | 3.22646795 | Bacteriovoracales bacterium | 2497611 | Bacteria | Bacteria | 54.3 | 9.27e-7 | NR | MFI5391501.1 | 2497611 | g32480 | i0 | 56.1 | 0.478599221789883 | 41 | 14 | 43.2 | 1 | 112 | 2 | 48 | 88 | MFI5391501.1 phospholipase A2 [Bacteriovoracales bacterium] | diamond | 123 | 54.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracales bacterium | ||||
| 28645726 | 28645726 | PRJNA1022139_P_NODE_30067_length_266_cov_3.968912_g29962_i0 | PRJNA1022139 | 30067 | 266 | 3.968912 | 10.55730592 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 53.9 | 5.41e-6 | NR | MBF0311945.1 | 2599941 | g29962 | i0 | 45.6 | 0.766917293233083 | 68 | 33 | 72.2 | 3 | 72 | 263 | 1 | 68 | MBF0311945.1 SPASM domain-containing protein [Oligoflexia bacterium] | diamond | 204 | 53.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 29245526 | 29245526 | PRJNA1022139_P_NODE_2129_length_842_cov_3.031209_g2047_i0 | PRJNA1022139 | 2129 | 842 | 3.031209 | 25.52277978 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 375 | 1.64e-129 | NR | MBX9767865.1 | 2053517 | g2047 | i0 | 90.5 | 0.716152019002375 | 201 | 19 | 71.6 | 0 | 206 | 808 | 1 | 201 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 603 | 375 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29308581 | 29308581 | PRJNA1022139_P_NODE_43409_length_237_cov_2.262195_g43304_i0 | PRJNA1022139 | 43409 | 237 | 2.262195 | 5.36140215 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 58.9 | 1.2e-8 | NR | MCB0368043.1 | 2053517 | g43304 | i0 | 70 | 0.506329113924051 | 40 | 12 | 50.6 | 0 | 1 | 120 | 110 | 149 | MCB0368043.1 50S ribosomal protein L4 [Bdellovibrionales bacterium] | diamond | 120 | 58.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29782225 | 29782225 | PRJNA1022139_P_NODE_2051_length_856_cov_3.162197_g1970_i0 | PRJNA1022139 | 2051 | 856 | 3.162197 | 27.06840632 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 69.3 | 2.58e-9 | NR | MEK6627027.1 | 3034175 | g1970 | i0 | 36.8 | 0.371495327102804 | 106 | 66 | 37.1 | 1 | 319 | 2 | 61 | 165 | MEK6627027.1 alkaline phosphatase family protein [Bdellovibrionota bacterium] | diamond | 318 | 69.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 29877110 | 29877110 | PRJNA1022139_P_NODE_30631_length_264_cov_2.015707_g30526_i0 | PRJNA1022139 | 30631 | 264 | 2.015707 | 5.32146648 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 89.4 | 3.96e-19 | NR | MCB0369784.1 | 2053517 | g30526 | i0 | 56.5 | 0.965909090909091 | 85 | 35 | 96.6 | 1 | 8 | 262 | 88 | 170 | MCB0369784.1 insulinase family protein [Bdellovibrionales bacterium] | diamond | 255 | 89.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30098060 | 30098060 | PRJNA1022139_P_NODE_36192_length_249_cov_0.875000_g36087_i0 | PRJNA1022139 | 36192 | 249 | 0.875 | 2.17875 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 75.1 | 1.09e-15 | NR | MCB0371200.1 | 2053517 | g36087 | i0 | 71.7 | 1.51807228915663 | 60 | 13 | 72.3 | 1 | 211 | 32 | 15 | 70 | MCB0371200.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 378 | 75.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30659006 | 30659006 | PRJNA1022139_P_NODE_12753_length_378_cov_2.268852_g12648_i0 | PRJNA1022139 | 12753 | 378 | 2.268852 | 8.57626056 | Bacteria | 2 | Bacteria | Bacteria | 62 | 9.58e-10 | NR | PWU12825.1 | 28201 | g12648 | i0 | 45.8 | 9 | 59 | 32 | 46.8 | 0 | 1 | 177 | 27 | 85 | PWU12825.1 MAG: 30S ribosomal protein S15 [Bdellovibrio sp.] | diamond | 3402 | 62 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 31195765 | 31195765 | PRJNA1022139_P_NODE_27555_length_276_cov_1.019704_g27450_i0 | PRJNA1022139 | 27555 | 276 | 1.019704 | 2.81438304 | Bdellovibrio | 958 | Bacteria | Bacteria | 48.5 | 4.98e-4 | NR | MEI7974133.1 | 28201 | g27450 | i0 | 61.3 | 0.673913043478261 | 31 | 12 | 33.7 | 0 | 2 | 94 | 529 | 559 | MEI7974133.1 peptide ABC transporter substrate-binding protein [Bdellovibrio sp.] | diamond | 186 | 48.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 31267287 | 31267287 | PRJNA1022139_P_NODE_39935_length_244_cov_2.257310_g39830_i0 | PRJNA1022139 | 39935 | 244 | 2.25731 | 5.5078364 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 62.8 | 4.69e-11 | NR | MCB0369687.1 | 2053517 | g39830 | i0 | 53.3 | 0.55327868852459 | 45 | 21 | 55.3 | 0 | 37 | 171 | 4 | 48 | MCB0369687.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 135 | 62.8 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31552162 | 31552162 | PRJNA1022139_P_NODE_3556_length_668_cov_2.077311_g3454_i0 | PRJNA1022139 | 3556 | 668 | 2.077311 | 13.87643748 | Bacteriovorax stolpii | 960 | Bacteria | Bacteria | 311 | 2.68e-103 | NR | WP_142409471.1 | 960 | g3454 | i0 | 70.9 | 2.87874251497006 | 213 | 62 | 95.7 | 0 | 28 | 666 | 3 | 215 | WP_142409471.1 adenosine kinase [Bacteriovorax stolpii] | diamond | 1923 | 311 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax stolpii | ||
| 31552171 | 31552171 | PRJNA1022139_P_NODE_39696_length_245_cov_0.895349_g39591_i0 | PRJNA1022139 | 39696 | 245 | 0.895349 | 2.19360505 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 103 | 1.81e-23 | NR | MBS1971215.1 | 2053517 | g39591 | i0 | 59.5 | 0.96734693877551 | 79 | 32 | 96.7 | 0 | 241 | 5 | 43 | 121 | MBS1971215.1 acyl-CoA dehydrogenase family protein [Bdellovibrionales bacterium] | diamond | 237 | 103 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32184772 | 32184772 | PRJNA1022139_P_NODE_4398_length_610_cov_2.422719_g4294_i0 | PRJNA1022139 | 4398 | 610 | 2.422719 | 14.7785859 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 109 | 2.1e-26 | NR | WP_324954760.1 | 1971216 | g4294 | i0 | 42.5 | 0.752459016393443 | 153 | 42 | 73.8 | 3 | 3 | 452 | 41 | 150 | WP_324954760.1 hypothetical protein [Oligoflexus sp.] | diamond | 459 | 109 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 32303652 | 32303652 | PRJNA1022139_P_NODE_14479_length_359_cov_1.076923_g14374_i0 | PRJNA1022139 | 14479 | 359 | 1.076923 | 3.86615357 | root | 1 | Root_unresolved | Root_unresolved | 80.1 | 1.15e-14 | NR | MBC7741559.1 | 28201 | g14374 | i0 | 38.5 | 3.26740947075209 | 96 | 57 | 78.6 | 2 | 3 | 284 | 118 | 213 | MBC7741559.1 aminopeptidase N [Bdellovibrio sp.] | diamond | 1173 | 80.9 | 0.990111248454882 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 32721800 | 32721800 | PRJNA1022139_P_NODE_41040_length_243_cov_0.905882_g40935_i0 | PRJNA1022139 | 41040 | 243 | 0.905882 | 2.20129326 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 45.4 | 0.00403 | NR | MEK6623678.1 | 3034175 | g40935 | i0 | 35.7 | 0.691358024691358 | 56 | 36 | 69.1 | 0 | 62 | 229 | 26 | 81 | MEK6623678.1 hypothetical protein [Bdellovibrionota bacterium] | diamond | 168 | 45.4 | 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);;