contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_superkingdom = "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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12678372 | 12678372 | PRJNA745553_S_NODE_6930_length_449_cov_1.045213_g6736_i0 | PRJNA745553 | 6930 | 449 | 1.045213 | 4.69300637 | Dothistroma septosporum bunya-like virus 4 | 3104557 | Viruses | Viruses | 149 | 7.22e-41 | NR | WPV70723.1 | 3104557 | g6736 | i0 | 66.4 | 0.855233853006682 | 128 | 39 | 83.5 | 2 | 72 | 446 | 1 | 127 | WPV70723.1 MAG: nonstructural protein [Dothistroma septosporum bunya-like virus 4] | diamond | 384 | 149 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Dothistroma septosporum bunya-like virus 4 | ||||
| 16027049 | 16027049 | PRJNA745553_S_NODE_7633_length_431_cov_2.642458_g7438_i0 | PRJNA745553 | 7633 | 431 | 2.642458 | 11.38899398 | Streptophyte associated narna-like virus 9 | 3067074 | Viruses | Viruses | 115 | 5.550000000000001e-27 | NR | WPR17282.1 | 3067074 | g7438 | i0 | 79.5 | 1.00232018561485 | 73 | 14 | 50.8 | 1 | 2 | 220 | 491 | 562 | WPR17282.1 MAG: RNA-dependent RNA polymerase, partial [Streptophyte associated narna-like virus 9] | diamond | 432 | 115 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Streptophyte associated narna-like virus 9 | |||
| 26863272 | 26863272 | PRJNA745553_S_NODE_4201_length_533_cov_2.904348_g4011_i0 | PRJNA745553 | 4201 | 533 | 2.904348 | 15.48017484 | Cryphonectria naterciae splipalmivirus 1 | 2841740 | Viruses | Viruses | 52 | 1.46e-4 | NR | BCX55512.1 | 2841740 | g4011 | i0 | 32 | 0.579737335834897 | 103 | 67 | 56.3 | 1 | 480 | 181 | 78 | 180 | BCX55512.1 hypothetical protein 2 [Cryphonectria naterciae splipalmivirus 1] | diamond | 309 | 52 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus cryphonectriae | ||
| 27242326 | 27242326 | PRJNA745553_S_NODE_13463_length_335_cov_2.858779_g13268_i0 | PRJNA745553 | 13463 | 335 | 2.858779 | 9.57690965 | Phytophthora cinnamomi ormycovirus 11-3 | 3239320 | Viruses | Viruses | 163 | 5.84e-44 | NR | XDO01629.1 | 3239320 | g13268 | i0 | 67 | 1.96119402985075 | 109 | 36 | 97.6 | 0 | 332 | 6 | 438 | 546 | XDO01629.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 11-3] | diamond | 657 | 163 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Alphaormycoviridae | Phormycovirus | Phormycovirus quaphytophthorae | |||
| 27369165 | 27369165 | PRJNA745553_S_NODE_25023_length_248_cov_1.760000_g24828_i0 | PRJNA745553 | 25023 | 248 | 1.76 | 4.3648 | Sclerotinia sclerotiorum fusarivirus 2 | 2822941 | Viruses | Viruses | 171 | 3.839999999999999e-47 | NR | QUE49153.1 | 2822941 | g24828 | i0 | 97.6 | 5.95161290322581 | 82 | 2 | 99.2 | 0 | 248 | 3 | 627 | 708 | QUE49153.1 MAG: polyprotein [Sclerotinia sclerotiorum fusarivirus 2] | diamond | 1476 | 171 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Sclerotinia sclerotiorum fusarivirus 2 | |||
| 27495170 | 27495170 | PRJNA745553_S_NODE_11303_length_364_cov_3.295533_g11108_i0 | PRJNA745553 | 11303 | 364 | 3.295533 | 11.99574012 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 132 | 4.85e-33 | NR | XOE97085.1 | 2832643 | g11108 | i0 | 61.5 | 0.857142857142857 | 104 | 36 | 85.7 | 2 | 322 | 11 | 464 | 563 | XOE97085.1 MAG: DNA polymerase [Caudoviricetes sp.] | diamond | 312 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27495173 | 27495173 | PRJNA745553_S_NODE_20183_length_275_cov_3.237624_g19988_i0 | PRJNA745553 | 20183 | 275 | 3.237624 | 8.903466 | Black raspberry virus F | 463392 | Viruses | Viruses | 130 | 1.0799999999999999e-32 | NR | YP_001497151.1 | 463392 | g19988 | i0 | 71.1 | 0.905454545454545 | 83 | 24 | 90.5 | 0 | 24 | 272 | 7 | 89 | YP_001497151.1 RNA-dependent RNA polymerase [Black raspberry virus F] | diamond | 249 | 130 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Black raspberry virus F | ||
| 27694827 | 27694827 | PRJNA745553_S_NODE_12384_length_349_cov_1.394928_g12189_i0 | PRJNA745553 | 12384 | 349 | 1.394928 | 4.86829872 | Ghabrivirales | 2732540 | Viruses | Viruses | 81.3 | 3.98e-15 | NR | WAK77569.1 | 1955172 | g12189 | i0 | 38.9 | 1.92550143266476 | 113 | 64 | 94.6 | 2 | 16 | 345 | 123 | 233 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 672 | 81.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 27873998 | 27873998 | PRJNA745553_S_NODE_12165_length_351_cov_20.323741_g11970_i0 | PRJNA745553 | 12165 | 351 | 20.323741 | 71.33633091 | Riboviria sp. | 2585031 | Viruses | Viruses | 117 | 1.8099999999999999e-28 | NR | WWV90559.1 | 2585031 | g11970 | i0 | 52.5 | 0.846153846153846 | 99 | 46 | 84.6 | 1 | 297 | 1 | 12 | 109 | WWV90559.1 MAG: RNA polymerase, partial [Riboviria sp.] | diamond | 297 | 117 | 1 | Viruses | Riboviria sp. | ||||||||
| 28316115 | 28316115 | PRJNA745553_S_NODE_20186_length_275_cov_3.049505_g19991_i0 | PRJNA745553 | 20186 | 275 | 3.049505 | 8.38613875 | Plasmopara viticola lesion associated ourmia-like virus 19 | 2686486 | Viruses | Viruses | 98.6 | 1.2600000000000002e-21 | NR | YP_010800219.1 | 2686486 | g19991 | i0 | 50.5 | 0.992727272727273 | 91 | 45 | 99.3 | 0 | 274 | 2 | 1 | 91 | YP_010800219.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 19] | diamond | 273 | 98.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus omicronplasmoparae | ||
| 28410882 | 28410882 | PRJNA745553_S_NODE_13986_length_329_cov_2.046875_g13791_i0 | PRJNA745553 | 13986 | 329 | 2.046875 | 6.73421875 | Dothistroma septosporum bunya-like virus 4 | 3104557 | Viruses | Viruses | 196 | 5.079999999999999e-60 | NR | WPV70723.1 | 3104557 | g13791 | i0 | 86.9 | 0.975683890577508 | 107 | 14 | 97.6 | 0 | 7 | 327 | 120 | 226 | WPV70723.1 MAG: nonstructural protein [Dothistroma septosporum bunya-like virus 4] | diamond | 321 | 196 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Dothistroma septosporum bunya-like virus 4 | ||||
| 28695143 | 28695143 | PRJNA745553_S_NODE_19467_length_280_cov_5.830918_g19272_i0 | PRJNA745553 | 19467 | 280 | 5.830918 | 16.3265704 | Dishui Lake large algae virus 1 | 2704073 | Viruses | Viruses | 57.4 | 4.11e-7 | NR | QIG60031.1 | 2704073 | g19272 | i0 | 52.9 | 0.546428571428571 | 51 | 24 | 54.6 | 0 | 11 | 163 | 582 | 632 | QIG60031.1 transposase [Dishui Lake large algae virus 1] | diamond | 153 | 57.4 | 1 | Viruses | Dishui Lake large algae virus 1 | ||||||||
| 28820951 | 28820951 | PRJNA745553_S_NODE_26528_length_242_cov_1.366864_g26333_i0 | PRJNA745553 | 26528 | 242 | 1.366864 | 3.30781088 | Grapevine associated cogu-like virus 2 | 2716184 | Viruses | Viruses | 86.7 | 1.31e-17 | NR | YP_010840131.1 | 2716184 | g26333 | i0 | 58.8 | 1.98347107438017 | 80 | 33 | 99.2 | 0 | 1 | 240 | 465 | 544 | YP_010840131.1 P1 [Grapevine associated cogu-like virus 2] | diamond | 480 | 86.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Laulavirus | Laulavirus alphaviticulum | ||
| 28947822 | 28947822 | PRJNA745553_S_NODE_8448_length_413_cov_5.267647_g8253_i0 | PRJNA745553 | 8448 | 413 | 5.267647 | 21.75538211 | Jiangsu sediment virgavirus | 2824508 | Viruses | Viruses | 53.1 | 5.22e-5 | NR | QYW08465.1 | 2824508 | g8253 | i0 | 47.5 | 1.31476997578692 | 61 | 27 | 44.3 | 2 | 1 | 183 | 504 | 559 | QYW08465.1 MAG: putative replicase, partial [Jiangsu sediment virgavirus] | diamond | 543 | 53.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Jiangsu sediment virgavirus | |||
| 29641831 | 29641831 | PRJNA745553_S_NODE_12750_length_344_cov_4.055351_g12555_i0 | PRJNA745553 | 12750 | 344 | 4.055351 | 13.95040744 | Riboviria sp. | 2585031 | Viruses | Viruses | 146 | 2.2e-39 | NR | UGO57614.1 | 2585031 | g12555 | i0 | 61.5 | 0.906976744186046 | 104 | 40 | 90.7 | 0 | 323 | 12 | 149 | 252 | UGO57614.1 MAG: hypothetical protein, partial [Riboviria sp.] | diamond | 312 | 146 | 1 | Viruses | Riboviria sp. | ||||||||
| 29957933 | 29957933 | PRJNA745553_S_NODE_9411_length_394_cov_7.722741_g9216_i0 | PRJNA745553 | 9411 | 394 | 7.722741 | 30.42759954 | Sylvanvirus sp. | 2487774 | Viruses | Viruses | 75.1 | 3.88e-13 | NR | AYV87038.1 | 2487774 | g9216 | i0 | 48.8 | 0.654822335025381 | 86 | 44 | 65.5 | 0 | 386 | 129 | 205 | 290 | AYV87038.1 MAG: syntaxin-2 isoform X3 [Sylvanvirus sp.] | diamond | 258 | 75.1 | 1 | Viruses | Sylvanvirus sp. | ||||||||
| 30084219 | 30084219 | PRJNA745553_S_NODE_13312_length_337_cov_3.939394_g13117_i0 | PRJNA745553 | 13312 | 337 | 3.939394 | 13.27575778 | Betapolyomavirus macacae | 1891767 | Viruses | Viruses | 54.7 | 6.95e-6 | NR | AAK29054.1 | 1891767 | g13117 | i0 | 78.1 | 0.28486646884273 | 32 | 7 | 28.5 | 0 | 103 | 8 | 506 | 537 | AAK29054.1 truncated large tumor antigen [Betapolyomavirus macacae] | diamond | 96 | 54.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 30274206 | 30274206 | PRJNA745553_S_NODE_16052_length_308_cov_2.025532_g15857_i0 | PRJNA745553 | 16052 | 308 | 2.025532 | 6.23863856 | Oidiodendron maius splipalmivirus 1 | 2769353 | Viruses | Viruses | 93.2 | 1.51e-19 | NR | UJT31791.1 | 2769353 | g15857 | i0 | 55.8 | 0.925324675324675 | 95 | 42 | 92.5 | 0 | 288 | 4 | 1 | 95 | UJT31791.1 hypothetical protein [Oidiodendron maius splipalmivirus 1] | diamond | 285 | 93.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Delepalmivirus | Delepalmivirus oidiodendri | ||
| 30536639 | 30536639 | PRJNA745553_S_NODE_21653_length_266_cov_1.590674_g21458_i0 | PRJNA745553 | 21653 | 266 | 1.590674 | 4.23119284 | Phormycovirus | 3424975 | Viruses | Viruses | 85.5 | 4.54e-17 | NR | XDO01629.1 | 3239320 | g21458 | i0 | 46.1 | 1.99624060150376 | 89 | 47 | 99.2 | 1 | 265 | 2 | 536 | 624 | XDO01629.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 11-3] | diamond | 531 | 85.9 | 0.9953434225844 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Alphaormycoviridae | Phormycovirus | Phormycovirus quaphytophthorae | |||
| 30558084 | 30558084 | PRJNA745553_S_NODE_26893_length_240_cov_4.844311_g26698_i0 | PRJNA745553 | 26893 | 240 | 4.844311 | 11.6263464 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94 | 2.02e-22 | NR | XOE97092.1 | 2832643 | g26698 | i0 | 78 | 0.625 | 50 | 11 | 62.5 | 0 | 225 | 76 | 91 | 140 | XOE97092.1 MAG: Sak4-like ssDNA annealing protein [Caudoviricetes sp.] | diamond | 150 | 94 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30589783 | 30589783 | PRJNA745553_S_NODE_433_length_966_cov_2.524076_g354_i0 | PRJNA745553 | 433 | 966 | 2.524076 | 24.38257416 | Fusarium oxysporum f. sp. cubense ourmia-like virus 3 | 3038613 | Viruses | Viruses | 353 | 2.0999999999999997e-113 | NR | WNK16432.1 | 3038613 | g354 | i0 | 56.8 | 2 | 322 | 136 | 100 | 2 | 966 | 1 | 83 | 401 | WNK16432.1 MAG: RNA-dependent RNA polymerase [Fusarium oxysporum f. sp. cubense ourmia-like virus 3] | diamond | 1932 | 353 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Fusarium oxysporum f. sp. cubense ourmia-like virus 3 | |||
| 30779474 | 30779474 | PRJNA745553_S_NODE_18214_length_289_cov_5.148148_g18019_i0 | PRJNA745553 | 18214 | 289 | 5.148148 | 14.87814772 | Grapevine-associated RNA virus 2 | 2814388 | Viruses | Viruses | 70.9 | 8.15e-12 | NR | QXN75432.1 | 2814388 | g18019 | i0 | 48.3 | 0.622837370242215 | 60 | 31 | 62.3 | 0 | 271 | 92 | 424 | 483 | QXN75432.1 MAG: RNA-dependent RNA polymerase [Grapevine-associated RNA virus 2] | diamond | 180 | 70.9 | 1 | Viruses | Grapevine-associated RNA virus 2 | ||||||||
| 31284972 | 31284972 | PRJNA745553_S_NODE_7175_length_442_cov_1.788618_g6981_i0 | PRJNA745553 | 7175 | 442 | 1.788618 | 7.90569156 | Alphachrysovirus aspergilli | 607716 | Viruses | Viruses | 163 | 2.09e-43 | NR | YP_009508106.1 | 607716 | g6981 | i0 | 55.9 | 1.94117647058824 | 143 | 61 | 97.1 | 1 | 442 | 14 | 521 | 661 | YP_009508106.1 hypothetical protein [Alphachrysovirus aspergilli] | diamond | 858 | 163 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus aspergilli | ||
| 31569957 | 31569957 | PRJNA745553_S_NODE_5356_length_492_cov_8.687351_g5162_i0 | PRJNA745553 | 5356 | 492 | 8.687351 | 42.74176692 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 94.4 | 1.45e-20 | NR | XOS25152.1 | 2832643 | g5162 | i0 | 39.6 | 0.817073170731707 | 134 | 80 | 81.1 | 1 | 63 | 461 | 1 | 134 | XOS25152.1 MAG: hypothetical protein MSP0003_302 [Caudoviricetes sp.] | diamond | 402 | 94.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31664486 | 31664486 | PRJNA745553_S_NODE_22377_length_261_cov_7.031915_g22182_i0 | PRJNA745553 | 22377 | 261 | 7.031915 | 18.35329815 | Erysiphe necator associated ourmia-like virus 1 | 2689557 | Viruses | Viruses | 125 | 3.53e-31 | NR | QGZ98421.1 | 2689557 | g22182 | i0 | 77.5 | 1.83908045977011 | 80 | 18 | 92 | 0 | 241 | 2 | 605 | 684 | QGZ98421.1 RNA dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 1] | diamond | 480 | 125 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Erysiphe necator associated ourmia-like virus 1 | |||
| 31822614 | 31822614 | PRJNA745553_S_NODE_4877_length_508_cov_2.666667_g4685_i0 | PRJNA745553 | 4877 | 508 | 2.666667 | 13.54666836 | Penicillium vanoranjei associated RNA virus 1 | 2918179 | Viruses | Viruses | 205 | 5.37e-61 | NR | BDF97667.1 | 2918179 | g4685 | i0 | 68.7 | 0.868110236220472 | 147 | 45 | 86.2 | 1 | 508 | 71 | 297 | 443 | BDF97667.1 RNA-dependent RNA polymerase [Penicillium vanoranjei associated RNA virus 1] | diamond | 441 | 205 | 1 | Viruses | Penicillium vanoranjei associated RNA virus 1 | ||||||||
| 32266013 | 32266013 | PRJNA745553_S_NODE_29078_length_224_cov_7.192053_g28883_i0 | PRJNA745553 | 29078 | 224 | 7.192053 | 16.11019872 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 72.8 | 4.47e-14 | NR | DAO47502.1 | 2832643 | g28883 | i0 | 57.7 | 0.950892857142857 | 71 | 30 | 95.1 | 0 | 3 | 215 | 77 | 147 | DAO47502.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 213 | 72.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32402378 | 32402378 | PRJNA745553_S_NODE_22519_length_261_cov_1.228723_g22324_i0 | PRJNA745553 | 22519 | 261 | 1.228723 | 3.20696703 | Viruses | 10239 | Viruses | Viruses | 104 | 3.57e-24 | NR | WZH60757.1 | 3131039 | g22324 | i0 | 53.9 | 1.77011494252874 | 76 | 35 | 87.4 | 0 | 24 | 251 | 244 | 319 | WZH60757.1 MAG: RNA-dependent RNA polymerase [Ripoproz virus] | diamond | 462 | 104 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Ripoproz virus |
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);;