RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1199330 · 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
26597413 26597413 PRJNA1199330_P_NODE_37721_length_337_cov_1.181818_g37022_i0 PRJNA1199330 37721 337 1.181818 3.98272666 Spirochaetota bacterium 2202144 Bacteria Bacteria 73.9 3.56e-13   NR TXG81208.1 2202144 g37022 i0 50 0.694362017804154 78 38 69.4 1 236 3 3 79 TXG81208.1 MAG: hypothetical protein E6R13_06675 [Spirochaetota bacterium] diamond 234 73.9 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28020260 28020260 PRJNA1199330_P_NODE_23825_length_420_cov_3.161383_g23130_i0 PRJNA1199330 23825 420 3.161383 13.2778086 Leptospiraceae bacterium 2026757 Bacteria Bacteria 55.1 1.12e-5   NR HMW07766.1 2026757 g23130 i0 54.5 0.957142857142857 44 20 31.4 0 4 135 73 116 HMW07766.1 NHL repeat-containing protein [Leptospiraceae bacterium] diamond 402 55.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
28240943 28240943 PRJNA1199330_P_NODE_60626_length_290_cov_1.437788_g59927_i0 PRJNA1199330 60626 290 1.437788 4.1695852 Leptospira semungkisensis 2484985 Bacteria Bacteria 45.4 0.00688   NR WP_167882131.1 2484985 g59927 i0 36.4 0.682758620689655 66 41 67.2 1 3 197 174 239 WP_167882131.1 NHL repeat-containing protein [Leptospira semungkisensis] diamond 198 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira semungkisensis
30198705 30198705 PRJNA1199330_P_NODE_33172_length_359_cov_2.541958_g32475_i0 PRJNA1199330 33172 359 2.541958 9.12562922 Spirochaetota bacterium 2202144 Bacteria Bacteria 61.2 4.26e-9   NR UCB45765.1 2202144 g32475 i0 45.2 1.4958217270195 73 38 60.2 2 331 116 20 91 UCB45765.1 MAG: hypothetical protein JSV25_16440 [Spirochaetota bacterium] diamond 537 61.2 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
31810963 31810963 PRJNA1199330_P_NODE_110777_length_246_cov_0.901734_g110078_i0 PRJNA1199330 110777 246 0.901734 2.21826564 Spirochaetota bacterium 2202144 Bacteria Bacteria 45.1 0.00604   NR MCK4907454.1 2202144 g110078 i0 34 0.609756097560976 50 33 61 0 153 4 371 420 MCK4907454.1 hypothetical protein [Spirochaetota bacterium] diamond 150 45.1 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
32633032 32633032 PRJNA1199330_P_NODE_63140_length_288_cov_1.306977_g62441_i0 PRJNA1199330 63140 288 1.306977 3.76409376 Leptospiraceae bacterium 2026757 Bacteria Bacteria 76.3 1.01e-13   NR MCB1176098.1 2026757 g62441 i0 50.5 0.96875 93 37 88.5 3 282 28 281 372 MCB1176098.1 NHL repeat-containing protein [Leptospiraceae bacterium] diamond 279 76.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);;