RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240804 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26978616 26978616 PRJNA1240804_P_NODE_99302_length_174_cov_1.136000_g98936_i0 PRJNA1240804 99302 174 1.136 1.97664 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 127 3.0299999999999996e-32   NR CAI9858973.1 3048756 g98936 i0 98.2 0.982758620689655 57 1 98.3 0 3 173 343 399 CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] diamond 171 127 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
28368218 28368218 PRJNA1240804_P_NODE_121486_length_167_cov_0.881356_g121120_i0 PRJNA1240804 121486 167 0.881356 1.47186452 Malassezia restricta virus MrV4 76775 Viruses Viruses 77.4 7.93e-15   NR QJA42330.1 2727863 g121120 i0 76.6 1.68862275449102 47 11 84.4 0 9 149 1 47 QJA42330.1 capsid protein [Malassezia restricta virus MrV40L] diamond 282 77.4 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
29031642 29031642 PRJNA1240804_P_NODE_144128_length_163_cov_0.912281_g143762_i0 PRJNA1240804 144128 163 0.912281 1.48701803 Totivirus sp. 2776824 Viruses Viruses 67 1.23e-11   NR QOQ37359.1 2776824 g143762 i0 75 2.42944785276074 44 11 81 0 32 163 21 64 QOQ37359.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] diamond 396 67 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Totivirus sp.
31400881 31400881 PRJNA1240804_P_NODE_141096_length_163_cov_1.403509_g140730_i0 PRJNA1240804 141096 163 1.403509 2.28771967 Erysiphe necator associated totivirus 4 2737094 Viruses Viruses 57.8 6.3e-8   NR QJW70332.1 2737094 g140730 i0 100 0.552147239263804 30 0 55.2 0 114 25 89 118 QJW70332.1 coat protein [Erysiphe necator associated totivirus 4] diamond 90 57.8 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Erysiphe necator associated totivirus 4
32064987 32064987 PRJNA1240804_P_NODE_91438_length_179_cov_1.176923_g91072_i0 PRJNA1240804 91438 179 1.176923 2.10669217 Aspergillus terreus chrysovirus 1 3064026 Viruses Viruses 68.2 1.7e-11   NR WKU83718.1 3064026 g91072 i0 94.3 0.58659217877095 35 2 58.7 0 109 5 427 461 WKU83718.1 RNA-dependent RNA polymerase [Aspergillus terreus chrysovirus 1] diamond 105 68.2 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Alphachrysovirus Aspergillus terreus chrysovirus 1

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