RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA832865 · 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
4652097 4652097 PRJNA832865_S_NODE_79004_length_276_cov_1.605911_g73918_i0 PRJNA832865 79004 276 1.605911 4.43231436 Treponema denticola 158 Bacteria Bacteria 58.4 5.45e-4   NTclustered gi|41821838|gb|AE017226.1| 243275 g73918 i0 94.595 0.134057971014493 37 2 13 0 127 163 933220 933184 Treponema denticola ATCC 35405, complete genome blastn 37 58.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
15256696 15256696 PRJNA832865_S_NODE_86172_length_263_cov_2.026316_g81086_i0 PRJNA832865 86172 263 2.026316 5.32921108 Borreliella 64895 Bacteria Bacteria 54.7 0.007   NTclustered gi|2918227369|gb|CP179558.1| 88916 g81086 i0 100 0.220532319391635 29 0 11 0 193 221 11118 11090 Borreliella spielmanii strain Pmew plasmid lp36, complete sequence blastn 58 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella spielmanii
16126334 16126334 PRJNA832865_S_NODE_81313_length_272_cov_1.442211_g76227_i0 PRJNA832865 81313 272 1.442211 3.92281392 Brachyspira pilosicoli 52584 Bacteria Bacteria 54.7 0.007   NTclustered gi|2514077256|gb|CP098750.1| 52584 g76227 i0 94.444 0.264705882352941 36 1 13 1 107 141 771570 771535 Brachyspira pilosicoli strain ZH1243 chromosome, complete genome blastn 72 54.7 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Brachyspirales Brachyspiraceae Brachyspira Brachyspira pilosicoli
22499201 22499201 PRJNA832865_S_NODE_16178_length_971_cov_4.163697_g12068_i0 PRJNA832865 16178 971 4.163697 40.42949787 Borreliella lanei 373540 Bacteria Bacteria 58.4 0.002   NTclustered gi|2537428790|gb|CP124054.1| 373540 g12068 i0 100 1.33264675592173 31 0 3 0 573 603 49314 49344 Borreliella lanei strain CA-28-91 chromosome, complete genome blastn 1294 58.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borreliella Borreliella lanei

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