contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6804767 | 6804767 | PRJNA429937_P_NODE_58086_length_457_cov_2.121495_g38845_i0 | PRJNA429937 | 58086 | 457 | 2.121495 | 9.69523215 | Narnavirus sp. | 2587225 | Viruses | Viruses | 197 | 1.32e-56 | NR | XFO98523.1 | 2587225 | g38845 | i0 | 61.3 | 1.13566739606127 | 173 | 29 | 88.6 | 1 | 408 | 4 | 32 | 204 | XFO98523.1 RNA-dependent RNA polymerase [Narnavirus sp.] | diamond | 519 | 197 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 11904992 | 11904992 | PRJNA429937_P_NODE_2190_length_2055_cov_17.662389_g1310_i0 | PRJNA429937 | 2190 | 2055 | 17.662389 | 362.96209395 | Botryosphaeria dothidea narnavirus 4 | 2785368 | Viruses | Viruses | 392 | 4.8200000000000006e-123 | NR | QQD86178.1 | 2785368 | g1310 | i0 | 38.7 | 1.75912408759124 | 656 | 377 | 93.9 | 16 | 2022 | 94 | 1 | 644 | QQD86178.1 RNA-dependent RNA polymerase [Botryosphaeria dothidea narnavirus 4] | diamond | 3615 | 392 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Botryosphaeria dothidea narnavirus 4 | |||
| 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 | ||
| 27518105 | 27518105 | PRJNA429937_P_NODE_43443_length_544_cov_2.188350_g27761_i0 | PRJNA429937 | 43443 | 544 | 2.18835 | 11.904624 | Colletotrichum cliviicola partitivirus 1 | 3400824 | Viruses | Viruses | 143 | 1.31e-36 | NR | XOT41440.1 | 3400824 | g27761 | i0 | 39.1 | 2.83455882352941 | 256 | 81 | 99.8 | 4 | 544 | 2 | 248 | 503 | XOT41440.1 RNA-dependent RNA polymerase [Colletotrichum cliviicola partitivirus 1] | diamond | 1542 | 143 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Colletotrichum cliviicola partitivirus 1 | |||
| 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. | ||||
| 28149693 | 28149693 | PRJNA429937_P_NODE_89845_length_334_cov_2.203279_g67271_i0 | PRJNA429937 | 89845 | 334 | 2.203279 | 7.35895186 | Narnavirus sp. | 2587225 | Viruses | Viruses | 167 | 6.04e-46 | NR | XFO98523.1 | 2587225 | g67271 | i0 | 75.7 | 0.997005988023952 | 111 | 27 | 99.7 | 0 | 2 | 334 | 24 | 134 | XFO98523.1 RNA-dependent RNA polymerase [Narnavirus sp.] | diamond | 333 | 167 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus 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 | ||
| 28718015 | 28718015 | PRJNA429937_P_NODE_83427_length_355_cov_2.282209_g60936_i0 | PRJNA429937 | 83427 | 355 | 2.282209 | 8.10184195 | Narnavirus sp. | 2587225 | Viruses | Viruses | 182 | 1.48e-51 | NR | XFO98523.1 | 2587225 | g60936 | i0 | 79.1 | 0.971830985915493 | 115 | 24 | 97.2 | 0 | 11 | 355 | 32 | 146 | XFO98523.1 RNA-dependent RNA polymerase [Narnavirus sp.] | diamond | 345 | 182 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 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. | ||||
| 30360553 | 30360553 | PRJNA429937_P_NODE_63472_length_431_cov_2.199005_g43092_i0 | PRJNA429937 | 63472 | 431 | 2.199005 | 9.47771155 | Nigrospora oryzae partitivirus 2 | 3231912 | Viruses | Viruses | 132 | 6.24e-33 | NR | XCK16958.1 | 3231912 | g43092 | i0 | 87 | 0.960556844547564 | 69 | 9 | 48 | 0 | 173 | 379 | 437 | 505 | XCK16958.1 RNA-dependent RNA polymerase [Nigrospora oryzae partitivirus 2] | diamond | 414 | 132 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Nigrospora oryzae partitivirus 2 | |||
| 30423630 | 30423630 | PRJNA429937_P_NODE_54453_length_476_cov_1.977629_g36052_i0 | PRJNA429937 | 54453 | 476 | 1.977629 | 9.41351404 | Narnavirus sp. | 2587225 | Viruses | Viruses | 157 | 1.33e-41 | NR | XFO98523.1 | 2587225 | g36052 | i0 | 76.7 | 0.649159663865546 | 103 | 24 | 64.9 | 0 | 50 | 358 | 32 | 134 | XFO98523.1 RNA-dependent RNA polymerase [Narnavirus sp.] | diamond | 309 | 157 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Narnavirus sp. | ||
| 30518044 | 30518044 | PRJNA429937_P_NODE_50313_length_499_cov_3.827660_g32926_i0 | PRJNA429937 | 50313 | 499 | 3.82766 | 19.1000234 | Downy mildew lesion associated ormycovirus 3 | 3162771 | Viruses | Viruses | 225 | 1.01e-68 | NR | USW07203.1 | 3162771 | g32926 | i0 | 62.4 | 0.991983967935872 | 165 | 62 | 99.2 | 0 | 3 | 497 | 55 | 219 | USW07203.1 hypothetical protein [Downy mildew lesion associated ormycovirus 3] | diamond | 495 | 225 | 1 | Viruses | Orthornavirae | Orpoviricetes | Formycovirales | Betaormycoviridae | Vormycovirus | Vormycovirus plasmoparae | |||
| 30977045 | 30977045 | PRJNA429937_P_NODE_7354_length_1303_cov_7.319466_g4350_i0 | PRJNA429937 | 7354 | 1303 | 7.319466 | 95.37264198 | Ghabrivirales | 2732540 | Viruses | Viruses | 123 | 3.9e-26 | NR | WAK77569.1 | 1955172 | g4350 | i0 | 35.2 | 1.06600153491942 | 230 | 144 | 52.3 | 4 | 1257 | 577 | 351 | 578 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 1389 | 124 | 0.991935483870968 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 31624290 | 31624290 | PRJNA429937_P_NODE_49756_length_502_cov_6.860465_g32509_i0 | PRJNA429937 | 49756 | 502 | 6.860465 | 34.4395343 | Fushun phasmavirus 1 | 2905464 | Viruses | Viruses | 59.3 | 9.61e-7 | NR | YP_010840784.1 | 2905464 | g32509 | i0 | 46.8 | 0.370517928286853 | 62 | 30 | 37.1 | 1 | 221 | 36 | 282 | 340 | YP_010840784.1 MAG: RNA-dependent RNA polymerase [Fushun phasmavirus 1] | diamond | 186 | 59.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Phasmaviridae | Orthophasmavirus | Orthophasmavirus sogatellae | ||
| 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. | ||||
| 32193893 | 32193893 | PRJNA429937_P_NODE_9558_length_1166_cov_5.156552_g5619_i0 | PRJNA429937 | 9558 | 1166 | 5.156552 | 60.12539632 | Totiviridae sp. | 1955172 | Viruses | Viruses | 311 | 8.13e-98 | NR | UHS72443.1 | 1955172 | g5619 | i0 | 67 | 0.545454545454545 | 212 | 70 | 54.5 | 0 | 636 | 1 | 2 | 213 | UHS72443.1 MAG: putative RNA-dependent RNA polymerase, partial [Totiviridae sp.] | diamond | 636 | 311 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae 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);;