RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA278119" and tax_kingdom = "Bamfordvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Bamfordvirae · 2 ✖

bioproject 1

  • PRJNA278119 · 2 ✖

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
27895220 27895220 PRJNA278119_P_NODE_19685_length_226_cov_1.175141_g19436_i0 PRJNA278119 19685 226 1.175141 2.65581866 Hyperionvirus sp. 2487770 Viruses Viruses 87 3.5e-18   NR AYV82700.1 2487770 g19436 i0 58.3 0.955752212389381 72 30 95.6 0 11 226 112 183 AYV82700.1 MAG: RNA ligase [Hyperionvirus sp.] diamond 216 87 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Hyperionvirus sp.
32697660 32697660 PRJNA278119_P_NODE_8820_length_397_cov_2.086207_g8573_i0 PRJNA278119 8820 397 2.086207 8.28224179 Marseillevirus LCMAC2 2506606 Viruses Viruses 57.8 8.28e-7   NR QBK88291.1 2506606 g8573 i0 51.9 0.408060453400504 54 22 40.8 1 344 183 7 56 QBK88291.1 MAG: hypothetical protein LCMAC202_06530 [Marseillevirus LCMAC202] diamond 162 57.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Marseilleviridae   Marseillevirus LCMAC202

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