RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA763243 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
17321350 17321350 PRJNA763243_P_NODE_29694_length_310_cov_2.468354_g29348_i0 PRJNA763243 29694 310 2.468354 7.6518974 Fusarium poae narnavirus 2 1849532 Viruses Viruses 231 3.47e-56   NTclustered gi|1063296161|ref|NC_030866.1| 1849532 g29348 i0 95.205 3.39354838709677 146 7 47 0 161 306 954 809 Fusarium poae narnavirus 2 genomic RNA, complete genome blastn 1052 231 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Fusarium poae narnavirus 2
19869894 19869894 PRJNA763243_P_NODE_29036_length_310_cov_4.637131_g28690_i0 PRJNA763243 29036 310 4.637131 14.3751061 Erysiphe necator associated narnavirus 5 2695338 Viruses Viruses 213 1.26e-50   NTclustered gi|1793889052|gb|MN557023.1| 2695338 g28690 i0 93.103 1.73225806451613 145 10 47 0 4 148 1582 1726 Erysiphe necator associated narnavirus 5 isolate PMS-18_DN51913_ RdRp gene, complete cds blastn 537 213 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Erysiphe necator associated narnavirus 5
22420312 22420312 PRJNA763243_P_NODE_28898_length_310_cov_5.122363_g28552_i0 PRJNA763243 28898 310 5.122363 15.8793253 Grapevine wood holobiome associated narna-like virus 21 3398658 Viruses Viruses 135 2.8e-27   NTclustered gi|2905035892|gb|PV022019.1| 3398658 g28552 i0 84.672 0.441935483870968 137 19 44 2 7 142 388 253 Grapevine wood holobiome associated narna-like virus 21 isolate grp21 segment RNA3 HP1 gene, complete cds blastn 137 135 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Grapevine wood holobiome associated narna-like virus 21

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