RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA774958" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 21 ✖

bioproject 1

  • PRJNA774958 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
21610407 21610407 PRJNA774958_P_NODE_38217_length_242_cov_0.911243_g37970_i0 PRJNA774958 38217 242 0.911243 2.20520806 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 145 2.63e-39   NR NNC92983.1 2080302 g37970 i0 92.5 2.97520661157025 80 6 99.2 0 241 2 263 342 NNC92983.1 NADH-quinone oxidoreductase subunit N [Acidimicrobiia bacterium] diamond 720 145 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
26641819 26641819 PRJNA774958_P_NODE_35561_length_247_cov_0.885057_g35314_i0 PRJNA774958 35561 247 0.885057 2.18609079 Cyanobacteria bacterium REEB67 2800110 Bacteria Bacteria 163 4.06e-45   NR MBU6451373.1 2800110 g35314 i0 87.8 1.9919028340081 82 10 99.6 0 1 246 449 530 MBU6451373.1 AMP-binding protein [Cyanobacteria bacterium REEB67] diamond 492 163 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
26863881 26863881 PRJNA774958_P_NODE_32041_length_259_cov_1.193548_g31794_i0 PRJNA774958 32041 259 1.193548 3.09128932 Clostridia bacterium 2044939 Bacteria Bacteria 43.9 0.0188   NR MBR2020077.1 2044939 g31794 i0 41 0.451737451737452 39 23 45.2 0 131 247 416 454 MBR2020077.1 hypothetical protein [Clostridia bacterium] diamond 117 43.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
27369787 27369787 PRJNA774958_P_NODE_33323_length_251_cov_0.865169_g33076_i0 PRJNA774958 33323 251 0.865169 2.17157419 Peptococcaceae bacterium 2052179 Bacteria Bacteria 53.1 8.83e-6   NR MBQ2369403.1 2052179 g33076 i0 36.4 1.75697211155378 77 49 92 0 233 3 632 708 MBQ2369403.1 RNA-binding transcriptional accessory protein [Peptococcaceae bacterium] diamond 441 53.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae   Peptococcaceae bacterium
27631663 27631663 PRJNA774958_P_NODE_36304_length_246_cov_0.890173_g36057_i0 PRJNA774958 36304 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 89.4 7.46e-19   NR HMN63026.1 1872519 g36057 i0 51.9 3.95121951219512 81 39 98.8 0 246 4 218 298 HMN63026.1 M20/M25/M40 family metallo-hydrolase [Anaerolinea sp.] diamond 972 89.4 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae Anaerolinea Anaerolinea sp.
28064041 28064041 PRJNA774958_P_NODE_18785_length_371_cov_1.285235_g18538_i0 PRJNA774958 18785 371 1.285235 4.76822185 Clostridiaceae bacterium 1898204 Bacteria Bacteria 43.9 0.0406   NR MEQ8196678.1 1898204 g18538 i0 33.7 0.719676549865229 89 48 63.9 3 327 91 98 185 MEQ8196678.1 tRNA (guanosine(46)-N7)-methyltransferase TrmB [Clostridiaceae bacterium] diamond 267 43.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
28506168 28506168 PRJNA774958_P_NODE_39427_length_227_cov_2.922078_g39180_i0 PRJNA774958 39427 227 2.922078 6.63311706 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 44.3 0.00857   NR MBE6951160.1 2485925 g39180 i0 40 0.52863436123348 40 24 52.9 0 219 100 49 88 MBE6951160.1 hypothetical protein [Oscillospiraceae bacterium] diamond 120 44.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28569198 28569198 PRJNA774958_P_NODE_18047_length_379_cov_6.003268_g17800_i0 PRJNA774958 18047 379 6.003268 22.75238572 Clostridium lundense 319475 Bacteria Bacteria 135 2.38e-38   NR WP_027623586.1 319475 g17800 i0 56.8 5.46965699208443 118 49 91.8 1 32 379 2 119 WP_027623586.1 RidA family protein [Clostridium lundense] diamond 2073 135 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium lundense
28664099 28664099 PRJNA774958_P_NODE_38987_length_241_cov_0.916667_g38740_i0 PRJNA774958 38987 241 0.916667 2.20916747 Agromyces sp. NBRC 114283 2994521 Bacteria Bacteria 135 9.04e-36   NR WP_285464103.1 2994521 g38740 i0 92.4 0.983402489626556 79 6 98.3 0 239 3 160 238 WP_285464103.1 alpha/beta hydrolase family protein [Agromyces sp. NBRC 114283] diamond 237 135 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Agromyces Agromyces sp. NBRC 114283
29399643 29399643 PRJNA774958_P_NODE_21829_length_338_cov_1.550943_g21582_i0 PRJNA774958 21829 338 1.550943 5.24218734 root 1 Root_unresolved Root_unresolved 44.3 0.0288   NR MDD3206133.1 1898203 g21582 i0 29.2 1.52662721893491 96 55 85.2 3 24 311 101 183 MDD3206133.1 hypothetical protein [Lachnospiraceae bacterium] diamond 516 44.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29968135 29968135 PRJNA774958_P_NODE_16191_length_403_cov_1.942424_g15944_i0 PRJNA774958 16191 403 1.942424 7.82796872 Carboxydothermus 129957 Bacteria Bacteria 118 2.3899999999999993e-31   NR WP_011343424.1 129957 g15944 i0 60 1.35483870967742 90 36 67 0 270 1 6 95 WP_011343424.1 MULTISPECIES: glycine cleavage system protein GcvH [Carboxydothermus] diamond 546 118 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Carboxydothermus  
30031333 30031333 PRJNA774958_P_NODE_10991_length_492_cov_1.599045_g10745_i0 PRJNA774958 10991 492 1.599045 7.8673014 Spiroplasma 2132 Bacteria Bacteria 46.6 0.0145   NR WP_040093749.1 2138 g10745 i0 25.9 1.92682926829268 158 87 88.4 5 483 49 45 185 WP_040093749.1 hypothetical protein [Spiroplasma poulsonii] diamond 948 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma poulsonii
30338198 30338198 PRJNA774958_P_NODE_16372_length_401_cov_1.368902_g16125_i0 PRJNA774958 16372 401 1.368902 5.48929702 Candidatus Flexifilum breve 3140694 Bacteria Bacteria 47 0.00635   NR WP_343421316.1 3140694 g16125 i0 33.3 0.538653366583541 72 44 51.6 2 280 74 84 154 WP_343421316.1 hypothetical protein [Candidatus Flexifilum breve] diamond 216 47 1 Bacteria   Bacillati Chloroflexota Anaerolineae Aggregatilineales Candidatus Flexifilaceae Candidatus Flexifilum Candidatus Flexifilum breve
30716801 30716801 PRJNA774958_P_NODE_36974_length_244_cov_2.198830_g36727_i0 PRJNA774958 36974 244 2.19883 5.3651452 Streptomyces resistomycificus 67356 Bacteria Bacteria 41.2 0.0192   NR WP_030044973.1 67356 g36727 i0 38.1 0.774590163934426 63 38 76.2 1 54 239 5 67 WP_030044973.1 EF-hand domain-containing protein [Streptomyces resistomycificus] diamond 189 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces resistomycificus
30874834 30874834 PRJNA774958_P_NODE_25014_length_310_cov_0.974684_g24767_i0 PRJNA774958 25014 310 0.974684 3.0215204 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 76.3 5.86e-15   NR MCP3885490.1 2021380 g24767 i0 63.3 0.580645161290323 60 22 58.1 0 3 182 92 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 180 76.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
31222201 31222201 PRJNA774958_P_NODE_18895_length_370_cov_0.993266_g18648_i0 PRJNA774958 18895 370 0.993266 3.6750842 Streptomyces sp. NPDC 1931 Bacteria Bacteria 46.2 0.00905   NR WP_384831232.1 3346694 g18648 i0 24.4 0.964864864864865 119 86 93.2 1 353 9 566 684 WP_384831232.1 hypothetical protein [Streptomyces sp. NPDC059009] diamond 357 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC059009
31633523 31633523 PRJNA774958_P_NODE_19076_length_368_cov_1.044068_g18829_i0 PRJNA774958 19076 368 1.044068 3.84217024 Streptomyces purpurogeneiscleroticus 68259 Bacteria Bacteria 44.3 0.043   NR WP_223735224.1 68259 g18829 i0 34.8 0.5625 69 42 56.3 1 345 139 427 492 WP_223735224.1 hypothetical protein [Streptomyces purpurogeneiscleroticus] diamond 207 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces purpurogeneiscleroticus
32044924 32044924 PRJNA774958_P_NODE_38038_length_243_cov_0.823529_g37791_i0 PRJNA774958 38038 243 0.823529 2.00117547 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 42.7 0.0357   NR HVC70596.1 2201156 g37791 i0 37.2 0.962962962962963 78 39 96.3 4 9 242 323 390 HVC70596.1 MFS transporter [Acidimicrobiales bacterium] diamond 234 42.7 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
32266578 32266578 PRJNA774958_P_NODE_18198_length_378_cov_0.980328_g17951_i0 PRJNA774958 18198 378 0.980328 3.70563984 Actinomycetota bacterium 2900548 Bacteria Bacteria 86.3 6.84e-17   NR MEY3806157.1 2900548 g17951 i0 39 1.99206349206349 123 72 97.6 2 9 377 98 217 MEY3806157.1 molybdopterin biosynthesis protein MoeA [Actinomycetota bacterium] diamond 753 86.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32276106 32276106 PRJNA774958_P_NODE_9718_length_525_cov_1.418142_g9475_i0 PRJNA774958 9718 525 1.418142 7.4452455 Cohnella 329857 Bacteria Bacteria 112 4.66e-28   NR WP_204602556.1 768479 g9475 i0 42.3 1.50857142857143 130 75 74.3 0 419 30 23 152 WP_204602556.1 acyl-CoA thioesterase [Cohnella boryungensis] diamond 792 113 0.991150442477876 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella boryungensis
32361537 32361537 PRJNA774958_P_NODE_35399_length_247_cov_1.327586_g35152_i0 PRJNA774958 35399 247 1.327586 3.27913742 Oscillibacter sp. 1945593 Bacteria Bacteria 40.4 0.0384   NR WP_293279915.1 1945593 g35152 i0 54.1 0.449392712550607 37 12 44.9 1 97 207 13 44 WP_293279915.1 hypothetical protein, partial [Oscillibacter sp.] diamond 111 40.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Oscillibacter Oscillibacter sp.

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