RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA784979 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
30631479 30631479 PRJNA784979_S_NODE_6793_length_193_cov_1.159722_g6751_i0 PRJNA784979 6793 193 1.159722 2.23826346 Pseudomonadati 3379134 Bacteria Bacteria 64.7 3.28e-10   NR PYM11754.1 2026799 g6751 i0 48.4 7.72538860103627 62 32 96.4 0 192 7 181 242 PYM11754.1 MAG: replicative DNA helicase, partial [Verrucomicrobiota bacterium] diamond 1491 64.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31570837 31570837 PRJNA784979_S_NODE_12856_length_162_cov_0.902655_g12814_i0 PRJNA784979 12856 162 0.902655 1.4623011 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 57.8 6.33e-8   NR MEW6303779.1 2026799 g12814 i0 51.9 1 54 25 100 1 162 1 310 362 MEW6303779.1 SNF2-related protein [Verrucomicrobiota bacterium] diamond 162 57.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32298638 32298638 PRJNA784979_S_NODE_12319_length_163_cov_0.894737_g12277_i0 PRJNA784979 12319 163 0.894737 1.45842131 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 50.1 3.28e-5   NR MEO5720484.1 2201154 g12277 i0 46.2 2.83435582822086 52 26 92 1 8 157 10 61 MEO5720484.1 class I SAM-dependent methyltransferase [Chthoniobacterales bacterium] diamond 462 50.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
32520016 32520016 PRJNA784979_S_NODE_12739_length_162_cov_1.097345_g12697_i0 PRJNA784979 12739 162 1.097345 1.7776989 Nibricoccus aquaticus 2576891 Bacteria Bacteria 80.5 1.03e-16   NR WP_096055814.1 2576891 g12697 i0 71.7 0.981481481481482 53 12 98.1 1 159 1 25 74 WP_096055814.1 hypothetical protein [Nibricoccus aquaticus] diamond 159 80.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Nibricoccus Nibricoccus aquaticus

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