RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB43370" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJEB43370 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
60172 60172 PRJEB43370_P_NODE_10621_length_162_cov_1.371681_g10578_i0 PRJEB43370 10621 162 1.371681 2.22212322 Clostridia 186801 Bacteria Bacteria 94 3.15e-21   NR MDR0978712.1 1898203 g10578 i0 84.9 3.92592592592593 53 8 98.1 0 4 162 110 162 MDR0978712.1 type I glyceraldehyde-3-phosphate dehydrogenase [Lachnospiraceae bacterium] diamond 636 94.4 0.995762711864407 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
20461074 20461074 PRJEB43370_P_NODE_8357_length_167_cov_0.881356_g8314_i0 PRJEB43370 8357 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 99 4.38e-23   NR MCI8805183.1 1898207 g8314 i0 87.3 12.8443113772455 55 7 98.8 0 1 165 218 272 MCI8805183.1 type I glyceraldehyde-3-phosphate dehydrogenase [Clostridiales bacterium] diamond 2145 99 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
27437890 27437890 PRJEB43370_P_NODE_2923_length_254_cov_1.087805_g2880_i0 PRJEB43370 2923 254 1.087805 2.7630247 Clostridia 186801 Bacteria Bacteria 70.9 5.24e-12   NR WP_014552408.1 2331 g2880 i0 54.4 10.7125984251969 57 23 67.3 1 34 204 309 362 WP_014552408.1 glycoside hydrolase family 13 protein [Halanaerobium praevalens] diamond 2721 71.2 0.995786516853933 Bacteria   Bacillati Bacillota Clostridia Halanaerobiales Halanaerobiaceae Halanaerobium Halanaerobium praevalens
27507634 27507634 PRJEB43370_P_NODE_10223_length_163_cov_0.912281_g10180_i0 PRJEB43370 10223 163 0.912281 1.48701803 Kurthia sp. 1963358 Bacteria Bacteria 72.4 4.19e-13   NR HEY4532174.1 1963358 g10180 i0 60.4 1.95092024539877 53 21 97.5 0 161 3 236 288 HEY4532174.1 phosphoenolpyruvate mutase [Kurthia sp.] diamond 318 72.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Kurthia Kurthia sp.
27753582 27753582 PRJEB43370_P_NODE_8064_length_168_cov_0.873950_g8021_i0 PRJEB43370 8064 168 0.87395 1.468236 root 1 Root_unresolved Root_unresolved 70.5 1.85e-14   NR WP_252413872.1 1598 g8021 i0 61.2 4.44642857142857 49 19 87.5 0 1 147 12 60 WP_252413872.1 ATG3/ATG10 family protein, partial [Limosilactobacillus reuteri] diamond 747 70.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Limosilactobacillus Limosilactobacillus reuteri
28044195 28044195 PRJEB43370_P_NODE_5585_length_192_cov_1.818182_g5542_i0 PRJEB43370 5585 192 1.818182 3.49090944 Gemelliphila palaticanis 81950 Bacteria Bacteria 118 5.18e-29   NR WP_179940000.1 81950 g5542 i0 87.3 5.90625 63 8 98.4 0 190 2 595 657 WP_179940000.1 ATP-dependent Clp protease ATP-binding subunit [Gemelliphila palaticanis] diamond 1134 118 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemelliphila Gemelliphila palaticanis
28321663 28321663 PRJEB43370_P_NODE_8006_length_168_cov_0.873950_g7963_i0 PRJEB43370 8006 168 0.87395 1.468236 PVC group 1783257 Bacteria Bacteria 46.6 3.02e-4   NR WP_412453079.1 41978 g7963 i0 37 4.66071428571429 54 34 96.4 0 1 162 76 129 WP_412453079.1 YbjN domain-containing protein [Ruminococcus sp.] diamond 783 47 0.991489361702128 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Ruminococcus Ruminococcus sp.
28511175 28511175 PRJEB43370_P_NODE_10207_length_163_cov_0.912281_g10164_i0 PRJEB43370 10207 163 0.912281 1.48701803 Bacteria 2 Bacteria Bacteria 47 3.98e-4   NR OGO83525.1 1797679 g10164 i0 47.8 2.22699386503067 46 24 84.7 0 2 139 175 220 OGO83525.1 MAG: hypothetical protein A2Y18_00530 [Clostridiales bacterium GWD2_32_19] diamond 363 47 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium GWD2_32_19
28574239 28574239 PRJEB43370_P_NODE_4047_length_220_cov_2.128655_g4004_i0 PRJEB43370 4047 220 2.128655 4.683041 Bacillaceae 186817 Bacteria Bacteria 127 8.34e-36   NR WP_044748053.1 279215 g4004 i0 80.8 14.9318181818182 73 14 99.5 0 1 219 2 74 WP_044748053.1 nucleoside-diphosphate kinase [Bacillus alveayuensis] diamond 3285 127 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Aeribacillus Aeribacillus alveayuensis
28581091 28581091 PRJEB43370_P_NODE_9227_length_165_cov_1.344828_g9184_i0 PRJEB43370 9227 165 1.344828 2.2189662 Caloramator australicus 515264 Bacteria Bacteria 60.1 1e-8   NR WP_008909892.1 515264 g9184 i0 56.4 1 55 24 100 0 165 1 29 83 WP_008909892.1 hydroxylamine reductase [Caloramator australicus] diamond 165 60.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Caloramator Caloramator australicus
28707369 28707369 PRJEB43370_P_NODE_4707_length_207_cov_1.316456_g4664_i0 PRJEB43370 4707 207 1.316456 2.72506392 Thermoclostridium sp. 2304696 Bacteria Bacteria 42.4 0.0311   NR MBP7175911.1 2304696 g4664 i0 46 0.72463768115942 50 24 69.6 2 23 166 66 114 MBP7175911.1 cysteate synthase [Thermoclostridium sp.] diamond 150 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Thermoclostridium Thermoclostridium sp.
28985056 28985056 PRJEB43370_P_NODE_7628_length_169_cov_0.866667_g7585_i0 PRJEB43370 7628 169 0.866667 1.46466723 root 1 Root_unresolved Root_unresolved 42.7 0.0143   NR WP_108991287.1 171404 g7585 i0 44.4 1.54437869822485 45 23 76.3 1 37 165 299 343 WP_108991287.1 discoidin domain-containing protein [Paenibacillus agaridevorans] diamond 261 43.1 0.990719257540603 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus agaridevorans
29016669 29016669 PRJEB43370_P_NODE_2908_length_255_cov_1.009709_g2865_i0 PRJEB43370 2908 255 1.009709 2.57475795 Paenibacillus 44249 Bacteria Bacteria 43.5 0.0236   NR WP_079695261.1 185978 g2865 i0 39.3 3.58823529411765 61 36 71.8 1 254 72 468 527 WP_079695261.1 MULTISPECIES: S-layer homology domain-containing protein [unclassified Paenibacillus] diamond 915 43.5 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus  
29205988 29205988 PRJEB43370_P_NODE_8669_length_167_cov_0.881356_g8626_i0 PRJEB43370 8669 167 0.881356 1.47186452 Lactobacillales 186826 Bacteria Bacteria 88.6 7.6e-19   NR WP_161900285.1 1857218 g8626 i0 79.6 17.3173652694611 54 11 97 0 167 6 306 359 WP_161900285.1 glutathione-disulfide reductase [Enterococcus sp. CU9D] diamond 2892 88.6 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Candidatus Enterococcus leclercqii
29426612 29426612 PRJEB43370_P_NODE_5349_length_196_cov_1.380952_g5306_i0 PRJEB43370 5349 196 1.380952 2.70666592 root 1 Root_unresolved Root_unresolved 99.4 1.2e-24   NR MFG1554834.1 1280 g5306 i0 76.9 9.75 65 15 99.5 0 195 1 49 113 MFG1554834.1 S6e family ribosomal protein [Staphylococcus aureus] diamond 1911 100 0.994 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
29559621 29559621 PRJEB43370_P_NODE_5430_length_195_cov_1.068493_g5387_i0 PRJEB43370 5430 195 1.068493 2.08356135 Clostridia bacterium 2044939 Bacteria Bacteria 55.8 4.78e-7   NR MBP3802180.1 2044939 g5387 i0 43.5 0.953846153846154 62 32 92.3 2 183 4 34 94 MBP3802180.1 hypothetical protein [Clostridia bacterium] diamond 186 55.8 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
30222978 30222978 PRJEB43370_P_NODE_5352_length_196_cov_1.292517_g5309_i0 PRJEB43370 5352 196 1.292517 2.53333332 Bacilli bacterium 1903720 Bacteria Bacteria 60.1 1.4e-8   NR NLG81299.1 1903720 g5309 i0 47.8 1.05612244897959 69 22 96.4 3 7 195 106 166 NLG81299.1 cellulase family glycosylhydrolase [Bacilli bacterium] diamond 207 60.1 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli bacterium
31044874 31044874 PRJEB43370_P_NODE_3575_length_232_cov_1.136612_g3532_i0 PRJEB43370 3575 232 1.136612 2.63693984 Streptococcus pneumoniae 1313 Bacteria Bacteria 52.8 3.75e-7   NR WP_196301321.1 1313 g3532 i0 50 0.568965517241379 44 22 56.9 0 48 179 16 59 WP_196301321.1 hypothetical protein, partial [Streptococcus pneumoniae] diamond 132 52.8 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
31360809 31360809 PRJEB43370_P_NODE_9596_length_165_cov_0.896552_g9553_i0 PRJEB43370 9596 165 0.896552 1.4793108 Acutalibacter caecimuris 3093657 Bacteria Bacteria 48.1 1.66e-4   NR WP_322174608.1 3093657 g9553 i0 45.6 12.3636363636364 57 29 100 2 165 1 511 567 WP_322174608.1 ATP-dependent zinc metalloprotease FtsH [Acutalibacter caecimuris] diamond 2040 48.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Acutalibacteraceae Acutalibacter Acutalibacter caecimuris
31676841 31676841 PRJEB43370_P_NODE_9337_length_165_cov_0.896552_g9294_i0 PRJEB43370 9337 165 0.896552 1.4793108 Clostridiales Family XIII bacterium 3107375 Bacteria Bacteria 77.8 1.61e-15   NR MDR0854123.1 2137877 g9294 i0 62.3 8.85454545454546 53 20 96.4 0 165 7 126 178 MDR0854123.1 enoyl-CoA hydratase/isomerase family protein [Eubacteriales Family XIII. Incertae Sedis bacterium] diamond 1461 77.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriales Family XIII. Incertae Sedis   Clostridiales Family XIII bacterium
31803311 31803311 PRJEB43370_P_NODE_1117_length_412_cov_1.002755_g1074_i0 PRJEB43370 1117 412 1.002755 4.1313506 Lihuaxuella thermophila 1173111 Bacteria Bacteria 45.1 0.0293   NR WP_170839795.1 1173111 g1074 i0 38.4 0.531553398058252 73 42 51 1 129 338 153 225 WP_170839795.1 type II secretion system F family protein [Lihuaxuella thermophila] diamond 219 45.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Thermoactinomycetaceae Lihuaxuella Lihuaxuella thermophila
32524861 32524861 PRJEB43370_P_NODE_8419_length_167_cov_0.881356_g8376_i0 PRJEB43370 8419 167 0.881356 1.47186452 Bacteria 2 Bacteria Bacteria 72 3.24e-13   NR MBS3899861.1 2093370 g8376 i0 87.5 24.4311377245509 40 5 71.9 0 167 48 210 249 MBS3899861.1 AAA family ATPase [Dethiobacter sp.] diamond 4080 72 1 Bacteria   Bacillati Bacillota Dethiobacteria Dethiobacterales Dethiobacteraceae Dethiobacter Dethiobacter sp.
32681874 32681874 PRJEB43370_P_NODE_9540_length_165_cov_0.896552_g9497_i0 PRJEB43370 9540 165 0.896552 1.4793108 Bacillati 1783272 Bacteria Bacteria 53.9 5.75e-7   NR WP_251525362.1 152268 g9497 i0 49 1.78181818181818 49 25 89.1 0 149 3 113 161 WP_251525362.1 AP2 domain-containing protein [Metabacillus litoralis] diamond 294 54.3 0.992633517495396 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus litoralis
32751753 32751753 PRJEB43370_P_NODE_5420_length_195_cov_1.404110_g5377_i0 PRJEB43370 5420 195 1.40411 2.7380145 Defluviitaleaceae bacterium 2660712 Bacteria Bacteria 98.2 3.98e-22   NR MCL2565735.1 2660712 g5377 i0 68.8 2.95384615384615 64 20 98.5 0 2 193 303 366 MCL2565735.1 asparagine--tRNA ligase [Defluviitaleaceae bacterium] diamond 576 98.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Defluviitaleaceae   Defluviitaleaceae 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);;