contig_metadata
14 rows where analysis = "diamond" and tax_clade = "dsRNA viruses"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27454285 | 27454285 | PRJNA358049_S_NODE_18823_length_160_cov_2.324324_g18775_i0 | PRJNA358049 | 18823 | 160 | 2.324324 | 3.7189184 | Gremmeniella abietina RNA virus 6 | 1565456 | Viruses | Viruses | 59.7 | 1.26e-8 | NR | AIU98624.1 | 1565456 | g18775 | i0 | 60.4 | 0.9 | 48 | 17 | 88.1 | 2 | 160 | 20 | 469 | 515 | AIU98624.1 RNA-dependent RNA polymerase [Gremmeniella abietina RNA virus 6] | diamond | 144 | 59.7 | 1 | Viruses | dsRNA viruses | Gremmeniella abietina RNA virus 6 | |||||||
| 27738838 | 27738838 | PRJNA382357_P_NODE_70544_length_282_cov_1.176471_g69805_i0 | PRJNA382357 | 70544 | 282 | 1.176471 | 3.31764822 | Sclerotinia sclerotiorum double-stranded RNA virus 3 | 1848505 | Viruses | Viruses | 46.2 | 0.00373 | NR | AND83002.1 | 1848505 | g69805 | i0 | 37.8 | 1.82978723404255 | 90 | 56 | 95.7 | 0 | 273 | 4 | 593 | 682 | AND83002.1 RNA-dependent RNA polymerase [Sclerotinia sclerotiorum double-stranded RNA virus 3] | diamond | 516 | 46.2 | 1 | Viruses | dsRNA viruses | Sclerotinia sclerotiorum double-stranded RNA virus 3 | |||||||
| 28041185 | 28041185 | PRJNA643700_P_NODE_379685_length_172_cov_1.268293_g378129_i0 | PRJNA643700 | 379685 | 172 | 1.268293 | 2.18146396 | Unirnavirus | 3424976 | Viruses | Viruses | 78.6 | 3.38e-15 | NR | YP_009052469.1 | 1532031 | g378129 | i0 | 66.7 | 3 | 57 | 19 | 99.4 | 0 | 172 | 2 | 174 | 230 | YP_009052469.1 RNA-dependent RNA polymerase [Alternaria longipes dsRNA virus 1] | diamond | 516 | 78.6 | 1 | Viruses | dsRNA viruses | Alternaria longipes dsRNA virus 1 | |||||||
| 29413576 | 29413576 | PRJNA493827_P_NODE_72709_length_406_cov_2.384384_g70512_i0 | PRJNA493827 | 72709 | 406 | 2.384384 | 9.68059904 | Bremia lactucae associated fusagravirus 1 | 2719799 | Viruses | Viruses | 66.2 | 1.39e-9 | NR | QIP68010.1 | 2719799 | g70512 | i0 | 32.3 | 0.960591133004926 | 130 | 83 | 95.3 | 3 | 3 | 389 | 567 | 692 | QIP68010.1 MAG: ORF2 [Bremia lactucae associated fusagravirus 1] | diamond | 390 | 66.2 | 1 | Viruses | dsRNA viruses | Bremia lactucae associated fusagravirus 1 | |||||||
| 29460980 | 29460980 | PRJNA556992_P_NODE_880870_length_242_cov_0.911243_g878680_i0 | PRJNA556992 | 880870 | 242 | 0.911243 | 2.20520806 | Viruses | 10239 | Viruses | Viruses | 57.8 | 1.86e-7 | NR | YP_009551504.1 | 1678177 | g878680 | i0 | 49.1 | 2.1198347107438 | 55 | 26 | 68.2 | 1 | 222 | 58 | 390 | 442 | YP_009551504.1 RNA dependent RNA polymerase [Diatom colony associated dsRNA virus 17 genome type A] | diamond | 513 | 57.8 | 1 | Viruses | dsRNA viruses | Diatom colony associated dsRNA virus 17 genome type A | |||||||
| 29829999 | 29829999 | PRJNA702290_P_NODE_951_length_191_cov_9.401316_g943_i0 | PRJNA702290 | 951 | 191 | 9.401316 | 17.95651356 | Trichoderma harzianum dsRNA virus 3 | 3032470 | Viruses | Viruses | 48.5 | 1.72e-4 | NR | WGH72980.1 | 3032470 | g943 | i0 | 83.3 | 0.37696335078534 | 24 | 4 | 37.7 | 0 | 3 | 74 | 269 | 292 | WGH72980.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma harzianum dsRNA virus 3] | diamond | 72 | 48.5 | 1 | Viruses | dsRNA viruses | Trichoderma harzianum dsRNA virus 3 | |||||||
| 30365503 | 30365503 | PRJNA630162_P_NODE_32792_length_314_cov_2.543396_g31270_i0 | PRJNA630162 | 32792 | 314 | 2.543396 | 7.98626344 | Corynespora cassiicola bipartite mycovirus 1 | 2762594 | Viruses | Viruses | 51.2 | 8.85e-5 | NR | QNC69629.1 | 2762594 | g31270 | i0 | 36.3 | 2.60828025477707 | 91 | 51 | 86 | 4 | 41 | 310 | 218 | 302 | QNC69629.1 putative RNA-dependent RNA polymerase [Corynespora cassiicola bipartite mycovirus 1] | diamond | 819 | 51.2 | 1 | Viruses | dsRNA viruses | Corynespora cassiicola bipartite mycovirus 1 | |||||||
| 30755535 | 30755535 | PRJNA358049_S_NODE_8474_length_217_cov_1.232143_g8426_i0 | PRJNA358049 | 8474 | 217 | 1.232143 | 2.67375031 | Viruses | 10239 | Viruses | Viruses | 101 | 4.579999999999999e-23 | NR | AIU98624.1 | 1565456 | g8426 | i0 | 65.2 | 2.91705069124424 | 69 | 24 | 95.4 | 0 | 3 | 209 | 352 | 420 | AIU98624.1 RNA-dependent RNA polymerase [Gremmeniella abietina RNA virus 6] | diamond | 633 | 102 | 0.990196078431373 | Viruses | dsRNA viruses | Gremmeniella abietina RNA virus 6 | |||||||
| 30818684 | 30818684 | PRJNA356682_P_NODE_28414_length_278_cov_1.307317_g27723_i0 | PRJNA356682 | 28414 | 278 | 1.307317 | 3.63434126 | Botybirnavirus | 1918013 | Viruses | Viruses | 61.2 | 1.81e-8 | NR | AZF86106.1 | 1908387 | g27723 | i0 | 39.2 | 3.39928057553957 | 79 | 48 | 85.3 | 0 | 9 | 245 | 842 | 920 | AZF86106.1 RNA-dependent RNA polymerase, partial [Sclerotium rolfsii mycovirus dsRNA 1] | diamond | 945 | 61.6 | 0.993506493506494 | Viruses | dsRNA viruses | Sclerotium rolfsii mycovirus dsRNA 1 | |||||||
| 31660827 | 31660827 | PRJNA630162_P_NODE_26257_length_356_cov_2.488599_g24736_i0 | PRJNA630162 | 26257 | 356 | 2.488599 | 8.85941244 | Ustilaginoidea virens nonsegmented virus 2 | 2305465 | Viruses | Viruses | 70.9 | 1.93e-11 | NR | YP_009553680.1 | 2305465 | g24736 | i0 | 41.2 | 2.88202247191011 | 114 | 66 | 96.1 | 1 | 15 | 356 | 24 | 136 | YP_009553680.1 fusion protein [Ustilaginoidea virens nonsegmented virus 2] | diamond | 1026 | 70.9 | 1 | Viruses | dsRNA viruses | Ustilaginoidea virens nonsegmented virus 2 | |||||||
| 32229861 | 32229861 | PRJNA600413_P_NODE_94698_length_171_cov_1.401639_g93997_i0 | PRJNA600413 | 94698 | 171 | 1.401639 | 2.39680269 | Rhizoctonia solani dsRNA virus 18 | 2838383 | Viruses | Viruses | 77.4 | 8.28e-15 | NR | UIW13809.1 | 2838383 | g93997 | i0 | 58.9 | 0.982456140350877 | 56 | 23 | 98.2 | 0 | 2 | 169 | 104 | 159 | UIW13809.1 MAG: RNA-dependent RNA polymerase [Rhizoctonia solani dsRNA virus 18] | diamond | 168 | 77.4 | 1 | Viruses | dsRNA viruses | Rhizoctonia solani dsRNA virus 18 | |||||||
| 32514709 | 32514709 | PRJNA600413_P_NODE_150519_length_161_cov_0.910714_g149818_i0 | PRJNA600413 | 150519 | 161 | 0.910714 | 1.46624954 | Rhizoctonia solani dsRNA virus 16 | 2838381 | Viruses | Viruses | 60.8 | 4.33e-9 | NR | UIW13807.1 | 2838381 | g149818 | i0 | 53.1 | 0.91304347826087 | 49 | 23 | 91.3 | 0 | 156 | 10 | 254 | 302 | UIW13807.1 MAG: RNA-dependent RNA polymerase, partial [Rhizoctonia solani dsRNA virus 16] | diamond | 147 | 60.8 | 1 | Viruses | dsRNA viruses | Rhizoctonia solani dsRNA virus 16 | |||||||
| 32978790 | 32978790 | PRJEB14175_P_NODE_80275_length_407_cov_14.303468_g78013_i0 | PRJEB14175 | 80275 | 407 | 14.303468 | 58.21511476 | Ustilaginoidea virens unassigned RNA virus HNND-1 | 1670975 | Viruses | Viruses | 222 | 1.84e-67 | NR | YP_009154709.1 | 1670975 | g78013 | i0 | 82.5 | 0.928746928746929 | 126 | 22 | 92.9 | 0 | 400 | 23 | 64 | 189 | YP_009154709.1 RNA-dependent RNA polymerase [Ustilaginoidea virens unassigned RNA virus HNND-1] | diamond | 378 | 222 | 1 | Viruses | dsRNA viruses | Ustilaginoidea virens unassigned RNA virus HNND-1 | |||||||
| 33178895 | 33178895 | PRJEB14175_P_NODE_58568_length_485_cov_10.429245_g56315_i0 | PRJEB14175 | 58568 | 485 | 10.429245 | 50.58183825 | Polymycovirus | 2733294 | Viruses | Viruses | 55.1 | 2.16e-5 | NR | AWY10947.1 | 2231775 | g56315 | i0 | 31.4 | 1.37938144329897 | 121 | 81 | 74.8 | 2 | 101 | 463 | 346 | 464 | AWY10947.1 methyltransferase [Sclerotinia sclerotiorum tetramycovirus-1] | diamond | 669 | 55.1 | 1 | Viruses | dsRNA viruses | Sclerotinia sclerotiorum tetramycovirus-1 |
Advanced export
JSON shape: default, array, newline-delimited
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);;