RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1047749" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 3 ✖

bioproject 1

  • PRJNA1047749 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
5277813 5277813 PRJNA1047749_P_NODE_26085_length_299_cov_7.469027_g25818_i0 PRJNA1047749 26085 299 7.469027 22.33239073 Halosimplex rarum 3396619 Archaea Archaea 139 2.07e-28   NTclustered gi|2908454640|gb|CP180412.1| 3396619 g25818 i0 84.028 2.67892976588629 144 23 48 0 13 156 1820921 1820778 Halosimplex sp. TS25 chromosome, complete genome blastn 801 139 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halosimplex Halosimplex rarum
20576121 20576121 PRJNA1047749_P_NODE_27617_length_296_cov_2.901345_g27350_i0 PRJNA1047749 27617 296 2.901345 8.5879812 Haloglomus litoreum 3034026 Archaea Archaea 56.5 0.002   NTclustered gi|2463606059|gb|CP119988.1| 3034026 g27350 i0 100 0.101351351351351 30 0 10 0 245 274 1876041 1876012 Haloglomus litoreum strain DT116 chromosome, complete genome blastn 30 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Haloglomus Haloglomus litoreum
24401067 24401067 PRJNA1047749_P_NODE_27260_length_297_cov_3.531250_g26993_i0 PRJNA1047749 27260 297 3.53125 10.4878125 Halovalidus salilacus 3075124 Archaea Archaea 54.7 0.008   NTclustered gi|2581323319|gb|CP134700.1| 3075124 g26993 i0 100 0.191919191919192 29 0 10 0 240 268 3941006 3940978 Halovalidus salilacus strain CCL63 chromosome, complete genome blastn 57 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halovalidus Halovalidus salilacus

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