RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA814235", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

  • Duplornaviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA814235 · 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
13568836 13568836 PRJNA814235_P_NODE_109951_length_203_cov_2.072289_g108556_i0 PRJNA814235 109951 203 2.072289 4.20674667 Coltivirus dermacentoris 3428066 Viruses Viruses 108 3.72e-19   NTclustered gi|2758887253|gb|PP473574.1| 46839 g108556 i0 92.105 8.53694581280788 76 6 37 0 1 76 5000 5075 MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence blastn 1733 108 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales Spinareoviridae Coltivirus Coltivirus dermacentoris
27054514 27054514 PRJNA814235_P_NODE_91422_length_203_cov_3.150602_g90027_i0 PRJNA814235 91422 203 3.150602 6.39572206 Penicillium janczewskii chrysovirus 1 1755792 Viruses Viruses 58.9 4.33e-8   NR YP_009182332.1 1755792 g90027 i0 96 0.738916256157635 25 1 36.9 0 2 76 716 740 YP_009182332.1 127 kDa protein [Penicillium janczewskii chrysovirus 1] diamond 150 58.9 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Betachrysovirus Betachrysovirus pripenicillii
29959557 29959557 PRJNA814235_P_NODE_128491_length_197_cov_1.337500_g127096_i0 PRJNA814235 128491 197 1.3375 2.634875 Erysiphe necator associated chrysovirus 3 2742544 Viruses Viruses 61.6 4.44e-9   NR QKK35390.1 2742544 g127096 i0 41.5 0.989847715736041 65 38 99 0 195 1 824 888 QKK35390.1 capsid protein [Erysiphe necator associated chrysovirus 3] diamond 195 61.6 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Chrysovirus Erysiphe necator associated chrysovirus 3
30212240 30212240 PRJNA814235_P_NODE_56672_length_253_cov_1.625000_g55278_i0 PRJNA814235 56672 253 1.625 4.11125 Grapevine associated chrysovirus-1 908828 Viruses Viruses 142 5.17e-37   NR ADO60926.1 908828 g55278 i0 83.1 1.96837944664032 83 14 98.4 0 3 251 453 535 ADO60926.1 putative RNA-dependent RNA polymerase, partial [Grapevine associated chrysovirus-1] diamond 498 142 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Chrysoviridae Chrysovirus Grapevine associated chrysovirus-1
32393965 32393965 PRJNA814235_P_NODE_109759_length_203_cov_2.078313_g108364_i0 PRJNA814235 109759 203 2.078313 4.21897539 Erysiphe necator associated totivirus 7 2737097 Viruses Viruses 42.7 0.0223   NR QJW70338.1 2737097 g108364 i0 80 0.295566502463054 20 4 29.6 0 69 10 217 236 QJW70338.1 coat protein [Erysiphe necator associated totivirus 7] diamond 60 42.7 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Erysiphe necator associated totivirus 7

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