contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA665531" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 629252 | 629252 | PRJNA665531_P_NODE_121_length_2173_cov_3.911429_g96_i0 | PRJNA665531 | 121 | 2173 | 3.911429 | 84.99535217 | Ghabrivirales | 2732540 | Viruses | Viruses | 625 | 6.24e-212 | NR | WAK77685.1 | 1955172 | g96 | i0 | 47.9 | 1.89139438564197 | 681 | 344 | 93.5 | 5 | 71 | 2101 | 116 | 789 | WAK77685.1 MAG: polyprotein [Totiviridae sp.] | diamond | 4110 | 625 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 26701454 | 26701454 | PRJNA665531_P_NODE_7941_length_376_cov_1.435644_g7705_i0 | PRJNA665531 | 7941 | 376 | 1.435644 | 5.39802144 | Totivirus sp. | 2776824 | Viruses | Viruses | 216 | 1.82e-68 | NR | QOQ37363.1 | 2776824 | g7705 | i0 | 87.1 | 0.98936170212766 | 124 | 16 | 98.9 | 0 | 374 | 3 | 52 | 175 | QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 372 | 216 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 27965822 | 27965822 | PRJNA665531_P_NODE_12945_length_288_cov_1.404651_g12709_i0 | PRJNA665531 | 12945 | 288 | 1.404651 | 4.04539488 | Totiviridae sp. | 1955172 | Viruses | Viruses | 89.7 | 1.92e-18 | NR | WAK77569.1 | 1955172 | g12709 | i0 | 47.9 | 0.979166666666667 | 94 | 49 | 97.9 | 0 | 6 | 287 | 202 | 295 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 282 | 89.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 28060531 | 28060531 | PRJNA665531_P_NODE_8365_length_364_cov_2.044674_g8129_i0 | PRJNA665531 | 8365 | 364 | 2.044674 | 7.44261336 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 218 | 1.02e-64 | NR | CAI9858976.1 | 3048757 | g8129 | i0 | 90.1 | 0.997252747252747 | 121 | 12 | 99.7 | 0 | 2 | 364 | 455 | 575 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 363 | 218 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 28249892 | 28249892 | PRJNA665531_P_NODE_1326_length_1022_cov_3.526870_g1183_i0 | PRJNA665531 | 1326 | 1022 | 3.52687 | 36.0446114 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 648 | 1.0699999999999999e-228 | NR | CAI9858976.1 | 3048757 | g1183 | i0 | 94.1 | 0.998043052837573 | 340 | 20 | 99.8 | 0 | 1022 | 3 | 300 | 639 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 1020 | 648 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 28597468 | 28597468 | PRJNA665531_P_NODE_1447_length_978_cov_3.829834_g1289_i0 | PRJNA665531 | 1447 | 978 | 3.829834 | 37.45577652 | Totiviridae sp. | 1955172 | Viruses | Viruses | 272 | 5.009999999999999e-82 | NR | WAK77569.1 | 1955172 | g1289 | i0 | 45.3 | 0.987730061349693 | 322 | 171 | 97.9 | 2 | 1 | 957 | 13 | 332 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 966 | 272 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 28660584 | 28660584 | PRJNA665531_P_NODE_10087_length_328_cov_1.992157_g9851_i0 | PRJNA665531 | 10087 | 328 | 1.992157 | 6.53427496 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 103 | 4.51e-23 | NR | CAI9858974.1 | 3048756 | g9851 | i0 | 42.6 | 1.97560975609756 | 108 | 62 | 98.8 | 0 | 328 | 5 | 56 | 163 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 648 | 103 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 28735819 | 28735819 | PRJNA665531_P_NODE_47_length_2532_cov_5.536397_g39_i0 | PRJNA665531 | 47 | 2532 | 5.536397 | 140.18157204 | Ghabrivirales | 2732540 | Viruses | Viruses | 406 | 1.0999999999999999e-126 | NR | WAK77569.1 | 1955172 | g39 | i0 | 37.2 | 1.58530805687204 | 659 | 392 | 76.7 | 10 | 51 | 1991 | 1 | 649 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 4014 | 409 | 0.992665036674817 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 29291950 | 29291950 | PRJNA665531_P_NODE_10069_length_328_cov_3.070588_g9833_i0 | PRJNA665531 | 10069 | 328 | 3.070588 | 10.07152864 | Totiviridae sp. | 1955172 | Viruses | Viruses | 117 | 4.42e-28 | NR | WAK77569.1 | 1955172 | g9833 | i0 | 50.5 | 0.996951219512195 | 109 | 54 | 99.7 | 0 | 1 | 327 | 290 | 398 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 327 | 117 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 29355255 | 29355255 | PRJNA665531_P_NODE_7829_length_379_cov_1.147059_g7593_i0 | PRJNA665531 | 7829 | 379 | 1.147059 | 4.34735361 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 256 | 2.65e-79 | NR | CAI9858976.1 | 3048757 | g7593 | i0 | 93.7 | 0.997361477572559 | 126 | 8 | 99.7 | 0 | 378 | 1 | 308 | 433 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 378 | 256 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 29544426 | 29544426 | PRJNA665531_P_NODE_8290_length_366_cov_1.716724_g8054_i0 | PRJNA665531 | 8290 | 366 | 1.716724 | 6.28320984 | Totiviridae sp. | 1955172 | Viruses | Viruses | 87 | 4.51e-17 | NR | WAK77569.1 | 1955172 | g8054 | i0 | 41.1 | 1.82786885245902 | 112 | 61 | 90.2 | 2 | 332 | 3 | 196 | 304 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 669 | 87 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 29923618 | 29923618 | PRJNA665531_P_NODE_16691_length_253_cov_1.344444_g16455_i0 | PRJNA665531 | 16691 | 253 | 1.344444 | 3.40144332 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 112 | 9.41e-27 | NR | CAI9858974.1 | 3048756 | g16455 | i0 | 57.1 | 0.99604743083004 | 84 | 35 | 99.6 | 1 | 252 | 1 | 561 | 643 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 252 | 112 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 30018438 | 30018438 | PRJNA665531_P_NODE_5871_length_447_cov_1.807487_g5635_i0 | PRJNA665531 | 5871 | 447 | 1.807487 | 8.07946689 | Tuatara cloaca-assoiciated totivrus-3 | 2970571 | Viruses | Viruses | 179 | 3.28e-53 | NR | UUV42637.1 | 2970571 | g5635 | i0 | 61.4 | 5.70469798657718 | 145 | 56 | 97.3 | 0 | 11 | 445 | 116 | 260 | UUV42637.1 MAG: RNA-dependent RNA polymerase, partial [Tuatara cloaca-assoiciated totivrus-3] | diamond | 2550 | 179 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Tuatara cloaca-assoiciated totivrus-3 | ||
| 30144315 | 30144315 | PRJNA665531_P_NODE_20552_length_210_cov_5.240876_g20316_i0 | PRJNA665531 | 20552 | 210 | 5.240876 | 11.0058396 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 53.9 | 2.89e-6 | NR | WLN26256.1 | 3065075 | g20316 | i0 | 53.5 | 1.22857142857143 | 43 | 20 | 61.4 | 0 | 1 | 129 | 192 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 258 | 53.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 30239445 | 30239445 | PRJNA665531_P_NODE_11152_length_311_cov_2.936975_g10916_i0 | PRJNA665531 | 11152 | 311 | 2.936975 | 9.13399225 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 185 | 1.3e-52 | NR | QJA42330.1 | 2727863 | g10916 | i0 | 83.3 | 1.96784565916399 | 102 | 17 | 98.4 | 0 | 308 | 3 | 504 | 605 | QJA42330.1 capsid protein [Malassezia restricta virus MrV40L] | diamond | 612 | 185 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 30315264 | 30315264 | PRJNA665531_P_NODE_6832_length_409_cov_2.392857_g6596_i0 | PRJNA665531 | 6832 | 409 | 2.392857 | 9.78678513 | Totivirus | 11007 | Viruses | Viruses | 218 | 1.84e-66 | NR | QOQ37362.1 | 2776824 | g6596 | i0 | 77.8 | 1.98044009779951 | 135 | 30 | 99 | 0 | 3 | 407 | 102 | 236 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 810 | 219 | 0.995433789954338 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 30586827 | 30586827 | PRJNA665531_P_NODE_5793_length_451_cov_1.042328_g5557_i0 | PRJNA665531 | 5793 | 451 | 1.042328 | 4.70089928 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 273 | 3.11e-85 | NR | CAI9858976.1 | 3048757 | g5557 | i0 | 92.7 | 0.997782705099778 | 150 | 11 | 99.8 | 0 | 451 | 2 | 519 | 668 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 450 | 273 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31598661 | 31598661 | PRJNA665531_P_NODE_17036_length_251_cov_0.865169_g16800_i0 | PRJNA665531 | 17036 | 251 | 0.865169 | 2.17157419 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 153 | 3.21e-41 | NR | CAI9858974.1 | 3048756 | g16800 | i0 | 84.3 | 0.99203187250996006 | 83 | 13 | 99.2 | 0 | 1 | 249 | 444 | 526 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 249 | 153 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 31756593 | 31756593 | PRJNA665531_P_NODE_16957_length_251_cov_1.573034_g16721_i0 | PRJNA665531 | 16957 | 251 | 1.573034 | 3.94831534 | Totiviridae sp. | 1955172 | Viruses | Viruses | 79.7 | 3.93e-15 | NR | WAK77569.1 | 1955172 | g16721 | i0 | 51.3 | 0.956175298804781 | 80 | 39 | 95.6 | 0 | 240 | 1 | 326 | 405 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 240 | 79.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31819768 | 31819768 | PRJNA665531_P_NODE_7177_length_398_cov_1.889231_g6941_i0 | PRJNA665531 | 7177 | 398 | 1.889231 | 7.51913938 | Totivirus sp. | 2776824 | Viruses | Viruses | 152 | 2.3999999999999998e-43 | NR | QOQ37363.1 | 2776824 | g6941 | i0 | 60.6 | 0.994974874371859 | 132 | 52 | 99.5 | 0 | 396 | 1 | 47 | 178 | QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 396 | 152 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 32452950 | 32452950 | PRJNA665531_P_NODE_7779_length_380_cov_2.557003_g7543_i0 | PRJNA665531 | 7779 | 380 | 2.557003 | 9.7166114 | Totiviridae sp. | 1955172 | Viruses | Viruses | 91.7 | 2.22e-20 | NR | WWV90169.1 | 1955172 | g7543 | i0 | 43.6 | 2.55 | 117 | 66 | 92.4 | 0 | 30 | 380 | 46 | 162 | WWV90169.1 MAG: polyprotein, partial [Totiviridae sp.] | diamond | 969 | 91.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32811641 | 32811641 | PRJNA665531_P_NODE_20_length_3040_cov_23.982474_g15_i0 | PRJNA665531 | 20 | 3040 | 23.982474 | 729.0672096 | Totivirus | 11007 | Viruses | Viruses | 794 | 8.29e-274 | NR | QJW70335.1 | 2737096 | g15 | i0 | 50.8 | 1.57894736842105 | 801 | 383 | 78.5 | 6 | 600 | 2984 | 1 | 796 | QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6] | diamond | 4800 | 795 | 0.99874213836478 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 6 |
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);;