RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA939369", tax_phylum = "Phixviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Phixviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 4 ✖

analysis 1

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
27593855 27593855 PRJNA939369_S_NODE_18184_length_348_cov_1.098182_g17767_i0 PRJNA939369 18184 348 1.098182 3.82167336 Microviridae sp. 2202644 Viruses Viruses 81.6 2.89e-15   NR UCS96056.1 2202644 g17767 i0 45.6 0.775862068965517 90 43 72.4 1 4 255 32 121 UCS96056.1 MAG: major capsid protein [Microviridae sp.] diamond 270 81.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
28761843 28761843 PRJNA939369_S_NODE_61347_length_248_cov_0.880000_g60930_i0 PRJNA939369 61347 248 0.88 2.1824 Microviridae sp. 2202644 Viruses Viruses 82.8 3.1e-16   NR UCS96056.1 2202644 g60930 i0 52.6 0.943548387096774 78 36 93.1 1 241 11 430 507 UCS96056.1 MAG: major capsid protein [Microviridae sp.] diamond 234 82.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31478888 31478888 PRJNA939369_S_NODE_48836_length_260_cov_1.058824_g48419_i0 PRJNA939369 48836 260 1.058824 2.7529424 Microviridae sp. 2202644 Viruses Viruses 57.4 3.21e-7   NR WQF93261.1 2202644 g48419 i0 45.2 0.715384615384615 62 34 71.5 0 74 259 457 518 WQF93261.1 MAG: major capsid protein, partial [Microviridae sp.] diamond 186 57.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
32143087 32143087 PRJNA939369_S_NODE_58378_length_249_cov_1.312500_g57961_i0 PRJNA939369 58378 249 1.3125 3.268125 Microviridae sp. 2202644 Viruses Viruses 167 9.409999999999999e-47   NR WQF95838.1 2202644 g57961 i0 90.4 2.97590361445783 83 8 100 0 1 249 44 126 WQF95838.1 MAG: major capsid protein, partial [Microviridae sp.] diamond 741 167 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.

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