RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_phylum = "Duplornaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Duplornaviricota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA429937 · 2 ✖

analysis 1

  • diamond · 2 ✖

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
30977045 30977045 PRJNA429937_P_NODE_7354_length_1303_cov_7.319466_g4350_i0 PRJNA429937 7354 1303 7.319466 95.37264198 Ghabrivirales 2732540 Viruses Viruses 123 3.9e-26   NR WAK77569.1 1955172 g4350 i0 35.2 1.06600153491942 230 144 52.3 4 1257 577 351 578 WAK77569.1 MAG: capsid protein [Totiviridae sp.] diamond 1389 124 0.991935483870968 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
32193893 32193893 PRJNA429937_P_NODE_9558_length_1166_cov_5.156552_g5619_i0 PRJNA429937 9558 1166 5.156552 60.12539632 Totiviridae sp. 1955172 Viruses Viruses 311 8.13e-98   NR UHS72443.1 1955172 g5619 i0 67 0.545454545454545 212 70 54.5 0 636 1 2 213 UHS72443.1 MAG: putative RNA-dependent RNA polymerase, partial [Totiviridae sp.] diamond 636 311 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae 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);;