RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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

  • PRJNA1005695 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27350834 27350834 PRJNA1005695_P_NODE_38703_length_245_cov_0.906977_g37851_i0 PRJNA1005695 38703 245 0.906977 2.22209365 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 92.4 5.480000000000001e-21   NR MDC7127142.1 1898206 g37851 i0 46.9 0.991836734693878 81 43 99.2 0 3 245 70 150 MDC7127142.1 HAD hydrolase-like protein [Spirochaetaceae bacterium] diamond 243 92.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
30982509 30982509 PRJNA1005695_P_NODE_30754_length_269_cov_1.591837_g29902_i0 PRJNA1005695 30754 269 1.591837 4.28204153 Treponemataceae bacterium 2854022 Bacteria Bacteria 45.8 0.00401   NR MEL3908691.1 2854022 g29902 i0 58.6 0.323420074349442 29 12 32.3 0 121 35 372 400 MEL3908691.1 SPFH domain-containing protein [Treponemataceae bacterium] diamond 87 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae bacterium
32215884 32215884 PRJNA1005695_P_NODE_29558_length_275_cov_1.232673_g28706_i0 PRJNA1005695 29558 275 1.232673 3.38985075 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 44.3 0.012   NR MBL8967346.1 1898206 g28706 i0 39 0.84 77 45 81.8 1 262 38 82 158 MBL8967346.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Spirochaetaceae bacterium] diamond 231 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
32588117 32588117 PRJNA1005695_P_NODE_9739_length_498_cov_1.762353_g8888_i0 PRJNA1005695 9739 498 1.762353 8.77651794 Bacteria 2 Bacteria Bacteria 135 4.5799999999999995e-37   NR PKL26378.1 2013835 g8888 i0 45.5 4.68674698795181 156 70 93.4 5 33 497 8 149 PKL26378.1 MAG: hypothetical protein CVV47_00140 [Spirochaetae bacterium HGW-Spirochaetae-3] diamond 2334 135 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetae bacterium HGW-Spirochaetae-3

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