RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA631796 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
27030163 27030163 PRJNA631796_S_NODE_1662_length_456_cov_3.675949_g1495_i0 PRJNA631796 1662 456 3.675949 16.76232744 Bacteria 2 Bacteria Bacteria 45.4 0.00183   NR GHT13140.1 2053591 g1495 i0 52.9 1.09868421052632 34 16 22.4 0 452 351 9 42 GHT13140.1 hypothetical protein FACS1894170_08790 [Planctomycetales bacterium] diamond 501 45.8 0.991266375545852 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
28375700 28375700 PRJNA631796_S_NODE_41086_length_239_cov_1.533708_g40919_i0 PRJNA631796 41086 239 1.533708 3.66556212 Opitutaceae bacterium 2006848 Bacteria Bacteria 42.7 0.0346   NR MFO1449013.1 2006848 g40919 i0 30.1 0.916317991631799 73 40 82.8 2 219 22 32 100 MFO1449013.1 SWIM zinc finger family protein [Opitutaceae bacterium] diamond 219 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30744454 30744454 PRJNA631796_P_NODE_12014_length_205_cov_0.888889_g11736_i0 PRJNA631796 12014 205 0.888889 1.82222245 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42 0.043   NR MCX6908558.1 2026799 g11736 i0 52.8 0.526829268292683 36 15 49.8 1 10 111 73 108 MCX6908558.1 DUF4838 domain-containing protein [Verrucomicrobiota bacterium] diamond 108 42 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium

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