RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA640143" 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

  • PRJNA640143 · 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
27143807 27143807 PRJNA640143_S_NODE_19042_length_201_cov_2.018293_g18832_i0 PRJNA640143 19042 201 2.018293 4.05676893 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 49.7 7.56e-5   NR WP_250124880.1 155894 g18832 i0 41.8 0.82089552238806 55 32 82.1 0 35 199 34 88 WP_250124880.1 restriction endonuclease subunit S [Chroococcidiopsis sp. CCMEE 29] diamond 165 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
27933865 27933865 PRJNA640143_S_NODE_5165_length_362_cov_4.067692_g4955_i0 PRJNA640143 5165 362 4.067692 14.72504504 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 72 7.16e-13   NR WP_009632138.1 927677 g4955 i0 94.7 0.314917127071823 38 2 31.5 0 116 3 1 38 WP_009632138.1 phycocyanin subunit beta [Synechocystis sp. PCC 7509] diamond 114 72 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
28344273 28344273 PRJNA640143_S_NODE_23246_length_183_cov_1.335616_g23036_i0 PRJNA640143 23246 183 1.335616 2.44417728 Xenococcaceae cyanobacterium MO_188.B32 3036640 Bacteria Bacteria 43.5 0.00211   NR MDJ0687266.1 3036640 g23036 i0 67.7 0.508196721311475 31 10 50.8 0 3 95 65 95 MDJ0687266.1 RNA-binding protein [Xenococcaceae cyanobacterium MO_188.B32] diamond 93 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Xenococcaceae   Xenococcaceae cyanobacterium MO_188.B32
29575475 29575475 PRJNA640143_S_NODE_18250_length_205_cov_2.321429_g18040_i0 PRJNA640143 18250 205 2.321429 4.75892945 Nostocaceae 1162 Bacteria Bacteria 67.8 3.33e-12   NR WP_126987027.1 1162 g18040 i0 52.3 0.951219512195122 65 30 95.1 1 203 9 70 133 WP_126987027.1 MULTISPECIES: hypothetical protein [Nostocaceae] diamond 195 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae    
29967149 29967149 PRJNA640143_S_NODE_14651_length_227_cov_13.878947_g14441_i0 PRJNA640143 14651 227 13.878947 31.50520969 Bacteria 2 Bacteria Bacteria 43.5 0.0166   NR KPQ31753.1 1666911 g14441 i0 42 2.04845814977974 50 26 66.1 2 198 49 537 583 KPQ31753.1 MAG: protein of unknown function (DUF3883) [Phormidesmis priestleyi Ana] diamond 465 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Phormidesmis Phormidesmis priestleyi
31123274 31123274 PRJNA640143_S_NODE_12275_length_247_cov_252.195238_g12065_i0 PRJNA640143 12275 247 252.195238 622.92223786 Pleurocapsa sp. CCALA 161 2107688 Bacteria Bacteria 136 1.82e-37   NR WP_106236211.1 2107688 g12065 i0 98.6 0.838056680161943 69 1 83.8 0 207 1 72 140 WP_106236211.1 SDR family oxidoreductase [Pleurocapsa sp. CCALA 161] diamond 207 136 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. CCALA 161
32515784 32515784 PRJNA640143_S_NODE_9319_length_280_cov_6.316872_g9109_i0 PRJNA640143 9319 280 6.316872 17.6872416 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 147 1.15e-41   NR WP_106369903.1 2107693 g9109 i0 98.6 0.792857142857143 74 1 79.3 0 34 255 46 119 WP_106369903.1 hypothetical protein [Chlorogloea sp. CCALA 695] diamond 222 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695

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