RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1160211 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
9237992 9237992 PRJNA1160211_S_NODE_249328_length_262_cov_3.708995_g248095_i0 PRJNA1160211 249328 262 3.708995 9.7175669 Leptospira stimsonii 2202203 Bacteria Bacteria 63.9 1.04e-9   NR WP_135685735.1 2202203 g248095 i0 62.2 0.83587786259542 45 17 51.5 0 241 107 228 272 WP_135685735.1 sterol desaturase family protein [Leptospira stimsonii] diamond 219 63.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira stimsonii
26838395 26838395 PRJNA1160211_S_NODE_46641_length_587_cov_3.861868_g45483_i0 PRJNA1160211 46641 587 3.861868 22.66916516 Pseudomonadati 3379134 Bacteria Bacteria 55.1 2.63e-5   NR MCL2175558.1 166 g45483 i0 61.8 1.10902896081772 34 13 17.4 0 371 472 39 72 MCL2175558.1 sel1 repeat family protein [Treponema sp.] diamond 651 55.5 0.992792792792793 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27704198 27704198 PRJNA1160211_S_NODE_61324_length_544_cov_2.611465_g60139_i0 PRJNA1160211 61324 544 2.611465 14.2063696 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 74.3 7.72e-12   NR UCF97407.1 1898206 g60139 i0 53.2 1.33455882352941 62 29 34.2 0 543 358 451 512 UCF97407.1 MAG: glycerol kinase GlpK [Spirochaetaceae bacterium] diamond 726 74.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae bacterium
28114161 28114161 PRJNA1160211_S_NODE_30925_length_647_cov_21.134146_g29828_i0 PRJNA1160211 30925 647 21.134146 136.73792462 Brevinematales bacterium 2614249 Bacteria Bacteria 43.9 0.0433   NR NPV39414.1 2614249 g29828 i0 31.3 0.384853168469861 83 56 38.5 1 223 471 3 84 NPV39414.1 YggT family protein [Brevinematales bacterium] diamond 249 43.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brevinematales     Brevinematales bacterium
28871977 28871977 PRJNA1160211_S_NODE_24168_length_683_cov_7.944262_g23119_i0 PRJNA1160211 24168 683 7.944262 54.25930946 Spirochaetia bacterium 2053615 Bacteria Bacteria 189 2.26e-58   NR MFO7729640.1 2053615 g23119 i0 95.2 0.456808199121523 104 2 45.7 2 357 668 1 101 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 312 189 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
29156461 29156461 PRJNA1160211_S_NODE_163889_length_355_cov_8.507092_g162656_i0 PRJNA1160211 163889 355 8.507092 30.2001766 Spirochaetia bacterium 2053615 Bacteria Bacteria 149 3.57e-44   NR MFO7729640.1 2053615 g162656 i0 91.7 0.709859154929578 84 6 71 1 272 21 3 85 MFO7729640.1 hypothetical protein [Spirochaetia bacterium] diamond 252 149 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
30198158 30198158 PRJNA1160211_S_NODE_143612_length_384_cov_2.408360_g142379_i0 PRJNA1160211 143612 384 2.40836 9.2481024 Spirochaetales bacterium 2026792 Bacteria Bacteria 44.3 0.0233   NR MDR2588289.1 2026792 g142379 i0 43.7 0.5546875 71 38 55.5 2 86 298 45 113 MDR2588289.1 TRAP transporter small permease [Spirochaetales bacterium] diamond 213 44.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales 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);;