contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA977246" and tax_phylum = "Lenarviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 951161 | 951161 | PRJNA977246_S_NODE_2581_length_1088_cov_11.371105_g946_i2 | PRJNA977246 | 2581 | 1088 | 11.371105 | 123.7176224 | Erysiphe necator associated ourmia-like virus 16 | 2741796 | Viruses | Viruses | 1400 | 0 | NTclustered | gi|1848976565|gb|MN611544.1| | 2741796 | g946 | i2 | 89.918 | 11.4724264705882 | 1091 | 104 | 100 | 6 | 1 | 1088 | 770 | 1857 | Erysiphe necator associated ourmia-like virus 16 isolate PMS1_48, complete genome | blastn | 12482 | 1400 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 16 | ||
| 2226125 | 2226125 | PRJNA977246_S_NODE_1062_length_1883_cov_16.277778_g946_i0 | PRJNA977246 | 1062 | 1883 | 16.277778 | 306.51055974 | Erysiphe necator associated ourmia-like virus 16 | 2741796 | Viruses | Viruses | 2536 | 0 | NTclustered | gi|1848976565|gb|MN611544.1| | 2741796 | g946 | i0 | 91.402 | 7.12586298459904 | 1861 | 145 | 98 | 12 | 1 | 1850 | 1857 | 1 | Erysiphe necator associated ourmia-like virus 16 isolate PMS1_48, complete genome | blastn | 13418 | 2536 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 16 | ||
| 2227045 | 2227045 | PRJNA977246_S_NODE_4722_length_752_cov_256.323651_g4117_i0 | PRJNA977246 | 4722 | 752 | 256.323651 | 1927.55385552 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 1249 | 0 | NTclustered | gi|1848976575|gb|MN611549.1| | 2741801 | g4117 | i0 | 98.315 | 2.0811170212766 | 712 | 12 | 95 | 0 | 41 | 752 | 1 | 712 | Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome | blastn | 1565 | 1249 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 3501681 | 3501681 | PRJNA977246_S_NODE_2163_length_1216_cov_20.956192_g1861_i0 | PRJNA977246 | 2163 | 1216 | 20.956192 | 254.82729472 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 1975 | 0 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g1861 | i0 | 95.97 | 2.92434210526316 | 1216 | 49 | 100 | 0 | 1 | 1216 | 2050 | 835 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 3556 | 1975 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 | ||
| 4779320 | 4779320 | PRJNA977246_S_NODE_2284_length_1177_cov_102.447735_g1895_i1 | PRJNA977246 | 2284 | 1177 | 102.447735 | 1205.80984095 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 76.8 | 7.12e-9 | NTclustered | gi|2396039641|gb|ON812892.1| | 2808997 | g1895 | i1 | 92.593 | 0.325403568394223 | 54 | 3 | 5 | 1 | 19 | 72 | 2248 | 2196 | MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome | blastn | 383 | 76.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 4779499 | 4779499 | PRJNA977246_S_NODE_2964_length_1001_cov_1894.780864_g946_i3 | PRJNA977246 | 2964 | 1001 | 1894.780864 | 18966.75644864 | Erysiphe necator associated ourmia-like virus 16 | 2741796 | Viruses | Viruses | 1288 | 0 | NTclustered | gi|1848976565|gb|MN611544.1| | 2741796 | g946 | i3 | 90.928 | 16.4235764235764 | 959 | 85 | 96 | 2 | 7 | 964 | 907 | 1864 | Erysiphe necator associated ourmia-like virus 16 isolate PMS1_48, complete genome | blastn | 16440 | 1288 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 16 | ||
| 4780018 | 4780018 | PRJNA977246_S_NODE_6924_length_602_cov_3.753927_g6133_i0 | PRJNA977246 | 6924 | 602 | 3.753927 | 22.59864054 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 1057 | 0 | NTclustered | gi|1848976575|gb|MN611549.1| | 2741801 | g6133 | i0 | 98.339 | 2 | 602 | 10 | 100 | 0 | 1 | 602 | 1918 | 2519 | Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome | blastn | 1204 | 1057 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 6054393 | 6054393 | PRJNA977246_S_NODE_2205_length_1203_cov_1709.710392_g1895_i0 | PRJNA977246 | 2205 | 1203 | 1709.710392 | 20567.81601576 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 76.8 | 7.28e-9 | NTclustered | gi|2396039641|gb|ON812892.1| | 2808997 | g1895 | i0 | 92.593 | 4.31837073981712 | 54 | 3 | 4 | 1 | 1132 | 1185 | 2196 | 2248 | MAG: Botourmiaviridae sp. isolate TIGMIC_1, complete genome | blastn | 5195 | 76.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 8603935 | 8603935 | PRJNA977246_S_NODE_19307_length_317_cov_6.927083_g18315_i0 | PRJNA977246 | 19307 | 317 | 6.927083 | 21.95885311 | Magoulivirus jiplasmoparae | 2956162 | Viruses | Viruses | 534 | 2.42e-147 | NTclustered | gi|2500381287|ref|NC_076761.1| | 2686494 | g18315 | i0 | 98.361 | 3.47003154574133 | 305 | 4 | 96 | 1 | 5 | 308 | 2025 | 2329 | Plasmopara viticola lesion associated ourmia-like virus 26 isolate DMS1_25556 RNA dependent RNA polymerase (QKR36_gp1) gene, complete cds | blastn | 1100 | 534 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae | ||
| 8604091 | 8604091 | PRJNA977246_S_NODE_2427_length_1130_cov_11.255223_g946_i1 | PRJNA977246 | 2427 | 1130 | 11.255223 | 127.1840199 | Erysiphe necator associated ourmia-like virus 16 | 2741796 | Viruses | Viruses | 1522 | 0 | NTclustered | gi|1848976565|gb|MN611544.1| | 2741796 | g946 | i1 | 91.111 | 23.223008849557505 | 1125 | 98 | 99 | 2 | 7 | 1130 | 907 | 2030 | Erysiphe necator associated ourmia-like virus 16 isolate PMS1_48, complete genome | blastn | 26242 | 1522 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 16 | ||
| 8604477 | 8604477 | PRJNA977246_S_NODE_39167_length_184_cov_4.580645_g38175_i0 | PRJNA977246 | 39167 | 184 | 4.580645 | 8.4283868 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 279 | 6.61e-71 | NTclustered | gi|1848976575|gb|MN611549.1| | 2741801 | g38175 | i0 | 94.022 | 1.98369565217391 | 184 | 11 | 100 | 0 | 1 | 184 | 1744 | 1927 | Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome | blastn | 365 | 279 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 11154378 | 11154378 | PRJNA977246_S_NODE_1429_length_1586_cov_1414.551702_g1246_i0 | PRJNA977246 | 1429 | 1586 | 1414.551702 | 22434.78999372 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 473 | 2.9399999999999996e-128 | NTclustered | gi|2320142628|gb|ON585088.1| | 2808997 | g1246 | i0 | 81.531 | 3.55296343001261 | 601 | 87 | 48 | 22 | 19 | 606 | 2541 | 1952 | MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds | blastn | 5635 | 473 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 11154393 | 11154393 | PRJNA977246_S_NODE_1469_length_1560_cov_214.896799_g1246_i1 | PRJNA977246 | 1469 | 1560 | 214.896799 | 3352.3900644 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 473 | 2.89e-128 | NTclustered | gi|2320142628|gb|ON585088.1| | 2808997 | g1246 | i1 | 81.531 | 0.497435897435897 | 601 | 87 | 49 | 22 | 955 | 1542 | 1952 | 2541 | MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds | blastn | 776 | 473 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 12430970 | 12430970 | PRJNA977246_S_NODE_48870_length_156_cov_4.228346_g47878_i0 | PRJNA977246 | 48870 | 156 | 4.228346 | 6.59621976 | Chrocagosk virus | 3129397 | Viruses | Viruses | 224 | 2.57e-54 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g47878 | i0 | 92.857 | 21.4487179487179 | 154 | 11 | 99 | 0 | 3 | 156 | 52 | 205 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 3346 | 224 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 14979310 | 14979310 | PRJNA977246_S_NODE_34992_length_201_cov_4.325581_g34000_i0 | PRJNA977246 | 34992 | 201 | 4.325581 | 8.69441781 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 309 | 9.39e-80 | NTclustered | gi|1848976575|gb|MN611549.1| | 2741801 | g34000 | i0 | 97.778 | 1.7910447761194 | 180 | 3 | 89 | 1 | 1 | 179 | 1423 | 1244 | Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome | blastn | 360 | 309 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 16253789 | 16253789 | PRJNA977246_S_NODE_16333_length_355_cov_2851.723926_g15342_i0 | PRJNA977246 | 16333 | 355 | 2851.723926 | 10123.6199373 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 547 | 3.5099999999999985e-151 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g15342 | i0 | 98.089 | 2.62816901408451 | 314 | 6 | 88 | 0 | 40 | 353 | 546 | 859 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 933 | 547 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 | ||
| 17529256 | 17529256 | PRJNA977246_S_NODE_28654_length_234_cov_9301.946341_g27662_i0 | PRJNA977246 | 28654 | 234 | 9301.946341 | 21766.55443794 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 326 | 1.12e-84 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g27662 | i0 | 98.378 | 71.2478632478633 | 185 | 3 | 79 | 0 | 50 | 234 | 57 | 241 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 16672 | 326 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 | ||
| 18803133 | 18803133 | PRJNA977246_S_NODE_33675_length_207_cov_3.960674_g32683_i0 | PRJNA977246 | 33675 | 207 | 3.960674 | 8.19859518 | Scleroulivirus xiplasmoparae | 2956422 | Viruses | Viruses | 350 | 5.74e-92 | NTclustered | gi|2500381397|ref|NC_076804.1| | 2686548 | g32683 | i0 | 100 | 2.35265700483092 | 189 | 0 | 91 | 0 | 19 | 207 | 100 | 288 | Plasmopara viticola lesion associated ourmia-like virus 75 isolate DMS5_37170 RNA dependent RNA polymerase (QKR80_gp1) gene, complete cds | blastn | 487 | 350 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus xiplasmoparae | ||
| 18803404 | 18803404 | PRJNA977246_S_NODE_48175_length_158_cov_2.565891_g47183_i0 | PRJNA977246 | 48175 | 158 | 2.565891 | 4.05410778 | Chrocagosk virus | 3129397 | Viruses | Viruses | 58.4 | 2.81e-4 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g47183 | i0 | 97.059 | 0.215189873417722 | 34 | 1 | 22 | 0 | 95 | 128 | 519 | 552 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 34 | 58.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 23904378 | 23904378 | PRJNA977246_S_NODE_899_length_2084_cov_57.987348_g815_i0 | PRJNA977246 | 899 | 2084 | 57.987348 | 1208.45633232 | Erysiphe necator associated ourmia-like virus 78 | 2741858 | Viruses | Viruses | 3299 | 0 | NTclustered | gi|1848976689|gb|MN611606.1| | 2741858 | g815 | i0 | 95.501 | 15.8214971209213 | 2067 | 90 | 99 | 1 | 21 | 2084 | 2340 | 274 | Erysiphe necator associated ourmia-like virus 78 isolate PMS3_72, complete genome | blastn | 32972 | 3299 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 78 | ||
| 25177256 | 25177256 | PRJNA977246_S_NODE_23820_length_272_cov_3.773663_g22828_i0 | PRJNA977246 | 23820 | 272 | 3.773663 | 10.26436336 | Penoulivirus alphaerysiphe | 3060537 | Viruses | Viruses | 425 | 1.28e-114 | NTclustered | gi|2500387314|ref|NC_077170.1| | 2741801 | g22828 | i0 | 94.853 | 3.62132352941176 | 272 | 14 | 100 | 0 | 1 | 272 | 1508 | 1779 | Erysiphe necator associated ourmia-like virus 21 isolate RDPM33, complete genome | blastn | 985 | 425 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 25177625 | 25177625 | PRJNA977246_S_NODE_37480_length_191_cov_2.543210_g36488_i0 | PRJNA977246 | 37480 | 191 | 2.54321 | 4.8575311 | Guiyang mito-like virus 5 | 2970163 | Viruses | Viruses | 248 | 1.95e-61 | NTclustered | gi|2284932518|gb|OM514568.1| | 2970163 | g36488 | i0 | 92.486 | 0.905759162303665 | 173 | 13 | 91 | 0 | 17 | 189 | 2141 | 2313 | MAG: Guiyang mito-like virus 5 isolate CQCGZ6 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 173 | 248 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Guiyang mito-like virus 5 |
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);;