RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA694770" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA694770 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
15978199 15978199 PRJNA694770_P_NODE_79033_length_251_cov_0.865169_g78739_i0 PRJNA694770 79033 251 0.865169 2.17157419 Candidatus Gallitreponema excrementavium 2840840 Bacteria Bacteria 162 1.73e-46   NR MBO8457604.1 2840840 g78739 i0 100 0.99203187250996006 83 0 99.2 0 250 2 174 256 MBO8457604.1 cell division protein FtsZ [Candidatus Gallitreponema excrementavium] diamond 249 162 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales   Candidatus Gallitreponema Candidatus Gallitreponema excrementavium
27998776 27998776 PRJNA694770_P_NODE_65065_length_272_cov_1.170854_g64771_i0 PRJNA694770 65065 272 1.170854 3.18472288 Leptospira kmetyi 408139 Bacteria Bacteria 114 2.87e-28   NR WP_010572207.1 408139 g64771 i0 63.4 5.45955882352941 82 30 90.4 0 1 246 258 339 WP_010572207.1 uroporphyrinogen decarboxylase family protein [Leptospira kmetyi] diamond 1485 114 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira kmetyi
30777749 30777749 PRJNA694770_P_NODE_100094_length_241_cov_0.916667_g99800_i0 PRJNA694770 100094 241 0.916667 2.20916747 Candidatus Ornithospirochaeta stercorigallinarum 2840898 Bacteria Bacteria 79.7 1.64e-15   NR HIS13673.1 2840898 g99800 i0 100 7.65560165975104 41 0 51 0 123 1 1 41 HIS13673.1 WYL domain-containing transcriptional regulator [Candidatus Ornithospirochaeta stercorigallinarum] diamond 1845 79.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Candidatus Ornithospirochaeta Candidatus Ornithospirochaeta stercorigallinarum
32800591 32800591 PRJNA694770_P_NODE_90900_length_245_cov_0.895349_g90606_i0 PRJNA694770 90900 245 0.895349 2.19360505 Sphaerochaetaceae bacterium 2791017 Bacteria Bacteria 60.8 1.62e-9   NR MFA7188517.1 2791017 g90606 i0 59.2 2.4 49 20 60 0 2 148 80 128 MFA7188517.1 hypothetical protein [Sphaerochaetaceae bacterium] diamond 588 60.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Sphaerochaetaceae   Sphaerochaetaceae 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);;