RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA937226", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_phylum 1

  • Spirochaetota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA937226 · 3 ✖

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
26771803 26771803 PRJNA937226_S_NODE_4881_length_309_cov_2.488462_g4754_i0 PRJNA937226 4881 309 2.488462 7.68934758 Treponema sp. 166 Bacteria Bacteria 45.4 0.00871   NR WP_407400490.1 166 g4754 i0 31.5 1.78640776699029 92 52 86.4 3 298 32 61 144 WP_407400490.1 sodium/proline symporter PutP [Treponema sp.] diamond 552 45.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
30151113 30151113 PRJNA937226_S_NODE_9152_length_250_cov_6.228856_g9025_i0 PRJNA937226 9152 250 6.228856 15.57214 Brachyspira murdochii 84378 Bacteria Bacteria 41.2 0.0419   NR PPS21705.1 84378 g9025 i0 40 0.48 40 24 48 0 198 79 30 69 PPS21705.1 hypothetical protein DJ52_09280 [Brachyspira murdochii] diamond 120 41.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira murdochii
31763320 31763320 PRJNA937226_S_NODE_18897_length_190_cov_1.475177_g18770_i0 PRJNA937226 18897 190 1.475177 2.8028363 Treponema sp. 166 Bacteria Bacteria 42.4 0.0261   NR MCQ2592527.1 166 g18770 i0 38.5 0.821052631578947 52 32 82.1 0 10 165 65 116 MCQ2592527.1 glycosyl hydrolase 115 family protein [Treponema sp.] diamond 156 42.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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);;