RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA704949 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26767009 26767009 PRJNA704949_P_NODE_877601_length_282_cov_1.339056_g862267_i0 PRJNA704949 877601 282 1.339056 3.77613792 Flyfo microvirus Tbat2_98 2907284 Viruses Viruses 189 2.0899999999999995e-55   NR UIB81404.1 2907284 g862267 i0 94.7 1 94 5 100 0 282 1 125 218 UIB81404.1 major capsid protein [Flyfo microvirus Tbat2_98] diamond 282 189 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Flyfo microvirus Tbat2_98
29136335 29136335 PRJNA704949_P_NODE_798849_length_298_cov_1.879518_g783517_i0 PRJNA704949 798849 298 1.879518 5.60096364 Microvirus sp. 2202559 Viruses Viruses 192 5.29e-58   NR QRV61918.1 2202559 g783517 i0 95.7 0.926174496644295 92 4 92.6 0 278 3 67 158 QRV61918.1 replication initiator protein [Microvirus sp.] diamond 276 192 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30051719 30051719 PRJNA704949_P_NODE_921891_length_273_cov_3.102679_g906557_i0 PRJNA704949 921891 273 3.102679 8.47031367 Microvirus sp. 2202559 Viruses Viruses 85.5 1.9e-18   NR WBY54298.1 2202559 g906557 i0 55.4 1.62637362637363 74 30 78 2 43 255 108 181 WBY54298.1 putative endolysin [Microvirus sp.] diamond 444 85.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31726569 31726569 PRJNA704949_P_NODE_1838117_length_175_cov_1.238095_g1822778_i0 PRJNA704949 1838117 175 1.238095 2.16666625 Flyfo microvirus Tbat2_98 2907284 Viruses Viruses 106 3.86e-25   NR UIB81404.1 2907284 g1822778 i0 96.6 0.994285714285714 58 2 99.4 0 175 2 43 100 UIB81404.1 major capsid protein [Flyfo microvirus Tbat2_98] diamond 174 106 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Flyfo microvirus Tbat2_98
32328410 32328410 PRJNA704949_P_NODE_710819_length_319_cov_1.744444_g695490_i0 PRJNA704949 710819 319 1.744444 5.56477636 Microvirus sp. 2202559 Viruses Viruses 172 1.13e-50   NR QRV61919.1 2202559 g695490 i0 98.9 0.855799373040752 91 1 85.6 0 317 45 45 135 QRV61919.1 DNA pilot protein [Microvirus sp.] diamond 273 172 1 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);;