RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA358490" 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

  • PRJNA358490 · 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
20800437 20800437 PRJNA358490_P_NODE_12077_length_248_cov_1.909091_g11733_i0 PRJNA358490 12077 248 1.909091 4.73454568 Bacillales 1385 Bacteria Bacteria 147 3.729999999999999e-42   NR GGH85319.1 1437324 g11733 i0 90.8 12.7137096774194 76 7 91.9 0 20 247 147 222 GGH85319.1 hypothetical protein GCM10007096_30430 [Pullulanibacillus pueri] diamond 3153 148 0.993243243243243 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Pullulanibacillus Pullulanibacillus pueri
27137650 27137650 PRJNA358490_P_NODE_6422_length_520_cov_1.783784_g6094_i0 PRJNA358490 6422 520 1.783784 9.2756768 Evansella clarkii 79879 Bacteria Bacteria 239 4.83e-71   NR WP_078598340.1 79879 g6094 i0 71.5 1.81730769230769 158 43 91.2 1 3 476 678 833 WP_078598340.1 DNA topoisomerase [Evansella clarkii] diamond 945 239 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Evansella Evansella clarkii
27391119 27391119 PRJNA358490_P_NODE_5643_length_569_cov_2.450943_g5338_i0 PRJNA358490 5643 569 2.450943 13.94586567 uncultured Megasphaera sp. 165188 Bacteria Bacteria 368 3.5e-123   NR WP_288224225.1 165188 g5338 i0 99.5 1.9402460456942 184 1 97 0 567 16 105 288 WP_288224225.1 DUF3656 domain-containing U32 family peptidase, partial [uncultured Megasphaera sp.] diamond 1104 368 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Megasphaera uncultured Megasphaera sp.
27439938 27439938 PRJNA358490_P_NODE_17663_length_155_cov_1.758621_g17319_i0 PRJNA358490 17663 155 1.758621 2.72586255 PVC group 1783257 Bacteria Bacteria 41.6 0.029   NR MBO7426995.1 1898207 g17319 i0 45.8 1.83870967741935 48 25 91 1 13 153 171 218 MBO7426995.1 DUF4214 domain-containing protein [Clostridiales bacterium] diamond 285 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27485679 27485679 PRJNA358490_P_NODE_10023_length_331_cov_3.746575_g9681_i0 PRJNA358490 10023 331 3.746575 12.40116325 Listeria monocytogenes 1639 Bacteria Bacteria 190 2.2099999999999994e-54   NR HCA4015448.1 1639 g9681 i0 93.5 0.978851963746224 108 7 97.9 0 326 3 171 278 HCA4015448.1 tape measure protein [Listeria monocytogenes] diamond 324 190 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
27896014 27896014 PRJNA358490_P_NODE_18025_length_153_cov_0.824561_g17681_i0 PRJNA358490 18025 153 0.824561 1.26157833 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 39.7 0.0412   NR WP_249119867.1 1590 g17681 i0 43.8 1.88235294117647 48 19 78.4 2 34 153 14 61 WP_249119867.1 hypothetical protein [Lactiplantibacillus plantarum] diamond 288 39.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28180072 28180072 PRJNA358490_P_NODE_12346_length_239_cov_2.160000_g12002_i0 PRJNA358490 12346 239 2.16 5.1624 Lactovum miscens 190387 Bacteria Bacteria 62.4 7.39e-10   NR WP_414672544.1 190387 g12002 i0 100 0.338912133891213 27 0 33.9 0 22 102 140 166 WP_414672544.1 SGNH/GDSL hydrolase family protein [Lactovum miscens] diamond 81 62.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactovum Lactovum miscens
28323560 28323560 PRJNA358490_P_NODE_16326_length_167_cov_1.046875_g15982_i0 PRJNA358490 16326 167 1.046875 1.74828125 Streptococcus 1301 Bacteria Bacteria 92.8 9.36e-21   NR WP_002883881.1 1304 g15982 i0 91.3 1.65269461077844 46 4 82.6 0 167 30 292 337 WP_002883881.1 phage/plasmid replication protein, II/X family [Streptococcus salivarius] diamond 276 92.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
29190780 29190780 PRJNA358490_P_NODE_7009_length_485_cov_1.358744_g6677_i0 PRJNA358490 7009 485 1.358744 6.5899084 Megasphaera lornae 1000568 Bacteria Bacteria 168 1.04e-45   NR WP_039891647.1 1000568 g6677 i0 98.8 0.507216494845361 82 1 50.7 0 1 246 428 509 WP_039891647.1 DUF4127 family protein [Megasphaera lornae] diamond 246 168 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Megasphaera Megasphaera lornae
29222409 29222409 PRJNA358490_P_NODE_12069_length_248_cov_2.344498_g11725_i0 PRJNA358490 12069 248 2.344498 5.81435504 Anaerococcus vaginalis 33037 Bacteria Bacteria 90.9 4.58e-19   NR MDU7163697.1 33037 g11725 i0 97.8 1.08870967741935 45 1 54.4 0 112 246 1 45 MDU7163697.1 transcription-repair coupling factor [Anaerococcus vaginalis] diamond 270 90.9 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus vaginalis
29821882 29821882 PRJNA358490_P_NODE_14651_length_188_cov_1.362416_g14307_i0 PRJNA358490 14651 188 1.362416 2.56134208 Evtepia gabavorous 2211183 Bacteria Bacteria 72.8 4.82e-15   NR MFR0912284.1 2211183 g14307 i0 100 0.558510638297872 35 0 55.9 0 188 84 49 83 MFR0912284.1 hypothetical protein [Evtepia gabavorous] diamond 105 72.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Evtepia Evtepia gabavorous
30517197 30517197 PRJNA358490_P_NODE_8693_length_402_cov_9.071625_g8352_i0 PRJNA358490 8693 402 9.071625 36.4679325 Listeria monocytogenes 1639 Bacteria Bacteria 236 4.79e-72   NR HCA4015451.1 1639 g8352 i0 95.4 0.970149253731343 130 6 97 0 391 2 185 314 HCA4015451.1 hypothetical protein [Listeria monocytogenes] diamond 390 236 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30548743 30548743 PRJNA358490_P_NODE_693_length_1473_cov_15.578801_g636_i0 PRJNA358490 693 1473 15.578801 229.47573873 Listeria monocytogenes 1639 Bacteria Bacteria 409 1.3399999999999996e-137   NR HCA4015456.1 1639 g636 i0 63.8 0.69857433808554 343 105 69 6 321 1337 1 328 HCA4015456.1 hypothetical protein [Listeria monocytogenes] diamond 1029 409 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30643426 30643426 PRJNA358490_P_NODE_7993_length_435_cov_4.497475_g7652_i0 PRJNA358490 7993 435 4.497475 19.56401625 Clostridium butyricum 1492 Bacteria Bacteria 46.2 7.92e-4   NR MDU1007285.1 1492 g7652 i0 81.3 0.220689655172414 32 6 22.1 0 258 353 1 32 MDU1007285.1 hypothetical protein [Clostridium butyricum] diamond 96 46.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium butyricum
31117241 31117241 PRJNA358490_P_NODE_5755_length_561_cov_8.021073_g5449_i0 PRJNA358490 5755 561 8.021073 44.99821953 unclassified Streptococcus 2608887 Bacteria Bacteria 362 1.98e-121   NR WP_301363312.1 2608887 g5449 i0 98.4 0.973262032085562 182 3 97.3 0 14 559 162 343 WP_301363312.1 MULTISPECIES: hypothetical protein [unclassified Streptococcus] diamond 546 362 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus  
31307139 31307139 PRJNA358490_P_NODE_7315_length_468_cov_4.132867_g6981_i0 PRJNA358490 7315 468 4.132867 19.34181756 Salimicrobium jeotgali 1230341 Bacteria Bacteria 48.9 0.00219   NR WP_008592600.1 1230341 g6981 i0 55.8 0.275641025641026 43 19 27.6 0 436 308 99 141 WP_008592600.1 SAP domain-containing protein [Salimicrobium jeotgali] diamond 129 48.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Salimicrobium Salimicrobium jeotgali
31465581 31465581 PRJNA358490_P_NODE_18116_length_152_cov_1.451327_g17772_i0 PRJNA358490 18116 152 1.451327 2.20601704 Streptococcus salivarius 1304 Bacteria Bacteria 75.5 3.53e-16   NR WP_002883880.1 1304 g17772 i0 97.3 0.730263157894737 37 1 73 0 40 150 1 37 WP_002883880.1 hypothetical protein [Streptococcus salivarius] diamond 111 75.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus salivarius
31497132 31497132 PRJNA358490_P_NODE_6716_length_503_cov_1.724138_g6386_i0 PRJNA358490 6716 503 1.724138 8.67241414 Evtepia gabavorous 2211183 Bacteria Bacteria 179 7.759999999999999e-54   NR MFR0912286.1 2211183 g6386 i0 99 0.614314115308151 103 1 61.4 0 330 22 1 103 MFR0912286.1 hypothetical protein [Evtepia gabavorous] diamond 309 179 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Evtepia Evtepia gabavorous
32319860 32319860 PRJNA358490_P_NODE_399_length_1745_cov_2.848769_g358_i0 PRJNA358490 399 1745 2.848769 49.71101905 Listeria monocytogenes 1639 Bacteria Bacteria 263 1.78e-81   NR HCA4016293.1 1639 g358 i0 94.1 0.233810888252149 136 8 23.4 0 408 1 1 136 HCA4016293.1 hypothetical protein [Listeria monocytogenes] diamond 408 263 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32351332 32351332 PRJNA358490_P_NODE_14159_length_196_cov_2.050955_g13815_i0 PRJNA358490 14159 196 2.050955 4.0198718 Roseburia faecis 301302 Bacteria Bacteria 47.8 3.26e-4   NR WP_343087346.1 301302 g13815 i0 87 0.352040816326531 23 3 35.2 0 125 57 5 27 WP_343087346.1 glycosyltransferase family 4 protein [Roseburia faecis] diamond 69 47.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Roseburia Roseburia faecis
32382783 32382783 PRJNA358490_P_NODE_8379_length_418_cov_1.968338_g8038_i0 PRJNA358490 8379 418 1.968338 8.22765284 Bacillota bacterium 1879010 Bacteria Bacteria 215 1.41e-64   NR MCL6553432.1 1879010 g8038 i0 74.2 0.947368421052632 132 34 94.7 0 397 2 47 178 MCL6553432.1 HAD-IC family P-type ATPase [Bacillota bacterium] diamond 396 215 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
32446301 32446301 PRJNA358490_P_NODE_17959_length_153_cov_1.429825_g17615_i0 PRJNA358490 17959 153 1.429825 2.18763225 Listeria monocytogenes 1639 Bacteria Bacteria 104 2.49e-26   NR HCA4016211.1 1639 g17615 i0 98 0.980392156862745 50 1 98 0 2 151 98 147 HCA4016211.1 hypothetical protein [Listeria monocytogenes] diamond 150 104 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes

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