contig_metadata
8 rows where bioproject = "PRJNA495391" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4303079 | 4303079 | PRJNA495391_S_NODE_30344_length_220_cov_1.875676_g29292_i0 | PRJNA495391 | 30344 | 220 | 1.875676 | 4.1264872 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 252 | 1.79e-62 | NTclustered | gi|2320142628|gb|ON585088.1| | 2808997 | g29292 | i0 | 87.387 | 1.00909090909091 | 222 | 24 | 100 | 4 | 1 | 220 | 2430 | 2211 | MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds | blastn | 222 | 252 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 6210681 | 6210681 | PRJNA495391_S_NODE_33685_length_210_cov_1.428571_g32633_i0 | PRJNA495391 | 33685 | 210 | 1.428571 | 2.9999991 | Botourmiaviridae | 2560063 | Viruses | Viruses | 75 | 3.93e-9 | NTclustered | gi|2500381378|ref|NC_076801.1| | 2686545 | g32633 | i0 | 100 | 5.76190476190476 | 40 | 0 | 19 | 0 | 1 | 40 | 2325 | 2286 | Plasmopara viticola lesion associated ourmia-like virus 72 isolate DMG-F_43929 RNA dependent RNA polymerase (QKR77_gp1) gene, complete cds | blastn | 1210 | 75 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus lambdaplasmoparae | ||
| 8128812 | 8128812 | PRJNA495391_S_NODE_14607_length_313_cov_2.262590_g13555_i0 | PRJNA495391 | 14607 | 313 | 2.26259 | 7.0819067 | Jakapalmivirus cinereae | 3429993 | Viruses | Viruses | 484 | 2.4399999999999998e-132 | NTclustered | gi|1841761922|gb|MN619795.1| | 2802527 | g13555 | i0 | 94.569 | 2.96805111821086 | 313 | 17 | 100 | 0 | 1 | 313 | 638 | 326 | Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence | blastn | 929 | 484 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus cinereae | ||
| 11954891 | 11954891 | PRJNA495391_S_NODE_29170_length_224_cov_1.751323_g28118_i0 | PRJNA495391 | 29170 | 224 | 1.751323 | 3.92296352 | Jakapalmivirus cinereae | 3429993 | Viruses | Viruses | 387 | 4.8e-103 | NTclustered | gi|1841761922|gb|MN619795.1| | 2802527 | g28118 | i0 | 97.768 | 3.97321428571429 | 224 | 5 | 100 | 0 | 1 | 224 | 596 | 819 | Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence | blastn | 890 | 387 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus cinereae | ||
| 17053729 | 17053729 | PRJNA495391_S_NODE_37294_length_200_cov_1.878788_g36242_i0 | PRJNA495391 | 37294 | 200 | 1.878788 | 3.757576 | Jakapalmivirus cinereae | 3429993 | Viruses | Viruses | 359 | 9.14e-95 | NTclustered | gi|1841761922|gb|MN619795.1| | 2802527 | g36242 | i0 | 99 | 6.865 | 200 | 2 | 100 | 0 | 1 | 200 | 1968 | 1769 | Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence | blastn | 1373 | 359 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus cinereae | ||
| 18328722 | 18328722 | PRJNA495391_S_NODE_63495_length_157_cov_2.614754_g62443_i0 | PRJNA495391 | 63495 | 157 | 2.614754 | 4.10516378 | Jakapalmivirus cinereae | 3429993 | Viruses | Viruses | 279 | 5.46e-71 | NTclustered | gi|1841761922|gb|MN619795.1| | 2802527 | g62443 | i0 | 98.726 | 3.98726114649682 | 157 | 2 | 100 | 0 | 1 | 157 | 2234 | 2078 | Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence | blastn | 626 | 279 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus cinereae | ||
| 19601684 | 19601684 | PRJNA495391_S_NODE_14536_length_314_cov_1.792115_g13484_i0 | PRJNA495391 | 14536 | 314 | 1.792115 | 5.6272411 | Jakapalmivirus cinereae | 3429993 | Viruses | Viruses | 560 | 3.95e-155 | NTclustered | gi|1841761922|gb|MN619795.1| | 2802527 | g13484 | i0 | 99.038 | 1.99363057324841 | 312 | 3 | 99 | 0 | 3 | 314 | 1602 | 1291 | Botrytis cinerea binarnavirus 1 isolate BCI12_DN4441 segment 1, complete sequence | blastn | 626 | 560 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus cinereae | ||
| 22152888 | 22152888 | PRJNA495391_S_NODE_34658_length_207_cov_1.761628_g33606_i0 | PRJNA495391 | 34658 | 207 | 1.761628 | 3.64656996 | Erysiphe necator associated ourmia-like virus 78 | 2741858 | Viruses | Viruses | 344 | 2.67e-90 | NTclustered | gi|1848976689|gb|MN611606.1| | 2741858 | g33606 | i0 | 96.618 | 2.84541062801932 | 207 | 7 | 100 | 0 | 1 | 207 | 2126 | 1920 | Erysiphe necator associated ourmia-like virus 78 isolate PMS3_72, complete genome | blastn | 589 | 344 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 78 |
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);;