RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1145276", tax_kingdom = "Bacillati" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 12 ✖

tax_kingdom 1

  • Bacillati · 12 ✖

bioproject 1

  • PRJNA1145276 · 12 ✖

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
288258 288258 PRJNA1145276_P_NODE_14361_length_266_cov_1.595855_g14304_i0 PRJNA1145276 14361 266 1.595855 4.2449743 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 54.7 0.007   NTclustered gi|2188789952|dbj|AP025561.1| 2485925 g14304 i0 100 0.109022556390977 29 0 11 0 230 258 384512 384540 Oscillospiraceae bacterium CE91-St42 DNA, complete genome blastn 29 54.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
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
24514061 24514061 PRJNA1145276_P_NODE_10080_length_321_cov_1.326613_g10023_i0 PRJNA1145276 10080 321 1.326613 4.25842773 Lactobacillus iners 147802 Bacteria Bacteria 409 1.55e-109   NTclustered gi|2769739957|gb|CP160078.1| 147802 g10023 i0 92.657 457.97507788162 286 18 88 3 38 321 4531 4247 Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome blastn 147010 409 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactobacillus Lactobacillus iners
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
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
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
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

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