RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA983848 · 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
7649547 7649547 PRJNA983848_P_NODE_154346_length_245_cov_0.906977_g148463_i0 PRJNA983848 154346 245 0.906977 2.22209365 Paenibacillus nanensis 393251 Bacteria Bacteria 145 2.16e-40   NR WP_119598696.1 393251 g148463 i0 84 2.96326530612245 81 13 99.2 0 3 245 184 264 WP_119598696.1 iron-hydroxamate ABC transporter substrate-binding protein [Paenibacillus nanensis] diamond 726 145 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus nanensis
9895763 9895763 PRJNA983848_P_NODE_142268_length_251_cov_0.876404_g136385_i0 PRJNA983848 142268 251 0.876404 2.19977404 Halanaerobium saccharolyticum 43595 Bacteria Bacteria 157 9.439999999999999e-43   NR WP_208320763.1 43595 g136385 i0 100 0.99203187250996006 83 0 99.2 0 251 3 490 572 WP_208320763.1 copper-translocating P-type ATPase [Halanaerobium saccharolyticum] diamond 249 157 1 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium saccharolyticum
26646218 26646218 PRJNA983848_P_NODE_156241_length_244_cov_0.912281_g150358_i0 PRJNA983848 156241 244 0.912281 2.22596564 Bacilli bacterium 1903720 Bacteria Bacteria 174 1.33e-50   NR MEG0407265.1 1903720 g150358 i0 97.5 0.995901639344262 81 2 99.6 0 1 243 306 386 MEG0407265.1 hypothetical protein [Bacilli bacterium] diamond 243 174 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
26677873 26677873 PRJNA983848_P_NODE_31521_length_768_cov_2.988489_g25900_i0 PRJNA983848 31521 768 2.988489 22.95159552 Streptococcus dysgalactiae 1334 Bacteria Bacteria 59.3 4.44e-6   NR MBM6549304.1 119602 g25900 i0 42.9 0.35546875 91 51 35.5 1 371 99 340 429 MBM6549304.1 reverse transcriptase family protein [Streptococcus dysgalactiae subsp. equisimilis] diamond 273 59.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
26994441 26994441 PRJNA983848_P_NODE_143402_length_250_cov_0.881356_g137519_i0 PRJNA983848 143402 250 0.881356 2.20339 Clostridia bacterium 2044939 Bacteria Bacteria 42.7 0.0395   NR MBQ3040114.1 2044939 g137519 i0 37 0.648 54 33 63.6 1 190 32 1 54 MBQ3040114.1 hypothetical protein [Clostridia bacterium] diamond 162 42.7 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28100096 28100096 PRJNA983848_P_NODE_137805_length_253_cov_0.866667_g131922_i0 PRJNA983848 137805 253 0.866667 2.19266751 Streptococcus dysgalactiae 1334 Bacteria Bacteria 74.3 2.91e-13   NR MBM6549304.1 119602 g131922 i0 56.3 0.758893280632411 64 28 75.9 0 197 6 303 366 MBM6549304.1 reverse transcriptase family protein [Streptococcus dysgalactiae subsp. equisimilis] diamond 192 74.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus dysgalactiae
28485158 28485158 PRJNA983848_P_NODE_65706_length_395_cov_1.270186_g59823_i0 PRJNA983848 65706 395 1.270186 5.0172347 root 1 Root_unresolved Root_unresolved 65.1 2.8e-9   NR WP_251844289.1 53345 g59823 i0 38.1 2.58227848101266 105 65 79.7 0 377 63 64 168 WP_251844289.1 2-oxo acid dehydrogenase subunit E2 [Enterococcus durans] diamond 1020 65.5 0.993893129770992 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus durans
28573761 28573761 PRJNA983848_P_NODE_140167_length_252_cov_0.871508_g134284_i0 PRJNA983848 140167 252 0.871508 2.19620016 Clostridia bacterium 2044939 Bacteria Bacteria 51.6 2.3e-5   NR MEG1520364.1 2044939 g134284 i0 42.3 1.54761904761905 71 38 81 1 1 204 166 236 MEG1520364.1 hypothetical protein [Clostridia bacterium] diamond 390 51.6 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28731769 28731769 PRJNA983848_P_NODE_148707_length_247_cov_1.793103_g142824_i0 PRJNA983848 148707 247 1.793103 4.42896441 Holdemanella sp. 1971762 Bacteria Bacteria 43.1 0.00611   NR MCF0106778.1 1971762 g142824 i0 32.7 0.668016194331984 55 37 66.8 0 227 63 37 91 MCF0106778.1 hypothetical protein [Holdemanella sp.] diamond 165 43.1 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Holdemanella Holdemanella sp.
28763170 28763170 PRJNA983848_P_NODE_132547_length_258_cov_2.529730_g126664_i0 PRJNA983848 132547 258 2.52973 6.5267034 Gemmiger formicilis 745368 Bacteria Bacteria 43.1 0.0329   NR WP_143402632.1 745368 g126664 i0 31.5 0.848837209302326 73 50 84.9 0 229 11 166 238 WP_143402632.1 sugar ABC transporter permease [Gemmiger formicilis] diamond 219 43.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Gemmiger Gemmiger formicilis
29527100 29527100 PRJNA983848_P_NODE_137990_length_253_cov_0.866667_g132107_i0 PRJNA983848 137990 253 0.866667 2.19266751 root 1 Root_unresolved Root_unresolved 98.6 7.7e-22   NR WP_317582624.1 1314 g132107 i0 62.4 7.16205533596838 85 30 99.6 2 2 253 27 110 WP_317582624.1 GIY-YIG nuclease family protein, partial [Streptococcus pyogenes] diamond 1812 99 0.995959595959596 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pyogenes
30095397 30095397 PRJNA983848_P_NODE_40432_length_595_cov_1.603448_g34601_i0 PRJNA983848 40432 595 1.603448 9.5405156 root 1 Root_unresolved Root_unresolved 78.6 4.08e-13   NR WP_317582624.1 1314 g34601 i0 57.7 5.94957983193277 78 33 39.3 0 595 362 174 251 WP_317582624.1 GIY-YIG nuclease family protein, partial [Streptococcus pyogenes] diamond 3540 78.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pyogenes
30152491 30152491 PRJNA983848_P_NODE_145692_length_249_cov_0.886364_g139809_i0 PRJNA983848 145692 249 0.886364 2.20704636 Firmicutes bacterium CAG:321 1263018 Bacteria Bacteria 153 1.63e-44   NR CDE39500.1 1263018 g139809 i0 100 0.987951807228916 82 0 98.8 0 248 3 26 107 CDE39500.1 putative uncharacterized protein [Firmicutes bacterium CAG:321] diamond 246 153 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium CAG:321
30247761 30247761 PRJNA983848_P_NODE_164632_length_230_cov_5.305732_g158749_i0 PRJNA983848 164632 230 5.305732 12.2031836 Lactobacillus helveticus 1587 Bacteria Bacteria 41.6 0.0338   NR WP_253268338.1 1587 g158749 i0 38.9 0.704347826086957 54 31 67.8 1 221 66 63 116 WP_253268338.1 hypothetical protein [Lactobacillus helveticus] diamond 162 41.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus helveticus
30253785 30253785 PRJNA983848_P_NODE_134532_length_256_cov_1.704918_g128649_i0 PRJNA983848 134532 256 1.704918 4.36459008 root 1 Root_unresolved Root_unresolved 44.7 0.00908   NR WP_317582624.1 1314 g128649 i0 76.9 0.71484375 26 6 30.5 0 249 172 220 245 WP_317582624.1 GIY-YIG nuclease family protein, partial [Streptococcus pyogenes] diamond 183 44.7 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pyogenes
31422766 31422766 PRJNA983848_P_NODE_145636_length_249_cov_0.886364_g139753_i0 PRJNA983848 145636 249 0.886364 2.20704636 Bacillota 1239 Bacteria Bacteria 132 6.99e-35   NR WP_250243244.1 1406 g139753 i0 68.7 7 83 26 100 0 249 1 194 276 WP_250243244.1 restriction endonuclease subunit S [Paenibacillus polymyxa] diamond 1743 132 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus polymyxa
31669771 31669771 PRJNA983848_P_NODE_38837_length_620_cov_2.287020_g33023_i0 PRJNA983848 38837 620 2.28702 14.179524 Eubacterium sp. 142586 Bacteria Bacteria 99 5.13e-20   NR MDF2986509.1 142586 g33023 i0 42 0.667741935483871 138 76 66.8 2 1 414 70 203 MDF2986509.1 quiP [Eubacterium sp.] diamond 414 99 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
31891203 31891203 PRJNA983848_P_NODE_121517_length_271_cov_2.373737_g115634_i0 PRJNA983848 121517 271 2.373737 6.43282727 Pullulanibacillus pueri 1437324 Bacteria Bacteria 42.4 0.0362   NR WP_188497299.1 1437324 g115634 i0 33.3 0.896678966789668 81 49 84.1 4 6 233 8 88 WP_188497299.1 immunoglobulin-like domain-containing protein [Pullulanibacillus pueri] diamond 243 42.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Sporolactobacillaceae Pullulanibacillus Pullulanibacillus pueri
32334506 32334506 PRJNA983848_P_NODE_148879_length_247_cov_1.678161_g142996_i0 PRJNA983848 148879 247 1.678161 4.14505767 Epulopiscium sp. SCG-B1 3100283 Bacteria Bacteria 42.7 0.0351   NR ONI46646.1 1712379 g142996 i0 42.9 0.510121457489879 42 24 51 0 167 42 63 104 ONI46646.1 hypothetical protein AN642_00515 [Epulopiscium sp. SCG-B10WGA-EpuloA2] diamond 126 42.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscioides Candidatus Epulonipiscioides gigas
32492598 32492598 PRJNA983848_P_NODE_143519_length_250_cov_0.881356_g137636_i0 PRJNA983848 143519 250 0.881356 2.20339 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 42.7 0.0043   NR MCI6203015.1 1898203 g137636 i0 45.7 0.42 35 19 42 0 107 3 25 59 MCI6203015.1 hypothetical protein [Lachnospiraceae bacterium] diamond 105 42.7 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32681406 32681406 PRJNA983848_P_NODE_149360_length_247_cov_0.896552_g143477_i0 PRJNA983848 149360 247 0.896552 2.21448344 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 157 9.04e-47   NR MEG1299418.1 2049044 g143477 i0 88.8 0.97165991902834 80 9 97.2 0 242 3 35 114 MEG1299418.1 hypothetical protein [Erysipelotrichaceae bacterium] diamond 240 157 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium
32719145 32719145 PRJNA983848_P_NODE_140480_length_251_cov_8.747191_g134597_i0 PRJNA983848 140480 251 8.747191 21.95544941 Thermoanaerobacter 1754 Bacteria Bacteria 42.4 0.0397   NR WP_256201211.1 29350 g134597 i0 34.4 1.52988047808765 64 40 75.3 2 203 15 45 107 WP_256201211.1 ABC-2 family transporter protein [Thermoanaerobacter thermocopriae] diamond 384 42.4 1 Bacteria   Bacillati Bacillota Clostridia Thermoanaerobacterales Thermoanaerobacteraceae Thermoanaerobacter Thermoanaerobacter thermocopriae

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