contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2944062 | 2944062 | PRJNA345071_P_NODE_6583_length_265_cov_2.432292_g6543_i0 | PRJNA345071 | 6583 | 265 | 2.432292 | 6.4455738 | Great lobelia partitivirus | 2933144 | Viruses | Viruses | 127 | 9.389999999999999e-32 | NR | CAI5383835.1 | 2933144 | g6543 | i0 | 74.4 | 0.973584905660377 | 86 | 22 | 97.4 | 0 | 263 | 6 | 287 | 372 | CAI5383835.1 putative coat protein [Great lobelia partitivirus] | diamond | 258 | 127 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Great lobelia partitivirus | |||
| 14422032 | 14422032 | PRJNA345071_P_NODE_1432_length_459_cov_2.880829_g1392_i0 | PRJNA345071 | 1432 | 459 | 2.880829 | 13.22300511 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 225 | 5.61e-65 | NR | XCM68314.1 | 3003959 | g1392 | i0 | 72.5 | 3.73856209150327 | 142 | 39 | 92.8 | 0 | 455 | 30 | 76 | 217 | XCM68314.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 1716 | 225 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 24619421 | 24619421 | PRJNA345071_P_NODE_1020_length_527_cov_4.601322_g980_i0 | PRJNA345071 | 1020 | 527 | 4.601322 | 24.24896694 | Great lobelia partitivirus | 2933144 | Viruses | Viruses | 284 | 4.019999999999999e-89 | NR | CAI5383835.1 | 2933144 | g980 | i0 | 79.7 | 0.979127134724858 | 172 | 35 | 97.9 | 0 | 2 | 517 | 501 | 672 | CAI5383835.1 putative coat protein [Great lobelia partitivirus] | diamond | 516 | 284 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Great lobelia partitivirus | |||
| 26599629 | 26599629 | PRJNA345071_P_NODE_41_length_1563_cov_367.995973_g33_i0 | PRJNA345071 | 41 | 1563 | 367.995973 | 5751.77705799 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 578 | 1.75e-201 | NR | AVM87625.1 | RQ01 | g33 | i0 | 64.4 | 0.90595009596929 | 472 | 163 | 89.6 | 3 | 66 | 1466 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1416 | 578 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 26821763 | 26821763 | PRJNA345071_P_NODE_641_length_631_cov_2.577061_g601_i0 | PRJNA345071 | 641 | 631 | 2.577061 | 16.26125491 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 145 | 2.71e-36 | NR | URG14823.1 | 1530251 | g601 | i0 | 58.9 | 0.508716323296355 | 107 | 44 | 50.9 | 0 | 348 | 28 | 410 | 516 | URG14823.1 MAG: capsid protein [Picornaviridae sp.] | diamond | 321 | 145 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 26821765 | 26821765 | PRJNA345071_P_NODE_921_length_548_cov_3.010526_g881_i0 | PRJNA345071 | 921 | 548 | 3.010526 | 16.49768248 | Hubei picorna-like virus 4 | 1923120 | Viruses | Viruses | 128 | 1.26e-30 | NR | YP_009337256.1 | 1923120 | g881 | i0 | 42.6 | 1.02919708029197 | 188 | 77 | 98 | 5 | 540 | 4 | 779 | 944 | YP_009337256.1 hypothetical protein 1 [Hubei picorna-like virus 4] | diamond | 564 | 128 | 1 | Viruses | Hubei picorna-like virus 4 | ||||||||
| 26885076 | 26885076 | PRJNA345071_P_NODE_21_length_1869_cov_841.831292_g15_i0 | PRJNA345071 | 21 | 1869 | 841.831292 | 15733.82684748 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 713 | 2.5100000000000007e-251 | NR | AVM87624.1 | RQ01 | g15 | i0 | 62.7 | 0.913322632423756 | 569 | 208 | 91.2 | 3 | 1796 | 93 | 3 | 568 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 1707 | 713 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 27169347 | 27169347 | PRJNA345071_P_NODE_1142_length_503_cov_2.595349_g1102_i0 | PRJNA345071 | 1142 | 503 | 2.595349 | 13.05460547 | Great lobelia partitivirus | 2933144 | Viruses | Viruses | 253 | 2.08e-77 | NR | CAI5383835.1 | 2933144 | g1102 | i0 | 82.3 | 0.876739562624254 | 147 | 26 | 87.7 | 0 | 5 | 445 | 526 | 672 | CAI5383835.1 putative coat protein [Great lobelia partitivirus] | diamond | 441 | 253 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Great lobelia partitivirus | |||
| 27296018 | 27296018 | PRJNA345071_P_NODE_1743_length_422_cov_3.220630_g1703_i0 | PRJNA345071 | 1743 | 422 | 3.22063 | 13.5910586 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 197 | 6.3799999999999995e-56 | NR | URG14823.1 | 1530251 | g1703 | i0 | 70.5 | 0.988151658767773 | 139 | 40 | 98.8 | 1 | 2 | 418 | 142 | 279 | URG14823.1 MAG: capsid protein [Picornaviridae sp.] | diamond | 417 | 197 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 27454189 | 27454189 | PRJNA345071_P_NODE_383_length_770_cov_2.111908_g346_i0 | PRJNA345071 | 383 | 770 | 2.111908 | 16.2616916 | Great lobelia partitivirus | 2933144 | Viruses | Viruses | 378 | 2.2299999999999998e-124 | NR | CAI5383835.1 | 2933144 | g346 | i0 | 75 | 0.997402597402597 | 256 | 64 | 99.7 | 0 | 768 | 1 | 240 | 495 | CAI5383835.1 putative coat protein [Great lobelia partitivirus] | diamond | 768 | 378 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Great lobelia partitivirus | |||
| 28559251 | 28559251 | PRJNA345071_P_NODE_947_length_542_cov_1.191898_g907_i0 | PRJNA345071 | 947 | 542 | 1.191898 | 6.46008716 | Qianjiang picorna-like virus 22 | 3239337 | Viruses | Viruses | 233 | 2.08e-67 | NR | XDO02804.1 | 3239337 | g907 | i0 | 60.1 | 0.985239852398524 | 178 | 71 | 98.5 | 0 | 4 | 537 | 255 | 432 | XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] | diamond | 534 | 233 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Qianjiang picorna-like virus 22 | ||||
| 29727031 | 29727031 | PRJNA345071_P_NODE_1690_length_429_cov_3.424157_g1650_i0 | PRJNA345071 | 1690 | 429 | 3.424157 | 14.68963353 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 185 | 2.7e-51 | NR | URG14823.1 | 1530251 | g1650 | i0 | 62.5 | 1.00699300699301 | 144 | 50 | 97.9 | 2 | 8 | 427 | 523 | 666 | URG14823.1 MAG: capsid protein [Picornaviridae sp.] | diamond | 432 | 185 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 30137570 | 30137570 | PRJNA345071_P_NODE_1932_length_405_cov_2.798193_g1892_i0 | PRJNA345071 | 1932 | 405 | 2.798193 | 11.33268165 | Fish-associated picorna-like virus 5 | 3003961 | Viruses | Viruses | 57.8 | 1.23e-6 | NR | WAQ80639.1 | 3003961 | g1892 | i0 | 27.3 | 2.45925925925926 | 139 | 93 | 97.8 | 3 | 8 | 403 | 506 | 643 | WAQ80639.1 MAG: hypothetical protein [Fish-associated picorna-like virus 5] | diamond | 996 | 57.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 5 | ||||
| 30296384 | 30296384 | PRJNA345071_P_NODE_3252_length_336_cov_2.372624_g3212_i0 | PRJNA345071 | 3252 | 336 | 2.372624 | 7.97201664 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 159 | 1.0499999999999999e-42 | NR | XCM68142.1 | 3003959 | g3212 | i0 | 70.3 | 0.991071428571429 | 111 | 33 | 99.1 | 0 | 2 | 334 | 1406 | 1516 | XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 333 | 159 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30328027 | 30328027 | PRJNA345071_P_NODE_5132_length_288_cov_2.009302_g5092_i0 | PRJNA345071 | 5132 | 288 | 2.009302 | 5.78678976 | Hubei picorna-like virus 4 | 1923120 | Viruses | Viruses | 66.6 | 2.6e-10 | NR | YP_009337256.1 | 1923120 | g5092 | i0 | 36.1 | 1.01041666666667 | 97 | 58 | 96.9 | 1 | 287 | 9 | 652 | 748 | YP_009337256.1 hypothetical protein 1 [Hubei picorna-like virus 4] | diamond | 291 | 66.6 | 1 | Viruses | Hubei picorna-like virus 4 | ||||||||
| 30422696 | 30422696 | PRJNA345071_P_NODE_8493_length_250_cov_0.881356_g8453_i0 | PRJNA345071 | 8493 | 250 | 0.881356 | 2.20339 | Hangzhou dicistro-like virus 3 | 3028995 | Viruses | Viruses | 82.8 | 3.36e-16 | NR | WEU70914.1 | 3028995 | g8453 | i0 | 43.9 | 0.984 | 82 | 46 | 98.4 | 0 | 2 | 247 | 1645 | 1726 | WEU70914.1 MAG: putative polyprotein [Hangzhou dicistro-like virus 3] | diamond | 246 | 82.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Hangzhou dicistro-like virus 3 | |||
| 30706572 | 30706572 | PRJNA345071_P_NODE_1094_length_512_cov_3.216401_g1054_i0 | PRJNA345071 | 1094 | 512 | 3.216401 | 16.46797312 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 63.5 | 3.76e-8 | NR | UNY41972.1 | 3003959 | g1054 | i0 | 28.4 | 0.94921875 | 162 | 101 | 92.6 | 5 | 28 | 501 | 3041 | 3191 | UNY41972.1 MAG: polyprotein [Picornavirales sp.] | diamond | 486 | 63.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30738153 | 30738153 | PRJNA345071_P_NODE_5854_length_276_cov_1.536946_g5814_i0 | PRJNA345071 | 5854 | 276 | 1.536946 | 4.24197096 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 134 | 3.85e-34 | NR | UNY41988.1 | 3003959 | g5814 | i0 | 67.4 | 1.95652173913043 | 92 | 30 | 100 | 0 | 1 | 276 | 683 | 774 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 540 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31338640 | 31338640 | PRJNA345071_P_NODE_1716_length_425_cov_1.934659_g1676_i0 | PRJNA345071 | 1716 | 425 | 1.934659 | 8.22230075 | flactilig virus 16 | 2985748 | Viruses | Viruses | 121 | 1.8e-29 | NR | UZT54529.1 | 2985748 | g1676 | i0 | 44.1 | 0.96 | 136 | 72 | 96 | 1 | 408 | 1 | 142 | 273 | UZT54529.1 MAG: ATPase, partial [flactilig virus 16] | diamond | 408 | 121 | 1 | Viruses | flactilig virus 16 | ||||||||
| 31956803 | 31956803 | PRJNA345071_P_NODE_2057_length_396_cov_1.640867_g2017_i0 | PRJNA345071 | 2057 | 396 | 1.640867 | 6.49783332 | Picornavirales | 464095 | Viruses | Viruses | 212 | 1.4800000000000002e-64 | NR | URG14614.1 | 1530251 | g2017 | i0 | 75 | 7 | 132 | 33 | 100 | 0 | 396 | 1 | 76 | 207 | URG14614.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 2772 | 212 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 32129754 | 32129754 | PRJNA345071_P_NODE_8598_length_249_cov_1.693182_g8558_i0 | PRJNA345071 | 8598 | 249 | 1.693182 | 4.21602318 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 89.4 | 1.58e-18 | NR | XCM67742.1 | 3003959 | g8558 | i0 | 51.9 | 1.95180722891566 | 81 | 38 | 96.4 | 1 | 247 | 8 | 340 | 420 | XCM67742.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 486 | 89.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32224573 | 32224573 | PRJNA345071_P_NODE_1878_length_410_cov_1.765579_g1838_i0 | PRJNA345071 | 1878 | 410 | 1.765579 | 7.2388739 | Qianjiang picorna-like virus 22 | 3239337 | Viruses | Viruses | 75.9 | 6.42e-13 | NR | XDO02804.1 | 3239337 | g1838 | i0 | 35.3 | 1.01707317073171 | 139 | 78 | 99.5 | 3 | 3 | 410 | 729 | 858 | XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] | diamond | 417 | 75.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Qianjiang picorna-like virus 22 | ||||
| 32305278 | 32305278 | PRJNA345071_P_NODE_599_length_646_cov_2.417103_g559_i0 | PRJNA345071 | 599 | 646 | 2.417103 | 15.61448538 | Viruses | 10239 | Viruses | Viruses | 222 | 7.07e-63 | NR | URG14822.1 | 1530251 | g559 | i0 | 49.5 | 2.97678018575851 | 214 | 107 | 98.9 | 1 | 640 | 2 | 967 | 1180 | URG14822.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] | diamond | 1923 | 222 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 32729994 | 32729994 | PRJNA345071_P_NODE_4680_length_296_cov_1.228700_g4640_i0 | PRJNA345071 | 4680 | 296 | 1.2287 | 3.636952 | Homavirus sp. | 2487769 | Viruses | Viruses | 76.6 | 4.55e-14 | NR | AYV82246.1 | 2487769 | g4640 | i0 | 45.6 | 0.800675675675676 | 79 | 42 | 79.1 | 1 | 1 | 234 | 239 | 317 | AYV82246.1 MAG: hypothetical protein Homavirus20_4 [Homavirus sp.] | diamond | 237 | 76.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. | |||
| 32792640 | 32792640 | PRJNA345071_P_NODE_5200_length_287_cov_1.457944_g5160_i0 | PRJNA345071 | 5200 | 287 | 1.457944 | 4.18429928 | Qianjiang picorna-like virus 22 | 3239337 | Viruses | Viruses | 110 | 1.38e-25 | NR | XDO02803.1 | 3239337 | g5160 | i0 | 61 | 0.804878048780488 | 77 | 30 | 80.5 | 0 | 286 | 56 | 1909 | 1985 | XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] | diamond | 231 | 110 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Qianjiang picorna-like virus 22 | ||||
| 32887186 | 32887186 | PRJNA345071_P_NODE_11000_length_238_cov_2.278788_g10960_i0 | PRJNA345071 | 11000 | 238 | 2.278788 | 5.42351544 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 157 | 6.489999999999999e-43 | NR | URG14866.1 | 1530251 | g10960 | i0 | 92.4 | 0.995798319327731 | 79 | 6 | 99.6 | 0 | 237 | 1 | 50 | 128 | URG14866.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 237 | 157 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. |
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);;