RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA255848" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA255848 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
11847332 11847332 PRJNA255848_P_NODE_38170_length_166_cov_0.871795_g37852_i0 PRJNA255848 38170 166 0.871795 1.4471797 Erysiphe necator associated ourmia-like virus 119 2741779 Viruses Viruses 307 2.69e-79   NTclustered gi|1848976769|gb|MN611646.1| 2741779 g37852 i0 100 7.95783132530121 166 0 100 0 1 166 434 269 Erysiphe necator associated ourmia-like virus 119 isolate PMS8_126, complete genome blastn 1321 307 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 119
13122448 13122448 PRJNA255848_P_NODE_22371_length_211_cov_0.944444_g22053_i0 PRJNA255848 22371 211 0.944444 1.99277684 Scleroulivirus epsilonplasmoparae 2956408 Viruses Viruses 351 1.63e-92   NTclustered gi|2500381362|ref|NC_076793.1| 2686535 g22053 i0 96.682 5.98104265402844 211 7 100 0 1 211 797 587 Plasmopara viticola lesion associated ourmia-like virus 63 isolate DMG-B_Contig3 RNA dependent RNA polymerase (QKR69_gp1) gene, complete cds blastn 1262 351 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Scleroulivirus Scleroulivirus epsilonplasmoparae

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