contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA558770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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);;