RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 4 ✖

bioproject 1

  • PRJNA1200128 · 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
27420499 27420499 PRJNA1200128_S_NODE_11763_length_240_cov_1.852792_g11654_i0 PRJNA1200128 11763 240 1.852792 4.4467008 Nostoc sp. XA 1180 Bacteria Bacteria 45.4 0.00399   NR WP_229558049.1 2780407 g11654 i0 51.5 1.175 33 16 41.3 0 80 178 62 94 WP_229558049.1 DUF3854 domain-containing protein [Nostoc sp. XA010] diamond 282 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. XA010
29535672 29535672 PRJNA1200128_S_NODE_8130_length_270_cov_1.096916_g8021_i0 PRJNA1200128 8130 270 1.096916 2.9616732 Pseudanabaenaceae cyanobacterium bins.39 2971805 Bacteria Bacteria 44.3 0.0146   NR MDX2256354.1 2971805 g8021 i0 34.5 0.966666666666667 87 47 85.6 3 30 260 167 253 MDX2256354.1 hypothetical protein [Pseudanabaenaceae cyanobacterium bins.39] diamond 261 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium bins.39
30799136 30799136 PRJNA1200128_S_NODE_30294_length_178_cov_1.533333_g30185_i0 PRJNA1200128 30294 178 1.533333 2.72933274 Crocosphaera sp. 2729996 Bacteria Bacteria 43.1 0.0113   NR MDJ0660714.1 2729996 g30185 i0 54.1 0.623595505617977 37 17 62.4 0 116 6 695 731 MDJ0660714.1 HEAT repeat domain-containing protein [Crocosphaera sp.] diamond 111 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera sp.
32444069 32444069 PRJNA1200128_S_NODE_8859_length_263_cov_1.386364_g8750_i0 PRJNA1200128 8859 263 1.386364 3.64613732 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 43.5 0.0234   NR MEZ0369900.1 2762020 g8750 i0 32 0.855513307984791 75 49 83.3 1 28 246 23 97 MEZ0369900.1 lysostaphin resistance A-like protein [Candidatus Sericytochromatia bacterium] diamond 225 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia 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);;