contig_metadata
17 rows where bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179501 | 179501 | PRJNA1063685_S_NODE_24421_length_470_cov_11.473552_g23881_i0 | PRJNA1063685 | 24421 | 470 | 11.473552 | 53.9256944 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 811 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g23881 | i0 | 98.899 | 1.14255319148936 | 454 | 5 | 97 | 0 | 17 | 470 | 1037 | 584 | Malassezia restricta virus MrV40L, complete genome | blastn | 537 | 811 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2729810 | 2729810 | PRJNA1063685_S_NODE_10823_length_616_cov_12.694291_g10308_i0 | PRJNA1063685 | 10823 | 616 | 12.694291 | 78.19683256 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 1098 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g10308 | i0 | 99.503 | 0.980519480519481 | 604 | 2 | 98 | 1 | 1 | 603 | 4604 | 4001 | Malassezia restricta virus MrV40L, complete genome | blastn | 604 | 1098 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2730153 | 2730153 | PRJNA1063685_S_NODE_44723_length_344_cov_1.442804_g44180_i0 | PRJNA1063685 | 44723 | 344 | 1.442804 | 4.96324576 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 488 | 2.0899999999999996e-133 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g44180 | i0 | 94.081 | 1.43313953488372 | 321 | 19 | 93 | 0 | 24 | 344 | 711 | 391 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 493 | 488 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 7832260 | 7832260 | PRJNA1063685_S_NODE_42507_length_355_cov_3.567376_g41964_i0 | PRJNA1063685 | 42507 | 355 | 3.567376 | 12.6641848 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 542 | 1.63e-149 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g41964 | i0 | 99.331 | 0.842253521126761 | 299 | 2 | 84 | 0 | 57 | 355 | 1335 | 1037 | Malassezia restricta virus MrV40S, complete genome | blastn | 299 | 542 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 7832392 | 7832392 | PRJNA1063685_S_NODE_59447_length_282_cov_1.794258_g58904_i0 | PRJNA1063685 | 59447 | 282 | 1.794258 | 5.05980756 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 499 | 7.729999999999999e-137 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g58904 | i0 | 98.582 | 2 | 282 | 4 | 100 | 0 | 1 | 282 | 330 | 611 | Malassezia restricta virus MrV40L, complete genome | blastn | 564 | 499 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9107115 | 9107115 | PRJNA1063685_S_NODE_27928_length_444_cov_4.347709_g27387_i0 | PRJNA1063685 | 27928 | 444 | 4.347709 | 19.30382796 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 752 | 0 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g27387 | i0 | 99.045 | 0.943693693693694 | 419 | 4 | 94 | 0 | 24 | 442 | 914 | 496 | Malassezia restricta virus MrV40S, complete genome | blastn | 419 | 752 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 10382874 | 10382874 | PRJNA1063685_S_NODE_37089_length_384_cov_3.292605_g36546_i0 | PRJNA1063685 | 37089 | 384 | 3.292605 | 12.6436032 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 553 | 8.239999999999998e-153 | NTclustered | gi|2512878152|emb|OX637979.1| | 3048757 | g36546 | i0 | 93.767 | 1.22395833333333 | 369 | 21 | 96 | 2 | 1 | 368 | 1055 | 1422 | Malassezia restricta associated totivirus 1 polyprotein gene for polyprotein | blastn | 470 | 553 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 12933388 | 12933388 | PRJNA1063685_S_NODE_431_length_1475_cov_27.145506_g298_i0 | PRJNA1063685 | 431 | 1475 | 27.145506 | 400.3962135 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2627 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g298 | i0 | 99.86 | 1.89491525423729 | 1428 | 2 | 97 | 0 | 24 | 1451 | 3231 | 1804 | Malassezia restricta virus MrV40L, complete genome | blastn | 2795 | 2627 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 16756450 | 16756450 | PRJNA1063685_S_NODE_31834_length_416_cov_2.020408_g31292_i0 | PRJNA1063685 | 31834 | 416 | 2.020408 | 8.40489728 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 713 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g31292 | i0 | 97.596 | 1 | 416 | 10 | 100 | 0 | 1 | 416 | 1742 | 1327 | Malassezia restricta virus MrV40L, complete genome | blastn | 416 | 713 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 21856258 | 21856258 | PRJNA1063685_S_NODE_18198_length_527_cov_9.451542_g17662_i0 | PRJNA1063685 | 18198 | 527 | 9.451542 | 49.80962634 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 756 | 0 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g17662 | i0 | 93.077 | 0.986717267552182 | 520 | 31 | 98 | 4 | 12 | 527 | 436 | 954 | Malassezia restricta virus MrV40S, complete genome | blastn | 520 | 756 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 27817166 | 27817166 | PRJNA1063685_S_NODE_45304_length_341_cov_2.264925_g44761_i0 | PRJNA1063685 | 45304 | 341 | 2.264925 | 7.72339425 | Totivirus | 11007 | Viruses | Viruses | 102 | 9.97e-23 | NR | QJW70335.1 | 2737096 | g44761 | i0 | 48.4 | 1.67155425219941 | 95 | 49 | 83.6 | 0 | 323 | 39 | 702 | 796 | QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6] | diamond | 570 | 102 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 6 | ||
| 29458501 | 29458501 | PRJNA1063685_S_NODE_19310_length_516_cov_6.823928_g18773_i0 | PRJNA1063685 | 19310 | 516 | 6.823928 | 35.21146848 | Totivirus | 11007 | Viruses | Viruses | 139 | 9.91e-35 | NR | QJW70338.1 | 2737097 | g18773 | i0 | 43 | 1.84883720930233 | 158 | 90 | 91.9 | 0 | 39 | 512 | 28 | 185 | QJW70338.1 coat protein [Erysiphe necator associated totivirus 7] | diamond | 954 | 140 | 0.992857142857143 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 7 | ||
| 29782790 | 29782790 | PRJNA1063685_S_NODE_23171_length_480_cov_12.783784_g22631_i0 | PRJNA1063685 | 23171 | 480 | 12.783784 | 61.3621632 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 112 | 1.82e-28 | NR | QJA42333.1 | 2727864 | g22631 | i0 | 62.5 | 0.5 | 80 | 30 | 50 | 0 | 240 | 479 | 1 | 80 | QJA42333.1 hypothetical protein MRV40S_001 [Malassezia restricta virus MrV40S] | diamond | 240 | 112 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 30035590 | 30035590 | PRJNA1063685_S_NODE_40971_length_363_cov_4.534483_g40428_i0 | PRJNA1063685 | 40971 | 363 | 4.534483 | 16.46017329 | Totivirus sp. | 2776824 | Viruses | Viruses | 155 | 9.33e-45 | NR | QOQ37363.1 | 2776824 | g40428 | i0 | 71.7 | 0.933884297520661 | 113 | 32 | 93.4 | 0 | 340 | 2 | 24 | 136 | QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 339 | 155 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 31204057 | 31204057 | PRJNA1063685_S_NODE_16195_length_548_cov_10.400000_g15665_i0 | PRJNA1063685 | 16195 | 548 | 10.4 | 56.992 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 181 | 2.18e-49 | NR | CAI9858973.1 | 3048756 | g15665 | i0 | 59.9 | 0.804744525547445 | 147 | 59 | 80.5 | 0 | 107 | 547 | 59 | 205 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 441 | 181 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 32058569 | 32058569 | PRJNA1063685_S_NODE_44098_length_347_cov_1.967153_g43555_i0 | PRJNA1063685 | 44098 | 347 | 1.967153 | 6.82602091 | Red clover powdery mildew-associated totivirus 4 | 1714365 | Viruses | Viruses | 176 | 6.05e-49 | NR | BAT62484.1 | 1714365 | g43555 | i0 | 79.4 | 0.92507204610951 | 107 | 22 | 92.5 | 0 | 25 | 345 | 86 | 192 | BAT62484.1 RNA dependent RNA polymerase, partial [Red clover powdery mildew-associated totivirus 4] | diamond | 321 | 176 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Red clover powdery mildew-associated totivirus 4 | |||
| 32785157 | 32785157 | PRJNA1063685_S_NODE_79540_length_213_cov_6.078571_g78997_i0 | PRJNA1063685 | 79540 | 213 | 6.078571 | 12.94735623 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 61.2 | 7.42e-9 | NR | CAI9858976.1 | 3048757 | g78997 | i0 | 76.9 | 0.549295774647887 | 39 | 9 | 54.9 | 0 | 74 | 190 | 523 | 561 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 117 | 61.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta 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);;