RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA796753 · 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
3768326 3768326 PRJNA796753_P_NODE_10623_length_426_cov_1.025496_g10311_i0 PRJNA796753 10623 426 1.025496 4.36861296 Treponema 157 Bacteria Bacteria 771 0   NTclustered gi|1807378492|gb|CP048020.1| 69710 g10311 i0 99.296 196.544600938967 426 3 100 0 1 426 2739055 2739480 Treponema vincentii strain OMZ 804 chromosome, complete genome blastn 83728 771 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema vincentii
4609186 4609186 PRJNA796753_P_NODE_53564_length_241_cov_1.232143_g53252_i0 PRJNA796753 53564 241 1.232143 2.96946463 Treponema medium 58231 Bacteria Bacteria 427 3.079999999999999e-115   NTclustered gi|1996296230|gb|CP031393.1| 58231 g53252 i0 98.75 187.074688796681 240 3 99 0 2 241 1012976 1012737 Treponema medium strain ATCC 700293 chromosome, complete genome blastn 45085 427 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
8869866 8869866 PRJNA796753_P_NODE_28387_length_285_cov_1.566038_g28075_i0 PRJNA796753 28387 285 1.566038 4.4632083 Treponema 157 Bacteria Bacteria 516 7.77e-142   NTclustered gi|923140915|gb|KP101520.1| 166 g28075 i0 99.298 111.00350877193 285 2 100 0 1 285 1374 1090 Treponema sp. strain OMZ 804 16S ribosomal RNA gene, complete sequence blastn 31636 521 0.990403071017274 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
16519633 16519633 PRJNA796753_P_NODE_48113_length_245_cov_0.895349_g47801_i0 PRJNA796753 48113 245 0.895349 2.19360505 Treponema 157 Bacteria Bacteria 396 8.869999999999996e-106   NTclustered gi|1996291085|gb|CP027017.1| 58231 g47801 i0 95.951 83.0979591836735 247 4 100 4 1 245 1012117 1011875 Treponema medium strain T19 chromosome, complete genome blastn 20359 396 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema medium
17794349 17794349 PRJNA796753_P_NODE_15534_length_363_cov_1.227586_g15222_i0 PRJNA796753 15534 363 1.227586 4.45613718 Treponema 157 Bacteria Bacteria 619 7.529999999999998e-173   NTclustered gi|2265127813|gb|CP051195.1| 120682 g15222 i0 97.521 190.457300275482 363 8 100 1 1 363 1961721 1962082 Treponema sp. OMZ 803 strain BF2M chromosome, complete genome blastn 69136 625 0.9904 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp. OMZ 803

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