contig_metadata
5 rows where bioproject = "PRJNA939369", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21316570 | 21316570 | PRJNA939369_S_NODE_61757_length_248_cov_0.880000_g61340_i0 | PRJNA939369 | 61757 | 248 | 0.88 | 2.1824 | Orthoflavivirus denguei | 3052464 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2126762592|gb|OL314736.1| | 11070 | g61340 | i0 | 100 | 0.67741935483871 | 28 | 0 | 11 | 0 | 57 | 84 | 9735 | 9762 | Dengue virus 4 isolate JBB-007, complete genome | blastn | 168 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 21316707 | 21316707 | PRJNA939369_S_NODE_79837_length_213_cov_12.328571_g79420_i0 | PRJNA939369 | 79837 | 213 | 12.328571 | 26.25985623 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g79420 | i0 | 100 | 0.7981220657277 | 29 | 0 | 14 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 170 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 22591253 | 22591253 | PRJNA939369_S_NODE_18578_length_345_cov_17.915441_g18161_i0 | PRJNA939369 | 18578 | 345 | 17.915441 | 61.80827145 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g18161 | i0 | 94.444 | 0.510144927536232 | 36 | 2 | 10 | 0 | 310 | 345 | 48 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 176 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 25140423 | 25140423 | PRJNA939369_S_NODE_28400_length_305_cov_2.383621_g27983_i0 | PRJNA939369 | 28400 | 305 | 2.383621 | 7.27004405 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g27983 | i0 | 100 | 0.462295081967213 | 29 | 0 | 10 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 30088126 | 30088126 | PRJNA939369_S_NODE_3792_length_602_cov_2.421550_g3386_i0 | PRJNA939369 | 3792 | 602 | 2.42155 | 14.577731 | Qianjiang noda-like virus 72 | 3348660 | Viruses | Viruses | 52 | 5.83e-4 | NR | XHA86042.1 | 3348660 | g3386 | i0 | 26.6 | 0.712624584717608 | 143 | 101 | 70.8 | 3 | 599 | 174 | 475 | 614 | XHA86042.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang noda-like virus 72] | diamond | 429 | 52 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 72 |
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);;