RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA605033" 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

  • PRJNA605033 · 3 ✖

analysis 1

  • diamond · 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
24809335 24809335 PRJNA605033_P_NODE_64140_length_222_cov_4.679144_g62571_i0 PRJNA605033 64140 222 4.679144 10.38769968 Halovenus aranensis 890420 Archaea Archaea 67.8 3.8e-11   NR SDJ86709.1 890420 g62571 i0 46.6 0.986486486486487 73 30 98.6 1 220 2 271 334 SDJ86709.1 Transposase DDE domain-containing protein [Halovenus aranensis] diamond 219 67.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Halovenus Halovenus aranensis
28596069 28596069 PRJNA605033_P_NODE_109247_length_222_cov_1.807487_g107678_i0 PRJNA605033 109247 222 1.807487 4.01262114 Methanospirillum sp. 45200 Archaea Archaea 50.1 7.37e-5   NR MBP9009538.1 45200 g107678 i0 41.1 1.97297297297297 73 20 98.6 1 219 1 199 248 MBP9009538.1 DNA cytosine methyltransferase [Methanospirillum sp.] diamond 438 50.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanospirillaceae Methanospirillum Methanospirillum sp.
32229986 32229986 PRJNA605033_P_NODE_170558_length_180_cov_1.379310_g168989_i0 PRJNA605033 170558 180 1.37931 2.482758 Halobaculum sp. 1891221 Archaea Archaea 40 0.0495   NR MFB6177911.1 1891221 g168989 i0 35.8 0.883333333333333 53 28 78.3 1 177 37 49 101 MFB6177911.1 AAA family ATPase [Halobaculum sp.] diamond 159 40 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobaculum Halobaculum sp.

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