RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA390533" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA390533 · 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
409851 409851 PRJNA390533_P_NODE_4621_length_891_cov_5.515258_g4017_i0 PRJNA390533 4621 891 5.515258 49.14094878 Halovalidus salilacus 3075124 Archaea Archaea 54.7 0.025   NTclustered gi|2581323319|gb|CP134700.1| 3075124 g4017 i0 100 0.0325476992143659 29 0 3 0 385 413 3648312 3648340 Halovalidus salilacus strain CCL63 chromosome, complete genome blastn 29 54.7 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natrialbaceae Halovalidus Halovalidus salilacus
10613469 10613469 PRJNA390533_P_NODE_26109_length_306_cov_2.101124_g25082_i0 PRJNA390533 26109 306 2.101124 6.42943944 Halomicrobium sp. HM KBTZ05 3242663 Archaea Archaea 84.2 1.01e-11   NTclustered gi|2794134197|gb|CP168057.1| 3242663 g25082 i0 85.185 4.46078431372549 81 12 26 0 1 81 792059 791979 Halomicrobium sp. HM KBTZ05 chromosome, complete genome blastn 1365 84.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halomicrobium Halomicrobium sp. HM KBTZ05
14438655 14438655 PRJNA390533_P_NODE_39612_length_182_cov_1.972028_g38585_i0 PRJNA390533 39612 182 1.972028 3.58909096 halophilic archaeon DL31 756883 Archaea Archaea 71.3 4.27e-8   NTclustered gi|344319636|gb|CP002988.1| 756883 g38585 i0 97.561 0.725274725274725 41 1 23 0 54 94 596487 596527 Halophilic archaeon DL31 chromosome, complete genome blastn 132 71.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon DL31

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