RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA505329" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA505329 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
28561534 28561534 PRJNA505329_P_NODE_45247_length_166_cov_1.461538_g44776_i0 PRJNA505329 45247 166 1.461538 2.42615308 Totivirus sp. 2776824 Viruses Viruses 92.4 3.11e-20   NR QOQ37362.1 2776824 g44776 i0 72.7 1.98795180722892 55 15 99.4 0 165 1 320 374 QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] diamond 330 92.4 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Totivirus sp.
29413789 29413789 PRJNA505329_P_NODE_16549_length_233_cov_0.983696_g16078_i0 PRJNA505329 16549 233 0.983696 2.29201168 Malassezia restricta associated totivirus 1 3048757 Viruses Viruses 139 1.87e-36   NR CAI9858976.1 3048757 g16078 i0 94.7 0.978540772532189 76 4 97.9 0 228 1 536 611 CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] diamond 228 139 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia restricta associated totivirus 1
29919256 29919256 PRJNA505329_P_NODE_11311_length_233_cov_3.521739_g10840_i0 PRJNA505329 11311 233 3.521739 8.20565187 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 44.7 0.00687   NR CAI9858974.1 3048756 g10840 i0 64.5 1.19742489270386 31 11 39.9 0 4 96 49 79 CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] diamond 279 44.7 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
30060786 30060786 PRJNA505329_P_NODE_13391_length_233_cov_2.788043_g12920_i0 PRJNA505329 13391 233 2.788043 6.49614019 Ghabrivirales 2732540 Viruses Viruses 52.8 9.61e-6   NR WAK77685.1 1955172 g12920 i0 59.4 2.47210300429185 32 13 41.2 0 137 232 316 347 WAK77685.1 MAG: polyprotein [Totiviridae sp.] diamond 576 52.8 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
32052418 32052418 PRJNA505329_P_NODE_25818_length_193_cov_2.812500_g25347_i0 PRJNA505329 25818 193 2.8125 5.428125 Ghabrivirales 2732540 Viruses Viruses 112 4.7100000000000006e-27   NR WAK77449.1 1955172 g25347 i0 77.8 8.81347150259067 63 14 97.9 0 3 191 311 373 WAK77449.1 MAG: polyprotein, partial [Totiviridae sp.] diamond 1701 112 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
32543419 32543419 PRJNA505329_P_NODE_33879_length_181_cov_2.340909_g33408_i0 PRJNA505329 33879 181 2.340909 4.23704529 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 113 1.89e-27   NR CAI9858973.1 3048756 g33408 i0 91.5 0.977900552486188 59 5 97.8 0 180 4 85 143 CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] diamond 177 113 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa 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);;