contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA312107" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26648460 | 26648460 | PRJNA312107_P_NODE_18961_length_169_cov_0.866667_g18795_i0 | PRJNA312107 | 18961 | 169 | 0.866667 | 1.46466723 | Bdellovibrio | 958 | Bacteria | Bacteria | 91.7 | 6.13e-20 | NR | MBC7465026.1 | 28201 | g18795 | i0 | 75 | 4.97041420118343 | 56 | 14 | 99.4 | 0 | 169 | 2 | 269 | 324 | MBC7465026.1 DEAD/DEAH box helicase [Bdellovibrio sp.] | diamond | 840 | 91.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio sp. | ||
| 26694325 | 26694325 | PRJNA312107_P_NODE_24961_length_163_cov_0.912281_g24795_i0 | PRJNA312107 | 24961 | 163 | 0.912281 | 1.48701803 | Halobacteriovoraceae bacterium | 2026745 | Bacteria | Bacteria | 48.5 | 7.61e-6 | NR | MAX65654.1 | 2026745 | g24795 | i0 | 46.8 | 2.61349693251534 | 47 | 25 | 86.5 | 0 | 143 | 3 | 3 | 49 | MAX65654.1 50S ribosomal protein L29 [Halobacteriovoraceae bacterium] | diamond | 426 | 48.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Halobacteriovoraceae | Halobacteriovoraceae bacterium | |||
| 26884573 | 26884573 | PRJNA312107_P_NODE_23121_length_165_cov_0.896552_g22955_i0 | PRJNA312107 | 23121 | 165 | 0.896552 | 1.4793108 | Oligoflexus sp. | 1971216 | Bacteria | Bacteria | 112 | 3.7100000000000005e-27 | NR | WP_325143496.1 | 1971216 | g22955 | i0 | 100 | 0.963636363636364 | 53 | 0 | 96.4 | 0 | 161 | 3 | 449 | 501 | WP_325143496.1 replication restart helicase PriA [Oligoflexus sp.] | diamond | 159 | 112 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexales | Oligoflexaceae | Oligoflexus | Oligoflexus sp. | ||
| 27042647 | 27042647 | PRJNA312107_P_NODE_25682_length_162_cov_0.920354_g25516_i0 | PRJNA312107 | 25682 | 162 | 0.920354 | 1.49097348 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 50.1 | 3.17e-5 | NR | MBL7716680.1 | 2053517 | g25516 | i0 | 47.1 | 0.944444444444444 | 51 | 27 | 94.4 | 0 | 161 | 9 | 391 | 441 | MBL7716680.1 hypothetical protein [Bdellovibrionales bacterium] | diamond | 153 | 50.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 27168851 | 27168851 | PRJNA312107_P_NODE_20802_length_167_cov_0.881356_g20636_i0 | PRJNA312107 | 20802 | 167 | 0.881356 | 1.47186452 | Pseudobdellovibrionaceae bacterium | 2026715 | Bacteria | Bacteria | 80.1 | 2.56e-16 | NR | HPI40480.1 | 2026715 | g20636 | i0 | 72.7 | 0.988023952095808 | 55 | 15 | 98.8 | 0 | 165 | 1 | 58 | 112 | HPI40480.1 peptidylprolyl isomerase [Pseudobdellovibrionaceae bacterium] | diamond | 165 | 80.1 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Pseudobdellovibrionaceae bacterium | |||
| 27249864 | 27249864 | PRJNA312107_P_NODE_19443_length_168_cov_1.428571_g19277_i0 | PRJNA312107 | 19443 | 168 | 1.428571 | 2.39999928 | Bacteria | 2 | Bacteria | Bacteria | 72.4 | 4.04e-13 | NR | MCO5143756.1 | 2599941 | g19277 | i0 | 79.1 | 1.53571428571429 | 43 | 9 | 76.8 | 0 | 131 | 3 | 319 | 361 | MCO5143756.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Oligoflexia bacterium] | diamond | 258 | 72.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Oligoflexia | Oligoflexia bacterium | |||||
| 27674706 | 27674706 | PRJNA312107_P_NODE_22484_length_165_cov_0.896552_g22318_i0 | PRJNA312107 | 22484 | 165 | 0.896552 | 1.4793108 | Micavibrio aeruginosavorus | 349221 | Bacteria | Bacteria | 64.7 | 2.24e-10 | NR | PZQ44255.1 | 349221 | g22318 | i0 | 59.3 | 0.981818181818182 | 54 | 22 | 98.2 | 0 | 3 | 164 | 224 | 277 | PZQ44255.1 MAG: UDP-N-acetylmuramate--alanine ligase [Micavibrio aeruginosavorus] | diamond | 162 | 64.7 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Micavibrio | Micavibrio aeruginosavorus | ||
| 27737975 | 27737975 | PRJNA312107_P_NODE_20064_length_168_cov_0.873950_g19898_i0 | PRJNA312107 | 20064 | 168 | 0.87395 | 1.468236 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 100 | 5.449999999999999e-23 | NR | NOT80326.1 | 2081706 | g19898 | i0 | 85.2 | 0.964285714285714 | 54 | 8 | 96.4 | 0 | 3 | 164 | 240 | 293 | NOT80326.1 potassium-transporting ATPase subunit KdpA [Bacteriovoracaceae bacterium] | diamond | 162 | 100 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 29554746 | 29554746 | PRJNA312107_P_NODE_24230_length_164_cov_0.895652_g24064_i0 | PRJNA312107 | 24230 | 164 | 0.895652 | 1.46886928 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 78.2 | 6.24e-16 | NR | HEX4923610.1 | 2053517 | g24064 | i0 | 64.8 | 2.96341463414634 | 54 | 19 | 98.8 | 0 | 162 | 1 | 47 | 100 | HEX4923610.1 MotA/TolQ/ExbB proton channel family protein [Bdellovibrionales bacterium] | diamond | 486 | 78.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 29789798 | 29789798 | PRJNA312107_P_NODE_21451_length_166_cov_0.888889_g21285_i0 | PRJNA312107 | 21451 | 166 | 0.888889 | 1.47555574 | Bdellovibrionales bacterium RIFOXYC1_FULL_54_43 | 1797397 | Bacteria | Bacteria | 97.4 | 5.04e-23 | NR | OFZ52880.1 | 1797397 | g21285 | i0 | 87 | 0.975903614457831 | 54 | 7 | 97.6 | 0 | 163 | 2 | 1 | 54 | OFZ52880.1 MAG: flagellar basal-body rod protein FlgG [Bdellovibrionales bacterium RIFOXYC1_FULL_54_43] | diamond | 162 | 97.4 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium RIFOXYC1_FULL_54_43 | ||||
| 29979460 | 29979460 | PRJNA312107_P_NODE_23231_length_165_cov_0.896552_g23065_i0 | PRJNA312107 | 23231 | 165 | 0.896552 | 1.4793108 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 108 | 6.13e-26 | NR | MBX3021641.1 | 2053517 | g23065 | i0 | 94.4 | 2.94545454545455 | 54 | 3 | 98.2 | 0 | 164 | 3 | 350 | 403 | MBX3021641.1 DNA-directed RNA polymerase subunit beta [Bdellovibrionales bacterium] | diamond | 486 | 108 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30042621 | 30042621 | PRJNA312107_P_NODE_26291_length_162_cov_0.920354_g26125_i0 | PRJNA312107 | 26291 | 162 | 0.920354 | 1.49097348 | Bdellovibrionales bacterium | 2053517 | Bacteria | Bacteria | 41.2 | 0.0418 | NR | NUM88476.1 | 2053517 | g26125 | i0 | 41 | 0.722222222222222 | 39 | 23 | 72.2 | 0 | 145 | 29 | 102 | 140 | NUM88476.1 glycosyltransferase [Bdellovibrionales bacterium] | diamond | 117 | 41.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30264130 | 30264130 | PRJNA312107_P_NODE_18952_length_169_cov_0.866667_g18786_i0 | PRJNA312107 | 18952 | 169 | 0.866667 | 1.46466723 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 80.5 | 1.94e-16 | NR | MEO5669010.1 | 3034175 | g18786 | i0 | 76.1 | 0.816568047337278 | 46 | 11 | 81.7 | 0 | 25 | 162 | 37 | 82 | MEO5669010.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Bdellovibrionota bacterium] | diamond | 138 | 80.5 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 30628719 | 30628719 | PRJNA312107_P_NODE_19053_length_169_cov_0.866667_g18887_i0 | PRJNA312107 | 19053 | 169 | 0.866667 | 1.46466723 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 91.3 | 1.04e-19 | NR | MCB0407548.1 | 2053517 | g18887 | i0 | 73.2 | 2.98224852071006 | 56 | 15 | 99.4 | 0 | 1 | 168 | 218 | 273 | MCB0407548.1 acyl-CoA dehydrogenase [Bdellovibrionales bacterium] | diamond | 504 | 91.3 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 30959022 | 30959022 | PRJNA312107_P_NODE_21454_length_166_cov_0.888889_g21288_i0 | PRJNA312107 | 21454 | 166 | 0.888889 | 1.47555574 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 66.6 | 4.95e-11 | NR | MES2855834.1 | 3034175 | g21288 | i0 | 54.7 | 0.957831325301205 | 53 | 24 | 95.8 | 0 | 7 | 165 | 488 | 540 | MES2855834.1 DUF3857 domain-containing protein [Bdellovibrionota bacterium] | diamond | 159 | 66.6 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31008127 | 31008127 | PRJNA312107_P_NODE_25834_length_162_cov_0.920354_g25668_i0 | PRJNA312107 | 25834 | 162 | 0.920354 | 1.49097348 | Bdellovibrio | 958 | Bacteria | Bacteria | 73.9 | 1.02e-13 | NR | WP_061835465.1 | 959 | g25668 | i0 | 61.1 | 3.01851851851852 | 54 | 21 | 100 | 0 | 1 | 162 | 149 | 202 | WP_061835465.1 cyclic nucleotide-binding domain-containing protein [Bdellovibrio bacteriovorus] | diamond | 489 | 73.9 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Pseudobdellovibrionaceae | Bdellovibrio | Bdellovibrio bacteriovorus | ||
| 31717779 | 31717779 | PRJNA312107_P_NODE_21157_length_167_cov_0.881356_g20991_i0 | PRJNA312107 | 21157 | 167 | 0.881356 | 1.47186452 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 78.2 | 3.82e-15 | NR | MEK6706183.1 | 3034175 | g20991 | i0 | 59.3 | 0.970059880239521 | 54 | 22 | 97 | 0 | 3 | 164 | 142 | 195 | MEK6706183.1 MFS transporter [Bdellovibrionota bacterium] | diamond | 162 | 78.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionota bacterium | ||||||
| 31875775 | 31875775 | PRJNA312107_P_NODE_23657_length_164_cov_0.904348_g23491_i0 | PRJNA312107 | 23657 | 164 | 0.904348 | 1.48313072 | Bacteriovoracaceae bacterium | 2081706 | Bacteria | Bacteria | 56.2 | 7.27e-8 | NR | MCM2351162.1 | 2081706 | g23491 | i0 | 51.9 | 0.98780487804878 | 54 | 26 | 98.8 | 0 | 164 | 3 | 79 | 132 | MCM2351162.1 hypothetical protein [Bacteriovoracaceae bacterium] | diamond | 162 | 56.2 | 1 | Bacteria | Pseudomonadati | Bdellovibrionota | Bacteriovoracia | Bacteriovoracales | Bacteriovoracaceae | Bacteriovoracaceae bacterium | |||
| 32494872 | 32494872 | PRJNA312107_P_NODE_19739_length_168_cov_0.873950_g19573_i0 | PRJNA312107 | 19739 | 168 | 0.87395 | 1.468236 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 107 | 5.190000000000001e-27 | NR | MBA2405567.1 | 2053517 | g19573 | i0 | 85.7 | 3 | 56 | 8 | 100 | 0 | 1 | 168 | 116 | 171 | MBA2405567.1 type I methionyl aminopeptidase [Bdellovibrionales bacterium] | diamond | 504 | 108 | 0.990740740740741 | Bacteria | Pseudomonadati | Bdellovibrionota | Bdellovibrionia | Bdellovibrionales | Bdellovibrionales bacterium | ||||
| 32572211 | 32572211 | PRJNA312107_P_NODE_22959_length_165_cov_0.896552_g22793_i0 | PRJNA312107 | 22959 | 165 | 0.896552 | 1.4793108 | Bdellovibrionota bacterium | 3034175 | Bacteria | Bacteria | 93.2 | 1.83e-22 | NR | MEK6628179.1 | 3034175 | g22793 | i0 | 72.7 | 1 | 55 | 15 | 100 | 0 | 165 | 1 | 13 | 67 | MEK6628179.1 EVE domain-containing protein [Bdellovibrionota bacterium] | diamond | 165 | 93.2 | 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);;