contig_metadata
10 rows where bioproject = "PRJNA1005695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3979859 | 3979859 | PRJNA1005695_P_NODE_20864_length_330_cov_1.400778_g20012_i0 | PRJNA1005695 | 20864 | 330 | 1.400778 | 4.6225674 | Totivirus ichi | 3432942 | Viruses | Viruses | 610 | 4.09e-170 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g20012 | i0 | 100 | 3 | 330 | 0 | 100 | 0 | 1 | 330 | 952 | 623 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 990 | 610 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 5256434 | 5256434 | PRJNA1005695_P_NODE_26345_length_291_cov_4.311927_g25493_i0 | PRJNA1005695 | 26345 | 291 | 4.311927 | 12.54770757 | Totivirus ichi | 3432942 | Viruses | Viruses | 529 | 1.0199999999999996e-145 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g25493 | i0 | 99.654 | 2.97938144329897 | 289 | 1 | 99 | 0 | 3 | 291 | 1733 | 1445 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 867 | 529 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 7806184 | 7806184 | PRJNA1005695_P_NODE_38687_length_245_cov_0.906977_g37835_i0 | PRJNA1005695 | 38687 | 245 | 0.906977 | 2.22209365 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 444 | 3.12e-120 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g37835 | i0 | 99.588 | 0.991836734693878 | 243 | 1 | 99 | 0 | 3 | 245 | 2376 | 2618 | Malassezia restricta virus MrV40L, complete genome | blastn | 243 | 444 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 10356708 | 10356708 | PRJNA1005695_P_NODE_32569_length_261_cov_1.659574_g31717_i0 | PRJNA1005695 | 32569 | 261 | 1.659574 | 4.33148814 | Totivirus ichi | 3432942 | Viruses | Viruses | 483 | 7.12e-132 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g31717 | i0 | 100 | 3 | 261 | 0 | 100 | 0 | 1 | 261 | 1169 | 909 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 783 | 483 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 11632283 | 11632283 | PRJNA1005695_P_NODE_9310_length_511_cov_3.075342_g8461_i0 | PRJNA1005695 | 9310 | 511 | 3.075342 | 15.71499762 | Totivirus ichi | 3432942 | Viruses | Viruses | 926 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g8461 | i0 | 99.412 | 20.7495107632094 | 510 | 3 | 99 | 0 | 1 | 510 | 2429 | 1920 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 10603 | 926 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 20554697 | 20554697 | PRJNA1005695_P_NODE_27457_length_285_cov_2.235849_g26605_i0 | PRJNA1005695 | 27457 | 285 | 2.235849 | 6.37216965 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 516 | 7.77e-142 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g26605 | i0 | 99.298 | 1 | 285 | 2 | 100 | 0 | 1 | 285 | 494 | 778 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 285 | 516 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 21830214 | 21830214 | PRJNA1005695_P_NODE_15618_length_384_cov_3.295820_g14766_i0 | PRJNA1005695 | 15618 | 384 | 3.29582 | 12.655948800000001 | Totivirus ichi | 3432942 | Viruses | Viruses | 697 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g14766 | i0 | 99.737 | 5.46354166666667 | 380 | 1 | 99 | 0 | 5 | 384 | 2516 | 2895 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 2098 | 697 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 23105724 | 23105724 | PRJNA1005695_P_NODE_23519_length_310_cov_1.316456_g22667_i0 | PRJNA1005695 | 23519 | 310 | 1.316456 | 4.0810136 | Totivirus ichi | 3432942 | Viruses | Viruses | 573 | 4.999999999999998e-159 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g22667 | i0 | 100 | 3 | 310 | 0 | 100 | 0 | 1 | 310 | 3376 | 3067 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 930 | 573 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 24379628 | 24379628 | PRJNA1005695_P_NODE_35780_length_250_cov_4.214689_g34928_i0 | PRJNA1005695 | 35780 | 250 | 4.214689 | 10.5367225 | Totivirus ichi | 3432942 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g34928 | i0 | 100 | 3 | 250 | 0 | 100 | 0 | 1 | 250 | 1180 | 1429 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 750 | 462 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 30128962 | 30128962 | PRJNA1005695_P_NODE_38432_length_245_cov_1.337209_g37580_i0 | PRJNA1005695 | 38432 | 245 | 1.337209 | 3.27616205 | Reovirus GCRV1 | 1164802 | Viruses | Viruses | 162 | 7.37e-47 | NR | AFG73679.1 | 1164802 | g37580 | i0 | 95.1 | 0.991836734693878 | 81 | 4 | 99.2 | 0 | 244 | 2 | 135 | 215 | AFG73679.1 hypothetical protein [Reovirus GCRV104] | diamond | 243 | 162 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Reovirus GCRV104 |
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);;