contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 611298 | 611298 | PRJNA641707_P_NODE_1221_length_1589_cov_34.223377_g788_i0 | PRJNA641707 | 1221 | 1589 | 34.223377 | 543.80946053 | Cinnamomum chago deltapartitivirus 1 | 2765856 | Viruses | Viruses | 741 | 1.46e-265 | NR | DAF42460.1 | 2765856 | g788 | i0 | 73.8 | 0.89490245437382 | 474 | 124 | 89.5 | 0 | 1475 | 54 | 2 | 475 | DAF42460.1 TPA_exp: RNA-dependent RNA polymerase [Cinnamomum chago deltapartitivirus 1] | diamond | 1422 | 741 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Cinnamomum chago deltapartitivirus 1 | ||
| 4445361 | 4445361 | PRJNA641707_P_NODE_9764_length_685_cov_7.748428_g6757_i1 | PRJNA641707 | 9764 | 685 | 7.748428 | 53.0767318 | Camellia cryptic virus 2 | 2809264 | Viruses | Viruses | 229 | 6.06e-69 | NR | QRG29190.1 | 2809264 | g6757 | i1 | 76.9 | 3.13138686131387 | 143 | 33 | 62.6 | 0 | 6 | 434 | 65 | 207 | QRG29190.1 RdRp, partial [Camellia cryptic virus 2] | diamond | 2145 | 229 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Camellia cryptic virus 2 | |||
| 18469928 | 18469928 | PRJNA641707_P_NODE_97515_length_246_cov_4.563452_g94852_i0 | PRJNA641707 | 97515 | 246 | 4.563452 | 11.22609192 | Arabis mosaic virus | 12271 | Viruses | Viruses | 97.1 | 3.18e-21 | NR | QYA72350.1 | 12271 | g94852 | i0 | 77.2 | 2.89024390243902 | 79 | 10 | 96.3 | 1 | 7 | 243 | 1120 | 1190 | QYA72350.1 polyprotein 1 [Arabis mosaic virus] | diamond | 711 | 97.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus arabis | ||
| 18469930 | 18469930 | PRJNA641707_P_NODE_975_length_1708_cov_867.776974_g624_i0 | PRJNA641707 | 975 | 1708 | 867.776974 | 14821.63071592 | Panax cryptic virus 4 | 2809267 | Viruses | Viruses | 785 | 5.3700000000000006e-282 | NR | QRG29207.1 | 2809267 | g624 | i0 | 79.6 | 0.858899297423888 | 489 | 100 | 85.9 | 0 | 1704 | 238 | 2 | 490 | QRG29207.1 putative CP [Panax cryptic virus 4] | diamond | 1467 | 785 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Panax cryptic virus 4 | |||
| 19740822 | 19740822 | PRJNA641707_P_NODE_240356_length_186_cov_5.576642_g237693_i0 | PRJNA641707 | 240356 | 186 | 5.576642 | 10.37255412 | Panax cryptic virus 4 | 2809267 | Viruses | Viruses | 103 | 6.43e-24 | NR | QRG29207.1 | 2809267 | g237693 | i0 | 81.4 | 0.951612903225806 | 59 | 11 | 95.2 | 0 | 1 | 177 | 272 | 330 | QRG29207.1 putative CP [Panax cryptic virus 4] | diamond | 177 | 103 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Panax cryptic virus 4 | |||
| 27839052 | 27839052 | PRJNA641707_P_NODE_234664_length_188_cov_8.014388_g232001_i0 | PRJNA641707 | 234664 | 188 | 8.014388 | 15.06704944 | Annulohypoxylon moriforme hypovirus 1 | 3081087 | Viruses | Viruses | 43.5 | 0.00986 | NR | WOA03765.1 | 3081087 | g232001 | i0 | 32.8 | 0.973404255319149 | 61 | 40 | 95.7 | 1 | 185 | 6 | 2551 | 2611 | WOA03765.1 polyprotein [Annulohypoxylon moriforme hypovirus 1] | diamond | 183 | 43.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Annulohypoxylon moriforme hypovirus 1 | |||
| 28217956 | 28217956 | PRJNA641707_P_NODE_77946_length_246_cov_9.614213_g75283_i0 | PRJNA641707 | 77946 | 246 | 9.614213 | 23.65096398 | Carrot torradovirus 1 | 1425364 | Viruses | Viruses | 73.6 | 5.47e-13 | NR | YP_009104369.1 | 1425364 | g75283 | i0 | 100 | 1.20731707317073 | 33 | 0 | 40.2 | 0 | 146 | 244 | 420 | 452 | YP_009104369.1 polyprotein [Carrot torradovirus 1] | diamond | 297 | 73.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Torradovirus | Torradovirus carotae | ||
| 28660303 | 28660303 | PRJNA641707_P_NODE_302667_length_163_cov_10.008772_g300004_i0 | PRJNA641707 | 302667 | 163 | 10.008772 | 16.31429836 | Army ant associated iflavirus 4 | 3004006 | Viruses | Viruses | 72.8 | 3.09e-13 | NR | WAX26122.1 | 3004006 | g300004 | i0 | 64.7 | 0.938650306748466 | 51 | 18 | 93.9 | 0 | 158 | 6 | 2354 | 2404 | WAX26122.1 MAG: polyprotein, partial [Army ant associated iflavirus 4] | diamond | 153 | 72.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Army ant associated iflavirus 4 | ||
| 28912426 | 28912426 | PRJNA641707_P_NODE_1568_length_1469_cov_63.005634_g1031_i0 | PRJNA641707 | 1568 | 1469 | 63.005634 | 925.55276346 | Cinnamomum chago deltapartitivirus 1 | 2765856 | Viruses | Viruses | 441 | 8.28e-149 | NR | DAF42461.1 | 2765856 | g1031 | i0 | 53.1 | 0.845473110959837 | 414 | 181 | 84.5 | 2 | 79 | 1320 | 8 | 408 | DAF42461.1 TPA_exp: coat protein [Cinnamomum chago deltapartitivirus 1] | diamond | 1242 | 441 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Cinnamomum chago deltapartitivirus 1 | ||
| 29575622 | 29575622 | PRJNA641707_P_NODE_292730_length_166_cov_4.803419_g290067_i0 | PRJNA641707 | 292730 | 166 | 4.803419 | 7.97367554 | Hooked Veilwort waikavirus | 3115791 | Viruses | Viruses | 62.4 | 1.56e-9 | NR | DBA54825.1 | 3115791 | g290067 | i0 | 58.5 | 0.957831325301205 | 53 | 22 | 95.8 | 0 | 5 | 163 | 2742 | 2794 | DBA54825.1 TPA_asm: polyprotein, partial [Hooked Veilwort waikavirus] | diamond | 159 | 62.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Waikavirus | Hooked Veilwort waikavirus | ||
| 29670186 | 29670186 | PRJNA641707_P_NODE_284110_length_169_cov_2.008333_g281447_i0 | PRJNA641707 | 284110 | 169 | 2.008333 | 3.39408277 | Iflaviridae sp. | 1955145 | Viruses | Viruses | 74.7 | 7.33e-14 | NR | XCO48898.1 | 1955145 | g281447 | i0 | 60.4 | 1.88165680473373 | 53 | 21 | 94.1 | 0 | 10 | 168 | 365 | 417 | XCO48898.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.] | diamond | 318 | 74.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae sp. | |||
| 29733475 | 29733475 | PRJNA641707_P_NODE_315850_length_159_cov_6.372727_g313187_i0 | PRJNA641707 | 315850 | 159 | 6.372727 | 10.13263593 | Leuven Sobemo-like virus 2 | 2874438 | Viruses | Viruses | 64.3 | 2.83e-10 | NR | QZZ63347.1 | 2874438 | g313187 | i0 | 81.8 | 0.622641509433962 | 33 | 6 | 62.3 | 0 | 2 | 100 | 457 | 489 | QZZ63347.1 hypothetical protein [Leuven Sobemo-like virus 2] | diamond | 99 | 64.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Leuven Sobemo-like virus 2 | |||
| 30112708 | 30112708 | PRJNA641707_P_NODE_8612_length_728_cov_10.958763_g6757_i0 | PRJNA641707 | 8612 | 728 | 10.958763 | 79.77979464 | Camellia cryptic virus 2 | 2809264 | Viruses | Viruses | 303 | 1.6200000000000002e-97 | NR | QRG29190.1 | 2809264 | g6757 | i0 | 75.3 | 0.799450549450549 | 194 | 48 | 79.9 | 0 | 584 | 3 | 14 | 207 | QRG29190.1 RdRp, partial [Camellia cryptic virus 2] | diamond | 582 | 303 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Camellia cryptic virus 2 | |||
| 30270938 | 30270938 | PRJNA641707_P_NODE_232352_length_189_cov_6.578571_g229689_i0 | PRJNA641707 | 232352 | 189 | 6.578571 | 12.43349919 | Soldier fly virus | 2866945 | Viruses | Viruses | 84.3 | 3.93e-17 | NR | QYR68989.1 | 2866945 | g229689 | i0 | 65.6 | 0.968253968253968 | 61 | 21 | 96.8 | 0 | 184 | 2 | 746 | 806 | QYR68989.1 putative structural polyprotein [Soldier fly virus] | diamond | 183 | 84.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Soldier fly virus | |||
| 30441193 | 30441193 | PRJNA641707_P_NODE_178813_length_200_cov_6.245033_g176150_i0 | PRJNA641707 | 178813 | 200 | 6.245033 | 12.490066 | Betapartitivirus | 1511809 | Viruses | Viruses | 70.1 | 4.78e-12 | NR | QFU95809.1 | 1955169 | g176150 | i0 | 52.9 | 4.965 | 68 | 24 | 93 | 3 | 187 | 2 | 676 | 741 | QFU95809.1 RNA-dependent RNA polymerase [Betapartitivirus sp.] | diamond | 993 | 70.5 | 0.994326241134752 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Betapartitivirus | Betapartitivirus sp. | ||
| 30586455 | 30586455 | PRJNA641707_P_NODE_190293_length_199_cov_2.866667_g187630_i0 | PRJNA641707 | 190293 | 199 | 2.866667 | 5.70466733 | Jingmen rodent picorna-like virus 1 | 3083435 | Viruses | Viruses | 63.9 | 2.46e-10 | NR | WPV63416.1 | 3083435 | g187630 | i0 | 36.9 | 1.55276381909548 | 103 | 25 | 95 | 1 | 10 | 198 | 29 | 131 | WPV63416.1 MAG: RNA-dependent RNA polymerase, partial [Jingmen rodent picorna-like virus 1] | diamond | 309 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Jingmen rodent picorna-like virus 1 | ||||
| 30776392 | 30776392 | PRJNA641707_P_NODE_317034_length_159_cov_3.509091_g314371_i0 | PRJNA641707 | 317034 | 159 | 3.509091 | 5.57945469 | Grapevine wood holobiome associated hypovirus | 3396144 | Viruses | Viruses | 56.2 | 2.13e-7 | NR | XNT19719.1 | 3396144 | g314371 | i0 | 64.6 | 0.905660377358491 | 48 | 15 | 86.8 | 1 | 147 | 10 | 904 | 951 | XNT19719.1 polyprotein [Grapevine wood holobiome associated hypovirus] | diamond | 144 | 56.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Grapevine wood holobiome associated hypovirus | ||
| 30902668 | 30902668 | PRJNA641707_P_NODE_235954_length_188_cov_3.633094_g233291_i0 | PRJNA641707 | 235954 | 188 | 3.633094 | 6.83021672 | Lentinula edodes partitivirus 2 | 2491351 | Viruses | Viruses | 45.1 | 0.00275 | NR | QOX06027.1 | 2491351 | g233291 | i0 | 60.7 | 0.446808510638298 | 28 | 11 | 44.7 | 0 | 7 | 90 | 612 | 639 | QOX06027.1 capsid protein [Lentinula edodes partitivirus 2] | diamond | 84 | 45.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Lentinula edodes partitivirus 2 | |||
| 31250151 | 31250151 | PRJNA641707_P_NODE_256255_length_179_cov_11.284615_g253592_i0 | PRJNA641707 | 256255 | 179 | 11.284615 | 20.19946085 | Switchgrass poty-like virus 1 | 3233121 | Viruses | Viruses | 55.1 | 7.09e-7 | NR | XCN99618.1 | 3233121 | g253592 | i0 | 41.4 | 1.94413407821229 | 58 | 34 | 97.2 | 0 | 177 | 4 | 634 | 691 | XCN99618.1 polyprotein [Switchgrass poty-like virus 1] | diamond | 348 | 55.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Switchgrass poty-like virus 1 | |||
| 31598335 | 31598335 | PRJNA641707_P_NODE_228876_length_190_cov_10.120567_g226213_i0 | PRJNA641707 | 228876 | 190 | 10.120567 | 19.2290773 | Dicistroviridae sp. | 1955144 | Viruses | Viruses | 47 | 6.08e-4 | NR | UBJ26062.1 | 1955144 | g226213 | i0 | 66.7 | 2.4 | 27 | 9 | 42.6 | 0 | 172 | 92 | 650 | 676 | UBJ26062.1 putative RNA-dependent RNA polymerase [Dicistroviridae sp.] | diamond | 456 | 47 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 31756212 | 31756212 | PRJNA641707_P_NODE_173797_length_201_cov_3.322368_g171134_i0 | PRJNA641707 | 173797 | 201 | 3.322368 | 6.67795968 | Potato virus B | 2340870 | Viruses | Viruses | 50.1 | 5.53e-5 | NR | YP_010229207.1 | 2340870 | g171134 | i0 | 63.6 | 1.97014925373134 | 33 | 12 | 49.3 | 0 | 101 | 199 | 49 | 81 | YP_010229207.1 Pol [Potato virus B] | diamond | 396 | 50.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus betasolani | ||
| 31787736 | 31787736 | PRJNA641707_P_NODE_263217_length_177_cov_2.453125_g260554_i0 | PRJNA641707 | 263217 | 177 | 2.453125 | 4.34203125 | Lysoka partitivirus | 2169483 | Viruses | Viruses | 102 | 9.289999999999999e-24 | NR | AWV67013.1 | 2169483 | g260554 | i0 | 84.2 | 1.93220338983051 | 57 | 9 | 96.6 | 0 | 6 | 176 | 378 | 434 | AWV67013.1 RdRp [Lysoka partitivirus] | diamond | 342 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Lysoka partitivirus | |||
| 32294423 | 32294423 | PRJNA641707_P_NODE_111759_length_246_cov_2.624365_g109096_i0 | PRJNA641707 | 111759 | 246 | 2.624365 | 6.4559379 | Burdock mosaic virus | 3036445 | Viruses | Viruses | 58.5 | 1.09e-7 | NR | WEU75086.1 | 3036445 | g109096 | i0 | 71.9 | 0.390243902439024 | 32 | 9 | 39 | 0 | 96 | 1 | 180 | 211 | WEU75086.1 polyprotein [Burdock mosaic virus] | diamond | 96 | 58.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Torradovirus | Torradovirus arctii | ||
| 32515850 | 32515850 | PRJNA641707_P_NODE_20379_length_482_cov_12.157044_g17862_i0 | PRJNA641707 | 20379 | 482 | 12.157044 | 58.59695208 | Iflaviridae sp. | 1955145 | Viruses | Viruses | 73.6 | 9.39e-12 | NR | XCO48851.1 | 1955145 | g17862 | i0 | 42.3 | 0.603734439834025 | 97 | 52 | 57.9 | 2 | 365 | 87 | 139 | 235 | XCO48851.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.] | diamond | 291 | 73.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae 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);;