RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA799842", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fidelibacterota · 3 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJNA799842 · 3 ✖

analysis 1

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
29305020 29305020 PRJNA799842_P_NODE_172489_length_244_cov_0.900585_g170916_i0 PRJNA799842 172489 244 0.900585 2.1974274 FCB group 1783270 Bacteria Bacteria 127 6.36e-33   NR UCH10315.1 2026760 g170916 i0 74.1 7.95491803278689 81 21 99.6 0 243 1 118 198 UCH10315.1 MAG: iron-containing alcohol dehydrogenase [Fidelibacterota bacterium] diamond 1941 127 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
30780722 30780722 PRJNA799842_P_NODE_70754_length_340_cov_1.471910_g69181_i0 PRJNA799842 70754 340 1.47191 5.004494 Fidelibacterota bacterium 2026760 Bacteria Bacteria 121 1.53e-29   NR MDC0917960.1 2026760 g69181 i0 51.4 4.87058823529412 111 53 97.9 1 335 3 362 471 MDC0917960.1 thiamine pyrophosphate-binding protein [Fidelibacterota bacterium] diamond 1656 121 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
30907300 30907300 PRJNA799842_P_NODE_171194_length_244_cov_0.900585_g169621_i0 PRJNA799842 171194 244 0.900585 2.1974274 Fidelibacterota bacterium 2026760 Bacteria Bacteria 119 6e-29   NR UCH62013.1 2026760 g169621 i0 80 0.799180327868853 65 13 79.9 0 198 4 967 1031 UCH62013.1 MAG: family 78 glycoside hydrolase catalytic domain [Fidelibacterota bacterium] diamond 195 119 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota 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);;