RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1108009" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1108009 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
3571080 3571080 PRJNA1108009_P_NODE_3983_length_701_cov_1.490446_g3679_i0 PRJNA1108009 3983 701 1.490446 10.44802646 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 217 2.8099999999999998e-67   NR HCF26074.1 2055787 g3679 i0 52.9 8.60627674750357 227 97 95.9 5 672 1 4 223 HCF26074.1 short-chain dehydrogenase [Cyanobacteria bacterium UBA11049] diamond 6033 217 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
15515436 15515436 PRJNA1108009_P_NODE_16173_length_326_cov_1.217391_g15855_i0 PRJNA1108009 16173 326 1.217391 3.96869466 Cyanobacteria bacterium P01_A01_bin.135 3023243 Bacteria Bacteria 160 2.99e-48   NR MEO0406224.1 3023243 g15855 i0 67.3 2.95398773006135 107 35 98.5 0 326 6 33 139 MEO0406224.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_A01_bin.135] diamond 963 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.135
27974978 27974978 PRJNA1108009_P_NODE_31565_length_241_cov_0.916667_g31247_i0 PRJNA1108009 31565 241 0.916667 2.20916747 Cyanophyceae 3028117 Bacteria Bacteria 108 2.56e-25   NR MBO1350831.1 2480853 g31247 i0 66.7 6.03734439834025 81 26 99.6 1 241 2 105 185 MBO1350831.1 leucine-rich repeat domain-containing protein [Hormoscilla sp. GUM202] diamond 1455 108 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. GUM202
28173037 28173037 PRJNA1108009_P_NODE_26726_length_248_cov_0.880000_g26408_i0 PRJNA1108009 26726 248 0.88 2.1824 Hormoscilla sp. SP5CHS1 2653675 Bacteria Bacteria 53.9 4.55e-6   NR MBC6453268.1 2653675 g26408 i0 43.9 1.42741935483871 57 32 69 0 240 70 9 65 MBC6453268.1 CHAT domain-containing protein [Hormoscilla sp. SP5CHS1] diamond 354 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. SP5CHS1
30415607 30415607 PRJNA1108009_P_NODE_26833_length_248_cov_0.880000_g26515_i0 PRJNA1108009 26833 248 0.88 2.1824 Oscillatoriaceae cyanobacterium 2664179 Bacteria Bacteria 48.1 4.75e-4   NR HEY9720540.1 2664179 g26515 i0 37.3 1.82661290322581 75 40 90.7 2 247 23 305 372 HEY9720540.1 kelch repeat-containing protein [Oscillatoriaceae cyanobacterium] diamond 453 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae   Oscillatoriaceae cyanobacterium
31742715 31742715 PRJNA1108009_P_NODE_21517_length_276_cov_0.837438_g21199_i0 PRJNA1108009 21517 276 0.837438 2.31132888 Geminocystis sp. NIES-37 2664100 Bacteria Bacteria 68.6 4.74e-11   NR WP_066348589.1 1615909 g21199 i0 44.4 0.978260869565217 90 45 97.8 2 274 5 2167 2251 WP_066348589.1 bluetail domain-containing putative surface protein [Geminocystis sp. NIES-3708] diamond 270 68.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Geminocystis Geminocystis sp. NIES-3708

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