contig_metadata
7 rows where bioproject = "PRJNA1240804", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2900083 | 2900083 | PRJNA1240804_P_NODE_91683_length_179_cov_0.969231_g91317_i0 | PRJNA1240804 | 91683 | 179 | 0.969231 | 1.73492349 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 300 | 4.9e-77 | NTclustered | gi|1805995756|gb|MN882044.1| | 1761477 | g91317 | i0 | 99.398 | 92.7374301675978 | 166 | 0 | 92 | 1 | 1 | 165 | 6279 | 6114 | Tomato brown rugose fruit virus isolate 39563388_A, complete genome | blastn | 16600 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 5452894 | 5452894 | PRJNA1240804_P_NODE_99725_length_173_cov_2.225806_g99359_i0 | PRJNA1240804 | 99725 | 173 | 2.225806 | 3.85064438 | Riponysc virus | 3130951 | Viruses | Viruses | 63.9 | 6.71e-6 | NTclustered | gi|2717321224|gb|PP173253.1| | 3130951 | g99359 | i0 | 95 | 0.23121387283237 | 40 | 2 | 23 | 0 | 12 | 51 | 179 | 218 | MAG: Riponysc virus isolate KCAP3_k141_285214 genomic sequence | blastn | 40 | 63.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Riponysc virus | |||
| 13101023 | 13101023 | PRJNA1240804_P_NODE_128711_length_165_cov_2.301724_g128345_i0 | PRJNA1240804 | 128711 | 165 | 2.301724 | 3.7978446 | Chrocorelt virus | 3129514 | Viruses | Viruses | 233 | 4.5899999999999994e-57 | NTclustered | gi|2717317772|gb|PP171962.1| | 3129514 | g128345 | i0 | 93.168 | 151.824242424242 | 161 | 8 | 96 | 3 | 7 | 165 | 2519 | 2678 | MAG: Chrocorelt virus isolate CC1B_k141_7916 genomic sequence | blastn | 25051 | 233 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Chrocorelt virus | ||||
| 13101459 | 13101459 | PRJNA1240804_P_NODE_15471_length_344_cov_6.681356_g15106_i0 | PRJNA1240804 | 15471 | 344 | 6.681356 | 22.98386464 | Tombusviridae sp. | 2583950 | Viruses | Viruses | 302 | 2.93e-77 | NTclustered | gi|2171146054|gb|MZ218543.1| | 2583950 | g15106 | i0 | 87.786 | 0.761627906976744 | 262 | 26 | 75 | 6 | 32 | 289 | 1 | 260 | MAG: Tombusviridae sp. isolate 277-k141_9923 genomic sequence | blastn | 262 | 302 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusviridae sp. | |||
| 16352271 | 16352271 | PRJNA1240804_P_NODE_100573_length_173_cov_1.298387_g100207_i0 | PRJNA1240804 | 100573 | 173 | 1.298387 | 2.24620951 | Tobamovirus | 12234 | Viruses | Viruses | 289 | 1.02e-73 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g100207 | i0 | 98.182 | 95.3757225433526 | 165 | 3 | 95 | 0 | 1 | 165 | 3789 | 3625 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 16500 | 289 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 20749798 | 20749798 | PRJNA1240804_P_NODE_43677_length_230_cov_1.165746_g43311_i0 | PRJNA1240804 | 43677 | 230 | 1.165746 | 2.6812158 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 381 | 2.309999999999999e-101 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g43311 | i0 | 98.611 | 89.9869565217391 | 216 | 2 | 93 | 1 | 2 | 216 | 3288 | 3073 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 20697 | 381 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 30705367 | 30705367 | PRJNA1240804_P_NODE_89634_length_180_cov_1.343511_g89268_i0 | PRJNA1240804 | 89634 | 180 | 1.343511 | 2.4183198 | Grapevine-associated tymo-like virus 2 | 2814378 | Viruses | Viruses | 86.3 | 3.73e-18 | NR | QXN75448.1 | 2814378 | g89268 | i0 | 76.6 | 0.783333333333333 | 47 | 11 | 78.3 | 0 | 148 | 8 | 1 | 47 | QXN75448.1 MAG: RNA-dependent RNA polymerase, partial [Grapevine-associated tymo-like virus 2] | diamond | 141 | 86.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Grapevine-associated tymo-like virus 2 |
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);;