RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1253698", 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

  • PRJNA1253698 · 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
12531317 12531317 PRJNA1253698_S_NODE_14170_length_186_cov_2.175182_g13804_i0 PRJNA1253698 14170 186 2.175182 4.04583852 Treponema 157 Bacteria Bacteria 337 3.9199999999999994e-88   NTclustered gi|1996291085|gb|CP027017.1| 58231 g13804 i0 99.459 195.489247311828 185 1 99 0 2 186 1014812 1014628 Treponema medium strain T19 chromosome, complete genome blastn 36361 337 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
17630439 17630439 PRJNA1253698_S_NODE_16234_length_176_cov_1.070866_g15868_i0 PRJNA1253698 16234 176 1.070866 1.88472416 Treponema 157 Bacteria Bacteria 303 3.71e-78   NTclustered gi|2265193197|gb|CP058347.1| 158 g15868 i0 99.401 185.806818181818 167 1 95 0 3 169 1662164 1662330 Treponema denticola strain OKA3 chromosome, complete genome blastn 32702 305 0.99344262295082 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
20761246 20761246 PRJNA1253698_S_NODE_23137_length_162_cov_1.353982_g22771_i0 PRJNA1253698 23137 162 1.353982 2.19345084 Treponema sp. OMZ 803 120682 Bacteria Bacteria 294 2.03e-75   NTclustered gi|2265127813|gb|CP051195.1| 120682 g22771 i0 99.383 174.851851851852 162 1 100 0 1 162 1962090 1962251 Treponema sp. OMZ 803 strain BF2M chromosome, complete genome blastn 28326 294 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 803
23311843 23311843 PRJNA1253698_S_NODE_13139_length_193_cov_0.965278_g12773_i0 PRJNA1253698 13139 193 0.965278 1.86298654 Borreliella garinii 29519 Bacteria Bacteria 69.4 1.65e-7   NTclustered gi|2592017114|gb|CP117894.1| 29519 g12773 i0 97.5 0.559585492227979 40 1 21 0 143 182 868502 868463 Borreliella garinii strain 17-54Z3 chromosome blastn 108 69.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella garinii

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