RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax_phylum = "Methanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Methanobacteriota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1156092 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
27008485 27008485 PRJNA1156092_P_NODE_32542_length_241_cov_0.916667_g32412_i0 PRJNA1156092 32542 241 0.916667 2.20916747 Halohasta salina 2961621 Archaea Archaea 45.4 0.00401   NR WP_253737137.1 2961621 g32412 i0 48.7 0.485477178423237 39 20 48.5 0 124 240 51 89 WP_253737137.1 cytochrome P450 [Halohasta salina] diamond 117 45.4 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halohasta Halohasta salina
30767020 30767020 PRJNA1156092_P_NODE_22294_length_251_cov_0.865169_g22164_i0 PRJNA1156092 22294 251 0.865169 2.17157419 Candidatus Methanoperedens sp. 2032688 Archaea Archaea 92 7.360000000000001e-21   NR HWR98909.1 2032688 g22164 i0 59.7 0.860557768924303 72 29 86.1 0 3 218 141 212 HWR98909.1 deoxynucleoside kinase [Candidatus Methanoperedens sp.] diamond 216 92 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae Candidatus Methanoperedens Candidatus Methanoperedens 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);;