RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA560932" and tax_phylum = "Candidatus Joergenseniibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Joergenseniibacteriota · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA560932 · 2 ✖

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
28910360 28910360 PRJNA560932_P_NODE_41628_length_283_cov_1.114286_g41272_i0 PRJNA560932 41628 283 1.114286 3.15342938 Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_ 2268185 Bacteria Bacteria 43.5 0.00656   NR OGG40117.1 1798471 g41272 i0 32.7 0.551236749116608 52 35 55.1 0 7 162 15 66 OGG40117.1 MAG: 30S ribosomal protein S16 [Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_01_FULL_45_25b] diamond 156 43.5 1 Bacteria Bacteria candidate phyla   Candidatus Joergenseniibacteriota         Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_01_FULL_45_25b
29208967 29208967 PRJNA560932_P_NODE_9149_length_575_cov_1.679283_g8796_i0 PRJNA560932 9149 575 1.679283 9.65587725 Bacteria 2 Bacteria Bacteria 121 4.38e-29   NR OGG38819.1 1798469 g8796 i0 35.5 1.76347826086957 169 107 88.2 1 529 23 173 339 OGG38819.1 MAG: diaminopimelate decarboxylase [Candidatus Jorgensenbacteria bacterium GWC1_48_12] diamond 1014 122 0.991803278688525 Bacteria Bacteria candidate phyla   Candidatus Joergenseniibacteriota         Candidatus Jorgensenbacteria bacterium GWC1_48_12

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