RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJEB48218 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
4818421 4818421 PRJEB48218_S_NODE_8564_length_319_cov_2.200000_g7602_i0 PRJEB48218 8564 319 2.2 7.018 Anoxybacillus sp. J5B_2 1872573 Bacteria Bacteria 194 9.09e-59   NR WP_268852168.1 3003246 g7602 i0 100 0.959247648902821 102 0 95.9 0 308 3 40 141 WP_268852168.1 endolytic transglycosylase MltG [Anoxybacillus sp. J5B_2022] diamond 306 194 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus sp. J5B_2022
9918432 9918432 PRJEB48218_S_NODE_12168_length_256_cov_2.568282_g11206_i0 PRJEB48218 12168 256 2.568282 6.57480192 Calditerricola sp. 2885161 Bacteria Bacteria 77 3.51e-14   NR HEY8343370.1 2885161 g11206 i0 76.2 2.0859375 42 10 49.2 0 1 126 390 431 HEY8343370.1 hypothetical protein [Calditerricola sp.] diamond 534 77 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Calditerricola Calditerricola sp.
11540646 11540646 PRJEB48218_S_NODE_17270_length_226_cov_3.842640_g16308_i0 PRJEB48218 17270 226 3.84264 8.6843664 Effusibacillus consociatus 1117041 Bacteria Bacteria 127 2.4999999999999997e-32   NR WP_380025292.1 1117041 g16308 i0 90.9 1.76548672566372 66 6 87.6 0 25 222 161 226 WP_380025292.1 S8 family serine peptidase [Effusibacillus consociatus] diamond 399 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Effusibacillus Effusibacillus consociatus
11540785 11540785 PRJEB48218_S_NODE_24570_length_176_cov_3.387755_g23608_i0 PRJEB48218 24570 176 3.387755 5.9624488 Clostridium tyrobutyricum 1519 Bacteria Bacteria 107 5.78e-29   NR WP_217819116.1 1519 g23608 i0 100 1.77272727272727 52 0 88.6 0 14 169 8 59 WP_217819116.1 hypothetical protein, partial [Clostridium tyrobutyricum] diamond 312 107 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium tyrobutyricum
19188107 19188107 PRJEB48218_S_NODE_26816_length_165_cov_2.441176_g25854_i0 PRJEB48218 26816 165 2.441176 4.0279404 Atopostipes 292480 Bacteria Bacteria 68.9 7.3e-12   NR MDN6730922.1 180295 g25854 i0 66.7 5.56363636363636 51 17 92.7 0 3 155 707 757 MDN6730922.1 alanine--tRNA ligase [Atopostipes suicloacalis] diamond 918 68.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Atopostipes Atopostipes suicloacalis
26646684 26646684 PRJEB48218_S_NODE_28941_length_156_cov_3.039370_g27979_i0 PRJEB48218 28941 156 3.03937 4.7414172 root 1 Root_unresolved Root_unresolved 100 3.76e-26   NR MDN8996941.1 1280 g27979 i0 96.2 11 52 2 100 0 1 156 17 68 MDN8996941.1 NADH-quinone oxidoreductase subunit H [Staphylococcus aureus] diamond 1716 100 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
26938406 26938406 PRJEB48218_S_NODE_25082_length_173_cov_3.243056_g24120_i0 PRJEB48218 25082 173 3.243056 5.61048688 Clostridia bacterium 2044939 Bacteria Bacteria 97.1 7.49e-22   NR MDA8212469.1 2044939 g24120 i0 92.2 0.884393063583815 51 4 88.4 0 3 155 229 279 MDA8212469.1 cytochrome c biogenesis protein ResB [Clostridia bacterium] diamond 153 97.1 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
26938407 26938407 PRJEB48218_S_NODE_25302_length_172_cov_2.769231_g24340_i0 PRJEB48218 25302 172 2.769231 4.76307732 Caldinitratiruptor microaerophilus 671077 Bacteria Bacteria 75.5 8.98e-15   NR WP_264843356.1 671077 g24340 i0 64.3 0.976744186046512 56 20 97.7 0 3 170 180 235 WP_264843356.1 2Fe-2S iron-sulfur cluster-binding protein [Caldinitratiruptor microaerophilus] diamond 168 75.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae Caldinitratiruptor Caldinitratiruptor microaerophilus
26970074 26970074 PRJEB48218_S_NODE_8482_length_321_cov_5.647260_g7520_i0 PRJEB48218 8482 321 5.64726 18.1277046 Cytobacillus sp. Hz8 3347168 Bacteria Bacteria 42 0.0265   NR WP_375843522.1 3347168 g7520 i0 36.6 0.383177570093458 41 26 38.3 0 127 249 2 42 WP_375843522.1 DUF3231 family protein [Cytobacillus sp. Hz8] diamond 123 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Cytobacillus Cytobacillus sp. Hz8
27001645 27001645 PRJEB48218_S_NODE_15822_length_233_cov_3.357843_g14860_i0 PRJEB48218 15822 233 3.357843 7.82377419 Anoxybacteroides tepidamans 265948 Bacteria Bacteria 118 1.15e-31   NR WP_183254624.1 265948 g14860 i0 85.9 2.8068669527897 78 8 97.9 2 6 233 60 136 WP_183254624.1 acetyl-CoA carboxylase biotin carboxyl carrier protein [Anoxybacteroides tepidamans] diamond 654 118 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacteroides Anoxybacteroides tepidamans
27381345 27381345 PRJEB48218_S_NODE_30723_length_150_cov_2.247934_g29761_i0 PRJEB48218 30723 150 2.247934 3.371901 Streptococcus gallinaceus 165758 Bacteria Bacteria 84.3 7.54e-18   NR WP_253636094.1 165758 g29761 i0 70 2 50 15 100 0 1 150 158 207 WP_253636094.1 LysR family transcriptional regulator [Streptococcus gallinaceus] diamond 300 84.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus gallinaceus
27475894 27475894 PRJEB48218_S_NODE_24463_length_177_cov_2.331081_g23501_i0 PRJEB48218 24463 177 2.331081 4.12601337 Paenibacillus koleovorans 121608 Bacteria Bacteria 81.3 1.62e-16   NR WP_246067196.1 121608 g23501 i0 79.5 1.49152542372881 44 9 74.6 0 133 2 20 63 WP_246067196.1 ABC transporter permease [Paenibacillus koleovorans] diamond 264 81.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus koleovorans
27539136 27539136 PRJEB48218_S_NODE_5024_length_491_cov_47.376623_g4083_i0 PRJEB48218 5024 491 47.376623 232.61921893 Staphylococcus pseudintermedius 283734 Bacteria Bacteria 127 6.49e-35   NR WP_222114562.1 283734 g4083 i0 100 1.02647657841141 84 0 51.3 0 277 26 1 84 WP_222114562.1 hypothetical protein, partial [Staphylococcus pseudintermedius] diamond 504 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus pseudintermedius
27570593 27570593 PRJEB48218_S_NODE_24484_length_177_cov_1.966216_g23522_i0 PRJEB48218 24484 177 1.966216 3.48020232 Thermoanaerobacterium thermosaccharolyticum 1517 Bacteria Bacteria 52.8 3.51e-7   NR MFU0783792.1 1517 g23522 i0 75 0.677966101694915 40 10 67.8 0 58 177 13 52 MFU0783792.1 hypothetical protein [Thermoanaerobacterium thermosaccharolyticum] diamond 120 52.8 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacterium Thermoanaerobacterium thermosaccharolyticum
27570594 27570594 PRJEB48218_S_NODE_25924_length_169_cov_3.050000_g24962_i0 PRJEB48218 25924 169 3.05 5.1545 Caldanaerobacter subterraneus 911092 Bacteria Bacteria 98.6 7.41e-24   NR WP_132040630.1 911092 g24962 i0 100 0.940828402366864 53 0 94.1 0 161 3 136 188 WP_132040630.1 hypothetical protein [Caldanaerobacter subterraneus] diamond 159 98.6 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Caldanaerobacter Caldanaerobacter subterraneus
27633891 27633891 PRJEB48218_S_NODE_26604_length_166_cov_2.138686_g25642_i0 PRJEB48218 26604 166 2.138686 3.55021876 Thermoanaerobacterium thermosaccharolyticum 1517 Bacteria Bacteria 100 2.1399999999999994e-23   NR WP_416318198.1 1517 g25642 i0 83.6 1.98795180722892 55 9 99.4 0 2 166 242 296 WP_416318198.1 esterase/lipase family protein [Thermoanaerobacterium thermosaccharolyticum] diamond 330 100 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacterium Thermoanaerobacterium thermosaccharolyticum
27816740 27816740 PRJEB48218_S_NODE_20104_length_208_cov_2.726257_g19142_i0 PRJEB48218 20104 208 2.726257 5.67061456 Bacillales 1385 Bacteria Bacteria 110 5.550000000000001e-27   NR WP_031409274.1 135517 g19142 i0 93.7 16.3557692307692 63 4 90.9 0 19 207 148 210 WP_031409274.1 iron-containing alcohol dehydrogenase [Geobacillus vulcani] diamond 3402 111 0.990990990990991 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Geobacillus Geobacillus vulcani
28006196 28006196 PRJEB48218_S_NODE_18685_length_219_cov_1.710526_g17723_i0 PRJEB48218 18685 219 1.710526 3.74605194 Lachnospiraceae 186803 Bacteria Bacteria 137 1.12e-36   NR WP_243110842.1 2292982 g17723 i0 98.5 2.79452054794521 68 1 93.2 0 1 204 319 386 WP_243110842.1 peptidoglycan D,D-transpeptidase FtsI family protein [Blautia sp. OF11-22] diamond 612 137 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Blautia Blautia sp. OF11-22
28006198 28006198 PRJEB48218_S_NODE_23685_length_182_cov_2.274510_g22723_i0 PRJEB48218 23685 182 2.27451 4.1396082 Clostridia 186801 Bacteria Bacteria 102 3.66e-25   NR WP_329996431.1 1506 g22723 i0 100 4.94505494505495 50 0 82.4 0 31 180 125 174 WP_329996431.1 glycoside hydrolase family 20 zincin-like fold domain-containing protein, partial [Clostridium sp.] diamond 900 102 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
28549628 28549628 PRJEB48218_S_NODE_21007_length_201_cov_2.866279_g20045_i0 PRJEB48218 21007 201 2.866279 5.76122079 Thermoanaerobacter sp. CM-CNRG TB177 2800659 Bacteria Bacteria 131 1.05e-34   NR WP_074666674.1 2800659 g20045 i0 98.5 0.985074626865672 66 1 98.5 0 199 2 5 70 WP_074666674.1 radical SAM/SPASM domain-containing protein [Thermoanaerobacter sp. CM-CNRG TB177] diamond 198 131 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacter Thermoanaerobacter sp. CM-CNRG TB177
28770388 28770388 PRJEB48218_S_NODE_13887_length_240_cov_2.938389_g12925_i0 PRJEB48218 13887 240 2.938389 7.0521336 Eubacteriales bacterium 2831996 Bacteria Bacteria 149 6.77e-41   NR MDD4200097.1 2831996 g12925 i0 97.5 1 80 2 100 0 240 1 52 131 MDD4200097.1 sigma 54-interacting transcriptional regulator [Eubacteriales bacterium] diamond 240 149 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Eubacteriales bacterium
29086330 29086330 PRJEB48218_S_NODE_21428_length_198_cov_2.733728_g20466_i0 PRJEB48218 21428 198 2.733728 5.41278144 Lacrimispora algidixylanolytica 94868 Bacteria Bacteria 133 2.89e-34   NR WP_120195514.1 94868 g20466 i0 100 1 66 0 100 0 1 198 198 263 WP_120195514.1 alpha-galactosidase [Lacrimispora algidixylanolytica] diamond 198 133 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lacrimispora Lacrimispora algidixylanolytica
29559654 29559654 PRJEB48218_S_NODE_23530_length_183_cov_2.240260_g22568_i0 PRJEB48218 23530 183 2.24026 4.0996758 Cohnella cellulosilytica 986710 Bacteria Bacteria 42.4 0.0233   NR WP_378107407.1 986710 g22568 i0 43.2 0.721311475409836 44 25 72.1 0 133 2 2774 2817 WP_378107407.1 RHS repeat-associated core domain-containing protein [Cohnella cellulosilytica] diamond 132 42.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella cellulosilytica
29717368 29717368 PRJEB48218_S_NODE_20870_length_202_cov_2.826590_g19908_i0 PRJEB48218 20870 202 2.82659 5.7097118 Candidatus Coprovivens excrementavium 2840755 Bacteria Bacteria 124 3.5999999999999996e-31   NR HIS17474.1 2840755 g19908 i0 90.9 1.96039603960396 66 6 98 0 199 2 84 149 HIS17474.1 NAD-dependent DNA ligase LigA [Candidatus Coprovivens excrementavium] diamond 396 124 1 Bacteria   Bacillati Bacillota Bacilli     Candidatus Coprovivens Candidatus Coprovivens excrementavium
31139009 31139009 PRJEB48218_S_NODE_25795_length_170_cov_2.170213_g24833_i0 PRJEB48218 25795 170 2.170213 3.6893621 Thermoanaerobacterium thermosaccharolyticum 1517 Bacteria Bacteria 115 2.4799999999999998e-28   NR WP_094046235.1 1517 g24833 i0 100 0.988235294117647 56 0 98.8 0 168 1 424 479 WP_094046235.1 CRISPR-associated protein Csx11 [Thermoanaerobacterium thermosaccharolyticum] diamond 168 115 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacterium Thermoanaerobacterium thermosaccharolyticum
31512339 31512339 PRJEB48218_S_NODE_17296_length_226_cov_1.969543_g16334_i0 PRJEB48218 17296 226 1.969543 4.45116718 Clostridium 1485 Bacteria Bacteria 137 1.4e-37   NR WP_150356453.1 1485 g16334 i0 88 1.99115044247788 75 9 99.6 0 225 1 227 301 WP_150356453.1 MULTISPECIES: translation elongation factor Ts [Clostridium] diamond 450 137 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium  
31803350 31803350 PRJEB48218_S_NODE_30117_length_152_cov_2.284553_g29155_i0 PRJEB48218 30117 152 2.284553 3.47252056 Clostridiaceae bacterium 1898204 Bacteria Bacteria 44.7 0.00211   NR NLY43758.1 1898204 g29155 i0 60 1.36184210526316 35 14 69.1 0 105 1 19 53 NLY43758.1 SDR family oxidoreductase [Clostridiaceae bacterium] diamond 207 44.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
32214913 32214913 PRJEB48218_S_NODE_19698_length_211_cov_4.802198_g18736_i0 PRJEB48218 19698 211 4.802198 10.13263778 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 87 1.08e-19   NR MBE5938652.1 1898203 g18736 i0 72.7 2.3175355450237 55 15 78.2 0 206 42 100 154 MBE5938652.1 nucleoside deaminase [Lachnospiraceae bacterium] diamond 489 87 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32373165 32373165 PRJEB48218_S_NODE_9639_length_294_cov_4.520755_g8677_i0 PRJEB48218 9639 294 4.520755 13.2910197 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 181 3.3299999999999992e-52   NR MBR3170575.1 1898203 g8677 i0 98.9 1.87755102040816 92 1 93.9 0 294 19 112 203 MBR3170575.1 response regulator [Lachnospiraceae bacterium] diamond 552 181 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32404732 32404732 PRJEB48218_S_NODE_17579_length_224_cov_3.548718_g16617_i0 PRJEB48218 17579 224 3.548718 7.94912832 Anoxybacillus sp. J5B_2 1872573 Bacteria Bacteria 150 1.82e-41   NR WP_268851925.1 3003246 g16617 i0 100 0.991071428571429 74 0 99.1 0 1 222 120 193 WP_268851925.1 nucleoside triphosphate pyrophosphohydrolase [Anoxybacillus sp. J5B_2022] diamond 222 150 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus sp. J5B_2022
32499806 32499806 PRJEB48218_S_NODE_24899_length_174_cov_3.496552_g23937_i0 PRJEB48218 24899 174 3.496552 6.08400048 Staphylococcus haemolyticus 1283 Bacteria Bacteria 63.5 1.26e-11   NR WP_186311779.1 1283 g23937 i0 96.4 0.482758620689655 28 1 48.3 0 165 82 1 28 WP_186311779.1 hypothetical protein, partial [Staphylococcus haemolyticus] diamond 84 63.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
32656994 32656994 PRJEB48218_S_NODE_23840_length_181_cov_2.388158_g22878_i0 PRJEB48218 23840 181 2.388158 4.32256598 Negativicutes bacterium 2499140 Bacteria Bacteria 94.7 6.4400000000000006e-21   NR MCX7780934.1 2499140 g22878 i0 76.3 1.93922651933702 59 14 97.8 0 181 5 148 206 MCX7780934.1 TldD/PmbA family protein [Negativicutes bacterium] diamond 351 94.7 1 Bacteria   Bacillati Bacillota Negativicutes       Negativicutes bacterium

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