RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA690124" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690124 · 20 ✖

analysis 1

  • diamond · 20 ✖

tax_clade 0

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
13423587 13423587 PRJNA690124_P_NODE_54731_length_243_cov_0.917647_g54365_i0 PRJNA690124 54731 243 0.917647 2.22988221 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 155 1.06e-45   NR NTW90624.1 2049044 g54365 i0 98.8 2 81 1 100 0 243 1 94 174 NTW90624.1 elongation factor 4 [Erysipelotrichaceae bacterium] diamond 486 155 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
22347000 22347000 PRJNA690124_P_NODE_51038_length_246_cov_0.901734_g50672_i0 PRJNA690124 51038 246 0.901734 2.21826564 Neobacillus driksii 3035913 Bacteria Bacteria 91.7 3.45e-21   NR WP_306075567.1 3035913 g50672 i0 97.8 0.560975609756098 46 1 56.1 0 138 1 1 46 WP_306075567.1 thiol peroxidase [Neobacillus driksii] diamond 138 91.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus driksii
26702339 26702339 PRJNA690124_P_NODE_49841_length_247_cov_0.896552_g49475_i0 PRJNA690124 49841 247 0.896552 2.21448344 Paenibacillus chitinolyticus 79263 Bacteria Bacteria 45.4 5.78e-4   NR WP_317953505.1 79263 g49475 i0 50 1.12955465587045 44 22 53.4 0 114 245 10 53 WP_317953505.1 acyl carrier protein [Paenibacillus chitinolyticus] diamond 279 45.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus chitinolyticus
26702341 26702341 PRJNA690124_P_NODE_51121_length_246_cov_0.901734_g50755_i0 PRJNA690124 51121 246 0.901734 2.21826564 Paenibacillus elgii 189691 Bacteria Bacteria 72 1.86e-12   NR WP_251598501.1 189691 g50755 i0 43 3.90243902439024 79 45 96.3 0 237 1 69 147 WP_251598501.1 contractile injection system protein, VgrG/Pvc8 family [Paenibacillus elgii] diamond 960 72 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus elgii
26713745 26713745 PRJNA690124_P_NODE_44801_length_252_cov_0.871508_g44435_i0 PRJNA690124 44801 252 0.871508 2.19620016 Bacillota 1239 Bacteria Bacteria 103 5.0799999999999996e-24   NR WP_331892576.1 1506 g44435 i0 61.7 11.5595238095238 81 30 95.2 1 248 9 199 279 WP_331892576.1 IS1182 family transposase, partial [Clostridium sp.] diamond 2913 103 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
27303765 27303765 PRJNA690124_P_NODE_43723_length_253_cov_0.866667_g43357_i0 PRJNA690124 43723 253 0.866667 2.19266751 Vallitaleaceae bacterium 9-2 3039680 Bacteria Bacteria 110 2.3700000000000003e-27   NR WZL82767.1 3039680 g43357 i0 63.5 4.9802371541502 85 30 99.6 1 253 2 18 102 WZL82767.1 VanW family protein [Vallitaleaceae bacterium 9-2] diamond 1260 110 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Vallitaleaceae   Vallitaleaceae bacterium 9-2
27378562 27378562 PRJNA690124_P_NODE_25423_length_326_cov_1.055336_g25057_i0 PRJNA690124 25423 326 1.055336 3.44039536 root 1 Root_unresolved Root_unresolved 84.3 8.89e-19   NR MDK0897247.1 1502 g25057 i0 75.8 1.71165644171779 62 15 57.1 0 1 186 4 65 MDK0897247.1 hypothetical protein [Clostridium perfringens] diamond 558 84.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
27504823 27504823 PRJNA690124_P_NODE_34323_length_283_cov_1.895238_g33957_i0 PRJNA690124 34323 283 1.895238 5.36352354 Bacteria 2 Bacteria Bacteria 53.9 7.04e-6   NR MDK2926074.1 1879010 g33957 i0 42.9 1.57950530035336 84 42 84.8 2 40 279 172 253 MDK2926074.1 two-component system, OmpR family, sensor histidine kinase ResE [Bacillota bacterium] diamond 447 53.9 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
28566615 28566615 PRJNA690124_P_NODE_44147_length_252_cov_1.173184_g43781_i0 PRJNA690124 44147 252 1.173184 2.95642368 Clostridiales bacterium 1898207 Bacteria Bacteria 119 2.25e-30   NR MCI6435032.1 1898207 g43781 i0 75.9 0.988095238095238 83 20 98.8 0 2 250 78 160 MCI6435032.1 sporulation integral membrane protein YtvI [Clostridiales bacterium] diamond 249 119 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28736054 28736054 PRJNA690124_P_NODE_43527_length_253_cov_0.866667_g43161_i0 PRJNA690124 43527 253 0.866667 2.19266751 Bacillota 1239 Bacteria Bacteria 48.9 5.95e-5   NR WP_109998851.1 44249 g43161 i0 95.8 2.85770750988142 24 1 28.5 0 72 1 1 24 WP_109998851.1 MULTISPECIES: hypothetical protein [Paenibacillus] diamond 723 49.3 0.991886409736308 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus  
29072032 29072032 PRJNA690124_P_NODE_50408_length_247_cov_0.896552_g50042_i0 PRJNA690124 50408 247 0.896552 2.21448344 Selenomonas sp. 2053611 Bacteria Bacteria 69.7 5.86e-12   NR MCH3960190.1 2053611 g50042 i0 42 1.84615384615385 69 38 83.8 2 37 243 143 209 MCH3960190.1 CRISPR system precrRNA processing endoribonuclease RAMP protein Cas6 [Selenomonas sp.] diamond 456 69.7 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Selenomonadaceae Selenomonas Selenomonas sp.
29209741 29209741 PRJNA690124_P_NODE_45349_length_251_cov_0.876404_g44983_i0 PRJNA690124 45349 251 0.876404 2.19977404 Alkalihalobacterium 2893050 Bacteria Bacteria 156 5.38e-45   NR WP_078429032.1 427920 g44983 i0 91.6 1.9840637450199201 83 7 99.2 0 2 250 132 214 WP_078429032.1 hydroxymethylglutaryl-CoA lyase [Alkalihalobacterium alkalinitrilicum] diamond 498 157 0.993630573248408 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Alkalihalobacterium Alkalihalobacterium alkalinitrilicum
29513723 29513723 PRJNA690124_P_NODE_53510_length_244_cov_0.912281_g53144_i0 PRJNA690124 53510 244 0.912281 2.22596564 Propionispora sp. 2/2-37 1677858 Bacteria Bacteria 68.6 3.07e-11   NR WP_054260664.1 1677858 g53144 i0 44.4 3.98360655737705 81 40 99.6 1 1 243 428 503 WP_054260664.1 DNA topoisomerase 3 [Propionispora sp. 2/2-37] diamond 972 68.6 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Propionispora Propionispora sp. 2/2-37
29893026 29893026 PRJNA690124_P_NODE_44011_length_252_cov_1.441341_g43645_i0 PRJNA690124 44011 252 1.441341 3.63217932 Clostridiales bacterium 1898207 Bacteria Bacteria 98.2 8.9e-23   NR NLM61000.1 1898207 g43645 i0 56.6 0.988095238095238 83 36 98.8 0 2 250 181 263 NLM61000.1 hypothetical protein [Clostridiales bacterium] diamond 249 98.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
31251390 31251390 PRJNA690124_P_NODE_49915_length_247_cov_0.896552_g49549_i0 PRJNA690124 49915 247 0.896552 2.21448344 Clostridium sp. 1506 Bacteria Bacteria 95.1 3.6e-21   NR MBS6937453.1 1506 g49549 i0 94.4 0.65587044534413 54 3 65.6 0 247 86 278 331 MBS6937453.1 rRNA pseudouridine synthase [Clostridium sp.] diamond 162 95.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
31421083 31421083 PRJNA690124_P_NODE_34176_length_284_cov_1.322275_g33810_i0 PRJNA690124 34176 284 1.322275 3.755261 Bacteria 2 Bacteria Bacteria 131 9.789999999999999e-35   NR HWI60150.1 1879010 g33810 i0 73.9 9.69718309859155 92 24 97.2 0 277 2 196 287 HWI60150.1 2-hydroxyacid dehydrogenase [Bacillota bacterium] diamond 2754 131 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
31567991 31567991 PRJNA690124_P_NODE_44096_length_252_cov_1.307263_g43730_i0 PRJNA690124 44096 252 1.307263 3.29430276 Clostridium botulinum 1491 Bacteria Bacteria 118 1.26e-30   NR WP_053284728.1 1491 g43730 i0 69 1 84 24 100 1 252 1 1 82 WP_053284728.1 replication initiation protein [Clostridium botulinum] diamond 252 118 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
31694212 31694212 PRJNA690124_P_NODE_17037_length_392_cov_1.467085_g16671_i0 PRJNA690124 17037 392 1.467085 5.7509732 Holdemanella biformis 1735 Bacteria Bacteria 47.8 0.0032   NR WP_227976277.1 1735 g16671 i0 38.6 0.673469387755102 88 35 54.3 3 379 167 153 238 WP_227976277.1 glycoside hydrolase family 13 protein [Holdemanella biformis] diamond 264 47.8 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Holdemanella Holdemanella biformis
31820635 31820635 PRJNA690124_P_NODE_33717_length_286_cov_1.159624_g33351_i0 PRJNA690124 33717 286 1.159624 3.31652464 Carnobacterium inhibens 147709 Bacteria Bacteria 182 2.7e-52   NR WP_251165798.1 147709 g33351 i0 98.9 0.996503496503496 95 1 99.7 0 2 286 505 599 WP_251165798.1 lantibiotic ABC transporter permease [Carnobacterium inhibens] diamond 285 182 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Carnobacterium Carnobacterium inhibens
32705903 32705903 PRJNA690124_P_NODE_23280_length_339_cov_1.041353_g22914_i0 PRJNA690124 23280 339 1.041353 3.53018667 Clostridium perfringens 1502 Bacteria Bacteria 57.4 6.26e-7   NR MDJ8948203.1 1502 g22914 i0 45 1.41592920353982 80 44 70.8 0 69 308 13 92 MDJ8948203.1 troponin [Clostridium perfringens] diamond 480 57.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;