RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA994052" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA994052 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
976716 976716 PRJNA994052_P_NODE_66321_length_217_cov_33.597222_g65065_i0 PRJNA994052 66321 217 33.597222 72.90597174 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 148 2.38e-31   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g65065 i0 94.737 0.898617511520737 95 5 90 0 118 212 2099918 2099824 Treponema sp. Marseille-Q4132 chromosome blastn 195 148 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
6079981 6079981 PRJNA994052_P_NODE_74305_length_207_cov_34.985075_g73049_i0 PRJNA994052 74305 207 34.985075 72.41910525 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 148 2.2499999999999993e-31   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g73049 i0 94.737 0.898550724637681 95 5 90 0 6 100 2099824 2099918 Treponema sp. Marseille-Q4132 chromosome blastn 186 148 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132
7354267 7354267 PRJNA994052_P_NODE_51246_length_239_cov_30.626506_g49991_i0 PRJNA994052 51246 239 30.626506 73.19734934 Borrelia hermsii 140 Bacteria Bacteria 54.7 0.006   NTclustered gi|576091739|gb|CP005706.1| 1313295 g49991 i0 100 0.121338912133891 29 0 12 0 111 139 7632 7604 Borrelia hermsii YBT, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia hermsii
7354317 7354317 PRJNA994052_P_NODE_55586_length_232_cov_90.044025_g54331_i0 PRJNA994052 55586 232 90.044025 208.902138 Treponema parvum 138851 Bacteria Bacteria 198 2.52e-46   NTclustered gi|2023447176|gb|CP054142.1| 138851 g54331 i0 82.278 56.5301724137931 237 34 99 7 2 232 452739 452505 Treponema parvum strain ATCC 700770 chromosome, complete genome blastn 13115 198 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema parvum
12455867 12455867 PRJNA994052_P_NODE_64070_length_220_cov_29.877551_g62814_i0 PRJNA994052 64070 220 29.877551 65.7306122 Spirochaetia bacterium 2053615 Bacteria Bacteria 54.7 0.005   NTclustered gi|2621706436|emb|OY764216.1| 2053615 g62814 i0 100 0.131818181818182 29 0 13 0 143 171 187342 187370 MAG: Spirochaetia bacterium isolate 151cca69-ec02-4520-8068-0d6d6324a753 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
23929341 23929341 PRJNA994052_P_NODE_76819_length_204_cov_35.328244_g75562_i0 PRJNA994052 76819 204 35.328244 72.06961776 Treponema sp. Marseille-Q4132 2766701 Bacteria Bacteria 148 2.21e-31   NTclustered gi|1897717435|gb|CP060591.1| 2766701 g75562 i0 94.737 0.897058823529412 95 5 90 0 6 100 2099824 2099918 Treponema sp. Marseille-Q4132 chromosome blastn 183 148 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. Marseille-Q4132

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