RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJEB75017" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJEB75017 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
135316 135316 PRJEB75017_P_NODE_11321_length_276_cov_1.364532_g11192_i0 PRJEB75017 11321 276 1.364532 3.76610832 PVC group 1783257 Bacteria Bacteria 120 5.1e-30   NR MBR5375943.1 1898203 g11192 i0 62.2 69.554347826087 90 32 95.7 1 2 265 46 135 MBR5375943.1 glutamine synthetase III [Lachnospiraceae bacterium] diamond 19197 121 0.991735537190083 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
2685379 2685379 PRJEB75017_P_NODE_11203_length_277_cov_1.529412_g11074_i0 PRJEB75017 11203 277 1.529412 4.23647124 Candidatus Onthocola gallistercoris 2840876 Bacteria Bacteria 139 9.01e-37   NR HIU03815.1 2840876 g11074 i0 66.7 1.96028880866426 90 30 97.5 0 7 276 214 303 HIU03815.1 family 1 glycosylhydrolase [Candidatus Onthocola gallistercoris] diamond 543 139 1 Bacteria   Bacillati Bacillota Bacilli     Candidatus Onthocola Candidatus Onthocola gallistercoris
11613813 11613813 PRJEB75017_P_NODE_13250_length_257_cov_1.695652_g13121_i0 PRJEB75017 13250 257 1.695652 4.35782564 Halanaerobium praevalens 2331 Bacteria Bacteria 158 5.24e-44   NR WP_014554159.1 2331 g13121 i0 92.9 1.98443579766537 85 6 99.2 0 257 3 340 424 WP_014554159.1 IMP dehydrogenase [Halanaerobium praevalens] diamond 510 158 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium praevalens
21812162 21812162 PRJEB75017_P_NODE_4478_length_414_cov_1.196481_g4349_i0 PRJEB75017 4478 414 1.196481 4.95343134 Bacillota 1239 Bacteria Bacteria 162 1.2999999999999996e-43   NR WP_008787537.1 100884 g4349 i0 57.7 14.9347826086957 137 57 99.3 1 411 1 334 469 WP_008787537.1 glutamine synthetase III [Coprobacillus cateniformis] diamond 6183 163 0.993865030674847 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Coprobacillaceae Coprobacillus Coprobacillus cateniformis
27223591 27223591 PRJEB75017_P_NODE_16503_length_246_cov_1.676301_g16374_i0 PRJEB75017 16503 246 1.676301 4.12370046 Paenibacillus sp. GP183 1882751 Bacteria Bacteria 103 3.28e-24   NR WP_090787275.1 1882751 g16374 i0 61.7 3.95121951219512 81 28 95.1 1 235 2 36 116 WP_090787275.1 alpha/beta hydrolase family esterase [Paenibacillus sp. GP183] diamond 972 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. GP183
27350485 27350485 PRJEB75017_P_NODE_10823_length_281_cov_1.125000_g10694_i0 PRJEB75017 10823 281 1.125 3.16125 Bacillus mobilis 2026190 Bacteria Bacteria 49.7 2.21e-4   NR WP_327799871.1 2026190 g10694 i0 45.8 0.886120996441281 83 39 87.5 3 250 5 1375 1452 WP_327799871.1 DUF7507 domain-containing protein [Bacillus mobilis] diamond 249 49.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus mobilis
27413665 27413665 PRJEB75017_P_NODE_16223_length_247_cov_0.896552_g16094_i0 PRJEB75017 16223 247 0.896552 2.21448344 Enterococcus cecorum 44008 Bacteria Bacteria 115 6.75e-31   NR OUN51481.1 44008 g16094 i0 93.3 2.18623481781377 60 4 72.9 0 247 68 92 151 OUN51481.1 hypothetical protein B5G19_00620 [Enterococcus cecorum] diamond 540 115 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus cecorum
27571254 27571254 PRJEB75017_P_NODE_15884_length_248_cov_0.891429_g15755_i0 PRJEB75017 15884 248 0.891429 2.21074392 Halanaerobium sp. MDAL1 1898548 Bacteria Bacteria 78.6 9.67e-15   NR OEG62285.1 1898548 g15755 i0 80.4 1.11290322580645 46 9 55.6 0 108 245 1 46 OEG62285.1 MAG: hypothetical protein BHK79_07155 [Halanaerobium sp. MDAL1] diamond 276 78.6 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium sp. MDAL1
27634577 27634577 PRJEB75017_P_NODE_13424_length_256_cov_0.819672_g13295_i0 PRJEB75017 13424 256 0.819672 2.09836032 Ruminococcus sp. 41978 Bacteria Bacteria 75.9 2.1e-15   NR MBQ1814427.1 41978 g13295 i0 54.2 1.3828125 59 27 69.1 0 243 67 63 121 MBQ1814427.1 hypothetical protein [Ruminococcus sp.] diamond 354 75.9 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
28353368 28353368 PRJEB75017_P_NODE_17526_length_244_cov_0.912281_g17397_i0 PRJEB75017 17526 244 0.912281 2.22596564 Bacillati 1783272 Bacteria Bacteria 45.8 0.00325   NR WP_268632640.1 44250 g17397 i0 41.9 3.25819672131148 43 25 52.9 0 225 97 2526 2568 WP_268632640.1 non-ribosomal peptide synthetase/type I polyketide synthase [Paenibacillus alvei] diamond 795 46.2 0.991341991341991 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus alvei
28858499 28858499 PRJEB75017_P_NODE_8088_length_316_cov_1.279835_g7959_i0 PRJEB75017 8088 316 1.279835 4.0442786 Clostridia 186801 Bacteria Bacteria 43.9 0.0334   NR WP_024861356.1 1265 g7959 i0 41.8 1.06329113924051 55 31 52.2 1 311 147 428 481 WP_024861356.1 leucine-rich repeat domain-containing protein [Ruminococcus flavefaciens] diamond 336 44.3 0.99097065462754 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus flavefaciens
29016824 29016824 PRJEB75017_P_NODE_12128_length_268_cov_1.400000_g11999_i0 PRJEB75017 12128 268 1.4 3.752 Bacillati 1783272 Bacteria Bacteria 67 1.52e-10   NR WP_094868791.1 1986222 g11999 i0 46.3 7.8134328358209 80 41 89.6 1 19 258 2005 2082 WP_094868791.1 DUF7507 domain-containing protein [Paenibacillus sp. VTT E-133280] diamond 2094 67.4 0.99406528189911 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. VTT E-133280
29339540 29339540 PRJEB75017_P_NODE_18829_length_228_cov_2.664516_g18700_i0 PRJEB75017 18829 228 2.664516 6.07509648 Salinicoccus sp. YB14-2 1572701 Bacteria Bacteria 143 6.55e-41   NR WP_052256675.1 1572701 g18700 i0 94.7 0.986842105263158 75 4 98.7 0 3 227 157 231 WP_052256675.1 orotidine-5'-phosphate decarboxylase [Salinicoccus sp. YB14-2] diamond 225 143 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Salinicoccus Salinicoccus sp. YB14-2
29528995 29528995 PRJEB75017_P_NODE_18350_length_242_cov_0.923077_g18221_i0 PRJEB75017 18350 242 0.923077 2.23384634 Clostridium 1485 Bacteria Bacteria 111 2.04e-27   NR WP_317273973.1 1485 g18221 i0 72.2 0.892561983471074 72 20 89.3 0 242 27 215 286 WP_317273973.1 MULTISPECIES: 1-phosphofructokinase [Clostridium] diamond 216 111 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium  
29616056 29616056 PRJEB75017_P_NODE_16170_length_247_cov_1.344828_g16041_i0 PRJEB75017 16170 247 1.344828 3.32172516 PVC group 1783257 Bacteria Bacteria 138 8.86e-37   NR WP_036944508.1 35825 g16041 i0 82.7 24.5951417004049 81 14 98.4 0 3 245 8 88 WP_036944508.1 adenosylhomocysteinase [Pseudobacteroides cellulosolvens] diamond 6075 139 0.992805755395683 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Pseudobacteroides Pseudobacteroides cellulosolvens
30002723 30002723 PRJEB75017_P_NODE_13271_length_257_cov_1.271739_g13142_i0 PRJEB75017 13271 257 1.271739 3.26836923 Peptococcaceae bacterium 2052179 Bacteria Bacteria 42.7 0.0443   NR MDO4923033.1 2052179 g13142 i0 40.7 0.630350194552529 54 32 63 0 253 92 155 208 MDO4923033.1 alkaline phosphatase family protein [Peptococcaceae bacterium] diamond 162 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Peptococcaceae   Peptococcaceae bacterium
30034283 30034283 PRJEB75017_P_NODE_14591_length_251_cov_0.876404_g14462_i0 PRJEB75017 14591 251 0.876404 2.19977404 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 58.2 1.52e-7   NR MEE1039786.1 1898203 g14462 i0 43.1 1.73306772908367 72 37 86.1 1 247 32 78 145 MEE1039786.1 protein kinase [Lachnospiraceae bacterium] diamond 435 58.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30160312 30160312 PRJEB75017_P_NODE_14672_length_251_cov_0.876404_g14543_i0 PRJEB75017 14672 251 0.876404 2.19977404 Paenibacillus thermotolerans 3027807 Bacteria Bacteria 48.5 3.86e-4   NR WP_274364956.1 3027807 g14543 i0 58.1 0.370517928286853 31 13 37.1 0 250 158 127 157 WP_274364956.1 S-layer homology domain-containing protein [Paenibacillus thermotolerans] diamond 93 48.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus thermotolerans
30982187 30982187 PRJEB75017_P_NODE_16294_length_247_cov_0.896552_g16165_i0 PRJEB75017 16294 247 0.896552 2.21448344 Bacilli bacterium 1903720 Bacteria Bacteria 54.7 2.42e-6   NR HOH61227.1 1903720 g16165 i0 46.9 0.595141700404858 49 26 59.5 0 16 162 584 632 HOH61227.1 hypothetical protein [Bacilli bacterium] diamond 147 54.7 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31234671 31234671 PRJEB75017_P_NODE_10615_length_283_cov_1.114286_g10486_i0 PRJEB75017 10615 283 1.114286 3.15342938 Lacticaseibacillus pantheris 171523 Bacteria Bacteria 45.1 0.00514   NR WP_225350196.1 171523 g10486 i0 58.3 1.43109540636042 36 13 36 1 151 252 135 170 WP_225350196.1 ABC transporter ATP-binding protein [Lacticaseibacillus pantheris] diamond 405 45.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus pantheris
31393137 31393137 PRJEB75017_P_NODE_15696_length_248_cov_1.571429_g15567_i0 PRJEB75017 15696 248 1.571429 3.89714392 Orenia marismortui 46469 Bacteria Bacteria 88.6 6.34e-21   NR WP_018250339.1 46469 g15567 i0 50.7 0.883064516129032 73 35 87.1 1 3 218 12 84 WP_018250339.1 hypothetical protein [Orenia marismortui] diamond 219 88.6 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halobacteroidaceae Orenia Orenia marismortui
31488102 31488102 PRJEB75017_P_NODE_18876_length_227_cov_2.019481_g18747_i0 PRJEB75017 18876 227 2.019481 4.58422187 Clostridium sp. 1506 Bacteria Bacteria 45.8 0.00242   NR MBS5719324.1 1506 g18747 i0 54.3 0.607929515418502 46 20 59.5 1 227 93 2 47 MBS5719324.1 zinc-ribbon domain-containing protein [Clostridium sp.] diamond 138 45.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
31614351 31614351 PRJEB75017_P_NODE_12856_length_261_cov_1.287234_g12727_i0 PRJEB75017 12856 261 1.287234 3.35968074 Halanaerobacter sp. 3080552 Bacteria Bacteria 130 2.9699999999999997e-35   NR MFO7820342.1 3080552 g12727 i0 81.4 1.97701149425287 86 16 98.9 0 2 259 93 178 MFO7820342.1 Flp pilus assembly protein CpaB [Halanaerobacter sp.] diamond 516 130 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halobacteroidaceae Halanaerobacter Halanaerobacter sp.
32588034 32588034 PRJEB75017_P_NODE_6479_length_348_cov_1.701818_g6350_i0 PRJEB75017 6479 348 1.701818 5.92232664 Clostridium 1485 Bacteria Bacteria 51.2 2.82e-5   NR WP_286905866.1 1946348 g6350 i0 32.5 1.37931034482759 80 50 68.1 2 237 1 11 87 WP_286905866.1 ATP-binding protein [Clostridium sp. UBA1652] diamond 480 51.6 0.992248062015504 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. UBA1652
32878365 32878365 PRJEB75017_P_NODE_18720_length_235_cov_2.814815_g18591_i0 PRJEB75017 18720 235 2.814815 6.61481525 Halanaerobiales bacterium 2094029 Bacteria Bacteria 92.4 2.61e-21   NR MCF8000668.1 2094029 g18591 i0 97.9 0.612765957446809 48 1 61.3 0 2 145 143 190 MCF8000668.1 potassium-transporting ATPase subunit KdpC [Halanaerobiales bacterium] diamond 144 92.4 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales     Halanaerobiales 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);;