RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA986547" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA986547 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
5100533 5100533 PRJNA986547_P_NODE_2344_length_318_cov_1.195918_g2262_i0 PRJNA986547 2344 318 1.195918 3.80301924 Treponema 157 Bacteria Bacteria 538 1.8799999999999993e-148   NTclustered gi|2277007739|gb|CP038800.1| 158 g2262 i0 97.476 184.754716981132 317 5 99 2 1 317 1102112 1101799 Treponema denticola strain ATCC 700768 chromosome, complete genome blastn 58752 538 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
20398634 20398634 PRJNA986547_P_NODE_3836_length_293_cov_1.136364_g3754_i0 PRJNA986547 3836 293 1.136364 3.32954652 Treponema 157 Bacteria Bacteria 514 2.88e-141   NTclustered gi|1996296230|gb|CP031393.1| 58231 g3754 i0 98.299 150.709897610922 294 4 100 1 1 293 1014100 1014393 Treponema medium strain ATCC 700293 chromosome, complete genome blastn 44158 514 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
20398641 20398641 PRJNA986547_P_NODE_4836_length_281_cov_1.480769_g4754_i0 PRJNA986547 4836 281 1.480769 4.16096089 Treponema 157 Bacteria Bacteria 375 1.3499999999999995e-99   NTclustered gi|1928027651|gb|CP061839.1| 409322 g4754 i0 91.103 189.996441281139 281 20 99 4 2 280 390338 390061 Treponema pedis strain KS1 chromosome, complete genome blastn 53389 375 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema pedis

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