RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJEB80557 · 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
29908055 29908055 PRJEB80557_S_NODE_19611_length_214_cov_1.884848_g19215_i0 PRJEB80557 19611 214 1.884848 4.03357472 Sebaldella sp. S 2819260 Bacteria Bacteria 76.3 2.99e-14   NR WP_253349088.1 2957809 g19215 i0 53.1 1.79439252336449 64 30 89.7 0 23 214 165 228 WP_253349088.1 efflux RND transporter periplasmic adaptor subunit [Sebaldella sp. S0638] diamond 384 76.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Sebaldella Sebaldella sp. S0638
31417405 31417405 PRJEB80557_S_NODE_16296_length_233_cov_1.114130_g15900_i0 PRJEB80557 16296 233 1.11413 2.5959229 root 1 Root_unresolved Root_unresolved 145 9.57e-39   NR BBM48974.1 157687 g15900 i0 97.4 4.95708154506438 77 2 99.1 0 233 3 371 447 BBM48974.1 CRISPR/Cas system Cas13a [Leptotrichia wadei] diamond 1155 145 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
31733525 31733525 PRJEB80557_S_NODE_27897_length_183_cov_1.164179_g27501_i0 PRJEB80557 27897 183 1.164179 2.13044757 root 1 Root_unresolved Root_unresolved 120 3.48e-30   NR BBM48974.1 157687 g27501 i0 100 4.91803278688525 60 0 98.4 0 3 182 327 386 BBM48974.1 CRISPR/Cas system Cas13a [Leptotrichia wadei] diamond 900 120 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
32373909 32373909 PRJEB80557_S_NODE_2859_length_475_cov_1.481221_g2465_i0 PRJEB80557 2859 475 1.481221 7.03579975 Fusobacteriales bacterium 2044942 Bacteria Bacteria 89.7 3.26e-19   NR MBZ4684216.1 2044942 g2465 i0 38.7 0.783157894736842 124 76 78.3 0 475 104 45 168 MBZ4684216.1 hypothetical protein [Fusobacteriales bacterium] diamond 372 89.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales     Fusobacteriales bacterium

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