contig_metadata
11 rows where bioproject = "PRJNA1148190", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3585573 | 3585573 | PRJNA1148190_P_NODE_413643_length_283_cov_3.090476_g402470_i0 | PRJNA1148190 | 413643 | 283 | 3.090476 | 8.74604708 | Totivirus | 11007 | Viruses | Viruses | 501 | 2.1599999999999998e-137 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g402470 | i0 | 98.587 | 4.34628975265018 | 283 | 4 | 100 | 0 | 1 | 283 | 4309 | 4591 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 1230 | 501 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 7952689 | 7952689 | PRJNA1148190_P_NODE_73827_length_644_cov_1.583187_g62724_i0 | PRJNA1148190 | 73827 | 644 | 1.583187 | 10.19572428 | Totivirus ni | 3432954 | Viruses | Viruses | 1182 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g62724 | i0 | 99.844 | 6.38509316770186 | 643 | 1 | 99 | 0 | 2 | 644 | 1892 | 2534 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 4112 | 1182 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 9225843 | 9225843 | PRJNA1148190_P_NODE_597208_length_250_cov_2.282486_g586035_i0 | PRJNA1148190 | 597208 | 250 | 2.282486 | 5.706215 | Totivirus ichi | 3432942 | Viruses | Viruses | 451 | 1.91e-122 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g586035 | i0 | 99.2 | 21.1 | 250 | 2 | 100 | 0 | 1 | 250 | 1853 | 2102 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 5275 | 451 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 13045001 | 13045001 | PRJNA1148190_P_NODE_156111_length_421_cov_1.327586_g144944_i0 | PRJNA1148190 | 156111 | 421 | 1.327586 | 5.58913706 | Totivirus ichi | 3432942 | Viruses | Viruses | 778 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g144944 | i0 | 100 | 3.37054631828979 | 421 | 0 | 100 | 0 | 1 | 421 | 2753 | 3173 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1419 | 778 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 13045880 | 13045880 | PRJNA1148190_P_NODE_208971_length_369_cov_3.361486_g197801_i0 | PRJNA1148190 | 208971 | 369 | 3.361486 | 12.40388334 | Totivirus ni | 3432954 | Viruses | Viruses | 682 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g197801 | i0 | 100 | 3 | 369 | 0 | 100 | 0 | 1 | 369 | 387 | 19 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 1107 | 682 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 14323220 | 14323220 | PRJNA1148190_P_NODE_342032_length_303_cov_1.800000_g330859_i0 | PRJNA1148190 | 342032 | 303 | 1.8 | 5.454 | Totivirus ichi | 3432942 | Viruses | Viruses | 549 | 8.209999999999997e-152 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g330859 | i0 | 99.34 | 5.78547854785479 | 303 | 2 | 100 | 0 | 1 | 303 | 2325 | 2627 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1753 | 549 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 16870551 | 16870551 | PRJNA1148190_P_NODE_28734_length_1338_cov_2.422134_g19268_i0 | PRJNA1148190 | 28734 | 1338 | 2.422134 | 32.40815292 | Totivirus ni | 3432954 | Viruses | Viruses | 2444 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g19268 | i0 | 99.626 | 3 | 1338 | 5 | 100 | 0 | 1 | 1338 | 1918 | 581 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 4014 | 2444 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 18143269 | 18143269 | PRJNA1148190_P_NODE_167355_length_407_cov_1.943114_g156186_i0 | PRJNA1148190 | 167355 | 407 | 1.943114 | 7.90847398 | Totivirus ichi | 3432942 | Viruses | Viruses | 741 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g156186 | i0 | 99.509 | 5.6044226044226 | 407 | 2 | 100 | 0 | 1 | 407 | 3296 | 3702 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 2281 | 741 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 21969744 | 21969744 | PRJNA1148190_P_NODE_251558_length_342_cov_2.650558_g240388_i0 | PRJNA1148190 | 251558 | 342 | 2.650558 | 9.06490836 | Totivirus ichi | 3432942 | Viruses | Viruses | 621 | 1.9599999999999997e-173 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g240388 | i0 | 99.415 | 3 | 342 | 2 | 100 | 0 | 1 | 342 | 1318 | 1659 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 1026 | 621 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 21977308 | 21977308 | PRJNA1148190_P_NODE_83778_length_594_cov_1.696737_g72647_i0 | PRJNA1148190 | 83778 | 594 | 1.696737 | 10.07861778 | Totivirus ni | 3432954 | Viruses | Viruses | 1070 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g72647 | i0 | 99.158 | 2 | 594 | 5 | 100 | 0 | 1 | 594 | 2797 | 3390 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 1188 | 1070 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 24519878 | 24519878 | PRJNA1148190_P_NODE_317880_length_312_cov_1.933054_g306707_i0 | PRJNA1148190 | 317880 | 312 | 1.933054 | 6.03112848 | Totivirus ni | 3432954 | Viruses | Viruses | 555 | 1.8199999999999994e-153 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g306707 | i0 | 98.718 | 2 | 312 | 4 | 100 | 0 | 1 | 312 | 3533 | 3844 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 624 | 555 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni |
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);;