RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA849646", 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

  • PRJNA849646 · 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
838113 838113 PRJNA849646_P_NODE_1_length_5245_cov_14.010247_g0_i0 PRJNA849646 1 5245 14.010247 734.83745515 Zebrafish picornavirus 1 2304617 Viruses Viruses 8719 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g0 i0 96.666 3.0850333651096302 5249 170 100 3 1 5245 8281 3034 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 16181 8719 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
2113490 2113490 PRJNA849646_P_NODE_14662_length_278_cov_4.039024_g14544_i0 PRJNA849646 14662 278 4.039024 11.22848672 Zebrafish picornavirus 1 2304617 Viruses Viruses 436 6.049999999999999e-118   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g14544 i0 94.964 2.99280575539568 278 14 100 0 1 278 1591 1314 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 832 436 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4666494 4666494 PRJNA849646_P_NODE_1344_length_443_cov_2.972973_g1227_i0 PRJNA849646 1344 443 2.972973 13.17027039 Zebrafish picornavirus 1 2304617 Viruses Viruses 736 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g1227 i0 96.614 3 443 15 100 0 1 443 7492 7934 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1329 736 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
7216201 7216201 PRJNA849646_P_NODE_1486_length_425_cov_2.096591_g1369_i0 PRJNA849646 1486 425 2.096591 8.91051175 Zebrafish picornavirus 1 2304617 Viruses Viruses 680 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1369 i0 95.529 3 425 19 100 0 1 425 2316 1892 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1275 680 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9766508 9766508 PRJNA849646_P_NODE_8_length_3243_cov_12.190852_g4_i0 PRJNA849646 8 3243 12.190852 395.34933036 Zebrafish picornavirus 1 2304617 Viruses Viruses 5188 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g4 i0 95.536 2.98704902867715 3248 138 100 7 1 3243 3271 26 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 9687 5188 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
11042113 11042113 PRJNA849646_P_NODE_9429_length_289_cov_1.425926_g9311_i0 PRJNA849646 9429 289 1.425926 4.12092614 Zebrafish picornavirus 1 2304617 Viruses Viruses 490 4.78e-134   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g9311 i0 97.232 3 289 8 100 0 1 289 7098 6810 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 867 490 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13591745 13591745 PRJNA849646_P_NODE_11_length_3219_cov_13.867133_g0_i1 PRJNA849646 11 3219 13.867133 446.38301127 Zebrafish picornavirus 1 2304617 Viruses Viruses 5308 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g0 i1 96.429 3.13606710158434 3220 113 100 2 1 3219 5050 8268 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 10095 5308 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14866102 14866102 PRJNA849646_P_NODE_2012_length_382_cov_1.754045_g1894_i0 PRJNA849646 2012 382 1.754045 6.7004519 Zebrafish picornavirus 1 2304617 Viruses Viruses 617 2.8599999999999996e-172   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1894 i0 95.812 2.99214659685864 382 16 100 0 1 382 2738 2357 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1143 617 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17416305 17416305 PRJNA849646_P_NODE_13894_length_280_cov_1.487923_g13776_i0 PRJNA849646 13894 280 1.487923 4.1661844 Zebrafish picornavirus 1 2304617 Viruses Viruses 455 1.68e-123   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g13776 i0 96.703 2.925 273 9 98 0 8 280 1048 1320 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 819 455 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18689372 18689372 PRJNA849646_P_NODE_14875_length_278_cov_2.000000_g14757_i0 PRJNA849646 14875 278 2 5.56 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 398 2.8499999999999997e-106   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g14757 i0 92.727 0.989208633093525 275 20 99 0 2 276 6448 6722 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 275 398 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
19964546 19964546 PRJNA849646_P_NODE_1696_length_406_cov_2.528529_g1579_i0 PRJNA849646 1696 406 2.528529 10.26582774 Zebrafish picornavirus 1 2304617 Viruses Viruses 695 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g1579 i0 97.537 3 406 10 100 0 1 406 7470 7875 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1218 695 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21240400 21240400 PRJNA849646_P_NODE_37_length_2590_cov_15.282876_g0_i2 PRJNA849646 37 2590 15.282876 395.8264884 Zebrafish picornavirus 1 2304617 Viruses Viruses 4357 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g0 i2 97.027 3.16718146718147 2590 77 100 0 1 2590 5692 8281 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 8203 4357 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22514999 22514999 PRJNA849646_P_NODE_2758_length_342_cov_1.799257_g2640_i0 PRJNA849646 2758 342 1.799257 6.15345894 Zebrafish picornavirus 1 2304617 Viruses Viruses 549 9.399999999999999e-152   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g2640 i0 95.614 3.08479532163743 342 15 100 0 1 342 7103 7444 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1055 549 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22515198 22515198 PRJNA849646_P_NODE_6738_length_306_cov_2.484979_g6620_i0 PRJNA849646 6738 306 2.484979 7.60403574 Zebrafish picornavirus 1 2304617 Viruses Viruses 512 1.09e-140   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g6620 i0 97.039 2.99346405228758 304 9 99 0 3 306 7005 7308 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 916 512 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
26674721 26674721 PRJNA849646_P_NODE_2301_length_364_cov_3.594502_g2183_i0 PRJNA849646 2301 364 3.594502 13.08398728 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 206 7.630000000000001e-59   NR WKU61618.1 3063761 g2183 i0 85.8 0.989010989010989 120 17 98.9 0 3 362 1219 1338 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 360 206 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
26706433 26706433 PRJNA849646_P_NODE_28261_length_252_cov_3.553073_g28143_i0 PRJNA849646 28261 252 3.553073 8.95374396 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 81.6 8.52e-16   NR AVM87439.1 3063761 g28143 i0 52.9 0.833333333333333 70 33 83.3 0 3 212 975 1044 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 210 81.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2

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