RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA564013" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 3 ✖

bioproject 1

  • PRJNA564013 · 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
28184423 28184423 PRJNA564013_P_NODE_206766_length_300_cov_1.573222_g203915_i0 PRJNA564013 206766 300 1.573222 4.719666 Agapanthus tungrovirus 2838078 Viruses Viruses 44.3 0.0134   NR YP_010804323.1 2838078 g203915 i0 41.8 0.67 67 36 65 3 73 267 16 81 YP_010804323.1 p24 [Agapanthus tungrovirus] diamond 201 44.3 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Tungrovirus Tungrovirus agapanthi
29636721 29636721 PRJNA564013_P_NODE_55030_length_536_cov_20.690526_g52259_i0 PRJNA564013 55030 536 20.690526 110.90121936 Marsupial endogenous gammaretrovirus 2 3386030 Viruses Viruses 69.7 3.27e-10   NR DBA62711.1 3386030 g52259 i0 45.2 0.408582089552239 73 40 40.9 0 23 241 163 235 DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2] diamond 219 69.7 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Marsupial endogenous gammaretrovirus 2
29777052 29777052 PRJNA564013_P_NODE_369691_length_179_cov_10.703390_g366839_i0 PRJNA564013 369691 179 10.70339 19.1590681 Gammaretrovirus 153135 Viruses Viruses 89.7 4.39e-19   NR AAA43042.1 11772 g366839 i0 76.8 10.0893854748603 56 13 93.9 0 178 11 177 232 AAA43042.1 gag-abl-pol fusion polyprotein, partial [Feline sarcoma virus] diamond 1806 89.7 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus felleu

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