RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA763718" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA763718 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
5847727 5847727 PRJNA763718_S_NODE_205_length_2911_cov_13.293319_g158_i0 PRJNA763718 205 2911 13.293319 386.96851609 Zebrafish picornavirus 1 2304617 Viruses Viruses 4654 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g158 i0 95.654 2.98694606664376 2899 124 99 2 14 2911 3089 192 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 8695 4654 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
10948310 10948310 PRJNA763718_S_NODE_209_length_2788_cov_106.600509_g106_i2 PRJNA763718 209 2788 106.600509 2972.02219092 Zebrafish picornavirus 1 2304617 Viruses Viruses 4741 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g106 i2 97.382 3.13665710186514 2788 70 100 1 1 2788 8169 5385 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 8745 4741 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
18595832 18595832 PRJNA763718_S_NODE_315_length_1427_cov_11.574101_g158_i1 PRJNA763718 315 1427 11.574101 165.16242127 Zebrafish picornavirus 1 2304617 Viruses Viruses 2213 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g158 i1 94.912 2.97196916608269 1415 70 99 2 14 1427 3089 1676 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 4241 2213 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21146715 21146715 PRJNA763718_S_NODE_137_length_5282_cov_77.602669_g106_i0 PRJNA763718 137 5282 77.602669 4098.97297658 Zebrafish picornavirus 1 2304617 Viruses Viruses 8804 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g106 i0 96.746 3.07402499053389 5285 169 100 3 1 5282 2815 8099 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 16237 8804 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21146728 21146728 PRJNA763718_S_NODE_5677_length_183_cov_3.205479_g5469_i0 PRJNA763718 5677 183 3.205479 5.86602657 Zebrafish picornavirus 1 2304617 Viruses Viruses 292 8.44e-75   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g5469 i0 95.628 2.71584699453552 183 7 100 1 1 183 224 43 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 497 292 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24970779 24970779 PRJNA763718_S_NODE_140_length_5169_cov_78.702455_g106_i1 PRJNA763718 140 5169 78.702455 4068.12989895 Zebrafish picornavirus 1 2304617 Viruses Viruses 8687 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g106 i1 97.003 3.07564325788354 5172 149 100 4 1 5169 3001 8169 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 15898 8687 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);;