RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA565778" and tax_kingdom = "Sangervirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Sangervirae · 4 ✖

bioproject 1

  • PRJNA565778 · 4 ✖

analysis 1

  • blastn · 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
558336 558336 PRJNA565778_S_NODE_31041_length_197_cov_3.081250_g30745_i0 PRJNA565778 31041 197 3.08125 6.0700625 Microvirus sp. 2202559 Viruses Viruses 211 2.66e-50   NTclustered gi|1832332353|gb|MT310342.1| 2202559 g30745 i0 86.458 0.974619289340102 192 26 97 0 5 196 5002 5193 MAG: Microvirus sp. isolate 1712115_391, complete genome blastn 192 211 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
6936385 6936385 PRJNA565778_S_NODE_27086_length_212_cov_3.537143_g26790_i0 PRJNA565778 27086 212 3.537143 7.49874316 Microvirus sp. 2202559 Viruses Viruses 270 4.729999999999999e-68   NTclustered gi|1832332367|gb|MT310344.1| 2202559 g26790 i0 89.623 1 212 22 100 0 1 212 5035 4824 MAG: Microvirus sp. isolate 1712115_374, complete genome blastn 212 270 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
8211545 8211545 PRJNA565778_S_NODE_767_length_921_cov_10.536199_g702_i0 PRJNA565778 767 921 10.536199 97.03839279 Microvirus sp. 2202559 Viruses Viruses 909 0   NTclustered gi|1832332360|gb|MT310343.1| 2202559 g702 i0 85.995 4.63735070575461 864 104 93 9 32 888 2198 1345 MAG: Microvirus sp. isolate 1712115_58, complete genome blastn 4271 909 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
23510628 23510628 PRJNA565778_S_NODE_2339_length_626_cov_8.714771_g702_i1 PRJNA565778 2339 626 8.714771 54.55446646 Microvirus sp. 2202559 Viruses Viruses 612 2.2699999999999993e-170   NTclustered gi|1832332353|gb|MT310342.1| 2202559 g702 i1 86.549 4.47284345047923 565 65 90 8 33 595 1642 2197 MAG: Microvirus sp. isolate 1712115_391, complete genome blastn 2800 612 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);;