RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA384462" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA384462 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
16982713 16982713 PRJNA384462_S_NODE_5694_length_227_cov_2.157303_g5578_i0 PRJNA384462 5694 227 2.157303 4.89707781 Clostridia bacterium 2044939 Bacteria Bacteria 123 5.909999999999999e-32   NR MBC7765143.1 2044939 g5578 i0 83.8 13.6916299559471 74 12 97.8 0 227 6 196 269 MBC7765143.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridia bacterium] diamond 3108 123 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28085791 28085791 PRJNA384462_S_NODE_7765_length_202_cov_1.326797_g7649_i0 PRJNA384462 7765 202 1.326797 2.68012994 Clostridiales bacterium 1898207 Bacteria Bacteria 79.7 1.94e-15   NR MDR3293840.1 1898207 g7649 i0 58.2 2.95544554455446 67 27 99.5 1 1 201 402 467 MDR3293840.1 adenylosuccinate lyase [Clostridiales bacterium] diamond 597 79.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
28811739 28811739 PRJNA384462_S_NODE_11568_length_174_cov_1.224000_g11452_i0 PRJNA384462 11568 174 1.224 2.12976 Neobacillus cucumis 1740721 Bacteria Bacteria 84.7 2.07e-19   NR WP_378575789.1 1740721 g11452 i0 87.5 0.827586206896552 48 6 82.8 0 3 146 74 121 WP_378575789.1 HU family DNA-binding protein, partial [Neobacillus cucumis] diamond 144 84.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
28860441 28860441 PRJNA384462_S_NODE_14948_length_162_cov_0.902655_g14832_i0 PRJNA384462 14948 162 0.902655 1.4623011 Bacillales 1385 Bacteria Bacteria 46.2 7.31e-4   NR WP_253052538.1 269672 g14832 i0 57.6 2.7037037037037 33 14 61.1 0 18 116 381 413 WP_253052538.1 GH32 C-terminal domain-containing protein [Sporolactobacillus kofuensis] diamond 438 46.6 0.991416309012876 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Sporolactobacillus Sporolactobacillus kofuensis
29191071 29191071 PRJNA384462_S_NODE_3149_length_293_cov_21.827869_g3033_i0 PRJNA384462 3149 293 21.827869 63.95565617 Lactobacillus crispatus 47770 Bacteria Bacteria 68.6 1.59e-12   NR WP_205758365.1 47770 g3033 i0 95.8 0.491467576791809 48 2 49.1 0 293 150 60 107 WP_205758365.1 hypothetical protein, partial [Lactobacillus crispatus] diamond 144 68.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
29302570 29302570 PRJNA384462_S_NODE_7769_length_202_cov_1.281046_g7653_i0 PRJNA384462 7769 202 1.281046 2.58771292 FCB group 1783270 Bacteria Bacteria 130 1.0799999999999998e-37   NR MEB3029810.1 33033 g7653 i0 100 3.6831683168316798 62 0 92.1 0 17 202 1 62 MEB3029810.1 type IIA DNA topoisomerase subunit B [Parvimonas micra] diamond 744 130 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Parvimonas Parvimonas micra
29365785 29365785 PRJNA384462_S_NODE_4729_length_246_cov_1.802030_g4613_i0 PRJNA384462 4729 246 1.80203 4.4329938 Bacteria 2 Bacteria Bacteria 42 0.0346   NR MBQ3588980.1 2044939 g4613 i0 50 1.21951219512195 38 19 46.3 0 64 177 30 67 MBQ3588980.1 NUDIX hydrolase [Clostridia bacterium] diamond 300 42 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29474841 29474841 PRJNA384462_S_NODE_7670_length_203_cov_1.324675_g7554_i0 PRJNA384462 7670 203 1.324675 2.68909025 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 75.5 5.24e-14   NR MBE6750281.1 2485925 g7554 i0 52.2 4.9064039408867 67 31 97.5 1 201 4 159 225 MBE6750281.1 molecular chaperone DnaJ [Oscillospiraceae bacterium] diamond 996 75.5 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29997432 29997432 PRJNA384462_S_NODE_12071_length_171_cov_1.254098_g11955_i0 PRJNA384462 12071 171 1.254098 2.14450758 Alteribacillus 1433300 Bacteria Bacteria 55.5 1.28e-7   NR MFO7264015.1 1879010 g11955 i0 42.9 4.91228070175439 56 27 98.2 1 3 170 91 141 MFO7264015.1 ribonuclease E activity regulator RraA [Bacillota bacterium] diamond 840 55.5 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
30360014 30360014 PRJNA384462_S_NODE_9172_length_190_cov_0.950355_g9056_i0 PRJNA384462 9172 190 0.950355 1.8056745 Neobacillus cucumis 1740721 Bacteria Bacteria 64.3 3.36e-11   NR WP_378575619.1 1740721 g9056 i0 81 1.32631578947368 42 8 66.3 0 4 129 88 129 WP_378575619.1 hypothetical protein [Neobacillus cucumis] diamond 252 64.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
30928363 30928363 PRJNA384462_S_NODE_14654_length_163_cov_0.877193_g14538_i0 PRJNA384462 14654 163 0.877193 1.42982459 Acetivibrio clariflavus 288965 Bacteria Bacteria 49.3 5.89e-5   NR WP_027621627.1 288965 g14538 i0 48.1 0.993865030674847 54 28 99.4 0 163 2 171 224 WP_027621627.1 NADAR family protein [Acetivibrio clariflavus] diamond 162 49.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Acetivibrio Acetivibrio clariflavus
30959919 30959919 PRJNA384462_S_NODE_13014_length_167_cov_0.864407_g12898_i0 PRJNA384462 13014 167 0.864407 1.44355969 Cohnella abietis 2507935 Bacteria Bacteria 41.2 0.0476   NR WP_130606847.1 2507935 g12898 i0 39.2 0.916167664670659 51 30 89.8 1 166 17 518 568 WP_130606847.1 phage tail protein [Cohnella abietis] diamond 153 41.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella abietis
31307416 31307416 PRJNA384462_S_NODE_10555_length_180_cov_1.167939_g10439_i0 PRJNA384462 10555 180 1.167939 2.1022902 Staphylococcus aureus 1280 Bacteria Bacteria 115 3.25e-32   NR MFS4895232.1 1280 g10439 i0 100 1 60 0 100 0 1 180 9 68 MFS4895232.1 hypothetical protein [Staphylococcus aureus] diamond 180 115 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31592339 31592339 PRJNA384462_S_NODE_7316_length_207_cov_0.968354_g7200_i0 PRJNA384462 7316 207 0.968354 2.00449278 Hathewaya histolytica 1498 Bacteria Bacteria 79.3 4.44e-17   NR WP_138210518.1 1498 g7200 i0 58.9 2.43478260869565 56 23 81.2 0 202 35 65 120 WP_138210518.1 CoA-binding protein [Hathewaya histolytica] diamond 504 79.3 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Hathewaya Hathewaya histolytica
31845098 31845098 PRJNA384462_S_NODE_13317_length_166_cov_0.871795_g13201_i0 PRJNA384462 13317 166 0.871795 1.4471797 Staphylococcus aureus 1280 Bacteria Bacteria 113 7.729999999999999e-31   NR MFS4834712.1 1280 g13201 i0 98.2 2.98192771084337 55 1 99.4 0 1 165 41 95 MFS4834712.1 hypothetical protein [Staphylococcus aureus] diamond 495 113 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
32730413 32730413 PRJNA384462_S_NODE_1360_length_449_cov_2.665000_g1244_i0 PRJNA384462 1360 449 2.665 11.96585 Lysinibacillus sphaericus 1421 Bacteria Bacteria 66.2 8.56e-10   NR WP_197140054.1 1421 g1244 i0 54.4 0.380846325167038 57 26 38.1 0 173 343 186 242 WP_197140054.1 AP2 domain-containing protein [Lysinibacillus sphaericus] diamond 171 66.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Lysinibacillus Lysinibacillus sphaericus
32747170 32747170 PRJNA384462_S_NODE_13280_length_166_cov_0.871795_g13164_i0 PRJNA384462 13280 166 0.871795 1.4471797 Clostridia 186801 Bacteria Bacteria 55.8 2.15e-7   NR MDE7395605.1 1898207 g13164 i0 57.4 4.24698795180723 47 20 84.9 0 9 149 173 219 MDE7395605.1 DUF2589 domain-containing protein [Clostridiales bacterium] diamond 705 55.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales 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);;