RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA826497" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA826497 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
27686665 27686665 PRJNA826497_S_NODE_17204_length_158_cov_3.184000_g17164_i0 PRJNA826497 17204 158 3.184 5.03072 Hydrocoleum sp. CS-953 1671698 Bacteria Bacteria 60.1 8.8e-9   NR WP_094673277.1 1671698 g17164 i0 90 2.27848101265823 30 3 57 0 147 58 184 213 WP_094673277.1 ferredoxin:protochlorophyllide reductase (ATP-dependent) subunit N [Hydrocoleum sp. CS-953] diamond 360 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Hydrocoleum Hydrocoleum sp. CS-953
28096747 28096747 PRJNA826497_S_NODE_11265_length_180_cov_11.333333_g11225_i0 PRJNA826497 11265 180 11.333333 20.3999994 Scytonema millei 1245922 Bacteria Bacteria 72.8 4.01e-13   NR WP_165587607.1 1245922 g11225 i0 71.7 1 60 16 98.3 1 178 2 294 353 WP_165587607.1 filamentous hemagglutinin N-terminal domain-containing protein [Scytonema millei] diamond 180 72.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema millei
28222883 28222883 PRJNA826497_S_NODE_9766_length_188_cov_13.612903_g9726_i0 PRJNA826497 9766 188 13.612903 25.59225764 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 97.4 5.369999999999999e-23   NR HEY9742142.1 3081323 g9726 i0 86.8 0.845744680851064 53 7 84.6 0 4 162 196 248 HEY9742142.1 SDR family oxidoreductase [Coleofasciculaceae cyanobacterium] diamond 159 97.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
28736905 28736905 PRJNA826497_S_NODE_4207_length_237_cov_8.176471_g4167_i0 PRJNA826497 4207 237 8.176471 19.37823627 Aliterella 1827277 Bacteria Bacteria 94.4 2.45e-23   NR KJH70267.1 1618023 g4167 i0 97.7 1.11392405063291 44 1 55.7 0 139 8 35 78 KJH70267.1 hypothetical protein UH38_19160 [Aliterella atlantica CENA595] diamond 264 94.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28917444 28917444 PRJNA826497_S_NODE_19708_length_151_cov_4.389831_g19668_i0 PRJNA826497 19708 151 4.389831 6.62864481 Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35 2801880 Bacteria Bacteria 66.2 4.98e-11   NR MBV8886747.1 2801880 g19668 i0 68.1 1.86754966887417 47 14 91.4 1 1 138 246 292 MBV8886747.1 ArsA family ATPase [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35] diamond 282 66.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae   Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
28989737 28989737 PRJNA826497_S_NODE_2028_length_284_cov_3.254980_g1988_i0 PRJNA826497 2028 284 3.25498 9.2441432 Cyanophyceae 3028117 Bacteria Bacteria 113 7.51e-30   NR WP_015188920.1 1173026 g1988 i0 72.3 3.42253521126761 65 18 68.7 0 282 88 59 123 WP_015188920.1 hypothetical protein [Gloeocapsa sp. PCC 7428] diamond 972 114 0.991228070175439 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. PCC 7428
29179085 29179085 PRJNA826497_S_NODE_18809_length_153_cov_7.633333_g18769_i0 PRJNA826497 18809 153 7.633333 11.67899949 Cyanophyceae 3028117 Bacteria Bacteria 52.4 1.97e-7   NR WP_144873840.1 1982969 g18769 i0 45.8 2.82352941176471 48 26 94.1 0 149 6 1 48 WP_144873840.1 hypothetical protein [Hyella patelloides] diamond 432 52.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Hyella Hyella patelloides
29201984 29201984 PRJNA826497_S_NODE_8169_length_198_cov_8.666667_g8129_i0 PRJNA826497 8169 198 8.666667 17.16000066 Microseira sp. BLCC-F43 3153602 Bacteria Bacteria 92 5.22e-20   NR WP_374883059.1 3153602 g8129 i0 79.6 2.22727272727273 49 10 74.2 0 50 196 1 49 WP_374883059.1 RNA-guided endonuclease InsQ/TnpB family protein [Microseira sp. BLCC-F43] diamond 441 92 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Microseira Microseira sp. BLCC-F43
30031581 30031581 PRJNA826497_S_NODE_10171_length_186_cov_3.313725_g10131_i0 PRJNA826497 10171 186 3.313725 6.1635285 Nostocales 1161 Bacteria Bacteria 114 1.47e-29   NR WP_094347668.1 2014529 g10131 i0 93.3 4.83870967741935 60 4 96.8 0 6 185 175 234 WP_094347668.1 SDR family NAD(P)-dependent oxidoreductase [Nostoc sp. 'Peltigera membranacea cyanobiont' 210A] diamond 900 114 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. 'Peltigera membranacea cyanobiont' 210A
30663404 30663404 PRJNA826497_S_NODE_19373_length_152_cov_3.369748_g19333_i0 PRJNA826497 19373 152 3.369748 5.12201696 Nostocales 1161 Bacteria Bacteria 54.3 8.65e-8   NR WP_038072380.1 1161 g19333 i0 100 10.6578947368421 27 0 53.3 0 83 3 1 27 WP_038072380.1 MULTISPECIES: EutN/CcmL family microcompartment protein [Nostocales] diamond 1620 54.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales      
30758284 30758284 PRJNA826497_S_NODE_4894_length_228_cov_6.102564_g4854_i0 PRJNA826497 4894 228 6.102564 13.91384592 root 1 Root_unresolved Root_unresolved 43.5 0.0158   NR WP_272819331.1 34078 g4854 i0 52.2 4.77631578947368 46 20 57.9 2 157 26 334 379 WP_272819331.1 RNA-guided endonuclease InsQ/TnpB family protein [Scytonema hofmannii] diamond 1089 43.9 0.990888382687927 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema hofmannii
31200126 31200126 PRJNA826497_S_NODE_14175_length_168_cov_3.540741_g14135_i0 PRJNA826497 14175 168 3.540741 5.94844488 Cyanophyceae 3028117 Bacteria Bacteria 92.4 4.17e-20   NR MBR8833142.1 221294 g14135 i0 85.7 4.375 49 7 87.5 0 3 149 870 918 MBR8833142.1 peptidase domain-containing ABC transporter [Stigonema ocellatum SAG 48.90 = DSM 106950] diamond 735 92.8 0.995689655172414 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Stigonemataceae Stigonema Stigonema ocellatum
31390476 31390476 PRJNA826497_S_NODE_5296_length_224_cov_2.434555_g5256_i0 PRJNA826497 5296 224 2.434555 5.4534032 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 84 8.6e-17   NR RCJ26180.1 1844469 g5256 i0 56.2 3.91071428571429 73 32 97.8 0 3 221 16 88 RCJ26180.1 hypothetical protein A6770_26570 [Nostoc minutum NIES-26] diamond 876 84 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc minutum
31508340 31508340 PRJNA826497_S_NODE_10276_length_185_cov_6.888158_g10236_i0 PRJNA826497 10276 185 6.888158 12.7430923 Tolypothrix brevis 2835081 Bacteria Bacteria 55.5 1.11e-7   NR MBW4480837.1 2835095 g10236 i0 42.1 0.924324324324324 57 31 89.2 1 185 21 41 97 MBW4480837.1 hypothetical protein [Tolypothrix brevis GSE-NOS-MK-07-07A] diamond 171 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Tolypothrichaceae Tolypothrix Tolypothrix brevis
31634600 31634600 PRJNA826497_S_NODE_15616_length_163_cov_2.692308_g15576_i0 PRJNA826497 15616 163 2.692308 4.38846204 uncultured Leptolyngbya sp. 332963 Bacteria Bacteria 68.9 2.84e-13   NR CAA9367999.1 332963 g15576 i0 76.1 0.846625766871166 46 11 84.7 0 163 26 40 85 CAA9367999.1 Preprotein translocase subunit SecD, partial [uncultured Leptolyngbya sp.] diamond 138 68.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya uncultured Leptolyngbya sp.
31634609 31634609 PRJNA826497_S_NODE_9516_length_190_cov_3.394904_g9476_i0 PRJNA826497 9516 190 3.394904 6.4503176 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 61.6 2.85e-10   NR WP_106367630.1 2107693 g9476 i0 92.6 1.26315789473684 27 2 42.6 0 190 110 90 116 WP_106367630.1 histidine triad nucleotide-binding protein [Chlorogloea sp. CCALA 695] diamond 240 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
32046046 32046046 PRJNA826497_S_NODE_8098_length_199_cov_2.909639_g8058_i0 PRJNA826497 8098 199 2.909639 5.79018161 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 81.3 7.59e-17   NR MEL7079531.1 3023143 g8058 i0 81.8 0.663316582914573 44 8 66.3 0 197 66 72 115 MEL7079531.1 hypothetical protein [Cyanobacteria bacterium J06582_2] diamond 132 81.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
32835559 32835559 PRJNA826497_S_NODE_2340_length_275_cov_2.553719_g2300_i0 PRJNA826497 2340 275 2.553719 7.02272725 Gloeocapsa sp. UFS-A4-WI-NPMV-4B04 2839657 Bacteria Bacteria 85.5 4.85e-17   NR MBW4637729.1 2839657 g2300 i0 69.6 1.21090909090909 56 17 61.1 0 4 171 197 252 MBW4637729.1 HAMP domain-containing histidine kinase [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04] diamond 333 85.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. UFS-A4-WI-NPMV-4B04

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