contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA768450" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021340 | 2021340 | PRJNA768450_S_NODE_1042_length_539_cov_5.224490_g999_i0 | PRJNA768450 | 1042 | 539 | 5.22449 | 28.1600011 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 62.1 | 8.8e-5 | NTclustered | gi|2560516847|emb|OY702104.1| | 2697049 | g999 | i0 | 100 | 6.30055658627087 | 33 | 0 | 6 | 0 | 507 | 539 | 23282 | 23314 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3396 | 62.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2021394 | 2021394 | PRJNA768450_S_NODE_11802_length_207_cov_2.335443_g11753_i0 | PRJNA768450 | 11802 | 207 | 2.335443 | 4.83436701 | Deltapartitivirus duobetae | 3428206 | Viruses | Viruses | 374 | 3.4e-99 | NTclustered | gi|523580592|gb|KC845533.1| | 912029 | g11753 | i0 | 100 | 7.68115942028986 | 202 | 0 | 98 | 0 | 1 | 202 | 412 | 613 | Beet cryptic virus 2 isolate Rp coat protein gene, complete cds | blastn | 1590 | 374 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Deltapartitivirus duobetae | ||
| 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 | ||
| 3297148 | 3297148 | PRJNA768450_S_NODE_2843_length_361_cov_8.038462_g2794_i0 | PRJNA768450 | 2843 | 361 | 8.0384620000000009 | 29.01884782 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 137 | 9.18e-28 | NTclustered | gi|2165834218|emb|OV195924.1| | 2697049 | g2794 | i0 | 97.531 | 23.7479224376731 | 81 | 0 | 22 | 2 | 276 | 354 | 352 | 272 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8573 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4573929 | 4573929 | PRJNA768450_S_NODE_18184_length_176_cov_3.464567_g18135_i0 | PRJNA768450 | 18184 | 176 | 3.464567 | 6.09763792 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 8.87e-5 | NTclustered | gi|2557393137|emb|OY661705.1| | 2697049 | g18135 | i0 | 91.111 | 3.60227272727273 | 45 | 3 | 25 | 1 | 1 | 44 | 7180 | 7136 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 634 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5034484 | 5034484 | PRJNA768450_S_NODE_15524_length_187_cov_1.971014_g15475_i0 | PRJNA768450 | 15524 | 187 | 1.971014 | 3.68579618 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.016 | NTclustered | gi|2565360070|emb|OY632882.1| | 2697049 | g15475 | i0 | 100 | 0.449197860962567 | 28 | 0 | 15 | 0 | 1 | 28 | 22489 | 22462 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 84 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7124114 | 7124114 | PRJNA768450_S_NODE_1186_length_511_cov_401.487013_g1140_i0 | PRJNA768450 | 1186 | 511 | 401.487013 | 2051.59863643 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 135 | 4.83e-27 | NTclustered | gi|2165834303|emb|OV196009.1| | 2697049 | g1140 | i0 | 94.382 | 16.6027397260274 | 89 | 3 | 17 | 2 | 1 | 87 | 30000 | 29912 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8484 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10949553 | 10949553 | PRJNA768450_S_NODE_13809_length_196_cov_1.360544_g13760_i0 | PRJNA768450 | 13809 | 196 | 1.360544 | 2.66666624 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|2557641183|emb|OY671812.1| | 2697049 | g13760 | i0 | 100 | 0.142857142857143 | 28 | 0 | 14 | 0 | 169 | 196 | 16421 | 16448 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 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 | ||
| 17324423 | 17324423 | PRJNA768450_S_NODE_6834_length_255_cov_2.548544_g6785_i0 | PRJNA768450 | 6834 | 255 | 2.548544 | 6.4987872 | Deltapartitivirus duobetae | 3428206 | Viruses | Viruses | 468 | 1.94e-127 | NTclustered | gi|2754350654|gb|PP987721.1| | 912029 | g6785 | i0 | 100 | 6.94509803921569 | 253 | 0 | 99 | 0 | 3 | 255 | 1143 | 891 | Beet cryptic virus 2 isolate Kz1-49C segment dsRNA2a, partial sequence | blastn | 1771 | 468 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Deltapartitivirus duobetae | ||
| 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. |
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);;