RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA371613" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA371613 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
2950185 2950185 PRJNA371613_P_NODE_7383_length_171_cov_0.955224_g7207_i0 PRJNA371613 7383 171 0.955224 1.63343304 Anaerococcus lactolyticus 33032 Bacteria Bacteria 105 2.31e-25   NR WP_039931090.1 33032 g7207 i0 98.2 0.982456140350877 56 1 98.2 0 3 170 279 334 WP_039931090.1 NAD(P)H-hydrate dehydratase [Anaerococcus lactolyticus] diamond 168 105 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus lactolyticus
27106325 27106325 PRJNA371613_P_NODE_7622_length_170_cov_0.962406_g7446_i0 PRJNA371613 7622 170 0.962406 1.6360902 Aedoeadaptatus nemausensis 2582829 Bacteria Bacteria 68.2 7.17e-12   NR WP_180500468.1 2582829 g7446 i0 100 0.547058823529412 31 0 54.7 0 3 95 232 262 WP_180500468.1 copper amine oxidase N-terminal domain-containing protein [Aedoeadaptatus nemausensis] diamond 93 68.2 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Aedoeadaptatus Aedoeadaptatus nemausensis
27391130 27391130 PRJNA371613_P_NODE_6003_length_189_cov_1.605263_g5827_i0 PRJNA371613 6003 189 1.605263 3.03394707 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 96.3 2.44e-21   NR MDR1019019.1 1898203 g5827 i0 74.2 0.984126984126984 62 16 98.4 0 188 3 139 200 MDR1019019.1 hypothetical protein [Lachnospiraceae bacterium] diamond 186 96.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27612076 27612076 PRJNA371613_P_NODE_8224_length_167_cov_0.953846_g8048_i0 PRJNA371613 8224 167 0.953846 1.59292282 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 85.9 8.36e-18   NR MDR1019039.1 1898203 g8048 i0 68.5 1.95808383233533 54 17 97 0 1 162 385 438 MDR1019039.1 hypothetical protein [Lachnospiraceae bacterium] diamond 327 85.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
27660780 27660780 PRJNA371613_P_NODE_9004_length_163_cov_1.015873_g8828_i0 PRJNA371613 9004 163 1.015873 1.65587299 Peptoniphilus 162289 Bacteria Bacteria 103 6.45e-24   NR WP_205052203.1 411567 g8828 i0 94.4 3.97546012269939 54 3 99.4 0 163 2 360 413 WP_205052203.1 DHH family phosphoesterase [Peptoniphilus gorbachii] diamond 648 103 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus gorbachii
29050019 29050019 PRJNA371613_P_NODE_8348_length_166_cov_0.992248_g8172_i0 PRJNA371613 8348 166 0.992248 1.64713168 Bacillota 1239 Bacteria Bacteria 86.7 4.47e-18   NR WP_115995159.1 1294267 g8172 i0 78.8 3.90361445783133 52 11 94 0 166 11 187 238 WP_115995159.1 phage tail tape measure protein [Cohnella lupini] diamond 648 86.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Cohnella Cohnella lupini
29586349 29586349 PRJNA371613_P_NODE_5470_length_201_cov_1.560976_g5294_i0 PRJNA371613 5470 201 1.560976 3.13756176 root 1 Root_unresolved Root_unresolved 89.4 8.18e-19   NR MDR1019039.1 1898203 g5294 i0 66.1 1.67164179104478 59 20 88.1 0 23 199 1 59 MDR1019039.1 hypothetical protein [Lachnospiraceae bacterium] diamond 336 89.4 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29586350 29586350 PRJNA371613_P_NODE_6850_length_174_cov_1.759124_g6674_i0 PRJNA371613 6850 174 1.759124 3.06087576 Clostridia 186801 Bacteria Bacteria 104 1.8899999999999998e-24   NR MFR5117835.1 142586 g6674 i0 87.7 46.1724137931034 57 7 98.3 0 172 2 259 315 MFR5117835.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Eubacterium sp.] diamond 8034 104 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriaceae Eubacterium Eubacterium sp.
29663922 29663922 PRJNA371613_P_NODE_7770_length_169_cov_0.969697_g7594_i0 PRJNA371613 7770 169 0.969697 1.63878793 Herbivorax sp. ANBcel31 3069754 Bacteria Bacteria 93.6 1.98e-21   NR WP_306695453.1 3069754 g7594 i0 76.4 0.976331360946746 55 13 97.6 0 3 167 180 234 WP_306695453.1 glycosyltransferase [Herbivorax sp. ANBcel31] diamond 165 93.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Herbivorax Herbivorax sp. ANBcel31
29917091 29917091 PRJNA371613_P_NODE_9211_length_162_cov_1.024000_g9035_i0 PRJNA371613 9211 162 1.024 1.65888 Peptoniphilus sp. BV3AC2 1111133 Bacteria Bacteria 108 2.76e-26   NR WP_023059932.1 1111133 g9035 i0 100 1 54 0 100 0 1 162 287 340 WP_023059932.1 hypothetical protein [Peptoniphilus sp. BV3AC2] diamond 162 108 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus sp. BV3AC2
30770108 30770108 PRJNA371613_P_NODE_8394_length_166_cov_0.992248_g8218_i0 PRJNA371613 8394 166 0.992248 1.64713168 Facklamia languida 82347 Bacteria Bacteria 112 5.830000000000001e-29   NR WP_006309015.1 82347 g8218 i0 96.4 0.993975903614458 55 2 99.4 0 166 2 51 105 WP_006309015.1 3-oxoacyl-ACP reductase [Facklamia languida] diamond 165 112 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Facklamia Facklamia languida
31338763 31338763 PRJNA371613_P_NODE_6976_length_173_cov_0.941176_g6800_i0 PRJNA371613 6976 173 0.941176 1.62823448 Staphylococcus haemolyticus 1283 Bacteria Bacteria 42 0.00236   NR GEQ09250.1 1283 g6800 i0 68 0.433526011560694 25 8 43.4 0 77 3 1 25 GEQ09250.1 hypothetical protein SHA04_21270 [Staphylococcus haemolyticus] diamond 75 42 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus haemolyticus
31356087 31356087 PRJNA371613_P_NODE_8756_length_164_cov_1.007874_g8580_i0 PRJNA371613 8756 164 1.007874 1.65291336 Macrococcus 69965 Bacteria Bacteria 79 1.88e-15   NR WP_254250397.1 69967 g8580 i0 86.4 1.6280487804878 44 6 80.5 0 30 161 1 44 WP_254250397.1 phosphoribosylamine--glycine ligase [Macrococcus equipercicus] diamond 267 79 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Macrococcus Macrococcus equipercicus
31402276 31402276 PRJNA371613_P_NODE_8536_length_165_cov_1.000000_g8360_i0 PRJNA371613 8536 165 1 1.65 Enterococcus sp. 665A 2815324 Bacteria Bacteria 104 2.43e-25   NR WP_207703342.1 2815324 g8360 i0 90.9 1 55 5 100 0 165 1 226 280 WP_207703342.1 aldo/keto reductase [Enterococcus sp. 665A] diamond 165 104 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Candidatus Enterococcus ferrettii
32066290 32066290 PRJNA371613_P_NODE_1518_length_507_cov_2.553191_g1349_i0 PRJNA371613 1518 507 2.553191 12.94467837 Lactiplantibacillus plantarum 1590 Bacteria Bacteria 95.5 1.86e-22   NR WP_229963743.1 1590 g1349 i0 95.9 0.431952662721893 73 3 43.2 0 495 277 1 73 WP_229963743.1 hypothetical protein [Lactiplantibacillus plantarum] diamond 219 95.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
32824528 32824528 PRJNA371613_P_NODE_7020_length_173_cov_0.941176_g6844_i0 PRJNA371613 7020 173 0.941176 1.62823448 Bacilli bacterium 1903720 Bacteria Bacteria 113 2e-27   NR MEG1506368.1 1903720 g6844 i0 100 0.988439306358382 57 0 98.8 0 172 2 168 224 MEG1506368.1 replication initiation protein [Bacilli bacterium] diamond 171 113 1 Bacteria   Bacillati Bacillota Bacilli       Bacilli 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);;