RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA540466" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA540466 · 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
27299154 27299154 PRJNA540466_S_NODE_22663_length_373_cov_4.466667_g22114_i0 PRJNA540466 22663 373 4.466667 16.66066791 Plasmopara viticola lesion associated tobamo-like virus 1 2719536 Viruses Viruses 70.1 4.62e-11   NR QIP68002.1 2719536 g22114 i0 38.5 0.772117962466488 96 57 75.6 1 2 283 2198 2293 QIP68002.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated tobamo-like virus 1] diamond 288 70.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Plasmopara viticola lesion associated tobamo-like virus 1
29319874 29319874 PRJNA540466_S_NODE_58369_length_249_cov_0.875000_g57820_i0 PRJNA540466 58369 249 0.875 2.17875 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 119 4.83e-29   NR WKU61618.1 3063761 g57820 i0 98.2 0.674698795180723 56 1 67.5 0 240 73 2165 2220 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 168 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
31911159 31911159 PRJNA540466_S_NODE_56017_length_252_cov_2.340782_g55468_i0 PRJNA540466 56017 252 2.340782 5.89877064 Mint vein banding-associated virus 265877 Viruses Viruses 62.8 3.69e-9   NR YP_009506335.1 265877 g55468 i0 57.1 0.583333333333333 49 21 58.3 0 2 148 1875 1923 YP_009506335.1 polyprotein [Mint vein banding-associated virus] diamond 147 62.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae Menthavirus Menthavirus menthae
32147610 32147610 PRJNA540466_S_NODE_32058_length_319_cov_1.735772_g31509_i0 PRJNA540466 32058 319 1.735772 5.53711268 Narnavirus 186767 Viruses Viruses 70.5 1.68e-11   NR WAK75248.1 2583949 g31509 i0 51.5 4.76802507836991 66 32 62.1 0 265 68 14 79 WAK75248.1 MAG: RNA-dependent RNA polymerase [Narnaviridae sp.] diamond 1521 71.2 0.990168539325843 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Narnaviridae 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);;