RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA385396 · 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
10611029 10611029 PRJNA385396_P_NODE_9409_length_291_cov_1.412844_g9317_i0 PRJNA385396 9409 291 1.412844 4.11137604 Poplar mosaic virus 12166 Viruses Viruses 156 7.089999999999998e-42   NR NP_958171.1 12166 g9317 i0 72.2 1 97 27 100 0 291 1 1289 1385 NP_958171.1 replicase [Poplar mosaic virus] diamond 291 156 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus populi
23358766 23358766 PRJNA385396_P_NODE_10399_length_280_cov_1.487923_g10307_i0 PRJNA385396 10399 280 1.487923 4.1661844 Poplar mosaic virus 12166 Viruses Viruses 175 1.48e-48   NR NP_958171.1 12166 g10307 i0 89.2 0.996428571428571 93 10 99.6 0 2 280 1744 1836 NP_958171.1 replicase [Poplar mosaic virus] diamond 279 175 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus populi
27833241 27833241 PRJNA385396_P_NODE_17504_length_246_cov_0.890173_g17412_i0 PRJNA385396 17504 246 0.890173 2.18982558 Fusarium culmorum narnavirus 1 3233852 Viruses Viruses 86.7 1.34e-17   NR XCO56019.1 3233852 g17412 i0 57.1 0.939024390243902 77 33 93.9 0 2 232 462 538 XCO56019.1 MAG: putative coat protein [Fusarium culmorum narnavirus 1] diamond 231 86.7 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales     Fusarium culmorum narnavirus 1
29128093 29128093 PRJNA385396_P_NODE_7409_length_319_cov_1.195122_g7317_i0 PRJNA385396 7409 319 1.195122 3.81243918 Fusarium culmorum narnavirus 1 3233852 Viruses Viruses 56.6 1.24e-6   NR XCO56019.1 3233852 g7317 i0 35.9 0.968652037617555 103 63 96.9 1 10 318 542 641 XCO56019.1 MAG: putative coat protein [Fusarium culmorum narnavirus 1] diamond 309 56.6 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales     Fusarium culmorum narnavirus 1
29744375 29744375 PRJNA385396_P_NODE_3430_length_417_cov_2.026163_g3338_i0 PRJNA385396 3430 417 2.026163 8.44909971 Chuvivirus 2842604 Viruses Viruses 182 2.2499999999999993e-52   NR WET19887.1 2842604 g3338 i0 63.8 1.98561151079137 138 50 99.3 0 414 1 243 380 WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] diamond 828 182 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
32003500 32003500 PRJNA385396_P_NODE_13018_length_253_cov_1.988889_g12926_i0 PRJNA385396 13018 253 1.988889 5.03188917 Poplar mosaic virus 12166 Viruses Viruses 130 1.39e-34   NR NP_958175.1 12166 g12926 i0 78.6 1.99209486166008 84 18 99.6 0 2 253 42 125 NP_958175.1 viral coat protein [Poplar mosaic virus] diamond 504 130 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus populi

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