RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA867519", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Eiseniibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Eiseniibacteriota · 3 ✖

tax_clade 1

  • Bacteria candidate phyla · 3 ✖

bioproject 1

  • PRJNA867519 · 3 ✖

analysis 1

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
27971108 27971108 PRJNA867519_P_NODE_27045_length_249_cov_0.875000_g26891_i0 PRJNA867519 27045 249 0.875 2.17875 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 47 0.00128   NR HYV28042.1 2212470 g26891 i0 48 1.83132530120482 50 23 60.2 1 232 83 400 446 HYV28042.1 tetratricopeptide repeat protein [Candidatus Eiseniibacteriota bacterium] diamond 456 47 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
28831651 28831651 PRJNA867519_P_NODE_25448_length_251_cov_0.865169_g25294_i0 PRJNA867519 25448 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 53.1 8.92e-6   NR HTL70189.1 2212470 g25294 i0 38.8 2.40239043824701 67 41 80.1 0 8 208 802 868 HTL70189.1 M1 family metallopeptidase [Candidatus Eiseniibacteriota bacterium] diamond 603 53.5 0.992523364485981 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
29360434 29360434 PRJNA867519_P_NODE_15929_length_296_cov_1.726457_g15775_i0 PRJNA867519 15929 296 1.726457 5.11031272 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 140 1.2899999999999999e-38   NR MEO5617181.1 2212470 g15775 i0 71.4 3.97297297297297 98 28 99.3 0 3 296 80 177 MEO5617181.1 indole-3-glycerol phosphate synthase TrpC [Candidatus Eiseniibacteriota bacterium] diamond 1176 140 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium

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