RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA495391" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJNA495391 · 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
27614230 27614230 PRJNA495391_S_NODE_50364_length_174_cov_2.007194_g49312_i0 PRJNA495391 50364 174 2.007194 3.49251756 Erysiphe necator associated flexivirus 3 2743100 Viruses Viruses 123 7.019999999999999e-31   NR QKN22675.1 2743100 g49312 i0 96.5 0.982758620689655 57 2 98.3 0 3 173 1751 1807 QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] diamond 171 123 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales     Erysiphe necator associated flexivirus 3
28340258 28340258 PRJNA495391_S_NODE_21886_length_256_cov_3.909502_g20834_i0 PRJNA495391 21886 256 3.909502 10.00832512 Plasmopara viticola lesion associated Partitivirus 9 2692007 Viruses Viruses 139 1.82e-36   NR QHD64805.1 2692007 g20834 i0 74.1 1.9921875 85 22 99.6 0 256 2 156 240 QHD64805.1 coat protein [Plasmopara viticola lesion associated Partitivirus 9] diamond 510 139 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Plasmopara viticola lesion associated Partitivirus 9
30740423 30740423 PRJNA495391_S_NODE_15014_length_309_cov_1.901460_g13962_i0 PRJNA495391 15014 309 1.90146 5.8755114 Malassezia restricta associated totivirus 1 3048757 Viruses Viruses 173 2.41e-48   NR CAI9858976.1 3048757 g13962 i0 87.5 0.932038834951456 96 12 93.2 0 308 21 595 690 CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] diamond 288 173 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia restricta associated totivirus 1
31277576 31277576 PRJNA495391_S_NODE_1235_length_1430_cov_4.279570_g524_i0 PRJNA495391 1235 1430 4.27957 61.197851 Malassezia restricta associated totivirus 1 3048757 Viruses Viruses 707 1.3899999999999998e-249   NR CAI9858976.1 3048757 g524 i0 91 0.795104895104895 379 34 79.5 0 6 1142 312 690 CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] diamond 1137 707 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia restricta associated totivirus 1
31562566 31562566 PRJNA495391_S_NODE_32336_length_214_cov_1.391061_g31284_i0 PRJNA495391 32336 214 1.391061 2.97687054 Malassezia restricta associated totivirus 1 3048757 Viruses Viruses 146 6.4e-39   NR CAI9858976.1 3048757 g31284 i0 94.4 0.995327102803738 71 4 99.5 0 214 2 390 460 CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] diamond 213 146 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia restricta associated totivirus 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);;