RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1145276" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 16 ✖

bioproject 1

  • PRJNA1145276 · 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
9216292 9216292 PRJNA1145276_P_NODE_13048_length_281_cov_1.399038_g12991_i0 PRJNA1145276 13048 281 1.399038 3.93129678 Enterococcus faecalis 1351 Bacteria Bacteria 188 2.4300000000000003e-58   NR WP_411401454.1 1351 g12991 i0 100 3.97153024911032 93 0 99.3 0 279 1 65 157 WP_411401454.1 hypothetical protein, partial [Enterococcus faecalis] diamond 1116 188 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecalis
23240736 23240736 PRJNA1145276_P_NODE_17219_length_247_cov_0.885057_g17162_i0 PRJNA1145276 17219 247 0.885057 2.18609079 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 171 2.0599999999999995e-47   NR GFH96433.1 1898203 g17162 i0 100 0.995951417004049 82 0 99.6 0 1 246 370 451 GFH96433.1 DNA-directed RNA polymerase subunit beta [Lachnospiraceae bacterium] diamond 246 171 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
26721921 26721921 PRJNA1145276_P_NODE_13221_length_279_cov_1.257282_g13164_i0 PRJNA1145276 13221 279 1.257282 3.50781678 Clostridium botulinum 1491 Bacteria Bacteria 61.2 6.89e-10   NR WP_231172257.1 1491 g13164 i0 72.5 0.43010752688172 40 11 43 0 160 279 17 56 WP_231172257.1 hypothetical protein, partial [Clostridium botulinum] diamond 120 61.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium botulinum
26753710 26753710 PRJNA1145276_P_NODE_18001_length_245_cov_0.895349_g17944_i0 PRJNA1145276 18001 245 0.895349 2.19360505 Bacillus toyonensis 155322 Bacteria Bacteria 76.6 3.72e-16   NR PHF94465.1 155322 g17944 i0 56.3 0.869387755102041 71 31 86.9 0 18 230 12 82 PHF94465.1 hypothetical protein COI49_31885, partial [Bacillus toyonensis] diamond 213 76.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus toyonensis
27070516 27070516 PRJNA1145276_P_NODE_17222_length_247_cov_0.885057_g17165_i0 PRJNA1145276 17222 247 0.885057 2.18609079 Cutibacterium acnes HL 1747 Bacteria Bacteria 45.4 2.24e-4   NR EFT59931.1 765074 g17165 i0 43.6 0.473684210526316 39 22 47.4 0 140 24 1 39 EFT59931.1 hypothetical protein HMPREF9572_01614 [Cutibacterium acnes HL072PA1] diamond 117 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27923370 27923370 PRJNA1145276_P_NODE_6905_length_383_cov_0.770968_g6848_i0 PRJNA1145276 6905 383 0.770968 2.95280744 Mycobacterium tuberculosis 1773 Bacteria Bacteria 45.8 0.0114   NR CLA46635.1 1773 g6848 i0 93.6 0.736292428198433 47 3 36.8 0 187 47 113 159 CLA46635.1 Uncharacterised protein [Mycobacterium tuberculosis] diamond 282 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
28901987 28901987 PRJNA1145276_P_NODE_7268_length_374_cov_1.601329_g7211_i0 PRJNA1145276 7268 374 1.601329 5.98897046 Bacillus velezensis 492670 Bacteria Bacteria 73.9 1.45e-14   NR WP_218950233.1 492670 g7211 i0 75 0.385026737967914 48 12 38.5 0 373 230 29 76 WP_218950233.1 hypothetical protein, partial [Bacillus velezensis] diamond 144 73.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus velezensis
29396303 29396303 PRJNA1145276_P_NODE_14949_length_259_cov_1.430108_g14892_i0 PRJNA1145276 14949 259 1.430108 3.70397972 Bacillati 1783272 Bacteria Bacteria 54.7 2.13e-7   NR KTT77149.1 1296 g14892 i0 39.3 2.83783783783784 84 51 97.3 0 5 256 5 88 KTT77149.1 hypothetical protein NS1R_14860, partial [Mammaliicoccus sciuri] diamond 735 54.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Mammaliicoccus Mammaliicoccus sciuri
29849505 29849505 PRJNA1145276_P_NODE_3191_length_544_cov_1.632696_g3134_i0 PRJNA1145276 3191 544 1.632696 8.88186624 Streptomyces aureoverticillatus 66871 Bacteria Bacteria 152 8.67e-45   NR GGS30451.1 66871 g3134 i0 98.7 0.435661764705882 79 1 43.6 0 226 462 1 79 GGS30451.1 hypothetical protein GCM10010252_78320 [Streptomyces aureoverticillatus] diamond 237 152 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces aureoverticillatus
29912764 29912764 PRJNA1145276_P_NODE_18751_length_243_cov_0.905882_g18694_i0 PRJNA1145276 18751 243 0.905882 2.20129326 Listeria monocytogenes 1639 Bacteria Bacteria 54.3 9.76e-8   NR WP_242328663.1 1639 g18694 i0 79.4 0.419753086419753 34 7 42 0 107 6 1 34 WP_242328663.1 hypothetical protein [Listeria monocytogenes] diamond 102 54.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria monocytogenes
30512840 30512840 PRJNA1145276_P_NODE_12553_length_287_cov_1.079439_g12496_i0 PRJNA1145276 12553 287 1.079439 3.09798993 Mammaliicoccus sciuri 1296 Bacteria Bacteria 52.4 2.31e-6   NR KTT77149.1 1296 g12496 i0 40 0.836236933797909 80 48 83.6 0 273 34 9 88 KTT77149.1 hypothetical protein NS1R_14860, partial [Mammaliicoccus sciuri] diamond 240 52.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Mammaliicoccus Mammaliicoccus sciuri
30544523 30544523 PRJNA1145276_P_NODE_11773_length_296_cov_1.412556_g11716_i0 PRJNA1145276 11773 296 1.412556 4.18116576 Lactobacillus crispatus 47770 Bacteria Bacteria 59.3 2.3e-9   NR TDN07424.1 47770 g11716 i0 63.6 0.445945945945946 44 16 44.6 0 158 27 13 56 TDN07424.1 hypothetical protein CEE84_11690 [Lactobacillus crispatus] diamond 132 59.3 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus crispatus
31113000 31113000 PRJNA1145276_P_NODE_11915_length_295_cov_0.855856_g11858_i0 PRJNA1145276 11915 295 0.855856 2.5247752 Streptomyces sp. AS 1931 Bacteria Bacteria 59.3 2.3e-9   NR WP_250093409.1 2938946 g11858 i0 50 0.569491525423729 56 28 56.9 0 247 80 7 62 WP_250093409.1 hypothetical protein, partial [Streptomyces sp. AS02] diamond 168 59.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. AS02
31113003 31113003 PRJNA1145276_P_NODE_6575_length_391_cov_1.210692_g6518_i0 PRJNA1145276 6575 391 1.210692 4.73380572 Streptomyces sp. B93 2824875 Bacteria Bacteria 46.2 0.00958   NR WP_210924484.1 2824875 g6518 i0 35.2 0.544757033248082 71 45 53.7 1 242 33 238 308 WP_210924484.1 LLM class flavin-dependent oxidoreductase [Streptomyces sp. B93] diamond 213 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. B93
31714078 31714078 PRJNA1145276_P_NODE_1417_length_795_cov_2.869806_g1368_i0 PRJNA1145276 1417 795 2.869806 22.8149577 Fructilactobacillus sanfranciscensis 1625 Bacteria Bacteria 111 9.9e-27   NR POH17992.1 1625 g1368 i0 48.8 0.471698113207547 125 64 47.2 0 500 126 1 125 POH17992.1 hypothetical protein BGL45_06810 [Fructilactobacillus sanfranciscensis] diamond 375 111 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Fructilactobacillus Fructilactobacillus sanfranciscensis
31903792 31903792 PRJNA1145276_P_NODE_4597_length_458_cov_2.779221_g4540_i0 PRJNA1145276 4597 458 2.779221 12.72883218 Mycobacterium angelicum 470074 Bacteria Bacteria 65.9 6.24e-11   NR WP_211281424.1 470074 g4540 i0 61.5 0.799126637554585 52 20 34.1 0 254 409 20 71 WP_211281424.1 hypothetical protein, partial [Mycobacterium angelicum] diamond 366 65.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium angelicum

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