RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
3808160 3808160 PRJNA939369_S_NODE_80243_length_207_cov_5.052239_g79826_i0 PRJNA939369 80243 207 5.052239 10.45813473 Borrelia 138 Bacteria Bacteria 52.8 0.018   NTclustered gi|2668652688|gb|CP129313.1| 142 g79826 i0 100 0.270531400966184 28 0 14 0 40 67 11655 11682 Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence blastn 56 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia turicatae
5084354 5084354 PRJNA939369_S_NODE_20104_length_337_cov_1.507576_g19687_i0 PRJNA939369 20104 337 1.507576 5.08053112 Treponema 157 Bacteria Bacteria 333 1.01e-86   NTclustered gi|2189493055|gb|CP091738.1| 167 g19687 i0 85.152 91.3946587537092 330 43 97 6 11 337 287462 287136 MAG: Treponema succinifaciens isolate nC27_bin.114.fa chromosome blastn 30800 333 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema succinifaciens

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