RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA577580" and tax_phylum = "Fidelibacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fidelibacterota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA577580 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
5667753 5667753 PRJNA577580_P_NODE_285_length_1408_cov_2.679401_g253_i0 PRJNA577580 285 1408 2.679401 37.72596608 Fidelibacterota bacterium 2026760 Bacteria Bacteria 344 7.769999999999998e-108   NR MBC8197018.1 2026760 g253 i0 42.9 10.1143465909091 415 213 87.8 7 60 1295 20 413 MBC8197018.1 DUF2817 domain-containing protein [Fidelibacterota bacterium] diamond 14241 344 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
30932800 30932800 PRJNA577580_P_NODE_8254_length_315_cov_2.082645_g8176_i0 PRJNA577580 8254 315 2.082645 6.56033175 Fidelibacterota bacterium 2026760 Bacteria Bacteria 46.2 0.00497   NR MBH10300.1 2026760 g8176 i0 45.8 0.914285714285714 96 51 91.4 1 311 24 39 133 MBH10300.1 hypothetical protein [Fidelibacterota bacterium] diamond 288 46.2 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
31501959 31501959 PRJNA577580_P_NODE_12816_length_259_cov_1.677419_g12738_i0 PRJNA577580 12816 259 1.677419 4.34451521 Fidelibacterota bacterium 2026760 Bacteria Bacteria 93.2 8.95e-21   NR MFC1583680.1 2026760 g12738 i0 48.8 0.996138996138996 86 43 99.6 1 258 1 81 165 MFC1583680.1 SDR family oxidoreductase [Fidelibacterota bacterium] diamond 258 93.2 1 Bacteria FCB group Pseudomonadati Fidelibacterota         Fidelibacterota bacterium
32356216 32356216 PRJNA577580_P_NODE_2079_length_629_cov_29.030576_g2002_i0 PRJNA577580 2079 629 29.030576 182.60232304 Fidelibacterota bacterium 2026760 Bacteria Bacteria 47.8 0.0177   NR MAZ61031.1 2026760 g2002 i0 33.7 0.481717011128776 101 60 48.2 3 547 245 1 94 MAZ61031.1 hypothetical protein [Fidelibacterota bacterium] diamond 303 47.8 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);;