RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1005695 · 24 ✖

analysis 1

  • blastn · 24 ✖

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
153553 153553 PRJNA1005695_P_NODE_30221_length_271_cov_4.015152_g29369_i0 PRJNA1005695 30221 271 4.015152 10.88106192 Zebrafish picornavirus 1 2304617 Viruses Viruses 483 7.44e-132   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g29369 i0 98.889 2.99261992619926 270 3 99 0 1 270 544 813 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 811 483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
1428217 1428217 PRJNA1005695_P_NODE_22662_length_315_cov_3.256198_g21810_i0 PRJNA1005695 22662 315 3.256198 10.2570237 Zebrafish picornavirus 1 2304617 Viruses Viruses 547 3.079999999999999e-151   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g21810 i0 98.095 3.0031746031746 315 5 100 1 1 315 433 120 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 946 547 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
1428318 1428318 PRJNA1005695_P_NODE_33422_length_257_cov_5.614130_g32570_i0 PRJNA1005695 33422 257 5.61413 14.4283141 Zebrafish picornavirus 1 2304617 Viruses Viruses 468 1.96e-127   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g32570 i0 99.609 2.98832684824903 256 1 99 0 2 257 6281 6536 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 768 468 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
2703700 2703700 PRJNA1005695_P_NODE_23703_length_309_cov_0.991525_g22851_i0 PRJNA1005695 23703 309 0.991525 3.06381225 Picornaviridae sp. 1530251 Viruses Viruses 433 8.82e-117   NTclustered gi|2245485490|gb|ON161862.1| 1530251 g22851 i0 91.909 2 309 25 100 0 1 309 1193 885 MAG: Picornaviridae sp. isolate 39R-k141_319895 RNA dependent RNA polymerase gene, partial cds blastn 618 433 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
3979820 3979820 PRJNA1005695_P_NODE_1564_length_1264_cov_6.794291_g1149_i0 PRJNA1005695 1564 1264 6.794291 85.87983824 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1146 0   NTclustered gi|2214231551|gb|OM622270.1| 3003959 g1149 i0 83.07 2 1264 210 99 4 3 1264 8960 7699 MAG: Picornavirales sp. isolate HPLV-15 genomic sequence blastn 2528 1146 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
3979985 3979985 PRJNA1005695_P_NODE_33824_length_256_cov_1.278689_g32972_i0 PRJNA1005695 33824 256 1.278689 3.27344384 Zebrafish picornavirus 1 2304617 Viruses Viruses 436 5.5e-118   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g32972 i0 97.638 2.98046875 254 6 99 0 2 255 1336 1083 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 763 436 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
3980008 3980008 PRJNA1005695_P_NODE_3584_length_843_cov_2.933766_g2943_i0 PRJNA1005695 3584 843 2.933766 24.73164738 Zebrafish picornavirus 1 2304617 Viruses Viruses 1459 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g2943 i0 97.979 2.99525504151839 841 17 99 0 2 842 3856 4696 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2525 1459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5256325 5256325 PRJNA1005695_P_NODE_13885_length_410_cov_2.362018_g13033_i0 PRJNA1005695 13885 410 2.362018 9.6842738 Polycipiviridae sp. 2496155 Viruses Viruses 52.8 0.039   NTclustered gi|2756421824|gb|PP744841.1| 2496155 g13033 i0 90.244 0.1 41 3 10 1 73 112 9171 9211 MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence blastn 41 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae   Polycipiviridae sp.
6531724 6531724 PRJNA1005695_P_NODE_31866_length_264_cov_1.732984_g31014_i0 PRJNA1005695 31866 264 1.732984 4.57507776 Picornaviridae sp. 1530251 Viruses Viruses 363 9.809999999999999e-96   NTclustered gi|2245485465|gb|ON161849.1| 1530251 g31014 i0 91.603 2.58712121212121 262 22 99 0 3 264 759 1020 MAG: Picornaviridae sp. isolate 37-k141_149780 RNA dependent RNA polymerase gene, partial cds blastn 683 363 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
6531856 6531856 PRJNA1005695_P_NODE_946_length_1585_cov_6.124339_g649_i0 PRJNA1005695 946 1585 6.124339 97.07077315 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 2028 0   NTclustered gi|2214231551|gb|OM622270.1| 3003959 g649 i0 89.792 2.75331230283912 1587 156 99 6 1 1584 3957 5540 MAG: Picornavirales sp. isolate HPLV-15 genomic sequence blastn 4364 2028 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
7806083 7806083 PRJNA1005695_P_NODE_29067_length_277_cov_1.779412_g28215_i0 PRJNA1005695 29067 277 1.779412 4.92897124 Zebrafish picornavirus 1 2304617 Viruses Viruses 490 4.56e-134   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g28215 i0 98.556 3 277 4 100 0 1 277 3830 3554 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 831 490 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
7806087 7806087 PRJNA1005695_P_NODE_29707_length_274_cov_1.547264_g28855_i0 PRJNA1005695 29707 274 1.547264 4.23950336 Zebrafish picornavirus 1 2304617 Viruses Viruses 464 2.7299999999999994e-126   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g28855 i0 97.426 2.98905109489051 272 7 99 0 2 273 3109 3380 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 819 464 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
10356833 10356833 PRJNA1005695_P_NODE_7689_length_565_cov_3.264228_g6855_i0 PRJNA1005695 7689 565 3.264228 18.4428882 Zebrafish picornavirus 1 2304617 Viruses Viruses 1014 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g6855 i0 99.113 2.99469026548673 564 5 99 0 2 565 7243 7806 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1692 1014 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
11632161 11632161 PRJNA1005695_P_NODE_34130_length_254_cov_3.193370_g33278_i0 PRJNA1005695 34130 254 3.19337 8.1111598 Zebrafish picornavirus 1 2304617 Viruses Viruses 457 4.18e-124   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g33278 i0 99.209 2.98818897637795 253 2 99 0 1 253 2859 2607 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 759 457 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12907381 12907381 PRJNA1005695_P_NODE_431_length_2169_cov_5.205630_g276_i0 PRJNA1005695 431 2169 5.20563 112.9101147 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 2475 0   NTclustered gi|2214231551|gb|OM622270.1| 3003959 g276 i0 87.333 2.00184416781927 2171 263 99 7 1 2162 7688 5521 MAG: Picornavirales sp. isolate HPLV-15 genomic sequence blastn 4342 2475 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
15456287 15456287 PRJNA1005695_P_NODE_41833_length_227_cov_2.863636_g40981_i0 PRJNA1005695 41833 227 2.863636 6.50045372 Zebrafish picornavirus 1 2304617 Viruses Viruses 375 1.06e-99   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g40981 i0 97.285 2.83259911894273 221 6 97 0 2 222 1626 1846 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 643 375 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
16730558 16730558 PRJNA1005695_P_NODE_74_length_4059_cov_5.293778_g45_i0 PRJNA1005695 74 4059 5.293778 214.87444902 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 2420 0   NTclustered gi|2214231551|gb|OM622270.1| 3003959 g45 i0 81.666 2.02118748460212 2989 479 99 56 1 2965 4001 1058 MAG: Picornavirales sp. isolate HPLV-15 genomic sequence blastn 8204 2420 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
18005222 18005222 PRJNA1005695_P_NODE_2355_length_1040_cov_2.152017_g1821_i0 PRJNA1005695 2355 1040 2.152017 22.3809768 Zebrafish picornavirus 1 2304617 Viruses Viruses 1799 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1821 i0 97.885 3.00096153846154 1040 22 100 0 1 1040 5151 6190 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 3121 1799 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18005376 18005376 PRJNA1005695_P_NODE_38875_length_244_cov_1.707602_g38023_i0 PRJNA1005695 38875 244 1.707602 4.16654888 Chemarfal virus 29 3062910 Viruses Viruses 119 2.14e-22   NTclustered gi|2626079099|gb|OR270218.1| 3062910 g38023 i0 81.457 0.618852459016393 151 22 61 6 43 190 6382 6529 MAG: Chemarfal virus 29 isolate ML176 genomic sequence blastn 151 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 29
21830211 21830211 PRJNA1005695_P_NODE_15338_length_388_cov_2.968254_g14486_i0 PRJNA1005695 15338 388 2.968254 11.51682552 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 425 1.9e-114   NTclustered gi|2214231551|gb|OM622270.1| 3003959 g14486 i0 86.667 2.01030927835052 390 44 99 5 4 388 8935 9321 MAG: Picornavirales sp. isolate HPLV-15 genomic sequence blastn 780 425 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23105748 23105748 PRJNA1005695_P_NODE_25999_length_294_cov_1.230769_g25147_i0 PRJNA1005695 25999 294 1.230769 3.61846086 Zebrafish picornavirus 1 2304617 Viruses Viruses 525 1.3399999999999995e-144   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g25147 i0 98.976 2.98979591836735 293 3 99 0 1 293 6768 6476 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 879 525 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23953436 23953436 PRJNA1005695_P_NODE_18999_length_346_cov_3.908425_g18147_i0 PRJNA1005695 18999 346 3.908425 13.5231505 Marnavirus 324902 Viruses Viruses 368 2.86e-97   NTclustered gi|1854291015|gb|MN823682.1| 2739886 g18147 i0 85.838 7.00867052023121 346 49 100 0 1 346 6003 5658 Zehneria japonica marnavirus strain pt107-mar-4, complete genome blastn 2425 368 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Marnavirus Zehneria japonica marnavirus
24379693 24379693 PRJNA1005695_P_NODE_42520_length_203_cov_4.353846_g41668_i0 PRJNA1005695 42520 203 4.353846 8.83830738 Zebrafish picornavirus 1 2304617 Viruses Viruses 364 2e-96   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g41668 i0 99.015 2.99014778325123 203 2 100 0 1 203 2000 2202 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 607 364 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
25227251 25227251 PRJNA1005695_P_NODE_15280_length_389_cov_1.974684_g14428_i0 PRJNA1005695 15280 389 1.974684 7.68152076 Marnavirus 324902 Viruses Viruses 320 9.23e-83   NTclustered gi|1854291015|gb|MN823682.1| 2739886 g14428 i0 83.008 2.76863753213368 359 56 92 5 2 358 8778 8423 Zehneria japonica marnavirus strain pt107-mar-4, complete genome blastn 1077 320 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Marnavirus Zehneria japonica marnavirus

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