RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA1214993", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 22 ✖

tax_phylum 1

  • Pisuviricota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1214993 · 22 ✖

tax_clade 0

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
1605106 1605106 PRJNA1214993_P_NODE_3062_length_603_cov_3.081132_g2883_i0 PRJNA1214993 3062 603 3.081132 18.57922596 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 409 3.08e-109   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2883 i0 89.937 0.782752902155887 318 31 78 1 1 318 1087 771 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 472 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
2881347 2881347 PRJNA1214993_P_NODE_9543_length_354_cov_0.971530_g9357_i0 PRJNA1214993 9543 354 0.97153 3.4392162 Zebrafish picornavirus 1 2304617 Viruses Viruses 588 2.0599999999999994e-163   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g9357 i0 96.884 2.99717514124294 353 8 99 3 5 354 3032 3384 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1061 588 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
6708215 6708215 PRJNA1214993_P_NODE_7746_length_388_cov_2.495238_g7560_i0 PRJNA1214993 7746 388 2.495238 9.68152344 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 634 2.8899999999999995e-177   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7560 i0 96.134 1 388 15 100 0 1 388 90 477 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 388 634 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
7983720 7983720 PRJNA1214993_P_NODE_1827_length_772_cov_1.961373_g1662_i0 PRJNA1214993 1827 772 1.961373 15.14179956 Zebrafish picornavirus 1 2304617 Viruses Viruses 1299 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1662 i0 97.021 3 772 23 100 0 1 772 3824 4595 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2316 1299 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13083995 13083995 PRJNA1214993_P_NODE_19571_length_253_cov_1.344444_g19385_i0 PRJNA1214993 19571 253 1.344444 3.40144332 Zebrafish picornavirus 1 2304617 Viruses Viruses 388 1.5399999999999998e-103   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g19385 i0 94.444 2.98814229249012 252 14 99 0 1 252 1909 2160 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 756 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13084049 13084049 PRJNA1214993_P_NODE_26771_length_225_cov_5.592105_g26585_i0 PRJNA1214993 26771 225 5.592105 12.58223625 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 178 3.16e-40   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g26585 i0 97.143 0.466666666666667 105 3 47 0 121 225 1 105 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 105 178 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
14359265 14359265 PRJNA1214993_P_NODE_12_length_4932_cov_16.048570_g6_i0 PRJNA1214993 12 4932 16.04857 791.5154724 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2342 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6 i0 91.529 0.684712084347121 1700 140 68 4 3235 4932 5329 7026 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 3377 2342 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15633274 15633274 PRJNA1214993_P_NODE_5593_length_453_cov_1.589474_g5408_i0 PRJNA1214993 5593 453 1.589474 7.20031722 Zebrafish picornavirus 1 2304617 Viruses Viruses 793 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g5408 i0 98.234 3 453 8 100 0 1 453 3866 3414 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1359 793 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23282455 23282455 PRJNA1214993_P_NODE_1819_length_774_cov_2.400856_g1654_i0 PRJNA1214993 1819 774 2.400856 18.58262544 Zebrafish picornavirus 1 2304617 Viruses Viruses 1236 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1654 i0 95.478 3 774 35 100 0 1 774 4853 5626 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2322 1236 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23282594 23282594 PRJNA1214993_P_NODE_99_length_2294_cov_3.776677_g66_i0 PRJNA1214993 99 2294 3.776677 86.63697038 Zebrafish picornavirus 1 2304617 Viruses Viruses 3904 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g66 i0 97.384 3 2294 60 100 0 1 2294 5568 7861 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 6882 3904 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24556400 24556400 PRJNA1214993_P_NODE_1420_length_863_cov_5.131646_g1268_i0 PRJNA1214993 1420 863 5.131646 44.28610498 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 388 5.84e-103   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1268 i0 92.884 0.309385863267671 267 19 31 0 336 602 1708 1442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 267 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
24556545 24556545 PRJNA1214993_P_NODE_7320_length_399_cov_1.343558_g7134_i0 PRJNA1214993 7320 399 1.343558 5.36079642 Zebrafish picornavirus 1 2304617 Viruses Viruses 616 1.0799999999999999e-171   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7134 i0 94.486 3 399 22 100 0 1 399 1249 1647 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1197 616 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
26724002 26724002 PRJNA1214993_P_NODE_11361_length_327_cov_0.921260_g11175_i0 PRJNA1214993 11361 327 0.92126 3.0125202 Aspo dicistro-like virus 2994985 Viruses Viruses 62.4 1.21e-8   NR UZO29912.1 2994985 g11175 i0 58.7 0.422018348623853 46 19 42.2 0 318 181 298 343 UZO29912.1 MAG: RNA-dependent RNA polymerase, partial [Aspo dicistro-like virus] diamond 138 62.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Aspo dicistro-like virus
29756641 29756641 PRJNA1214993_P_NODE_1171_length_932_cov_4.679860_g1033_i0 PRJNA1214993 1171 932 4.67986 43.6162952 Durnavirales sp. 2809355 Viruses Viruses 212 3.08e-61   NR WRQ64726.1 2809355 g1033 i0 37.2 0.978540772532189 304 188 97.2 3 14 919 179 481 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 912 212 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
30483467 30483467 PRJNA1214993_P_NODE_3513_length_565_cov_2.371951_g3331_i0 PRJNA1214993 3513 565 2.371951 13.40152315 Gammapartitivirus sp. 2809420 Viruses Viruses 95.9 2.99e-19   NR UDL14336.1 2809420 g3331 i0 36.5 0.886725663716814 167 100 85.5 2 490 8 102 268 UDL14336.1 MAG: RNA-dependent RNA polymerase [Gammapartitivirus sp.] diamond 501 95.9 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Gammapartitivirus Gammapartitivirus sp.
30736085 30736085 PRJNA1214993_P_NODE_1374_length_877_cov_4.638060_g1225_i0 PRJNA1214993 1374 877 4.63806 40.6757862 Pseudogymnoascus destructans partitivirus-pa 1685502 Viruses Viruses 181 5.7e-49   NR YP_009259752.1 1685502 g1225 i0 43.2 3.8072976054732 229 115 78 4 89 772 277 491 YP_009259752.1 RNA-dependent RNA polymerase [Pseudogymnoascus destructans partitivirus-pa] diamond 3339 181 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Pseudogymnoascus destructans partitivirus-pa
30894300 30894300 PRJNA1214993_P_NODE_19614_length_253_cov_0.866667_g19428_i0 PRJNA1214993 19614 253 0.866667 2.19266751 Qianjiang marna-like virus 1 3347518 Viruses Viruses 55.8 1.04e-6   NR XHA88237.1 3347528 g19428 i0 34.9 0.984189723320158 83 50 98.4 1 250 2 403 481 XHA88237.1 MAG: putative viral coat protein [Qianjiang marna-like virus 108] diamond 249 55.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 108
31558254 31558254 PRJNA1214993_P_NODE_26696_length_228_cov_2.464516_g26510_i0 PRJNA1214993 26696 228 2.464516 5.61909648 Picornaviridae sp. 1530251 Viruses Viruses 75.5 8.79e-14   NR URG14752.1 1530251 g26510 i0 47.3 0.973684210526316 74 38 97.4 1 5 226 554 626 URG14752.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 222 75.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31842514 31842514 PRJNA1214993_P_NODE_17437_length_268_cov_1.600000_g17251_i0 PRJNA1214993 17437 268 1.6 4.288 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 43.5 0.0277   NR ASG92535.1 3003959 g17251 i0 32.4 0.828358208955224 74 49 82.8 1 34 255 285 357 ASG92535.1 putative structural protein [Picornavirales N_OV_003] diamond 222 43.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31937460 31937460 PRJNA1214993_P_NODE_2877_length_621_cov_4.065693_g2698_i0 PRJNA1214993 2877 621 4.065693 25.24795353 Durnavirales sp. 2809355 Viruses Viruses 95.5 5.8e-19   NR WRQ64726.1 2809355 g2698 i0 33 0.85024154589372 176 115 83.6 3 521 3 11 186 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 528 95.5 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
32190852 32190852 PRJNA1214993_P_NODE_7998_length_383_cov_1.258065_g7812_i0 PRJNA1214993 7998 383 1.258065 4.81838895 Picornaviridae sp. 1530251 Viruses Viruses 90.5 3.46e-18   NR URG14752.1 1530251 g7812 i0 43.3 0.759791122715405 97 55 76 0 378 88 112 208 URG14752.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 291 90.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32380670 32380670 PRJNA1214993_P_NODE_10659_length_336_cov_1.779468_g10473_i0 PRJNA1214993 10659 336 1.779468 5.97901248 Ohio dicistro-like virus 2789442 Viruses Viruses 63.5 5.75e-9   NR QPN36938.1 2789442 g10473 i0 39.6 1.625 91 55 81.3 0 9 281 2470 2560 QPN36938.1 polyprotein [Ohio dicistro-like virus] diamond 546 63.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Ohio dicistro-like virus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;