RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493827 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
9400116 9400116 PRJNA493827_P_NODE_221048_length_243_cov_1.523529_g218850_i0 PRJNA493827 221048 243 1.523529 3.70217547 Locarnavirus 2560169 Viruses Viruses 142 9.32e-38   NR XCM68368.1 1955153 g218850 i0 80 3.95061728395062 80 16 98.8 0 3 242 406 485 XCM68368.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 960 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
28371624 28371624 PRJNA493827_P_NODE_210226_length_246_cov_0.890173_g208028_i0 PRJNA493827 210226 246 0.890173 2.18982558 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 76.6 4.71e-14   NR XHA87929.1 3347367 g208028 i0 50 0.926829268292683 76 38 92.7 0 231 4 2072 2147 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 228 76.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
28971592 28971592 PRJNA493827_P_NODE_130848_length_299_cov_1.053097_g128650_i0 PRJNA493827 130848 299 1.053097 3.14876003 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 79.7 7.7e-15   NR XHA87929.1 3347367 g128650 i0 55.7 0.792642140468227 79 31 78.3 3 65 298 2396 2471 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 237 79.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113
31182277 31182277 PRJNA493827_P_NODE_132555_length_297_cov_1.017857_g130357_i0 PRJNA493827 132555 297 1.017857 3.02303529 Qianjiang dicistro-like virus 113 3347367 Viruses Viruses 82.4 8.37e-16   NR XHA87929.1 3347367 g130357 i0 46.9 0.96969696969697 96 50 96 1 8 292 1893 1988 XHA87929.1 MAG: polyprotein [Qianjiang dicistro-like virus 113] diamond 288 82.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 113

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