contig_metadata
9 rows where bioproject = "PRJNA929922", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3457242 | 3457242 | PRJNA929922_P_NODE_14803_length_462_cov_1.979434_g14268_i0 | PRJNA929922 | 14803 | 462 | 1.979434 | 9.14498508 | Totivirus ni | 3432954 | Viruses | Viruses | 789 | 0 | NTclustered | gi|2581542379|gb|OR393309.1| | 42478 | g14268 | i0 | 99.312 | 4.93939393939394 | 436 | 3 | 94 | 0 | 1 | 436 | 436 | 1 | Saccharomyces cerevisiae virus L-BC (La) isolate LBC RNA-directed RNA polymerase gene, partial cds | blastn | 2282 | 789 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 7284675 | 7284675 | PRJNA929922_P_NODE_159866_length_241_cov_1.595238_g159326_i0 | PRJNA929922 | 159866 | 241 | 1.595238 | 3.84452358 | Totivirus ichi | 3432942 | Viruses | Viruses | 438 | 1.4299999999999999e-118 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g159326 | i0 | 99.583 | 2.98755186721992 | 240 | 1 | 99 | 0 | 2 | 241 | 3150 | 2911 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 720 | 438 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 7284953 | 7284953 | PRJNA929922_P_NODE_326_length_2748_cov_4.033645_g160_i0 | PRJNA929922 | 326 | 2748 | 4.033645 | 110.8445646 | Totivirus ni | 3432954 | Viruses | Viruses | 5031 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g160 | i0 | 99.709 | 4.12336244541485 | 2748 | 8 | 100 | 0 | 1 | 2748 | 2765 | 18 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 11331 | 5031 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 8559665 | 8559665 | PRJNA929922_P_NODE_2147_length_951_cov_3.743736_g1742_i0 | PRJNA929922 | 2147 | 951 | 3.743736 | 35.60292936 | Totivirus ichi | 3432942 | Viruses | Viruses | 1733 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g1742 | i0 | 99.579 | 2.99684542586751 | 950 | 4 | 99 | 0 | 1 | 950 | 1011 | 1960 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 2850 | 1733 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 13660580 | 13660580 | PRJNA929922_P_NODE_3911_length_727_cov_2.172783_g3429_i0 | PRJNA929922 | 3911 | 727 | 2.172783 | 15.79613241 | Totivirus ichi | 3432942 | Viruses | Viruses | 1288 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g3429 | i0 | 98.624 | 5.55295735900963 | 727 | 10 | 100 | 0 | 1 | 727 | 3850 | 3124 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 4037 | 1288 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 14934206 | 14934206 | PRJNA929922_P_NODE_144212_length_244_cov_0.900585_g143672_i0 | PRJNA929922 | 144212 | 244 | 0.900585 | 2.1974274 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2672713159|gb|OR645555.1| | 881914 | g143672 | i0 | 100 | 0.237704918032787 | 30 | 0 | 12 | 0 | 9 | 38 | 1972 | 1943 | MAG: Tribec virus isolate Romania segment 3, complete sequence | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 16209913 | 16209913 | PRJNA929922_P_NODE_3533_length_757_cov_2.491228_g3063_i0 | PRJNA929922 | 3533 | 757 | 2.491228 | 18.85859596 | Totivirus ni | 3432954 | Viruses | Viruses | 1371 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g3063 | i0 | 99.339 | 1.99735799207398 | 757 | 5 | 100 | 0 | 1 | 757 | 3549 | 2793 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 1512 | 1371 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 17485315 | 17485315 | PRJNA929922_P_NODE_49174_length_325_cov_1.813492_g48634_i0 | PRJNA929922 | 49174 | 325 | 1.813492 | 5.893849 | Totivirus ichi | 3432942 | Viruses | Viruses | 601 | 2.4199999999999993e-167 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g48634 | i0 | 100 | 5.06769230769231 | 325 | 0 | 100 | 0 | 1 | 325 | 2587 | 2911 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1647 | 601 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 25133595 | 25133595 | PRJNA929922_P_NODE_72980_length_287_cov_2.785047_g72440_i0 | PRJNA929922 | 72980 | 287 | 2.785047 | 7.9930848900000004 | Totivirus ichi | 3432942 | Viruses | Viruses | 501 | 2.19e-137 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g72440 | i0 | 99.278 | 2.89547038327526 | 277 | 2 | 97 | 0 | 11 | 287 | 855 | 579 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 831 | 501 | 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);;