RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA934472 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
911201 911201 PRJNA934472_P_NODE_35981_length_249_cov_0.875000_g35603_i0 PRJNA934472 35981 249 0.875 2.17875 Clostridium sp. 1506 Bacteria Bacteria 110 1.17e-26   NR NLB23660.1 1506 g35603 i0 67.5 1 83 27 100 0 1 249 237 319 NLB23660.1 ABC transporter ATP-binding protein [Clostridium sp.] diamond 249 110 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
911274 911274 PRJNA934472_P_NODE_39181_length_238_cov_2.678788_g38803_i0 PRJNA934472 39181 238 2.678788 6.37551544 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 152 1.3599999999999999e-42   NR MBQ8597199.1 1898203 g38803 i0 97.4 5.89915966386555 78 2 98.3 0 3 236 3 80 MBQ8597199.1 NADP-dependent malic enzyme [Lachnospiraceae bacterium] diamond 1404 152 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
8908355 8908355 PRJNA934472_P_NODE_31747_length_264_cov_1.534031_g31369_i0 PRJNA934472 31747 264 1.534031 4.04984184 Candidatus Gallacutalibacter pullistercoris 2840831 Bacteria Bacteria 184 1.69e-53   NR HIS49258.1 2840831 g31369 i0 98.9 1 88 1 100 0 1 264 124 211 HIS49258.1 beta-N-acetylhexosaminidase [Candidatus Gallacutalibacter pullistercoris] diamond 264 184 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Candidatus Gallacutalibacter Candidatus Gallacutalibacter pullistercoris
9839068 9839068 PRJNA934472_P_NODE_31808_length_264_cov_1.361257_g31430_i0 PRJNA934472 31808 264 1.361257 3.59371848 Atopostipes sp. 1872652 Bacteria Bacteria 167 4.88e-47   NR HZK23173.1 1872652 g31430 i0 98.9 0.988636363636364 87 1 98.9 0 262 2 438 524 HZK23173.1 ATP-dependent Clp protease ATP-binding subunit [Atopostipes sp.] diamond 261 167 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Atopostipes Atopostipes sp.
23863515 23863515 PRJNA934472_P_NODE_35999_length_249_cov_0.875000_g35621_i0 PRJNA934472 35999 249 0.875 2.17875 uncultured Subdoligranulum sp. 512298 Bacteria Bacteria 162 2.99e-45   NR WP_300369311.1 512298 g35621 i0 100 0.987951807228916 82 0 98.8 0 2 247 232 313 WP_300369311.1 DUF4153 domain-containing protein [uncultured Subdoligranulum sp.] diamond 246 162 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Subdoligranulum uncultured Subdoligranulum sp.
26739643 26739643 PRJNA934472_P_NODE_25721_length_290_cov_1.797235_g25343_i0 PRJNA934472 25721 290 1.797235 5.2119815 Gelria sp. Kuro-4 2796927 Bacteria Bacteria 89.4 2.8e-18   NR WP_221039197.1 2796927 g25343 i0 45.4 1.00344827586207 97 52 99.3 1 1 288 1013 1109 WP_221039197.1 LamG domain-containing protein [Gelria sp. Kuro-4] diamond 291 89.4 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Gelria Gelria sp. Kuro-4
26771796 26771796 PRJNA934472_P_NODE_36921_length_246_cov_1.450867_g36543_i0 PRJNA934472 36921 246 1.450867 3.56913282 Brevibacillus fulvus 1125967 Bacteria Bacteria 94.7 1.79e-22   NR WP_204518615.1 1125967 g36543 i0 52.5 1.90243902439024 80 37 96.3 1 237 1 3 82 WP_204518615.1 hypothetical protein [Brevibacillus fulvus] diamond 468 94.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
27024959 27024959 PRJNA934472_P_NODE_36582_length_247_cov_1.241379_g36204_i0 PRJNA934472 36582 247 1.241379 3.06620613 Staphylococcus gallinarum 1293 Bacteria Bacteria 159 7.27e-44   NR WP_232165844.1 1293 g36204 i0 100 1.9919028340081 82 0 99.6 0 246 1 208 289 WP_232165844.1 DUF262 domain-containing protein [Staphylococcus gallinarum] diamond 492 159 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus gallinarum
27056662 27056662 PRJNA934472_P_NODE_31022_length_267_cov_1.340206_g30644_i0 PRJNA934472 31022 267 1.340206 3.57835002 Parvimonas micra 33033 Bacteria Bacteria 122 5.64e-34   NR WP_324009556.1 33033 g30644 i0 100 0.674157303370786 60 0 67.4 0 86 265 1 60 WP_324009556.1 hypothetical protein, partial [Parvimonas micra] diamond 180 122 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Parvimonas Parvimonas micra
27119522 27119522 PRJNA934472_P_NODE_39782_length_231_cov_2.265823_g39404_i0 PRJNA934472 39782 231 2.265823 5.23405113 Anaerococcus senegalensis 1288120 Bacteria Bacteria 108 3.56e-27   NR WP_040397785.1 1288120 g39404 i0 100 0.701298701298701 54 0 70.1 0 1 162 182 235 WP_040397785.1 hypothetical protein [Anaerococcus senegalensis] diamond 162 108 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus senegalensis
27561874 27561874 PRJNA934472_P_NODE_37084_length_246_cov_0.890173_g36706_i0 PRJNA934472 37084 246 0.890173 2.18982558 Clostridium baratii 1561 Bacteria Bacteria 65.1 5.11e-10   NR WP_040113734.1 1561 g36706 i0 41.8 0.817073170731707 67 38 81.7 1 223 23 151 216 WP_040113734.1 metallophosphoesterase [Clostridium baratii] diamond 201 65.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium baratii
27909136 27909136 PRJNA934472_P_NODE_31325_length_266_cov_1.170984_g30947_i0 PRJNA934472 31325 266 1.170984 3.11481744 Anaerococcus sp. 1872515 Bacteria Bacteria 181 8.42e-51   NR WP_306483032.1 1872515 g30947 i0 98.9 0.992481203007519 88 1 99.2 0 264 1 2679 2766 WP_306483032.1 SpaA isopeptide-forming pilin-related protein [Anaerococcus sp.] diamond 264 181 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus sp.
27972571 27972571 PRJNA934472_P_NODE_35125_length_251_cov_1.477528_g34747_i0 PRJNA934472 35125 251 1.477528 3.70859528 Rossellomorea arthrocnemi 2769542 Bacteria Bacteria 105 2.97e-26   NR WP_230980990.1 2769542 g34747 i0 80 1.43426294820717 60 12 71.7 0 182 3 1 60 WP_230980990.1 MerR family transcriptional regulator [Rossellomorea arthrocnemi] diamond 360 105 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Rossellomorea Rossellomorea arthrocnemi
28004389 28004389 PRJNA934472_P_NODE_29225_length_274_cov_1.422886_g28847_i0 PRJNA934472 29225 274 1.422886 3.89870764 Pseudoflavonifractor capillosus 106588 Bacteria Bacteria 170 7.729999999999998e-47   NR WP_204871814.1 106588 g28847 i0 98.9 0.996350364963504 91 1 99.6 0 273 1 1981 2071 WP_204871814.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Pseudoflavonifractor capillosus] diamond 273 170 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Pseudoflavonifractor Pseudoflavonifractor capillosus
28351415 28351415 PRJNA934472_P_NODE_37026_length_246_cov_0.890173_g36648_i0 PRJNA934472 37026 246 0.890173 2.18982558 Terrisporobacter hibernicus 2813371 Bacteria Bacteria 95.9 1.36e-23   NR WP_228415817.1 2813371 g36648 i0 81.5 0.658536585365854 54 10 65.9 0 241 80 43 96 WP_228415817.1 hypothetical protein [Terrisporobacter hibernicus] diamond 162 95.9 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Terrisporobacter Terrisporobacter hibernicus
28919623 28919623 PRJNA934472_P_NODE_36328_length_248_cov_0.880000_g35950_i0 PRJNA934472 36328 248 0.88 2.1824 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 172 7.829999999999999e-52   NR MBS7305300.1 1898203 g35950 i0 100 0.991935483870968 82 0 99.2 0 248 3 122 203 MBS7305300.1 ChbG/HpnK family deacetylase [Lachnospiraceae bacterium] diamond 246 172 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29393515 29393515 PRJNA934472_P_NODE_38969_length_241_cov_0.886905_g38591_i0 PRJNA934472 38969 241 0.886905 2.13744105 Thermicanus aegyptius 94009 Bacteria Bacteria 112 2.71e-27   NR WP_005582964.1 94009 g38591 i0 61.3 0.995850622406639 80 31 99.6 0 1 240 195 274 WP_005582964.1 N-acetylmuramoyl-L-alanine amidase [Thermicanus aegyptius] diamond 240 112 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
29456214 29456214 PRJNA934472_P_NODE_37410_length_245_cov_0.895349_g37032_i0 PRJNA934472 37410 245 0.895349 2.19360505 Thermoanaerobacter sp. 1755 Bacteria Bacteria 65.1 2.7e-10   NR MDI3528695.1 1755 g37032 i0 73.2 0.502040816326531 41 11 50.2 0 21 143 1 41 MDI3528695.1 hypothetical protein [Thermoanaerobacter sp.] diamond 123 65.1 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacter Thermoanaerobacter sp.
29645572 29645572 PRJNA934472_P_NODE_35970_length_249_cov_0.875000_g35592_i0 PRJNA934472 35970 249 0.875 2.17875 Candidatus Allocopromorpha excrementavium 2840741 Bacteria Bacteria 92.8 5.19e-20   NR HIT98741.1 2840741 g35592 i0 59 0.939759036144578 78 32 94 0 248 15 38 115 HIT98741.1 ATP-binding protein [Candidatus Allocopromorpha excrementavium] diamond 234 92.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Candidatus Allocopromorpha Candidatus Allocopromorpha excrementavium
30309836 30309836 PRJNA934472_P_NODE_33472_length_257_cov_1.597826_g33094_i0 PRJNA934472 33472 257 1.597826 4.10641282 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 157 2.1799999999999998e-47   NR MCI6409429.1 1898203 g33094 i0 100 0.992217898832685 85 0 99.2 0 256 2 61 145 MCI6409429.1 flagellar protein FlaG [Lachnospiraceae bacterium] diamond 255 157 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30309837 30309837 PRJNA934472_P_NODE_35492_length_250_cov_1.502825_g35114_i0 PRJNA934472 35492 250 1.502825 3.7570625 Clostridium sp. 1506 Bacteria Bacteria 72.4 3.35e-13   NR WP_291674305.1 1506 g35114 i0 90 0.48 40 4 48 0 131 250 1 40 WP_291674305.1 hypothetical protein [Clostridium sp.] diamond 120 72.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
30372929 30372929 PRJNA934472_P_NODE_35972_length_249_cov_0.875000_g35594_i0 PRJNA934472 35972 249 0.875 2.17875 uncultured Anaerobutyricum sp. 2569100 Bacteria Bacteria 130 6.3899999999999985e-34   NR WP_296189918.1 2569100 g35594 i0 78 0.987951807228916 82 18 98.8 0 249 4 11 92 WP_296189918.1 FtsW/RodA/SpoVE family cell cycle protein [uncultured Anaerobutyricum sp.] diamond 246 130 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaerobutyricum uncultured Anaerobutyricum sp.
30467645 30467645 PRJNA934472_P_NODE_38193_length_243_cov_0.905882_g37815_i0 PRJNA934472 38193 243 0.905882 2.20129326 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 132 5.13e-38   NR MCI6409058.1 1898203 g37815 i0 100 1.62962962962963 66 0 81.5 0 241 44 32 97 MCI6409058.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Lachnospiraceae bacterium] diamond 396 132 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30758760 30758760 PRJNA934472_P_NODE_36314_length_248_cov_0.880000_g35936_i0 PRJNA934472 36314 248 0.88 2.1824 Bacillales 1385 Bacteria Bacteria 123 5.5e-31   NR WP_412964301.1 324854 g35936 i0 79.3 2.9758064516129 82 17 99.2 0 246 1 119 200 WP_412964301.1 MFS transporter [Metabacillus niabensis] diamond 738 123 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus niabensis
30814825 30814825 PRJNA934472_P_NODE_25794_length_290_cov_1.258065_g25416_i0 PRJNA934472 25794 290 1.258065 3.6483885 Exiguobacterium sp. S3 483245 Bacteria Bacteria 142 2.06e-39   NR WP_214780977.1 483245 g25416 i0 97.3 0.755172413793103 73 2 75.5 0 70 288 1 73 WP_214780977.1 phage protein [Exiguobacterium sp. S3] diamond 219 142 1 Bacteria   Bacillati Bacillota Bacilli Bacillales   Exiguobacterium Exiguobacterium sp. S3
31542037 31542037 PRJNA934472_P_NODE_29956_length_271_cov_1.797980_g29578_i0 PRJNA934472 29956 271 1.79798 4.8725258 Listeria monocytogenes 1639 Bacteria Bacteria 86.7 7.94e-20   NR WP_198491510.1 1639 g29578 i0 58.8 0.752767527675277 68 28 75.3 0 205 2 2 69 WP_198491510.1 hypothetical protein, partial [Listeria monocytogenes] diamond 204 86.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
31794727 31794727 PRJNA934472_P_NODE_36497_length_247_cov_1.689655_g36119_i0 PRJNA934472 36497 247 1.689655 4.17344785 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 141 1.5899999999999999e-40   NR MCI5479964.1 1898203 g36119 i0 79.3 0.995951417004049 82 17 99.6 0 2 247 4 85 MCI5479964.1 ANTAR domain-containing protein [Lachnospiraceae bacterium] diamond 246 141 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32648520 32648520 PRJNA934472_P_NODE_30700_length_268_cov_1.512821_g30322_i0 PRJNA934472 30700 268 1.512821 4.05436028 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 83.2 4.92e-17   NR MBS7338914.1 1898203 g30322 i0 100 0.985074626865672 88 0 98.5 0 266 3 34 121 MBS7338914.1 hypothetical protein [Lachnospiraceae bacterium] diamond 264 83.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32774682 32774682 PRJNA934472_P_NODE_37940_length_243_cov_1.805882_g37562_i0 PRJNA934472 37940 243 1.805882 4.38829326 Lachnoclostridium sp. An169 1965569 Bacteria Bacteria 159 1.64e-44   NR WP_087159943.1 1965569 g37562 i0 96.3 1 81 3 100 0 243 1 35 115 WP_087159943.1 hypothetical protein [Lachnoclostridium sp. An169] diamond 243 159 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnoclostridium Lachnoclostridium sp. An169
32806245 32806245 PRJNA934472_P_NODE_35280_length_251_cov_0.865169_g34902_i0 PRJNA934472 35280 251 0.865169 2.17157419 Staphylococcus 1279 Bacteria Bacteria 144 1.8299999999999994e-42   NR WP_242226847.1 1279 g34902 i0 100 0.776892430278884 65 0 77.7 0 249 55 50 114 WP_242226847.1 MULTISPECIES: type II toxin-antitoxin system MqsR family toxin [Staphylococcus] diamond 195 144 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus  

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