RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA546018 · 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
27962316 27962316 PRJNA546018_S_NODE_42385_length_236_cov_1.291429_g42060_i0 PRJNA546018 42385 236 1.291429 3.04777244 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 112 1.03e-26   NR CAI9858973.1 3048756 g42060 i0 69.9 0.927966101694915 73 22 92.8 0 219 1 136 208 CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] diamond 219 112 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
29193901 29193901 PRJNA546018_S_NODE_29349_length_290_cov_4.524017_g29024_i0 PRJNA546018 29349 290 4.524017 13.1196493 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 153 3.989999999999999e-41   NR CAI9858974.1 3048756 g29024 i0 76.1 0.910344827586207 88 21 91 0 23 286 516 603 CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] diamond 264 153 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
31025884 31025884 PRJNA546018_S_NODE_57795_length_201_cov_4.078571_g57470_i0 PRJNA546018 57795 201 4.078571 8.19792771 Totiviridae sp. 1955172 Viruses Viruses 60.5 1.18e-8   NR WAK77569.1 1955172 g57470 i0 61.4 0.656716417910448 44 17 65.7 0 56 187 1 44 WAK77569.1 MAG: capsid protein [Totiviridae sp.] diamond 132 60.5 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
32480946 32480946 PRJNA546018_S_NODE_6139_length_730_cov_8.167414_g5865_i0 PRJNA546018 6139 730 8.167414 59.6221222 Panax cryptic virus 4 2809267 Viruses Viruses 264 2.7e-82   NR QRG29207.1 2809267 g5865 i0 78.2 0.698630136986301 170 37 69.9 0 25 534 321 490 QRG29207.1 putative CP [Panax cryptic virus 4] diamond 510 264 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Panax cryptic virus 4

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