RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_phylum = "Negarnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Negarnaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA432257 · 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
26664007 26664007 PRJNA432257_S_NODE_7181_length_458_cov_64.178147_g6868_i0 PRJNA432257 7181 458 64.178147 293.93591326 Aspen mosaic-associated virus 2681381 Viruses Viruses 122 2.26e-30   NR WLF82580.1 2681381 g6868 i0 50 1.53930131004367 120 57 76.6 1 425 75 186 305 WLF82580.1 nucleoprotein [Aspen mosaic-associated virus] diamond 705 122 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Fimoviridae Emaravirus Emaravirus populi
29160271 29160271 PRJNA432257_S_NODE_4009_length_568_cov_8.638418_g3774_i0 PRJNA432257 4009 568 8.638418 49.06621424 blackberry leaf mottle-associated virus 3070201 Viruses Viruses 78.6 2.14e-13   NR QBM15141.1 3070201 g3774 i0 40.9 0.670774647887324 127 70 67.1 1 568 188 236 357 QBM15141.1 movement protein [blackberry leaf mottle-associated virus] diamond 381 78.6 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Fimoviridae Emaravirus Emaravirus rubi
29270996 29270996 PRJNA432257_S_NODE_79949_length_193_cov_1.961538_g79568_i0 PRJNA432257 79949 193 1.961538 3.78576834 Chuvivirus 2842604 Viruses Viruses 52 1.06e-5   NR YP_010839346.1 2842604 g79568 i0 46.4 1.74093264248705 56 29 87 1 184 17 454 508 YP_010839346.1 putative nucleoprotein [Wenzhou crab virus 2] diamond 336 52 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus

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