contig_metadata
15 rows where bioproject = "PRJNA745553", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3275332 | 3275332 | PRJNA745553_S_NODE_10523_length_374_cov_5.362126_g10328_i0 | PRJNA745553 | 10523 | 374 | 5.362126 | 20.05435124 | Tonghua Botou tick virus 2 | 2972055 | Viruses | Viruses | 606 | 6.059999999999998e-169 | NTclustered | gi|2819062441|gb|PQ150489.1| | 2972055 | g10328 | i0 | 97.465 | 6.00802139037433 | 355 | 9 | 95 | 0 | 10 | 364 | 2289 | 1935 | MAG: Tonghua Botou tick virus 2 isolate Beijing_119 genomic sequence | blastn | 2247 | 606 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Tonghua Botou tick virus 2 | |||
| 8377526 | 8377526 | PRJNA745553_S_NODE_2067_length_650_cov_4.441941_g1895_i0 | PRJNA745553 | 2067 | 650 | 4.441941 | 28.8726165 | Dracophyllum associated narna-like virus 19 | 3066855 | Viruses | Viruses | 725 | 0 | NTclustered | gi|2626077411|gb|OQ987586.1| | 3066855 | g1895 | i0 | 87.619 | 9.36 | 630 | 70 | 96 | 7 | 19 | 641 | 1 | 629 | MAG: Dracophyllum associated narna-like virus 19 isolate DRALON genomic sequence | blastn | 6084 | 725 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Dracophyllum associated narna-like virus 19 | |||
| 10928265 | 10928265 | PRJNA745553_S_NODE_26989_length_240_cov_2.305389_g26794_i0 | PRJNA745553 | 26989 | 240 | 2.305389 | 5.5329336 | Sopafab virus | 3131770 | Viruses | Viruses | 231 | 2.58e-56 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g26794 | i0 | 84.047 | 63.45 | 257 | 23 | 100 | 12 | 1 | 240 | 51 | 306 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 15228 | 231 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 12203686 | 12203686 | PRJNA745553_S_NODE_2270_length_633_cov_5.900000_g2094_i0 | PRJNA745553 | 2270 | 633 | 5.9 | 37.347 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 230 | 2.7099999999999992e-55 | NTclustered | gi|2183453089|gb|MZ679401.1| | 2808997 | g2094 | i0 | 90.805 | 0.608214849921011 | 174 | 12 | 27 | 4 | 9 | 180 | 157 | 328 | MAG: Botourmiaviridae sp. isolate 110-k141_211195 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 385 | 230 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 16026890 | 16026890 | PRJNA745553_S_NODE_27473_length_236_cov_4.061350_g27278_i0 | PRJNA745553 | 27473 | 236 | 4.06135 | 9.584786 | Sopatuq virus | 3131685 | Viruses | Viruses | 135 | 2.04e-27 | NTclustered | gi|2717323148|gb|PP173986.1| | 3131685 | g27278 | i0 | 91.089 | 16.4915254237288 | 101 | 8 | 42 | 1 | 90 | 189 | 3138 | 3238 | MAG: Sopatuq virus isolate SP1B_k141_215904 genomic sequence | blastn | 3892 | 135 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sopatuq virus | |||
| 16027049 | 16027049 | PRJNA745553_S_NODE_7633_length_431_cov_2.642458_g7438_i0 | PRJNA745553 | 7633 | 431 | 2.642458 | 11.38899398 | Streptophyte associated narna-like virus 9 | 3067074 | Viruses | Viruses | 115 | 5.550000000000001e-27 | NR | WPR17282.1 | 3067074 | g7438 | i0 | 79.5 | 1.00232018561485 | 73 | 14 | 50.8 | 1 | 2 | 220 | 491 | 562 | WPR17282.1 MAG: RNA-dependent RNA polymerase, partial [Streptophyte associated narna-like virus 9] | diamond | 432 | 115 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Streptophyte associated narna-like virus 9 | |||
| 17302385 | 17302385 | PRJNA745553_S_NODE_27434_length_236_cov_7.042945_g27239_i0 | PRJNA745553 | 27434 | 236 | 7.042945 | 16.6213502 | Chrocagost virus | 3129398 | Viruses | Viruses | 204 | 5.519999999999999e-48 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g27239 | i0 | 83.721 | 740.546610169491 | 215 | 35 | 91 | 0 | 10 | 224 | 5648 | 5862 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 174769 | 204 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 17302442 | 17302442 | PRJNA745553_S_NODE_3174_length_579_cov_2.604743_g2991_i0 | PRJNA745553 | 3174 | 579 | 2.604743 | 15.08146197 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 316 | 1.84e-81 | NTclustered | gi|2395813225|gb|ON811959.1| | 2583949 | g2991 | i0 | 77.281 | 8.01554404145078 | 559 | 113 | 95 | 14 | 2 | 553 | 1355 | 1906 | MAG: Narnaviridae sp. isolate TIGMIC_1, complete genome | blastn | 4641 | 316 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 19851058 | 19851058 | PRJNA745553_S_NODE_12096_length_352_cov_8.283154_g11901_i0 | PRJNA745553 | 12096 | 352 | 8.283154 | 29.15670208 | Sopawol virus | 3131668 | Viruses | Viruses | 433 | 1.0199999999999999e-116 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g11901 | i0 | 93.22 | 81.3068181818182 | 295 | 18 | 83 | 2 | 12 | 304 | 296 | 2 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 28620 | 433 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 21126905 | 21126905 | PRJNA745553_S_NODE_29757_length_213_cov_9.307143_g29562_i0 | PRJNA745553 | 29757 | 213 | 9.307143 | 19.82421459 | Chrocagost virus | 3129398 | Viruses | Viruses | 189 | 1.37e-43 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g29562 | i0 | 84.375 | 65.6009389671361 | 192 | 30 | 90 | 0 | 2 | 193 | 5648 | 5839 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 13973 | 189 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 26863272 | 26863272 | PRJNA745553_S_NODE_4201_length_533_cov_2.904348_g4011_i0 | PRJNA745553 | 4201 | 533 | 2.904348 | 15.48017484 | Cryphonectria naterciae splipalmivirus 1 | 2841740 | Viruses | Viruses | 52 | 1.46e-4 | NR | BCX55512.1 | 2841740 | g4011 | i0 | 32 | 0.579737335834897 | 103 | 67 | 56.3 | 1 | 480 | 181 | 78 | 180 | BCX55512.1 hypothetical protein 2 [Cryphonectria naterciae splipalmivirus 1] | diamond | 309 | 52 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Divipalmivirus | Divipalmivirus cryphonectriae | ||
| 28316115 | 28316115 | PRJNA745553_S_NODE_20186_length_275_cov_3.049505_g19991_i0 | PRJNA745553 | 20186 | 275 | 3.049505 | 8.38613875 | Plasmopara viticola lesion associated ourmia-like virus 19 | 2686486 | Viruses | Viruses | 98.6 | 1.2600000000000002e-21 | NR | YP_010800219.1 | 2686486 | g19991 | i0 | 50.5 | 0.992727272727273 | 91 | 45 | 99.3 | 0 | 274 | 2 | 1 | 91 | YP_010800219.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 19] | diamond | 273 | 98.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus omicronplasmoparae | ||
| 30274206 | 30274206 | PRJNA745553_S_NODE_16052_length_308_cov_2.025532_g15857_i0 | PRJNA745553 | 16052 | 308 | 2.025532 | 6.23863856 | Oidiodendron maius splipalmivirus 1 | 2769353 | Viruses | Viruses | 93.2 | 1.51e-19 | NR | UJT31791.1 | 2769353 | g15857 | i0 | 55.8 | 0.925324675324675 | 95 | 42 | 92.5 | 0 | 288 | 4 | 1 | 95 | UJT31791.1 hypothetical protein [Oidiodendron maius splipalmivirus 1] | diamond | 285 | 93.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Splipalmiviridae | Delepalmivirus | Delepalmivirus oidiodendri | ||
| 30589783 | 30589783 | PRJNA745553_S_NODE_433_length_966_cov_2.524076_g354_i0 | PRJNA745553 | 433 | 966 | 2.524076 | 24.38257416 | Fusarium oxysporum f. sp. cubense ourmia-like virus 3 | 3038613 | Viruses | Viruses | 353 | 2.0999999999999997e-113 | NR | WNK16432.1 | 3038613 | g354 | i0 | 56.8 | 2 | 322 | 136 | 100 | 2 | 966 | 1 | 83 | 401 | WNK16432.1 MAG: RNA-dependent RNA polymerase [Fusarium oxysporum f. sp. cubense ourmia-like virus 3] | diamond | 1932 | 353 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Fusarium oxysporum f. sp. cubense ourmia-like virus 3 | |||
| 31664486 | 31664486 | PRJNA745553_S_NODE_22377_length_261_cov_7.031915_g22182_i0 | PRJNA745553 | 22377 | 261 | 7.031915 | 18.35329815 | Erysiphe necator associated ourmia-like virus 1 | 2689557 | Viruses | Viruses | 125 | 3.53e-31 | NR | QGZ98421.1 | 2689557 | g22182 | i0 | 77.5 | 1.83908045977011 | 80 | 18 | 92 | 0 | 241 | 2 | 605 | 684 | QGZ98421.1 RNA dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 1] | diamond | 480 | 125 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Erysiphe necator associated ourmia-like virus 1 |
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);;