RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1008624 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
6532163 6532163 PRJNA1008624_P_NODE_15106_length_217_cov_1.505952_g14918_i0 PRJNA1008624 15106 217 1.505952 3.26791584 Streptococcus pneumoniae 1313 Bacteria Bacteria 118 1.4799999999999998e-32   NR MBX4482175.1 1313 g14918 i0 100 1.63133640552995 59 0 81.6 0 2 178 48 106 MBX4482175.1 amino acid ABC transporter ATP-binding protein [Streptococcus pneumoniae] diamond 354 118 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
10357004 10357004 PRJNA1008624_P_NODE_11429_length_247_cov_1.762626_g11241_i0 PRJNA1008624 11429 247 1.762626 4.35368622 Bacteria 2 Bacteria Bacteria 77.4 1.29e-16   NR HBN6228237.1 1496 g11241 i0 100 0.850202429149798 35 0 42.5 0 247 143 41 75 HBN6228237.1 dihydroxyacetone kinase subunit DhaK [Clostridioides difficile] diamond 210 77.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
10357776 10357776 PRJNA1008624_P_NODE_6569_length_328_cov_2.738351_g6381_i0 PRJNA1008624 6569 328 2.738351 8.98179128 Clostridioides difficile 1496 Bacteria Bacteria 199 7.87e-64   NR HBN6228182.1 1496 g6381 i0 100 0.932926829268293 102 0 93.3 0 326 21 34 135 HBN6228182.1 ABC transporter ATP-binding protein [Clostridioides difficile] diamond 306 199 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
27311740 27311740 PRJNA1008624_P_NODE_31343_length_166_cov_0.888889_g31155_i0 PRJNA1008624 31343 166 0.888889 1.47555574 Bacillales 1385 Bacteria Bacteria 45.1 0.00199   NR MDT2295506.1 1464 g31155 i0 59.5 3.83132530120482 37 15 66.9 0 166 56 239 275 MDT2295506.1 DNA (cytosine-5-)-methyltransferase [Paenibacillus larvae] diamond 636 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus larvae
27445629 27445629 PRJNA1008624_P_NODE_30763_length_166_cov_0.888889_g30575_i0 PRJNA1008624 30763 166 0.888889 1.47555574 [Clostridium] innocuum 1522 Bacteria Bacteria 45.1 0.002   NR WP_233106945.1 1522 g30575 i0 47.7 0.795180722891566 44 21 79.5 1 28 159 69 110 WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum] diamond 132 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium [Clostridium] innocuum
27445631 27445631 PRJNA1008624_P_NODE_31223_length_166_cov_0.888889_g31035_i0 PRJNA1008624 31223 166 0.888889 1.47555574 Clostridiales bacterium 1898207 Bacteria Bacteria 93.6 6.82e-22   NR HAS92843.1 1898207 g31035 i0 79.2 0.957831325301205 53 11 95.8 0 161 3 14 66 HAS92843.1 hypothetical protein [Clostridiales bacterium] diamond 159 93.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27508660 27508660 PRJNA1008624_P_NODE_28503_length_168_cov_0.873950_g28315_i0 PRJNA1008624 28503 168 0.87395 1.468236 Butyrivibrio sp. 28121 Bacteria Bacteria 49.3 6.35e-5   NR WP_292208651.1 28121 g28315 i0 59.4 0.571428571428571 32 13 57.1 0 2 97 113 144 WP_292208651.1 macro domain-containing protein [Butyrivibrio sp.] diamond 96 49.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Butyrivibrio Butyrivibrio sp.
27698310 27698310 PRJNA1008624_P_NODE_31224_length_166_cov_0.888889_g31036_i0 PRJNA1008624 31224 166 0.888889 1.47555574 Streptococcus pneumoniae 1313 Bacteria Bacteria 72 3.88e-15   NR WP_223688341.1 1313 g31036 i0 97.4 0.686746987951807 38 1 68.7 0 3 116 23 60 WP_223688341.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 114 72 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
28202878 28202878 PRJNA1008624_P_NODE_29126_length_168_cov_0.873950_g28938_i0 PRJNA1008624 29126 168 0.87395 1.468236 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 59.3 1.9e-8   NR MBR3610057.1 2485925 g28938 i0 56.6 0.946428571428571 53 12 94.6 1 161 3 1196 1237 MBR3610057.1 hypothetical protein [Oscillospiraceae bacterium] diamond 159 59.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28416796 28416796 PRJNA1008624_P_NODE_30346_length_167_cov_0.881356_g30158_i0 PRJNA1008624 30346 167 0.881356 1.47186452 root 1 Root_unresolved Root_unresolved 86.7 7.01e-20   NR MFA5153779.1 2044939 g30158 i0 72.2 2.91017964071856 54 15 97 0 4 165 73 126 MFA5153779.1 macro domain-containing protein [Clostridia bacterium] diamond 486 86.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28708464 28708464 PRJNA1008624_P_NODE_36987_length_162_cov_0.920354_g36799_i0 PRJNA1008624 36987 162 0.920354 1.49097348 Symbiobacterium terraclitae 557451 Bacteria Bacteria 45.4 0.00132   NR WP_374713316.1 557451 g36799 i0 43.1 0.944444444444444 51 27 94.4 1 157 5 57 105 WP_374713316.1 hypothetical protein [Symbiobacterium terraclitae] diamond 153 45.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Symbiobacteriaceae Symbiobacterium Symbiobacterium terraclitae
29024423 29024423 PRJNA1008624_P_NODE_27288_length_169_cov_0.866667_g27100_i0 PRJNA1008624 27288 169 0.866667 1.46466723 Paenibacillus ginsengarvi 400777 Bacteria Bacteria 56.2 2.37e-7   NR WP_120745458.1 400777 g27100 i0 44.6 1.98816568047337 56 31 99.4 0 168 1 199 254 WP_120745458.1 phage portal protein [Paenibacillus ginsengarvi] diamond 336 56.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus ginsengarvi
29055747 29055747 PRJNA1008624_P_NODE_32288_length_165_cov_0.896552_g32100_i0 PRJNA1008624 32288 165 0.896552 1.4793108 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 75.1 1.55e-15   NR MFK5280848.1 1597 g32100 i0 60.4 0.963636363636364 53 21 96.4 0 5 163 79 131 MFK5280848.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 159 75.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
29245108 29245108 PRJNA1008624_P_NODE_30949_length_166_cov_0.888889_g30761_i0 PRJNA1008624 30949 166 0.888889 1.47555574 Fusibacter sp. 2004507 Bacteria Bacteria 85.1 1.55e-17   NR HSN67330.1 2004507 g30761 i0 83.3 0.975903614457831 54 9 97.6 0 5 166 74 127 HSN67330.1 reverse transcriptase domain-containing protein [Fusibacter sp.] diamond 162 85.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriales Family XII. Incertae Sedis Fusibacter Fusibacter sp.
29339897 29339897 PRJNA1008624_P_NODE_31249_length_166_cov_0.888889_g31061_i0 PRJNA1008624 31249 166 0.888889 1.47555574 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 120 3.09e-34   NR MFK5283129.1 1597 g31061 i0 98.1 0.957831325301205 53 1 95.8 0 6 164 1 53 MFK5283129.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 159 120 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
29497624 29497624 PRJNA1008624_P_NODE_34250_length_164_cov_0.904348_g34062_i0 PRJNA1008624 34250 164 0.904348 1.48313072 Listeria monocytogenes 1639 Bacteria Bacteria 93.6 1.8299999999999994e-23   NR WP_333729467.1 1639 g34062 i0 93.9 0.896341463414634 49 3 89.6 0 160 14 31 79 WP_333729467.1 hypothetical protein, partial [Listeria monocytogenes] diamond 147 93.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
29655118 29655118 PRJNA1008624_P_NODE_6590_length_327_cov_3.100719_g6402_i0 PRJNA1008624 6590 327 3.100719 10.13935113 Romboutsia sedimentorum 1368474 Bacteria Bacteria 101 9.34e-24   NR WP_284131535.1 1368474 g6402 i0 55.7 0.889908256880734 97 39 88.1 2 322 35 156 249 WP_284131535.1 formate/nitrite transporter family protein [Romboutsia sedimentorum] diamond 291 101 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sedimentorum
29749959 29749959 PRJNA1008624_P_NODE_30531_length_166_cov_1.717949_g30343_i0 PRJNA1008624 30531 166 1.717949 2.85179534 Loigolactobacillus coryniformis 1610 Bacteria Bacteria 62.4 3.39e-11   NR WP_249567895.1 1610 g30343 i0 97 0.596385542168675 33 1 59.6 0 161 63 40 72 WP_249567895.1 hypothetical protein, partial [Loigolactobacillus coryniformis] diamond 99 62.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Loigolactobacillus Loigolactobacillus coryniformis
30128983 30128983 PRJNA1008624_P_NODE_28992_length_168_cov_0.873950_g28804_i0 PRJNA1008624 28992 168 0.87395 1.468236 Clostridia bacterium 2044939 Bacteria Bacteria 50.8 1.93e-5   NR HML69724.1 2044939 g28804 i0 50 1.03571428571429 58 26 98.2 1 165 1 141 198 HML69724.1 phage portal protein [Clostridia bacterium] diamond 174 50.8 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30280231 30280231 PRJNA1008624_P_NODE_2752_length_519_cov_4.244681_g2571_i0 PRJNA1008624 2752 519 4.244681 22.02989439 Bacteria 2 Bacteria Bacteria 150 1.1099999999999999e-43   NR OJH15975.1 1914540 g2571 i0 94.8 0.890173410404624 77 4 44.5 0 517 287 10 86 OJH15975.1 2-methylcitrate dehydratase, partial [Bacillus obstructivus] diamond 462 150 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus obstructivus
30319416 30319416 PRJNA1008624_P_NODE_24832_length_175_cov_3.166667_g24644_i0 PRJNA1008624 24832 175 3.166667 5.54166725 Bacillus sp. ICE1 3083289 Bacteria Bacteria 115 1.3499999999999998e-31   NR MDV9081273.1 3083289 g24644 i0 96.5 1.95428571428571 57 2 97.7 0 174 4 26 82 MDV9081273.1 hypothetical protein [Bacillus sp. ICE1] diamond 342 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. ICE1
30319426 30319426 PRJNA1008624_P_NODE_8272_length_291_cov_1.000000_g8084_i0 PRJNA1008624 8272 291 1 2.91 Bacillus obstructivus 1914540 Bacteria Bacteria 88.2 1.73e-20   NR OJH15914.1 1914540 g8084 i0 91.5 0.484536082474227 47 4 48.5 0 149 289 1 47 OJH15914.1 hypothetical protein BLX88_26460, partial [Bacillus obstructivus] diamond 141 88.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus obstructivus
30413947 30413947 PRJNA1008624_P_NODE_27293_length_169_cov_0.866667_g27105_i0 PRJNA1008624 27293 169 0.866667 1.46466723 Loigolactobacillus coryniformis 1610 Bacteria Bacteria 52.4 4.43e-7   NR WP_249567990.1 1610 g27105 i0 100 0.390532544378698 22 0 39.1 0 68 3 1 22 WP_249567990.1 hypothetical protein, partial [Loigolactobacillus coryniformis] diamond 66 52.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Loigolactobacillus Loigolactobacillus coryniformis
30445410 30445410 PRJNA1008624_P_NODE_33973_length_164_cov_0.904348_g33785_i0 PRJNA1008624 33973 164 0.904348 1.48313072 Anaerocolumna chitinilytica 1727145 Bacteria Bacteria 59.3 1.8e-8   NR WP_185256975.1 1727145 g33785 i0 59.3 0.98780487804878 54 22 98.8 0 1 162 232 285 WP_185256975.1 hypothetical protein [Anaerocolumna chitinilytica] diamond 162 59.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaerocolumna Anaerocolumna chitinilytica
30824359 30824359 PRJNA1008624_P_NODE_2774_length_517_cov_2.049145_g2593_i0 PRJNA1008624 2774 517 2.049145 10.59407965 Clostridioides difficile 1496 Bacteria Bacteria 353 1.38e-122   NR HBN6228176.1 1496 g2593 i0 100 0.992263056092843 171 0 99.2 0 517 5 6 176 HBN6228176.1 hypothetical protein [Clostridioides difficile] diamond 513 353 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
30911861 30911861 PRJNA1008624_P_NODE_15414_length_215_cov_1.807229_g15226_i0 PRJNA1008624 15414 215 1.807229 3.88554235 Bacteria 2 Bacteria Bacteria 64.7 2.05e-11   NR KAF8254224.1 1313 g15226 i0 97 0.92093023255814 33 1 46 0 213 115 77 109 KAF8254224.1 hypothetical protein BKP31_11290 [Streptococcus pneumoniae] diamond 198 64.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31045885 31045885 PRJNA1008624_P_NODE_19015_length_196_cov_1.115646_g18827_i0 PRJNA1008624 19015 196 1.115646 2.18666616 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 90.9 5.8e-22   NR MFK5280989.1 1597 g18827 i0 97.8 0.688775510204082 45 1 68.9 0 137 3 1 45 MFK5280989.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 135 90.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
31424911 31424911 PRJNA1008624_P_NODE_8036_length_295_cov_1.630081_g7848_i0 PRJNA1008624 8036 295 1.630081 4.80873895 Paenibacillus zeirhizosphaerae 2987519 Bacteria Bacteria 87.4 1.4e-17   NR WP_305756971.1 2987519 g7848 i0 44.2 1.93220338983051 95 52 96.6 1 292 8 184 277 WP_305756971.1 methyltransferase domain-containing protein [Paenibacillus zeirhizosphaerae] diamond 570 87.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus zeirhizosphaerae
31512551 31512551 PRJNA1008624_P_NODE_36916_length_162_cov_0.920354_g36728_i0 PRJNA1008624 36916 162 0.920354 1.49097348 Bacteria 2 Bacteria Bacteria 70.1 3.86e-14   NR MBZ4284036.1 1313 g36728 i0 81.6 1.62962962962963 38 7 70.4 0 115 2 1 38 MBZ4284036.1 hypothetical protein [Streptococcus pneumoniae] diamond 264 70.1 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31835933 31835933 PRJNA1008624_P_NODE_27457_length_169_cov_0.866667_g27269_i0 PRJNA1008624 27457 169 0.866667 1.46466723 Lacticaseibacillus paracasei 1597 Bacteria Bacteria 65.9 1.87e-12   NR MFK5283885.1 1597 g27269 i0 100 0.603550295857988 34 0 60.4 0 168 67 46 79 MFK5283885.1 hypothetical protein [Lacticaseibacillus paracasei] diamond 102 65.9 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lacticaseibacillus Lacticaseibacillus paracasei
32595484 32595484 PRJNA1008624_P_NODE_36740_length_162_cov_0.920354_g36552_i0 PRJNA1008624 36740 162 0.920354 1.49097348 Clostridia bacterium 2044939 Bacteria Bacteria 45.4 1.99e-4   NR MDD2260656.1 2044939 g36552 i0 48.9 0.87037037037037 47 23 87 1 22 162 1 46 MDD2260656.1 hypothetical protein [Clostridia bacterium] diamond 141 45.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia 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);;