contig_metadata
17 rows where bioproject = "PRJNA558770", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3094287 | 3094287 | PRJNA558770_P_NODE_9643_length_587_cov_2.797101_g8101_i0 | PRJNA558770 | 9643 | 587 | 2.797101 | 16.41898287 | Totivirus ichi | 3432942 | Viruses | Viruses | 1068 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g8101 | i0 | 99.658 | 20.2112436115843 | 584 | 2 | 99 | 0 | 2 | 585 | 1569 | 2152 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 11864 | 1068 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 5644487 | 5644487 | PRJNA558770_P_NODE_29485_length_394_cov_8.128134_g27517_i0 | PRJNA558770 | 29485 | 394 | 8.128134 | 32.02484796 | Totivirus ichi | 3432942 | Viruses | Viruses | 725 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g27517 | i0 | 100 | 2.98477157360406 | 392 | 0 | 99 | 0 | 1 | 392 | 742 | 351 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1176 | 725 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 8190996 | 8190996 | PRJNA558770_P_NODE_14907_length_498_cov_6.807775_g13157_i0 | PRJNA558770 | 14907 | 498 | 6.807775 | 33.9027195 | Totivirus ichi | 3432942 | Viruses | Viruses | 490 | 8.699999999999998e-134 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g13157 | i0 | 100 | 3.24096385542169 | 265 | 0 | 92 | 0 | 234 | 498 | 2905 | 3169 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1614 | 490 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 10744064 | 10744064 | PRJNA558770_P_NODE_237369_length_234_cov_2.608040_g235364_i0 | PRJNA558770 | 237369 | 234 | 2.60804 | 6.1028136 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 141 | 4.35e-29 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g235364 | i0 | 100 | 0.636752136752137 | 76 | 0 | 64 | 0 | 159 | 234 | 271 | 196 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 149 | 141 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 13295932 | 13295932 | PRJNA558770_P_NODE_39851_length_337_cov_9.122517_g37856_i0 | PRJNA558770 | 39851 | 337 | 9.122517 | 30.74288229 | Totivirus ichi | 3432942 | Viruses | Viruses | 547 | 3.329999999999999e-151 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g37856 | i0 | 96.45 | 3.00890207715134 | 338 | 1 | 100 | 2 | 1 | 337 | 1484 | 1157 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1014 | 547 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 14571404 | 14571404 | PRJNA558770_P_NODE_62572_length_264_cov_2.471616_g60567_i0 | PRJNA558770 | 62572 | 264 | 2.471616 | 6.52506624 | Totivirus ichi | 3432942 | Viruses | Viruses | 292 | 1.31e-74 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g60567 | i0 | 100 | 4.33712121212121 | 158 | 0 | 95 | 0 | 107 | 264 | 3508 | 3351 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1145 | 292 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 23493502 | 23493502 | PRJNA558770_P_NODE_325359_length_233_cov_7.429293_g323354_i0 | PRJNA558770 | 325359 | 233 | 7.429293 | 17.31025269 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 141 | 4.33e-29 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g323354 | i0 | 100 | 0.630901287553648 | 76 | 0 | 63 | 0 | 158 | 233 | 738 | 663 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 147 | 141 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 23495091 | 23495091 | PRJNA558770_P_NODE_72539_length_244_cov_1.741627_g70534_i0 | PRJNA558770 | 72539 | 244 | 1.741627 | 4.24956988 | Totivirus ichi | 3432942 | Viruses | Viruses | 158 | 4.53e-34 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g70534 | i0 | 100 | 2.97131147540984 | 85 | 0 | 65 | 0 | 1 | 85 | 2419 | 2335 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 725 | 158 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 24764635 | 24764635 | PRJNA558770_P_NODE_161540_length_234_cov_5.663317_g159535_i0 | PRJNA558770 | 161540 | 234 | 5.663317 | 13.25216178 | Totivirus ichi | 3432942 | Viruses | Viruses | 141 | 4.35e-29 | NTclustered | gi|556414|gb|M28353.1|SCSL1A | 11008 | g159535 | i0 | 100 | 1.96153846153846 | 76 | 0 | 65 | 0 | 159 | 234 | 281 | 356 | Saccharomyces cerevisiae virus L-A L1 segment capsid protein and RNA polymerase gene, complete cds | blastn | 459 | 141 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 27078895 | 27078895 | PRJNA558770_P_NODE_201442_length_234_cov_3.728643_g199437_i0 | PRJNA558770 | 201442 | 234 | 3.728643 | 8.72502462 | Totiviridae sp. | 1955172 | Viruses | Viruses | 47 | 0.00105 | NR | WAK77569.1 | 1955172 | g199437 | i0 | 86.4 | 0.282051282051282 | 22 | 3 | 28.2 | 0 | 167 | 232 | 539 | 560 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 66 | 47 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 28026531 | 28026531 | PRJNA558770_P_NODE_133405_length_234_cov_7.788945_g131400_i0 | PRJNA558770 | 133405 | 234 | 7.788945 | 18.2261313 | Botrytis cinerea botybirnavirus 2 | 2735874 | Viruses | Viruses | 45.8 | 0.00286 | NR | QJT73738.1 | 2735874 | g131400 | i0 | 35.1 | 0.987179487179487 | 77 | 48 | 98.7 | 1 | 4 | 234 | 672 | 746 | QJT73738.1 hypothetical protein [Botrytis cinerea botybirnavirus 2] | diamond | 231 | 45.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Botybirnaviridae | Botybirnavirus | Botybirnavirus kyu | ||
| 29037042 | 29037042 | PRJNA558770_P_NODE_170108_length_234_cov_5.160804_g168103_i0 | PRJNA558770 | 170108 | 234 | 5.160804 | 12.07628136 | Fusarium oxysporum chrysovirus 1 | 434898 | Viruses | Viruses | 45.8 | 0.00206 | NR | YP_009665201.1 | 434898 | g168103 | i0 | 35.1 | 0.987179487179487 | 77 | 31 | 98.7 | 1 | 2 | 232 | 6 | 63 | YP_009665201.1 coat protein, partial [Fusarium oxysporum chrysovirus 1] | diamond | 231 | 45.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus fusarii | ||
| 30868705 | 30868705 | PRJNA558770_P_NODE_239154_length_234_cov_2.562814_g237149_i0 | PRJNA558770 | 239154 | 234 | 2.562814 | 5.99698476 | Penicillium roseopurpureum chrysovirus 1 | 2485919 | Viruses | Viruses | 68.6 | 2.74e-11 | NR | AYP71814.1 | 2485919 | g237149 | i0 | 49.4 | 0.987179487179487 | 77 | 36 | 98.7 | 1 | 4 | 234 | 304 | 377 | AYP71814.1 hypothetical protein [Penicillium roseopurpureum chrysovirus 1] | diamond | 231 | 68.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus penicillii | ||
| 31374612 | 31374612 | PRJNA558770_P_NODE_119976_length_234_cov_9.211055_g117971_i0 | PRJNA558770 | 119976 | 234 | 9.211055 | 21.5538687 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 48.1 | 4.26e-4 | NR | CAI9858976.1 | 3048757 | g117971 | i0 | 83.3 | 0.307692307692308 | 24 | 4 | 30.8 | 0 | 75 | 4 | 242 | 265 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 72 | 48.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 32274536 | 32274536 | PRJNA558770_P_NODE_162998_length_234_cov_5.572864_g160993_i0 | PRJNA558770 | 162998 | 234 | 5.572864 | 13.04050176 | Ghabrivirales | 2732540 | Viruses | Viruses | 49.3 | 1.6e-4 | NR | AOX47598.1 | 1905690 | g160993 | i0 | 31.6 | 8.71794871794872 | 76 | 40 | 97.4 | 1 | 6 | 233 | 251 | 314 | AOX47598.1 RNA-dependent RNA polymerase, partial [Pterostylis totivirus-like] | diamond | 2040 | 49.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Pterostylis totivirus-like | ||
| 32891342 | 32891342 | PRJNA558770_P_NODE_208960_length_234_cov_3.452261_g206955_i0 | PRJNA558770 | 208960 | 234 | 3.452261 | 8.07829074 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 48.1 | 4.09e-4 | NR | CAI9858974.1 | 3048756 | g206955 | i0 | 84 | 0.320512820512821 | 25 | 4 | 32.1 | 0 | 2 | 76 | 647 | 671 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 75 | 48.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 32891365 | 32891365 | PRJNA558770_P_NODE_335840_length_233_cov_4.777778_g333835_i0 | PRJNA558770 | 335840 | 233 | 4.777778 | 11.13222274 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 53.9 | 3.74e-6 | NR | CAI9858976.1 | 3048757 | g333835 | i0 | 100 | 0.296137339055794 | 23 | 0 | 29.6 | 0 | 3 | 71 | 375 | 397 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 69 | 53.9 | 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);;