RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA438572 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27092307 27092307 PRJNA438572_P_NODE_12822_length_289_cov_0.879630_g12703_i0 PRJNA438572 12822 289 0.87963 2.5421307 Bacteria 2 Bacteria Bacteria 79.7 9.770000000000001e-16   NR MDD7201844.1 2026792 g12703 i0 43 1.94117647058824 93 53 96.5 0 1 279 39 131 MDD7201844.1 SIMPL domain-containing protein [Spirochaetales bacterium] diamond 561 79.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27234067 27234067 PRJNA438572_P_NODE_9763_length_327_cov_1.838583_g9644_i0 PRJNA438572 9763 327 1.838583 6.01216641 Rectinemataceae bacterium 3064674 Bacteria Bacteria 46.2 0.00508   NR MDP2816068.1 3064674 g9644 i0 37.6 0.853211009174312 93 46 81.7 3 5 271 10 94 MDP2816068.1 hypothetical protein [Rectinemataceae bacterium] diamond 279 46.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Rectinemataceae   Rectinemataceae bacterium
28402442 28402442 PRJNA438572_P_NODE_2966_length_570_cov_1.096579_g2848_i0 PRJNA438572 2966 570 1.096579 6.2505003 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 45.8 0.0468   NR MBK5201917.1 1898206 g2848 i0 49.1 0.278947368421053 53 22 27.9 1 432 274 148 195 MBK5201917.1 L-lactate dehydrogenase [Spirochaetaceae bacterium] diamond 159 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
29696582 29696582 PRJNA438572_P_NODE_20650_length_247_cov_1.810345_g20531_i0 PRJNA438572 20650 247 1.810345 4.47155215 Treponema sp. 166 Bacteria Bacteria 45.8 0.00182   NR MBD5443786.1 166 g20531 i0 54.8 1.23886639676113 31 14 37.7 0 121 29 121 151 MBD5443786.1 CAP domain-containing protein [Treponema sp.] diamond 306 45.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31972575 31972575 PRJNA438572_P_NODE_8978_length_340_cov_1.745318_g8859_i0 PRJNA438572 8978 340 1.745318 5.9340812 Leptospiraceae bacterium 2026757 Bacteria Bacteria 74.3 6.14e-14   NR HNO24933.1 2026757 g8859 i0 97.5 0.352941176470588 40 1 35.3 0 340 221 108 147 HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium] diamond 120 74.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae 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);;