RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA559720" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA559720 · 4 ✖

analysis 1

  • diamond · 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
15846281 15846281 PRJNA559720_P_NODE_1133_length_887_cov_1.783784_g1053_i0 PRJNA559720 1133 887 1.783784 15.82216408 Picornaviridae sp. 1530251 Viruses Viruses 352 1.52e-111   NR URG14823.1 1530251 g1053 i0 55.2 1.00450958286359 297 131 99.8 1 885 1 360 656 URG14823.1 MAG: capsid protein [Picornaviridae sp.] diamond 891 352 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
30363736 30363736 PRJNA559720_P_NODE_4132_length_511_cov_1.582192_g3998_i0 PRJNA559720 4132 511 1.582192 8.08500112 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 188 1.2e-51   NR AVM87439.1 3063761 g3998 i0 51.4 1.01565557729941 173 77 97.5 1 498 1 933 1105 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 519 188 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
30837234 30837234 PRJNA559720_P_NODE_16014_length_242_cov_0.911243_g15875_i0 PRJNA559720 16014 242 0.911243 2.20520806 Zebrafish jaw picornavirus RQ13 Viruses Viruses 102 2.7499999999999995e-23   NR YP_010796394.1 RQ13 g15875 i0 57 1.94628099173554 79 34 97.9 0 238 2 2244 2322 YP_010796394.1 polyprotein [Wenling triplecross lizardfish picornavirus] diamond 471 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Symapivirus Zebrafish jaw picornavirus
32671017 32671017 PRJNA559720_P_NODE_4300_length_502_cov_2.771562_g4163_i0 PRJNA559720 4300 502 2.771562 13.91324124 Picornaviridae sp. 1530251 Viruses Viruses 205 3.999999999999999e-58   NR URG14823.1 1530251 g4163 i0 70.5 0.872509960159363 146 43 87.3 0 1 438 729 874 URG14823.1 MAG: capsid protein [Picornaviridae sp.] diamond 438 205 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;