RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA849172" 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

  • PRJNA849172 · 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
4663945 4663945 PRJNA849172_P_NODE_16004_length_521_cov_3.549107_g15645_i0 PRJNA849172 16004 521 3.549107 18.49084747 Zhangzhou Narna tick virus 5 2972251 Viruses Viruses 160 1.9e-43   NR UYL95400.1 2972251 g15645 i0 58.5 0.748560460652591 130 53 74.3 1 3 389 350 479 UYL95400.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 5] diamond 390 160 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Zhangzhou Narna tick virus 5
11040139 11040139 PRJNA849172_P_NODE_4669_length_1026_cov_7.237146_g4401_i0 PRJNA849172 4669 1026 7.237146 74.25311796 Streptophyte associated narna-like virus 19 3067063 Viruses Viruses 500 2.5199999999999996e-173   NR WPR17387.1 3067063 g4401 i0 73.1 0.944444444444444 323 87 94.4 0 56 1024 32 354 WPR17387.1 MAG: RNA-dependent RNA polymerase, partial [Streptophyte associated narna-like virus 19] diamond 969 500 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Streptophyte associated narna-like virus 19
16138210 16138210 PRJNA849172_P_NODE_1493_length_1739_cov_22.744898_g1376_i0 PRJNA849172 1493 1739 22.744898 395.53377622 Zhangzhou Narna tick virus 4 2972250 Viruses Viruses 805 9.86e-289   NR UYL95399.1 2972250 g1376 i0 75.9 1.76135710178263 511 122 88.2 1 22 1554 34 543 UYL95399.1 MAG: RNA-dependent RNA polymerase [Zhangzhou Narna tick virus 4] diamond 3063 805 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Zhangzhou Narna tick virus 4
29612356 29612356 PRJNA849172_P_NODE_630_length_2351_cov_42.178665_g569_i0 PRJNA849172 630 2351 42.178665 991.62041415 Leviviridae sp. 2027243 Viruses Viruses 336 2.43e-102   NR URG16464.1 2027243 g569 i0 47.1 1.49042960442365 401 182 47.9 9 1135 2259 150 546 URG16464.1 MAG: RNA dependent RNA polymerase [Leviviridae sp.] diamond 3504 336 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
29770409 29770409 PRJNA849172_P_NODE_28271_length_385_cov_19.448718_g27912_i0 PRJNA849172 28271 385 19.448718 74.8775643 ssRNA phage SRR696 2845570 Viruses Viruses 119 6.899999999999999e-32   NR YP_010769504.1 2786549 g27912 i0 43.8 0.997402597402597 128 72 99.7 0 384 1 2 129 YP_010769504.1 coat protein [ssRNA phage SRR6960551_11] diamond 384 119 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Manrohovirus Manrohovirus lutadaptatum
29991716 29991716 PRJNA849172_P_NODE_50951_length_293_cov_18.627273_g50591_i0 PRJNA849172 50951 293 18.627273 54.57790989 Plasmopara viticola lesion associated ourmia-like virus 33 2686502 Viruses Viruses 71.2 6.38e-12   NR QGY72563.1 2686502 g50591 i0 41.5 0.839590443686007 82 48 84 0 247 2 4 85 QGY72563.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 33] diamond 246 71.2 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Magoulivirus Magoulivirus phaeoacremonii
32308110 32308110 PRJNA849172_P_NODE_8559_length_742_cov_66.064275_g8217_i0 PRJNA849172 8559 742 66.064275 490.1969205 Fiersviridae 2842319 Viruses Viruses 81.3 1.18e-13   NR YP_010769358.1 2786110 g8217 i0 38.6 0.978436657681941 132 79 53 2 319 711 134 264 YP_010769358.1 maturation protein, partial [ssRNA phage Gephyllon.1_11] diamond 726 82 0.991463414634146 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Glyciruvirus Glyciruvirus geovicinum

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