RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA358490" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 2 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA358490 · 2 ✖

analysis 1

  • diamond · 2 ✖

tax_clade 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
32414555 32414555 PRJNA358490_P_NODE_9379_length_365_cov_4.831288_g9037_i0 PRJNA358490 9379 365 4.831288 17.6342012 archaeon 1906665 Archaea Archaea 65.9 7.25e-11   NR RYY81640.1 1906665 g9037 i0 32.7 0.928767123287671 113 71 88.8 2 357 34 20 132 RYY81640.1 MAG: hypothetical protein EON63_15000 [archaeon] diamond 339 65.9 1 Archaea               archaeon
32558389 32558389 PRJNA358490_P_NODE_12539_length_234_cov_1.451282_g12195_i0 PRJNA358490 12539 234 1.451282 3.39599988 root 1 Root_unresolved Root_unresolved 54.3 1.13e-6   NR MCL4552492.1 2823144 g12195 i0 57.4 2.35897435897436 47 19 59 1 138 1 1 47 MCL4552492.1 DUF1788 domain-containing protein [Candidatus Marsarchaeota archaeon] diamond 552 54.7 0.992687385740402 Archaea   Thermoproteati Candidatus Marsarchaeota         Candidatus Marsarchaeota archaeon

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