RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA657343" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA657343 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
8276499 8276499 PRJNA657343_P_NODE_547_length_723_cov_3.526706_g534_i0 PRJNA657343 547 723 3.526706 25.49808438 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 278 1.5199999999999999e-89   NR MEE3393424.1 1898203 g534 i0 58.3 0.975103734439834 235 91 97.5 3 711 7 26 253 MEE3393424.1 UDP-glucose 4-epimerase GalE [Lachnospiraceae bacterium] diamond 705 278 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
10827086 10827086 PRJNA657343_P_NODE_14989_length_231_cov_1.390110_g14965_i0 PRJNA657343 14989 231 1.39011 3.2111541 Bacteria 2 Bacteria Bacteria 133 9.589999999999999e-35   NR WP_053436003.1 1459 g14965 i0 84 95.4545454545455 75 12 97.4 0 3 227 49 123 WP_053436003.1 catalase KatA [Sporosarcina globispora] diamond 22050 134 0.992537313432836 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Sporosarcina Sporosarcina globispora
26606317 26606317 PRJNA657343_P_NODE_2661_length_437_cov_5.340206_g2638_i0 PRJNA657343 2661 437 5.340206 23.33670022 Clostridioides difficile 1496 Bacteria Bacteria 261 2.58e-86   NR MCJ0157547.1 1496 g2638 i0 81.8 20.6155606407323 143 26 98.2 0 437 9 4 146 MCJ0157547.1 WD40 repeat domain-containing protein [Clostridioides difficile] diamond 9009 262 0.99618320610687 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Clostridioides Clostridioides difficile
27302754 27302754 PRJNA657343_P_NODE_9883_length_269_cov_2.013636_g9859_i0 PRJNA657343 9883 269 2.013636 5.41668084 Fusibacter sp. 2004507 Bacteria Bacteria 77.8 1.88e-14   NR HSN67109.1 2004507 g9859 i0 44.3 0.981412639405205 88 49 98.1 0 265 2 119 206 HSN67109.1 transposase family protein [Fusibacter sp.] diamond 264 77.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriales Family XII. Incertae Sedis Fusibacter Fusibacter sp.
28325197 28325197 PRJNA657343_P_NODE_13346_length_241_cov_1.531250_g13322_i0 PRJNA657343 13346 241 1.53125 3.6903125 root 1 Root_unresolved Root_unresolved 94.4 2.53e-20   NR HVI20890.1 1409 g13322 i0 59.7 3.80912863070539 77 30 95.9 1 241 11 676 751 HVI20890.1 reverse transcriptase domain-containing protein [Bacillus sp. (in: firmicutes)] diamond 918 94.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. (in: firmicutes)
28597367 28597367 PRJNA657343_P_NODE_41667_length_164_cov_0.904348_g41643_i0 PRJNA657343 41667 164 0.904348 1.48313072 Oscillospiraceae bacterium 2485925 Bacteria Bacteria 47 4.1e-4   NR MDR2571990.1 2485925 g41643 i0 34.6 0.951219512195122 52 33 93.3 1 159 7 910 961 MDR2571990.1 protein kinase [Oscillospiraceae bacterium] diamond 156 47 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
29197301 29197301 PRJNA657343_P_NODE_41669_length_164_cov_0.904348_g41645_i0 PRJNA657343 41669 164 0.904348 1.48313072 Bacillota bacterium 1879010 Bacteria Bacteria 83.2 6.86e-17   NR MEI6287151.1 1879010 g41645 i0 73.1 10.5365853658537 52 14 95.1 0 164 9 392 443 MEI6287151.1 phosphoenolpyruvate carboxykinase (ATP) [Bacillota bacterium] diamond 1728 83.2 1 Bacteria   Bacillati Bacillota         Bacillota bacterium
29701957 29701957 PRJNA657343_P_NODE_27450_length_185_cov_1.382353_g27426_i0 PRJNA657343 27450 185 1.382353 2.55735305 Fusibacter sp. 2004507 Bacteria Bacteria 52.4 6.71e-6   NR HSN67109.1 2004507 g27426 i0 39.7 0.940540540540541 58 34 94.1 1 178 5 266 322 HSN67109.1 transposase family protein [Fusibacter sp.] diamond 174 52.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Eubacteriales Family XII. Incertae Sedis Fusibacter Fusibacter sp.
29765327 29765327 PRJNA657343_P_NODE_28991_length_181_cov_1.962121_g28967_i0 PRJNA657343 28991 181 1.962121 3.55143901 Faecalispora jeddahensis 1414721 Bacteria Bacteria 42.4 0.0219   NR MFR1802583.1 1414721 g28967 i0 40 0.911602209944751 55 27 91.2 1 11 175 224 272 MFR1802583.1 MFS transporter [Faecalispora jeddahensis] diamond 165 42.4 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae Faecalispora Faecalispora jeddahensis

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