RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

bioproject 1

  • PRJNA1233317 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26883094 26883094 PRJNA1233317_S_NODE_10321_length_242_cov_3.885246_g10285_i0 PRJNA1233317 10321 242 3.885246 9.40229532 Sonchus virus 1 3014457 Viruses Viruses 90.1 8.01e-19   NR DBA07051.1 3014457 g10285 i0 53.8 0.991735537190083 80 37 99.2 0 240 1 5357 5436 DBA07051.1 TPA_asm: polyprotein [Sonchus virus 1] diamond 240 90.1 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae   Sonchus virus 1
29346521 29346521 PRJNA1233317_S_NODE_3249_length_354_cov_5.108475_g3213_i0 PRJNA1233317 3249 354 5.108475 18.0840015 Gammaretrovirus murleu 3428959 Viruses Viruses 234 1.1e-72   NR 8WUS_E 11801 g3213 i0 99.2 4 118 1 100 0 1 354 205 322 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] diamond 1416 234 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
29883409 29883409 PRJNA1233317_S_NODE_8131_length_270_cov_4.559242_g8095_i0 PRJNA1233317 8131 270 4.559242 12.3099534 Moloney murine leukemia virus 11801 Viruses Viruses 179 7.9800000000000005e-50   NR NP_057933.2 11801 g8095 i0 98.9 2 90 1 100 0 270 1 1140 1229 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 540 179 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
30641325 30641325 PRJNA1233317_S_NODE_16793_length_185_cov_3.984127_g16757_i0 PRJNA1233317 16793 185 3.984127 7.37063495 Gammaretrovirus murleu 3428959 Viruses Viruses 116 7.760000000000001e-29   NR 8WUS_E 11801 g16757 i0 100 11.8054054054054 52 0 84.3 0 29 184 157 208 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] diamond 2184 116 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
31305015 31305015 PRJNA1233317_S_NODE_15735_length_193_cov_7.104478_g15699_i0 PRJNA1233317 15735 193 7.104478 13.71164254 Caudoviricetes sp. 2832643 Viruses Viruses 43.9 0.00647   NR DAT77581.1 2832643 g15699 i0 43.8 0.746113989637306 48 23 74.6 2 34 177 15 58 DAT77581.1 MAG TPA: metallophosphatase domain protein [Caudoviricetes sp.] diamond 144 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;