RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 9 ✖

bioproject 1

  • PRJNA795663 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
27433285 27433285 PRJNA795663_S_NODE_10203_length_191_cov_2.285714_g10098_i0 PRJNA795663 10203 191 2.285714 4.36571374 Synechococcus sp. L2F 2823739 Bacteria Bacteria 133 3.3999999999999996e-36   NR WP_255099523.1 2823739 g10098 i0 100 0.989528795811518 63 0 99 0 3 191 189 251 WP_255099523.1 tetratricopeptide repeat protein [Synechococcus sp. L2F] diamond 189 133 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. L2F
27591130 27591130 PRJNA795663_S_NODE_4704_length_269_cov_1.987069_g4599_i0 PRJNA795663 4704 269 1.987069 5.34521561 Cyanobium sp. 2164130 Bacteria Bacteria 77 3.92e-15   NR GDX76675.1 2164130 g4599 i0 63.1 0.724907063197026 65 24 72.5 0 195 1 73 137 GDX76675.1 hypothetical protein LBMAG41_17510 [Cyanobium sp.] diamond 195 77 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp.
29769424 29769424 PRJNA795663_S_NODE_7971_length_212_cov_3.600000_g7866_i0 PRJNA795663 7971 212 3.6 7.632 Synechococcus sp. MW1 1131 Bacteria Bacteria 120 1.08e-29   NR WP_198948260.1 210768 g7866 i0 90 0.990566037735849 70 7 99.1 0 211 2 59 128 WP_198948260.1 hypothetical protein, partial [Synechococcus sp. MW101C3] diamond 210 120 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. MW101C3
29959012 29959012 PRJNA795663_S_NODE_4631_length_271_cov_1.867521_g4526_i0 PRJNA795663 4631 271 1.867521 5.06098191 Synechococcus sp. MW1 1131 Bacteria Bacteria 165 1.19e-47   NR WP_144036918.1 210768 g4526 i0 93.3 0.996309963099631 90 6 99.6 0 271 2 12 101 WP_144036918.1 alpha/beta hydrolase [Synechococcus sp. MW101C3] diamond 270 165 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. MW101C3
30053655 30053655 PRJNA795663_S_NODE_3731_length_299_cov_1.896947_g3626_i0 PRJNA795663 3731 299 1.896947 5.67187153 Synechococcus sp. L2F 2823739 Bacteria Bacteria 193 6.370000000000001e-59   NR WP_255099523.1 2823739 g3626 i0 100 0.993311036789298 99 0 99.3 0 3 299 92 190 WP_255099523.1 tetratricopeptide repeat protein [Synechococcus sp. L2F] diamond 297 193 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. L2F
30653995 30653995 PRJNA795663_S_NODE_5273_length_254_cov_2.225806_g5168_i0 PRJNA795663 5273 254 2.225806 5.65354724 Synechococcus sp. MW1 1131 Bacteria Bacteria 147 7.02e-39   NR WP_144037042.1 210768 g5168 i0 89.3 1.98425196850394 84 9 99.2 0 2 253 1087 1170 WP_144037042.1 DUF4347 domain-containing protein, partial [Synechococcus sp. MW101C3] diamond 504 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. MW101C3
30907099 30907099 PRJNA795663_S_NODE_14474_length_166_cov_1.883721_g14369_i0 PRJNA795663 14474 166 1.883721 3.12697686 unclassified Synechococcus 2626047 Bacteria Bacteria 97.8 3.39e-25   NR WP_094512741.1 2626047 g14369 i0 100 0.813253012048193 45 0 81.3 0 1 135 29 73 WP_094512741.1 MULTISPECIES: DUF4278 domain-containing protein [unclassified Synechococcus] diamond 135 97.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus  
31507715 31507715 PRJNA795663_S_NODE_15076_length_164_cov_0.897638_g14971_i0 PRJNA795663 15076 164 0.897638 1.47212632 unclassified Synechococcus 2626047 Bacteria Bacteria 105 1.52e-25   NR WP_094510192.1 2626047 g14971 i0 100 0.98780487804878 54 0 98.8 0 164 3 138 191 WP_094510192.1 MULTISPECIES: orange carotenoid-binding protein [unclassified Synechococcus] diamond 162 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus  
32022853 32022853 PRJNA795663_S_NODE_18418_length_152_cov_1.017391_g18313_i0 PRJNA795663 18418 152 1.017391 1.54643432 Synechococcales 1890424 Bacteria Bacteria 102 1.15e-25   NR WP_254951590.1 2627006 g18313 i0 98 1.97368421052632 50 1 98.7 0 152 3 51 100 WP_254951590.1 MULTISPECIES: spermidine N1-acetyltransferase [unclassified Cyanobium] diamond 300 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium  

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