RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA722925" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA722925 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27726341 27726341 PRJNA722925_S_NODE_8764_length_164_cov_1.322835_g8701_i0 PRJNA722925 8764 164 1.322835 2.1694494 root 1 Root_unresolved Root_unresolved 70.5 1.01e-14   NR KZU89800.1 1590 g8701 i0 87.2 3.25609756097561 39 5 71.3 0 42 158 2 40 KZU89800.1 hypothetical protein Nizo3893_2340 [Lactiplantibacillus plantarum] diamond 534 70.5 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Lactobacillaceae Lactiplantibacillus Lactiplantibacillus plantarum
28325699 28325699 PRJNA722925_S_NODE_6526_length_182_cov_1.882759_g6463_i0 PRJNA722925 6526 182 1.882759 3.42662138 Allobaculum 174708 Bacteria Bacteria 111 1.2299999999999998e-29   NR WP_019892766.1 174709 g6463 i0 100 1.97802197802198 60 0 98.9 0 2 181 42 101 WP_019892766.1 DUF948 domain-containing protein [Allobaculum stercoricanis] diamond 360 111 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae Allobaculum Allobaculum stercoricanis
28725840 28725840 PRJNA722925_S_NODE_8387_length_166_cov_18.457364_g8324_i0 PRJNA722925 8387 166 18.457364 30.63922424 Staphylococcus aureus 1280 Bacteria Bacteria 47.8 3.38e-5   NR MCS4580470.1 1280 g8324 i0 92.5 0.72289156626506 40 3 72.3 0 156 37 1 40 MCS4580470.1 hypothetical protein [Staphylococcus aureus] diamond 120 47.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
28957538 28957538 PRJNA722925_S_NODE_11248_length_151_cov_1.464912_g11185_i0 PRJNA722925 11248 151 1.464912 2.21201712 Streptococcus 1301 Bacteria Bacteria 63.9 3.49e-10   NR WP_414307118.1 28037 g11185 i0 80 1.98675496688742 50 10 99.3 0 151 2 12 61 WP_414307118.1 DUF1542 domain-containing protein, partial [Streptococcus mitis] diamond 300 64.3 0.993779160186625 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus mitis
29451722 29451722 PRJNA722925_S_NODE_11110_length_152_cov_1.017391_g11047_i0 PRJNA722925 11110 152 1.017391 1.54643432 uncultured Gemella sp. 254352 Bacteria Bacteria 98.2 3.13e-22   NR WP_299324214.1 254352 g11047 i0 100 0.986842105263158 50 0 98.7 0 150 1 1821 1870 WP_299324214.1 Ig-like domain-containing protein [uncultured Gemella sp.] diamond 150 98.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Gemellaceae Gemella uncultured Gemella sp.
29957246 29957246 PRJNA722925_S_NODE_7311_length_175_cov_1.130435_g7248_i0 PRJNA722925 7311 175 1.130435 1.97826125 Lachnoanaerobaculum saburreum 467210 Bacteria Bacteria 124 1.4899999999999998e-31   NR WP_008751559.1 467210 g7248 i0 100 0.977142857142857 57 0 97.7 0 173 3 455 511 WP_008751559.1 excinuclease ABC subunit UvrC [Lachnoanaerobaculum saburreum] diamond 171 124 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnoanaerobaculum Lachnoanaerobaculum saburreum

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