contig_metadata
12 rows where bioproject = "PRJNA1137393", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1559393 | 1559393 | PRJNA1137393_P_NODE_6102_length_348_cov_3.040134_g5586_i0 | PRJNA1137393 | 6102 | 348 | 3.040134 | 10.57966632 | Sopatrul virus | 3131609 | Viruses | Viruses | 350 | 1.04e-91 | NTclustered | gi|2717322931|gb|PP173910.1| | 3131609 | g5586 | i0 | 86.462 | 53.7873563218391 | 325 | 37 | 92 | 5 | 29 | 348 | 687 | 365 | MAG: Sopatrul virus isolate SP1A_k141_123728 genomic sequence | blastn | 18718 | 350 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopatrul virus | |||||
| 7937705 | 7937705 | PRJNA1137393_P_NODE_21547_length_197_cov_2.290541_g21031_i0 | PRJNA1137393 | 21547 | 197 | 2.290541 | 4.51236577 | Ripagron virus | 3130596 | Viruses | Viruses | 119 | 1.66e-22 | NTclustered | gi|2717320202|gb|PP172898.1| | 3130596 | g21031 | i0 | 80.503 | 2.34010152284264 | 159 | 27 | 80 | 4 | 26 | 182 | 238 | 394 | MAG: Ripagron virus isolate KCAP2_k141_176596 genomic sequence | blastn | 461 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripagron virus | |||
| 18136376 | 18136376 | PRJNA1137393_P_NODE_18315_length_208_cov_1.238994_g17799_i0 | PRJNA1137393 | 18315 | 208 | 1.238994 | 2.57710752 | Moss associated botourmia-like virus 63 | 3066699 | Viruses | Viruses | 176 | 1.04e-39 | NTclustered | gi|2626076699|gb|OQ987193.1| | 3066699 | g17799 | i0 | 84.699 | 1.34134615384615 | 183 | 20 | 86 | 8 | 10 | 188 | 972 | 1150 | MAG: Moss associated botourmia-like virus 63 isolate DICBIL genomic sequence | blastn | 279 | 176 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Moss associated botourmia-like virus 63 | |||
| 23236945 | 23236945 | PRJNA1137393_P_NODE_12359_length_238_cov_3.994709_g11843_i0 | PRJNA1137393 | 12359 | 238 | 3.994709 | 9.50740742 | Chrocaryrb virus | 3129548 | Viruses | Viruses | 257 | 4.22e-64 | NTclustered | gi|2717317854|gb|PP171996.1| | 3129548 | g11843 | i0 | 86.42 | 205.012605042017 | 243 | 24 | 100 | 6 | 1 | 238 | 1305 | 1543 | MAG: Chrocaryrb virus isolate CC1C_k141_106130 genomic sequence | blastn | 48793 | 257 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocaryrb virus | |||||
| 24510691 | 24510691 | PRJNA1137393_P_NODE_48060_length_167_cov_0.881356_g47544_i0 | PRJNA1137393 | 48060 | 167 | 0.881356 | 1.47186452 | Sopapen virus | 3131614 | Viruses | Viruses | 71.3 | 3.87e-8 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g47544 | i0 | 88.136 | 1.61077844311377 | 59 | 7 | 35 | 0 | 109 | 167 | 527 | 469 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 269 | 71.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 29312493 | 29312493 | PRJNA1137393_P_NODE_47769_length_167_cov_1.322034_g47253_i0 | PRJNA1137393 | 47769 | 167 | 1.322034 | 2.20779678 | Moss associated botourmia-like virus 89 | 3066726 | Viruses | Viruses | 68.9 | 1.55e-12 | NR | WPR16895.1 | 3066726 | g47253 | i0 | 61.8 | 0.988023952095808 | 55 | 21 | 98.8 | 0 | 167 | 3 | 131 | 185 | WPR16895.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated botourmia-like virus 89] | diamond | 165 | 68.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Moss associated botourmia-like virus 89 | |||
| 29364789 | 29364789 | PRJNA1137393_P_NODE_9049_length_276_cov_1.709251_g8533_i0 | PRJNA1137393 | 9049 | 276 | 1.709251 | 4.71753276 | Magoulivirus | 2560172 | Viruses | Viruses | 55.1 | 2.5e-6 | NR | YP_010800216.1 | 2686483 | g8533 | i0 | 55 | 1.35869565217391 | 40 | 18 | 43.5 | 0 | 3 | 122 | 583 | 622 | YP_010800216.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 16] | diamond | 375 | 55.5 | 0.992792792792793 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Magoulivirus miplasmoparae | ||
| 29627759 | 29627759 | PRJNA1137393_P_NODE_17150_length_212_cov_1.773006_g16634_i0 | PRJNA1137393 | 17150 | 212 | 1.773006 | 3.75877272 | Sjack associated botourmia-like virus 15 | 3066740 | Viruses | Viruses | 119 | 3.69e-29 | NR | WPR16981.1 | 3066740 | g16634 | i0 | 71 | 0.976415094339623 | 69 | 20 | 97.6 | 0 | 208 | 2 | 228 | 296 | WPR16981.1 MAG: RNA-dependent RNA polymerase [Sjack associated botourmia-like virus 15] | diamond | 207 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sjack associated botourmia-like virus 15 | |||
| 29691022 | 29691022 | PRJNA1137393_P_NODE_39290_length_169_cov_1.300000_g38774_i0 | PRJNA1137393 | 39290 | 169 | 1.3 | 2.197 | Botourmiaviridae sp. | 2808997 | Viruses | Viruses | 79 | 2.14e-15 | NR | URG17172.1 | 2808997 | g38774 | i0 | 75.5 | 0.869822485207101 | 49 | 12 | 87 | 0 | 168 | 22 | 350 | 398 | URG17172.1 MAG: RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.] | diamond | 147 | 79 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Botourmiaviridae sp. | |||
| 30228284 | 30228284 | PRJNA1137393_P_NODE_64272_length_164_cov_0.904348_g63756_i0 | PRJNA1137393 | 64272 | 164 | 0.904348 | 1.48313072 | Sjack associated botourmia-like virus 15 | 3066740 | Viruses | Viruses | 73.6 | 1.72e-13 | NR | WPR16981.1 | 3066740 | g63756 | i0 | 71.7 | 0.969512195121951 | 53 | 14 | 97 | 1 | 161 | 3 | 452 | 503 | WPR16981.1 MAG: RNA-dependent RNA polymerase [Sjack associated botourmia-like virus 15] | diamond | 159 | 73.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sjack associated botourmia-like virus 15 | |||
| 31386771 | 31386771 | PRJNA1137393_P_NODE_74436_length_157_cov_2.472222_g73920_i0 | PRJNA1137393 | 74436 | 157 | 2.472222 | 3.88138854 | Viruses | 10239 | Viruses | Viruses | 65.9 | 7.78e-11 | NR | WLK77428.1 | 3067804 | g73920 | i0 | 58.8 | 2.92356687898089 | 51 | 21 | 97.5 | 0 | 155 | 3 | 122 | 172 | WLK77428.1 RNA-dependent RNA polymerase [Suillus luteus botourmiavirus 3] | diamond | 459 | 66.2 | 0.995468277945619 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Suillus luteus botourmiavirus 3 | |||
| 32188546 | 32188546 | PRJNA1137393_P_NODE_9578_length_268_cov_1.392694_g9062_i0 | PRJNA1137393 | 9578 | 268 | 1.392694 | 3.73241992 | Sjack associated botourmia-like virus 15 | 3066740 | Viruses | Viruses | 107 | 9.25e-25 | NR | WPR16981.1 | 3066740 | g9062 | i0 | 65.2 | 0.996268656716418 | 89 | 30 | 99.6 | 1 | 268 | 2 | 504 | 591 | WPR16981.1 MAG: RNA-dependent RNA polymerase [Sjack associated botourmia-like virus 15] | diamond | 267 | 107 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Sjack associated botourmia-like virus 15 |
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);;