RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJEB76780" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJEB76780 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
24364581 24364581 PRJEB76780_P_NODE_4560_length_380_cov_1.869707_g4460_i0 PRJEB76780 4560 380 1.869707 7.1048866 Bacillales 1385 Bacteria Bacteria 172 2.3e-52   NR WP_251514668.1 519977 g4460 i0 70.2 22.5789473684211 114 34 90 0 37 378 2 115 WP_251514668.1 nucleoside-diphosphate kinase [Robertmurraya korlensis] diamond 8580 172 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Robertmurraya Robertmurraya korlensis
28037788 28037788 PRJEB76780_P_NODE_11065_length_250_cov_1.322034_g10965_i0 PRJEB76780 11065 250 1.322034 3.305085 Bacteria 2 Bacteria Bacteria 108 3.42e-28   NR WP_148842497.1 1314 g10965 i0 100 1.368 57 0 68.4 0 80 250 1 57 WP_148842497.1 exosortase C-terminal domain/associated protein EpsI, partial [Streptococcus pyogenes] diamond 342 108 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pyogenes
28139949 28139949 PRJEB76780_P_NODE_11425_length_249_cov_0.886364_g11325_i0 PRJEB76780 11425 249 0.886364 2.20704636 Halanaerobium saccharolyticum 43595 Bacteria Bacteria 160 1.82e-44   NR WP_133530588.1 43595 g11325 i0 95.1 0.987951807228916 82 4 98.8 0 3 248 135 216 WP_133530588.1 ABC transporter substrate-binding protein [Halanaerobium saccharolyticum] diamond 246 160 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium saccharolyticum
28739639 28739639 PRJEB76780_P_NODE_3227_length_455_cov_0.963351_g3127_i0 PRJEB76780 3227 455 0.963351 4.38324705 Clostridium sp. BSD9I1 2003589 Bacteria Bacteria 64.7 4.56e-10   NR WP_186431075.1 2003589 g3127 i0 41.4 4.70769230769231 99 45 65.3 2 154 450 35 120 WP_186431075.1 ACT domain-containing protein [Clostridium sp. BSD9I1] diamond 2142 64.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sp. BSD9I1
28865852 28865852 PRJEB76780_P_NODE_11228_length_250_cov_0.881356_g11128_i0 PRJEB76780 11228 250 0.881356 2.20339 Neobacillus cucumis 1740721 Bacteria Bacteria 47 0.00123   NR WP_239558129.1 1740721 g11128 i0 35 0.96 80 46 94.8 2 12 248 50 124 WP_239558129.1 MFS transporter [Neobacillus cucumis] diamond 240 47 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Neobacillus Neobacillus cucumis
29174519 29174519 PRJEB76780_P_NODE_1289_length_728_cov_1.407634_g1196_i0 PRJEB76780 1289 728 1.407634 10.24757552 root 1 Root_unresolved Root_unresolved 79.3 6.57e-13   NR MBQ8310812.1 2044939 g1196 i0 34.2 1.75137362637363 146 82 57.7 3 661 242 52 189 MBQ8310812.1 hypothetical protein [Clostridia bacterium] diamond 1275 79.3 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
29623161 29623161 PRJEB76780_P_NODE_12190_length_246_cov_0.901734_g12090_i0 PRJEB76780 12190 246 0.901734 2.21826564 Macrococcus equipercicus 69967 Bacteria Bacteria 119 1.16e-30   NR WP_149459066.1 69967 g12090 i0 85 0.975609756097561 80 12 97.6 0 5 244 1 80 WP_149459066.1 AEC family transporter [Macrococcus equipercicus] diamond 240 119 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Macrococcus Macrococcus equipercicus
30034363 30034363 PRJEB76780_P_NODE_9091_length_269_cov_1.561224_g8991_i0 PRJEB76780 9091 269 1.561224 4.19969256 Anoxybacillus sp. LAT_26 2862719 Bacteria Bacteria 70.5 2.47e-12   NR WP_238802733.1 2862719 g8991 i0 100 0.423791821561338 38 0 42.4 0 1 114 8 45 WP_238802733.1 hypothetical protein [Anoxybacillus sp. LAT_26] diamond 114 70.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Anoxybacillus Anoxybacillus sp. LAT_26
30255731 30255731 PRJEB76780_P_NODE_10952_length_251_cov_0.876404_g10852_i0 PRJEB76780 10952 251 0.876404 2.19977404 Metaclostridioides mangenotii 1540 Bacteria Bacteria 150 5.85e-42   NR WP_304340605.1 1540 g10852 i0 97.5 0.968127490039841 81 2 96.8 0 8 250 187 267 WP_304340605.1 ethanolamine utilization protein EutH [Metaclostridioides mangenotii] diamond 243 150 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Metaclostridioides Metaclostridioides mangenotii
31298100 31298100 PRJEB76780_P_NODE_10615_length_252_cov_0.871508_g10515_i0 PRJEB76780 10615 252 0.871508 2.19620016 Streptococcus pneumoniae 1313 Bacteria Bacteria 82.8 5.06e-19   NR CWF69157.1 1313 g10515 i0 97.4 0.464285714285714 39 1 46.4 0 3 119 10 48 CWF69157.1 Uncharacterised protein [Streptococcus pneumoniae] diamond 117 82.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32025758 32025758 PRJEB76780_P_NODE_438_length_1180_cov_3.823848_g386_i0 PRJEB76780 438 1180 3.823848 45.1214064 Clostridia bacterium 2044939 Bacteria Bacteria 66.2 1.41e-7   NR MBR6524527.1 2044939 g386 i0 30.9 1.63474576271186 136 85 32.3 4 1077 697 111 246 MBR6524527.1 serine/threonine protein kinase [Clostridia bacterium] diamond 1929 66.2 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
32120765 32120765 PRJEB76780_P_NODE_11818_length_247_cov_1.666667_g11718_i0 PRJEB76780 11818 247 1.666667 4.11666749 Macrococcoides caseolyticum 69966 Bacteria Bacteria 147 8.93e-41   NR WP_101031590.1 69966 g11718 i0 98.8 0.983805668016194 81 1 98.4 0 245 3 17 97 WP_101031590.1 MFS transporter [Macrococcoides caseolyticum] diamond 243 147 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Macrococcoides Macrococcoides caseolyticum
32461500 32461500 PRJEB76780_P_NODE_5319_length_351_cov_1.546763_g5219_i0 PRJEB76780 5319 351 1.546763 5.42913813 root 1 Root_unresolved Root_unresolved 109 1.3600000000000002e-27   NR MBE6052561.1 84031 g5219 i0 60 1.78632478632479 95 33 76.9 1 276 7 36 130 MBE6052561.1 fasciclin domain-containing protein [Clostridium sartagoforme] diamond 627 110 0.990909090909091 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium sartagoforme

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