RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA615175 · 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
28154362 28154362 PRJNA615175_P_NODE_20245_length_308_cov_2.553191_g20077_i0 PRJNA615175 20245 308 2.553191 7.86382828 Treponema phagedenis 162 Bacteria Bacteria 85.9 5.54e-17   NR WP_002696063.1 162 g20077 i0 57.3 7.72402597402597 82 35 79.9 0 275 30 133 214 WP_002696063.1 proline--tRNA ligase [Treponema phagedenis] diamond 2379 85.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema phagedenis
30175045 30175045 PRJNA615175_P_NODE_26652_length_259_cov_1.241935_g26484_i0 PRJNA615175 26652 259 1.241935 3.21661165 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 92 2.07e-19   NR MFA7188464.1 2791017 g26484 i0 60.2 0.961389961389961 83 33 96.1 0 9 257 680 762 MFA7188464.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 249 92 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae bacterium
31344347 31344347 PRJNA615175_P_NODE_33456_length_243_cov_1.811765_g33288_i0 PRJNA615175 33456 243 1.811765 4.40258895 Sphaerochaeta sp. 1972642 Bacteria Bacteria 62.4 4.52e-9   NR HKM07651.1 1972642 g33288 i0 65.1 1.06172839506173 43 15 53.1 0 129 1 1 43 HKM07651.1 AAA family ATPase [Sphaerochaeta sp.] diamond 258 62.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae Sphaerochaeta Sphaerochaeta sp.
31470969 31470969 PRJNA615175_P_NODE_5536_length_650_cov_5.608319_g5372_i0 PRJNA615175 5536 650 5.608319 36.4540735 Leptospiraceae bacterium 2026757 Bacteria Bacteria 112 3.13e-25   NR MBL0265350.1 2026757 g5372 i0 40.6 0.761538461538461 165 91 75.7 5 3 494 210 368 MBL0265350.1 alpha/beta hydrolase [Leptospiraceae bacterium] diamond 495 112 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
31723760 31723760 PRJNA615175_P_NODE_3577_length_821_cov_2.943850_g3429_i0 PRJNA615175 3577 821 2.94385 24.1690085 Sphaerochaeta sp. 1972642 Bacteria Bacteria 195 6.9500000000000004e-59   NR MFA6733421.1 1972642 g3429 i0 75.4 0.489646772228989 134 33 49 0 420 821 1 134 MFA6733421.1 hypothetical protein [Sphaerochaeta sp.] diamond 402 195 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);;