RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA560932 · 5 ✖

analysis 1

  • blastn · 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
1820553 1820553 PRJNA560932_P_NODE_64562_length_243_cov_0.905882_g64206_i0 PRJNA560932 64562 243 0.905882 2.20129326 Treponema parvum 138851 Bacteria Bacteria 283 7.14e-72   NTclustered gi|2023447176|gb|CP054142.1| 138851 g64206 i0 88.017 174.917695473251 242 25 99 4 4 243 452995 452756 Treponema parvum strain ATCC 700770 chromosome, complete genome blastn 42505 283 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema parvum
6922625 6922625 PRJNA560932_P_NODE_32706_length_317_cov_1.200820_g32350_i0 PRJNA560932 32706 317 1.20082 3.8065994 Borreliella burgdorferi 139 Bacteria Bacteria 52.8 0.03   NTclustered gi|2598246|emb|X81517.1| 139 g32350 i0 100 0.0883280757097792 28 0 9 0 265 292 176 203 B.burgdorferi (strain B31) bmpB gene blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella burgdorferi
8197575 8197575 PRJNA560932_P_NODE_34547_length_309_cov_1.305085_g34191_i0 PRJNA560932 34547 309 1.305085 4.03271265 Borrelia turcica 229155 Bacteria Bacteria 52.8 0.029   NTclustered gi|1484376061|gb|CP028884.1| 1104446 g34191 i0 100 0.0906148867313916 28 0 9 0 58 85 75837 75810 Borrelia turcica IST7 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia turcica
10748884 10748884 PRJNA560932_P_NODE_24809_length_357_cov_1.355634_g24453_i0 PRJNA560932 24809 357 1.355634 4.83961338 Brachyspira pilosicoli 52584 Bacteria Bacteria 52.8 0.034   NTclustered gi|2514086334|gb|CP098754.1| 52584 g24453 i0 94.286 0.294117647058824 35 1 10 1 119 153 2418589 2418622 Brachyspira pilosicoli strain MEI4028 chromosome, complete genome blastn 105 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira pilosicoli
12609549 12609549 PRJNA560932_P_NODE_59850_length_246_cov_0.890173_g59494_i0 PRJNA560932 59850 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 58.4 4.78e-4   NTclustered gi|1732601887|gb|CP042818.1| 162 g59494 i0 100 10.8373983739837 31 0 13 0 13 43 1844879 1844909 Treponema phagedenis strain B43.1 chromosome, complete genome blastn 2666 58.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema phagedenis

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