RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJEB56027" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJEB56027 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
122158 122158 PRJEB56027_P_NODE_107761_length_258_cov_2.097297_g104952_i0 PRJEB56027 107761 258 2.097297 5.41102626 Lactococcus hircilactis 1494462 Bacteria Bacteria 179 1.4499999999999999e-52   NR WP_153495869.1 1494462 g104952 i0 100 1 86 0 100 0 258 1 183 268 WP_153495869.1 HD domain-containing protein [Lactococcus hircilactis] diamond 258 179 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Lactococcus Lactococcus hircilactis
22668908 22668908 PRJEB56027_P_NODE_87478_length_286_cov_1.901408_g84669_i0 PRJEB56027 87478 286 1.901408 5.43802688 Cytobacillus horneckiae 549687 Bacteria Bacteria 146 5.37e-39   NR WP_066198410.1 549687 g84669 i0 100 0.797202797202797 76 0 79.7 0 3 230 445 520 WP_066198410.1 ABC transporter ATP-binding protein [Cytobacillus horneckiae] diamond 228 146 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Cytobacillus Cytobacillus horneckiae
22668910 22668910 PRJEB56027_P_NODE_88938_length_284_cov_1.459716_g86129_i0 PRJEB56027 88938 284 1.459716 4.14559344 Clostridiales bacterium 1898207 Bacteria Bacteria 176 3.12e-51   NR MBS6116743.1 1898207 g86129 i0 94.7 1.98591549295775 94 5 99.3 0 284 3 269 362 MBS6116743.1 ABC transporter ATP-binding protein [Clostridiales bacterium] diamond 564 176 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
26685265 26685265 PRJEB56027_P_NODE_128501_length_243_cov_1.805882_g125692_i0 PRJEB56027 128501 243 1.805882 4.38829326 Thermicanus aegyptius 94009 Bacteria Bacteria 149 8.8e-40   NR WP_028986924.1 94009 g125692 i0 93.8 1 81 4 98.8 1 2 241 369 449 WP_028986924.1 HD domain-containing phosphohydrolase [Thermicanus aegyptius] diamond 243 149 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
27096750 27096750 PRJEB56027_P_NODE_98162_length_271_cov_1.555556_g95353_i0 PRJEB56027 98162 271 1.555556 4.21555676 Falseniella ignava 137730 Bacteria Bacteria 85.5 1.18e-18   NR WP_101953717.1 137730 g95353 i0 100 0.453874538745387 41 0 45.4 0 2 124 125 165 WP_101953717.1 PTS sugar transporter subunit IIA [Falseniella ignava] diamond 123 85.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Falseniella Falseniella ignava
27254752 27254752 PRJEB56027_P_NODE_136123_length_232_cov_2.685535_g133314_i0 PRJEB56027 136123 232 2.685535 6.2304412 Peptoniphilus grossensis 1465756 Bacteria Bacteria 138 3.38e-38   NR WP_412261186.1 1465756 g133314 i0 93.5 0.995689655172414 77 5 99.6 0 231 1 18 94 WP_412261186.1 MerR family transcriptional regulator [Peptoniphilus grossensis] diamond 231 138 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus grossensis
27854839 27854839 PRJEB56027_P_NODE_104285_length_263_cov_1.384211_g101476_i0 PRJEB56027 104285 263 1.384211 3.64047493 Anaerococcus faecalis 2742993 Bacteria Bacteria 75.9 1.04e-13   NR WP_176270234.1 2742993 g101476 i0 54.8 0.707224334600761 62 28 70.7 0 2 187 717 778 WP_176270234.1 hydroxymethylbilane synthase [Anaerococcus faecalis] diamond 186 75.9 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus faecalis
28423383 28423383 PRJEB56027_P_NODE_131026_length_242_cov_0.911243_g128217_i0 PRJEB56027 131026 242 0.911243 2.20520806 Clostridia bacterium 2044939 Bacteria Bacteria 102 8.37e-26   NR MBZ4647456.1 2044939 g128217 i0 98 0.619834710743802 50 1 62 0 152 3 1 50 MBZ4647456.1 hypothetical protein [Clostridia bacterium] diamond 150 102 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28423384 28423384 PRJEB56027_P_NODE_97146_length_272_cov_3.512563_g94337_i0 PRJEB56027 97146 272 3.512563 9.55417136 Peptoniphilus porci 2652280 Bacteria Bacteria 178 3.47e-53   NR WP_075660466.1 2652280 g94337 i0 94.4 0.992647058823529 90 5 99.3 0 2 271 29 118 WP_075660466.1 DNA adenine methylase [Peptoniphilus porci] diamond 270 178 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus porci
29023488 29023488 PRJEB56027_P_NODE_131428_length_242_cov_0.911243_g128619_i0 PRJEB56027 131428 242 0.911243 2.20520806 Clostridiales bacterium 1898207 Bacteria Bacteria 126 1.01e-33   NR MCR5484597.1 1898207 g128619 i0 75.9 4.93388429752066 79 19 97.9 0 2 238 102 180 MCR5484597.1 nucleoside triphosphate pyrophosphohydrolase [Clostridiales bacterium] diamond 1194 126 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
29118049 29118049 PRJEB56027_P_NODE_100149_length_268_cov_2.143590_g97340_i0 PRJEB56027 100149 268 2.14359 5.7448212 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 147 7.939999999999998e-43   NR RKW52391.1 1898203 g97340 i0 87.6 0.996268656716418 89 11 99.6 0 2 268 79 167 RKW52391.1 MAG: cell division protein SepF [Lachnospiraceae bacterium] diamond 267 147 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
29300554 29300554 PRJEB56027_P_NODE_119349_length_248_cov_1.491429_g116540_i0 PRJEB56027 119349 248 1.491429 3.69874392 FCB group 1783270 Bacteria Bacteria 83.2 9.55e-19   NR WP_375855466.1 1351 g116540 i0 60.9 1.5241935483871 87 25 95.6 2 248 12 3 88 WP_375855466.1 hypothetical protein [Enterococcus faecalis] diamond 378 83.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
29496736 29496736 PRJEB56027_P_NODE_111770_length_253_cov_2.138889_g108961_i0 PRJEB56027 111770 253 2.138889 5.41138917 Anaerococcus vaginimassiliensis 2042308 Bacteria Bacteria 163 4.48e-49   NR WP_130819494.1 2042308 g108961 i0 97.6 0.99604743083004 84 2 99.6 0 253 2 43 126 WP_130819494.1 isochorismatase family protein [Anaerococcus vaginimassiliensis] diamond 252 163 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus vaginimassiliensis
29749018 29749018 PRJEB56027_P_NODE_105851_length_261_cov_1.276596_g103042_i0 PRJEB56027 105851 261 1.276596 3.33191556 Lentilactobacillus senioris 931534 Bacteria Bacteria 161 9.36e-45   NR WP_056978051.1 931534 g103042 i0 100 0.988505747126437 86 0 98.9 0 3 260 74 159 WP_056978051.1 hypothetical protein [Lentilactobacillus senioris] diamond 258 161 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lentilactobacillus Lentilactobacillus senioris
30128088 30128088 PRJEB56027_P_NODE_98312_length_271_cov_1.368687_g95503_i0 PRJEB56027 98312 271 1.368687 3.70914177 Thermicanus aegyptius 94009 Bacteria Bacteria 139 1.26e-39   NR WP_005585308.1 94009 g95503 i0 87 0.85239852398524 77 10 85.2 0 41 271 1 77 WP_005585308.1 NAD(P)/FAD-dependent oxidoreductase [Thermicanus aegyptius] diamond 231 139 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
30191458 30191458 PRJEB56027_P_NODE_133172_length_241_cov_0.916667_g130363_i0 PRJEB56027 133172 241 0.916667 2.20916747 Thermicanus aegyptius 94009 Bacteria Bacteria 130 6.53e-33   NR WP_028988490.1 94009 g130363 i0 80.8 0.970954356846473 78 15 97.1 0 239 6 486 563 WP_028988490.1 stage II sporulation protein E [Thermicanus aegyptius] diamond 234 130 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
30255045 30255045 PRJEB56027_P_NODE_130972_length_242_cov_0.911243_g128163_i0 PRJEB56027 130972 242 0.911243 2.20520806 Bacillota bacterium 1879010 Bacteria Bacteria 80.9 9.16e-17   NR MBT9137494.1 1879010 g128163 i0 51.3 1.89669421487603 76 36 94.2 1 1 228 26 100 MBT9137494.1 hypothetical protein [Bacillota bacterium] diamond 459 80.9 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
30381544 30381544 PRJEB56027_P_NODE_137013_length_229_cov_2.576923_g134204_i0 PRJEB56027 137013 229 2.576923 5.90115367 Anaerococcus murdochii 411577 Bacteria Bacteria 113 3.11e-28   NR WP_223418236.1 411577 g134204 i0 100 0.720524017467249 55 0 72.1 0 227 63 287 341 WP_223418236.1 M42 family metallopeptidase [Anaerococcus murdochii] diamond 165 113 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus murdochii
30444466 30444466 PRJEB56027_P_NODE_127813_length_244_cov_0.900585_g125004_i0 PRJEB56027 127813 244 0.900585 2.1974274 Streptococcus thermophilus 1308 Bacteria Bacteria 122 3.58e-30   NR TKW62483.1 1308 g125004 i0 67.1 0.971311475409836 79 26 97.1 0 244 8 651 729 TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus] diamond 237 122 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus thermophilus
30823473 30823473 PRJEB56027_P_NODE_120514_length_248_cov_0.880000_g117705_i0 PRJEB56027 120514 248 0.88 2.1824 Thermicanus aegyptius 94009 Bacteria Bacteria 59.7 4.04e-8   NR WP_028986559.1 94009 g117705 i0 43.9 0.991935483870968 82 46 99.2 0 247 2 328 409 WP_028986559.1 methyl-accepting chemotaxis protein [Thermicanus aegyptius] diamond 246 59.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
31107690 31107690 PRJEB56027_P_NODE_116455_length_250_cov_0.870056_g113646_i0 PRJEB56027 116455 250 0.870056 2.17514 Thermicanus aegyptius 94009 Bacteria Bacteria 129 1.6e-35   NR WP_028986967.1 94009 g113646 i0 85.3 0.9 75 11 90 0 3 227 146 220 WP_028986967.1 L-serine ammonia-lyase, iron-sulfur-dependent subunit beta [Thermicanus aegyptius] diamond 225 129 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
31107691 31107691 PRJEB56027_P_NODE_89075_length_284_cov_1.336493_g86266_i0 PRJEB56027 89075 284 1.336493 3.79564012 Enterococcus faecium 1352 Bacteria Bacteria 41.2 0.0366   NR WP_416115354.1 1352 g86266 i0 47.4 0.401408450704225 38 20 40.1 0 214 101 10 47 WP_416115354.1 hypothetical protein, partial [Enterococcus faecium] diamond 114 41.2 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
31170781 31170781 PRJEB56027_P_NODE_102615_length_265_cov_1.604167_g99806_i0 PRJEB56027 102615 265 1.604167 4.25104255 Veillonellaceae bacterium DNF 2049049 Bacteria Bacteria 100 4.4599999999999996e-23   NR KXB92744.1 1588754 g99806 i0 95.9 0.554716981132075 49 2 55.5 0 2 148 264 312 KXB92744.1 periplasmic binding protein [Veillonellaceae bacterium DNF00626] diamond 147 100 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae   Veillonellaceae bacterium DNF00626
31645277 31645277 PRJEB56027_P_NODE_133037_length_241_cov_0.916667_g130228_i0 PRJEB56027 133037 241 0.916667 2.20916747 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 149 1.3599999999999999e-42   NR MCI8750033.1 1898203 g130228 i0 100 0.983402489626556 79 0 98.3 0 240 4 18 96 MCI8750033.1 pyrroline-5-carboxylate reductase [Lachnospiraceae bacterium] diamond 237 149 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32151629 32151629 PRJEB56027_P_NODE_137858_length_226_cov_2.620915_g135049_i0 PRJEB56027 137858 226 2.620915 5.9232679 Cytobacillus horneckiae 549687 Bacteria Bacteria 152 4.7799999999999997e-42   NR WP_206393222.1 549687 g135049 i0 100 0.942477876106195 71 0 94.2 0 14 226 127 197 WP_206393222.1 23S rRNA (uracil(1939)-C(5))-methyltransferase RlmD [Cytobacillus horneckiae] diamond 213 152 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Cytobacillus Cytobacillus horneckiae

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