contig_metadata
6 rows where bioproject = "PRJNA513467", tax_phylum = "Kitrinoviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486658 | 486658 | PRJNA513467_S_NODE_5481_length_175_cov_1.586957_g5458_i0 | PRJNA513467 | 5481 | 175 | 1.586957 | 2.77717475 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 270 | 3.739999999999999e-68 | NTclustered | gi|1240393784|gb|MF141071.1| | 2034334 | g5458 | i0 | 96.341 | 3.76 | 164 | 6 | 94 | 0 | 3 | 166 | 2018 | 1855 | Norway luteo-like virus 4 isolate NOR/S5/Kilen/2014 RNA-dependent RNA-polymerase gene, partial cds | blastn | 658 | 270 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 3037698 | 3037698 | PRJNA513467_S_NODE_1203_length_306_cov_2.375465_g1180_i0 | PRJNA513467 | 1203 | 306 | 2.375465 | 7.2689229 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 553 | 6.419999999999998e-153 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g1180 | i0 | 99.669 | 2.91830065359477 | 302 | 1 | 99 | 0 | 5 | 306 | 4522 | 4221 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 893 | 553 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 10690438 | 10690438 | PRJNA513467_S_NODE_2809_length_221_cov_2.505435_g2786_i0 | PRJNA513467 | 2809 | 221 | 2.505435 | 5.53701135 | Allexivirus ecsallii | 3433712 | Viruses | Viruses | 375 | 1.0199999999999998e-99 | NTclustered | gi|1722561625|gb|MN059411.1| | 150284 | g2786 | i0 | 97.285 | 93.5927601809955 | 221 | 6 | 100 | 0 | 1 | 221 | 7874 | 7654 | Garlic virus X isolate G40, complete genome | blastn | 20684 | 375 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus ecsallii | ||
| 10690474 | 10690474 | PRJNA513467_S_NODE_549_length_421_cov_2.140625_g526_i0 | PRJNA513467 | 549 | 421 | 2.140625 | 9.01203125 | Allexivirus ecsallii | 3433712 | Viruses | Viruses | 656 | 0 | NTclustered | gi|410131120|gb|JQ807994.1| | 150284 | g526 | i0 | 94.774 | 89.1615201900238 | 421 | 22 | 100 | 0 | 1 | 421 | 7948 | 8368 | Garlic virus X isolate SW3, complete genome | blastn | 37537 | 656 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus ecsallii | ||
| 11965447 | 11965447 | PRJNA513467_S_NODE_530_length_426_cov_5.053985_g507_i0 | PRJNA513467 | 530 | 426 | 5.053985 | 21.5299761 | Erysiphe necator associated deltaflexivirus 4 | 2743097 | Viruses | Viruses | 754 | 0 | NTclustered | gi|2288523299|gb|ON811606.1| | 2743097 | g507 | i0 | 100 | 3.13145539906103 | 408 | 0 | 96 | 0 | 19 | 426 | 7113 | 6706 | MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome | blastn | 1334 | 754 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 4 | ||
| 14515608 | 14515608 | PRJNA513467_S_NODE_2852_length_220_cov_5.464481_g2829_i0 | PRJNA513467 | 2852 | 220 | 5.464481 | 12.0218582 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 407 | 3.61e-109 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g2829 | i0 | 100 | 1 | 220 | 0 | 100 | 0 | 1 | 220 | 5759 | 5540 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 220 | 407 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 |
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);;