RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1074407", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 16 ✖

tax_phylum 1

  • Pisuviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1074407 · 16 ✖

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
189272 189272 PRJNA1074407_P_NODE_27461_length_1116_cov_2.291467_g24560_i0 PRJNA1074407 27461 1116 2.291467 25.57277172 Zebrafish picornavirus 1 2304617 Viruses Viruses 1129 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g24560 i0 96.486 3.01075268817204 683 24 100 0 434 1116 4309 3627 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 3360 1129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4016205 4016205 PRJNA1074407_P_NODE_42404_length_792_cov_1.974965_g38826_i0 PRJNA1074407 42404 792 1.974965 15.6417228 Zebrafish picornavirus 1 2304617 Viruses Viruses 1336 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g38826 i0 97.096 2.98989898989899 792 23 100 0 1 792 5185 4394 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2368 1336 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5293758 5293758 PRJNA1074407_P_NODE_97045_length_359_cov_0.909091_g93208_i0 PRJNA1074407 97045 359 0.909091 3.26363669 Zebrafish picornavirus 1 2304617 Viruses Viruses 592 1.6199999999999999e-164   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g93208 i0 96.379 3 359 13 100 0 1 359 5211 4853 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1077 592 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
6567267 6567267 PRJNA1074407_P_NODE_28866_length_1079_cov_1.773360_g25870_i0 PRJNA1074407 28866 1079 1.77336 19.1345544 Zebrafish picornavirus 1 2304617 Viruses Viruses 1681 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g25870 i0 94.884 2.98517145505097 1075 55 99 0 1 1075 2011 3085 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 3221 1681 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14217224 14217224 PRJNA1074407_P_NODE_125952_length_272_cov_0.804020_g122114_i0 PRJNA1074407 125952 272 0.80402 2.1869344 Zebrafish picornavirus 1 2304617 Viruses Viruses 431 2.74e-116   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g122114 i0 95.221 3.01102941176471 272 13 100 0 1 272 3126 3397 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 819 431 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18041156 18041156 PRJNA1074407_P_NODE_3435_length_2904_cov_4.531261_g2857_i0 PRJNA1074407 3435 2904 4.531261 131.58781944 Zebrafish picornavirus 1 2304617 Viruses Viruses 4855 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2857 i0 96.864 2.99896694214876 2902 91 99 0 1 2902 8083 5182 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 8709 4855 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23140705 23140705 PRJNA1074407_P_NODE_121559_length_283_cov_1.447619_g117721_i0 PRJNA1074407 121559 283 1.447619 4.09676177 Zebrafish picornavirus 1 2304617 Viruses Viruses 451 2.1999999999999995e-122   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g117721 i0 95.406 3 283 13 100 0 1 283 1653 1935 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 849 451 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23141100 23141100 PRJNA1074407_P_NODE_142299_length_243_cov_1.205882_g138461_i0 PRJNA1074407 142299 243 1.205882 2.93029326 Zebrafish picornavirus 1 2304617 Viruses Viruses 405 1.46e-108   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g138461 i0 96.708 3 243 8 100 0 1 243 1200 1442 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 729 405 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24413948 24413948 PRJNA1074407_P_NODE_10020_length_1938_cov_2.143164_g8616_i0 PRJNA1074407 10020 1938 2.143164 41.53451832 Zebrafish picornavirus 1 2304617 Viruses Viruses 3229 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g8616 i0 96.751 2.96955624355005 1939 60 100 2 1 1938 1954 18 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 5755 3229 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
28141494 28141494 PRJNA1074407_P_NODE_103045_length_338_cov_0.943396_g99207_i0 PRJNA1074407 103045 338 0.943396 3.18867848 Picornaviridae sp. 1530251 Viruses Viruses 207 2.93e-59   NR XDJ26655.1 1530251 g99207 i0 86.6 0.994082840236686 112 15 99.4 0 2 337 1544 1655 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 336 207 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28457160 28457160 PRJNA1074407_P_NODE_77866_length_444_cov_1.843666_g74031_i0 PRJNA1074407 77866 444 1.843666 8.18587704 Picornaviridae sp. 1530251 Viruses Viruses 258 1.54e-76   NR XDJ26655.1 1530251 g74031 i0 85.7 0.993243243243243 147 21 99.3 0 442 2 1327 1473 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 441 258 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28457162 28457162 PRJNA1074407_P_NODE_78966_length_438_cov_1.504110_g75130_i0 PRJNA1074407 78966 438 1.50411 6.5880018 Picornaviridae sp. 1530251 Viruses Viruses 111 2.88e-25   NR XDJ26655.1 1530251 g75130 i0 100 0.376712328767123 55 0 37.7 0 165 1 1 55 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 165 111 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28741166 28741166 PRJNA1074407_P_NODE_45007_length_751_cov_1.513274_g41354_i0 PRJNA1074407 45007 751 1.513274 11.36468774 Picornaviridae sp. 1530251 Viruses Viruses 493 2.0299999999999996e-158   NR XDJ26655.1 1530251 g41354 i0 96.8 0.994673768308921 249 8 99.5 0 3 749 639 887 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 747 493 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29774490 29774490 PRJNA1074407_P_NODE_123031_length_279_cov_2.165049_g119193_i0 PRJNA1074407 123031 279 2.165049 6.04048671 Iflavirus 232799 Viruses Viruses 96.7 6.03e-21   NR WWU04882.1 1916690 g119193 i0 46.2 2.87096774193548 91 49 97.8 0 5 277 309 399 WWU04882.1 MAG: RNA-dependent RNA polymerase, partial [Iflavirus sp.] diamond 801 96.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus sp.
31172929 31172929 PRJNA1074407_P_NODE_40155_length_830_cov_1.589168_g36654_i0 PRJNA1074407 40155 830 1.589168 13.1900944 Picornaviridae sp. 1530251 Viruses Viruses 483 3.9999999999999986e-154   NR XDJ26655.1 1530251 g36654 i0 86.1 0.986746987951807 273 36 98 1 828 16 1652 1924 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 819 483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32565494 32565494 PRJNA1074407_P_NODE_82859_length_419_cov_1.537572_g79023_i0 PRJNA1074407 82859 419 1.537572 6.44242668 Picornaviridae sp. 1530251 Viruses Viruses 290 7.48e-88   NR XDJ26655.1 1530251 g79023 i0 97.8 0.995226730310263 139 3 99.5 0 1 417 1171 1309 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 417 290 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.

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