RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB25583" 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 · 3 ✖

bioproject 1

  • PRJEB25583 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
27917501 27917501 PRJEB25583_P_NODE_7425_length_157_cov_0.966667_g7248_i0 PRJEB25583 7425 157 0.966667 1.51766719 Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30 2801879 Bacteria Bacteria 97.8 8.0699999999999994e-23   NR MBV9385538.1 2801879 g7248 i0 84.6 2.98089171974522 52 8 99.4 0 156 1 28 79 MBV9385538.1 transposase [Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30] diamond 468 97.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae   Chroococcidiopsidaceae cyanobacterium CP_BM_ER_R8_30
29843642 29843642 PRJEB25583_P_NODE_7611_length_155_cov_1.957627_g7434_i0 PRJEB25583 7611 155 1.957627 3.03432185 Anabaena sp. UHCC 1167 Bacteria Bacteria 42 0.0209   NR WP_168536775.1 2590019 g7434 i0 36.7 1.89677419354839 49 31 94.8 0 6 152 90 138 WP_168536775.1 glycosyltransferase family 9 protein [Anabaena sp. UHCC 0253] diamond 294 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. UHCC 0253
30033292 30033292 PRJEB25583_P_NODE_2691_length_248_cov_2.018957_g2514_i0 PRJEB25583 2691 248 2.018957 5.00701336 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 102 3.56e-25   NR WP_009632162.1 927677 g2514 i0 89.7 0.701612903225806 58 6 70.2 0 176 3 1 58 WP_009632162.1 gamma carbonic anhydrase family protein [Synechocystis sp. PCC 7509] diamond 174 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509

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