contig_metadata
23 rows where bioproject = "PRJEB20058", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5125170 | 5125170 | PRJEB20058_S_NODE_5265_length_265_cov_5.112745_g5227_i0 | PRJEB20058 | 5265 | 265 | 5.112745 | 13.54877425 | Sopafab virus | 3131770 | Viruses | Viruses | 327 | 3.59e-85 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g5227 | i0 | 91.02 | 17.5283018867925 | 245 | 19 | 92 | 3 | 22 | 264 | 3299 | 3056 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 4645 | 327 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 25513209 | 25513209 | PRJEB20058_P_NODE_110297_length_384_cov_4.845201_g107485_i0 | PRJEB20058 | 110297 | 384 | 4.845201 | 18.60557184 | Erysiphe necator associated ourmia-like virus 78 | 2741858 | Viruses | Viruses | 603 | 8.069999999999998e-168 | NTclustered | gi|1848976689|gb|MN611606.1| | 2741858 | g107485 | i0 | 96.448 | 6.24479166666667 | 366 | 12 | 95 | 1 | 20 | 384 | 1981 | 2346 | Erysiphe necator associated ourmia-like virus 78 isolate PMS3_72, complete genome | blastn | 2398 | 603 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 78 | ||
| 25513683 | 25513683 | PRJEB20058_P_NODE_120537_length_363_cov_21.480132_g117720_i0 | PRJEB20058 | 120537 | 363 | 21.480132 | 77.97287916 | Sopaded virus | 3131761 | Viruses | Viruses | 82.4 | 4.39e-11 | NTclustered | gi|2717323334|gb|PP174062.1| | 3131761 | g117720 | i0 | 83.696 | 0.253443526170799 | 92 | 10 | 25 | 5 | 78 | 166 | 338 | 427 | MAG: Sopaded virus isolate SP1C_k141_196651 genomic sequence | blastn | 92 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopaded virus | |||||
| 25513780 | 25513780 | PRJEB20058_P_NODE_122777_length_359_cov_4.281879_g119960_i0 | PRJEB20058 | 122777 | 359 | 4.281879 | 15.37194561 | Downy mildew lesion associated splipalmivirus 2 | 2719503 | Viruses | Viruses | 385 | 2.95e-102 | NTclustered | gi|1826553983|gb|MN539819.1| | 2719503 | g119960 | i0 | 87.842 | 10.9944289693593 | 329 | 39 | 92 | 1 | 9 | 337 | 2537 | 2210 | Downy mildew lesion associated splipalmivirus 2 isolate DMG-E_DN28263 RNA-dependent RNA polymerase gene, complete cds | blastn | 3947 | 385 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Downy mildew lesion associated splipalmivirus 2 | ||
| 25648831 | 25648831 | PRJEB20058_P_NODE_103298_length_399_cov_33.653846_g100491_i0 | PRJEB20058 | 103298 | 399 | 33.653846 | 134.27884554 | Sopafab virus | 3131770 | Viruses | Viruses | 464 | 4.1399999999999996e-126 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g100491 | i0 | 89.488 | 282.77694235589 | 371 | 34 | 92 | 5 | 21 | 388 | 3410 | 3042 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 112828 | 464 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 25649525 | 25649525 | PRJEB20058_P_NODE_119410_length_365_cov_99.161184_g116594_i0 | PRJEB20058 | 119410 | 365 | 99.161184 | 361.9383216 | Sclerotinia sclerotiorum mitovirus 12-U | 2879881 | Viruses | Viruses | 331 | 3.97e-86 | NTclustered | gi|2111887202|gb|MW454895.1| | 2879881 | g116594 | i0 | 98.925 | 0.789041095890411 | 186 | 1 | 51 | 1 | 23 | 207 | 712 | 897 | Sclerotinia sclerotiorum mitovirus 12-U isolate GB375-6 RNA-dependent RNA polymerase gene, complete cds | blastn | 288 | 331 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Sclerotinia sclerotiorum mitovirus 12-U | ||
| 25790703 | 25790703 | PRJEB20058_P_NODE_241475_length_212_cov_5.589404_g238650_i0 | PRJEB20058 | 241475 | 212 | 5.589404 | 11.84953648 | Erysiphe necator associated ourmia-like virus 21 | 2741801 | Viruses | Viruses | 327 | 2.77e-85 | NTclustered | gi|1848976575|gb|MN611549.1| | 2741801 | g238650 | i0 | 97.884 | 2.81132075471698 | 189 | 4 | 89 | 0 | 24 | 212 | 23 | 211 | Erysiphe necator associated ourmia-like virus 21 isolate PMS10_36, complete genome | blastn | 596 | 327 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Penoulivirus | Penoulivirus alphaerysiphe | ||
| 25794123 | 25794123 | PRJEB20058_P_NODE_84083_length_450_cov_4.483290_g81295_i0 | PRJEB20058 | 84083 | 450 | 4.48329 | 20.174805 | Sopawol virus | 3131668 | Viruses | Viruses | 425 | 2.23e-114 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g81295 | i0 | 91.346 | 212.257777777778 | 312 | 26 | 69 | 1 | 41 | 352 | 70 | 380 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 95516 | 425 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 25923277 | 25923277 | PRJEB20058_P_NODE_150780_length_312_cov_14.274900_g147958_i0 | PRJEB20058 | 150780 | 312 | 14.2749 | 44.537688 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 525 | 1.4299999999999994e-144 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g147958 | i0 | 99.31 | 1.85897435897436 | 290 | 2 | 93 | 0 | 1 | 290 | 1888 | 1599 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 580 | 525 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 | ||
| 25923932 | 25923932 | PRJEB20058_P_NODE_166180_length_292_cov_2.549784_g163357_i0 | PRJEB20058 | 166180 | 292 | 2.549784 | 7.44536928 | Sopafab virus | 3131770 | Viruses | Viruses | 329 | 1.12e-85 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g163357 | i0 | 89.615 | 12.3458904109589 | 260 | 26 | 89 | 1 | 14 | 272 | 3042 | 3301 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 3605 | 329 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 25925385 | 25925385 | PRJEB20058_P_NODE_200924_length_255_cov_34.484536_g198100_i0 | PRJEB20058 | 200924 | 255 | 34.484536 | 87.9355668 | Chrocagost virus | 3129398 | Viruses | Viruses | 296 | 9.69e-76 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g198100 | i0 | 91.667 | 519.666666666667 | 216 | 15 | 84 | 3 | 28 | 241 | 5862 | 5648 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 132515 | 296 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 25928166 | 25928166 | PRJEB20058_P_NODE_4308_length_2186_cov_84.472471_g3531_i0 | PRJEB20058 | 4308 | 2186 | 84.472471 | 1846.56821606 | Erysiphe necator associated narnavirus 44 | 2736401 | Viruses | Viruses | 668 | 5.16e-230 | NR | QJT93776.1 | 2736401 | g3531 | i0 | 52.4 | 1.91720036596523 | 701 | 317 | 95 | 6 | 2124 | 49 | 1 | 693 | QJT93776.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 44] | diamond | 4191 | 668 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 44 | ||
| 26062259 | 26062259 | PRJEB20058_P_NODE_223397_length_240_cov_4.508380_g220572_i0 | PRJEB20058 | 223397 | 240 | 4.50838 | 10.820112 | Sonafor virus | 3131557 | Viruses | Viruses | 291 | 4.2e-74 | NTclustered | gi|2717322811|gb|PP173858.1| | 3131557 | g220572 | i0 | 92.233 | 153.325 | 206 | 14 | 85 | 2 | 17 | 221 | 2954 | 2750 | MAG: Sonafor virus isolate SN1_k141_345389 genomic sequence | blastn | 36798 | 291 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sonafor virus | |||||
| 26065076 | 26065076 | PRJEB20058_P_NODE_59333_length_544_cov_4.662526_g56578_i0 | PRJEB20058 | 59333 | 544 | 4.662526 | 25.36414144 | Sopapen virus | 3131614 | Viruses | Viruses | 152 | 5.13e-32 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g56578 | i0 | 77.818 | 80.5477941176471 | 275 | 41 | 48 | 15 | 77 | 335 | 303 | 573 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 43818 | 152 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 26196438 | 26196438 | PRJEB20058_P_NODE_171702_length_285_cov_6.651786_g168879_i0 | PRJEB20058 | 171702 | 285 | 6.651786 | 18.9575901 | Ripakrev virus | 3130833 | Viruses | Viruses | 257 | 5.2e-64 | NTclustered | gi|2717320899|gb|PP173135.1| | 3130833 | g168879 | i0 | 84.942 | 115.99649122807 | 259 | 33 | 90 | 6 | 8 | 263 | 4358 | 4103 | MAG: Ripakrev virus isolate KCAP3_k141_172486 genomic sequence | blastn | 33059 | 257 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripakrev virus | |||||
| 26329837 | 26329837 | PRJEB20058_P_NODE_11743_length_1212_cov_10.066898_g10156_i0 | PRJEB20058 | 11743 | 1212 | 10.066898 | 122.01080376 | Chenopodium quinoa mitovirus 1 | 2185087 | Viruses | Viruses | 2163 | 0 | NTclustered | gi|1571831372|ref|NC_040543.1| | 2185087 | g10156 | i0 | 99.662 | 1.95214521452145 | 1183 | 4 | 98 | 0 | 30 | 1212 | 1 | 1183 | Chenopodium quinoa mitovirus 1 isolate Che1, complete genome | blastn | 2366 | 2163 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Duamitovirus | Duamitovirus chqu1 | ||
| 26333386 | 26333386 | PRJEB20058_P_NODE_199823_length_256_cov_5.794872_g196999_i0 | PRJEB20058 | 199823 | 256 | 5.794872 | 14.83487232 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 399 | 7.209999999999998e-107 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g196999 | i0 | 96.667 | 1.875 | 240 | 8 | 94 | 0 | 17 | 256 | 1647 | 1886 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 480 | 399 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 | ||
| 26335446 | 26335446 | PRJEB20058_P_NODE_28575_length_784_cov_2.322268_g26172_i0 | PRJEB20058 | 28575 | 784 | 2.322268 | 18.20658112 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 1256 | 0 | NTclustered | gi|2320142606|gb|ON585076.1| | 2808997 | g26172 | i0 | 96.457 | 2.55867346938776 | 762 | 25 | 97 | 1 | 23 | 784 | 1473 | 2232 | MAG: Botourmiaviridae sp. isolate PMS1_DN1240 RNA-dependent RNA polymerase gene, complete cds | blastn | 2006 | 1256 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 26337539 | 26337539 | PRJEB20058_P_NODE_65599_length_516_cov_3.054945_g62832_i0 | PRJEB20058 | 65599 | 516 | 3.054945 | 15.7635162 | Chrocaferb virus | 3129387 | Viruses | Viruses | 206 | 3.67e-48 | NTclustered | gi|2717317453|gb|PP171835.1| | 3129387 | g62832 | i0 | 78.914 | 27.1492248062016 | 313 | 58 | 60 | 7 | 30 | 341 | 260 | 565 | MAG: Chrocaferb virus isolate CC1A_k141_77359 genomic sequence | blastn | 14009 | 206 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocaferb virus | |||||
| 26467730 | 26467730 | PRJEB20058_P_NODE_153040_length_309_cov_6.318548_g150217_i0 | PRJEB20058 | 153040 | 309 | 6.318548 | 19.52431332 | Erysiphe necator associated ourmia-like virus 41 | 2741821 | Viruses | Viruses | 490 | 5.159999999999998e-134 | NTclustered | gi|2396039960|gb|ON812995.1| | 2741821 | g150217 | i0 | 95.484 | 5.6084142394822 | 310 | 8 | 100 | 2 | 1 | 309 | 2243 | 1939 | MAG: Erysiphe necator associated ourmia-like virus 41 isolate TIGMIC_10, complete genome | blastn | 1733 | 490 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 41 | ||
| 32945427 | 32945427 | PRJEB20058_P_NODE_235602_length_224_cov_24.877301_g232777_i0 | PRJEB20058 | 235602 | 224 | 24.877301 | 55.72515424 | Leviviridae sp. | 2027243 | Viruses | Viruses | 77.8 | 1.29e-14 | NR | URG15527.1 | 2027243 | g232777 | i0 | 61.2 | 0.897321428571429 | 67 | 26 | 89.7 | 0 | 24 | 224 | 291 | 357 | URG15527.1 MAG: RNA dependent RNA polymerase [Leviviridae sp.] | diamond | 201 | 77.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 33013839 | 33013839 | PRJEB20058_P_NODE_46812_length_615_cov_3.765343_g44113_i0 | PRJEB20058 | 46812 | 615 | 3.765343 | 23.15685945 | ssRNA phage SRR797631 | 2844826 | Viruses | Viruses | 126 | 1.18e-29 | NR | YP_010770674.1 | 2786676 | g44113 | i0 | 49.2 | 0.624390243902439 | 128 | 65 | 62.4 | 0 | 230 | 613 | 129 | 256 | YP_010770674.1 RNA-directed RNA polymerase [ssRNA phage SRR7976310_14] | diamond | 384 | 126 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Henifovirus | Henifovirus sp. 'caenadaptatum' | ||
| 33115322 | 33115322 | PRJEB20058_P_NODE_116503_length_371_cov_5.167742_g113688_i0 | PRJEB20058 | 116503 | 371 | 5.167742 | 19.17232282 | Hangzhou mitovirus 6 | 2905241 | Viruses | Viruses | 112 | 8.51e-26 | NR | UHK03232.1 | 2905241 | g113688 | i0 | 50.4 | 2.88679245283019 | 123 | 56 | 99.5 | 2 | 1 | 369 | 380 | 497 | UHK03232.1 MAG: RNA-dependent RNA polymerase [Hangzhou mitovirus 6] | diamond | 1071 | 112 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 6 |
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);;