RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA299585" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 17 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA299585 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
375076 375076 PRJNA299585_S_NODE_2161_length_660_cov_5.431062_g1975_i0 PRJNA299585 2161 660 5.431062 35.8450092 Zebrafish picornavirus 1 2304617 Viruses Viruses 1037 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1975 i0 95.015 3.00909090909091 662 30 99 3 2 660 3617 2956 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1986 1037 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
375145 375145 PRJNA299585_S_NODE_4741_length_379_cov_3.700000_g4511_i0 PRJNA299585 4741 379 3.7 14.023 Zebrafish picornavirus 1 2304617 Viruses Viruses 569 8.06e-158   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g4511 i0 93.701 2.9868073878628 381 22 100 2 1 379 743 1123 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1132 569 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
1649861 1649861 PRJNA299585_S_NODE_13102_length_172_cov_4.489510_g12872_i0 PRJNA299585 13102 172 4.48951 7.7219572 Zebrafish picornavirus 1 2304617 Viruses Viruses 259 7.92e-65   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g12872 i0 96.203 2.83720930232558 158 6 92 0 1 158 2491 2648 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 488 259 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
2925868 2925868 PRJNA299585_S_NODE_4343_length_403_cov_5.237968_g4113_i0 PRJNA299585 4343 403 5.237968 21.10901104 Zebrafish picornavirus 1 2304617 Viruses Viruses 678 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g4113 i0 97.022 3 403 12 100 0 1 403 1893 2295 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1209 678 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5478517 5478517 PRJNA299585_S_NODE_11045_length_196_cov_3.766467_g10815_i0 PRJNA299585 11045 196 3.766467 7.38227532 Zebrafish picornavirus 1 2304617 Viruses Viruses 296 7.089999999999998e-76   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g10815 i0 93.878 3 196 12 100 0 1 196 2814 2619 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 588 296 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
5478707 5478707 PRJNA299585_S_NODE_6425_length_303_cov_4.379562_g6195_i0 PRJNA299585 6425 303 4.379562 13.27007286 Zebrafish picornavirus 1 2304617 Viruses Viruses 460 3.959999999999999e-125   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g6195 i0 94.059 3 303 18 100 0 1 303 1165 1467 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 909 460 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
8028437 8028437 PRJNA299585_S_NODE_1947_length_703_cov_5.182493_g1771_i0 PRJNA299585 1947 703 5.182493 36.43292579 Zebrafish picornavirus 1 2304617 Viruses Viruses 1138 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g1771 i0 95.875 3 703 29 100 0 1 703 1159 1861 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2109 1138 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9303125 9303125 PRJNA299585_S_NODE_10128_length_209_cov_4.527778_g9898_i0 PRJNA299585 10128 209 4.527778 9.46305602 Zebrafish picornavirus 1 2304617 Viruses Viruses 353 4.489999999999999e-93   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g9898 i0 97.129 3 209 6 100 0 1 209 3604 3812 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 627 353 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9303238 9303238 PRJNA299585_S_NODE_288_length_1860_cov_10.434189_g260_i0 PRJNA299585 288 1860 10.434189 194.0759154 Zebrafish picornavirus 1 2304617 Viruses Viruses 3238 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g260 i0 98.116 3.13548387096774 1858 35 99 0 3 1860 6304 8161 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 5832 3238 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9303378 9303378 PRJNA299585_S_NODE_9208_length_226_cov_4.715736_g8978_i0 PRJNA299585 9208 226 4.715736 10.65756336 Zebrafish picornavirus 1 2304617 Viruses Viruses 390 3.749999999999999e-104   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g8978 i0 98.214 2.97345132743363 224 3 99 1 4 226 739 516 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 672 390 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
11853813 11853813 PRJNA299585_S_NODE_2710_length_573_cov_9.784926_g2505_i0 PRJNA299585 2710 573 9.784926 56.06762598 Zebrafish picornavirus 1 2304617 Viruses Viruses 1009 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2505 i0 98.429 3 573 9 100 0 1 573 6335 5763 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1719 1009 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
11853931 11853931 PRJNA299585_S_NODE_8130_length_251_cov_3.671171_g7900_i0 PRJNA299585 8130 251 3.671171 9.21463921 Zebrafish picornavirus 1 2304617 Viruses Viruses 459 1.1499999999999996e-124   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g7900 i0 99.602 3 251 1 100 0 1 251 275 525 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 753 459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18226990 18226990 PRJNA299585_S_NODE_9075_length_229_cov_3.945000_g8845_i0 PRJNA299585 9075 229 3.945 9.03405 Zebrafish picornavirus 1 2304617 Viruses Viruses 374 3.8399999999999996e-99   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g8845 i0 96.07 3 229 9 100 0 1 229 2819 3047 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 687 374 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
20776777 20776777 PRJNA299585_S_NODE_7357_length_272_cov_3.646091_g7127_i0 PRJNA299585 7357 272 3.646091 9.91736752 Zebrafish picornavirus 1 2304617 Viruses Viruses 436 5.9e-118   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g7127 i0 95.588 3 272 12 100 0 1 272 2336 2607 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 816 436 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22051689 22051689 PRJNA299585_S_NODE_2958_length_536_cov_7.187377_g2747_i0 PRJNA299585 2958 536 7.187377 38.52434072 Zebrafish picornavirus 1 2304617 Viruses Viruses 880 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2747 i0 96.269 3 536 20 100 0 1 536 5589 5054 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1608 880 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
22051768 22051768 PRJNA299585_S_NODE_638_length_1319_cov_8.016279_g570_i0 PRJNA299585 638 1319 8.016279 105.73472001 Zebrafish picornavirus 1 2304617 Viruses Viruses 2270 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g570 i0 97.726 2.99620924943139 1319 30 100 0 1 1319 5110 3792 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 3952 2270 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24601387 24601387 PRJNA299585_S_NODE_9020_length_230_cov_7.432836_g8790_i0 PRJNA299585 9020 230 7.432836 17.0955228 Zebrafish picornavirus 1 2304617 Viruses Viruses 398 2.2899999999999997e-106   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g8790 i0 97.826 3.01304347826087 230 5 100 0 1 230 5572 5801 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 693 398 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);;