RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Gottesmaniibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Gottesmaniibacteriota · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
9055558 9055558 PRJEB64798_P_NODE_230268_length_158_cov_11.238532_g228502_i0 PRJEB64798 230268 158 11.238532 17.75688056 Candidatus Gottesmanbacteria bacterium 2282145 Bacteria Bacteria 64.7 9.05e-12   NR MBI5620140.1 2282145 g228502 i0 58.8 1.93670886075949 51 21 96.8 0 3 155 52 102 MBI5620140.1 MGMT family protein [Candidatus Gottesmanbacteria bacterium] diamond 306 64.7 1 Bacteria Bacteria candidate phyla   Candidatus Gottesmaniibacteriota         Candidatus Gottesmanbacteria bacterium
27634106 27634106 PRJEB64798_P_NODE_149404_length_189_cov_1.092857_g147638_i0 PRJEB64798 149404 189 1.092857 2.06549973 Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_ 2282145 Bacteria Bacteria 56.2 3.6e-8   NR OGG18593.1 1798385 g147638 i0 73 0.587301587301587 37 10 58.7 0 66 176 6 42 OGG18593.1 MAG: hypothetical protein A3D05_01805 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_02_FULL_40_24] diamond 111 56.2 1 Bacteria Bacteria candidate phyla   Candidatus Gottesmaniibacteriota         Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_02_FULL_40_24
28960360 28960360 PRJEB64798_P_NODE_158988_length_184_cov_1.918519_g157222_i0 PRJEB64798 158988 184 1.918519 3.53007496 Candidatus Gottesmanbacteria bacterium 2282145 Bacteria Bacteria 80.9 4.05e-16   NR MBI3577184.1 2282145 g157222 i0 81.4 0.96195652173913 59 10 96.2 1 178 2 120 177 MBI3577184.1 hypothetical protein [Candidatus Gottesmanbacteria bacterium] diamond 177 80.9 1 Bacteria Bacteria candidate phyla   Candidatus Gottesmaniibacteriota         Candidatus Gottesmanbacteria bacterium
32436954 32436954 PRJEB64798_P_NODE_70379_length_230_cov_11.762431_g68614_i0 PRJEB64798 70379 230 11.762431 27.0535913 Candidatus Gottesmanbacteria bacterium GW2 2282145 Bacteria Bacteria 52.4 4.26e-6   NR KKU87615.1 1618445 g68614 i0 54.2 0.626086956521739 48 22 62.6 0 70 213 48 95 KKU87615.1 MAG: hypothetical protein UY16_C0022G0015 [Candidatus Gottesmanbacteria bacterium GW2011_GWA2_47_9] diamond 144 52.4 1 Bacteria Bacteria candidate phyla   Candidatus Gottesmaniibacteriota         Candidatus Gottesmanbacteria bacterium GW2011_GWA2_47_9

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