contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26763322 | 26763322 | PRJNA597223_P_NODE_75621_length_163_cov_1.476562_g73775_i0 | PRJNA597223 | 75621 | 163 | 1.476562 | 2.40679606 | Malassezia sympodialis mycovirus | 2766745 | Viruses | Viruses | 51.2 | 1.2e-5 | NR | QNJ34611.1 | 2766745 | g73775 | i0 | 32.1 | 0.975460122699387 | 53 | 36 | 97.5 | 0 | 3 | 161 | 51 | 103 | QNJ34611.1 hypothetical protein [Malassezia sympodialis mycovirus] | diamond | 159 | 51.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 26921645 | 26921645 | PRJNA597223_P_NODE_37642_length_235_cov_2.940000_g35796_i0 | PRJNA597223 | 37642 | 235 | 2.94 | 6.909 | Totiviridae sp. | 1955172 | Viruses | Viruses | 81.3 | 9.1e-16 | NR | WAK77570.1 | 1955172 | g35796 | i0 | 46.8 | 0.982978723404255 | 77 | 41 | 98.3 | 0 | 1 | 231 | 17 | 93 | WAK77570.1 MAG: polyprotein, partial [Totiviridae sp.] | diamond | 231 | 81.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 26953138 | 26953138 | PRJNA597223_P_NODE_8822_length_586_cov_2.453721_g7255_i0 | PRJNA597223 | 8822 | 586 | 2.453721 | 14.37880506 | Totiviridae sp. | 1955172 | Viruses | Viruses | 229 | 1.1699999999999997e-67 | NR | WAK77569.1 | 1955172 | g7255 | i0 | 59 | 0.998293515358362 | 195 | 78 | 99.8 | 1 | 2 | 586 | 86 | 278 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 585 | 229 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 27206005 | 27206005 | PRJNA597223_P_NODE_6122_length_704_cov_3.278027_g4763_i0 | PRJNA597223 | 6122 | 704 | 3.278027 | 23.07731008 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 233 | 2.32e-68 | NR | CAI9858976.1 | 3048757 | g4763 | i0 | 97.5 | 0.511363636363636 | 120 | 3 | 51.1 | 0 | 703 | 344 | 571 | 690 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 360 | 233 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 27301163 | 27301163 | PRJNA597223_P_NODE_18363_length_382_cov_2.648415_g16539_i0 | PRJNA597223 | 18363 | 382 | 2.648415 | 10.1169453 | Totiviridae sp. | 1955172 | Viruses | Viruses | 195 | 8.94e-57 | NR | WAK77570.1 | 1955172 | g16539 | i0 | 72.4 | 0.99738219895288 | 127 | 35 | 99.7 | 0 | 381 | 1 | 416 | 542 | WAK77570.1 MAG: polyprotein, partial [Totiviridae sp.] | diamond | 381 | 195 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 27522105 | 27522105 | PRJNA597223_P_NODE_33263_length_256_cov_1.814480_g31417_i0 | PRJNA597223 | 33263 | 256 | 1.81448 | 4.6450688 | Geotrichum candidum totivirus 3b | 2971329 | Viruses | Viruses | 63.5 | 2.07e-9 | NR | UUT40380.1 | 2971329 | g31417 | i0 | 61.7 | 1.1015625 | 47 | 18 | 55.1 | 0 | 256 | 116 | 267 | 313 | UUT40380.1 coat protein [Geotrichum candidum totivirus 3b] | diamond | 282 | 63.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Geotrichum candidum totivirus 3b | ||
| 27837766 | 27837766 | PRJNA597223_P_NODE_22324_length_337_cov_1.519868_g20484_i0 | PRJNA597223 | 22324 | 337 | 1.519868 | 5.12195516 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 210 | 1.5799999999999998e-61 | NR | CAI9858973.1 | 3048756 | g20484 | i0 | 92.9 | 0.997032640949555 | 112 | 8 | 99.7 | 0 | 337 | 2 | 545 | 656 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 336 | 210 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 28248227 | 28248227 | PRJNA597223_P_NODE_72226_length_167_cov_2.484848_g70380_i0 | PRJNA597223 | 72226 | 167 | 2.484848 | 4.14969616 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 105 | 1.43e-24 | NR | CAI9858976.1 | 3048757 | g70380 | i0 | 96.4 | 0.988023952095808 | 55 | 2 | 98.8 | 0 | 165 | 1 | 458 | 512 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 165 | 105 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 28311645 | 28311645 | PRJNA597223_P_NODE_56806_length_187_cov_2.631579_g54960_i0 | PRJNA597223 | 56806 | 187 | 2.631579 | 4.92105273 | Totivirus sp. | 2776824 | Viruses | Viruses | 112 | 5.569999999999999e-28 | NR | QOQ37361.1 | 2776824 | g54960 | i0 | 94.6 | 0.898395721925134 | 56 | 3 | 89.8 | 0 | 168 | 1 | 1 | 56 | QOQ37361.1 capsid protein, partial [Totivirus sp.] | diamond | 168 | 112 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 28690645 | 28690645 | PRJNA597223_P_NODE_30227_length_274_cov_2.464435_g28381_i0 | PRJNA597223 | 30227 | 274 | 2.464435 | 6.7525519 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 176 | 2.1400000000000002e-49 | NR | CAI9858976.1 | 3048757 | g28381 | i0 | 93.4 | 0.996350364963504 | 91 | 6 | 99.6 | 0 | 2 | 274 | 581 | 671 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 273 | 176 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 29006601 | 29006601 | PRJNA597223_P_NODE_75848_length_163_cov_0.859375_g74002_i0 | PRJNA597223 | 75848 | 163 | 0.859375 | 1.40078125 | Malassezia sympodialis mycovirus | 2766745 | Viruses | Viruses | 42 | 0.0238 | NR | QNJ34611.1 | 2766745 | g74002 | i0 | 34.6 | 0.957055214723926 | 52 | 34 | 95.7 | 0 | 8 | 163 | 119 | 170 | QNJ34611.1 hypothetical protein [Malassezia sympodialis mycovirus] | diamond | 156 | 42 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 30237818 | 30237818 | PRJNA597223_P_NODE_24532_length_316_cov_3.697509_g22688_i0 | PRJNA597223 | 24532 | 316 | 3.697509 | 11.68412844 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 89 | 5.26e-18 | NR | CAI9858976.1 | 3048757 | g22688 | i0 | 42.3 | 0.920886075949367 | 97 | 56 | 92.1 | 0 | 316 | 26 | 593 | 689 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 291 | 89 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 30301471 | 30301471 | PRJNA597223_P_NODE_19852_length_364_cov_2.285714_g18020_i0 | PRJNA597223 | 19852 | 364 | 2.285714 | 8.31999896 | Totiviridae sp. | 1955172 | Viruses | Viruses | 121 | 3.07e-29 | NR | WAK77569.1 | 1955172 | g18020 | i0 | 52.5 | 0.972527472527473 | 118 | 56 | 97.3 | 0 | 1 | 354 | 204 | 321 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 354 | 121 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 30522163 | 30522163 | PRJNA597223_P_NODE_76333_length_162_cov_1.661417_g74487_i0 | PRJNA597223 | 76333 | 162 | 1.661417 | 2.69149554 | Totivirus sp. | 2776824 | Viruses | Viruses | 101 | 1.7199999999999995e-23 | NR | QOQ37362.1 | 2776824 | g74487 | i0 | 86.8 | 0.981481481481482 | 53 | 7 | 98.1 | 0 | 3 | 161 | 150 | 202 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 159 | 101 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 30711709 | 30711709 | PRJNA597223_P_NODE_37434_length_236_cov_2.293532_g35588_i0 | PRJNA597223 | 37434 | 236 | 2.293532 | 5.41273552 | Totivirus sp. | 2776824 | Viruses | Viruses | 152 | 3.0799999999999993e-43 | NR | QOQ37361.1 | 2776824 | g35588 | i0 | 93.5 | 0.978813559322034 | 77 | 5 | 97.9 | 0 | 5 | 235 | 156 | 232 | QOQ37361.1 capsid protein, partial [Totivirus sp.] | diamond | 231 | 152 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 30838139 | 30838139 | PRJNA597223_P_NODE_82454_length_155_cov_1.650000_g80608_i0 | PRJNA597223 | 82454 | 155 | 1.65 | 2.5575 | Totiviridae sp. | 1955172 | Viruses | Viruses | 79.7 | 1.02e-15 | NR | WAK77570.1 | 1955172 | g80608 | i0 | 77.3 | 1.78064516129032 | 44 | 10 | 85.2 | 0 | 153 | 22 | 296 | 339 | WAK77570.1 MAG: polyprotein, partial [Totiviridae sp.] | diamond | 276 | 79.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31135506 | 31135506 | PRJNA597223_P_NODE_26895_length_297_cov_2.828244_g25049_i0 | PRJNA597223 | 26895 | 297 | 2.828244 | 8.39988468 | Ghabrivirales | 2732540 | Viruses | Viruses | 94.4 | 5.37e-20 | NR | WAK77569.1 | 1955172 | g25049 | i0 | 49 | 1.97979797979798 | 98 | 50 | 99 | 0 | 294 | 1 | 75 | 172 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 588 | 94.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31153725 | 31153725 | PRJNA597223_P_NODE_9835_length_553_cov_3.285714_g8197_i0 | PRJNA597223 | 9835 | 553 | 3.285714 | 18.16999842 | Totiviridae sp. | 1955172 | Viruses | Viruses | 163 | 9.69e-44 | NR | WAK77570.1 | 1955172 | g8197 | i0 | 52.2 | 0.851717902350814 | 157 | 74 | 84.6 | 1 | 4 | 471 | 106 | 262 | WAK77570.1 MAG: polyprotein, partial [Totiviridae sp.] | diamond | 471 | 163 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31438603 | 31438603 | PRJNA597223_P_NODE_81636_length_156_cov_1.404959_g79790_i0 | PRJNA597223 | 81636 | 156 | 1.404959 | 2.19173604 | Totiviridae sp. | 1955172 | Viruses | Viruses | 43.1 | 0.00828 | NR | WAK77569.1 | 1955172 | g79790 | i0 | 43.6 | 0.75 | 39 | 22 | 75 | 0 | 39 | 155 | 437 | 475 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 117 | 43.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31691696 | 31691696 | PRJNA597223_P_NODE_45197_length_209_cov_2.936782_g43351_i0 | PRJNA597223 | 45197 | 209 | 2.936782 | 6.13787438 | Totiviridae sp. | 1955172 | Viruses | Viruses | 54.7 | 1.45e-6 | NR | WAK77569.1 | 1955172 | g43351 | i0 | 48.2 | 0.803827751196172 | 56 | 29 | 80.4 | 0 | 207 | 40 | 629 | 684 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 168 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31849819 | 31849819 | PRJNA597223_P_NODE_86157_length_151_cov_3.706897_g84311_i0 | PRJNA597223 | 86157 | 151 | 3.706897 | 5.59741447 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 50.1 | 2.66e-5 | NR | CAI9858976.1 | 3048757 | g84311 | i0 | 100 | 0.47682119205298 | 24 | 0 | 47.7 | 0 | 146 | 75 | 474 | 497 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 72 | 50.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31976350 | 31976350 | PRJNA597223_P_NODE_13998_length_452_cov_2.045564_g12218_i0 | PRJNA597223 | 13998 | 452 | 2.045564 | 9.24594928 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 273 | 3.11e-85 | NR | CAI9858976.1 | 3048757 | g12218 | i0 | 92.7 | 1.99115044247788 | 150 | 11 | 99.6 | 0 | 1 | 450 | 113 | 262 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 900 | 273 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 32039753 | 32039753 | PRJNA597223_P_NODE_28138_length_288_cov_2.201581_g26292_i0 | PRJNA597223 | 28138 | 288 | 2.201581 | 6.34055328 | Totivirus sp. | 2776824 | Viruses | Viruses | 111 | 5.92e-27 | NR | QOQ37361.1 | 2776824 | g26292 | i0 | 87.9 | 0.604166666666667 | 58 | 7 | 60.4 | 0 | 2 | 175 | 163 | 220 | QOQ37361.1 capsid protein, partial [Totivirus sp.] | diamond | 174 | 111 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 32134745 | 32134745 | PRJNA597223_P_NODE_22298_length_337_cov_2.692053_g20458_i0 | PRJNA597223 | 22298 | 337 | 2.692053 | 9.07221861 | Totiviridae sp. | 1955172 | Viruses | Viruses | 80.5 | 6.17e-15 | NR | WAK77569.1 | 1955172 | g20458 | i0 | 39.8 | 0.961424332344214 | 108 | 65 | 96.1 | 0 | 335 | 12 | 169 | 276 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 324 | 80.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32293220 | 32293220 | PRJNA597223_P_NODE_65939_length_177_cov_2.746479_g64093_i0 | PRJNA597223 | 65939 | 177 | 2.746479 | 4.86126783 | Totiviridae sp. | 1955172 | Viruses | Viruses | 87.4 | 2.72e-18 | NR | WAK77569.1 | 1955172 | g64093 | i0 | 67.2 | 0.983050847457627 | 58 | 19 | 98.3 | 0 | 176 | 3 | 304 | 361 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 174 | 87.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32338098 | 32338098 | PRJNA597223_P_NODE_37279_length_237_cov_1.668317_g35433_i0 | PRJNA597223 | 37279 | 237 | 1.668317 | 3.95391129 | Ghabrivirales | 2732540 | Viruses | Viruses | 56.2 | 5.96e-7 | NR | WAK77450.1 | 1955172 | g35433 | i0 | 42.2 | 1.67088607594937 | 64 | 37 | 81 | 0 | 26 | 217 | 1 | 64 | WAK77450.1 MAG: capsid protein [Totiviridae sp.] | diamond | 396 | 56.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32892297 | 32892297 | PRJNA597223_P_NODE_48540_length_201_cov_1.168675_g46694_i0 | PRJNA597223 | 48540 | 201 | 1.168675 | 2.34903675 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 127 | 2.9599999999999996e-32 | NR | CAI9858976.1 | 3048757 | g46694 | i0 | 86.4 | 1.97014925373134 | 66 | 9 | 98.5 | 0 | 3 | 200 | 235 | 300 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 396 | 127 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 32892316 | 32892316 | PRJNA597223_P_NODE_88700_length_150_cov_1.391304_g86854_i0 | PRJNA597223 | 88700 | 150 | 1.391304 | 2.086956 | Erysiphales associated totivirus 1 | 2719839 | Viruses | Viruses | 56.6 | 1.35e-7 | NR | QIP68045.1 | 2719839 | g86854 | i0 | 54.3 | 0.92 | 46 | 21 | 92 | 0 | 1 | 138 | 330 | 375 | QIP68045.1 coat protein [Erysiphales associated totivirus 1] | diamond | 138 | 56.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphales associated totivirus 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);;