RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA971676", tax_kingdom = "Pseudomonadati" 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

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA971676 · 4 ✖

analysis 1

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
21346615 21346615 PRJNA971676_P_NODE_13857_length_251_cov_0.865169_g13768_i0 PRJNA971676 13857 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 98.2 4.059999999999999e-24   NR MDA3835525.1 2026792 g13768 i0 96 2.97609561752988 50 2 59.8 0 2 151 84 133 MDA3835525.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase [Spirochaetales bacterium] diamond 747 99 0.991919191919192 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
27089293 27089293 PRJNA971676_P_NODE_13042_length_257_cov_2.418478_g12953_i0 PRJNA971676 13042 257 2.418478 6.21548846 Leptospiraceae bacterium 2026757 Bacteria Bacteria 52 2.49e-5   NR MBP7282682.1 2026757 g12953 i0 39.5 0.88715953307393 76 45 88.7 1 248 21 252 326 MBP7282682.1 hypothetical protein [Leptospiraceae bacterium] diamond 228 52 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae   Leptospiraceae bacterium
29962835 29962835 PRJNA971676_P_NODE_15991_length_249_cov_0.875000_g15902_i0 PRJNA971676 15991 249 0.875 2.17875 Spirochaetales bacterium 2026792 Bacteria Bacteria 136 1.63e-37   NR MCK4541573.1 2026792 g15902 i0 100 0.771084337349398 64 0 77.1 0 57 248 1 64 MCK4541573.1 hypothetical protein [Spirochaetales bacterium] diamond 192 136 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
32371938 32371938 PRJNA971676_P_NODE_14239_length_251_cov_0.865169_g14150_i0 PRJNA971676 14239 251 0.865169 2.17157419 Pseudomonadati 3379134 Bacteria Bacteria 95.1 2.17e-21   NR MBN1411722.1 2026792 g14150 i0 65.1 1.52988047808765 63 22 75.3 0 248 60 229 291 MBN1411722.1 hypothetical protein [Spirochaetales bacterium] diamond 384 95.1 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);;