RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA615351", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 3 ✖

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJNA615351 · 3 ✖

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
27775660 27775660 PRJNA615351_P_NODE_75684_length_456_cov_1.762470_g61682_i0 PRJNA615351 75684 456 1.76247 8.0368632 Partitiviridae sp. 1955170 Viruses Viruses 132 1.98e-33   NR XFO98546.1 1955170 g61682 i0 54.8 2.33552631578947 124 55 80.9 1 370 2 1 124 XFO98546.1 capsid protein [Partitiviridae sp.] diamond 1065 132 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
31122802 31122802 PRJNA615351_P_NODE_81275_length_417_cov_2.196335_g67230_i0 PRJNA615351 81275 417 2.196335 9.15871695 Shallot yellow stripe virus 62059 Viruses Viruses 45.8 0.0183   NR YP_331422.1 62059 g67230 i0 45.8 0.345323741007194 48 25 33.8 1 174 314 338 385 YP_331422.1 NIb polymerase [Shallot yellow stripe virus] diamond 144 45.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus ascaloniae
31502848 31502848 PRJNA615351_P_NODE_85336_length_392_cov_1.434174_g71275_i0 PRJNA615351 85336 392 1.434174 5.62196208 Kashgar Parti tick virus 1 2972272 Viruses Viruses 141 2.83e-37   NR XHY99495.1 2972272 g71275 i0 66 0.76530612244898 100 34 76.5 0 48 347 319 418 XHY99495.1 MAG: capsid protein [Kashgar Parti tick virus 1] diamond 300 141 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Kashgar Parti tick virus 1

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