contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26882940 | 26882940 | PRJNA1204310_P_NODE_721_length_1564_cov_2.091214_g635_i0 | PRJNA1204310 | 721 | 1564 | 2.091214 | 32.70658696 | Cryphonectria naterciae splipalmivirus 1 | 2841740 | Viruses | Viruses | 196 | 2.45e-51 | NR | BCX55509.1 | 2841740 | g635 | i0 | 32.7 | 0.966751918158568 | 504 | 284 | 92.5 | 17 | 115 | 1560 | 103 | 573 | BCX55509.1 putative RNA-dependent RNA polymerase [Cryphonectria naterciae splipalmivirus 1] | diamond | 1512 | 196 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus cryphonectriae | ||
| 28039108 | 28039108 | PRJNA1204310_P_NODE_2365_length_1033_cov_2.029167_g2167_i0 | PRJNA1204310 | 2365 | 1033 | 2.029167 | 20.96129511 | Narnavirus | 186767 | Viruses | Viruses | 138 | 1.91e-32 | NR | WZE65507.1 | 3139161 | g2167 | i0 | 30.3 | 2.03291384317522 | 350 | 183 | 99.6 | 8 | 1 | 1029 | 262 | 557 | WZE65507.1 RNA-dependent RNA polymerase [Ophiocordyceps sinensis narnavirus 4] | diamond | 2100 | 138 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Ophiocordyceps sinensis narnavirus 4 | ||
| 28714849 | 28714849 | PRJNA1204310_P_NODE_28887_length_345_cov_1.720588_g28590_i0 | PRJNA1204310 | 28887 | 345 | 1.720588 | 5.9360286 | Downy mildew lesion associated splipalmivirus 3 | 2719514 | Viruses | Viruses | 46.2 | 0.00555 | NR | WNA22210.1 | 2719514 | g28590 | i0 | 44.4 | 0.469565217391304 | 54 | 30 | 47 | 0 | 184 | 345 | 54 | 107 | WNA22210.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 3] | diamond | 162 | 46.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus ibericum | ||
| 29157024 | 29157024 | PRJNA1204310_P_NODE_3869_length_846_cov_1.670116_g3627_i0 | PRJNA1204310 | 3869 | 846 | 1.670116 | 14.12918136 | Leptosphaeria biglobosa narnavirus 7 | 2985682 | Viruses | Viruses | 112 | 1.0799999999999999e-23 | NR | UYL94525.1 | 2985682 | g3627 | i0 | 32.7 | 1.6595744680851101 | 217 | 136 | 74.1 | 5 | 160 | 786 | 38 | 252 | UYL94525.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa narnavirus 7] | diamond | 1404 | 112 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Leptosphaeria biglobosa narnavirus 7 | ||
| 30420488 | 30420488 | PRJNA1204310_P_NODE_2093_length_1084_cov_7.941642_g1905_i0 | PRJNA1204310 | 2093 | 1084 | 7.941642 | 86.08739928 | Narnavirus sp. | 2587225 | Viruses | Viruses | 65.1 | 1.26e-8 | NR | CAK8705411.1 | 2587225 | g1905 | i0 | 34.4 | 1.26752767527675 | 128 | 73 | 34.9 | 3 | 992 | 615 | 4 | 122 | CAK8705411.1 uncharacterized [Narnavirus sp.] | diamond | 1374 | 65.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 31052337 | 31052337 | PRJNA1204310_P_NODE_4595_length_787_cov_1.676471_g4338_i0 | PRJNA1204310 | 4595 | 787 | 1.676471 | 13.19382677 | Aspergillus fumigatus narnavirus 2 | 2250450 | Viruses | Viruses | 54.3 | 2.6e-4 | NR | BCH36628.1 | 2250450 | g4338 | i0 | 26.4 | 0.880559085133418 | 231 | 147 | 82.7 | 8 | 113 | 763 | 262 | 483 | BCH36628.1 hypothetical protein [Aspergillus fumigatus narnavirus 2] | diamond | 693 | 54.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus aspergilli | ||
| 31811013 | 31811013 | PRJNA1204310_P_NODE_16497_length_440_cov_1.220708_g16200_i0 | PRJNA1204310 | 16497 | 440 | 1.220708 | 5.3711152 | Narnavirus sp. | 2587225 | Viruses | Viruses | 170 | 6.68e-46 | NR | CAK7594502.1 | 2587225 | g16200 | i0 | 55.1 | 0.940909090909091 | 138 | 61 | 93.4 | 1 | 435 | 25 | 97 | 234 | CAK7594502.1 RNA-dependent RNA polymerase, partial [Narnavirus sp.] | diamond | 414 | 170 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 32254291 | 32254291 | PRJNA1204310_P_NODE_34618_length_317_cov_1.750000_g34321_i0 | PRJNA1204310 | 34618 | 317 | 1.75 | 5.5475 | Narnavirus sp. | 2587225 | Viruses | Viruses | 103 | 5.42e-23 | NR | CAK7594523.1 | 2587225 | g34321 | i0 | 49.1 | 1.89274447949527 | 106 | 53 | 99.4 | 1 | 315 | 1 | 781 | 886 | CAK7594523.1 RNA-dependent RNA polymerase, partial [Narnavirus sp.] | diamond | 600 | 103 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 32462774 | 32462774 | PRJNA1204310_P_NODE_1939_length_1117_cov_1.754789_g1756_i0 | PRJNA1204310 | 1939 | 1117 | 1.754789 | 19.60099313 | Viruses | 10239 | Viruses | Viruses | 72.8 | 7.79e-10 | NR | WPR16641.1 | 3066944 | g1756 | i0 | 21.9 | 1.77529095792301 | 319 | 228 | 84.1 | 6 | 72 | 1010 | 274 | 577 | WPR16641.1 MAG: RNA-dependent RNA polymerase [Mbeech associated narna-like virus 2] | diamond | 1983 | 73.2 | 0.994535519125683 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Mbeech associated narna-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);;