RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB14803" 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 · 8 ✖

bioproject 1

  • PRJEB14803 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
21450 21450 PRJEB14803_P_NODE_21341_length_248_cov_1.502347_g20875_i0 PRJEB14803 21341 248 1.502347 3.72582056 root 1 Root_unresolved Root_unresolved 66.2 1.77e-10   NR WP_377074857.1 926360 g20875 i0 45.8 5.37096774193548 72 37 85.9 2 248 36 107 177 WP_377074857.1 carotenoid oxygenase family protein, partial [Natronoarchaeum mannanilyticum] diamond 1332 66.2 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronoarchaeaceae Natronoarchaeum Natronoarchaeum mannanilyticum
26716154 26716154 PRJEB14803_P_NODE_44681_length_155_cov_1.650000_g44215_i0 PRJEB14803 44681 155 1.65 2.5575 Candidatus Methanoperedens sp. 2032688 Archaea Archaea 51.6 8.28e-6   NR HWR97478.1 2032688 g44215 i0 51 1.89677419354839 49 24 94.8 0 151 5 339 387 HWR97478.1 NAD-dependent malic enzyme [Candidatus Methanoperedens sp.] diamond 294 51.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae Candidatus Methanoperedens Candidatus Methanoperedens sp.
27064668 27064668 PRJEB14803_P_NODE_21922_length_243_cov_2.418269_g21456_i0 PRJEB14803 21922 243 2.418269 5.87639367 Methanoculleus oceani 2184756 Archaea Archaea 42.4 0.0493   NR WP_250986302.1 2184756 g21456 i0 36.4 0.679012345679012 55 35 67.9 0 5 169 229 283 WP_250986302.1 cytosine permease [Methanoculleus oceani] diamond 165 42.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanoculleus Methanoculleus oceani
27190989 27190989 PRJEB14803_P_NODE_10742_length_389_cov_3.056497_g10277_i0 PRJEB14803 10742 389 3.056497 11.88977333 Halobellus rarus 1126237 Archaea Archaea 49.3 7.72e-4   NR WP_256419884.1 1126237 g10277 i0 40.5 0.609254498714653 79 46 60.2 1 102 335 214 292 WP_256419884.1 transcription initiation factor IIB [Halobellus rarus] diamond 237 49.3 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halobellus Halobellus rarus
29457979 29457979 PRJEB14803_P_NODE_22210_length_241_cov_2.058252_g21744_i0 PRJEB14803 22210 241 2.058252 4.96038732 root 1 Root_unresolved Root_unresolved 41.6 0.0459   NR WP_159902310.1 1198300 g21744 i0 31.2 1.70539419087137 77 50 92.1 1 236 15 32 108 WP_159902310.1 universal stress protein [Salinirussus salinus] diamond 411 41.6 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloarculaceae Salinirussus Salinirussus salinus
31233579 31233579 PRJEB14803_P_NODE_27175_length_211_cov_1.346591_g26709_i0 PRJEB14803 27175 211 1.346591 2.84130701 Methanogenium sp. 2196 Archaea Archaea 43.1 0.0129   NR MFA5397836.1 2196 g26709 i0 37.5 1.50710900473934 48 30 68.2 0 209 66 91 138 MFA5397836.1 HAD domain-containing protein [Methanogenium sp.] diamond 318 43.1 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanomicrobiaceae Methanogenium Methanogenium sp.
31613361 31613361 PRJEB14803_P_NODE_8416_length_455_cov_2.264286_g7956_i0 PRJEB14803 8416 455 2.264286 10.3025013 Halospeciosus flavus 3032283 Archaea Archaea 45.8 0.0242   NR WP_382218444.1 3032283 g7956 i0 30.9 2.67032967032967 81 56 53.4 0 267 25 292 372 WP_382218444.1 PQQ-binding-like beta-propeller repeat protein [Halospeciosus flavus] diamond 1215 45.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halospeciosus Halospeciosus flavus
31866176 31866176 PRJEB14803_P_NODE_18577_length_272_cov_1.556962_g18111_i0 PRJEB14803 18577 272 1.556962 4.23493664 Halosegnis rubeus 2212850 Archaea Archaea 53.9 6.34e-6   NR WP_152120952.1 2212850 g18111 i0 36.6 4.19117647058824 71 44 77.2 1 218 9 654 724 WP_152120952.1 PAS domain S-box protein [Halosegnis rubeus] diamond 1140 53.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Natronomonadaceae Halosegnis Halosegnis rubeus

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