contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 |
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);;