RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1069776", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 5 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 5 ✖

bioproject 1

  • PRJNA1069776 · 5 ✖

analysis 1

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
26782709 26782709 PRJNA1069776_S_NODE_28501_length_201_cov_5.645570_g28187_i0 PRJNA1069776 28501 201 5.64557 11.3475957 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.7 0.00436   NR TAN36928.1 2026799 g28187 i0 43.2 0.552238805970149 37 21 55.2 0 33 143 372 408 TAN36928.1 MAG: citrate transporter [Verrucomicrobiota bacterium] diamond 111 44.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26877770 26877770 PRJNA1069776_S_NODE_28041_length_203_cov_2.400000_g27727_i0 PRJNA1069776 28041 203 2.4 4.872 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 43.9 0.00865   NR MBL9167005.1 2026801 g27727 i0 41.1 0.827586206896552 56 30 82.8 1 181 14 471 523 MBL9167005.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 168 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
27951830 27951830 PRJNA1069776_S_NODE_14105_length_271_cov_3.789474_g13791_i0 PRJNA1069776 14105 271 3.789474 10.26947454 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 42.7 0.0485   NR HXL27472.1 2201154 g13791 i0 32.8 0.675276752767528 61 39 67.5 1 10 192 43 101 HXL27472.1 NAD(P)-dependent oxidoreductase [Chthoniobacterales bacterium] diamond 183 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
28520206 28520206 PRJNA1069776_S_NODE_14827_length_266_cov_2.107623_g14513_i0 PRJNA1069776 14827 266 2.107623 5.60627718 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.1 0.0351   NR RME91193.1 2026799 g14513 i0 41.7 0.541353383458647 48 28 54.1 0 245 102 47 94 RME91193.1 MAG: hypothetical protein D6766_12205 [Verrucomicrobiota bacterium] diamond 144 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32343870 32343870 PRJNA1069776_S_NODE_34119_length_186_cov_2.888112_g33805_i0 PRJNA1069776 34119 186 2.888112 5.37188832 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 40 0.049   NR MBM3857925.1 2026799 g33805 i0 50 0.483870967741935 30 15 48.4 0 153 64 15 44 MBM3857925.1 FAD-dependent oxidoreductase [Verrucomicrobiota bacterium] diamond 90 40 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);;