RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1012699" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1012699 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
2708348 2708348 PRJNA1012699_P_NODE_263_length_641_cov_6.580986_g234_i0 PRJNA1012699 263 641 6.580986 42.18412026 Zebrafish picornavirus 1 2304617 Viruses Viruses 1101 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g234 i0 97.66 3 641 15 100 0 1 641 6267 5627 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1923 1101 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
3984559 3984559 PRJNA1012699_P_NODE_304_length_604_cov_3.156309_g274_i0 PRJNA1012699 304 604 3.156309 19.06410636 Zebrafish picornavirus 1 2304617 Viruses Viruses 974 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g274 i0 95.847 2.99172185430464 602 25 99 0 3 604 1633 2234 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1807 974 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
10361293 10361293 PRJNA1012699_P_NODE_89_length_1103_cov_5.780583_g68_i0 PRJNA1012699 89 1103 5.780583 63.75983049 Zebrafish picornavirus 1 2304617 Viruses Viruses 1888 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g68 i0 97.721 3.28286491387126 1097 25 99 0 4 1100 7097 8193 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 3621 1888 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12911602 12911602 PRJNA1012699_P_NODE_131_length_885_cov_3.227833_g104_i0 PRJNA1012699 131 885 3.227833 28.56632205 Zebrafish picornavirus 1 2304617 Viruses Viruses 1471 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g104 i0 96.719 2.93220338983051 884 28 99 1 1 884 23 905 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2595 1471 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12911606 12911606 PRJNA1012699_P_NODE_151_length_824_cov_4.107856_g124_i0 PRJNA1012699 151 824 4.107856 33.84873344 Zebrafish picornavirus 1 2304617 Viruses Viruses 1341 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g124 i0 96.107 2.99514563106796 822 32 99 0 2 823 1709 888 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2468 1341 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14186617 14186617 PRJNA1012699_P_NODE_1432_length_315_cov_2.231405_g1400_i0 PRJNA1012699 1432 315 2.231405 7.02892575 Zebrafish picornavirus 1 2304617 Viruses Viruses 479 1.1399999999999996e-130   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g1400 i0 94.249 3.00952380952381 313 18 99 0 2 314 2936 3248 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 948 479 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14186625 14186625 PRJNA1012699_P_NODE_2012_length_279_cov_2.266990_g1980_i0 PRJNA1012699 2012 279 2.26699 6.3249021 Zebrafish picornavirus 1 2304617 Viruses Viruses 466 7.74e-127   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1980 i0 97.101 2.96774193548387 276 8 99 0 3 278 3487 3212 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 828 466 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18009885 18009885 PRJNA1012699_P_NODE_635_length_441_cov_3.847826_g603_i0 PRJNA1012699 635 441 3.847826 16.96891266 Zebrafish picornavirus 1 2304617 Viruses Viruses 682 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g603 i0 94.582 3.00680272108844 443 21 99 3 1 440 2720 3162 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1326 682 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
20559164 20559164 PRJNA1012699_P_NODE_137_length_868_cov_4.533333_g110_i0 PRJNA1012699 137 868 4.533333 39.34933044 Zebrafish picornavirus 1 2304617 Viruses Viruses 1483 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g110 i0 97.683 2.98617511520737 863 20 99 0 4 866 6247 7109 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2592 1483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23110310 23110310 PRJNA1012699_P_NODE_19_length_1799_cov_4.223638_g13_i0 PRJNA1012699 19 1799 4.223638 75.98324762 Zebrafish picornavirus 1 2304617 Viruses Viruses 2952 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g13 i0 96.28 3.00055586436909 1801 64 99 1 1 1798 3986 5786 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 5398 2952 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23110329 23110329 PRJNA1012699_P_NODE_319_length_595_cov_4.040230_g289_i0 PRJNA1012699 319 595 4.04023 24.0393685 Zebrafish picornavirus 1 2304617 Viruses Viruses 998 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g289 i0 96.97 2.97478991596639 594 18 99 0 1 594 2221 2814 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1770 998 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1

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