contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 211082 | 211082 | PRJNA1098727_P_NODE_11861_length_175_cov_1.595238_g11620_i0 | PRJNA1098727 | 11861 | 175 | 1.595238 | 2.7916665 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 100 | 1.1e-23 | NR | MCX6858354.1 | 2026799 | g11620 | i0 | 90.7 | 0.925714285714286 | 54 | 5 | 92.6 | 0 | 170 | 9 | 244 | 297 | MCX6858354.1 site-specific integrase [Verrucomicrobiota bacterium] | diamond | 162 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 11689822 | 11689822 | PRJNA1098727_P_NODE_13830_length_166_cov_1.641026_g13589_i0 | PRJNA1098727 | 13830 | 166 | 1.641026 | 2.72410316 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 103 | 6.77e-24 | NR | MBJ7390783.1 | 2201154 | g13589 | i0 | 89.1 | 4.95180722891566 | 55 | 6 | 99.4 | 0 | 165 | 1 | 548 | 602 | MBJ7390783.1 polyphosphate kinase 1 [Chthoniobacterales bacterium] | diamond | 822 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 16788209 | 16788209 | PRJNA1098727_P_NODE_13234_length_168_cov_0.873950_g12993_i0 | PRJNA1098727 | 13234 | 168 | 0.87395 | 1.468236 | Prosthecobacter | 48463 | Bacteria | Bacteria | 106 | 5.74e-25 | NR | WP_395717326.1 | 1965333 | g12993 | i0 | 98.2 | 12 | 56 | 1 | 100 | 0 | 168 | 1 | 346 | 401 | WP_395717326.1 cbb3-type cytochrome c oxidase subunit I [Prosthecobacter sp.] | diamond | 2016 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27415562 | 27415562 | PRJNA1098727_P_NODE_11483_length_178_cov_1.604651_g11242_i0 | PRJNA1098727 | 11483 | 178 | 1.604651 | 2.85627878 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 53.9 | 1.98e-7 | NR | MAD25766.1 | 2026801 | g11242 | i0 | 65.6 | 1.07865168539326 | 32 | 11 | 53.9 | 0 | 97 | 2 | 2 | 33 | MAD25766.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 192 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28322233 | 28322233 | PRJNA1098727_P_NODE_15386_length_163_cov_0.912281_g15145_i0 | PRJNA1098727 | 15386 | 163 | 0.912281 | 1.48701803 | Prosthecobacter | 48463 | Bacteria | Bacteria | 104 | 9.05e-25 | NR | WP_184340206.1 | 48466 | g15145 | i0 | 94.4 | 4.96932515337423 | 54 | 3 | 99.4 | 0 | 162 | 1 | 279 | 332 | WP_184340206.1 homoserine dehydrogenase [Prosthecobacter vanneervenii] | diamond | 810 | 105 | 0.990476190476191 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 28646800 | 28646800 | PRJNA1098727_P_NODE_14727_length_164_cov_0.904348_g14486_i0 | PRJNA1098727 | 14727 | 164 | 0.904348 | 1.48313072 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 63.9 | 3.62e-10 | NR | MEY2543526.1 | 2026799 | g14486 | i0 | 57.1 | 3.20121951219512 | 42 | 18 | 76.8 | 0 | 147 | 22 | 5 | 46 | MEY2543526.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 525 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28741417 | 28741417 | PRJNA1098727_P_NODE_13207_length_168_cov_0.873950_g12966_i0 | PRJNA1098727 | 13207 | 168 | 0.87395 | 1.468236 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 92 | 4.8e-20 | NR | MEX1010352.1 | 2201154 | g12966 | i0 | 83.6 | 3.92857142857143 | 55 | 9 | 98.2 | 0 | 165 | 1 | 325 | 379 | MEX1010352.1 NAD(P)/FAD-dependent oxidoreductase [Chthoniobacterales bacterium] | diamond | 660 | 92 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29120530 | 29120530 | PRJNA1098727_P_NODE_14569_length_165_cov_0.870690_g14328_i0 | PRJNA1098727 | 14569 | 165 | 0.87069 | 1.4366385 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 72 | 4.85e-13 | NR | GDX11140.1 | 2026799 | g14328 | i0 | 58.5 | 0.963636363636364 | 53 | 22 | 96.4 | 0 | 165 | 7 | 180 | 232 | GDX11140.1 hypothetical protein LBMAG57_29120 [Verrucomicrobiota bacterium] | diamond | 159 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29467280 | 29467280 | PRJNA1098727_P_NODE_14030_length_166_cov_0.888889_g13789_i0 | PRJNA1098727 | 14030 | 166 | 0.888889 | 1.47555574 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 106 | 5.66e-25 | NR | MCU0776801.1 | 2562705 | g13789 | i0 | 87.3 | 0.993975903614458 | 55 | 7 | 99.4 | 0 | 2 | 166 | 489 | 543 | MCU0776801.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 165 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 29719947 | 29719947 | PRJNA1098727_P_NODE_15270_length_163_cov_0.912281_g15029_i0 | PRJNA1098727 | 15270 | 163 | 0.912281 | 1.48701803 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 95.1 | 1.08e-22 | NR | MFM8810043.1 | 2201154 | g15029 | i0 | 88.7 | 3.90184049079755 | 53 | 6 | 97.5 | 0 | 1 | 159 | 2 | 54 | MFM8810043.1 exosortase/archaeosortase family protein [Chthoniobacterales bacterium] | diamond | 636 | 95.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 30280567 | 30280567 | PRJNA1098727_P_NODE_15372_length_163_cov_0.912281_g15131_i0 | PRJNA1098727 | 15372 | 163 | 0.912281 | 1.48701803 | Prosthecobacter | 48463 | Bacteria | Bacteria | 100 | 5.77e-23 | NR | WP_322278807.1 | 1965333 | g15131 | i0 | 96.2 | 1.95092024539877 | 53 | 2 | 97.5 | 0 | 160 | 2 | 1259 | 1311 | WP_322278807.1 PVC-type heme-binding CxxCH protein [Prosthecobacter sp.] | diamond | 318 | 101 | 0.99009900990099 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30731114 | 30731114 | PRJNA1098727_P_NODE_13034_length_168_cov_1.588235_g12793_i0 | PRJNA1098727 | 13034 | 168 | 1.588235 | 2.6682348 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 107 | 2.14e-26 | NR | MEZ5385044.1 | 1965333 | g12793 | i0 | 94.5 | 0.982142857142857 | 55 | 3 | 98.2 | 0 | 4 | 168 | 206 | 260 | MEZ5385044.1 polysaccharide deacetylase family protein [Prosthecobacter sp.] | diamond | 165 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 31711178 | 31711178 | PRJNA1098727_P_NODE_11977_length_174_cov_1.608000_g11736_i0 | PRJNA1098727 | 11977 | 174 | 1.608 | 2.79792 | Ereboglobus luteus | 1796921 | Bacteria | Bacteria | 68.6 | 1.13e-11 | NR | WP_108825712.1 | 1796921 | g11736 | i0 | 63.2 | 9.48275862068965 | 57 | 21 | 98.3 | 0 | 173 | 3 | 73 | 129 | WP_108825712.1 M48 family metallopeptidase [Ereboglobus luteus] | diamond | 1650 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Ereboglobus | Ereboglobus luteus | |
| 31837484 | 31837484 | PRJNA1098727_P_NODE_15557_length_162_cov_1.592920_g15316_i0 | PRJNA1098727 | 15557 | 162 | 1.59292 | 2.5805304 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 61.6 | 4.94e-10 | NR | MCX6966096.1 | 2026799 | g15316 | i0 | 60.4 | 1.77777777777778 | 48 | 19 | 88.9 | 0 | 161 | 18 | 107 | 154 | MCX6966096.1 helicase-related protein [Verrucomicrobiota bacterium] | diamond | 288 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31932511 | 31932511 | PRJNA1098727_P_NODE_14477_length_165_cov_0.896552_g14236_i0 | PRJNA1098727 | 14477 | 165 | 0.896552 | 1.4793108 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 86.3 | 6.11e-18 | NR | MBJ7391054.1 | 2201154 | g14236 | i0 | 79.6 | 0.981818181818182 | 54 | 11 | 98.2 | 0 | 162 | 1 | 753 | 806 | MBJ7391054.1 excinuclease ABC subunit UvrA [Chthoniobacterales bacterium] | diamond | 162 | 86.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32344170 | 32344170 | PRJNA1098727_P_NODE_13139_length_168_cov_0.873950_g12898_i0 | PRJNA1098727 | 13139 | 168 | 0.87395 | 1.468236 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 79.7 | 2.67e-16 | NR | MEZ5384735.1 | 1965333 | g12898 | i0 | 92.3 | 0.696428571428571 | 39 | 3 | 69.6 | 0 | 3 | 119 | 214 | 252 | MEZ5384735.1 glycosyltransferase family 2 protein [Prosthecobacter sp.] | diamond | 117 | 79.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32628204 | 32628204 | PRJNA1098727_P_NODE_5600_length_268_cov_0.940639_g5359_i0 | PRJNA1098727 | 5600 | 268 | 0.940639 | 2.52091252 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 154 | 4.76e-44 | NR | MBJ7390203.1 | 2201154 | g5359 | i0 | 86.6 | 4.58955223880597 | 82 | 11 | 91.8 | 0 | 246 | 1 | 1 | 82 | MBJ7390203.1 ring-cleaving dioxygenase [Chthoniobacterales bacterium] | diamond | 1230 | 154 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32650937 | 32650937 | PRJNA1098727_P_NODE_15160_length_163_cov_0.912281_g14919_i0 | PRJNA1098727 | 15160 | 163 | 0.912281 | 1.48701803 | Bacteria | 2 | Bacteria | Bacteria | 80.9 | 1.17e-16 | NR | NDH00700.1 | 2026771 | g14919 | i0 | 60.8 | 1.87730061349693 | 51 | 20 | 93.9 | 0 | 160 | 8 | 148 | 198 | NDH00700.1 ligase-associated DNA damage response exonuclease [Opitutia bacterium] | diamond | 306 | 81.3 | 0.995079950799508 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 32659610 | 32659610 | PRJNA1098727_P_NODE_14540_length_165_cov_0.896552_g14299_i0 | PRJNA1098727 | 14540 | 165 | 0.896552 | 1.4793108 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 85.5 | 1.09e-17 | NR | MBK8037429.1 | 2026800 | g14299 | i0 | 75.5 | 4.81818181818182 | 53 | 13 | 96.4 | 0 | 164 | 6 | 22 | 74 | MBK8037429.1 DUF1553 domain-containing protein [Verrucomicrobiaceae bacterium] | diamond | 795 | 85.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae 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);;