RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA781196" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA781196 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
2035086 2035086 PRJNA781196_P_NODE_23162_length_355_cov_2.290780_g22785_i0 PRJNA781196 23162 355 2.29078 8.132269 FCB group 1783270 Bacteria Bacteria 112 7.44e-28   NR WP_092724391.1 1537 g22785 i0 55.1 2.48450704225352 98 40 82.8 1 2 295 137 230 WP_092724391.1 superoxide dismutase [Romboutsia lituseburensis] diamond 882 113 0.991150442477876 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia lituseburensis
10963934 10963934 PRJNA781196_P_NODE_8609_length_538_cov_5.423656_g8234_i0 PRJNA781196 8609 538 5.423656 29.17926928 root 1 Root_unresolved Root_unresolved 238 1.24e-76   NR WP_260645718.1 1280 g8234 i0 74.3 4.34386617100372 148 34 80.3 1 106 537 56 203 WP_260645718.1 ribulose bisphosphate carboxylase small subunit, partial [Staphylococcus aureus] diamond 2337 240 0.991666666666667 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
14787970 14787970 PRJNA781196_P_NODE_43652_length_271_cov_1.282828_g43275_i0 PRJNA781196 43652 271 1.282828 3.47646388 Veillonellaceae bacterium 2049049 Bacteria Bacteria 158 4.95e-45   NR NLP41976.1 2049049 g43275 i0 87.4 1.95940959409594 87 11 96.3 0 270 10 229 315 NLP41976.1 branched-chain amino acid aminotransferase [Veillonellaceae bacterium] diamond 531 158 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae   Veillonellaceae bacterium
16061572 16061572 PRJNA781196_P_NODE_22173_length_362_cov_1.619377_g21796_i0 PRJNA781196 22173 362 1.619377 5.86214474 Proteiniclasticum 1155385 Bacteria Bacteria 196 9.36e-60   NR HHY23052.1 1898204 g21796 i0 77.5 21.878453038674 120 27 99.4 0 360 1 172 291 HHY23052.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridiaceae bacterium] diamond 7920 196 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
19886387 19886387 PRJNA781196_P_NODE_53356_length_251_cov_0.876404_g52979_i0 PRJNA781196 53356 251 0.876404 2.19977404 Sporolactobacillus terrae 269673 Bacteria Bacteria 78.6 1.08e-15   NR WP_028978043.1 269673 g52979 i0 53.7 1.57768924302789 67 27 80.1 1 247 47 145 207 WP_028978043.1 superoxide dismutase [Sporolactobacillus terrae] diamond 396 78.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus terrae
27085200 27085200 PRJNA781196_P_NODE_65762_length_243_cov_0.917647_g65385_i0 PRJNA781196 65762 243 0.917647 2.22988221 Bacillus sp. M6-12 2054166 Bacteria Bacteria 60.5 1.25e-8   NR WP_101591050.1 2054166 g65385 i0 52.9 0.839506172839506 68 26 80.2 5 241 47 135 199 WP_101591050.1 vWA domain-containing protein [Bacillus sp. M6-12] diamond 204 60.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. M6-12
27252468 27252468 PRJNA781196_P_NODE_47343_length_260_cov_1.251337_g46966_i0 PRJNA781196 47343 260 1.251337 3.2534762 root 1 Root_unresolved Root_unresolved 43.5 0.0156   NR WP_010329842.1 72361 g46966 i0 56.3 2.22692307692308 32 14 36.9 0 161 256 121 152 WP_010329842.1 AP2 domain-containing protein [Bacillus vallismortis] diamond 579 43.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus vallismortis
27306469 27306469 PRJNA781196_P_NODE_1503_length_1144_cov_17.940243_g1300_i0 PRJNA781196 1503 1144 17.940243 205.23637992 Listeria monocytogenes 1639 Bacteria Bacteria 137 7.63e-35   NR WP_160336953.1 1639 g1300 i0 41.6 1.03321678321678 197 91 49.3 7 419 982 14 195 WP_160336953.1 hypothetical protein, partial [Listeria monocytogenes] diamond 1182 137 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
27401287 27401287 PRJNA781196_P_NODE_38883_length_286_cov_2.197183_g38506_i0 PRJNA781196 38883 286 2.197183 6.28394338 Bacillus sp. FJAT-2979 1895002 Bacteria Bacteria 50.4 1.17e-4   NR WP_217041965.1 1895002 g38506 i0 37.6 0.891608391608392 85 42 87.1 5 30 278 495 570 WP_217041965.1 Ig-like domain-containing protein [Bacillus sp. FJAT-29790] diamond 255 50.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. FJAT-29790
27527434 27527434 PRJNA781196_P_NODE_58803_length_247_cov_0.896552_g58426_i0 PRJNA781196 58803 247 0.896552 2.21448344 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 67 1.11e-10   NR MBE6547970.1 2485925 g58426 i0 64.7 4.80971659919028 51 16 61.9 1 154 2 95 143 MBE6547970.1 glutamine synthetase type III [Oscillospiraceae bacterium] diamond 1188 67 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
28916510 28916510 PRJNA781196_P_NODE_52028_length_252_cov_0.871508_g51651_i0 PRJNA781196 52028 252 0.871508 2.19620016 Clostridium ganghwense 312089 Bacteria Bacteria 92.8 1.58e-20   NR WP_268047578.1 312089 g51651 i0 50.6 0.94047619047619 79 39 94 0 16 252 171 249 WP_268047578.1 Sir2 family NAD-dependent protein deacetylase [Clostridium ganghwense] diamond 237 92.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium ganghwense
29106306 29106306 PRJNA781196_P_NODE_53868_length_251_cov_0.876404_g53491_i0 PRJNA781196 53868 251 0.876404 2.19977404 Desulfosporosinus sp. PR 3401928 Bacteria Bacteria 151 1.76e-42   NR WP_308894164.1 3059172 g53491 i0 83.1 4.9601593625498 83 14 99.2 0 249 1 178 260 WP_308894164.1 GNAT family N-acetyltransferase [Desulfosporosinus sp. PR] diamond 1245 151 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus sp. PR
29295621 29295621 PRJNA781196_P_NODE_54489_length_250_cov_0.881356_g54112_i0 PRJNA781196 54489 250 0.881356 2.20339 Bacillus 1386 Bacteria Bacteria 66.6 1.47e-10   NR WP_019241769.1 1386 g54112 i0 48.6 3.696 74 36 86.4 2 14 229 205 278 WP_019241769.1 MULTISPECIES: NO-inducible flavohemoprotein [Bacillus] diamond 924 66.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus  
29484750 29484750 PRJNA781196_P_NODE_18350_length_391_cov_1.226415_g17973_i0 PRJNA781196 18350 391 1.226415 4.79528265 Candidatus Pullichristensenella avicola 2840906 Bacteria Bacteria 45.4 0.0194   NR HIS03394.1 2840906 g17973 i0 30.6 0.652173913043478 85 57 64.5 2 288 37 229 312 HIS03394.1 insulinase family protein [Candidatus Pullichristensenella avicola] diamond 255 45.4 1 Bacteria   Bacillati Bacillota Clostridia     Candidatus Pullichristensenella Candidatus Pullichristensenella avicola
30031367 30031367 PRJNA781196_P_NODE_20731_length_372_cov_1.043478_g20354_i0 PRJNA781196 20731 372 1.043478 3.88173816 Limosilactobacillus 2742598 Bacteria Bacteria 78.6 4.63e-14   NR WP_057740017.1 396268 g20354 i0 41.3 8.81451612903226 104 57 83.1 2 10 318 571 671 WP_057740017.1 methionine--tRNA ligase [Limosilactobacillus secaliphilus] diamond 3279 78.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus secaliphilus
30284498 30284498 PRJNA781196_P_NODE_47352_length_260_cov_1.251337_g46975_i0 PRJNA781196 47352 260 1.251337 3.2534762 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 145 2.86e-39   NR WP_068137502.1 1555112 g46975 i0 70.6 14.7115384615385 85 25 98.1 0 255 1 244 328 WP_068137502.1 putrescine aminotransferase [Limnochorda pilosa] diamond 3825 145 1 Bacteria   Bacillati Bacillota Limnochordia Limnochordales Limnochordaceae Limnochorda Limnochorda pilosa
30631454 30631454 PRJNA781196_P_NODE_38433_length_288_cov_1.088372_g38056_i0 PRJNA781196 38433 288 1.088372 3.13451136 root 1 Root_unresolved Root_unresolved 133 1.6299999999999998e-35   NR MRB67411.1 1428 g38056 i0 67 21.6770833333333 91 30 94.8 0 16 288 5 95 MRB67411.1 30S ribosomal protein S2 [Bacillus thuringiensis] diamond 6243 134 0.992537313432836 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus thuringiensis
31064829 31064829 PRJNA781196_P_NODE_5355_length_667_cov_1.632997_g4992_i0 PRJNA781196 5355 667 1.632997 10.89208999 Ruminococcus sp. 41978 Bacteria Bacteria 60.5 2.62e-7   NR MCM1330551.1 41978 g4992 i0 52.5 0.265367316341829 59 23 24.3 1 466 627 23 81 MCM1330551.1 ATP-dependent Clp protease proteolytic subunit [Ruminococcus sp.] diamond 177 60.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
31507440 31507440 PRJNA781196_P_NODE_47956_length_258_cov_1.318919_g47579_i0 PRJNA781196 47956 258 1.318919 3.40281102 Clostridium sp. 1506 Bacteria Bacteria 78.6 1.48e-15   NR NLB20780.1 1506 g47579 i0 57.8 2.23255813953488 64 27 74.4 0 1 192 65 128 NLB20780.1 uridine kinase [Clostridium sp.] diamond 576 78.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp.
31760260 31760260 PRJNA781196_P_NODE_7617_length_568_cov_2.842424_g7242_i0 PRJNA781196 7617 568 2.842424 16.14496832 Soehngenia saccharolytica 253256 Bacteria Bacteria 167 7.53e-50   NR TJX38978.1 253256 g7242 i0 67.3 0.596830985915493 113 37 59.7 0 479 141 1 113 TJX38978.1 thioredoxin family protein [Soehngenia saccharolytica] diamond 339 167 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Tissierellaceae Soehngenia Soehngenia saccharolytica
31791697 31791697 PRJNA781196_P_NODE_55437_length_250_cov_0.881356_g55060_i0 PRJNA781196 55437 250 0.881356 2.20339 Alicyclobacillus tolerans 90970 Bacteria Bacteria 45.8 0.00305   NR WP_236814711.1 90970 g55060 i0 71.4 1.344 28 8 33.6 0 85 2 1 28 WP_236814711.1 energy-coupling factor transporter transmembrane component T family protein [Alicyclobacillus tolerans] diamond 336 45.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Alicyclobacillus Alicyclobacillus tolerans
31959402 31959402 PRJNA781196_P_NODE_47737_length_259_cov_1.252688_g47360_i0 PRJNA781196 47737 259 1.252688 3.24446192 root 1 Root_unresolved Root_unresolved 47.8 7.58e-4   NR WP_345808546.1 1408 g47360 i0 46.2 3.76447876447876 52 28 60.2 0 1 156 42 93 WP_345808546.1 2-oxoglutarate dehydrogenase complex dihydrolipoyllysine-residue succinyltransferase [Bacillus pumilus] diamond 975 48.1 0.993762993762994 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus pumilus

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