RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA565778" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA565778 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_kingdom 0

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
12037173 12037173 PRJNA565778_S_NODE_1550_length_725_cov_2.648256_g1443_i0 PRJNA565778 1550 725 2.648256 19.199856 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 346 9.689999999999998e-117   NR CAD8176655.1 43137 g1443 i0 67.1 0.968275862068966 234 76 96.4 1 703 5 6 239 CAD8176655.1 unnamed protein product [Paramecium octaurelia] diamond 702 346 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31881000 31881000 PRJNA565778_S_NODE_15577_length_280_cov_3.473251_g15281_i0 PRJNA565778 15577 280 3.473251 9.7251028 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 68.6 2.99e-11   NR KRX01349.1 266149 g15281 i0 50.9 5.11071428571429 53 26 56.8 0 39 197 240 292 KRX01349.1 hypothetical protein PPERSA_01252 [Pseudocohnilembus persalinus] diamond 1431 68.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32432860 32432860 PRJNA565778_S_NODE_26159_length_216_cov_2.787709_g25863_i0 PRJNA565778 26159 216 2.787709 6.02145144 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 75.1 9.98e-14   NR YP_740803.1 5905 g25863 i0 63.5 4.33333333333333 52 19 72.2 0 41 196 330 381 YP_740803.1 NADH dehydrogenase subunit 4 [Tetrahymena paravorax] diamond 936 75.5 0.994701986754967 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena paravorax

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