RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA599026", tax_phylum = "Phixviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

  • Phixviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA599026 · 3 ✖

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
1847556 1847556 PRJNA599026_S_NODE_51922_length_167_cov_0.864407_g51466_i0 PRJNA599026 51922 167 0.864407 1.44355969 Microvirus sp. 2202559 Viruses Viruses 91.6 2.97e-14   NTclustered gi|1832330308|gb|MT310037.1| 2202559 g51466 i0 87.342 0.934131736526946 79 10 47 0 89 167 638 560 MAG: Microvirus sp. isolate 6538_54, complete genome blastn 156 91.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
27016526 27016526 PRJNA599026_S_NODE_45122_length_174_cov_1.224000_g44666_i0 PRJNA599026 45122 174 1.224 2.12976 Microvirus sp. 2202559 Viruses Viruses 87 4.36e-19   NR QJB20698.1 2202559 g44666 i0 87.5 0.96551724137931 56 7 96.6 0 172 5 134 189 QJB20698.1 MAG: DNA pilot protein [Microvirus sp.] diamond 168 87 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
28735396 28735396 PRJNA599026_S_NODE_13627_length_271_cov_1.180180_g13171_i0 PRJNA599026 13627 271 1.18018 3.1982878 Viruses 10239 Viruses Viruses 106 1.3299999999999999e-24   NR QJB19398.1 2202559 g13171 i0 86.8 2.38007380073801 53 7 58.7 0 268 110 473 525 QJB19398.1 MAG: major capsid protein [Microvirus sp.] diamond 645 107 0.990654205607477 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus 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);;