RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA235310" 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

  • PRJNA235310 · 7 ✖

analysis 1

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
23319427 23319427 PRJNA235310_P_NODE_439_length_555_cov_10.677866_g415_i0 PRJNA235310 439 555 10.677866 59.2621563 Cyanobium sp. ARS6 2024869 Bacteria Bacteria 219 1.4899999999999998e-69   NR CAI8350359.1 2024869 g415 i0 70.3 2.4 148 44 80 0 35 478 46 193 CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6] diamond 1332 219 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. ARS6
27200221 27200221 PRJNA235310_P_NODE_5582_length_166_cov_0.888889_g5556_i0 PRJNA235310 5582 166 0.888889 1.47555574 Leptolyngbyaceae cyanobacterium C42_A2020_001 2811131 Bacteria Bacteria 50.8 1.81e-5   NR MBF2028644.1 2811131 g5556 i0 41.8 3.97590361445783 55 32 99.4 0 1 165 24 78 MBF2028644.1 fatty acid desaturase [Leptolyngbyaceae cyanobacterium C42_A2020_001] diamond 660 50.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium C42_A2020_001
28670908 28670908 PRJNA235310_P_NODE_5867_length_164_cov_1.686957_g5841_i0 PRJNA235310 5867 164 1.686957 2.76660948 Chroococcidiopsis 54298 Bacteria Bacteria 90.5 1.89e-19   NR MEO1095502.1 3023210 g5841 i0 75.5 19.3719512195122 53 13 97 0 2 160 180 232 MEO1095502.1 transketolase [Cyanobacteria bacterium J06638_28] diamond 3177 90.9 0.995599559955996 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06638_28
29757989 29757989 PRJNA235310_P_NODE_2871_length_225_cov_1.181818_g2845_i0 PRJNA235310 2871 225 1.181818 2.6590905 Leptolyngbya sp. NIES-3755 1752064 Bacteria Bacteria 60.5 1.64e-8   NR BAU09863.1 1752064 g2845 i0 45.9 0.813333333333333 61 33 81.3 0 11 193 341 401 BAU09863.1 hypothetical protein LEP3755_03380 [Leptolyngbya sp. NIES-3755] diamond 183 60.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755
29902305 29902305 PRJNA235310_P_NODE_951_length_407_cov_1.581006_g925_i0 PRJNA235310 951 407 1.581006 6.43469442 Bacteria 2 Bacteria Bacteria 51.2 2.54e-4   NR WP_260324468.1 1126 g925 i0 37 3.1990171990172 100 59 71.5 3 21 311 884 982 WP_260324468.1 Calx-beta domain-containing protein [Microcystis aeruginosa] diamond 1302 51.6 0.992248062015504 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis aeruginosa
31210959 31210959 PRJNA235310_P_NODE_835_length_435_cov_1.318653_g809_i0 PRJNA235310 835 435 1.318653 5.73614055 Oscillatoria sp. PCC 1 1159 Bacteria Bacteria 160 3.84e-46   NR WP_017716299.1 1173028 g809 i0 64.7 3.28275862068966 119 39 82.1 1 435 79 124 239 WP_017716299.1 SDR family oxidoreductase [Oscillatoria sp. PCC 10802] diamond 1428 160 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria sp. PCC 10802
32255734 32255734 PRJNA235310_P_NODE_1778_length_299_cov_1.872000_g1752_i0 PRJNA235310 1778 299 1.872 5.59728 Crocosphaera sp. 2729996 Bacteria Bacteria 46.6 0.00176   NR WP_300508675.1 2729996 g1752 i0 37 1.55518394648829 81 42 75.3 3 293 69 13 90 WP_300508675.1 EF-hand domain-containing protein [Crocosphaera sp.] diamond 465 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera sp.

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