contig_metadata
26 rows where bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 792997 | 792997 | PRJNA799842_P_NODE_11781_length_913_cov_4.797619_g10551_i0 | PRJNA799842 | 11781 | 913 | 4.797619 | 43.80226147 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1565 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g10551 | i0 | 97.593 | 2.93209200438116 | 914 | 20 | 100 | 2 | 1 | 913 | 18 | 930 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2677 | 1565 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 793504 | 793504 | PRJNA799842_P_NODE_143381_length_250_cov_0.870056_g141808_i0 | PRJNA799842 | 143381 | 250 | 0.870056 | 2.17514 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 388 | 1.5199999999999998e-103 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g141808 | i0 | 94.8 | 2.776 | 250 | 12 | 100 | 1 | 1 | 250 | 287 | 39 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 694 | 388 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 4622341 | 4622341 | PRJNA799842_P_NODE_168504_length_245_cov_0.895349_g166931_i0 | PRJNA799842 | 168504 | 245 | 0.895349 | 2.19360505 | Potyvirus glycitessellati | 3240532 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2621721683|dbj|LC786829.1| | 12222 | g166931 | i0 | 99.592 | 100 | 245 | 1 | 100 | 0 | 1 | 245 | 5367 | 5123 | Soybean mosaic virus CC20s gene for polyprotein, complete cds | blastn | 24500 | 448 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus glycitessellati | ||
| 5898876 | 5898876 | PRJNA799842_P_NODE_62665_length_360_cov_1.052265_g61092_i0 | PRJNA799842 | 62665 | 360 | 1.052265 | 3.788154 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 562 | 1.27e-155 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g61092 | i0 | 94.972 | 2.96944444444444 | 358 | 18 | 99 | 0 | 1 | 358 | 2264 | 2621 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1069 | 562 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9721214 | 9721214 | PRJNA799842_P_NODE_121908_length_265_cov_1.203125_g120335_i0 | PRJNA799842 | 121908 | 265 | 1.203125 | 3.18828125 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 451 | 2.04e-122 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g120335 | i0 | 97.358 | 3 | 265 | 7 | 100 | 0 | 1 | 265 | 1417 | 1681 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 795 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12272182 | 12272182 | PRJNA799842_P_NODE_108870_length_280_cov_1.487923_g107297_i0 | PRJNA799842 | 108870 | 280 | 1.487923 | 4.1661844 | Guiyang Paspalum paspaloides solemo-like virus 1 | 2970294 | Viruses | Viruses | 473 | 4.649999999999999e-129 | NTclustered | gi|2320142004|gb|OM514387.1| | 2970294 | g107297 | i0 | 97.143 | 63.025 | 280 | 8 | 100 | 0 | 1 | 280 | 2336 | 2615 | MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence | blastn | 17647 | 473 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Guiyang Paspalum paspaloides solemo-like virus 1 | |||
| 13547912 | 13547912 | PRJNA799842_P_NODE_188031_length_241_cov_0.916667_g186458_i0 | PRJNA799842 | 188031 | 241 | 0.916667 | 2.20916747 | Guiyang Paspalum paspaloides solemo-like virus 1 | 2970294 | Viruses | Viruses | 350 | 6.87e-92 | NTclustered | gi|2320142004|gb|OM514387.1| | 2970294 | g186458 | i0 | 92.917 | 0.995850622406639 | 240 | 17 | 99 | 0 | 2 | 241 | 1031 | 1270 | MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence | blastn | 240 | 350 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Guiyang Paspalum paspaloides solemo-like virus 1 | |||
| 14821192 | 14821192 | PRJNA799842_P_NODE_108092_length_281_cov_1.466346_g106519_i0 | PRJNA799842 | 108092 | 281 | 1.466346 | 4.12043226 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 409 | 1.33e-109 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g106519 | i0 | 92.883 | 3 | 281 | 20 | 100 | 0 | 1 | 281 | 2716 | 2996 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 843 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 17371819 | 17371819 | PRJNA799842_P_NODE_138074_length_251_cov_0.865169_g136501_i0 | PRJNA799842 | 138074 | 251 | 0.865169 | 2.17157419 | Potyvirus orionspassiflorae | 3240573 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|1335762644|gb|KY614052.1| | 341167 | g136501 | i0 | 99.602 | 11.8366533864542 | 251 | 1 | 100 | 0 | 1 | 251 | 5882 | 5632 | East Asian Passiflora virus isolate pt, complete genome | blastn | 2971 | 459 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus orionspassiflorae | ||
| 17372184 | 17372184 | PRJNA799842_P_NODE_159094_length_247_cov_0.885057_g157521_i0 | PRJNA799842 | 159094 | 247 | 0.885057 | 2.18609079 | Guiyang Paspalum paspaloides solemo-like virus 1 | 2970294 | Viruses | Viruses | 296 | 9.34e-76 | NTclustered | gi|2320142004|gb|OM514387.1| | 2970294 | g157521 | i0 | 94.764 | 0.773279352226721 | 191 | 8 | 77 | 2 | 55 | 244 | 1619 | 1808 | MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence | blastn | 191 | 296 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Guiyang Paspalum paspaloides solemo-like virus 1 | |||
| 18646249 | 18646249 | PRJNA799842_P_NODE_37855_length_465_cov_1.964286_g36284_i0 | PRJNA799842 | 37855 | 465 | 1.964286 | 9.1339299 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 798 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g36284 | i0 | 97.634 | 2.99784946236559 | 465 | 11 | 100 | 0 | 1 | 465 | 4057 | 4521 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1394 | 798 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21197247 | 21197247 | PRJNA799842_P_NODE_40897_length_446_cov_1.959786_g39326_i0 | PRJNA799842 | 40897 | 446 | 1.959786 | 8.74064556 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 671 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g39326 | i0 | 94.292 | 2.95964125560538 | 438 | 25 | 98 | 0 | 9 | 446 | 5476 | 5039 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1320 | 671 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21197645 | 21197645 | PRJNA799842_P_NODE_57_length_6175_cov_7.528024_g18_i1 | PRJNA799842 | 57 | 6175 | 7.528024 | 464.855482 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 10087 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g18 | i1 | 96.148 | 3.00210526315789 | 6179 | 233 | 100 | 5 | 1 | 6175 | 969 | 7146 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 18538 | 10087 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23748402 | 23748402 | PRJNA799842_P_NODE_8079_length_1100_cov_9.037001_g18_i2 | PRJNA799842 | 8079 | 1100 | 9.037001 | 99.407011 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1820 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g18 | i2 | 96.545 | 3.47181818181818 | 1100 | 37 | 100 | 1 | 1 | 1100 | 8185 | 7087 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 3819 | 1820 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 25021440 | 25021440 | PRJNA799842_P_NODE_40_length_7285_cov_8.778841_g18_i0 | PRJNA799842 | 40 | 7285 | 8.778841 | 639.53856685 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 11860 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g18 | i0 | 96.048 | 3.07288949897049 | 7288 | 284 | 100 | 4 | 1 | 7285 | 969 | 8255 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 22386 | 11860 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 27316081 | 27316081 | PRJNA799842_P_NODE_59323_length_369_cov_1.543919_g57750_i0 | PRJNA799842 | 59323 | 369 | 1.543919 | 5.69706111 | Deltapartitivirus | 1511810 | Viruses | Viruses | 130 | 6.8399999999999985e-34 | NR | QRG29188.1 | 2562459 | g57750 | i0 | 51.3 | 1.90243902439024 | 117 | 57 | 95.1 | 0 | 368 | 18 | 179 | 295 | QRG29188.1 putative CP [Camellia oleifera cryptic virus 1] | diamond | 702 | 130 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Deltapartitivirus | Camellia oleifera cryptic virus 1 | ||
| 27505592 | 27505592 | PRJNA799842_P_NODE_94303_length_299_cov_1.022124_g92730_i0 | PRJNA799842 | 94303 | 299 | 1.022124 | 3.05615076 | root | 1 | Root_unresolved | Root_unresolved | 118 | 1.54e-29 | NR | UHA47118.1 | 351495 | g92730 | i0 | 58.6 | 3.93311036789298 | 99 | 40 | 99.3 | 1 | 299 | 3 | 217 | 314 | UHA47118.1 hypothetical protein [Raphanus sativus cryptic virus 2] | diamond | 1176 | 119 | 0.991596638655462 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Raphanus sativus cryptic virus 2 | |||
| 28033350 | 28033350 | PRJNA799842_P_NODE_63805_length_357_cov_0.950704_g62232_i0 | PRJNA799842 | 63805 | 357 | 0.950704 | 3.39401328 | Raphanus sativus cryptic virus 2 | 351495 | Viruses | Viruses | 119 | 1.64e-29 | NR | YP_001686784.1 | 351495 | g62232 | i0 | 51.7 | 0.974789915966387 | 116 | 56 | 97.5 | 0 | 6 | 353 | 99 | 214 | YP_001686784.1 unknown [Raphanus sativus cryptic virus 2] | diamond | 348 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Raphanus sativus cryptic virus 2 | |||
| 28105166 | 28105166 | PRJNA799842_P_NODE_26065_length_576_cov_1.530815_g24513_i0 | PRJNA799842 | 26065 | 576 | 1.530815 | 8.8174944 | Picornavirales | 464095 | Viruses | Viruses | 158 | 5.439999999999999e-42 | NR | URG14575.1 | 1530251 | g24513 | i0 | 43.2 | 7.91666666666667 | 185 | 104 | 95.8 | 1 | 2 | 553 | 53 | 237 | URG14575.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 4560 | 158 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 28285505 | 28285505 | PRJNA799842_P_NODE_114326_length_274_cov_1.149254_g112753_i0 | PRJNA799842 | 114326 | 274 | 1.149254 | 3.14895596 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 52.8 | 1.69e-5 | NR | XCM68122.1 | 3003959 | g112753 | i0 | 46.3 | 0.733576642335766 | 67 | 32 | 69 | 2 | 61 | 249 | 948 | 1014 | XCM68122.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 201 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28285577 | 28285577 | PRJNA799842_P_NODE_866_length_2459_cov_3.443839_g663_i0 | PRJNA799842 | 866 | 2459 | 3.443839 | 84.68400101 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 310 | 3.77e-89 | NR | XCM67884.1 | 3003959 | g663 | i0 | 32.7 | 3.11468076453843 | 623 | 390 | 73.4 | 12 | 1894 | 89 | 9 | 623 | XCM67884.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 7659 | 310 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28443796 | 28443796 | PRJNA799842_P_NODE_162866_length_246_cov_0.890173_g161293_i0 | PRJNA799842 | 162866 | 246 | 0.890173 | 2.18982558 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 124 | 7.53e-31 | NR | QDH89622.1 | 3003959 | g161293 | i0 | 78.8 | 0.975609756097561 | 80 | 17 | 97.6 | 0 | 245 | 6 | 677 | 756 | QDH89622.1 MAG: hypothetical protein H1RhizoLitter1238_000002 [Picornavirales sp.] | diamond | 240 | 124 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28475253 | 28475253 | PRJNA799842_P_NODE_42566_length_436_cov_2.168044_g40994_i0 | PRJNA799842 | 42566 | 436 | 2.168044 | 9.45267184 | Marnaviridae sp. | 2715102 | Viruses | Viruses | 62.4 | 4.1e-8 | NR | ULF99925.1 | 2715102 | g40994 | i0 | 33 | 0.729357798165138 | 106 | 70 | 72.9 | 1 | 323 | 6 | 753 | 857 | ULF99925.1 MAG: hypothetical protein 2 [Marnaviridae sp.] | diamond | 318 | 62.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Marnaviridae sp. | |||
| 31286209 | 31286209 | PRJNA799842_P_NODE_68015_length_346_cov_1.410256_g66442_i0 | PRJNA799842 | 68015 | 346 | 1.410256 | 4.87948576 | Raphanus sativus cryptic virus 2 | 351495 | Viruses | Viruses | 56.6 | 1.43e-6 | NR | UHA47119.1 | 351495 | g66442 | i0 | 34.5 | 1.73410404624277 | 113 | 74 | 98 | 0 | 6 | 344 | 1 | 113 | UHA47119.1 hypothetical protein [Raphanus sativus cryptic virus 2] | diamond | 600 | 56.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Raphanus sativus cryptic virus 2 | |||
| 31412852 | 31412852 | PRJNA799842_P_NODE_114576_length_274_cov_0.970149_g113003_i0 | PRJNA799842 | 114576 | 274 | 0.970149 | 2.65820826 | Raphanus sativus cryptic virus 2 | 351495 | Viruses | Viruses | 64.3 | 1.15e-9 | NR | YP_001686784.1 | 351495 | g113003 | i0 | 42.2 | 1.97080291970803 | 90 | 43 | 98.5 | 1 | 272 | 3 | 20 | 100 | YP_001686784.1 unknown [Raphanus sativus cryptic virus 2] | diamond | 540 | 64.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Raphanus sativus cryptic virus 2 | |||
| 32623675 | 32623675 | PRJNA799842_P_NODE_30460_length_526_cov_2.777042_g28898_i0 | PRJNA799842 | 30460 | 526 | 2.777042 | 14.60724092 | Viruses | 10239 | Viruses | Viruses | 139 | 1.2e-34 | NR | URG14944.1 | 1530251 | g28898 | i0 | 39.9 | 4.57984790874525 | 163 | 96 | 93 | 1 | 9 | 497 | 450 | 610 | URG14944.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] | diamond | 2409 | 139 | 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);;