RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA599208", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Spirochaetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA599208 · 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
3692894 3692894 PRJNA599208_P_NODE_11563_length_193_cov_91.391026_g11367_i0 PRJNA599208 11563 193 91.391026 176.38468018 Treponema 157 Bacteria Bacteria 298 1.94e-76   NTclustered gi|1996291085|gb|CP027017.1| 58231 g11367 i0 98.81 89.6217616580311 168 1 87 1 27 193 1012907 1012740 Treponema medium strain T19 chromosome, complete genome blastn 17297 298 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
4969608 4969608 PRJNA599208_P_NODE_6284_length_303_cov_5.823308_g6088_i0 PRJNA599208 6284 303 5.823308 17.64462324 Treponema 157 Bacteria Bacteria 560 3.79e-155   NTclustered gi|1996291085|gb|CP027017.1| 58231 g6088 i0 100 103.993399339934 303 0 100 0 1 303 1012754 1012452 Treponema medium strain T19 chromosome, complete genome blastn 31510 560 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
13326192 13326192 PRJNA599208_P_NODE_2491_length_567_cov_20.441509_g2309_i0 PRJNA599208 2491 567 20.441509 115.90335603 Treponema medium 58231 Bacteria Bacteria 1003 0   NTclustered gi|1996291085|gb|CP027017.1| 58231 g2309 i0 98.589 194.754850088183 567 8 100 0 1 567 1015893 1016459 Treponema medium strain T19 chromosome, complete genome blastn 110426 1003 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
15169629 15169629 PRJNA599208_P_NODE_10512_length_208_cov_2.485380_g10316_i0 PRJNA599208 10512 208 2.48538 5.1695904 Treponema 157 Bacteria Bacteria 368 1.59e-97   NTclustered gi|1996291085|gb|CP027017.1| 58231 g10316 i0 98.558 182.725961538462 208 3 100 0 1 208 1015657 1015450 Treponema medium strain T19 chromosome, complete genome blastn 38007 368 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium

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