RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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

bioproject 1

  • PRJNA1120060 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
269201 269201 PRJNA1120060_P_NODE_636041_length_343_cov_1.225926_g618279_i0 PRJNA1120060 636041 343 1.225926 4.20492618 Taiwan douglas-fir deltapartitivirus 2933092 Viruses Viruses 67 3.51e-10   NR CAI5384001.1 2933092 g618279 i0 61.1 0.472303206997085 54 18 47.2 1 178 17 128 178 CAI5384001.1 RNA-dependent RNA polymerase [Taiwan douglas-fir deltapartitivirus] diamond 162 67 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Deltapartitivirus Taiwan douglas-fir deltapartitivirus
27447678 27447678 PRJNA1120060_P_NODE_1261443_length_309_cov_2.084746_g1243502_i0 PRJNA1120060 1261443 309 2.084746 6.44186514 Pinus albicaulis amalgavirus 1 2982067 Viruses Viruses 56.6 1.13e-6   NR DAZ91039.1 2982067 g1243502 i0 37.8 0.796116504854369 82 37 66 1 103 306 868 949 DAZ91039.1 TPA_asm: fusion protein [Pinus albicaulis amalgavirus 1] diamond 246 56.6 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Amalgaviridae Amalgavirus Pinus albicaulis amalgavirus 1
28773766 28773766 PRJNA1120060_P_NODE_1767007_length_282_cov_2.143541_g1748996_i0 PRJNA1120060 1767007 282 2.143541 6.04478562 Pinus patula amalgavirus 1 2058877 Viruses Viruses 120 3.21e-30   NR DAB41736.1 2058877 g1748996 i0 61.4 0.936170212765957 88 34 93.6 0 282 19 212 299 DAB41736.1 TPA_exp: ORF1p, partial [Pinus patula amalgavirus 1] diamond 264 120 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Amalgaviridae   Pinus patula amalgavirus 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);;