RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1047551" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1047551 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
26686946 26686946 PRJNA1047551_S_NODE_3521_length_249_cov_1.878505_g3394_i0 PRJNA1047551 3521 249 1.878505 4.67747745 Downy mildew lesion associated splipalmivirus 1 2719492 Viruses Viruses 95.9 4.0900000000000002e-22   NR WNA22205.1 2719492 g3394 i0 90 0.602409638554217 50 5 60.2 0 242 93 189 238 WNA22205.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 1] diamond 150 95.9 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Downy mildew lesion associated splipalmivirus 1
28488136 28488136 PRJNA1047551_S_NODE_4867_length_218_cov_2.316940_g4740_i0 PRJNA1047551 4867 218 2.3169400000000002 5.0509292 Sophora japonica powdery mildew-associated partitivirus 1891704 Viruses Viruses 61.2 7.97e-9   NR YP_009272945.1 1891704 g4740 i0 78.4 0.509174311926605 37 8 50.9 0 217 107 491 527 YP_009272945.1 putative coat protein [Sophora japonica powdery mildew-associated partitivirus] diamond 111 61.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Sophora japonica powdery mildew-associated partitivirus
31678621 31678621 PRJNA1047551_S_NODE_13337_length_151_cov_2.465517_g13210_i0 PRJNA1047551 13337 151 2.465517 3.72293067 Totivirus sp. 2776824 Viruses Viruses 108 1.1e-27   NR QOQ37363.1 2776824 g13210 i0 98 0.973509933774834 49 1 97.4 0 3 149 131 179 QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] diamond 147 108 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Totivirus sp.
32564932 32564932 PRJNA1047551_S_NODE_9459_length_171_cov_2.132353_g9332_i0 PRJNA1047551 9459 171 2.132353 3.64632363 Grapevine alphapartitivirus 3113821 Viruses Viruses 80.9 4.77e-16   NR WRQ19776.1 3113821 g9332 i0 68.5 0.947368421052632 54 17 94.7 0 8 169 383 436 WRQ19776.1 MAG: coat protein [Grapevine alphapartitivirus] diamond 162 80.9 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Grapevine alphapartitivirus

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