RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA637219 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
6987219 6987219 PRJNA637219_S_NODE_11046_length_167_cov_0.864407_g11001_i0 PRJNA637219 11046 167 0.864407 1.44355969 Peptoniphilus 162289 Bacteria Bacteria 109 3.44e-26   NR WP_010242583.1 1175452 g11001 i0 100 12.8443113772455 55 0 98.8 0 3 167 738 792 WP_010242583.1 transcription-repair coupling factor [Peptoniphilus rhinitidis] diamond 2145 109 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus rhinitidis
27049493 27049493 PRJNA637219_S_NODE_15802_length_162_cov_0.902655_g15757_i0 PRJNA637219 15802 162 0.902655 1.4623011 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 58.2 4.24e-8   NR MCI9357897.1 1898203 g15757 i0 49.1 0.981481481481482 53 23 90.7 1 9 155 165 217 MCI9357897.1 nitrogenase molybdenum-iron protein [Lachnospiraceae bacterium] diamond 159 58.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27175614 27175614 PRJNA637219_S_NODE_11962_length_166_cov_0.871795_g11917_i0 PRJNA637219 11962 166 0.871795 1.4471797 Aliicoccus persicus 930138 Bacteria Bacteria 111 8.310000000000001e-27   NR WP_091475694.1 930138 g11917 i0 98.2 0.993975903614458 55 1 99.4 0 166 2 367 421 WP_091475694.1 ABC transporter ATP-binding protein [Aliicoccus persicus] diamond 165 111 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Aliicoccus Aliicoccus persicus
27491855 27491855 PRJNA637219_S_NODE_14823_length_163_cov_0.894737_g14778_i0 PRJNA637219 14823 163 0.894737 1.45842131 Peptoniphilus olsenii 411570 Bacteria Bacteria 105 7.07e-25   NR WP_354367824.1 411570 g14778 i0 100 0.975460122699387 53 0 97.5 0 3 161 854 906 WP_354367824.1 isoleucine--tRNA ligase [Peptoniphilus olsenii] diamond 159 105 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus olsenii
27554691 27554691 PRJNA637219_S_NODE_10924_length_167_cov_0.864407_g10879_i0 PRJNA637219 10924 167 0.864407 1.44355969 Anaerococcus sp. 1872515 Bacteria Bacteria 101 4.23e-25   NR WP_316111274.1 1872515 g10879 i0 89.1 0.988023952095808 55 6 98.8 0 1 165 16 70 WP_316111274.1 TetR/AcrR family transcriptional regulator [Anaerococcus sp.] diamond 165 101 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus sp.
27618231 27618231 PRJNA637219_S_NODE_17244_length_161_cov_0.910714_g17199_i0 PRJNA637219 17244 161 0.910714 1.46624954 Alloiococcus sp. 1872467 Bacteria Bacteria 90.5 1.72e-20   NR HLQ74526.1 1872467 g17199 i0 77.4 0.987577639751553 53 12 98.8 0 2 160 89 141 HLQ74526.1 RNA methyltransferase [Alloiococcus sp.] diamond 159 90.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Alloiococcus Alloiococcus sp.
27713206 27713206 PRJNA637219_S_NODE_2124_length_311_cov_1.427481_g2079_i0 PRJNA637219 2124 311 1.427481 4.43946591 Geobacillus thermoleovorans 33941 Bacteria Bacteria 68.2 2.51e-11   NR AZM68782.1 33941 g2079 i0 65.5 0.559485530546624 58 18 55.9 2 138 311 13 68 AZM68782.1 hypothetical protein, partial [Geobacillus thermoleovorans] diamond 174 68.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus thermoleovorans
28577812 28577812 PRJNA637219_S_NODE_14947_length_163_cov_0.894737_g14902_i0 PRJNA637219 14947 163 0.894737 1.45842131 Streptococcaceae 1300 Bacteria Bacteria 109 9.05e-27   NR WP_019291368.1 1357 g14902 i0 98.1 13.9141104294479 54 1 99.4 0 2 163 175 228 WP_019291368.1 MULTISPECIES: tRNA uracil 4-sulfurtransferase ThiI [Lactococcus] diamond 2268 109 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactococcus  
28849272 28849272 PRJNA637219_S_NODE_15888_length_162_cov_0.902655_g15843_i0 PRJNA637219 15888 162 0.902655 1.4623011 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 108 2.13e-26   NR WP_296115105.1 293428 g15843 i0 100 1 54 0 100 0 1 162 311 364 WP_296115105.1 lactate racemase domain-containing protein [uncultured Anaerococcus sp.] diamond 162 108 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
29386365 29386365 PRJNA637219_S_NODE_15869_length_162_cov_0.902655_g15824_i0 PRJNA637219 15869 162 0.902655 1.4623011 Mageeibacillus indolicus 884684 Bacteria Bacteria 58.2 4.42e-8   NR WP_197028491.1 884684 g15824 i0 53.7 2 54 24 98.1 1 160 2 707 760 WP_197028491.1 transglycosylase domain-containing protein [Mageeibacillus indolicus] diamond 324 58.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Mageeibacillus Mageeibacillus indolicus
29386366 29386366 PRJNA637219_S_NODE_6569_length_199_cov_2.386667_g6524_i0 PRJNA637219 6569 199 2.386667 4.74946733 Geobacillus thermoleovorans 33941 Bacteria Bacteria 75.9 6.86e-15   NR AZM68782.1 33941 g6524 i0 71.4 0.844221105527638 56 14 84.4 2 170 3 13 66 AZM68782.1 hypothetical protein, partial [Geobacillus thermoleovorans] diamond 168 75.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus thermoleovorans
30397432 30397432 PRJNA637219_S_NODE_15733_length_162_cov_0.902655_g15688_i0 PRJNA637219 15733 162 0.902655 1.4623011 Gemella 1378 Bacteria Bacteria 48.5 4.52e-5   NR WP_224207462.1 1378 g15688 i0 58.1 1.59259259259259 43 18 79.6 0 130 2 58 100 WP_224207462.1 MULTISPECIES: DUF3290 family protein [Gemella] diamond 258 48.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella  
31249998 31249998 PRJNA637219_S_NODE_14275_length_164_cov_0.747826_g14230_i0 PRJNA637219 14275 164 0.747826 1.22643464 Peribacillus muralis 264697 Bacteria Bacteria 41.6 0.0308   NR WP_057913021.1 264697 g14230 i0 41 0.713414634146341 39 23 71.3 0 43 159 195 233 WP_057913021.1 phosphoadenylyl-sulfate reductase [Peribacillus muralis] diamond 117 41.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Peribacillus Peribacillus muralis
31850933 31850933 PRJNA637219_S_NODE_15717_length_162_cov_0.902655_g15672_i0 PRJNA637219 15717 162 0.902655 1.4623011 Anaerococcus sp. 1872515 Bacteria Bacteria 92.8 5.59e-21   NR WP_288223057.1 1872515 g15672 i0 90.6 0.981481481481482 53 5 98.1 0 2 160 4 56 WP_288223057.1 helix-turn-helix domain-containing protein [Anaerococcus sp.] diamond 159 92.8 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus sp.
32135924 32135924 PRJNA637219_S_NODE_12858_length_165_cov_0.879310_g12813_i0 PRJNA637219 12858 165 0.87931 1.4508615 Clostridium tyrobutyricum 1519 Bacteria Bacteria 59.3 1.88e-8   NR WP_217828753.1 1519 g12813 i0 64.9 2.01818181818182 37 13 67.3 0 1 111 543 579 WP_217828753.1 ABC transporter ATP-binding protein [Clostridium tyrobutyricum] diamond 333 59.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium tyrobutyricum
32135925 32135925 PRJNA637219_S_NODE_14678_length_163_cov_0.894737_g14633_i0 PRJNA637219 14678 163 0.894737 1.45842131 Sakamotonia hominis 3078042 Bacteria Bacteria 50.4 4.15e-6   NR MEQ2382852.1 3133497 g14633 i0 77.8 0.496932515337423 27 6 49.7 0 10 90 85 111 MEQ2382852.1 hypothetical protein [Sakamotonia hominis] diamond 81 50.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Sakamotonia Sakamotonia hominis

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