RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA896973 · 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
26707222 26707222 PRJNA896973_P_NODE_26581_length_243_cov_0.905882_g26487_i0 PRJNA896973 26581 243 0.905882 2.20129326 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 161 5.52e-46   NR HEY9757324.1 3088181 g26487 i0 98.8 0.987654320987654 80 1 98.8 0 3 242 206 285 HEY9757324.1 acyltransferase [Oculatellaceae cyanobacterium] diamond 240 161 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27181950 27181950 PRJNA896973_P_NODE_10042_length_344_cov_1.302583_g9948_i0 PRJNA896973 10042 344 1.302583 4.48088552 Prochlorococcus marinus 1219 Bacteria Bacteria 42.4 0.0118   NR WP_269611066.1 1219 g9948 i0 41 0.340116279069767 39 23 34 0 119 3 10 48 WP_269611066.1 hypothetical protein [Prochlorococcus marinus] diamond 117 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus marinus
27814080 27814080 PRJNA896973_S_NODE_2544_length_251_cov_5.865169_g2530_i0 PRJNA896973 2544 251 5.865169 14.72157419 Leptolyngbya sp. BC13 47254 Bacteria Bacteria 51.6 3.02e-5   NR WP_121970628.1 2029589 g2530 i0 74.3 0.418326693227092 35 9 41.8 0 24 128 459 493 WP_121970628.1 efflux RND transporter periplasmic adaptor subunit [Leptolyngbya sp. BC1307] diamond 105 51.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. BC1307
31572882 31572882 PRJNA896973_P_NODE_17776_length_273_cov_1.180000_g17682_i0 PRJNA896973 17776 273 1.18 3.2214 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 184 2.0999999999999998e-55   NR HEY9756780.1 3088181 g17682 i0 96.7 1 91 3 100 0 273 1 22 112 HEY9756780.1 DUF4384 domain-containing protein [Oculatellaceae cyanobacterium] diamond 273 184 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium

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