contig_metadata
5 rows where bioproject = "PRJNA1120771" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1551279 | 1551279 | PRJNA1120771_S_NODE_5162_length_425_cov_7.905759_g4762_i0 | PRJNA1120771 | 5162 | 425 | 7.905759 | 33.59947575 | Magoulivirus jiplasmoparae | 2956162 | Viruses | Viruses | 743 | 0 | NTclustered | gi|2500381287|ref|NC_076761.1| | 2686494 | g4762 | i0 | 98.345 | 3.33411764705882 | 423 | 7 | 99 | 0 | 3 | 425 | 1882 | 2304 | Plasmopara viticola lesion associated ourmia-like virus 26 isolate DMS1_25556 RNA dependent RNA polymerase (QKR36_gp1) gene, complete cds | blastn | 1417 | 743 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae | ||
| 11755201 | 11755201 | PRJNA1120771_S_NODE_31630_length_217_cov_1.500000_g31230_i0 | PRJNA1120771 | 31630 | 217 | 1.5 | 3.255 | Neofusicoccum parvum narnavirus 1 | 2587532 | Viruses | Viruses | 291 | 3.729999999999999e-74 | NTclustered | gi|1682807473|gb|MK584833.1| | 2587532 | g31230 | i0 | 91.163 | 2.9815668202765 | 215 | 18 | 99 | 1 | 1 | 215 | 3119 | 2906 | MAG: Neofusicoccum parvum narnavirus 1 isolate CREA-VE-9AS3, complete sequence | blastn | 647 | 291 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Neofusicoccum parvum narnavirus 1 | ||
| 11755273 | 11755273 | PRJNA1120771_S_NODE_9370_length_343_cov_15.033333_g8970_i0 | PRJNA1120771 | 9370 | 343 | 15.033333 | 51.56433219 | Erysiphe necator associated ourmia-like virus 78 | 2741858 | Viruses | Viruses | 579 | 1.1999999999999996e-160 | NTclustered | gi|1848976689|gb|MN611606.1| | 2741858 | g8970 | i0 | 97.085 | 2.95626822157434 | 343 | 10 | 100 | 0 | 1 | 343 | 2280 | 1938 | Erysiphe necator associated ourmia-like virus 78 isolate PMS3_72, complete genome | blastn | 1014 | 579 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 78 | ||
| 14305586 | 14305586 | PRJNA1120771_S_NODE_4492_length_447_cov_4.247525_g4094_i0 | PRJNA1120771 | 4492 | 447 | 4.247525 | 18.98643675 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 372 | 2.9199999999999995e-98 | NTclustered | gi|2320142628|gb|ON585088.1| | 2808997 | g4094 | i0 | 83.293 | 0.923937360178971 | 413 | 59 | 91 | 10 | 41 | 447 | 2478 | 2070 | MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds | blastn | 413 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 19402422 | 19402422 | PRJNA1120771_S_NODE_17596_length_274_cov_3.281385_g17196_i0 | PRJNA1120771 | 17596 | 274 | 3.281385 | 8.9909949 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 449 | 7.64e-122 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g17196 | i0 | 96.337 | 1.99270072992701 | 273 | 10 | 99 | 0 | 1 | 273 | 1603 | 1875 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 546 | 449 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 |
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);;