RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA695140 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
676145 676145 PRJNA695140_S_NODE_6601_length_205_cov_2.357143_g6420_i0 PRJNA695140 6601 205 2.357143 4.83214315 Zebrafish picornavirus 1 2304617 Viruses Viruses 320 4.44e-83   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g6420 i0 97.849 2.7219512195122 186 3 91 1 1 186 4147 4331 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 558 320 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
676164 676164 PRJNA695140_S_NODE_8301_length_183_cov_9.246575_g8120_i0 PRJNA695140 8301 183 9.246575 16.92123225 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.004   NTclustered gi|2560238523|emb|OY706291.1| 2697049 g8120 i0 100 0.158469945355191 29 0 16 0 1 29 27265 27237 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1952021 1952021 PRJNA695140_S_NODE_10922_length_162_cov_2.376000_g10741_i0 PRJNA695140 10922 162 2.376 3.84912 Zebrafish picornavirus 1 2304617 Viruses Viruses 241 2.68e-59   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g10741 i0 94.805 2.95061728395062 154 8 95 0 9 162 3669 3516 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 478 241 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
1952065 1952065 PRJNA695140_S_NODE_3502_length_279_cov_1.739669_g3321_i0 PRJNA695140 3502 279 1.739669 4.85367651 Zebrafish picornavirus 1 2304617 Viruses Viruses 483 7.689999999999998e-132   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g3321 i0 97.849 2.99283154121864 279 6 100 0 1 279 2047 2325 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 835 483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4504106 4504106 PRJNA695140_S_NODE_13044_length_151_cov_1.614035_g12863_i0 PRJNA695140 13044 151 1.614035 2.43719285 Zebrafish picornavirus 1 2304617 Viruses Viruses 241 2.4500000000000008e-59   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g12863 i0 95.364 3 151 7 100 0 1 151 2630 2780 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 453 241 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4504181 4504181 PRJNA695140_S_NODE_7284_length_195_cov_2.854430_g7103_i0 PRJNA695140 7284 195 2.85443 5.5661385 Zebrafish picornavirus 1 2304617 Viruses Viruses 333 5.369999999999999e-87   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7103 i0 97.436 2.96923076923077 195 5 100 0 1 195 6572 6378 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 579 333 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4504182 4504182 PRJNA695140_S_NODE_7324_length_195_cov_1.367089_g7143_i0 PRJNA695140 7324 195 1.367089 2.66582355 Zebrafish picornavirus 1 2304617 Viruses Viruses 322 1.16e-83   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g7143 i0 96.41 3 195 7 100 0 1 195 5178 4984 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 585 322 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5779575 5779575 PRJNA695140_S_NODE_12945_length_151_cov_3.736842_g12764_i0 PRJNA695140 12945 151 3.736842 5.64263142 Zebrafish picornavirus 1 2304617 Viruses Viruses 263 5.23e-66   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g12764 i0 98.013 3 151 3 100 0 1 151 6073 5923 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 453 263 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5779654 5779654 PRJNA695140_S_NODE_8645_length_180_cov_2.419580_g8464_i0 PRJNA695140 8645 180 2.41958 4.355244 Zebrafish picornavirus 1 2304617 Viruses Viruses 300 4.94e-77   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g8464 i0 96.667 3 180 6 100 0 1 180 1613 1434 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 540 300 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
7054769 7054769 PRJNA695140_S_NODE_9906_length_169_cov_2.068182_g9725_i0 PRJNA695140 9906 169 2.068182 3.49522758 Zebrafish picornavirus 1 2304617 Viruses Viruses 302 1.27e-77   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g9725 i0 98.817 3 169 2 100 0 1 169 5943 5775 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 507 302 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
10880068 10880068 PRJNA695140_S_NODE_10549_length_165_cov_1.007812_g10368_i0 PRJNA695140 10549 165 1.007812 1.6628898 Zebrafish picornavirus 1 2304617 Viruses Viruses 255 9.8e-64   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g10368 i0 95.062 2.94545454545455 162 8 98 0 3 164 1801 1962 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 486 255 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
12155273 12155273 PRJNA695140_S_NODE_5050_length_233_cov_3.867347_g4869_i0 PRJNA695140 5050 233 3.867347 9.01091851 Zebrafish picornavirus 1 2304617 Viruses Viruses 420 4.96e-113   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g4869 i0 99.565 2.96137339055794 230 1 99 0 1 230 7632 7861 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 690 420 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14705037 14705037 PRJNA695140_S_NODE_10812_length_163_cov_1.531746_g10631_i0 PRJNA695140 10812 163 1.531746 2.49674598 Zebrafish picornavirus 1 2304617 Viruses Viruses 268 1.24e-67   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g10631 i0 96.319 3 163 6 100 0 1 163 2817 2979 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 489 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14705138 14705138 PRJNA695140_S_NODE_9992_length_168_cov_3.763359_g9811_i0 PRJNA695140 9992 168 3.763359 6.32244312 Zebrafish picornavirus 1 2304617 Viruses Viruses 285 1.28e-72   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g9811 i0 97.59 2.96428571428571 166 4 99 0 1 166 4867 4702 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 498 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17253937 17253937 PRJNA695140_S_NODE_4174_length_256_cov_3.753425_g3993_i0 PRJNA695140 4174 256 3.753425 9.608768 Zebrafish picornavirus 1 2304617 Viruses Viruses 446 9.139999999999999e-121   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g3993 i0 98.047 3 256 5 100 0 1 256 7687 7432 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 768 446 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
19802901 19802901 PRJNA695140_S_NODE_10756_length_163_cov_2.706349_g10575_i0 PRJNA695140 10756 163 2.706349 4.41134887 Zebrafish picornavirus 1 2304617 Viruses Viruses 285 1.23e-72   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g10575 i0 98.16 3 163 3 100 0 1 163 4284 4446 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 489 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
19802953 19802953 PRJNA695140_S_NODE_3336_length_286_cov_2.510040_g3155_i0 PRJNA695140 3336 286 2.51004 7.1787144 Zebrafish picornavirus 1 2304617 Viruses Viruses 496 1.02e-135   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g3155 i0 97.902 3 286 6 100 0 1 286 6328 6043 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 858 496 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21078551 21078551 PRJNA695140_S_NODE_7157_length_197_cov_1.637500_g6976_i0 PRJNA695140 7157 197 1.6375 3.225875 Zebrafish picornavirus 1 2304617 Viruses Viruses 353 4.18e-93   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g6976 i0 98.985 3 197 2 100 0 1 197 3437 3241 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 591 353 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23628829 23628829 PRJNA695140_S_NODE_3339_length_286_cov_2.176707_g3158_i0 PRJNA695140 3339 286 2.176707 6.22538202 Zebrafish picornavirus 1 2304617 Viruses Viruses 459 1.3299999999999996e-124   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g3158 i0 95.775 2.97902097902098 284 12 99 0 1 284 1050 1333 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 852 459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
23628837 23628837 PRJNA695140_S_NODE_4179_length_256_cov_2.986301_g3998_i0 PRJNA695140 4179 256 2.986301 7.64493056 Zebrafish picornavirus 1 2304617 Viruses Viruses 451 1.96e-122   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g3998 i0 98.438 3 256 4 100 0 1 256 3775 4030 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 768 451 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);;