RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA781427" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA781427 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
10966038 10966038 PRJNA781427_P_NODE_91149_length_243_cov_1.358824_g90265_i0 PRJNA781427 91149 243 1.358824 3.30194232 Bacilli bacterium 1903720 Bacteria Bacteria 122 7.33e-32   NR MFV0424572.1 1903720 g90265 i0 74 4.54320987654321 73 19 90.1 0 223 5 3 75 MFV0424572.1 DNA cytosine methyltransferase [Bacilli bacterium] diamond 1104 122 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
22439017 22439017 PRJNA781427_P_NODE_81578_length_248_cov_0.880000_g80694_i0 PRJNA781427 81578 248 0.88 2.1824 root 1 Root_unresolved Root_unresolved 101 2.13e-25   NR WP_204186787.1 1597 g80694 i0 68.3 47.5040322580645 82 26 99.2 0 248 3 12 93 WP_204186787.1 50S ribosomal protein L23, partial [Lacticaseibacillus paracasei] diamond 11781 101 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
26768691 26768691 PRJNA781427_P_NODE_75241_length_251_cov_0.865169_g74357_i0 PRJNA781427 75241 251 0.865169 2.17157419 uncultured Anaerococcus sp. 293428 Bacteria Bacteria 99 5.54e-24   NR WP_308748679.1 293428 g74357 i0 97.9 0.561752988047809 47 1 56.2 0 142 2 1 47 WP_308748679.1 NUDIX hydrolase [uncultured Anaerococcus sp.] diamond 141 99 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus uncultured Anaerococcus sp.
26800352 26800352 PRJNA781427_P_NODE_88641_length_245_cov_0.895349_g87757_i0 PRJNA781427 88641 245 0.895349 2.19360505 Clostridium botulinum 1491 Bacteria Bacteria 125 1.3e-32   NR WP_079006099.1 1491 g87757 i0 100 0.73469387755102 60 0 73.5 0 244 65 274 333 WP_079006099.1 class I SAM-dependent methyltransferase [Clostridium botulinum] diamond 180 125 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
27085256 27085256 PRJNA781427_P_NODE_89882_length_244_cov_0.900585_g88998_i0 PRJNA781427 89882 244 0.900585 2.1974274 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 43.1 0.0276   NR MBE6672871.1 2485925 g88998 i0 32.6 1.05737704918033 86 47 95.9 3 243 10 66 148 MBE6672871.1 hypothetical protein [Oscillospiraceae bacterium] diamond 258 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
27116570 27116570 PRJNA781427_P_NODE_64262_length_276_cov_1.354680_g63378_i0 PRJNA781427 64262 276 1.35468 3.7389168 Enterococcus pseudoavium 44007 Bacteria Bacteria 55.5 1.48e-6   NR WP_311848056.1 44007 g63378 i0 40.8 2.27173913043478 71 42 77.2 0 58 270 66 136 WP_311848056.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Enterococcus pseudoavium] diamond 627 55.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus pseudoavium
27243171 27243171 PRJNA781427_P_NODE_11783_length_761_cov_9.078488_g11013_i0 PRJNA781427 11783 761 9.078488 69.08729368 Staphylococcus warneri 1292 Bacteria Bacteria 446 2e-157   NR WP_160175718.1 1292 g11013 i0 99.5 0.863337713534823 219 1 86.3 0 25 681 1 219 WP_160175718.1 Kunitz family serine protease inhibitor, partial [Staphylococcus warneri] diamond 657 446 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
27243198 27243198 PRJNA781427_P_NODE_55763_length_299_cov_1.699115_g54879_i0 PRJNA781427 55763 299 1.699115 5.08035385 Tissierellales bacterium 2053631 Bacteria Bacteria 136 4.9099999999999995e-37   NR MFA5524981.1 2053631 g54879 i0 73.1 1.86622073578595 93 25 93.3 0 19 297 1 93 MFA5524981.1 CoA ester lyase [Tissierellales bacterium] diamond 558 136 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales     Tissierellales bacterium
27369951 27369951 PRJNA781427_P_NODE_66943_length_269_cov_1.311224_g66059_i0 PRJNA781427 66943 269 1.311224 3.52719256 Clostridiales bacterium 1898207 Bacteria Bacteria 44.3 0.0136   NR HCO63084.1 1898207 g66059 i0 34.3 0.747211895910781 67 33 65.8 3 229 53 126 189 HCO63084.1 alpha/beta hydrolase [Clostridiales bacterium] diamond 201 44.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27938074 27938074 PRJNA781427_P_NODE_15605_length_637_cov_1.750000_g14770_i0 PRJNA781427 15605 637 1.75 11.1475 Erysipelotrichaceae 128827 Bacteria Bacteria 222 2.19e-68   NR WP_117518857.1 128827 g14770 i0 49.3 0.984301412872841 209 106 98.4 0 6 632 71 279 WP_117518857.1 MULTISPECIES: LacI family DNA-binding transcriptional regulator [Erysipelotrichaceae] diamond 627 222 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae    
28032893 28032893 PRJNA781427_P_NODE_91185_length_243_cov_1.352941_g90301_i0 PRJNA781427 91185 243 1.352941 3.28764663 Paraclostridium sordellii 1505 Bacteria Bacteria 101 3.45e-24   NR WP_055337559.1 1505 g90301 i0 60.5 1 81 31 98.8 1 242 3 77 157 WP_055337559.1 DNA-methyltransferase [Paraclostridium sordellii] diamond 243 101 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Paraclostridium Paraclostridium sordellii
28380019 28380019 PRJNA781427_P_NODE_58666_length_290_cov_1.981567_g57782_i0 PRJNA781427 58666 290 1.981567 5.7465443 Staphylococcus warneri 1292 Bacteria Bacteria 156 8.15e-47   NR WP_160175716.1 1292 g57782 i0 91 0.806896551724138 78 7 80.7 0 57 290 1 78 WP_160175716.1 jacalin-like lectin, partial [Staphylococcus warneri] diamond 234 156 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
28411702 28411702 PRJNA781427_P_NODE_30946_length_417_cov_1.343023_g30065_i0 PRJNA781427 30946 417 1.343023 5.60040591 Clostridia bacterium 2044939 Bacteria Bacteria 113 1.27e-27   NR NCC74944.1 2044939 g30065 i0 49.5 1.58273381294964 109 55 78.4 0 415 89 97 205 NCC74944.1 pyrroline-5-carboxylate reductase [Clostridia bacterium] diamond 660 113 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28515729 28515729 PRJNA781427_P_NODE_43687_length_344_cov_1.040590_g42805_i0 PRJNA781427 43687 344 1.04059 3.5796296 root 1 Root_unresolved Root_unresolved 106 2.17e-27   NR MDK0835636.1 1502 g42805 i0 73.6 4.08139534883721 72 16 60.2 2 292 86 13 84 MDK0835636.1 hypothetical protein [Clostridium perfringens] diamond 1404 107 0.990654205607477 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
28569387 28569387 PRJNA781427_P_NODE_27767_length_445_cov_1.241935_g26886_i0 PRJNA781427 27767 445 1.241935 5.52661075 Clostridioides difficile 1496 Bacteria Bacteria 253 7.6e-84   NR MCJ0307450.1 1496 g26886 i0 84.2 0.984269662921348 146 23 98.4 0 2 439 7 152 MCJ0307450.1 hypothetical protein [Clostridioides difficile] diamond 438 253 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
28926042 28926042 PRJNA781427_P_NODE_86268_length_246_cov_0.890173_g85384_i0 PRJNA781427 86268 246 0.890173 2.18982558 Clostridia 186801 Bacteria Bacteria 107 2.83e-26   NR KUK64008.1 1641375 g85384 i0 70.4 4.9390243902439 81 24 98.8 0 244 2 210 290 KUK64008.1 MAG: Zinc ABC transport system zinc-binding protein ZnuA [Desulfotomaculum sp. 46_80] diamond 1215 108 0.990740740740741 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfotomaculaceae Desulfotomaculum Desulfotomaculum sp. 46_80
28948629 28948629 PRJNA781427_P_NODE_97548_length_231_cov_2.253165_g96664_i0 PRJNA781427 97548 231 2.253165 5.20481115 Aedoeadaptatus coxii 755172 Bacteria Bacteria 61.2 1.01e-8   NR WP_322630440.1 755172 g96664 i0 79.4 0.883116883116883 34 7 44.2 0 231 130 2345 2378 WP_322630440.1 hypothetical protein [Aedoeadaptatus coxii] diamond 204 61.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus Aedoeadaptatus coxii
28957909 28957909 PRJNA781427_P_NODE_75688_length_251_cov_0.865169_g74804_i0 PRJNA781427 75688 251 0.865169 2.17157419 PVC group 1783257 Bacteria Bacteria 57 1.28e-8   NR MEW6425794.1 1879010 g74804 i0 63.2 0.908366533864542 38 14 45.4 0 1 114 30 67 MEW6425794.1 transcriptional coactivator p15/PC4 family protein [Bacillota bacterium] diamond 228 57.4 0.993031358885017 Bacteria   Bacillati Bacillota         Bacillota bacterium
29052547 29052547 PRJNA781427_P_NODE_55748_length_299_cov_1.703540_g54864_i0 PRJNA781427 55748 299 1.70354 5.0935846 Bacteria 2 Bacteria Bacteria 125 2.71e-34   NR WP_160175716.1 1292 g54864 i0 100 1.18394648829431 59 0 59.2 0 298 122 89 147 WP_160175716.1 jacalin-like lectin, partial [Staphylococcus warneri] diamond 354 125 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri
29579574 29579574 PRJNA781427_P_NODE_15970_length_628_cov_2.138739_g15131_i0 PRJNA781427 15970 628 2.138739 13.43128092 Clostridioides difficile 1496 Bacteria Bacteria 265 1.5999999999999997e-87   NR MCJ0307450.1 1496 g15131 i0 84.4 0.735668789808917 154 22 73.6 1 628 167 1 152 MCJ0307450.1 hypothetical protein [Clostridioides difficile] diamond 462 265 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
30116664 30116664 PRJNA781427_P_NODE_76612_length_250_cov_0.870056_g75728_i0 PRJNA781427 76612 250 0.870056 2.17514 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 160 2.06e-45   NR MBR5732649.1 1898203 g75728 i0 98.8 0.984 82 1 98.4 0 248 3 17 98 MBR5732649.1 DUF87 domain-containing protein [Lachnospiraceae bacterium] diamond 246 160 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
30116670 30116670 PRJNA781427_P_NODE_86732_length_245_cov_1.656977_g85848_i0 PRJNA781427 86732 245 1.656977 4.05959365 Tissierellales bacterium 2053631 Bacteria Bacteria 141 1.87e-39   NR MFA5524981.1 2053631 g85848 i0 80.2 0.991836734693878 81 16 99.2 0 243 1 174 254 MFA5524981.1 CoA ester lyase [Tissierellales bacterium] diamond 243 141 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales     Tissierellales bacterium
31127447 31127447 PRJNA781427_P_NODE_81915_length_248_cov_0.880000_g81031_i0 PRJNA781427 81915 248 0.88 2.1824 Clostridia bacterium 2044939 Bacteria Bacteria 82.4 4.25e-16   NR MQY59143.1 2044939 g81031 i0 89.1 0.556451612903226 46 5 55.6 0 1 138 619 664 MQY59143.1 hypothetical protein [Clostridia bacterium] diamond 138 82.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31864370 31864370 PRJNA781427_P_NODE_74477_length_251_cov_0.865169_g73593_i0 PRJNA781427 74477 251 0.865169 2.17157419 Bacillaceae 186817 Bacteria Bacteria 139 1.4100000000000001e-36   NR WP_108669543.1 2171554 g73593 i0 73.5 2.97609561752988 83 22 99.2 0 2 250 190 272 WP_108669543.1 DNA packaging protein [Peribacillus acanthi] diamond 747 139 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Peribacillus Peribacillus acanthi
32203296 32203296 PRJNA781427_P_NODE_64078_length_277_cov_0.995098_g63194_i0 PRJNA781427 64078 277 0.995098 2.75642146 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 44.7 0.0118   NR MBR3833321.1 1898203 g63194 i0 37.8 0.487364620938628 45 28 48.7 0 152 18 79 123 MBR3833321.1 AAA family ATPase [Lachnospiraceae bacterium] diamond 135 44.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32330179 32330179 PRJNA781427_P_NODE_89219_length_244_cov_0.900585_g88335_i0 PRJNA781427 89219 244 0.900585 2.1974274 Bacillota bacterium 1879010 Bacteria Bacteria 42.7 0.0347   NR HHU76495.1 1879010 g88335 i0 35.7 0.860655737704918 70 40 86.1 2 14 223 53 117 HHU76495.1 4Fe-4S dicluster domain-containing protein [Bacillota bacterium] diamond 210 42.7 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32866209 32866209 PRJNA781427_P_NODE_97680_length_228_cov_2.019355_g96796_i0 PRJNA781427 97680 228 2.019355 4.6041294 Staphylococcus warneri 1292 Bacteria Bacteria 84.7 3.1e-18   NR WP_160175744.1 1292 g96796 i0 88.4 0.565789473684211 43 5 56.6 0 2 130 162 204 WP_160175744.1 Kunitz-type protease inhibitor, partial [Staphylococcus warneri] diamond 129 84.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus warneri

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