RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA613025 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
26763750 26763750 PRJNA613025_S_NODE_30701_length_166_cov_0.871795_g30547_i0 PRJNA613025 30701 166 0.871795 1.4471797 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 48.9 6.37e-6   NR PYJ85085.1 2026799 g30547 i0 63.2 0.686746987951807 38 14 68.7 0 153 40 28 65 PYJ85085.1 MAG: hypothetical protein DME22_10395 [Verrucomicrobiota bacterium] diamond 114 48.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27238257 27238257 PRJNA613025_S_NODE_14423_length_288_cov_10.133891_g14269_i0 PRJNA613025 14423 288 10.133891 29.18560608 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0164   NR MEI6341235.1 2026799 g14269 i0 46 0.520833333333333 50 25 50 1 110 253 109 158 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 150 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28280209 28280209 PRJNA613025_S_NODE_12346_length_330_cov_26.078292_g12192_i0 PRJNA613025 12346 330 26.078292 86.0583636 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0255   NR MEI6341235.1 2026799 g12192 i0 41.4 0.527272727272727 58 32 50.9 1 91 258 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28722549 28722549 PRJNA613025_S_NODE_11567_length_349_cov_29.053333_g11413_i0 PRJNA613025 11567 349 29.053333 101.39613217 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.7 0.0157   NR MEI6341235.1 2026799 g11413 i0 39.7 0.498567335243553 58 33 48.1 1 110 277 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 44.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28911588 28911588 PRJNA613025_S_NODE_11568_length_349_cov_25.446667_g11414_i0 PRJNA613025 11568 349 25.446667 88.80886783 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00432   NR MEI6341235.1 2026799 g11414 i0 33.7 0.713467048710602 83 46 63.6 2 56 277 84 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 249 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29196205 29196205 PRJNA613025_S_NODE_11569_length_349_cov_24.186667_g11415_i0 PRJNA613025 11569 349 24.186667 84.41146783 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00432   NR MEI6341235.1 2026799 g11415 i0 34.9 0.713467048710602 83 45 63.6 2 56 277 84 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 249 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30996591 30996591 PRJNA613025_S_NODE_11474_length_351_cov_25.784768_g11320_i0 PRJNA613025 11474 351 25.784768 90.50453568 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0308   NR MEI6341235.1 2026799 g11320 i0 41.4 0.495726495726496 58 32 47.9 1 112 279 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 43.9 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);;