RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 13 ✖

bioproject 1

  • PRJNA280983 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
26915897 26915897 PRJNA280983_P_NODE_4522_length_308_cov_2.142857_g4407_i0 PRJNA280983 4522 308 2.142857 6.59999956 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 124 1.87e-30   NR XCM67741.1 3003959 g4407 i0 61.3 0.905844155844156 93 33 90.6 1 301 23 1709 1798 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 279 124 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27453539 27453539 PRJNA280983_P_NODE_10743_length_163_cov_1.789474_g10628_i0 PRJNA280983 10743 163 1.789474 2.91684262 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 57 1.19e-7   NR XCM68142.1 3003959 g10628 i0 51.9 0.993865030674847 54 26 99.4 0 163 2 147 200 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 162 57 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27579565 27579565 PRJNA280983_P_NODE_11044_length_162_cov_0.902655_g10929_i0 PRJNA280983 11044 162 0.902655 1.4623011 Helianthus annuus leaf-associated totivirus 6 2883720 Viruses Viruses 50.4 2.32e-5   NR UMQ74227.1 2883720 g10929 i0 55.3 2.7037037037037 47 21 87 0 11 151 77 123 UMQ74227.1 capsid protein [Helianthus annuus leaf-associated totivirus 6] diamond 438 50.4 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Helianthus annuus leaf-associated totivirus 6
27674560 27674560 PRJNA280983_P_NODE_44_length_2369_cov_8.143966_g30_i0 PRJNA280983 44 2369 8.143966 192.93055454 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 703 2.0099999999999994e-222   NR UNY41988.1 3003959 g30 i0 52.7 0.845926551287463 668 301 83.5 8 2367 391 2277 2938 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 2004 703 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27706313 27706313 PRJNA280983_P_NODE_3804_length_345_cov_1.260135_g3689_i0 PRJNA280983 3804 345 1.260135 4.34746575 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 166 8.289999999999999e-45   NR XCM68142.1 3003959 g3689 i0 70.8 1.96521739130435 113 33 98.3 0 3 341 1422 1534 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 678 166 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29063739 29063739 PRJNA280983_P_NODE_7708_length_204_cov_1.129032_g7593_i0 PRJNA280983 7708 204 1.129032 2.30322528 Erysiphales associated totivirus 6 2719858 Viruses Viruses 58.9 4.48e-8   NR QIP68055.1 2719858 g7593 i0 43.1 0.75 51 29 75 0 52 204 67 117 QIP68055.1 coat protein [Erysiphales associated totivirus 6] diamond 153 58.9 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Erysiphales associated totivirus 6
29410811 29410811 PRJNA280983_P_NODE_3509_length_362_cov_6.361022_g3394_i0 PRJNA280983 3509 362 6.361022 23.02689964 Austropuccinia psidii associated totivirus 2 3367766 Viruses Viruses 135 3.22e-34   NR XHV16799.1 3367766 g3394 i0 59.4 0.878453038674033 106 43 87.8 0 348 31 33 138 XHV16799.1 RNA-dependent RNA polymerase, partial [Austropuccinia psidii associated totivirus 2] diamond 318 135 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Austropuccinia psidii associated totivirus 2
29631645 29631645 PRJNA280983_P_NODE_2070_length_503_cov_1.808370_g1957_i0 PRJNA280983 2070 503 1.80837 9.0961011 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 191 1.2099999999999997e-52   NR XCM68142.1 3003959 g1957 i0 56.5 0.960238568588469 161 69 96 1 503 21 876 1035 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 483 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30484911 30484911 PRJNA280983_P_NODE_10293_length_165_cov_0.879310_g10178_i0 PRJNA280983 10293 165 0.87931 1.4508615 Totiviridae sp. 1955172 Viruses Viruses 93.2 2.14e-20   NR UHS72436.1 1955172 g10178 i0 75.9 0.981818181818182 54 13 98.2 0 163 2 458 511 UHS72436.1 MAG: putative RNA-dependent RNA polymerase [Totiviridae sp.] diamond 162 93.2 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
30818479 30818479 PRJNA280983_P_NODE_714_length_884_cov_1.616766_g628_i0 PRJNA280983 714 884 1.616766 14.29221144 Viruses 10239 Viruses Viruses 55.5 6.41e-5   NR WWV86444.1 1955170 g628 i0 25.1 1.91402714932127 183 105 56 7 189 683 28 196 WWV86444.1 MAG: hypothetical protein [Partitiviridae sp.] diamond 1692 55.5 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
30895742 30895742 PRJNA280983_P_NODE_1294_length_651_cov_8.425249_g1189_i0 PRJNA280983 1294 651 8.425249 54.84837099 Qianjiang noda-like virus 31 3348615 Viruses Viruses 302 1e-91   NR XHA85951.1 3348615 g1189 i0 65.7 0.981566820276498 213 73 98.2 0 639 1 92 304 XHA85951.1 MAG: polyprotein [Qianjiang noda-like virus 31] diamond 639 302 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae   Qianjiang noda-like virus 31
32223925 32223925 PRJNA280983_P_NODE_7438_length_210_cov_1.826087_g7323_i0 PRJNA280983 7438 210 1.826087 3.8347827 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 54.7 1.55e-6   NR XCM67741.1 3003959 g7323 i0 42.6 1.78571428571429 68 39 97.1 0 210 7 1318 1385 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 375 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32382086 32382086 PRJNA280983_P_NODE_8839_length_183_cov_0.828358_g8724_i0 PRJNA280983 8839 183 0.828358 1.51589514 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 108 1.09e-25   NR XCM68142.1 3003959 g8724 i0 81.7 0.983606557377049 60 11 98.4 0 181 2 1331 1390 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 180 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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