RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1016321 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
11638602 11638602 PRJNA1016321_P_NODE_56270_length_241_cov_0.916667_g56039_i0 PRJNA1016321 56270 241 0.916667 2.20916747 Pleurocapsa 44474 Bacteria Bacteria 131 9.97e-34   NR WP_106241728.1 2107688 g56039 i0 83.5 10.804979253112 79 13 98.3 0 2 238 53 131 WP_106241728.1 ABC transporter ATP-binding protein [Pleurocapsa sp. CCALA 161] diamond 2604 132 0.992424242424242 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. CCALA 161
26971465 26971465 PRJNA1016321_P_NODE_53742_length_244_cov_0.900585_g53511_i0 PRJNA1016321 53742 244 0.900585 2.1974274 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 164 2.48e-46   NR HEY9757364.1 3088181 g53511 i0 100 0.983606557377049 80 0 98.4 0 3 242 191 270 HEY9757364.1 PLP-dependent transferase [Oculatellaceae cyanobacterium] diamond 240 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27761729 27761729 PRJNA1016321_P_NODE_56644_length_239_cov_2.783133_g56413_i0 PRJNA1016321 56644 239 2.783133 6.65168787 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 95.9 1.26e-23   NR WP_106367560.1 2107693 g56413 i0 86.5 0.652719665271967 52 7 65.3 0 157 2 1 52 WP_106367560.1 hypothetical protein [Chlorogloea sp. CCALA 695] diamond 156 95.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
29687145 29687145 PRJNA1016321_P_NODE_55150_length_242_cov_0.911243_g54919_i0 PRJNA1016321 55150 242 0.911243 2.20520806 Pleurocapsa sp. MO_226.B13 3036786 Bacteria Bacteria 125 1.1299999999999998e-31   NR MDJ0595363.1 3036786 g54919 i0 90 0.991735537190083 80 8 99.2 0 2 241 241 320 MDJ0595363.1 alanine/glycine:cation symporter family protein [Pleurocapsa sp. MO_226.B13] diamond 240 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. MO_226.B13
31298756 31298756 PRJNA1016321_P_NODE_44195_length_263_cov_3.000000_g43964_i0 PRJNA1016321 44195 263 3 7.89 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 122 1.39e-34   NR HEY9760802.1 3088181 g43964 i0 100 0.695817490494297 61 0 69.6 0 185 3 1 61 HEY9760802.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 183 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32437929 32437929 PRJNA1016321_P_NODE_49819_length_249_cov_0.875000_g49588_i0 PRJNA1016321 49819 249 0.875 2.17875 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 164 4.399999999999998e-47   NR HEY9760500.1 3088181 g49588 i0 100 0.987951807228916 82 0 98.8 0 248 3 280 361 HEY9760500.1 hydroxymethylglutaryl-CoA reductase [Oculatellaceae cyanobacterium] diamond 246 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32713868 32713868 PRJNA1016321_P_NODE_54480_length_243_cov_0.905882_g54249_i0 PRJNA1016321 54480 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 137 1.3e-35   NR HAX79343.1 2055768 g54249 i0 83.5 4.91358024691358 79 13 97.5 0 238 2 194 272 HAX79343.1 hypothetical protein [Cyanobacteria bacterium UBA11372] diamond 1194 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11372

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