RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA685060" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA685060 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
9594717 9594717 PRJNA685060_P_NODE_11268_length_279_cov_1.495146_g11178_i0 PRJNA685060 11268 279 1.495146 4.17145734 Zebrafish picornavirus 1 2304617 Viruses Viruses 505 1.6399999999999995e-138   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g11178 i0 99.283 3.9247311827957 279 2 100 0 1 279 8173 7895 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1095 505 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
9594736 9594736 PRJNA685060_P_NODE_1368_length_848_cov_1.766452_g1293_i0 PRJNA685060 1368 848 1.766452 14.97951296 Zebrafish picornavirus 1 2304617 Viruses Viruses 1417 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g1293 i0 96.816 3 848 27 100 0 1 848 7029 7876 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2544 1417 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13420133 13420133 PRJNA685060_P_NODE_2091_length_682_cov_1.625616_g2004_i0 PRJNA685060 2091 682 1.625616 11.08670112 Zebrafish picornavirus 1 2304617 Viruses Viruses 1144 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g2004 i0 96.921 3 682 21 100 0 1 682 6305 6986 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 2046 1144 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
21068525 21068525 PRJNA685060_P_NODE_11177_length_281_cov_1.389423_g11087_i0 PRJNA685060 11177 281 1.389423 3.90427863 Zebrafish picornavirus 1 2304617 Viruses Viruses 475 1.2999999999999999e-129   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g11087 i0 97.153 3 281 8 100 0 1 281 4869 5149 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 843 475 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24892323 24892323 PRJNA685060_P_NODE_5240_length_420_cov_1.109510_g5150_i0 PRJNA685060 5240 420 1.10951 4.659942 Zebrafish picornavirus 1 2304617 Viruses Viruses 721 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g5150 i0 97.619 3 420 10 100 0 1 420 5884 6303 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 1260 721 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);;