RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA685607" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA685607 · 4 ✖

analysis 1

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
29513566 29513566 PRJNA685607_P_NODE_56290_length_266_cov_1.383420_g55931_i0 PRJNA685607 56290 266 1.38342 3.6798972 Rectinemataceae bacterium 3064674 Bacteria Bacteria 166 1.3699999999999998e-47   NR HUW40862.1 3064674 g55931 i0 90.8 2.94360902255639 87 8 98.1 0 264 4 295 381 HUW40862.1 zinc-binding dehydrogenase [Rectinemataceae bacterium] diamond 783 166 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
29892881 29892881 PRJNA685607_P_NODE_90451_length_243_cov_0.905882_g90092_i0 PRJNA685607 90451 243 0.905882 2.20129326 Leptospiraceae bacterium 2026757 Bacteria Bacteria 67.4 7.49e-11   NR HMV81380.1 2026757 g90092 i0 41.5 2.02469135802469 82 46 98.8 1 3 242 500 581 HMV81380.1 adenylate/guanylate cyclase domain-containing protein [Leptospiraceae bacterium] diamond 492 67.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31219325 31219325 PRJNA685607_P_NODE_70155_length_249_cov_1.403409_g69796_i0 PRJNA685607 70155 249 1.403409 3.49448841 Leptospiraceae bacterium 2026757 Bacteria Bacteria 57.4 2.79e-7   NR MBP9889803.1 2026757 g69796 i0 41.8 0.951807228915663 79 45 94 1 235 2 1154 1232 MBP9889803.1 hypothetical protein [Leptospiraceae bacterium] diamond 237 57.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31725666 31725666 PRJNA685607_P_NODE_96397_length_241_cov_0.916667_g96038_i0 PRJNA685607 96397 241 0.916667 2.20916747 Sphaerochaeta sp. 1972642 Bacteria Bacteria 89 1.04e-19   NR MDD4572593.1 1972642 g96038 i0 76 0.622406639004149 50 12 62.2 0 92 241 1 50 MDD4572593.1 DUF3560 domain-containing protein [Sphaerochaeta sp.] diamond 150 89 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.

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