RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1174207", 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

  • PRJNA1174207 · 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
26787440 26787440 PRJNA1174207_P_NODE_39161_length_244_cov_0.900585_g38632_i0 PRJNA1174207 39161 244 0.900585 2.1974274 Fidelibacterota bacterium 2026760 Bacteria Bacteria 76.6 3.4e-14   NR MEA3392771.1 2026760 g38632 i0 52.4 1.91803278688525 82 37 98.4 2 244 5 12 93 MEA3392771.1 tail fiber domain-containing protein [Fidelibacterota bacterium] diamond 468 76.6 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
28259712 28259712 PRJNA1174207_P_NODE_23966_length_290_cov_1.603687_g23437_i0 PRJNA1174207 23966 290 1.603687 4.6506923 FCB group 1783270 Bacteria Bacteria 44.3 0.0186   NR MEC7736898.1 2026760 g23437 i0 45.9 2.28620689655172 37 20 38.3 0 74 184 28 64 MEC7736898.1 hypothetical protein [Fidelibacterota bacterium] diamond 663 44.3 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
31810529 31810529 PRJNA1174207_P_NODE_26357_length_280_cov_1.285024_g25828_i0 PRJNA1174207 26357 280 1.285024 3.5980672 Fidelibacterota bacterium 2026760 Bacteria Bacteria 47.4 0.00126   NR MBD3275568.1 2026760 g25828 i0 36 4.73571428571429 86 49 87.9 2 258 13 77 160 MBD3275568.1 hypothetical protein [Fidelibacterota bacterium] diamond 1326 47.4 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);;