contig_metadata
21 rows where bioproject = "PRJNA781196" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2035347 | 2035347 | PRJNA781196_P_NODE_40582_length_281_cov_1.500000_g40205_i0 | PRJNA781196 | 40582 | 281 | 1.5 | 4.215 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 479 | 9.999999999999999e-131 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g40205 | i0 | 97.509 | 2.7900355871886098 | 281 | 5 | 99 | 2 | 2 | 281 | 303 | 24 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 784 | 479 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 3310667 | 3310667 | PRJNA781196_P_NODE_47483_length_259_cov_2.096774_g47106_i0 | PRJNA781196 | 47483 | 259 | 2.096774 | 5.43064466 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 429 | 9.329999999999999e-116 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g47106 | i0 | 96.525 | 3 | 259 | 9 | 100 | 0 | 1 | 259 | 1841 | 2099 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 777 | 429 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 4587239 | 4587239 | PRJNA781196_P_NODE_16604_length_408_cov_0.898507_g16227_i0 | PRJNA781196 | 16604 | 408 | 0.898507 | 3.66590856 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 693 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g16227 | i0 | 97.304 | 3 | 408 | 11 | 100 | 0 | 1 | 408 | 4499 | 4906 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1224 | 693 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 4587531 | 4587531 | PRJNA781196_P_NODE_36784_length_293_cov_1.418182_g36407_i0 | PRJNA781196 | 36784 | 293 | 1.418182 | 4.15527326 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 514 | 2.88e-141 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g36407 | i0 | 98.294 | 2.99317406143345 | 293 | 5 | 100 | 0 | 1 | 293 | 7858 | 7566 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 877 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12238577 | 12238577 | PRJNA781196_P_NODE_12590_length_459_cov_1.272021_g12214_i0 | PRJNA781196 | 12590 | 459 | 1.272021 | 5.83857639 | Suillus luteus hypovirus 1 | 3067807 | Viruses | Viruses | 671 | 0 | NTclustered | gi|2560562976|gb|OQ862556.1| | 3067807 | g12214 | i0 | 93.028 | 1 | 459 | 32 | 100 | 0 | 1 | 459 | 7114 | 6656 | Suillus luteus hypovirus 1 isolate SlHV1 polyprotein gene, partial cds | blastn | 459 | 671 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Suillus luteus hypovirus 1 | |||
| 12238753 | 12238753 | PRJNA781196_P_NODE_24970_length_345_cov_1.312500_g24593_i0 | PRJNA781196 | 24970 | 345 | 1.3125 | 4.528125 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 568 | 2.6199999999999992e-157 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g24593 | i0 | 96.501 | 2.99420289855072 | 343 | 12 | 99 | 0 | 1 | 343 | 2535 | 2877 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1033 | 568 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 13513132 | 13513132 | PRJNA781196_P_NODE_38911_length_286_cov_1.830986_g38534_i0 | PRJNA781196 | 38911 | 286 | 1.830986 | 5.23661996 | Hulunbuir tick virus 1 | 2972183 | Viruses | Viruses | 172 | 2.66e-47 | NR | UYL95332.1 | 2972183 | g38534 | i0 | 83.2 | 0.996503496503496 | 95 | 16 | 99.7 | 0 | 286 | 2 | 3098 | 3192 | UYL95332.1 MAG: polyprotein [Hulunbuir tick virus 1] | diamond | 285 | 172 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hulunbuir tick virus 1 | |||
| 17337242 | 17337242 | PRJNA781196_P_NODE_18374_length_391_cov_0.981132_g17997_i0 | PRJNA781196 | 18374 | 391 | 0.981132 | 3.83622612 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 601 | 2.9599999999999992e-167 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g17997 | i0 | 94.373 | 3 | 391 | 22 | 100 | 0 | 1 | 391 | 1942 | 1552 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1173 | 601 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 18610508 | 18610508 | PRJNA781196_P_NODE_115_length_2754_cov_2.461768_g85_i0 | PRJNA781196 | 115 | 2754 | 2.461768 | 67.79709072 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 4532 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g85 | i0 | 96.37 | 3.00254175744372 | 2755 | 98 | 100 | 2 | 1 | 2754 | 7937 | 5184 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 8269 | 4532 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24985887 | 24985887 | PRJNA781196_P_NODE_44440_length_268_cov_2.800000_g44063_i0 | PRJNA781196 | 44440 | 268 | 2.8 | 7.504 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 435 | 2.09e-117 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g44063 | i0 | 96.565 | 2.95522388059702 | 262 | 9 | 98 | 0 | 7 | 268 | 5190 | 4929 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 792 | 435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 26610066 | 26610066 | PRJNA781196_P_NODE_10321_length_499_cov_1.730047_g9945_i0 | PRJNA781196 | 10321 | 499 | 1.730047 | 8.63293453 | Exserohilum turcicum hypovirus 1 | 3229025 | Viruses | Viruses | 217 | 5.9499999999999995e-62 | NR | XBY85566.1 | 3229025 | g9945 | i0 | 62 | 1.95991983967936 | 163 | 61 | 98 | 1 | 3 | 491 | 2615 | 2776 | XBY85566.1 MAG: polyprotein [Exserohilum turcicum hypovirus 1] | diamond | 978 | 217 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Exserohilum turcicum hypovirus 1 | ||
| 28569358 | 28569358 | PRJNA781196_P_NODE_57407_length_248_cov_0.891429_g57030_i0 | PRJNA781196 | 57407 | 248 | 0.891429 | 2.21074392 | Poaceae Liege nepovirus A | 2822470 | Viruses | Viruses | 121 | 9.71e-30 | NR | YP_010840366.1 | 2822470 | g57030 | i0 | 68.4 | 0.919354838709677 | 76 | 24 | 91.9 | 0 | 242 | 15 | 1177 | 1252 | YP_010840366.1 polyprotein [Poaceae Liege nepovirus A] | diamond | 228 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus poaceae | ||
| 28948523 | 28948523 | PRJNA781196_P_NODE_14128_length_436_cov_3.181818_g13751_i0 | PRJNA781196 | 14128 | 436 | 3.181818 | 13.87272648 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 77.4 | 1.84e-13 | NR | WRQ64935.1 | 2809868 | g13751 | i0 | 40 | 0.825688073394495 | 120 | 65 | 79.8 | 5 | 2 | 349 | 259 | 375 | WRQ64935.1 structural protein, partial [Sobelivirales sp.] | diamond | 360 | 77.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 29232620 | 29232620 | PRJNA781196_P_NODE_62209_length_245_cov_0.906977_g61832_i0 | PRJNA781196 | 62209 | 245 | 0.906977 | 2.22209365 | Poaceae Liege nepovirus A | 2822470 | Viruses | Viruses | 122 | 3.66e-30 | NR | YP_010840366.1 | 2822470 | g61832 | i0 | 74.7 | 1.01632653061224 | 83 | 19 | 99.2 | 2 | 2 | 244 | 1049 | 1131 | YP_010840366.1 polyprotein [Poaceae Liege nepovirus A] | diamond | 249 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus poaceae | ||
| 29516506 | 29516506 | PRJNA781196_P_NODE_59710_length_247_cov_0.896552_g59333_i0 | PRJNA781196 | 59710 | 247 | 0.896552 | 2.21448344 | Durnavirales sp. | 2809355 | Viruses | Viruses | 53.9 | 4.28e-6 | NR | WRQ64726.1 | 2809355 | g59333 | i0 | 36.3 | 1.94331983805668 | 80 | 50 | 96 | 1 | 242 | 6 | 98 | 177 | WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] | diamond | 480 | 53.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Durnavirales sp. | ||||
| 29705633 | 29705633 | PRJNA781196_P_NODE_33650_length_305_cov_1.008621_g33273_i0 | PRJNA781196 | 33650 | 305 | 1.008621 | 3.07629405 | Hulunbuir tick virus 1 | 2972183 | Viruses | Viruses | 179 | 9.4e-50 | NR | UYL95332.1 | 2972183 | g33273 | i0 | 75.2 | 0.99344262295082 | 101 | 25 | 99.3 | 0 | 2 | 304 | 3386 | 3486 | UYL95332.1 MAG: polyprotein [Hulunbuir tick virus 1] | diamond | 303 | 179 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hulunbuir tick virus 1 | |||
| 30148071 | 30148071 | PRJNA781196_P_NODE_31572_length_313_cov_1.300000_g31195_i0 | PRJNA781196 | 31572 | 313 | 1.3 | 4.069 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 129 | 3.05e-33 | NR | WRQ64934.1 | 2809868 | g31195 | i0 | 63.1 | 0.987220447284345 | 103 | 37 | 98.7 | 1 | 312 | 4 | 147 | 248 | WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] | diamond | 309 | 129 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 30338343 | 30338343 | PRJNA781196_P_NODE_51592_length_252_cov_0.871508_g51215_i0 | PRJNA781196 | 51592 | 252 | 0.871508 | 2.19620016 | Beet ringspot virus | 191547 | Viruses | Viruses | 134 | 1.69e-34 | NR | NP_734032.2 | 191547 | g51215 | i0 | 75.6 | 1.95238095238095 | 82 | 20 | 97.6 | 0 | 2 | 247 | 451 | 532 | NP_734032.2 NTP-binding domain [Beet ringspot virus] | diamond | 492 | 134 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus betae | ||
| 30969909 | 30969909 | PRJNA781196_P_NODE_19934_length_378_cov_1.534426_g19557_i0 | PRJNA781196 | 19934 | 378 | 1.534426 | 5.80013028 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 145 | 3.79e-39 | NR | WRQ64935.1 | 2809868 | g19557 | i0 | 61.7 | 0.952380952380952 | 120 | 44 | 94.4 | 2 | 17 | 373 | 114 | 232 | WRQ64935.1 structural protein, partial [Sobelivirales sp.] | diamond | 360 | 145 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 31886756 | 31886756 | PRJNA781196_P_NODE_817_length_1459_cov_3.401876_g689_i0 | PRJNA781196 | 817 | 1459 | 3.401876 | 49.63337084 | Hebei hypo-like virus 3 | 3401102 | Viruses | Viruses | 437 | 1.2699999999999999e-133 | NR | XHY85258.1 | 3401102 | g689 | i0 | 64.2 | 1.99657299520219 | 327 | 112 | 66.2 | 2 | 1459 | 494 | 1722 | 2048 | XHY85258.1 MAG: polyprotein, partial [Hebei hypo-like virus 3] | diamond | 2913 | 437 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hebei hypo-like virus 3 | |||
| 32361662 | 32361662 | PRJNA781196_P_NODE_39979_length_283_cov_1.414286_g39602_i0 | PRJNA781196 | 39979 | 283 | 1.414286 | 4.00242938 | Tomato black ring virus | 12275 | Viruses | Viruses | 150 | 1.18e-39 | NR | NP_958814.1 | 12275 | g39602 | i0 | 79.6 | 1.96113074204947 | 93 | 19 | 98.6 | 0 | 281 | 3 | 1123 | 1215 | NP_958814.1 polyprotein [Tomato black ring virus] | diamond | 555 | 150 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus nigranuli |
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);;