RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermoproteati · 2 ✖

bioproject 1

  • PRJNA509429 · 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
28071576 28071576 PRJNA509429_P_NODE_28485_length_233_cov_5.414141_g27657_i0 PRJNA509429 28485 233 5.414141 12.61494853 root 1 Root_unresolved Root_unresolved 66.6 1.23e-10   NR MDP6303927.1 2026808 g27657 i0 48.6 1.85407725321888 72 37 92.7 0 17 232 121 192 MDP6303927.1 reverse transcriptase family protein [Candidatus Nitrosopelagicus sp.] diamond 432 67 0.994029850746269 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosopelagicus Candidatus Nitrosopelagicus sp.
31341138 31341138 PRJNA509429_P_NODE_49636_length_154_cov_8.243697_g48808_i0 PRJNA509429 49636 154 8.243697 12.69529338 Nitrososphaerota archaeon 2026795 Archaea Archaea 40 0.0197   NR TLX82244.1 2026795 g48808 i0 41.7 0.701298701298701 36 18 70.1 1 37 144 37 69 TLX82244.1 MAG: citrate (Si)-synthase, partial [Nitrososphaerota archaeon] diamond 108 40 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota 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);;