RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 2 ✖

bioproject 1

  • PRJNA562549 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
15848635 15848635 PRJNA562549_P_NODE_28413_length_221_cov_1.625000_g28180_i0 PRJNA562549 28413 221 1.625 3.59125 Zebrafish picornavirus 1 2304617 Viruses Viruses 392 1.0199999999999999e-104   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g28180 i0 98.643 2.99095022624434 221 3 100 0 1 221 7251 7471 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 661 392 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
24772030 24772030 PRJNA562549_P_NODE_31980_length_210_cov_0.872483_g31747_i0 PRJNA562549 31980 210 0.872483 1.8322143 Zebrafish jaw poxvirus RQ14 Viruses Viruses 171 4.88e-38   NTclustered gi|1998702321|dbj|LC613089.1| RQ14 g31747 i0 82.323 77.3 198 33 94 2 6 202 370821 371017 Carp edema virus FTI2020 DNA, complete genome blastn 16233 171 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus

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