RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA207719" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA207719 · 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
367052 367052 PRJNA207719_P_NODE_921_length_200_cov_1.286550_g901_i0 PRJNA207719 921 200 1.28655 2.5731 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 298 2.02e-76   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g901 i0 93.5 1 200 13 100 0 1 200 6653 6454 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 200 298 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
27800664 27800664 PRJNA207719_P_NODE_384_length_342_cov_4.265176_g364_i0 PRJNA207719 384 342 4.265176 14.58690192 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 84.7 2.32e-16   NR UNY41988.1 3003959 g364 i0 48 0.859649122807018 98 49 85.1 2 340 50 2842 2938 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 294 84.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28021684 28021684 PRJNA207719_P_NODE_1165_length_170_cov_2.652482_g1145_i0 PRJNA207719 1165 170 2.652482 4.5092194 Locarnavirus sp. 2809529 Viruses Viruses 67.4 2.78e-11   NR ULG00057.1 2809529 g1145 i0 66.1 1.97647058823529 56 19 98.8 0 1 168 266 321 ULG00057.1 MAG: hypothetical protein 2 [Locarnavirus sp.] diamond 336 67.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
28905348 28905348 PRJNA207719_P_NODE_588_length_264_cov_3.293617_g568_i0 PRJNA207719 588 264 3.293617 8.69514888 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 108 2.54e-25   NR UNY41988.1 3003959 g568 i0 59.3 1.03409090909091 91 33 98.9 1 263 3 2292 2382 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 273 108 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30674185 30674185 PRJNA207719_P_NODE_1033_length_185_cov_2.051282_g1013_i0 PRJNA207719 1033 185 2.051282 3.7948717 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 86.3 7.98e-18   NR UNY41988.1 3003959 g1013 i0 67.3 0.843243243243243 52 17 84.3 0 29 184 2601 2652 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 156 86.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31496280 31496280 PRJNA207719_P_NODE_596_length_261_cov_3.689655_g576_i0 PRJNA207719 596 261 3.689655 9.62999955 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 78.6 1.22e-14   NR UNY41988.1 3003959 g576 i0 40.9 1.01149425287356 88 51 100 1 1 261 2689 2776 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 264 78.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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