contig_metadata
17 rows where bioproject = "PRJEB11748", tax_phylum = "Duplornaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6397469 | 6397469 | PRJEB11748_P_NODE_4766_length_2207_cov_32.151911_g4227_i0 | PRJEB11748 | 4766 | 2207 | 32.151911 | 709.59267577 | Erysiphe necator associated totivirus 5 | 2737095 | Viruses | Viruses | 2398 | 0 | NTclustered | gi|1843473447|gb|MN617026.1| | 2737095 | g4227 | i0 | 86.608 | 0.984594472134119 | 2173 | 288 | 98 | 3 | 1 | 2171 | 2172 | 1 | Erysiphe necator associated totivirus 5 isolate PMS5_DN34825, complete genome | blastn | 2173 | 2398 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 5 | ||
| 22966745 | 22966745 | PRJEB11748_P_NODE_148519_length_337_cov_2.706522_g146338_i0 | PRJEB11748 | 148519 | 337 | 2.706522 | 9.12097914 | Coltivirus dermacentoris | 3428066 | Viruses | Viruses | 477 | 4.429999999999998e-130 | NTclustered | gi|2758887253|gb|PP473574.1| | 46839 | g146338 | i0 | 94.006 | 91.1275964391691 | 317 | 15 | 93 | 3 | 3 | 317 | 4983 | 5297 | MAG: Colorado tick fever virus isolate HL11 segment 1, complete sequence | blastn | 30710 | 477 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Spinareoviridae | Coltivirus | Coltivirus dermacentoris | ||
| 28289850 | 28289850 | PRJEB11748_P_NODE_43186_length_659_cov_6.217391_g41125_i0 | PRJEB11748 | 43186 | 659 | 6.217391 | 40.97260669 | Victorivirus | 674981 | Viruses | Viruses | 229 | 2.21e-66 | NR | NP_047557.1 | 73497 | g41125 | i0 | 72.3 | 2.73141122913505 | 148 | 41 | 67.4 | 0 | 139 | 582 | 552 | 699 | NP_047557.1 coat protein [Sphaeropsis sapinea RNA virus 1] | diamond | 1800 | 230 | 0.995652173913044 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Pseudototiviridae | Victorivirus | Victorivirus sani | ||
| 28637509 | 28637509 | PRJEB11748_P_NODE_147327_length_338_cov_10.490975_g145146_i0 | PRJEB11748 | 147327 | 338 | 10.490975 | 35.4594955 | Victorivirus | 674981 | Viruses | Viruses | 69.7 | 3.92e-11 | NR | NP_047558.1 | 73497 | g145146 | i0 | 52.9 | 1.29585798816568 | 68 | 32 | 60.4 | 0 | 261 | 58 | 121 | 188 | NP_047558.1 RNA dependent RNA polymerase [Sphaeropsis sapinea RNA virus 1] | diamond | 438 | 69.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Pseudototiviridae | Victorivirus | Victorivirus sani | ||
| 28706774 | 28706774 | PRJEB11748_P_NODE_253467_length_244_cov_95.000000_g251284_i0 | PRJEB11748 | 253467 | 244 | 95 | 231.8 | Alphachrysovirus sp. | 2809129 | Viruses | Viruses | 139 | 1.87e-36 | NR | UHS72404.1 | 2809129 | g251284 | i0 | 84.7 | 0.885245901639344 | 72 | 11 | 88.5 | 0 | 216 | 1 | 578 | 649 | UHS72404.1 MAG: putative RNA-dependent RNA polymerase, partial [Alphachrysovirus sp.] | diamond | 216 | 139 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus sp. | ||
| 29117242 | 29117242 | PRJEB11748_P_NODE_175589_length_306_cov_5.126531_g173406_i0 | PRJEB11748 | 175589 | 306 | 5.126531 | 15.68718486 | Erysiphales associated totivirus 21 | 2719851 | Viruses | Viruses | 80.1 | 5.8e-15 | NR | QIP68083.1 | 2719851 | g173406 | i0 | 46.6 | 0.862745098039216 | 88 | 47 | 86.3 | 0 | 283 | 20 | 424 | 511 | QIP68083.1 coat protein [Erysiphales associated totivirus 21] | diamond | 264 | 80.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphales associated totivirus 21 | ||
| 29212015 | 29212015 | PRJEB11748_P_NODE_258209_length_242_cov_1.591160_g256026_i0 | PRJEB11748 | 258209 | 242 | 1.59116 | 3.8506072 | Xanthophyllomyces dendrorhous virus L1B | 1167691 | Viruses | Viruses | 89 | 1.97e-18 | NR | YP_009507834.1 | 1167691 | g256026 | i0 | 61.1 | 0.892561983471074 | 72 | 28 | 89.3 | 0 | 241 | 26 | 612 | 683 | YP_009507834.1 capsid protein [Xanthophyllomyces dendrorhous virus L1B] | diamond | 216 | 89 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus go | ||
| 29780262 | 29780262 | PRJEB11748_P_NODE_49251_length_612_cov_3.520871_g47152_i0 | PRJEB11748 | 49251 | 612 | 3.520871 | 21.547730520000002 | Hortaea werneckii totivirus 1 | 2501057 | Viruses | Viruses | 196 | 1.1399999999999999e-54 | NR | AZT88647.1 | 2501057 | g47152 | i0 | 49.7 | 0.965686274509804 | 197 | 99 | 96.6 | 0 | 591 | 1 | 600 | 796 | AZT88647.1 RNA-dependent RNA polymerase [Hortaea werneckii totivirus 1] | diamond | 591 | 196 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Hortaea werneckii totivirus 1 | |||
| 29969701 | 29969701 | PRJEB11748_P_NODE_337331_length_203_cov_7.781690_g335148_i0 | PRJEB11748 | 337331 | 203 | 7.78169 | 15.7968307 | Ripucyv virus | 3130341 | Viruses | Viruses | 72.8 | 5.6e-13 | NR | WZH59461.1 | 3130341 | g335148 | i0 | 71.2 | 1.68472906403941 | 52 | 15 | 76.8 | 0 | 158 | 3 | 266 | 317 | WZH59461.1 MAG: RNA-dependent RNA polymerase, partial [Ripucyv virus] | diamond | 342 | 72.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Ripucyv virus | ||||
| 30412431 | 30412431 | PRJEB11748_P_NODE_54833_length_576_cov_20.328155_g52714_i0 | PRJEB11748 | 54833 | 576 | 20.328155 | 117.0901728 | Sphaeropsis sapinea RNA virus 1 | 73497 | Viruses | Viruses | 88.6 | 1.33e-16 | NR | NP_047557.1 | 73497 | g52714 | i0 | 46.3 | 0.640625 | 123 | 41 | 60.4 | 5 | 368 | 21 | 31 | 135 | NP_047557.1 coat protein [Sphaeropsis sapinea RNA virus 1] | diamond | 369 | 88.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Pseudototiviridae | Victorivirus | Victorivirus sani | ||
| 30753390 | 30753390 | PRJEB11748_P_NODE_289614_length_224_cov_16.190184_g287431_i0 | PRJEB11748 | 289614 | 224 | 16.190184 | 36.26601216 | Totivirus | 11007 | Viruses | Viruses | 45.4 | 0.0032 | NR | QOQ37362.1 | 2776824 | g287431 | i0 | 67.6 | 0.910714285714286 | 34 | 11 | 45.5 | 0 | 146 | 45 | 237 | 270 | QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 204 | 45.8 | 0.991266375545852 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 30854401 | 30854401 | PRJEB11748_P_NODE_60194_length_547_cov_10.514403_g58061_i0 | PRJEB11748 | 60194 | 547 | 10.514403 | 57.51378441 | Erysiphe necator associated totivirus 6 | 2737096 | Viruses | Viruses | 145 | 9.32e-37 | NR | QJW70335.1 | 2737096 | g58061 | i0 | 46 | 1.64533820840951 | 150 | 80 | 82.3 | 1 | 510 | 61 | 648 | 796 | QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6] | diamond | 900 | 145 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 6 | ||
| 31107058 | 31107058 | PRJEB11748_P_NODE_364255_length_190_cov_7.558140_g362072_i0 | PRJEB11748 | 364255 | 190 | 7.55814 | 14.360466 | Qianjiang toti-like virus 11 | 3348833 | Viruses | Viruses | 61.6 | 4.07e-9 | NR | XHA85766.1 | 3348833 | g362072 | i0 | 54.2 | 1.87894736842105 | 59 | 27 | 93.2 | 0 | 13 | 189 | 308 | 366 | XHA85766.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang toti-like virus 11] | diamond | 357 | 61.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Qianjiang toti-like virus 11 | |||
| 31739396 | 31739396 | PRJEB11748_P_NODE_222177_length_266_cov_1.834146_g219994_i0 | PRJEB11748 | 222177 | 266 | 1.834146 | 4.87882836 | Totivirus sp. | 2776824 | Viruses | Viruses | 47 | 0.00132 | NR | QOQ37363.1 | 2776824 | g219994 | i0 | 91.7 | 0.270676691729323 | 24 | 2 | 27.1 | 0 | 248 | 177 | 228 | 251 | QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.] | diamond | 72 | 47 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 31834197 | 31834197 | PRJEB11748_P_NODE_107717_length_401_cov_14.244118_g105543_i0 | PRJEB11748 | 107717 | 401 | 14.244118 | 57.11891318 | Sphaeropsis sapinea RNA virus 1 | 73497 | Viruses | Viruses | 167 | 3.65e-45 | NR | NP_047558.1 | 73497 | g105543 | i0 | 66.4 | 1.78802992518703 | 119 | 40 | 89 | 0 | 378 | 22 | 506 | 624 | NP_047558.1 RNA dependent RNA polymerase [Sphaeropsis sapinea RNA virus 1] | diamond | 717 | 167 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Pseudototiviridae | Victorivirus | Victorivirus sani | ||
| 32404143 | 32404143 | PRJEB11748_P_NODE_301779_length_218_cov_19.541401_g299596_i0 | PRJEB11748 | 301779 | 218 | 19.541401 | 42.60025418 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 120 | 1.62e-29 | NR | QJA42332.1 | 2727863 | g299596 | i0 | 87.7 | 1.78899082568807 | 65 | 8 | 89.4 | 0 | 24 | 218 | 890 | 954 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 390 | 120 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 32562452 | 32562452 | PRJEB11748_P_NODE_182199_length_300_cov_1.619247_g180016_i0 | PRJEB11748 | 182199 | 300 | 1.619247 | 4.857741 | Fusarium virguliforme dsRNA mycovirus 1 | 1141583 | Viruses | Viruses | 47.8 | 0.00129 | NR | AEZ54148.1 | 1141583 | g180016 | i0 | 56.8 | 0.44 | 44 | 19 | 44 | 0 | 142 | 11 | 822 | 865 | AEZ54148.1 RNA-dependent RNA polymerase [Fusarium virguliforme dsRNA mycovirus 1] | diamond | 132 | 47.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Fusagraviridae | Fusagravirus | Fusagravirus shi |
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);;