RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA763718 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
27379134 27379134 PRJNA763718_S_NODE_1423_length_417_cov_6.831579_g1215_i0 PRJNA763718 1423 417 6.831579 28.48768443 Bacteria 2 Bacteria Bacteria 280 1.52e-93   NR MEG2251261.1 1903720 g1215 i0 99.3 1.98561151079137 138 1 99.3 0 414 1 1 138 MEG2251261.1 Rpn family recombination-promoting nuclease/putative transposase [Bacilli bacterium] diamond 828 280 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
27568244 27568244 PRJNA763718_S_NODE_1984_length_334_cov_2.784512_g1776_i0 PRJNA763718 1984 334 2.784512 9.30027008 Bacillati 1783272 Bacteria Bacteria 102 1.08e-25   NR MEG2250006.1 1903720 g1776 i0 64.4 1.31137724550898 73 26 65.6 0 330 112 18 90 MEG2250006.1 hypothetical protein [Bacilli bacterium] diamond 438 102 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
28262816 28262816 PRJNA763718_S_NODE_2746_length_273_cov_4.110169_g2538_i0 PRJNA763718 2746 273 4.110169 11.22076137 Clostridia 186801 Bacteria Bacteria 107 1.27e-25   NR CDA30789.1 1262813 g2538 i0 57.6 5.98901098901099 92 38 100 1 273 1 210 301 CDA30789.1 l-lactate dehydrogenase [Clostridium sp. CAG:492] diamond 1635 108 0.990740740740741 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. CAG:492
28695577 28695577 PRJNA763718_S_NODE_6887_length_167_cov_1.469231_g6679_i0 PRJNA763718 6887 167 1.469231 2.45361577 Bacillus sp. S/N-3 2758034 Bacteria Bacteria 90.1 6.53e-21   NR WP_221848772.1 2758034 g6679 i0 76.4 2.96407185628743 55 13 98.8 0 2 166 86 140 WP_221848772.1 HNH/ENDO VII family nuclease [Bacillus sp. S/N-304-OC-R1] diamond 495 90.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. S/N-304-OC-R1
28853037 28853037 PRJNA763718_S_NODE_3448_length_240_cov_1.684729_g3240_i0 PRJNA763718 3448 240 1.684729 4.0433496 Clostridia bacterium 2044939 Bacteria Bacteria 68.6 2.44e-11   NR MBQ7866821.1 2044939 g3240 i0 65.3 3.85 49 17 61.3 0 148 2 6 54 MBQ7866821.1 S-methyl-5-thioribose-1-phosphate isomerase [Clostridia bacterium] diamond 924 68.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28894334 28894334 PRJNA763718_S_NODE_3908_length_223_cov_3.172043_g3700_i0 PRJNA763718 3908 223 3.172043 7.07365589 Clostridia 186801 Bacteria Bacteria 91.3 1.39e-20   NR WP_373189221.1 649756 g3700 i0 63.2 1.82959641255605 68 25 91.5 0 2 205 160 227 WP_373189221.1 DUF6710 family protein [Anaerostipes hadrus] diamond 408 91.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaerostipes Anaerostipes hadrus
28894335 28894335 PRJNA763718_S_NODE_5688_length_183_cov_2.089041_g5480_i0 PRJNA763718 5688 183 2.089041 3.82294503 Bacteria 2 Bacteria Bacteria 87.4 1.55e-20   NR MCA9749906.1 1965302 g5480 i0 80.7 1.86885245901639 57 11 93.4 0 181 11 55 111 MCA9749906.1 F0F1 ATP synthase subunit A [Romboutsia sp.] diamond 342 87.4 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Romboutsia Romboutsia sp.
29084013 29084013 PRJNA763718_S_NODE_3748_length_228_cov_2.324607_g3540_i0 PRJNA763718 3748 228 2.324607 5.30010396 Neobacillus 2675232 Bacteria Bacteria 74.3 2.27e-13   NR WP_202654154.1 2803862 g3540 i0 63 1.42105263157895 54 20 71.1 0 226 65 1168 1221 WP_202654154.1 polysaccharide pyruvyl transferase family protein [Neobacillus paridis] diamond 324 74.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus paridis
29137689 29137689 PRJNA763718_S_NODE_7149_length_164_cov_1.519685_g6941_i0 PRJNA763718 7149 164 1.519685 2.4922834 Bacilli bacterium 1903720 Bacteria Bacteria 99.4 3.519999999999999e-23   NR MEG1506409.1 1903720 g6941 i0 83.3 0.98780487804878 54 9 98.8 0 163 2 202 255 MEG1506409.1 glycoside hydrolase family 99-like domain-containing protein [Bacilli bacterium] diamond 162 99.4 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
29873314 29873314 PRJNA763718_S_NODE_7931_length_156_cov_6.386555_g7723_i0 PRJNA763718 7931 156 6.386555 9.9630258 Clostridia 186801 Bacteria Bacteria 51.2 5.42e-6   NR WP_118738722.1 1872530 g7723 i0 44.8 3.34615384615385 58 25 98.1 1 154 2 105 162 WP_118738722.1 DUF6710 family protein [Anaerostipes sp.] diamond 522 51.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Anaerostipes Anaerostipes sp.
29895337 29895337 PRJNA763718_S_NODE_5531_length_186_cov_1.288591_g5323_i0 PRJNA763718 5531 186 1.288591 2.39677926 Neobacillus notoginsengisoli 1578198 Bacteria Bacteria 99.8 4.14e-23   NR WP_240035346.1 1578198 g5323 i0 76.7 1.93548387096774 60 14 96.8 0 182 3 146 205 WP_240035346.1 sugar ABC transporter substrate-binding protein [Neobacillus notoginsengisoli] diamond 360 99.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus notoginsengisoli
30242874 30242874 PRJNA763718_S_NODE_3652_length_231_cov_357.768041_g3444_i0 PRJNA763718 3652 231 357.768041 826.44417471 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 63.2 6.16e-11   NR WP_252130143.1 1590 g3444 i0 77.8 4.20779220779221 36 8 46.8 0 230 123 54 89 WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 972 63.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
30590245 30590245 PRJNA763718_S_NODE_5733_length_182_cov_7.772414_g5525_i0 PRJNA763718 5733 182 7.772414 14.14579348 Staphylococcus aureus 1280 Bacteria Bacteria 63.2 3.62e-11   NR MCS4580470.1 1280 g5525 i0 100 0.692307692307692 42 0 69.2 0 177 52 1 42 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 126 63.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30938015 30938015 PRJNA763718_S_NODE_2354_length_298_cov_3.674330_g2146_i0 PRJNA763718 2354 298 3.67433 10.9495034 Veillonella sp. 1926307 Bacteria Bacteria 154 2.88e-46   NR WP_366512514.1 1926307 g2146 i0 73.2 0.976510067114094 97 26 97.7 0 6 296 9 105 WP_366512514.1 hypothetical protein [Veillonella sp.] diamond 291 154 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp.
31001149 31001149 PRJNA763718_S_NODE_6594_length_170_cov_3.135338_g6386_i0 PRJNA763718 6594 170 3.135338 5.3300746 Staphylococcus aureus 1280 Bacteria Bacteria 46.6 3.44e-5   NR HDA7671954.1 1280 g6386 i0 90.5 0.370588235294118 21 2 37.1 0 3 65 1 21 HDA7671954.1 hypothetical protein [Staphylococcus aureus] diamond 63 46.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31032935 31032935 PRJNA763718_S_NODE_6295_length_174_cov_1.912409_g6087_i0 PRJNA763718 6295 174 1.912409 3.32759166 Listeria monocytogenes 1639 Bacteria Bacteria 111 1.96e-29   NR WP_369698296.1 1639 g6087 i0 96.6 2.98275862068966 58 2 100 0 1 174 87 144 WP_369698296.1 RNA-directed DNA polymerase, partial [Listeria monocytogenes] diamond 519 111 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
31358504 31358504 PRJNA763718_S_NODE_7476_length_161_cov_1.250000_g7268_i0 PRJNA763718 7476 161 1.25 2.0125 Clostridia 186801 Bacteria Bacteria 69.7 1.14e-13   NR WP_204990522.1 1494606 g7268 i0 57.7 8.60869565217391 52 22 96.9 0 157 2 2 53 WP_204990522.1 UPF0236 family transposase-like protein, partial [Sporohalobacter salinus] diamond 1386 70.1 0.994293865905849 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halobacteroidaceae Sporohalobacter Sporohalobacter salinus
31538724 31538724 PRJNA763718_S_NODE_3476_length_238_cov_143.592040_g3268_i0 PRJNA763718 3476 238 143.59204 341.7490552 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 63.2 6.91e-11   NR WP_252130143.1 1590 g3268 i0 77.8 4.08403361344538 36 8 45.4 0 2 109 54 89 WP_252130143.1 hypothetical protein, partial [Lactiplantibacillus plantarum] diamond 972 63.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
31633353 31633353 PRJNA763718_S_NODE_3136_length_253_cov_2.273148_g2928_i0 PRJNA763718 3136 253 2.273148 5.75106444 Listeria monocytogenes 1639 Bacteria Bacteria 170 5.48e-51   NR WP_369697479.1 1639 g2928 i0 100 5.97628458498024 84 0 99.6 0 1 252 162 245 WP_369697479.1 hypothetical protein, partial [Listeria monocytogenes] diamond 1512 170 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
32424408 32424408 PRJNA763718_S_NODE_5019_length_196_cov_1.440252_g4811_i0 PRJNA763718 5019 196 1.440252 2.82289392 Lysinibacillus mangiferihumi 1130819 Bacteria Bacteria 48.1 7.32e-5   NR WP_107894741.1 1130819 g4811 i0 58.3 0.551020408163265 36 15 55.1 0 109 2 16 51 WP_107894741.1 SMI1/KNR4 family protein [Lysinibacillus mangiferihumi] diamond 108 48.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus mangiferihumi

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