RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA635874" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA635874 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 0

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
26764439 26764439 PRJNA635874_P_NODE_46481_length_251_cov_0.865169_g46334_i0 PRJNA635874 46481 251 0.865169 2.17157419 Leptospira borgpetersenii 174 Bacteria Bacteria 46.6 4.56e-4   NR WP_228003977.1 174 g46334 i0 54.1 0.442231075697211 37 17 44.2 0 35 145 8 44 WP_228003977.1 hypothetical protein, partial [Leptospira borgpetersenii] diamond 111 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira borgpetersenii
27491833 27491833 PRJNA635874_P_NODE_43763_length_258_cov_1.243243_g43616_i0 PRJNA635874 43763 258 1.243243 3.20756694 Brachyspira hyodysenteriae 159 Bacteria Bacteria 46.6 2.72e-4   NR WP_085169531.1 159 g43616 i0 60 3.65116279069767 35 14 40.7 0 123 227 48 82 WP_085169531.1 hypothetical protein [Brachyspira hyodysenteriae] diamond 942 46.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira hyodysenteriae
30049172 30049172 PRJNA635874_P_NODE_17391_length_372_cov_0.785953_g17244_i0 PRJNA635874 17391 372 0.785953 2.92374516 Leptospira interrogans 173 Bacteria Bacteria 56.6 7.65e-8   NR WP_181743529.1 173 g17244 i0 45.5 0.532258064516129 66 35 53.2 1 199 2 1 65 WP_181743529.1 hypothetical protein [Leptospira interrogans] diamond 198 56.6 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans

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