RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA1136505 · 6 ✖

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
28207173 28207173 PRJNA1136505_P_NODE_139886_length_247_cov_0.885057_g133026_i0 PRJNA1136505 139886 247 0.885057 2.18609079 Spirochaetota bacterium 2202144 Bacteria Bacteria 42.7 0.0362   NR MBP7583300.1 2202144 g133026 i0 31.2 1.87044534412955 77 51 91.1 1 242 18 77 153 MBP7583300.1 glycosyltransferase family 2 protein [Spirochaetota bacterium] diamond 462 42.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28207176 28207176 PRJNA1136505_P_NODE_147926_length_244_cov_0.900585_g141066_i0 PRJNA1136505 147926 244 0.900585 2.1974274 Treponema sp. 166 Bacteria Bacteria 55.8 1.51e-7   NR MDR0448404.1 166 g141066 i0 43.4 0.651639344262295 53 28 62.7 1 239 87 64 116 MDR0448404.1 hypothetical protein [Treponema sp.] diamond 159 55.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
28460151 28460151 PRJNA1136505_P_NODE_121026_length_261_cov_2.755319_g114166_i0 PRJNA1136505 121026 261 2.755319 7.19138259 Leptospirales bacterium 2604146 Bacteria Bacteria 57.8 8.65e-8   NR MBL8018068.1 2604146 g114166 i0 40.7 1.94252873563218 91 50 100 2 261 1 2 92 MBL8018068.1 hypothetical protein [Leptospirales bacterium] diamond 507 57.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales     Leptospirales bacterium
29470015 29470015 PRJNA1136505_P_NODE_127930_length_253_cov_1.600000_g121070_i0 PRJNA1136505 127930 253 1.6 4.048 Spirochaetales bacterium 2026792 Bacteria Bacteria 124 5.359999999999999e-31   NR MFP4644909.1 2026792 g121070 i0 73.5 10.8379446640316 83 22 98.4 0 1 249 120 202 MFP4644909.1 acetate--CoA ligase [Spirochaetales bacterium] diamond 2742 124 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
30281021 30281021 PRJNA1136505_P_NODE_147612_length_244_cov_0.900585_g140752_i0 PRJNA1136505 147612 244 0.900585 2.1974274 Treponema 157 Bacteria Bacteria 109 1.41e-25   NR WP_303936532.1 158 g140752 i0 55.7 4.95491803278689 79 35 97.1 0 243 7 694 772 WP_303936532.1 FlgD immunoglobulin-like domain containing protein, partial [Treponema denticola] diamond 1209 109 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
30607376 30607376 PRJNA1136505_P_NODE_143893_length_245_cov_1.691860_g137033_i0 PRJNA1136505 143893 245 1.69186 4.145057 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 95.9 7.54e-21   NR MBE6344920.1 1898206 g137033 i0 65.6 1.48163265306122 61 21 74.7 0 2 184 290 350 MBE6344920.1 glutamine synthetase type III [Spirochaetaceae bacterium] diamond 363 95.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae 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);;