RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA909412" 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

  • PRJNA909412 · 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
7268858 7268858 PRJNA909412_P_NODE_4306_length_252_cov_3.338028_g4165_i0 PRJNA909412 4306 252 3.338028 8.41183056 Scopulibacillus cellulosilyticus 2665665 Bacteria Bacteria 127 4.39e-34   NR WP_380969081.1 2665665 g4165 i0 74.7 2.96428571428571 83 21 98.8 0 2 250 15 97 WP_380969081.1 dimethylarginine dimethylaminohydrolase family protein [Scopulibacillus cellulosilyticus] diamond 747 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Scopulibacillus Scopulibacillus cellulosilyticus
27150426 27150426 PRJNA909412_P_NODE_3422_length_284_cov_2.330612_g3281_i0 PRJNA909412 3422 284 2.330612 6.61893808 Cellulosilyticum sp. 1926876 Bacteria Bacteria 43.1 0.0445   NR MEE1072210.1 1926876 g3281 i0 31.3 0.845070422535211 80 53 82.4 2 37 270 253 332 MEE1072210.1 efflux RND transporter permease subunit [Cellulosilyticum sp.] diamond 240 43.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Cellulosilyticaceae Cellulosilyticum Cellulosilyticum sp.
27600785 27600785 PRJNA909412_P_NODE_6384_length_207_cov_3.059524_g6243_i0 PRJNA909412 6384 207 3.059524 6.33321468 Paenibacillus 44249 Bacteria Bacteria 45.1 0.00368   NR WP_245624987.1 169760 g6243 i0 29.4 4.92753623188406 68 48 98.6 0 204 1 627 694 WP_245624987.1 Ig-like domain-containing protein [Paenibacillus stellifer] diamond 1020 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus stellifer
28168928 28168928 PRJNA909412_P_NODE_3885_length_267_cov_1.732456_g3744_i0 PRJNA909412 3885 267 1.732456 4.62565752 root 1 Root_unresolved Root_unresolved 118 5.149999999999999e-31   NR HDR3341861.1 1392 g3744 i0 61.8 26.6741573033708 89 32 100 1 267 1 81 167 HDR3341861.1 protein-ADP-ribose hydrolase [Bacillus anthracis] diamond 7122 119 0.991596638655462 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus anthracis
28192837 28192837 PRJNA909412_P_NODE_6566_length_205_cov_1.819277_g6425_i0 PRJNA909412 6566 205 1.819277 3.72951785 Clostridium grantii 40575 Bacteria Bacteria 67.8 8.3e-12   NR WP_073339288.1 40575 g6425 i0 55.4 8.15121951219512 56 25 82 0 172 5 97 152 WP_073339288.1 DsbA family oxidoreductase [Clostridium grantii] diamond 1671 67.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium grantii
28951041 28951041 PRJNA909412_P_NODE_3428_length_284_cov_1.669388_g3287_i0 PRJNA909412 3428 284 1.669388 4.74106192 Massilistercora timonensis 2086584 Bacteria Bacteria 45.4 0.00259   NR WP_106790073.1 2086584 g3287 i0 37.5 0.591549295774648 56 35 59.2 0 227 60 31 86 WP_106790073.1 DMT family transporter [Massilistercora timonensis] diamond 168 45.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Massilistercora Massilistercora timonensis
29393000 29393000 PRJNA909412_P_NODE_7829_length_189_cov_2.720000_g7688_i0 PRJNA909412 7829 189 2.72 5.1408 Enterococcus faecium 1352 Bacteria Bacteria 61.6 1.17e-10   NR PWS21158.1 1352 g7688 i0 84.4 0.507936507936508 32 5 50.8 0 4 99 48 79 PWS21158.1 glutaredoxin 3, partial [Enterococcus faecium] diamond 96 61.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
29676677 29676677 PRJNA909412_P_NODE_5190_length_229_cov_2.152632_g5049_i0 PRJNA909412 5190 229 2.152632 4.92952728 Thermoanaerobacterales bacterium 2304039 Bacteria Bacteria 99.4 9.549999999999999e-24   NR HHU68895.1 2304039 g5049 i0 58.7 0.982532751091703 75 31 98.3 0 228 4 142 216 HHU68895.1 CoA transferase subunit B [Thermoanaerobacterales bacterium] diamond 225 99.4 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales     Thermoanaerobacterales bacterium
30221374 30221374 PRJNA909412_P_NODE_5572_length_221_cov_2.071429_g5431_i0 PRJNA909412 5572 221 2.071429 4.57785809 Bacillota 1239 Bacteria Bacteria 117 6.259999999999999e-31   NR WP_183601120.1 274593 g5431 i0 67.1 8.90497737556561 73 24 99.1 0 219 1 113 185 WP_183601120.1 nitroreductase family protein [Paenibacillus phyllosphaerae] diamond 1968 117 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus phyllosphaerae
30245818 30245818 PRJNA909412_P_NODE_12932_length_161_cov_2.606557_g12791_i0 PRJNA909412 12932 161 2.606557 4.19655677 Megasphaera lornae 1000568 Bacteria Bacteria 55.8 2.9e-7   NR WP_009370000.1 1000568 g12791 i0 100 0.503105590062112 27 0 50.3 0 160 80 995 1021 WP_009370000.1 DNA polymerase III subunit alpha [Megasphaera lornae] diamond 81 55.8 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Megasphaera Megasphaera lornae
30309287 30309287 PRJNA909412_P_NODE_1292_length_489_cov_6.700000_g1153_i0 PRJNA909412 1292 489 6.7 32.763 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 150 1.2299999999999996e-43   NR POH17992.1 1625 g1153 i0 67.2 0.803680981595092 131 43 80.4 0 394 2 1 131 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 393 150 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
30372390 30372390 PRJNA909412_P_NODE_1032_length_553_cov_11.389105_g904_i0 PRJNA909412 1032 553 11.389105 62.98175065 Fictibacillus gelatini 225985 Bacteria Bacteria 111 5.31e-26   NR WP_026677960.1 225985 g904 i0 38.6 1.70343580470163 158 91 83.5 3 538 77 132 287 WP_026677960.1 AraC family transcriptional regulator [Fictibacillus gelatini] diamond 942 111 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Fictibacillaceae Fictibacillus Fictibacillus gelatini
30467104 30467104 PRJNA909412_P_NODE_1293_length_489_cov_6.533333_g1154_i0 PRJNA909412 1293 489 6.533333 31.94799837 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 146 8.149999999999997e-42   NR POH17992.1 1625 g1154 i0 66.4 0.803680981595092 131 44 80.4 0 394 2 1 131 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 393 146 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
30498425 30498425 PRJNA909412_P_NODE_16293_length_152_cov_1.946903_g16152_i0 PRJNA909412 16293 152 1.946903 2.95929256 Eubacterium brachy ATCC 33 35517 Bacteria Bacteria 89.7 1.05e-19   NR ESE31107.1 1321814 g16152 i0 100 0.986842105263158 50 0 98.7 0 151 2 86 135 ESE31107.1 RIP metalloprotease RseP [Eubacterium brachy ATCC 33089] diamond 150 89.7 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   [Eubacterium] brachy
30758633 30758633 PRJNA909412_P_NODE_7014_length_199_cov_2.075000_g6873_i0 PRJNA909412 7014 199 2.075 4.12925 Marinilactibacillus 191769 Bacteria Bacteria 64.3 4.18e-10   NR WP_407124012.1 191770 g6873 i0 50 7.49246231155779 62 31 93.5 0 192 7 52 113 WP_407124012.1 L-threonine 3-dehydrogenase [Marinilactibacillus psychrotolerans] diamond 1491 64.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Marinilactibacillus Marinilactibacillus psychrotolerans
30940897 30940897 PRJNA909412_P_NODE_4314_length_252_cov_2.497653_g4173_i0 PRJNA909412 4314 252 2.497653 6.29408556 Bacillaceae bacterium 1889774 Bacteria Bacteria 79.7 3.07e-15   NR MBO8155725.1 1889774 g4173 i0 50 0.976190476190476 82 40 97.6 1 6 251 194 274 MBO8155725.1 NAD(P)/FAD-dependent oxidoreductase [Bacillaceae bacterium] diamond 246 79.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae   Bacillaceae bacterium
31889242 31889242 PRJNA909412_P_NODE_2457_length_339_cov_3.513333_g2317_i0 PRJNA909412 2457 339 3.513333 11.91019887 Peptococcaceae bacterium 2052179 Bacteria Bacteria 69.7 3.89e-11   NR NMA52675.1 2052179 g2317 i0 53.3 3.23008849557522 60 28 53.1 0 339 160 472 531 NMA52675.1 molecular chaperone HtpG [Peptococcaceae bacterium] diamond 1095 69.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae   Peptococcaceae bacterium
32245136 32245136 PRJNA909412_P_NODE_7338_length_195_cov_1.589744_g7197_i0 PRJNA909412 7338 195 1.589744 3.1000008 Bacteria 2 Bacteria Bacteria 94.4 2.4300000000000003e-21   NR MBP3610104.1 1898203 g7197 i0 65.1 12.3846153846154 63 22 96.9 0 190 2 88 150 MBP3610104.1 3-dehydroquinate synthase [Lachnospiraceae bacterium] diamond 2415 94.7 0.996832101372756 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32647975 32647975 PRJNA909412_P_NODE_13720_length_159_cov_3.533333_g13579_i0 PRJNA909412 13720 159 3.533333 5.61799947 Sporosarcina siberiensis 1365606 Bacteria Bacteria 43.5 0.00542   NR WP_381535452.1 1365606 g13579 i0 38.6 0.830188679245283 44 27 83 0 140 9 115 158 WP_381535452.1 LytR/AlgR family response regulator transcription factor [Sporosarcina siberiensis] diamond 132 43.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Sporosarcina Sporosarcina siberiensis
32679537 32679537 PRJNA909412_P_NODE_1460_length_456_cov_2.505995_g1321_i0 PRJNA909412 1460 456 2.505995 11.4273372 Clostridium tunisiense 219748 Bacteria Bacteria 137 9.24e-37   NR WP_017414920.1 219748 g1321 i0 52 3.26973684210526 127 60 83.6 1 76 456 124 249 WP_017414920.1 VIT1/CCC1 transporter family protein [Clostridium tunisiense] diamond 1491 137 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium tunisiense

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