RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA358049" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA358049 · 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
27074833 27074833 PRJNA358049_S_NODE_7102_length_233_cov_2.342391_g7054_i0 PRJNA358049 7102 233 2.342391 5.45777103 Botourmiaviridae sp. 2808997 Viruses Viruses 70.5 5.47e-12   NR WAK77862.1 2808997 g7054 i0 45.9 0.952789699570815 74 38 95.3 1 231 10 440 511 WAK77862.1 MAG: hypothetical protein [Botourmiaviridae sp.] diamond 222 70.5 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
27801530 27801530 PRJNA358049_S_NODE_13244_length_183_cov_1.156716_g13196_i0 PRJNA358049 13244 183 1.156716 2.11679028 Erysiphe necator associated ourmia-like virus 36 2741816 Viruses Viruses 103 8.289999999999999e-24   NR QKI79866.1 2741816 g13196 i0 73.3 1.95081967213115 60 16 98.4 0 182 3 81 140 QKI79866.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 36] diamond 357 103 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 36
29127731 29127731 PRJNA358049_S_NODE_2309_length_386_cov_4.899110_g2261_i0 PRJNA358049 2309 386 4.89911 18.9105646 Erysiphe necator associated ourmia-like virus 36 2741816 Viruses Viruses 223 5.859999999999999e-67   NR QKI79866.1 2741816 g2261 i0 80.5 0.994818652849741 128 25 99.5 0 2 385 132 259 QKI79866.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 36] diamond 384 223 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 36
31988506 31988506 PRJNA358049_S_NODE_3038_length_341_cov_1.989726_g2990_i0 PRJNA358049 3038 341 1.989726 6.78496566 Viruses 10239 Viruses Viruses 133 1.49e-33   NR WAK77979.1 2808997 g2990 i0 61.4 8.4633431085044 114 42 99.4 2 2 340 339 451 WAK77979.1 MAG: hypothetical protein [Botourmiaviridae sp.] diamond 2886 133 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.

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