contig_metadata
18 rows where bioproject = "PRJNA432257", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1704208 | 1704208 | PRJNA432257_S_NODE_19942_length_322_cov_14.628070_g19561_i0 | PRJNA432257 | 19942 | 322 | 14.62807 | 47.1023854 | Monilinia fructicola mitovirus 10 | 2964643 | Viruses | Viruses | 340 | 5.76e-89 | NTclustered | gi|2273758207|gb|ON038384.1| | 2964643 | g19561 | i0 | 92.766 | 1.11490683229814 | 235 | 17 | 73 | 0 | 3 | 237 | 248 | 14 | Monilinia fructicola mitovirus 10 RNA-dependent RNA polymerase gene, complete cds | blastn | 359 | 340 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Monilinia fructicola mitovirus 10 | ||
| 2980197 | 2980197 | PRJNA432257_S_NODE_32983_length_270_cov_2.128755_g32602_i0 | PRJNA432257 | 32983 | 270 | 2.128755 | 5.7476385 | Magoulivirus jiplasmoparae | 2956162 | Viruses | Viruses | 405 | 1.65e-108 | NTclustered | gi|2500381287|ref|NC_076761.1| | 2686494 | g32602 | i0 | 96 | 1.85185185185185 | 250 | 9 | 92 | 1 | 1 | 249 | 607 | 358 | Plasmopara viticola lesion associated ourmia-like virus 26 isolate DMS1_25556 RNA dependent RNA polymerase (QKR36_gp1) gene, complete cds | blastn | 500 | 405 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae | ||
| 4256633 | 4256633 | PRJNA432257_S_NODE_4384_length_549_cov_44.966797_g4141_i0 | PRJNA432257 | 4384 | 549 | 44.966797 | 246.86771553 | Downy mildew lesion associated splipalmivirus 4 | 2719525 | Viruses | Viruses | 135 | 9.29e-36 | NR | WNA22213.1 | 2719525 | g4141 | i0 | 65.5 | 0.650273224043716 | 119 | 40 | 65 | 1 | 37 | 393 | 121 | 238 | WNA22213.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 4] | diamond | 357 | 135 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 5534049 | 5534049 | PRJNA432257_S_NODE_92365_length_182_cov_4.096552_g91984_i0 | PRJNA432257 | 92365 | 182 | 4.096552 | 7.45572464 | Erysiphe necator associated ourmia-like virus 78 | 2741858 | Viruses | Viruses | 287 | 3.9e-73 | NTclustered | gi|1848976689|gb|MN611606.1| | 2741858 | g91984 | i0 | 99.367 | 2.20879120879121 | 158 | 1 | 87 | 0 | 1 | 158 | 2343 | 2186 | Erysiphe necator associated ourmia-like virus 78 isolate PMS3_72, complete genome | blastn | 402 | 287 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 78 | ||
| 10634162 | 10634162 | PRJNA432257_S_NODE_88889_length_185_cov_2.391892_g88508_i0 | PRJNA432257 | 88889 | 185 | 2.391892 | 4.4250002 | Suillus luteus narnavirus 8 | 3067827 | Viruses | Viruses | 191 | 3.210000000000001e-44 | NTclustered | gi|2560562950|gb|OQ862543.1| | 3067827 | g88508 | i0 | 87.73 | 2.5027027027027 | 163 | 20 | 88 | 0 | 2 | 164 | 1817 | 1655 | Suillus luteus narnavirus 8 isolate SlNV8 RNA-dependent RNA polymerase gene, complete cds | blastn | 463 | 191 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Suillus luteus narnavirus 8 | ||
| 11908229 | 11908229 | PRJNA432257_S_NODE_28670_length_283_cov_225.898374_g28289_i0 | PRJNA432257 | 28670 | 283 | 225.898374 | 639.29239842 | Ripaflec virus | 3130560 | Viruses | Viruses | 279 | 1.1e-70 | NTclustered | gi|2717320098|gb|PP172862.1| | 3130560 | g28289 | i0 | 87.251 | 130.399293286219 | 251 | 24 | 88 | 8 | 1 | 248 | 5266 | 5511 | MAG: Ripaflec virus isolate KCAP2_k141_128097 genomic sequence | blastn | 36903 | 279 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripaflec virus | |||||
| 15732398 | 15732398 | PRJNA432257_S_NODE_50133_length_231_cov_1.958763_g49752_i0 | PRJNA432257 | 50133 | 231 | 1.958763 | 4.52474253 | Magoulivirus jiplasmoparae | 2956162 | Viruses | Viruses | 387 | 4.98e-103 | NTclustered | gi|2500381287|ref|NC_076761.1| | 2686494 | g49752 | i0 | 96.97 | 3.67099567099567 | 231 | 6 | 100 | 1 | 1 | 231 | 2317 | 2088 | Plasmopara viticola lesion associated ourmia-like virus 26 isolate DMS1_25556 RNA dependent RNA polymerase (QKR36_gp1) gene, complete cds | blastn | 848 | 387 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae | ||
| 18281209 | 18281209 | PRJNA432257_S_NODE_37675_length_257_cov_2.509091_g37294_i0 | PRJNA432257 | 37675 | 257 | 2.509091 | 6.44836387 | Suillus luteus narnavirus 8 | 3067827 | Viruses | Viruses | 313 | 9.71e-81 | NTclustered | gi|2560562950|gb|OQ862543.1| | 3067827 | g37294 | i0 | 88.976 | 1.78988326848249 | 254 | 27 | 98 | 1 | 5 | 257 | 2051 | 1798 | Suillus luteus narnavirus 8 isolate SlNV8 RNA-dependent RNA polymerase gene, complete cds | blastn | 460 | 313 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Suillus luteus narnavirus 8 | ||
| 18281685 | 18281685 | PRJNA432257_S_NODE_72995_length_200_cov_2.865031_g72614_i0 | PRJNA432257 | 72995 | 200 | 2.865031 | 5.730062 | Erysiphe necator associated ourmia-like virus 85 | 2741865 | Viruses | Viruses | 337 | 4.28e-88 | NTclustered | gi|1848976703|gb|MN611613.1| | 2741865 | g72614 | i0 | 97 | 2.91 | 200 | 6 | 100 | 0 | 1 | 200 | 780 | 581 | Erysiphe necator associated ourmia-like virus 85 isolate PMS4_45, complete genome | blastn | 582 | 337 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 85 | ||
| 18940331 | 18940331 | PRJNA432257_S_NODE_68995_length_204_cov_167.946108_g68614_i0 | PRJNA432257 | 68995 | 204 | 167.946108 | 342.61006032 | Botourmiaviridae | 2560063 | Viruses | Viruses | 283 | 5.8e-72 | NTclustered | gi|2500381287|ref|NC_076761.1| | 2686494 | g68614 | i0 | 97.024 | 1.64705882352941 | 168 | 5 | 82 | 0 | 1 | 168 | 285 | 118 | Plasmopara viticola lesion associated ourmia-like virus 26 isolate DMS1_25556 RNA dependent RNA polymerase (QKR36_gp1) gene, complete cds | blastn | 336 | 283 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae | ||
| 23381745 | 23381745 | PRJNA432257_S_NODE_35879_length_261_cov_1092.883929_g35498_i0 | PRJNA432257 | 35879 | 261 | 1092.883929 | 2852.42705469 | Chrocagost virus | 3129398 | Viruses | Viruses | 305 | 1.65e-78 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g35498 | i0 | 92.891 | 168.984674329502 | 211 | 13 | 80 | 2 | 1 | 209 | 5652 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 44105 | 305 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 27265541 | 27265541 | PRJNA432257_S_NODE_52303_length_227_cov_5.178947_g51922_i0 | PRJNA432257 | 52303 | 227 | 5.178947 | 11.75620969 | Downy mildew lesion associated splipalmivirus 4 | 2719525 | Viruses | Viruses | 57.8 | 9.15e-8 | NR | WNA22213.1 | 2719525 | g51922 | i0 | 44.8 | 1.40088105726872 | 58 | 32 | 76.7 | 0 | 191 | 18 | 5 | 62 | WNA22213.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 4] | diamond | 318 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Jakapalmivirus | Jakapalmivirus italiense | ||
| 27455232 | 27455232 | PRJNA432257_S_NODE_89063_length_185_cov_1.702703_g88682_i0 | PRJNA432257 | 89063 | 185 | 1.702703 | 3.15000055 | Sjack associated botourmia-like virus 22 | 3066747 | Viruses | Viruses | 57.8 | 8.51e-8 | NR | WPR16987.1 | 3066747 | g88682 | i0 | 60 | 0.810810810810811 | 50 | 20 | 81.1 | 0 | 33 | 182 | 538 | 587 | WPR16987.1 MAG: RNA-dependent RNA polymerase, partial [Sjack associated botourmia-like virus 22] | diamond | 150 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sjack associated botourmia-like virus 22 | |||
| 28465537 | 28465537 | PRJNA432257_S_NODE_58806_length_217_cov_96.222222_g58425_i0 | PRJNA432257 | 58806 | 217 | 96.222222 | 208.80222174 | Yunnan mito-like virus 59 | 2937265 | Viruses | Viruses | 88.2 | 2.64e-18 | NR | UPW42189.1 | 2937265 | g58425 | i0 | 66.7 | 0.829493087557604 | 60 | 20 | 82.9 | 0 | 180 | 1 | 539 | 598 | UPW42189.1 MAG: putative RNA dependent RNA polymerase, partial [Yunnan mito-like virus 59] | diamond | 180 | 88.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Yunnan mito-like virus 59 | |||
| 28465560 | 28465560 | PRJNA432257_S_NODE_9946_length_409_cov_124.607527_g9594_i0 | PRJNA432257 | 9946 | 409 | 124.607527 | 509.64478543 | Exserohilum turcicum narnavirus 1 | 3229034 | Viruses | Viruses | 67.8 | 3.37e-10 | NR | XBY85592.1 | 3229034 | g9594 | i0 | 50 | 0.645476772616137 | 88 | 24 | 57.2 | 4 | 376 | 143 | 1 | 78 | XBY85592.1 MAG: hypothetical protein [Exserohilum turcicum narnavirus 1] | diamond | 264 | 67.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Exserohilum turcicum narnavirus 1 | ||
| 28560242 | 28560242 | PRJNA432257_S_NODE_73867_length_199_cov_3.574074_g73486_i0 | PRJNA432257 | 73867 | 199 | 3.574074 | 7.11240726 | Suillus luteus narnavirus 8 | 3067827 | Viruses | Viruses | 109 | 7.19e-26 | NR | WLK77416.1 | 3067827 | g73486 | i0 | 75.7 | 1.11557788944724 | 74 | 9 | 98 | 1 | 3 | 197 | 7 | 80 | WLK77416.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 8] | diamond | 222 | 109 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Suillus luteus narnavirus 8 | ||
| 29949508 | 29949508 | PRJNA432257_S_NODE_82011_length_191_cov_2.409091_g81630_i0 | PRJNA432257 | 82011 | 191 | 2.409091 | 4.60136381 | Suillus luteus narnavirus 8 | 3067827 | Viruses | Viruses | 117 | 1.3e-28 | NR | WLK77416.1 | 3067827 | g81630 | i0 | 84.1 | 0.989528795811518 | 63 | 10 | 99 | 0 | 190 | 2 | 673 | 735 | WLK77416.1 RNA-dependent RNA polymerase [Suillus luteus narnavirus 8] | diamond | 189 | 117 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Suillus luteus narnavirus 8 | ||
| 30107272 | 30107272 | PRJNA432257_S_NODE_100992_length_175_cov_27.202899_g100611_i0 | PRJNA432257 | 100992 | 175 | 27.202899 | 47.60507325 | Plasmopara viticola lesion associated ourmia-like virus 26 | 2686494 | Viruses | Viruses | 69.3 | 6.33e-12 | NR | YP_010800226.1 | 2686494 | g100611 | i0 | 91.7 | 0.617142857142857 | 36 | 3 | 61.7 | 0 | 141 | 34 | 565 | 600 | YP_010800226.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 26] | diamond | 108 | 69.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus jiplasmoparae |
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);;