RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA562549" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA562549 · 3 ✖

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
26952389 26952389 PRJNA562549_P_NODE_11782_length_334_cov_1.344322_g11549_i0 PRJNA562549 11782 334 1.344322 4.49003548 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 110 1.81e-26   NR RYD71398.1 2026800 g11549 i0 56.6 0.889221556886228 99 42 88 1 299 6 229 327 RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] diamond 297 110 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31216177 31216177 PRJNA562549_P_NODE_26355_length_229_cov_1.654762_g26122_i0 PRJNA562549 26355 229 1.654762 3.78940498 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 124 1.5799999999999999e-32   NR RYD65414.1 2026800 g26122 i0 83.8 0.96943231441048 74 12 96.9 0 225 4 99 172 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 222 124 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31690974 31690974 PRJNA562549_P_NODE_20217_length_259_cov_1.227273_g19984_i0 PRJNA562549 20217 259 1.227273 3.17863707 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.4 0.045   NR MEI6341235.1 2026799 g19984 i0 44 0.579150579150579 50 26 55.6 1 103 246 109 158 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 150 42.4 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);;