RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB50332" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB50332 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27563674 27563674 PRJEB50332_P_NODE_9164_length_229_cov_1.541667_g9082_i0 PRJEB50332 9164 229 1.541667 3.53041743 Pseudomonadati 3379134 Bacteria Bacteria 53.5 3.6e-6   NR WP_002703797.1 165 g9082 i0 42.1 5.63318777292576 76 39 99.6 2 1 228 113 183 WP_002703797.1 CAP domain-containing protein [Treponema saccharophilum] diamond 1290 53.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema saccharophilum
28226724 28226724 PRJEB50332_P_NODE_10986_length_219_cov_1.234177_g10904_i0 PRJEB50332 10986 219 1.234177 2.70284763 Leptospira 171 Bacteria Bacteria 50.8 3.82e-5   NR WP_025176879.1 173 g10904 i0 41.2 8.35616438356164 68 36 93.2 1 1 204 269 332 WP_025176879.1 sodium/proton-translocating pyrophosphatase, partial [Leptospira interrogans] diamond 1830 50.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira interrogans
30854979 30854979 PRJEB50332_P_NODE_234_length_1036_cov_3.299487_g193_i0 PRJEB50332 234 1036 3.299487 34.18268532 Treponema sp. 166 Bacteria Bacteria 69.7 1.49e-9   NR MEE0352004.1 166 g193 i0 36.7 0.457528957528958 158 90 45.8 6 619 146 91 238 MEE0352004.1 CAP domain-containing protein [Treponema sp.] diamond 474 69.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31329061 31329061 PRJEB50332_P_NODE_4796_length_277_cov_1.898148_g4714_i0 PRJEB50332 4796 277 1.898148 5.25786996 Spirochaetes bacterium GWB1_59_5 1802176 Bacteria Bacteria 44.7 0.00841   NR OHD18884.1 1802176 g4714 i0 38.7 1.0072202166065 93 47 89.9 2 29 277 14 106 OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5] diamond 279 44.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWB1_59_5
31834977 31834977 PRJEB50332_P_NODE_12477_length_211_cov_1.300000_g12395_i0 PRJEB50332 12477 211 1.3 2.743 Leptospiraceae bacterium 2026757 Bacteria Bacteria 63.5 9.73e-10   NR MCB1141982.1 2026757 g12395 i0 38.6 0.995260663507109 70 43 99.5 0 211 2 197 266 MCB1141982.1 zinc-binding dehydrogenase [Leptospiraceae bacterium] diamond 210 63.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
32271540 32271540 PRJEB50332_P_NODE_458_length_782_cov_1.420250_g390_i0 PRJEB50332 458 782 1.42025 11.106355 Pseudomonadati 3379134 Bacteria Bacteria 76.6 3.67e-12   NR MBP7584680.1 2202144 g390 i0 38 2.60485933503836 163 94 62.1 4 74 559 144 300 MBP7584680.1 CAP domain-containing protein [Spirochaetota bacterium] diamond 2037 76.6 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota 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);;