RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA851399" 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 · 10 ✖

bioproject 1

  • PRJNA851399 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
19965694 19965694 PRJNA851399_P_NODE_20096_length_177_cov_1.593750_g19643_i0 PRJNA851399 20096 177 1.59375 2.8209375 Geitlerinema sp. PCC 74 3100420 Bacteria Bacteria 98.2 4.01e-22   NR WP_041268524.1 1173025 g19643 i0 82.8 8.84745762711864 58 10 98.3 0 176 3 415 472 WP_041268524.1 Ppx/GppA phosphatase family protein [Geitlerinema sp. PCC 7407] diamond 1566 98.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Geitlerinematales Geitlerinemataceae Geitlerinema Geitlerinema sp. PCC 7407
26865435 26865435 PRJNA851399_P_NODE_35501_length_163_cov_0.894737_g35048_i0 PRJNA851399 35501 163 0.894737 1.45842131 Chroococcidiopsis sp. CCALA 3088168 Bacteria Bacteria 94.4 1.46e-22   NR WP_106545723.1 869949 g35048 i0 89.8 0.901840490797546 49 5 90.2 0 6 152 127 175 WP_106545723.1 HdeD family acid-resistance protein [Chroococcidiopsis sp. CCALA 051] diamond 147 94.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCALA 051
27212845 27212845 PRJNA851399_P_NODE_17542_length_184_cov_1.511111_g17089_i0 PRJNA851399 17542 184 1.511111 2.78044424 Microcoleus sp. PH2 44472 Bacteria Bacteria 52 9.42e-6   NR WP_293285320.1 2798850 g17089 i0 82.1 2.39673913043478 28 5 45.7 0 8 91 837 864 WP_293285320.1 NACHT domain-containing protein [Microcoleus sp. PH2017_40_RAT_O_B] diamond 441 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. PH2017_40_RAT_O_B
27434441 27434441 PRJNA851399_P_NODE_20443_length_176_cov_2.409449_g19990_i0 PRJNA851399 20443 176 2.409449 4.24063024 Argonema galeatum 2942762 Bacteria Bacteria 53.1 3.49e-7   NR WP_249093151.1 2942762 g19990 i0 89.3 0.477272727272727 28 3 47.7 0 91 174 1 28 WP_249093151.1 DUF3007 family protein [Argonema galeatum] diamond 84 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Argonema Argonema galeatum
28413086 28413086 PRJNA851399_P_NODE_37366_length_162_cov_0.902655_g36913_i0 PRJNA851399 37366 162 0.902655 1.4623011 Nostoc mirabile 2907820 Bacteria Bacteria 95.1 4.1800000000000005e-21   NR WP_229497677.1 2907820 g36913 i0 90.4 0.962962962962963 52 5 96.3 0 157 2 213 264 WP_229497677.1 hypothetical protein [Nostoc mirabile] diamond 156 95.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc mirabile
28886514 28886514 PRJNA851399_P_NODE_37588_length_162_cov_0.902655_g37135_i0 PRJNA851399 37588 162 0.902655 1.4623011 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 55.5 4.11e-7   NR WP_106367551.1 2107693 g37135 i0 90 0.555555555555556 30 3 55.6 0 162 73 476 505 WP_106367551.1 mechanosensitive ion channel domain-containing protein [Chlorogloea sp. CCALA 695] diamond 90 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
29170928 29170928 PRJNA851399_P_NODE_36109_length_163_cov_0.894737_g35656_i0 PRJNA851399 36109 163 0.894737 1.45842131 Chroococcidiopsis sp. CCALA 3088168 Bacteria Bacteria 89.4 3.59e-19   NR WP_199197606.1 869949 g35656 i0 75.9 1.98773006134969 54 13 99.4 0 1 162 80 133 WP_199197606.1 relaxase/mobilization nuclease domain-containing protein [Chroococcidiopsis sp. CCALA 051] diamond 324 89.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCALA 051
29431386 29431386 PRJNA851399_P_NODE_38689_length_162_cov_0.902655_g38236_i0 PRJNA851399 38689 162 0.902655 1.4623011 Tolypothrichaceae 119859 Bacteria Bacteria 95.1 3.42e-21   NR WP_039738543.1 482630 g38236 i0 83 1.96296296296296 53 9 98.1 0 2 160 202 254 WP_039738543.1 serine/threonine-protein kinase [Hassallia byssoidea] diamond 318 95.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Tolypothrichaceae Hassallia Hassallia byssoidea
32141454 32141454 PRJNA851399_P_NODE_17838_length_183_cov_1.522388_g17385_i0 PRJNA851399 17838 183 1.522388 2.78597004 Microcoleus sp. herbarium8 3055436 Bacteria Bacteria 72.4 1.5700000000000001e-13   NR WP_369293223.1 3055436 g17385 i0 64.4 0.967213114754098 59 21 96.7 0 179 3 14 72 WP_369293223.1 TolB family protein, partial [Microcoleus sp. herbarium8] diamond 177 72.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. herbarium8
32204738 32204738 PRJNA851399_P_NODE_27938_length_166_cov_0.871795_g27485_i0 PRJNA851399 27938 166 0.871795 1.4471797 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 113 2.0900000000000003e-27   NR WP_106369885.1 2107693 g27485 i0 94.5 0.993975903614458 55 3 99.4 0 2 166 92 146 WP_106369885.1 hypothetical protein [Chlorogloea sp. CCALA 695] diamond 165 113 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);;