RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB17675", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

  • Pseudomonadati · 5 ✖

bioproject 1

  • PRJEB17675 · 5 ✖

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
7673895 7673895 PRJEB17675_P_NODE_16347_length_198_cov_2.030675_g16043_i0 PRJEB17675 16347 198 2.030675 4.0207365 Spirochaetota bacterium 2202144 Bacteria Bacteria 117 6e-22   NTclustered gi|2649718696|emb|OZ001226.1| 2202144 g16043 i0 86.111 7.07070707070707 108 15 55 0 1 108 74480 74373 MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19 blastn 1400 117 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27823064 27823064 PRJEB17675_P_NODE_23784_length_156_cov_1.462810_g23480_i0 PRJEB17675 23784 156 1.46281 2.2819836 Treponema sp. 166 Bacteria Bacteria 60.8 1.94e-10   NR MCR4630287.1 166 g23480 i0 55.8 1 52 22 98.1 1 2 154 6 57 MCR4630287.1 co-chaperone GroES [Treponema sp.] diamond 156 60.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
27917488 27917488 PRJEB17675_P_NODE_25465_length_150_cov_1.391304_g25161_i0 PRJEB17675 25465 150 1.391304 2.086956 Spirochaetota bacterium 2202144 Bacteria Bacteria 44.7 0.00187   NR MBN1531716.1 2202144 g25161 i0 47.6 0.84 42 21 84 1 127 2 57 97 MBN1531716.1 hypothetical protein [Spirochaetota bacterium] diamond 126 44.7 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
28448123 28448123 PRJEB17675_P_NODE_10546_length_267_cov_1.551724_g10242_i0 PRJEB17675 10546 267 1.551724 4.14310308 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 65.5 1.51e-10   NR WP_029408900.1 409322 g10242 i0 45.9 5 74 37 83.1 2 45 266 122 192 WP_029408900.1 CAP domain-containing protein [Treponema pedis] diamond 1335 65.5 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
29363701 29363701 PRJEB17675_P_NODE_1469_length_805_cov_3.657143_g1275_i0 PRJEB17675 1469 805 3.657143 29.44000115 Pseudomonadati 3379134 Bacteria Bacteria 61.6 4.2e-7   NR MBR5097261.1 166 g1275 i0 32.1 3.74534161490683 165 99 61.1 6 718 227 81 233 MBR5097261.1 hypothetical protein [Treponema sp.] diamond 3015 61.6 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);;