contig_metadata
17 rows where bioproject = "PRJNA704949", tax_phylum = "Duplornaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1973147 | 1973147 | PRJNA704949_P_NODE_37362_length_1268_cov_7.850697_g27610_i0 | PRJNA704949 | 37362 | 1268 | 7.850697 | 99.54683796 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2242 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g27610 | i0 | 98.58 | 1 | 1268 | 18 | 100 | 0 | 1 | 1268 | 2739 | 1472 | Malassezia restricta virus MrV40L, complete genome | blastn | 1268 | 2242 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 8343837 | 8343837 | PRJNA704949_P_NODE_1581947_length_194_cov_1.331034_g1566608_i0 | PRJNA704949 | 1581947 | 194 | 1.331034 | 2.58220596 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 353 | 4.1e-93 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g1566608 | i0 | 99.485 | 1.70103092783505 | 194 | 1 | 100 | 0 | 1 | 194 | 3492 | 3299 | Malassezia restricta virus MrV40L, complete genome | blastn | 330 | 353 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 19824876 | 19824876 | PRJNA704949_P_NODE_460116_length_401_cov_3.642045_g444905_i0 | PRJNA704949 | 460116 | 401 | 3.642045 | 14.60460045 | Totiviridae sp. | 1955172 | Viruses | Viruses | 243 | 2.12e-59 | NTclustered | gi|2396038768|gb|ON812661.1| | 1955172 | g444905 | i0 | 80.984 | 2.40648379052369 | 305 | 58 | 76 | 0 | 96 | 400 | 4520 | 4216 | MAG: Totiviridae sp. isolate TIGMIC_4, complete genome | blastn | 965 | 243 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 21091613 | 21091613 | PRJNA704949_P_NODE_1390917_length_211_cov_1.401235_g1375579_i0 | PRJNA704949 | 1390917 | 211 | 1.401235 | 2.95660585 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 331 | 2.13e-86 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g1375579 | i0 | 96.078 | 3.75355450236967 | 204 | 6 | 97 | 2 | 7 | 210 | 146 | 347 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 792 | 331 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 22374035 | 22374035 | PRJNA704949_P_NODE_322738_length_475_cov_1.708920_g307845_i0 | PRJNA704949 | 322738 | 475 | 1.70892 | 8.11737 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 850 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g307845 | i0 | 98.947 | 1.49263157894737 | 475 | 5 | 100 | 0 | 1 | 475 | 3191 | 2717 | Malassezia restricta virus MrV40L, complete genome | blastn | 709 | 850 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 23649709 | 23649709 | PRJNA704949_P_NODE_31699_length_1403_cov_2.081979_g22473_i0 | PRJNA704949 | 31699 | 1403 | 2.081979 | 29.21016537 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2023 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g22473 | i0 | 98.517 | 1.23093371347113 | 1146 | 17 | 99 | 0 | 258 | 1403 | 333 | 1478 | Malassezia restricta virus MrV40L, complete genome | blastn | 1727 | 2023 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 26988224 | 26988224 | PRJNA704949_P_NODE_42682_length_1176_cov_2.966282_g32547_i0 | PRJNA704949 | 42682 | 1176 | 2.966282 | 34.88347632 | Totivirus sp. | 2776824 | Viruses | Viruses | 501 | 8.259999999999999e-175 | NR | QOQ37361.1 | 2776824 | g32547 | i0 | 72.6 | 0.836734693877551 | 328 | 90 | 83.7 | 0 | 1161 | 178 | 21 | 348 | QOQ37361.1 capsid protein, partial [Totivirus sp.] | diamond | 984 | 501 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 27156861 | 27156861 | PRJNA704949_P_NODE_1711002_length_184_cov_1.533333_g1695663_i0 | PRJNA704949 | 1711002 | 184 | 1.533333 | 2.82133272 | Totivirus | 11007 | Viruses | Viruses | 92.4 | 4.01e-20 | NR | QOQ37362.1 | 2776824 | g1695663 | i0 | 73.6 | 1.71195652173913 | 53 | 14 | 86.4 | 0 | 166 | 8 | 111 | 163 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 315 | 92.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 27209620 | 27209620 | PRJNA704949_P_NODE_647602_length_336_cov_1.993031_g632276_i0 | PRJNA704949 | 647602 | 336 | 1.993031 | 6.69658416 | Erysiphe necator associated totivirus 8 | 2737098 | Viruses | Viruses | 75.9 | 2.7e-13 | NR | WAK77400.1 | 2737098 | g632276 | i0 | 48 | 0.669642857142857 | 75 | 39 | 67 | 0 | 336 | 112 | 723 | 797 | WAK77400.1 MAG: polyprotein [Erysiphe necator associated totivirus 8] | diamond | 225 | 75.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 8 | ||
| 27841297 | 27841297 | PRJNA704949_P_NODE_614784_length_346_cov_1.400673_g599460_i0 | PRJNA704949 | 614784 | 346 | 1.400673 | 4.84632858 | Scheffersomyces segobiensis virus L | 1300323 | Viruses | Viruses | 101 | 3.54e-22 | NR | YP_009507830.1 | 1300323 | g599460 | i0 | 46.2 | 1.83815028901734 | 106 | 56 | 91 | 1 | 27 | 341 | 226 | 331 | YP_009507830.1 capsid [Scheffersomyces segobiensis virus L] | diamond | 636 | 101 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus roku | ||
| 29482845 | 29482845 | PRJNA704949_P_NODE_1890970_length_171_cov_1.688525_g1875631_i0 | PRJNA704949 | 1890970 | 171 | 1.688525 | 2.88737775 | Geotrichum candidum totivirus 4 | 3075233 | Viruses | Viruses | 44.7 | 0.00293 | NR | WMZ16835.1 | 3075233 | g1875631 | i0 | 41.1 | 0.982456140350877 | 56 | 32 | 96.5 | 1 | 169 | 5 | 68 | 123 | WMZ16835.1 RNA-dependent RNA polymerase [Geotrichum candidum totivirus 4] | diamond | 168 | 44.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Geotrichum candidum totivirus 4 | ||
| 30525722 | 30525722 | PRJNA704949_P_NODE_928413_length_272_cov_2.246637_g913079_i0 | PRJNA704949 | 928413 | 272 | 2.246637 | 6.11085264 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 103 | 1.5699999999999994e-23 | NR | CAI9858976.1 | 3048757 | g913079 | i0 | 60.7 | 0.981617647058823 | 89 | 35 | 98.2 | 0 | 269 | 3 | 166 | 254 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 267 | 103 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 30694250 | 30694250 | PRJNA704949_P_NODE_1206593_length_231_cov_1.972527_g1191256_i0 | PRJNA704949 | 1206593 | 231 | 1.972527 | 4.55653737 | Ghabrivirales | 2732540 | Viruses | Viruses | 70.5 | 5.27e-12 | NR | WAK77686.1 | 1955172 | g1191256 | i0 | 53.6 | 3.62337662337662 | 69 | 29 | 85.7 | 2 | 214 | 17 | 479 | 547 | WAK77686.1 MAG: capsid protein [Totiviridae sp.] | diamond | 837 | 70.9 | 0.994358251057828 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 30883898 | 30883898 | PRJNA704949_P_NODE_2185974_length_160_cov_2.765766_g2170635_i0 | PRJNA704949 | 2185974 | 160 | 2.765766 | 4.4252256 | Totivirus | 11007 | Viruses | Viruses | 80.1 | 7.52e-16 | NR | QOQ37362.1 | 2776824 | g2170635 | i0 | 73.6 | 1.9875 | 53 | 14 | 99.4 | 0 | 159 | 1 | 187 | 239 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 318 | 80.9 | 0.990111248454882 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 31283761 | 31283761 | PRJNA704949_P_NODE_1896695_length_171_cov_1.278689_g1881356_i0 | PRJNA704949 | 1896695 | 171 | 1.278689 | 2.18655819 | Totiviridae sp. | 1955172 | Viruses | Viruses | 63.9 | 4.62e-10 | NR | WAK77450.1 | 1955172 | g1881356 | i0 | 65.2 | 0.807017543859649 | 46 | 16 | 80.7 | 0 | 140 | 3 | 262 | 307 | WAK77450.1 MAG: capsid protein [Totiviridae sp.] | diamond | 138 | 63.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31884832 | 31884832 | PRJNA704949_P_NODE_29057_length_1484_cov_2.907317_g20164_i0 | PRJNA704949 | 29057 | 1484 | 2.907317 | 43.14458428 | Totiviridae sp. | 1955172 | Viruses | Viruses | 306 | 9.26e-93 | NR | WAK77569.1 | 1955172 | g20164 | i0 | 38.3 | 1.9588948787062 | 486 | 283 | 96.4 | 6 | 1436 | 6 | 1 | 478 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 2907 | 306 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 32706840 | 32706840 | PRJNA704949_P_NODE_32380_length_1383_cov_5.925037_g23075_i0 | PRJNA704949 | 32380 | 1383 | 5.925037 | 81.94326171 | Totivirus sp. | 2776824 | Viruses | Viruses | 454 | 7.579999999999998e-157 | NR | QOQ37363.1 | 2776824 | g23075 | i0 | 88.8 | 0.544468546637744 | 251 | 28 | 54.4 | 0 | 456 | 1208 | 1 | 251 | QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 753 | 454 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. |
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);;