RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA833575", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 10 ✖

tax_phylum 1

  • Pisuviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA833575 · 10 ✖

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
4652502 4652502 PRJNA833575_P_NODE_16304_length_363_cov_2.761905_g16167_i0 PRJNA833575 16304 363 2.761905 10.02571515 Zebrafish picornavirus 1 2304617 Viruses Viruses 610 4.529999999999999e-170   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g16167 i0 96.97 3 363 11 100 0 1 363 872 1234 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1089 610 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
7202662 7202662 PRJNA833575_P_NODE_36966_length_240_cov_1.538012_g36829_i0 PRJNA833575 36966 240 1.538012 3.6912288 Zebrafish picornavirus 1 2304617 Viruses Viruses 364 2.4399999999999993e-96   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g36829 i0 94.167 2.97916666666667 240 12 99 2 1 239 7518 7280 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 715 364 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
8477491 8477491 PRJNA833575_P_NODE_6147_length_571_cov_2.013944_g6010_i0 PRJNA833575 6147 571 2.013944 11.49962024 Zebrafish picornavirus 1 2304617 Viruses Viruses 800 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g6010 i0 92.091 3 569 44 99 1 3 571 3192 2625 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1713 800 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
11028377 11028377 PRJNA833575_P_NODE_489_length_1597_cov_3.105366_g461_i0 PRJNA833575 489 1597 3.105366 49.59269502 Zebrafish picornavirus 1 2304617 Viruses Viruses 2414 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g461 i0 93.938 3.00563556668754 1600 94 100 3 1 1597 3458 1859 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 4800 2414 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
16126808 16126808 PRJNA833575_P_NODE_233_length_1988_cov_3.415842_g218_i0 PRJNA833575 233 1988 3.415842 67.90693896 Zebrafish picornavirus 1 2304617 Viruses Viruses 3267 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g218 i0 96.328 3.00050301810865 1988 73 100 0 1 1988 3577 5564 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 5965 3267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17402531 17402531 PRJNA833575_P_NODE_2434_length_868_cov_3.141427_g2336_i0 PRJNA833575 2434 868 3.141427 27.26758636 Zebrafish picornavirus 1 2304617 Viruses Viruses 1519 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2336 i0 98.274 2.93778801843318 869 11 100 2 1 868 26 891 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2550 1519 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17402535 17402535 PRJNA833575_P_NODE_24514_length_300_cov_2.303030_g24377_i0 PRJNA833575 24514 300 2.30303 6.90909 Zebrafish picornavirus 1 2304617 Viruses Viruses 516 8.23e-142   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g24377 i0 97.667 3 300 7 100 0 1 300 7049 6750 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 900 516 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17402932 17402932 PRJNA833575_P_NODE_7754_length_512_cov_2.142212_g7617_i0 PRJNA833575 7754 512 2.142212 10.96812544 Zebrafish picornavirus 1 2304617 Viruses Viruses 813 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7617 i0 95.312 3 512 24 100 0 1 512 1372 1883 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1536 813 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18675744 18675744 PRJNA833575_P_NODE_35_length_3246_cov_7.294932_g32_i0 PRJNA833575 35 3246 7.294932 236.79349272 Zebrafish picornavirus 1 2304617 Viruses Viruses 5419 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g32 i0 96.796 3.12014787430684 3246 104 100 0 1 3246 4860 8105 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 10128 5419 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
28475837 28475837 PRJNA833575_P_NODE_25946_length_292_cov_1.417040_g25809_i0 PRJNA833575 25946 292 1.41704 4.1377568 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 50.1 1.84e-4   NR XDO02804.1 3239337 g25809 i0 40 0.667808219178082 65 36 63.7 1 1 186 819 883 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 195 50.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22

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