RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA801875 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
26968042 26968042 PRJNA801875_P_NODE_2902_length_197_cov_1.172840_g2799_i0 PRJNA801875 2902 197 1.17284 2.3104948 root 1 Root_unresolved Root_unresolved 75.9 2.61e-16   NR HEN0035530.1 1311 g2799 i0 74.5 11.1167512690355 51 13 77.7 0 35 187 14 64 HEN0035530.1 hypothetical protein [Streptococcus agalactiae] diamond 2190 76.6 0.990861618798956 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus agalactiae
27686340 27686340 PRJNA801875_P_NODE_1624_length_299_cov_2.420455_g1521_i0 PRJNA801875 1624 299 2.420455 7.23716045 Metabacillus flavus 2823519 Bacteria Bacteria 76.3 3.62e-14   NR WP_211560879.1 2823519 g1521 i0 53.3 1.8561872909699 92 39 92.3 3 281 6 2 89 WP_211560879.1 SDR family NAD(P)-dependent oxidoreductase [Metabacillus flavus] diamond 555 76.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus flavus
27821334 27821334 PRJNA801875_P_NODE_3884_length_166_cov_1.786260_g3781_i0 PRJNA801875 3884 166 1.78626 2.9651916 FCB group 1783270 Bacteria Bacteria 45.1 0.00205   NR WP_212904154.1 69208 g3781 i0 46.9 4.51807228915663 49 25 88.6 1 162 16 619 666 WP_212904154.1 DsrE/DsrF/DrsH-like family protein [Clostridium polyendosporum] diamond 750 45.1 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium polyendosporum
30654345 30654345 PRJNA801875_P_NODE_2953_length_195_cov_0.987500_g2850_i0 PRJNA801875 2953 195 0.9875 1.925625 Listeria ivanovii 1638 Bacteria Bacteria 49.3 7.51e-5   NR WP_325176422.1 1638 g2850 i0 36.4 1.01538461538462 66 38 96.9 2 3 191 42 106 WP_325176422.1 hypothetical protein [Listeria ivanovii] diamond 198 49.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Listeriaceae Listeria Listeria ivanovii

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