contig_metadata
14 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7465424 | 7465424 | PRJNA429937_P_NODE_152946_length_171_cov_2.084507_g130319_i0 | PRJNA429937 | 152946 | 171 | 2.084507 | 3.56450697 | root | 1 | Root_unresolved | Root_unresolved | 252 | 1.32e-62 | NTclustered | gi|2575892337|gb|OR233204.1| | 112229 | g130319 | i0 | 92.778 | 21.280701754386 | 180 | 3 | 100 | 7 | 1 | 171 | 6389 | 6211 | Pepino mosaic virus isolate DSMZ PV-0975, complete genome | blastn | 3639 | 252 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 19553382 | 19553382 | PRJNA429937_P_NODE_8336_length_1235_cov_3.791045_g4913_i0 | PRJNA429937 | 8336 | 1235 | 3.791045 | 46.81940575 | Bromovirus BMV | 3427622 | Viruses | Viruses | 2049 | 0 | NTclustered | gi|2329659867|gb|OK558647.1| | 12302 | g4913 | i0 | 98.038 | 38.4453441295547 | 1172 | 16 | 98 | 2 | 7 | 1171 | 2339 | 1168 | Brome mosaic virus isolate Portage- MB strain hypothetical protein gene, complete cds | blastn | 47480 | 2049 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 22103849 | 22103849 | PRJNA429937_P_NODE_72058_length_395_cov_2.207650_g50274_i0 | PRJNA429937 | 72058 | 395 | 2.20765 | 8.7202175 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 298 | 4.4e-76 | NTclustered | gi|1078555000|dbj|LC190455.1| | 12188 | g50274 | i0 | 93.909 | 11.2759493670886 | 197 | 12 | 87 | 0 | 47 | 243 | 274 | 470 | White clover mosaic virus CP gene for coat protein, complete cds, isolate: Namwon | blastn | 4454 | 298 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 26663875 | 26663875 | PRJNA429937_P_NODE_106381_length_284_cov_2.678431_g83761_i0 | PRJNA429937 | 106381 | 284 | 2.678431 | 7.60674404 | Bombyx mori latent virus | 2065033 | Viruses | Viruses | 77.8 | 5.42e-15 | NR | YP_009505643.1 | 2065033 | g83761 | i0 | 53.3 | 0.792253521126761 | 75 | 32 | 79.2 | 1 | 60 | 284 | 151 | 222 | YP_009505643.1 coat protein [Bombyx mori latent virus] | diamond | 225 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Bombyx mori latent virus | |||
| 26997150 | 26997150 | PRJNA429937_P_NODE_149302_length_185_cov_2.051282_g126675_i0 | PRJNA429937 | 149302 | 185 | 2.051282 | 3.7948717 | Maculavirus | 249185 | Viruses | Viruses | 52.4 | 6.91e-6 | NR | YP_009551952.1 | 2094260 | g126675 | i0 | 56.3 | 1.52432432432432 | 48 | 19 | 74.6 | 1 | 26 | 163 | 713 | 760 | YP_009551952.1 polyprotein [Bee Macula-Like virus 2] | diamond | 282 | 52.8 | 0.992424242424242 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bee Macula-Like virus 2 | ||
| 28023365 | 28023365 | PRJNA429937_P_NODE_40965_length_562_cov_3.493433_g25973_i0 | PRJNA429937 | 40965 | 562 | 3.493433 | 19.63309346 | Wufeng shrew carmotetravirus 1 | 3077505 | Viruses | Viruses | 56.6 | 1.31e-5 | NR | WOK58419.1 | 3077505 | g25973 | i0 | 29.2 | 0.47508896797153 | 89 | 63 | 47.5 | 0 | 388 | 122 | 539 | 627 | WOK58419.1 MAG: RNA-dependent RNA polymerase [Wufeng shrew carmotetravirus 1] | diamond | 267 | 56.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Carmotetraviridae | Wufeng shrew carmotetravirus 1 | |||
| 28086322 | 28086322 | PRJNA429937_P_NODE_67805_length_412_cov_2.070496_g46622_i0 | PRJNA429937 | 67805 | 412 | 2.070496 | 8.53044352 | Tymovirales sp. | 1955157 | Viruses | Viruses | 58.2 | 1.04e-6 | NR | XCO49695.1 | 1955157 | g46622 | i0 | 43.1 | 1.05582524271845 | 72 | 41 | 52.4 | 0 | 282 | 67 | 1142 | 1213 | XCO49695.1 MAG: putative ORF1 protein [Tymovirales sp.] | diamond | 435 | 58.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 28117887 | 28117887 | PRJNA429937_P_NODE_24745_length_738_cov_2.416079_g14787_i0 | PRJNA429937 | 24745 | 738 | 2.416079 | 17.83066302 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 3.77e-13 | NR | XCO49696.1 | 1955157 | g14787 | i0 | 65.5 | 0.443089430894309 | 55 | 19 | 22.4 | 0 | 524 | 688 | 150 | 204 | XCO49696.1 MAG: putative ORF2 protein [Tymovirales sp.] | diamond | 327 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 28307494 | 28307494 | PRJNA429937_P_NODE_70386_length_401_cov_7.981183_g48811_i0 | PRJNA429937 | 70386 | 401 | 7.981183 | 32.00454383 | Bombyx mori Macula-like virus | 288456 | Viruses | Viruses | 85.9 | 1.9e-18 | NR | YP_004464932.1 | 288456 | g48811 | i0 | 40.6 | 0.718204488778055 | 96 | 57 | 71.8 | 0 | 357 | 70 | 39 | 134 | YP_004464932.1 unnamed protein product [Bombyx mori Macula-like virus] | diamond | 288 | 85.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 28907123 | 28907123 | PRJNA429937_P_NODE_79528_length_367_cov_8.698225_g57161_i0 | PRJNA429937 | 79528 | 367 | 8.698225 | 31.92248575 | Bombyx mori Macula-like virus | 288456 | Viruses | Viruses | 85.9 | 1.31e-18 | NR | YP_004464932.1 | 288456 | g57161 | i0 | 40.6 | 0.784741144414169 | 96 | 57 | 78.5 | 0 | 11 | 298 | 39 | 134 | YP_004464932.1 unnamed protein product [Bombyx mori Macula-like virus] | diamond | 288 | 85.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Bombyx mori Macula-like virus | ||
| 29128629 | 29128629 | PRJNA429937_P_NODE_68229_length_410_cov_2.858268_g46971_i0 | PRJNA429937 | 68229 | 410 | 2.858268 | 11.7188988 | Drosophila-associated tymovirus | 2900522 | Viruses | Viruses | 110 | 5.01e-25 | NR | UFT26908.1 | 2900522 | g46971 | i0 | 61.4 | 1.90975609756098 | 83 | 32 | 60.7 | 0 | 65 | 313 | 13 | 95 | UFT26908.1 putative polyprotein [Drosophila-associated tymovirus] | diamond | 783 | 110 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Drosophila-associated tymovirus | ||||
| 29886330 | 29886330 | PRJNA429937_P_NODE_24891_length_736_cov_2.512023_g14870_i0 | PRJNA429937 | 24891 | 736 | 2.512023 | 18.48848928 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 3.7e-13 | NR | XCO49696.1 | 1955157 | g14870 | i0 | 65.5 | 0.44429347826087 | 55 | 19 | 22.4 | 0 | 215 | 51 | 150 | 204 | XCO49696.1 MAG: putative ORF2 protein [Tymovirales sp.] | diamond | 327 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 31687550 | 31687550 | PRJNA429937_P_NODE_80297_length_365_cov_2.672619_g57897_i0 | PRJNA429937 | 80297 | 365 | 2.672619 | 9.75505935 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 1.42e-14 | NR | XCO49696.1 | 1955157 | g57897 | i0 | 65.5 | 0.895890410958904 | 55 | 19 | 45.2 | 0 | 151 | 315 | 150 | 204 | XCO49696.1 MAG: putative ORF2 protein [Tymovirales sp.] | diamond | 327 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales sp. | ||||
| 32888172 | 32888172 | PRJNA429937_P_NODE_60060_length_447_cov_2.669856_g40376_i0 | PRJNA429937 | 60060 | 447 | 2.669856 | 11.93425632 | Tymovirales sp. | 1955157 | Viruses | Viruses | 77.8 | 2.17e-13 | NR | XCO49695.1 | 1955157 | g40376 | i0 | 51.3 | 0.536912751677852 | 80 | 26 | 52.3 | 2 | 211 | 444 | 60 | 128 | XCO49695.1 MAG: putative ORF1 protein [Tymovirales sp.] | diamond | 240 | 77.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymovirales 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);;