RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA752278" 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

bioproject 1

  • PRJNA752278 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3279253 3279253 PRJNA752278_P_NODE_65783_length_262_cov_1.730159_g65580_i0 PRJNA752278 65783 262 1.730159 4.53301658 Leptospira cinconiae 3235173 Bacteria Bacteria 128 3.86e-25   NTclustered gi|2777192084|gb|CP162137.1| 3235173 g65580 i0 100 0.263358778625954 69 0 26 0 1 69 2349492 2349560 Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence blastn 69 128 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira cinconiae
5830440 5830440 PRJNA752278_P_NODE_109045_length_230_cov_4.191083_g108842_i0 PRJNA752278 109045 230 4.191083 9.6394909 Treponema medium 58231 Bacteria Bacteria 331 2.3600000000000002e-86   NTclustered gi|1996291085|gb|CP027017.1| 58231 g108842 i0 92.609 21.2304347826087 230 17 100 0 1 230 1995487 1995716 Treponema medium strain T19 chromosome, complete genome blastn 4883 331 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
18578428 18578428 PRJNA752278_P_NODE_101615_length_242_cov_0.911243_g101412_i0 PRJNA752278 101615 242 0.911243 2.20520806 Treponema pedis 409322 Bacteria Bacteria 388 1.46e-103   NTclustered gi|1928027651|gb|CP061839.1| 409322 g101412 i0 97.368 81.0537190082645 228 6 94 0 15 242 831688 831915 Treponema pedis strain KS1 chromosome, complete genome blastn 19615 388 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis
24955069 24955069 PRJNA752278_P_NODE_98440_length_243_cov_1.600000_g98237_i0 PRJNA752278 98440 243 1.6 3.888 Turneriella parva 29510 Bacteria Bacteria 433 6.69e-117   NTclustered gi|390609540|gb|CP002959.1| 869212 g98237 i0 98.765 1 243 3 100 0 1 243 685598 685840 Turneriella parva DSM 21527, complete genome blastn 243 433 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella parva

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