RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1137393" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1137393 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
29312493 29312493 PRJNA1137393_P_NODE_47769_length_167_cov_1.322034_g47253_i0 PRJNA1137393 47769 167 1.322034 2.20779678 Moss associated botourmia-like virus 89 3066726 Viruses Viruses 68.9 1.55e-12   NR WPR16895.1 3066726 g47253 i0 61.8 0.988023952095808 55 21 98.8 0 167 3 131 185 WPR16895.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated botourmia-like virus 89] diamond 165 68.9 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Moss associated botourmia-like virus 89
29364789 29364789 PRJNA1137393_P_NODE_9049_length_276_cov_1.709251_g8533_i0 PRJNA1137393 9049 276 1.709251 4.71753276 Magoulivirus 2560172 Viruses Viruses 55.1 2.5e-6   NR YP_010800216.1 2686483 g8533 i0 55 1.35869565217391 40 18 43.5 0 3 122 583 622 YP_010800216.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 16] diamond 375 55.5 0.992792792792793 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Magoulivirus Magoulivirus miplasmoparae
29627759 29627759 PRJNA1137393_P_NODE_17150_length_212_cov_1.773006_g16634_i0 PRJNA1137393 17150 212 1.773006 3.75877272 Sjack associated botourmia-like virus 15 3066740 Viruses Viruses 119 3.69e-29   NR WPR16981.1 3066740 g16634 i0 71 0.976415094339623 69 20 97.6 0 208 2 228 296 WPR16981.1 MAG: RNA-dependent RNA polymerase [Sjack associated botourmia-like virus 15] diamond 207 119 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Sjack associated botourmia-like virus 15
29691022 29691022 PRJNA1137393_P_NODE_39290_length_169_cov_1.300000_g38774_i0 PRJNA1137393 39290 169 1.3 2.197 Botourmiaviridae sp. 2808997 Viruses Viruses 79 2.14e-15   NR URG17172.1 2808997 g38774 i0 75.5 0.869822485207101 49 12 87 0 168 22 350 398 URG17172.1 MAG: RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] diamond 147 79 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
30228284 30228284 PRJNA1137393_P_NODE_64272_length_164_cov_0.904348_g63756_i0 PRJNA1137393 64272 164 0.904348 1.48313072 Sjack associated botourmia-like virus 15 3066740 Viruses Viruses 73.6 1.72e-13   NR WPR16981.1 3066740 g63756 i0 71.7 0.969512195121951 53 14 97 1 161 3 452 503 WPR16981.1 MAG: RNA-dependent RNA polymerase [Sjack associated botourmia-like virus 15] diamond 159 73.6 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Sjack associated botourmia-like virus 15
31386771 31386771 PRJNA1137393_P_NODE_74436_length_157_cov_2.472222_g73920_i0 PRJNA1137393 74436 157 2.472222 3.88138854 Viruses 10239 Viruses Viruses 65.9 7.78e-11   NR WLK77428.1 3067804 g73920 i0 58.8 2.92356687898089 51 21 97.5 0 155 3 122 172 WLK77428.1 RNA-dependent RNA polymerase [Suillus luteus botourmiavirus 3] diamond 459 66.2 0.995468277945619 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Suillus luteus botourmiavirus 3
32188546 32188546 PRJNA1137393_P_NODE_9578_length_268_cov_1.392694_g9062_i0 PRJNA1137393 9578 268 1.392694 3.73241992 Sjack associated botourmia-like virus 15 3066740 Viruses Viruses 107 9.25e-25   NR WPR16981.1 3066740 g9062 i0 65.2 0.996268656716418 89 30 99.6 1 268 2 504 591 WPR16981.1 MAG: RNA-dependent RNA polymerase [Sjack associated botourmia-like virus 15] diamond 267 107 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Sjack associated botourmia-like virus 15

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