contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18863683 | 18863683 | PRJNA1063685_S_NODE_65075_length_264_cov_1.219895_g64532_i0 | PRJNA1063685 | 65075 | 264 | 1.219895 | 3.2205228 | Micavibrio | 213485 | Bacteria | Bacteria | 160 | 6.58e-44 | NR | PZQ48645.1 | 349221 | g64532 | i0 | 87.4 | 2.96590909090909 | 87 | 11 | 98.9 | 0 | 3 | 263 | 403 | 489 | PZQ48645.1 MAG: threonine--tRNA ligase [Micavibrio aeruginosavorus] | diamond | 783 | 160 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 23964485 | 23964485 | PRJNA1063685_S_NODE_54319_length_301_cov_0.916667_g53776_i0 | PRJNA1063685 | 54319 | 301 | 0.916667 | 2.75916767 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 154 | 1.3799999999999999e-43 | NR | HEU4839683.1 | 2024841 | g53776 | i0 | 73.7 | 4.93355481727575 | 99 | 26 | 98.7 | 0 | 299 | 3 | 125 | 223 | HEU4839683.1 anthranilate phosphoribosyltransferase [Micavibrio sp.] | diamond | 1485 | 154 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 26750196 | 26750196 | PRJNA1063685_S_NODE_35741_length_392_cov_1.175549_g35198_i0 | PRJNA1063685 | 35741 | 392 | 1.175549 | 4.60815208 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 171 | 1.3e-48 | NR | PZO88774.1 | 349221 | g35198 | i0 | 70.8 | 0.994897959183674 | 130 | 38 | 99.5 | 0 | 2 | 391 | 194 | 323 | PZO88774.1 MAG: MATE family efflux transporter [Micavibrio aeruginosavorus] | diamond | 390 | 171 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 26972104 | 26972104 | PRJNA1063685_S_NODE_1622_length_965_cov_11.110987_g1327_i0 | PRJNA1063685 | 1622 | 965 | 11.110987 | 107.22102455 | Silvanigrellaceae bacterium | 2654442 | Bacteria | Bacteria | 173 | 2.04e-50 | NR | MBX9702949.1 | 2654442 | g1327 | i0 | 70.7 | 0.382383419689119 | 123 | 35 | 38.2 | 1 | 538 | 170 | 1 | 122 | MBX9702949.1 hypothetical protein [Silvanigrellaceae bacterium] | diamond | 369 | 173 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Silvanigrellales | Silvanigrellaceae | Silvanigrellaceae bacterium | |||
| 27383274 | 27383274 | PRJNA1063685_S_NODE_18163_length_528_cov_2.026374_g17627_i0 | PRJNA1063685 | 18163 | 528 | 2.026374 | 10.69925472 | Bacteriovorax antarcticus | 3088717 | Bacteria | Bacteria | 160 | 5.02e-42 | NR | WP_323577870.1 | 3088717 | g17627 | i0 | 54 | 0.914772727272727 | 161 | 66 | 91.5 | 3 | 487 | 5 | 1020 | 1172 | WP_323577870.1 serine hydrolase [Bacteriovorax antarcticus] | diamond | 483 | 160 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax antarcticus | ||
| 27415069 | 27415069 | PRJNA1063685_S_NODE_9183_length_642_cov_2.300527_g8674_i0 | PRJNA1063685 | 9183 | 642 | 2.300527 | 14.76938334 | Oligoflexaceae bacterium | 2957744 | Bacteria | Bacteria | 46.6 | 0.0167 | NR | MDA9950979.1 | 2957744 | g8674 | i0 | 46.3 | 0.191588785046729 | 41 | 22 | 19.2 | 0 | 629 | 507 | 134 | 174 | MDA9950979.1 response regulator [Oligoflexaceae bacterium] | diamond | 123 | 46.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexaceae bacterium | |||
| 27541172 | 27541172 | PRJNA1063685_S_NODE_37224_length_383_cov_4.877419_g36681_i0 | PRJNA1063685 | 37224 | 383 | 4.877419 | 18.68051477 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 67 | 3.99e-11 | NR | MFA5592324.1 | 2024841 | g36681 | i0 | 54.5 | 0.830287206266319 | 66 | 22 | 51.7 | 1 | 199 | 2 | 64 | 121 | MFA5592324.1 peptidoglycan-binding domain-containing protein [Micavibrio sp.] | diamond | 318 | 67 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 28583169 | 28583169 | PRJNA1063685_S_NODE_65427_length_263_cov_1.342105_g64884_i0 | PRJNA1063685 | 65427 | 263 | 1.342105 | 3.52973615 | Pseudobdellovibrio sp. HCB154 | 3386277 | Bacteria | Bacteria | 124 | 1.46e-33 | NR | WP_409479636.1 | 3386277 | g64884 | i0 | 63.3 | 2.90874524714829 | 90 | 24 | 92.4 | 1 | 258 | 16 | 110 | 199 | WP_409479636.1 5-formyltetrahydrofolate cyclo-ligase [Pseudobdellovibrio sp. HCB154] | diamond | 765 | 124 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrio | Pseudobdellovibrio sp. HCB154 | ||
| 29561661 | 29561661 | PRJNA1063685_S_NODE_65990_length_261_cov_2.457447_g65447_i0 | PRJNA1063685 | 65990 | 261 | 2.457447 | 6.41393667 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 47.4 | 0.00106 | NR | MYE07237.1 | 2599941 | g65447 | i0 | 35.4 | 1.81609195402299 | 79 | 51 | 90.8 | 0 | 15 | 251 | 379 | 457 | MYE07237.1 translation initiation factor IF-2 [Oligoflexia bacterium] | diamond | 474 | 47.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 29624435 | 29624435 | PRJNA1063685_S_NODE_13810_length_576_cov_6.970179_g13287_i0 | PRJNA1063685 | 13810 | 576 | 6.970179 | 40.14823104 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 335 | 4.839999999999999e-115 | NR | MBX9767865.1 | 2053517 | g13287 | i0 | 92.7 | 0.921875 | 177 | 13 | 92.2 | 0 | 574 | 44 | 25 | 201 | MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 531 | 335 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30129923 | 30129923 | PRJNA1063685_S_NODE_10392_length_622_cov_37.686703_g9877_i0 | PRJNA1063685 | 10392 | 622 | 37.686703 | 234.41129266 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 179 | 2.08e-51 | NR | MCB0392966.1 | 2053517 | g9877 | i0 | 46.2 | 1.87138263665595 | 195 | 100 | 92.6 | 3 | 621 | 46 | 136 | 328 | MCB0392966.1 adenosine deaminase [Bdellovibrionales bacterium] | diamond | 1164 | 179 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30216723 | 30216723 | PRJNA1063685_S_NODE_11592_length_605_cov_9.866541_g11077_i0 | PRJNA1063685 | 11592 | 605 | 9.866541 | 59.69257305 | root | 1 | Root_unresolved | Root_unresolved | 132 | 2.33e-33 | NR | PIT99634.1 | 1973927 | g11077 | i0 | 46.7 | 1.51735537190083 | 152 | 79 | 74.4 | 2 | 11 | 460 | 180 | 331 | PIT99634.1 MAG: zinc-binding alcohol dehydrogenase family protein [Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34] | diamond | 918 | 132 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium CG10_big_fil_rev_8_21_14_0_10_45_34 | ||||
| 30477960 | 30477960 | PRJNA1063685_S_NODE_29233_length_434_cov_9.105263_g28691_i0 | PRJNA1063685 | 29233 | 434 | 9.105263 | 39.51684142 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 141 | 1.1e-35 | NR | PZQ47054.1 | 349221 | g28691 | i0 | 68.4 | 0.67741935483871 | 98 | 30 | 67.1 | 1 | 419 | 129 | 24 | 121 | PZQ47054.1 MAG: hypothetical protein DI551_04030 [Micavibrio aeruginosavorus] | diamond | 294 | 141 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 30635628 | 30635628 | PRJNA1063685_S_NODE_26673_length_453_cov_8.321053_g26132_i0 | PRJNA1063685 | 26673 | 453 | 8.321053 | 37.69437009 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 84.3 | 1.12e-15 | NR | MAE51158.1 | 2024841 | g26132 | i0 | 69.5 | 0.390728476821192 | 59 | 18 | 39.1 | 0 | 274 | 450 | 51 | 109 | MAE51158.1 GGDEF-domain containing protein [Micavibrio sp.] | diamond | 177 | 84.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 30762281 | 30762281 | PRJNA1063685_S_NODE_43534_length_350_cov_1.429603_g42991_i0 | PRJNA1063685 | 43534 | 350 | 1.429603 | 5.0036105 | Bacteriovorax antarcticus | 3088717 | Bacteria | Bacteria | 143 | 1.37e-39 | NR | WP_323574050.1 | 3088717 | g42991 | i0 | 91 | 0.668571428571429 | 78 | 7 | 66.9 | 0 | 349 | 116 | 197 | 274 | WP_323574050.1 Flp pilus assembly protein CpaB [Bacteriovorax antarcticus] | diamond | 234 | 143 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovorax | Bacteriovorax antarcticus | ||
| 30762293 | 30762293 | PRJNA1063685_S_NODE_73234_length_243_cov_3.282353_g72691_i0 | PRJNA1063685 | 73234 | 243 | 3.282353 | 7.97611779 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 117 | 5.13e-31 | NR | MAE51170.1 | 2024841 | g72691 | i0 | 81.5 | 0.802469135802469 | 65 | 12 | 80.2 | 0 | 47 | 241 | 1 | 65 | MAE51170.1 ribosomal subunit interface protein [Micavibrio sp.] | diamond | 195 | 117 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 30888614 | 30888614 | PRJNA1063685_S_NODE_38594_length_376_cov_1.504950_g38051_i0 | PRJNA1063685 | 38594 | 376 | 1.50495 | 5.658612 | Oligoflexia bacterium | 2599941 | Bacteria | Bacteria | 115 | 2.73e-28 | NR | MDZ4676061.1 | 2599941 | g38051 | i0 | 50 | 0.909574468085106 | 114 | 56 | 90.2 | 1 | 339 | 1 | 45 | 158 | MDZ4676061.1 adenosine deaminase [Oligoflexia bacterium] | diamond | 342 | 115 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 30983552 | 30983552 | PRJNA1063685_S_NODE_51994_length_310_cov_5.000000_g51451_i0 | PRJNA1063685 | 51994 | 310 | 5 | 15.5 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 138 | 1.85e-35 | NR | MAE51199.1 | 2024841 | g51451 | i0 | 64 | 0.967741935483871 | 100 | 35 | 96.8 | 1 | 3 | 302 | 776 | 874 | MAE51199.1 hypothetical protein [Micavibrio sp.] | diamond | 300 | 138 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 31236054 | 31236054 | PRJNA1063685_S_NODE_61035_length_276_cov_3.586207_g60492_i0 | PRJNA1063685 | 61035 | 276 | 3.586207 | 9.89793132 | Micavibrio sp. | 2024841 | Bacteria | Bacteria | 133 | 5.97e-38 | NR | MAE52192.1 | 2024841 | g60492 | i0 | 84.9 | 0.793478260869565 | 73 | 11 | 79.3 | 0 | 220 | 2 | 1 | 73 | MAE52192.1 two-component system response regulator [Micavibrio sp.] | diamond | 219 | 133 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio sp. | ||
| 31362848 | 31362848 | PRJNA1063685_S_NODE_3596_length_785_cov_13.494382_g3195_i0 | PRJNA1063685 | 3596 | 785 | 13.494382 | 105.9308987 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 116 | 7.030000000000001e-26 | NR | MBS1971917.1 | 2053517 | g3195 | i0 | 36.3 | 1.60127388535032 | 245 | 132 | 87.1 | 12 | 10 | 693 | 118 | 355 | MBS1971917.1 trypsin-like peptidase domain-containing protein [Bdellovibrionales bacterium] | diamond | 1257 | 116 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 31765552 | 31765552 | PRJNA1063685_S_NODE_52997_length_306_cov_2.042918_g52454_i0 | PRJNA1063685 | 52997 | 306 | 2.042918 | 6.25132908 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 55.1 | 2.2e-6 | NR | NRA63819.1 | 2020859 | g52454 | i0 | 34 | 5.86274509803922 | 94 | 59 | 90.2 | 2 | 26 | 301 | 90 | 182 | NRA63819.1 hypothetical protein [Pseudobacteriovorax sp.] | diamond | 1794 | 55.5 | 0.992792792792793 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Pseudobacteriovoracaceae | Pseudobacteriovorax | Pseudobacteriovorax sp. | ||
| 32722339 | 32722339 | PRJNA1063685_S_NODE_10980_length_614_cov_5.188540_g10465_i0 | PRJNA1063685 | 10980 | 614 | 5.18854 | 31.8576356 | Pigmentibacter ruber | 2683196 | Bacteria | Bacteria | 90.5 | 7.11e-20 | NR | WP_158998151.1 | 2683196 | g10465 | i0 | 52.4 | 1.62214983713355 | 84 | 40 | 41 | 0 | 524 | 273 | 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 |
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);;