RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB8827 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 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
25801595 25801595 PRJEB8827b_S_NODE_5635_length_206_cov_1.309942_g5583_i0 PRJEB8827 5635 206 1.309942 2.69848052 Myxococcales bacterium 2026763 Bacteria Bacteria 116 8.47e-31   NR MSP25910.1 2026763 g5583 i0 80.7 0.830097087378641 57 11 83 0 6 176 136 192 MSP25910.1 superoxide dismutase [Myxococcales bacterium] diamond 171 116 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
32931339 32931339 PRJEB8827h_S_NODE_2465_length_222_cov_2.491979_g2446_i0 PRJEB8827 2465 222 2.491979 5.53219338 Myxococcota bacterium 2818507 Bacteria Bacteria 53.9 3.3e-6   NR MFK7930480.1 2818507 g2446 i0 72.5 1.43243243243243 40 9 54.1 1 144 25 488 525 MFK7930480.1 ATP-binding protein [Myxococcota bacterium] diamond 318 53.9 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
33025985 33025985 PRJEB8827f_S_NODE_17380_length_168_cov_2.105263_g17360_i0 PRJEB8827 17380 168 2.105263 3.53684184 Pseudomonadati 3379134 Bacteria Bacteria 85.1 4.58e-18   NR MCL5126502.1 2026735 g17360 i0 78.8 15.8035714285714 52 11 92.9 0 168 13 241 292 MCL5126502.1 acetyl-CoA C-acyltransferase [Deltaproteobacteria bacterium] diamond 2655 85.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;