RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA690124" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690124 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1945227 1945227 PRJNA690124_P_NODE_2_length_7254_cov_7.986631_g1_i0 PRJNA690124 2 7254 7.986631 579.35021274 Zebrafish picornavirus 1 2304617 Viruses Viruses 11845 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1 i0 96.129 3.05707196029777 7260 275 100 4 1 7254 920 8179 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 22176 11845 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
3220283 3220283 PRJNA690124_P_NODE_3_length_7198_cov_46.612912_g2_i0 PRJNA690124 3 7198 46.612912 3355.19740576 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2839 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g2 i0 95.694 0.666157265907196 1765 73 67 3 1 1764 7091 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4795 2839 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
4497646 4497646 PRJNA690124_P_NODE_48524_length_248_cov_1.320000_g48158_i0 PRJNA690124 48524 248 1.32 3.2736 Zebrafish picornavirus 1 2304617 Viruses Viruses 418 1.9199999999999994e-112   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g48158 i0 97.166 2.98790322580645 247 7 99 0 1 247 6851 7097 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 741 418 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
7047904 7047904 PRJNA690124_P_NODE_3546_length_826_cov_8.289509_g3246_i0 PRJNA690124 3546 826 8.289509 68.47134434 Zebrafish picornavirus 1 2304617 Viruses Viruses 1406 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g3246 i0 97.455 2.87409200968523 825 19 99 2 1 824 2 825 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 2374 1406 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
8322162 8322162 PRJNA690124_P_NODE_22447_length_344_cov_1.583026_g22081_i0 PRJNA690124 22447 344 1.583026 5.44560944 Iflavirus betaspexiguae 3048332 Viruses Viruses 580 3.3599999999999993e-161   NTclustered gi|2895513713|tpg|BK068477.1| 3048332 g22081 i0 97.093 5 344 10 100 0 1 344 7692 7349 TPA_asm: Iflavirus betaspexiguae isolate WUR6 polyprotein gene, complete cds blastn 1720 580 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
8322556 8322556 PRJNA690124_P_NODE_40807_length_260_cov_1.593583_g40441_i0 PRJNA690124 40807 260 1.593583 4.1433158 Iflavirus betaspexiguae 3048332 Viruses Viruses 472 1.53e-128   NTclustered gi|2895513713|tpg|BK068477.1| 3048332 g40441 i0 99.612 5.95384615384615 258 1 99 0 1 258 4181 3924 TPA_asm: Iflavirus betaspexiguae isolate WUR6 polyprotein gene, complete cds blastn 1548 472 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
10872920 10872920 PRJNA690124_P_NODE_15069_length_415_cov_2.318713_g14703_i0 PRJNA690124 15069 415 2.318713 9.62265895 Iflavirus betaspexiguae 3048332 Viruses Viruses 680 0   NTclustered gi|612400726|gb|KJ186788.1| 1228012 g14703 i0 96.368 6.9710843373494 413 15 99 0 3 415 8289 7877 Spodoptera exigua iflavirus 2 from Spain, complete genome blastn 2893 680 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
10873901 10873901 PRJNA690124_P_NODE_9_length_5347_cov_6.780812_g1_i1 PRJNA690124 9 5347 6.780812 362.57001764 Zebrafish picornavirus 1 2304617 Viruses Viruses 8591 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1 i1 95.664 3.00224424911165 5350 229 100 3 1 5347 6269 920 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 16053 8591 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
16481491 16481491 PRJNA690124_P_NODE_50513_length_247_cov_0.896552_g50147_i0 PRJNA690124 50513 247 0.896552 2.21448344 Iflavirus 232799 Viruses Viruses 435 1.9e-117   NTclustered gi|612400726|gb|KJ186788.1| 1228012 g50147 i0 98.381 7.75708502024291 247 4 100 0 1 247 4144 4390 Spodoptera exigua iflavirus 2 from Spain, complete genome blastn 1916 435 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
17247680 17247680 PRJNA690124_P_NODE_56254_length_242_cov_0.923077_g55888_i0 PRJNA690124 56254 242 0.923077 2.23384634 Iflavirus betaspexiguae 3048332 Viruses Viruses 398 2.4299999999999994e-106   NTclustered gi|612400726|gb|KJ186788.1| 1228012 g55888 i0 96.281 5.99173553719008 242 9 100 0 1 242 5189 4948 Spodoptera exigua iflavirus 2 from Spain, complete genome blastn 1450 398 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
19796787 19796787 PRJNA690124_P_NODE_8996_length_535_cov_1.458874_g8631_i0 PRJNA690124 8996 535 1.458874 7.8049759 Iflavirus betaspexiguae 3048332 Viruses Viruses 939 0   NTclustered gi|2895513713|tpg|BK068477.1| 3048332 g8631 i0 98.318 5.99065420560748 535 9 100 0 1 535 6866 7400 TPA_asm: Iflavirus betaspexiguae isolate WUR6 polyprotein gene, complete cds blastn 3205 939 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
22346849 22346849 PRJNA690124_P_NODE_44538_length_252_cov_0.871508_g44172_i0 PRJNA690124 44538 252 0.871508 2.19620016 Iflavirus betaspexiguae 3048332 Viruses Viruses 436 5.4e-118   NTclustered gi|591398028|ref|NC_023676.1| 1228012 g44172 i0 98.008 5.99206349206349 251 5 99 0 1 251 34 284 Spodoptera exigua iflavirus 2 isolate Korean, complete genome blastn 1510 436 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae

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