RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB7799", tax_phylum = "Phixviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Phixviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB7799 · 6 ✖

analysis 1

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
12475393 12475393 PRJEB7799_P_NODE_770_length_276_cov_158842.283401_g763_i0 PRJEB7799 770 276 158842.283401 438404.70218676 Viruses 10239 Viruses Viruses 69.4 2.52e-7   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g763 i0 100 13.713768115942 37 0 13 0 1 37 2838 2802 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3785 69.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25889416 25889416 PRJEB7799p_S_NODE_3691_length_260_cov_11.222222_g3668_i0 PRJEB7799 3691 260 11.222222 29.1777772 Viruses 10239 Viruses Viruses 60.2 1.42e-4   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g3668 i0 100 13.1423076923077 32 0 12 0 1 32 2835 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3417 60.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26024957 26024957 PRJEB7799c_S_NODE_4196_length_206_cov_5.421053_g4173_i0 PRJEB7799 4196 206 5.421053 11.16736918 Viruses 10239 Viruses Viruses 52.8 0.018   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g4173 i0 100 0.271844660194175 28 0 14 0 179 206 2803 2830 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 56 52.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26161289 26161289 PRJEB7799g_S_NODE_597_length_323_cov_26.326389_g381_i0 PRJEB7799 597 323 26.326389 85.03423647 Viruses 10239 Viruses Viruses 62.1 5.04e-5   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g381 i0 100 10.6439628482972 33 0 10 0 290 322 2803 2835 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3438 62.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26297414 26297414 PRJEB7799n_S_NODE_2734_length_264_cov_25.633188_g2697_i0 PRJEB7799 2734 264 25.633188 67.67161632 Viruses 10239 Viruses Viruses 56.5 0.002   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g2697 i0 97.059 5.75378787878788 34 0 13 1 1 34 2833 2801 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 1519 56.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26569158 26569158 PRJEB7799i_S_NODE_5520_length_204_cov_2.644970_g5490_i0 PRJEB7799 5520 204 2.64497 5.3957388 Viruses 10239 Viruses Viruses 58.4 3.83e-4   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g5490 i0 100 7.42156862745098 31 0 15 0 1 31 2833 2803 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 1514 58.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae 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);;