contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA683902" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 665337 | 665337 | PRJNA683902_S_NODE_30901_length_175_cov_1.942029_g30457_i0 | PRJNA683902 | 30901 | 175 | 1.942029 | 3.39855075 | Gnomoniopsis castaneae mitovirus 1 | 3115468 | Viruses | Viruses | 100 | 5.19e-17 | NTclustered | gi|2654366799|gb|PP133326.1| | 3115468 | g30457 | i0 | 85.417 | 0.548571428571429 | 96 | 14 | 55 | 0 | 80 | 175 | 1744 | 1649 | Gnomoniopsis castaneae mitovirus 1 RdRp gene, complete cds | blastn | 96 | 100 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Gnomoniopsis castaneae mitovirus 1 | ||
| 1941325 | 1941325 | PRJNA683902_S_NODE_322_length_4645_cov_374.651476_g304_i0 | PRJNA683902 | 322 | 4645 | 374.651476 | 17402.5610602 | Totivirus ni | 3432954 | Viruses | Viruses | 8357 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g304 | i0 | 99.35 | 3.92960172228202 | 4616 | 28 | 99 | 2 | 9 | 4623 | 4615 | 1 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 18253 | 8357 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 3216157 | 3216157 | PRJNA683902_S_NODE_25363_length_201_cov_1.189024_g24919_i0 | PRJNA683902 | 25363 | 201 | 1.189024 | 2.38993824 | Phomopsis viticola mitovirus 962_1 | 2836441 | Viruses | Viruses | 311 | 2.61e-80 | NTclustered | gi|2048077198|gb|MZ050806.1| | 2836441 | g24919 | i0 | 95 | 0.995024875621891 | 200 | 7 | 99 | 3 | 2 | 200 | 212 | 409 | Phomopsis viticola mitovirus 962_1 RNA-dependent RNA polymerase gene, complete cds | blastn | 200 | 311 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Phomopsis viticola mitovirus 962_1 | ||
| 4493182 | 4493182 | PRJNA683902_S_NODE_20804_length_231_cov_2.376289_g20360_i0 | PRJNA683902 | 20804 | 231 | 2.376289 | 5.48922759 | Ripaglys virus | 3130696 | Viruses | Viruses | 176 | 1.17e-39 | NTclustered | gi|2717320496|gb|PP172998.1| | 3130696 | g20360 | i0 | 86.667 | 19.0779220779221 | 165 | 14 | 70 | 8 | 62 | 222 | 2145 | 2305 | MAG: Ripaglys virus isolate KCAP2_k141_358354 genomic sequence | blastn | 4407 | 176 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaglys virus | |||||
| 4493300 | 4493300 | PRJNA683902_S_NODE_34944_length_162_cov_1.872000_g34500_i0 | PRJNA683902 | 34944 | 162 | 1.872 | 3.03264 | Alternaria dianthicola narnavirus 1 | 2992030 | Viruses | Viruses | 126 | 7.83e-25 | NTclustered | gi|2324515426|gb|ON843756.1| | 2992030 | g34500 | i0 | 86.441 | 0.728395061728395 | 118 | 12 | 72 | 4 | 9 | 124 | 1440 | 1325 | Alternaria dianthicola narnavirus 1 isolate HNSZ-1 RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 118 | 126 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Alternaria dianthicola narnavirus 1 | ||
| 12144719 | 12144719 | PRJNA683902_S_NODE_32410_length_170_cov_1.466165_g31966_i0 | PRJNA683902 | 32410 | 170 | 1.466165 | 2.4924805 | Phomopsis viticola mitovirus 962_1 | 2836441 | Viruses | Viruses | 270 | 3.61e-68 | NTclustered | gi|2048077198|gb|MZ050806.1| | 2836441 | g31966 | i0 | 95.294 | 1 | 170 | 8 | 100 | 0 | 1 | 170 | 1862 | 2031 | Phomopsis viticola mitovirus 962_1 RNA-dependent RNA polymerase gene, complete cds | blastn | 170 | 270 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Phomopsis viticola mitovirus 962_1 | ||
| 12144722 | 12144722 | PRJNA683902_S_NODE_330_length_4577_cov_602.165639_g312_i0 | PRJNA683902 | 330 | 4577 | 602.165639 | 27561.12129703 | Totivirus ichi | 3432942 | Viruses | Viruses | 8287 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g312 | i0 | 99.495 | 23.8029276818877 | 4556 | 23 | 99 | 0 | 19 | 4574 | 4579 | 24 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 108946 | 8287 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 23618202 | 23618202 | PRJNA683902_S_NODE_30139_length_178_cov_1.432624_g29695_i0 | PRJNA683902 | 30139 | 178 | 1.432624 | 2.55007072 | Phomopsis viticola mitovirus 962_1 | 2836441 | Viruses | Viruses | 298 | 1.75e-76 | NTclustered | gi|2048077198|gb|MZ050806.1| | 2836441 | g29695 | i0 | 97.701 | 0.97752808988764 | 174 | 3 | 97 | 1 | 6 | 178 | 1771 | 1598 | Phomopsis viticola mitovirus 962_1 RNA-dependent RNA polymerase gene, complete cds | blastn | 174 | 298 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Phomopsis viticola mitovirus 962_1 |
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);;