RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA751877 · 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
27157183 27157183 PRJNA751877_P_NODE_29282_length_242_cov_0.911243_g29160_i0 PRJNA751877 29282 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 108 1.65e-27   NR WP_015166226.1 82654 g29160 i0 61.3 19.5371900826446 75 29 93 0 18 242 3 77 WP_015166226.1 peroxiredoxin [Pseudanabaena sp. PCC 7367] diamond 4728 109 0.990825688073395 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Thalassoporaceae Thalassoporum Thalassoporum mexicanum
29105597 29105597 PRJNA751877_P_NODE_16888_length_285_cov_1.089623_g16766_i0 PRJNA751877 16888 285 1.089623 3.10542555 Pseudanabaena sp. SR411 1980935 Bacteria Bacteria 69.7 8.29e-12   NR WP_094530082.1 1980935 g16766 i0 49.3 0.789473684210526 75 37 77.9 1 222 1 1 75 WP_094530082.1 hypothetical protein [Pseudanabaena sp. SR411] diamond 225 69.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. SR411
32329373 32329373 PRJNA751877_P_NODE_26099_length_246_cov_0.890173_g25977_i0 PRJNA751877 26099 246 0.890173 2.18982558 Cyanobacteria bacterium P01_A01_bin.37 3023248 Bacteria Bacteria 86.3 1.46e-17   NR MEM7770880.1 3023248 g25977 i0 48.8 1 82 42 100 0 246 1 71 152 MEM7770880.1 ISKra4 family transposase [Cyanobacteria bacterium P01_A01_bin.37] diamond 246 86.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.37

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