RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 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
26635850 26635850 PRJNA561212_P_NODE_25501_length_243_cov_0.917647_g25290_i0 PRJNA561212 25501 243 0.917647 2.22988221 Sanya narna-like virus 1 2970204 Viruses Viruses 69.7 1.16e-11   NR UUW20996.1 2970204 g25290 i0 47.9 0.901234567901235 73 37 90.1 1 18 236 480 551 UUW20996.1 MAG: RNA-dependent RNA polymerase [Sanya narna-like virus 1] diamond 219 69.7 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Sanya narna-like virus 1
27995162 27995162 PRJNA561212_P_NODE_4405_length_528_cov_1.369231_g4196_i0 PRJNA561212 4405 528 1.369231 7.22953968 Sclerotinia sclerotiorum narnavirus 1 2822897 Viruses Viruses 63.5 1.46e-8   NR QZE12035.1 2822897 g4196 i0 33.6 0.744318181818182 131 80 73.3 3 108 494 35 160 QZE12035.1 MAG: hypothetical protein [Sclerotinia sclerotiorum narnavirus 1] diamond 393 63.5 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Sclerotinia sclerotiorum narnavirus 1
28956444 28956444 PRJNA561212_P_NODE_9148_length_364_cov_0.951890_g8937_i0 PRJNA561212 9148 364 0.95189 3.4648796 Viruses 10239 Viruses Viruses 72.8 1.7e-12   NR WPR17273.1 3066908 g8937 i0 36.1 5.83516483516483 119 74 97.3 2 9 362 121 238 WPR17273.1 MAG: RNA-dependent RNA polymerase, partial [Dracophyllum associated narna-like virus 70] diamond 2124 72.8 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Dracophyllum associated narna-like virus 70

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