contig_metadata
10 rows where bioproject = "PRJNA768450" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021518 | 2021518 | PRJNA768450_S_NODE_14902_length_190_cov_1.737589_g14853_i0 | PRJNA768450 | 14902 | 190 | 1.737589 | 3.3014191 | Benyvirus necrobetae | 3427127 | Viruses | Viruses | 346 | 6.690000000000001e-91 | NTclustered | gi|1512470163|gb|MH106727.1| | 31721 | g14853 | i0 | 99.474 | 17.9210526315789 | 190 | 1 | 100 | 0 | 1 | 190 | 3008 | 2819 | Beet necrotic yellow vein virus isolate Brazilian segment RNA2, complete sequence | blastn | 3405 | 346 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Benyviridae | Benyvirus | Benyvirus necrobetae | ||
| 10949591 | 10949591 | PRJNA768450_S_NODE_14709_length_191_cov_1.704225_g14660_i0 | PRJNA768450 | 14709 | 191 | 1.704225 | 3.25506975 | Tolivirales sp. | 2809914 | Viruses | Viruses | 291 | 3.2000000000000003e-74 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g14660 | i0 | 95.58 | 0.947643979057592 | 181 | 8 | 95 | 0 | 1 | 181 | 1831 | 1651 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 181 | 291 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 16048135 | 16048135 | PRJNA768450_S_NODE_16033_length_185_cov_1.308824_g15984_i0 | PRJNA768450 | 16033 | 185 | 1.308824 | 2.4213244 | Benyvirus necrobetae | 3427127 | Viruses | Viruses | 324 | 3.03e-84 | NTclustered | gi|1883421658|gb|MT227165.1| | 31721 | g15984 | i0 | 98.895 | 52.5189189189189 | 181 | 2 | 98 | 0 | 3 | 183 | 648 | 828 | Beet necrotic yellow vein virus strain USA2020 segment RNA2, complete sequence | blastn | 9716 | 324 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Benyviridae | Benyvirus | Benyvirus necrobetae | ||
| 16048347 | 16048347 | PRJNA768450_S_NODE_21293_length_166_cov_2.358974_g21244_i0 | PRJNA768450 | 21293 | 166 | 2.358974 | 3.91589684 | Tolivirales sp. | 2809914 | Viruses | Viruses | 279 | 5.86e-71 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g21244 | i0 | 97.546 | 2.02409638554217 | 163 | 4 | 98 | 0 | 1 | 163 | 1490 | 1652 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 336 | 279 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 17324094 | 17324094 | PRJNA768450_S_NODE_21534_length_166_cov_1.128205_g21485_i0 | PRJNA768450 | 21534 | 166 | 1.128205 | 1.8728203 | Benyvirus necrobetae | 3427127 | Viruses | Viruses | 296 | 5.82e-76 | NTclustered | gi|1883421658|gb|MT227165.1| | 31721 | g21485 | i0 | 98.795 | 27.1987951807229 | 166 | 2 | 100 | 0 | 1 | 166 | 2141 | 1976 | Beet necrotic yellow vein virus strain USA2020 segment RNA2, complete sequence | blastn | 4515 | 296 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Benyviridae | Benyvirus | Benyvirus necrobetae | ||
| 19872306 | 19872306 | PRJNA768450_S_NODE_14796_length_191_cov_1.021127_g14747_i0 | PRJNA768450 | 14796 | 191 | 1.021127 | 1.95035257 | Benyvirus necrobetae | 3427127 | Viruses | Viruses | 350 | 5.2000000000000014e-92 | NTclustered | gi|1883421658|gb|MT227165.1| | 31721 | g14747 | i0 | 100 | 17.8115183246073 | 189 | 0 | 99 | 0 | 3 | 191 | 3168 | 2980 | Beet necrotic yellow vein virus strain USA2020 segment RNA2, complete sequence | blastn | 3402 | 350 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Benyviridae | Benyvirus | Benyvirus necrobetae | ||
| 21148730 | 21148730 | PRJNA768450_S_NODE_8297_length_237_cov_2.319149_g8248_i0 | PRJNA768450 | 8297 | 237 | 2.319149 | 5.49638313 | Benyvirus necrobetae | 3427127 | Viruses | Viruses | 438 | 1.4e-118 | NTclustered | gi|2316779776|gb|OM830522.1| | 31721 | g8248 | i0 | 100 | 99.8016877637131 | 237 | 0 | 100 | 0 | 1 | 237 | 103 | 339 | Beet necrotic yellow vein virus isolate 36-Villalonso-ES coat protein gene, complete cds | blastn | 23653 | 438 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Benyviridae | Benyvirus | Benyvirus necrobetae | ||
| 23698529 | 23698529 | PRJNA768450_S_NODE_16519_length_183_cov_1.365672_g16470_i0 | PRJNA768450 | 16519 | 183 | 1.365672 | 2.49917976 | Tolivirales sp. | 2809914 | Viruses | Viruses | 294 | 2.35e-75 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g16470 | i0 | 95.628 | 1.54644808743169 | 183 | 8 | 100 | 0 | 1 | 183 | 3671 | 3489 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 283 | 294 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28727016 | 28727016 | PRJNA768450_S_NODE_14547_length_192_cov_1.412587_g14498_i0 | PRJNA768450 | 14547 | 192 | 1.412587 | 2.71216704 | Tolivirales sp. | 2809914 | Viruses | Viruses | 102 | 2.5599999999999998e-23 | NR | WRQ65315.1 | 2809914 | g14498 | i0 | 87.5 | 2 | 64 | 8 | 100 | 0 | 192 | 1 | 84 | 147 | WRQ65315.1 polyprotein [Tolivirales sp.] | diamond | 384 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 30621816 | 30621816 | PRJNA768450_S_NODE_11993_length_206_cov_1.732484_g11944_i0 | PRJNA768450 | 11993 | 206 | 1.732484 | 3.56891704 | Tolivirales sp. | 2809914 | Viruses | Viruses | 71.2 | 1.96e-13 | NR | WRQ65126.1 | 2809914 | g11944 | i0 | 75.6 | 0.597087378640777 | 41 | 10 | 59.7 | 0 | 55 | 177 | 13 | 53 | WRQ65126.1 hypothetical protein, partial [Tolivirales sp.] | diamond | 123 | 71.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. |
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);;