RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA799842 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
792997 792997 PRJNA799842_P_NODE_11781_length_913_cov_4.797619_g10551_i0 PRJNA799842 11781 913 4.797619 43.80226147 Zebrafish picornavirus 1 2304617 Viruses Viruses 1565 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g10551 i0 97.593 2.93209200438116 914 20 100 2 1 913 18 930 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2677 1565 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
793504 793504 PRJNA799842_P_NODE_143381_length_250_cov_0.870056_g141808_i0 PRJNA799842 143381 250 0.870056 2.17514 Zebrafish picornavirus 1 2304617 Viruses Viruses 388 1.5199999999999998e-103   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g141808 i0 94.8 2.776 250 12 100 1 1 250 287 39 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 694 388 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4622341 4622341 PRJNA799842_P_NODE_168504_length_245_cov_0.895349_g166931_i0 PRJNA799842 168504 245 0.895349 2.19360505 Potyvirus glycitessellati 3240532 Viruses Viruses 448 2.41e-121   NTclustered gi|2621721683|dbj|LC786829.1| 12222 g166931 i0 99.592 100 245 1 100 0 1 245 5367 5123 Soybean mosaic virus CC20s gene for polyprotein, complete cds blastn 24500 448 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus glycitessellati
5898876 5898876 PRJNA799842_P_NODE_62665_length_360_cov_1.052265_g61092_i0 PRJNA799842 62665 360 1.052265 3.788154 Zebrafish picornavirus 1 2304617 Viruses Viruses 562 1.27e-155   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g61092 i0 94.972 2.96944444444444 358 18 99 0 1 358 2264 2621 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1069 562 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9721214 9721214 PRJNA799842_P_NODE_121908_length_265_cov_1.203125_g120335_i0 PRJNA799842 121908 265 1.203125 3.18828125 Zebrafish picornavirus 1 2304617 Viruses Viruses 451 2.04e-122   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g120335 i0 97.358 3 265 7 100 0 1 265 1417 1681 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 795 451 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12272182 12272182 PRJNA799842_P_NODE_108870_length_280_cov_1.487923_g107297_i0 PRJNA799842 108870 280 1.487923 4.1661844 Guiyang Paspalum paspaloides solemo-like virus 1 2970294 Viruses Viruses 473 4.649999999999999e-129   NTclustered gi|2320142004|gb|OM514387.1| 2970294 g107297 i0 97.143 63.025 280 8 100 0 1 280 2336 2615 MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence blastn 17647 473 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae   Guiyang Paspalum paspaloides solemo-like virus 1
13547912 13547912 PRJNA799842_P_NODE_188031_length_241_cov_0.916667_g186458_i0 PRJNA799842 188031 241 0.916667 2.20916747 Guiyang Paspalum paspaloides solemo-like virus 1 2970294 Viruses Viruses 350 6.87e-92   NTclustered gi|2320142004|gb|OM514387.1| 2970294 g186458 i0 92.917 0.995850622406639 240 17 99 0 2 241 1031 1270 MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence blastn 240 350 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae   Guiyang Paspalum paspaloides solemo-like virus 1
14821192 14821192 PRJNA799842_P_NODE_108092_length_281_cov_1.466346_g106519_i0 PRJNA799842 108092 281 1.466346 4.12043226 Zebrafish picornavirus 1 2304617 Viruses Viruses 409 1.33e-109   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g106519 i0 92.883 3 281 20 100 0 1 281 2716 2996 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 843 409 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17371819 17371819 PRJNA799842_P_NODE_138074_length_251_cov_0.865169_g136501_i0 PRJNA799842 138074 251 0.865169 2.17157419 Potyvirus orionspassiflorae 3240573 Viruses Viruses 459 1.1499999999999996e-124   NTclustered gi|1335762644|gb|KY614052.1| 341167 g136501 i0 99.602 11.8366533864542 251 1 100 0 1 251 5882 5632 East Asian Passiflora virus isolate pt, complete genome blastn 2971 459 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus orionspassiflorae
17372184 17372184 PRJNA799842_P_NODE_159094_length_247_cov_0.885057_g157521_i0 PRJNA799842 159094 247 0.885057 2.18609079 Guiyang Paspalum paspaloides solemo-like virus 1 2970294 Viruses Viruses 296 9.34e-76   NTclustered gi|2320142004|gb|OM514387.1| 2970294 g157521 i0 94.764 0.773279352226721 191 8 77 2 55 244 1619 1808 MAG: Guiyang Paspalum paspaloides solemo-like virus 1 isolate SSQBGZ50 genomic sequence blastn 191 296 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae   Guiyang Paspalum paspaloides solemo-like virus 1
18646249 18646249 PRJNA799842_P_NODE_37855_length_465_cov_1.964286_g36284_i0 PRJNA799842 37855 465 1.964286 9.1339299 Zebrafish picornavirus 1 2304617 Viruses Viruses 798 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g36284 i0 97.634 2.99784946236559 465 11 100 0 1 465 4057 4521 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1394 798 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21197247 21197247 PRJNA799842_P_NODE_40897_length_446_cov_1.959786_g39326_i0 PRJNA799842 40897 446 1.959786 8.74064556 Zebrafish picornavirus 1 2304617 Viruses Viruses 671 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g39326 i0 94.292 2.95964125560538 438 25 98 0 9 446 5476 5039 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1320 671 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21197645 21197645 PRJNA799842_P_NODE_57_length_6175_cov_7.528024_g18_i1 PRJNA799842 57 6175 7.528024 464.855482 Zebrafish picornavirus 1 2304617 Viruses Viruses 10087 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g18 i1 96.148 3.00210526315789 6179 233 100 5 1 6175 969 7146 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 18538 10087 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23748402 23748402 PRJNA799842_P_NODE_8079_length_1100_cov_9.037001_g18_i2 PRJNA799842 8079 1100 9.037001 99.407011 Zebrafish picornavirus 1 2304617 Viruses Viruses 1820 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g18 i2 96.545 3.47181818181818 1100 37 100 1 1 1100 8185 7087 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 3819 1820 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
25021440 25021440 PRJNA799842_P_NODE_40_length_7285_cov_8.778841_g18_i0 PRJNA799842 40 7285 8.778841 639.53856685 Zebrafish picornavirus 1 2304617 Viruses Viruses 11860 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g18 i0 96.048 3.07288949897049 7288 284 100 4 1 7285 969 8255 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 22386 11860 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);;