contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA493632" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9386032 | 9386032 | PRJNA493632_P_NODE_108_length_7208_cov_26.432095_g20_i0 | PRJNA493632 | 108 | 7208 | 26.432095 | 1905.2254076 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2477 | 0 | NR | WKU61618.1 | 3063761 | g20 | i0 | 63.4 | 0.92480577136515 | 2222 | 787 | 91.5 | 4 | 6687 | 94 | 1 | 2220 | WKU61618.1 polyprotein [Zebrafish picornavirus 2] | diamond | 6666 | 2477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15771538 | 15771538 | PRJNA493632_P_NODE_727433_length_203_cov_5.992308_g723990_i0 | PRJNA493632 | 727433 | 203 | 5.992308 | 12.16438524 | dengue virus type 4 | 11070 | Viruses | Viruses | 60.8 | 9.16e-9 | NR | WGD01105.1 | 11070 | g723990 | i0 | 60.8 | 0.753694581280788 | 51 | 17 | 75.4 | 1 | 32 | 184 | 2417 | 2464 | WGD01105.1 polyprotein [dengue virus type 4] | diamond | 153 | 60.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 27297805 | 27297805 | PRJNA493632_P_NODE_307223_length_293_cov_1.336364_g303785_i0 | PRJNA493632 | 307223 | 293 | 1.336364 | 3.91554652 | Chrocafynt virus | 3129393 | Viruses | Viruses | 79 | 1.29e-14 | NR | WZH58264.1 | 3129393 | g303785 | i0 | 40.3 | 0.78839590443686 | 77 | 46 | 78.8 | 0 | 38 | 268 | 34 | 110 | WZH58264.1 MAG: RNA-dependent RNA polymerase [Chrocafynt virus] | diamond | 231 | 79 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocafynt virus | |||||
| 27582050 | 27582050 | PRJNA493632_P_NODE_445064_length_263_cov_1.215789_g441625_i0 | PRJNA493632 | 445064 | 263 | 1.215789 | 3.19752507 | brine shrimp narna-like virus 1 | 2900385 | Viruses | Viruses | 57.8 | 2.44e-7 | NR | UNI73858.1 | 2900385 | g441625 | i0 | 45 | 0.684410646387833 | 60 | 33 | 68.4 | 0 | 83 | 262 | 148 | 207 | UNI73858.1 MAG: RNA-dependent RNA polymerase [brine shrimp narna-like virus 1] | diamond | 180 | 57.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | brine shrimp narna-like virus 1 | |||
| 27834509 | 27834509 | PRJNA493632_P_NODE_174824_length_364_cov_1.058419_g171396_i0 | PRJNA493632 | 174824 | 364 | 1.058419 | 3.85264516 | Sanya fiers-like virus 41 | 2970049 | Viruses | Viruses | 71.2 | 1.38e-11 | NR | UUW21380.1 | 2970049 | g171396 | i0 | 41.9 | 0.708791208791209 | 86 | 50 | 70.9 | 0 | 1 | 258 | 176 | 261 | UUW21380.1 MAG: maturation protein [Sanya fiers-like virus 41] | diamond | 258 | 71.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Longmavirus | Longmavirus dinebrenecus | ||
| 27850399 | 27850399 | PRJNA493632_P_NODE_733804_length_197_cov_6.443548_g730361_i0 | PRJNA493632 | 733804 | 197 | 6.443548 | 12.69378956 | Carlavirus | 12163 | Viruses | Viruses | 81.3 | 1.68e-17 | NR | QED43574.1 | 12458 | g730361 | i0 | 64.6 | 6.92893401015228 | 65 | 22 | 99 | 1 | 197 | 3 | 56 | 119 | QED43574.1 NBP [Garlic latent virus] | diamond | 1365 | 82 | 0.991463414634146 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensascalonici | ||
| 27961039 | 27961039 | PRJNA493632_P_NODE_524785_length_250_cov_0.870056_g521346_i0 | PRJNA493632 | 524785 | 250 | 0.870056 | 2.17514 | Leviviridae sp. | 2027243 | Viruses | Viruses | 111 | 4.2900000000000005e-27 | NR | URG16006.1 | 2027243 | g521346 | i0 | 70.4 | 0.972 | 81 | 22 | 97.2 | 1 | 243 | 1 | 146 | 224 | URG16006.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 243 | 111 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28529601 | 28529601 | PRJNA493632_P_NODE_658407_length_241_cov_0.916667_g654966_i0 | PRJNA493632 | 658407 | 241 | 0.916667 | 2.20916747 | Ripastol virus | 3131339 | Viruses | Viruses | 43.5 | 0.0196 | NR | WZH61253.1 | 3131339 | g654966 | i0 | 38.3 | 1.00829875518672 | 81 | 43 | 93.4 | 2 | 240 | 16 | 492 | 571 | WZH61253.1 MAG: RNA-dependent RNA polymerase, partial [Ripastol virus] | diamond | 243 | 43.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripastol virus | |||||
| 28624372 | 28624372 | PRJNA493632_P_NODE_660707_length_241_cov_0.916667_g657266_i0 | PRJNA493632 | 660707 | 241 | 0.916667 | 2.20916747 | Leviviridae sp. | 2027243 | Viruses | Viruses | 164 | 1.28e-45 | NR | DAE35055.1 | 2027243 | g657266 | i0 | 98.8 | 0.995850622406639 | 80 | 1 | 99.6 | 0 | 240 | 1 | 344 | 423 | DAE35055.1 MAG TPA: RDRP protein, partial [Leviviridae sp.] | diamond | 240 | 164 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28845015 | 28845015 | PRJNA493632_P_NODE_691168_length_230_cov_4.592357_g687727_i0 | PRJNA493632 | 691168 | 230 | 4.592357 | 10.5624211 | Puccinia striiformis totivirus 1 | 2045189 | Viruses | Viruses | 141 | 4.979999999999999e-37 | NR | ATO91006.1 | 2045189 | g687727 | i0 | 92.1 | 0.991304347826087 | 76 | 6 | 99.1 | 0 | 230 | 3 | 100 | 175 | ATO91006.1 putative capsid protein [Puccinia striiformis totivirus 1] | diamond | 228 | 141 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Puccinia striiformis totivirus 1 | |||
| 28908002 | 28908002 | PRJNA493632_P_NODE_542588_length_249_cov_0.875000_g539149_i0 | PRJNA493632 | 542588 | 249 | 0.875 | 2.17875 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 85.5 | 3.54e-17 | NR | UOL49050.1 | 2809572 | g539149 | i0 | 67.8 | 0.710843373493976 | 59 | 19 | 71.1 | 0 | 179 | 3 | 1 | 59 | UOL49050.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 177 | 85.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29034716 | 29034716 | PRJNA493632_P_NODE_32888_length_723_cov_2.829231_g29906_i0 | PRJNA493632 | 32888 | 723 | 2.829231 | 20.45534013 | Phytophthora cinnamomi ormycovirus 2-25 | 3239321 | Viruses | Viruses | 50.8 | 0.00301 | NR | XDO01615.1 | 3239321 | g29906 | i0 | 29.1 | 0.556016597510373 | 134 | 90 | 53.9 | 2 | 279 | 668 | 349 | 481 | XDO01615.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 2-25] | diamond | 402 | 50.8 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Deltanormycoviridae | Bormycovirus | Bormycovirus duphytophthorae | |||
| 29192548 | 29192548 | PRJNA493632_P_NODE_520509_length_250_cov_1.305085_g517070_i0 | PRJNA493632 | 520509 | 250 | 1.305085 | 3.2627125 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 50.8 | 4.9e-5 | NR | WRQ64796.1 | 2809868 | g517070 | i0 | 60.5 | 0.456 | 38 | 15 | 45.6 | 0 | 249 | 136 | 189 | 226 | WRQ64796.1 hypothetical protein, partial [Sobelivirales sp.] | diamond | 114 | 50.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 29823630 | 29823630 | PRJNA493632_P_NODE_369071_length_279_cov_1.048544_g365632_i0 | PRJNA493632 | 369071 | 279 | 1.048544 | 2.92543776 | Sanya fiers-like virus 56 | 2970065 | Viruses | Viruses | 98.2 | 6.819999999999999e-24 | NR | UUW21431.1 | 2970065 | g365632 | i0 | 50 | 0.946236559139785 | 88 | 44 | 94.6 | 0 | 2 | 265 | 2 | 89 | UUW21431.1 MAG: hypothetical protein [Sanya fiers-like virus 56] | diamond | 264 | 98.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Longmavirus | Longmavirus cypericola | ||
| 29918850 | 29918850 | PRJNA493632_P_NODE_584851_length_246_cov_0.890173_g581410_i0 | PRJNA493632 | 584851 | 246 | 0.890173 | 2.18982558 | Leviviridae sp. | 2027243 | Viruses | Viruses | 71.2 | 2.87e-12 | NR | URG16293.1 | 2027243 | g581410 | i0 | 47 | 0.804878048780488 | 66 | 34 | 80.5 | 1 | 1 | 198 | 294 | 358 | URG16293.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 198 | 71.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31008724 | 31008724 | PRJNA493632_P_NODE_499514_length_252_cov_1.670391_g496075_i0 | PRJNA493632 | 499514 | 252 | 1.670391 | 4.20938532 | Viruses | 10239 | Viruses | Viruses | 47.8 | 3.17e-4 | NR | WWV86706.1 | 1530251 | g496075 | i0 | 39.3 | 1.28571428571429 | 61 | 32 | 66.7 | 2 | 240 | 73 | 97 | 157 | WWV86706.1 MAG: hypothetical protein, partial [Picornaviridae sp.] | diamond | 324 | 48.1 | 0.993762993762994 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31166389 | 31166389 | PRJNA493632_P_NODE_616675_length_244_cov_0.900585_g613234_i0 | PRJNA493632 | 616675 | 244 | 0.900585 | 2.1974274 | Scarabeuvirus | 2843020 | Viruses | Viruses | 50.1 | 9.7e-5 | NR | YP_009337906.1 | 1922857 | g613234 | i0 | 35.1 | 1.90573770491803 | 77 | 50 | 94.7 | 0 | 14 | 244 | 216 | 292 | YP_009337906.1 hypothetical protein [Hubei chuvirus-like virus 1] | diamond | 465 | 50.4 | 0.994047619047619 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Scarabeuvirus | Scarabeuvirus hubeiense | ||
| 31340616 | 31340616 | PRJNA493632_P_NODE_602336_length_245_cov_0.895349_g598895_i0 | PRJNA493632 | 602336 | 245 | 0.895349 | 2.19360505 | Ripameb virus | 3130844 | Viruses | Viruses | 81.6 | 7.45e-16 | NR | WZH60424.1 | 3130844 | g598895 | i0 | 53.4 | 0.893877551020408 | 73 | 34 | 89.4 | 0 | 236 | 18 | 35 | 107 | WZH60424.1 MAG: RNA-dependent RNA polymerase, partial [Ripameb virus] | diamond | 219 | 81.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Ripameb virus | |||
| 31593726 | 31593726 | PRJNA493632_P_NODE_245416_length_317_cov_1.258197_g241980_i0 | PRJNA493632 | 245416 | 317 | 1.258197 | 3.98848449 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 48.9 | 6.07e-4 | NR | UOL49050.1 | 2809572 | g241980 | i0 | 38.2 | 1.66561514195584 | 89 | 44 | 77.6 | 3 | 18 | 263 | 649 | 733 | UOL49050.1 MAG: putative RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 528 | 48.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 32226477 | 32226477 | PRJNA493632_P_NODE_433758_length_265_cov_1.604167_g430319_i0 | PRJNA493632 | 433758 | 265 | 1.604167 | 4.25104255 | Erysiphe necator associated ourmia-like virus 89 | 2741869 | Viruses | Viruses | 132 | 4.369999999999999e-34 | NR | QKI79919.1 | 2741869 | g430319 | i0 | 74.1 | 0.962264150943396 | 85 | 22 | 96.2 | 0 | 2 | 256 | 148 | 232 | QKI79919.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 89] | diamond | 255 | 132 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 89 | ||
| 32273994 | 32273994 | PRJNA493632_P_NODE_334158_length_286_cov_2.164319_g330719_i0 | PRJNA493632 | 334158 | 286 | 2.164319 | 6.18995234 | Viruses | 10239 | Viruses | Viruses | 58.9 | 1.34e-7 | NR | UCS96409.1 | 1955145 | g330719 | i0 | 37.2 | 3.95454545454545 | 94 | 47 | 98.6 | 2 | 285 | 4 | 1759 | 1840 | UCS96409.1 MAG: polyprotein [Iflaviridae sp.] | diamond | 1131 | 58.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae sp. | |||
| 32384572 | 32384572 | PRJNA493632_P_NODE_598459_length_245_cov_0.895349_g595018_i0 | PRJNA493632 | 598459 | 245 | 0.895349 | 2.19360505 | Sanya fiers-like virus 43 | 2970051 | Viruses | Viruses | 75.9 | 2.09e-15 | NR | UUW21387.1 | 2970051 | g595018 | i0 | 75 | 0.538775510204082 | 44 | 11 | 53.9 | 0 | 244 | 113 | 87 | 130 | UUW21387.1 MAG: hypothetical protein [Sanya fiers-like virus 43] | diamond | 132 | 75.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Sanya fiers-like virus 43 | |||
| 32542986 | 32542986 | PRJNA493632_P_NODE_580899_length_246_cov_0.890173_g577458_i0 | PRJNA493632 | 580899 | 246 | 0.890173 | 2.18982558 | Birnaviridae sp. | 2585335 | Viruses | Viruses | 62.4 | 4.59e-9 | NR | XKB76322.1 | 2585335 | g577458 | i0 | 37 | 0.98780487804878 | 81 | 51 | 98.8 | 0 | 2 | 244 | 178 | 258 | XKB76322.1 MAG: RNA-dependent RNA polymerase [Birnaviridae sp.] | diamond | 243 | 62.4 | 1 | Viruses | Orthornavirae | Birnaviridae | Birnaviridae sp. | ||||||
| 32652763 | 32652763 | PRJNA493632_P_NODE_360_length_3893_cov_7.297644_g158_i0 | PRJNA493632 | 360 | 3893 | 7.297644 | 284.09728092 | Viruses | 10239 | Viruses | Viruses | 409 | 1.8099999999999999e-124 | NR | URG15081.1 | 2027243 | g158 | i0 | 40.8 | 0.920883637297714 | 601 | 327 | 45.5 | 8 | 1789 | 20 | 32 | 614 | URG15081.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 3585 | 409 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 32763260 | 32763260 | PRJNA493632_P_NODE_536820_length_249_cov_0.875000_g533381_i0 | PRJNA493632 | 536820 | 249 | 0.875 | 2.17875 | Hubei toti-like virus 18 | 1923306 | Viruses | Viruses | 94.7 | 2.05e-20 | NR | YP_009336931.1 | 1923306 | g533381 | i0 | 56.3 | 0.963855421686747 | 80 | 35 | 96.4 | 0 | 8 | 247 | 1480 | 1559 | YP_009336931.1 hypothetical protein 1 [Hubei toti-like virus 18] | diamond | 240 | 94.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Lebotiviridae | Lebotivirus | Lebotivirus roku | ||
| 32889056 | 32889056 | PRJNA493632_P_NODE_480340_length_256_cov_1.262295_g476901_i0 | PRJNA493632 | 480340 | 256 | 1.262295 | 3.2314752 | Sanxia Water Strider Virus 3 | 1608062 | Viruses | Viruses | 95.5 | 1.12e-20 | NR | APG77903.1 | 1608062 | g476901 | i0 | 51.8 | 0.99609375 | 85 | 41 | 99.6 | 0 | 2 | 256 | 274 | 358 | APG77903.1 nucleocapsid protein [Sanxia Water Strider Virus 3] | diamond | 255 | 95.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Quaranjavirus | Sanxia Water Strider Virus 3 |
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);;