RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 32 ✖

bioproject 1

  • PRJNA168635 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
26947263 26947263 PRJNA168635_P_NODE_26142_length_168_cov_0.873950_g25726_i0 PRJNA168635 26142 168 0.87395 1.468236 Leptolyngbyaceae cyanobacterium RM1_406_9 2720434 Bacteria Bacteria 43.1 0.00168   NR NJO73319.1 2720434 g25726 i0 55.6 0.642857142857143 36 16 64.3 0 41 148 8 43 NJO73319.1 hypothetical protein [Leptolyngbyaceae cyanobacterium RM1_406_9] diamond 108 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium RM1_406_9
26978948 26978948 PRJNA168635_P_NODE_24282_length_171_cov_1.434426_g23866_i0 PRJNA168635 24282 171 1.434426 2.45286846 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 75.9 2.89e-14   NR MEY3370844.1 2847862 g23866 i0 67.9 0.982456140350877 56 18 98.2 0 2 169 264 319 MEY3370844.1 mismatch repair protein [Cyanobacteriota bacterium] diamond 168 75.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27010512 27010512 PRJNA168635_P_NODE_4482_length_397_cov_13.163793_g4080_i0 PRJNA168635 4482 397 13.163793 52.26025821 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 51.2 1.12e-5   NR MEL7079773.1 3023143 g4080 i0 60 0.340050377833753 45 18 34 0 179 313 15 59 MEL7079773.1 hypothetical protein [Cyanobacteria bacterium J06582_2] diamond 135 51.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
27295181 27295181 PRJNA168635_P_NODE_35243_length_152_cov_2.941748_g34827_i0 PRJNA168635 35243 152 2.941748 4.47145696 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 97.4 2.4699999999999994e-23   NR MBX9725419.1 2364082 g34827 i0 95.9 0.967105263157895 49 2 96.7 0 151 5 133 181 MBX9725419.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 147 97.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
27326827 27326827 PRJNA168635_P_NODE_26043_length_168_cov_1.453782_g25627_i0 PRJNA168635 26043 168 1.453782 2.44235376 Leptolyngbya sp. SIO1E4 2607768 Bacteria Bacteria 52.8 3.29e-6   NR MBE7384383.1 2607768 g25627 i0 55.4 2 56 22 94.6 1 161 3 130 185 MBE7384383.1 hypothetical protein [Leptolyngbya sp. SIO1E4] diamond 336 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. SIO1E4
27390168 27390168 PRJNA168635_P_NODE_20263_length_181_cov_3.159091_g19847_i0 PRJNA168635 20263 181 3.159091 5.71795471 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 78.2 5.05e-15   NR MFN8671439.1 2762020 g19847 i0 67.8 1.95580110497238 59 19 97.8 0 179 3 244 302 MFN8671439.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 354 78.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
27547832 27547832 PRJNA168635_P_NODE_24264_length_171_cov_1.491803_g23848_i0 PRJNA168635 24264 171 1.491803 2.55098313 Allocoleopsis sp. 3088169 Bacteria Bacteria 72.8 1.08e-13   NR HEY9702753.1 3088169 g23848 i0 56.7 1.05263157894737 60 21 96.5 1 4 168 82 141 HEY9702753.1 hypothetical protein [Allocoleopsis sp.] diamond 180 72.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis sp.
27692247 27692247 PRJNA168635_P_NODE_30044_length_164_cov_0.904348_g29628_i0 PRJNA168635 30044 164 0.904348 1.48313072 Cyanophyceae 3028117 Bacteria Bacteria 50.4 2.03e-6   NR WP_190454107.1 1890438 g29628 i0 82.1 2.04878048780488 28 5 51.2 0 80 163 4 31 WP_190454107.1 MULTISPECIES: DUF2811 domain-containing protein [Leptolyngbyaceae] diamond 336 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae    
27926742 27926742 PRJNA168635_P_NODE_18565_length_187_cov_2.775362_g18149_i0 PRJNA168635 18565 187 2.775362 5.18992694 Scytonema sp. UIC 1 1204 Bacteria Bacteria 77.4 4.84e-15   NR WP_155753511.1 2304196 g18149 i0 51.7 10.572192513369 60 29 96.3 0 3 182 208 267 WP_155753511.1 ion channel [Scytonema sp. UIC 10036] diamond 1977 77.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. UIC 10036
27989990 27989990 PRJNA168635_P_NODE_24485_length_170_cov_2.537190_g24069_i0 PRJNA168635 24485 170 2.53719 4.313223 Aphanizomenon flos-aquae WA1 1176 Bacteria Bacteria 75.1 2.39e-14   NR OBQ42330.1 1710896 g24069 i0 60.7 2.78823529411765 56 21 97.1 1 169 5 85 140 OBQ42330.1 MAG: hypothetical protein AN484_18455 [Aphanizomenon flos-aquae WA102] diamond 474 75.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Aphanizomenon Aphanizomenon flos-aquae
28084516 28084516 PRJNA168635_P_NODE_34045_length_156_cov_2.439252_g33629_i0 PRJNA168635 34045 156 2.439252 3.80523312 Microcystis sp. M31BS1 2771186 Bacteria Bacteria 67.4 3.21e-12   NR WP_353847197.1 2771186 g33629 i0 77.8 0.692307692307692 36 8 69.2 0 150 43 131 166 WP_353847197.1 metallophosphoesterase family protein [Microcystis sp. M31BS1] diamond 108 67.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. M31BS1
28179080 28179080 PRJNA168635_P_NODE_31226_length_163_cov_0.912281_g30810_i0 PRJNA168635 31226 163 0.912281 1.48701803 Leptolyngbya sp. FACHB-36 2692808 Bacteria Bacteria 47.4 2.67e-4   NR WP_190340082.1 2692808 g30810 i0 59.5 0.680981595092024 37 15 68.1 0 4 114 213 249 WP_190340082.1 hypothetical protein [Leptolyngbya sp. FACHB-36] diamond 111 47.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-36
28747665 28747665 PRJNA168635_P_NODE_20707_length_180_cov_1.564885_g20291_i0 PRJNA168635 20707 180 1.564885 2.816793 Pseudanabaena sp. SR411 1980935 Bacteria Bacteria 70.9 1.87e-12   NR WP_141211735.1 1980935 g20291 i0 65.2 0.766666666666667 46 16 76.7 0 21 158 290 335 WP_141211735.1 SMEK domain-containing protein [Pseudanabaena sp. SR411] diamond 138 70.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. SR411
28747676 28747676 PRJNA168635_P_NODE_34687_length_154_cov_2.619048_g34271_i0 PRJNA168635 34687 154 2.619048 4.03333392 Fischerella sp. 1191 Bacteria Bacteria 42.4 0.00305   NR MCX7592427.1 1191 g34271 i0 63 1.05194805194805 27 10 52.6 0 74 154 1 27 MCX7592427.1 glutaredoxin [Fischerella sp.] diamond 162 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella sp.
28810454 28810454 PRJNA168635_P_NODE_31408_length_162_cov_4.300885_g30992_i0 PRJNA168635 31408 162 4.300885 6.9674337 Allocoleopsis sp. 3088169 Bacteria Bacteria 45.4 0.00136   NR HEY9701480.1 3088169 g30992 i0 40.7 1 54 27 100 1 1 162 174 222 HEY9701480.1 hypothetical protein [Allocoleopsis sp.] diamond 162 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis sp.
29063532 29063532 PRJNA168635_P_NODE_34008_length_156_cov_2.719626_g33592_i0 PRJNA168635 34008 156 2.719626 4.24261656 Synechococcaceae cyanobacterium SM2_3_1 2720469 Bacteria Bacteria 53.9 1.26e-6   NR NJK63633.1 2720469 g33592 i0 52.2 0.884615384615385 46 22 88.5 0 140 3 258 303 NJK63633.1 ATP-dependent helicase [Synechococcaceae cyanobacterium SM2_3_1] diamond 138 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium SM2_3_1
29239181 29239181 PRJNA168635_P_NODE_29049_length_165_cov_0.896552_g28633_i0 PRJNA168635 29049 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 51.2 8.21e-6   NR HEY9817448.1 2364082 g28633 i0 65.5 1.90909090909091 29 10 52.7 0 88 2 165 193 HEY9817448.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Candidatus Obscuribacterales bacterium] diamond 315 51.6 0.992248062015504 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29379191 29379191 PRJNA168635_P_NODE_34349_length_155_cov_2.594340_g33933_i0 PRJNA168635 34349 155 2.59434 4.021227 Nostoc linckia 92942 Bacteria Bacteria 44.7 0.00235   NR MBD2212909.1 2692905 g33933 i0 52.1 0.929032258064516 48 23 92.9 0 8 151 18 65 MBD2212909.1 CHAT domain-containing protein [Nostoc linckia FACHB-104] diamond 144 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc linckia
29662937 29662937 PRJNA168635_P_NODE_24490_length_170_cov_2.528926_g24074_i0 PRJNA168635 24490 170 2.528926 4.2991742 Altericista sp. CCNU 3082949 Bacteria Bacteria 105 1.74e-25   NR WP_404784353.1 3082949 g24074 i0 91.1 0.988235294117647 56 5 98.8 0 169 2 218 273 WP_404784353.1 UDP-glucuronic acid decarboxylase family protein [Altericista sp. CCNU0014] diamond 168 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales   Altericista Altericista sp. CCNU0014
29757901 29757901 PRJNA168635_P_NODE_18391_length_188_cov_1.467626_g17975_i0 PRJNA168635 18391 188 1.467626 2.75913688 Leptolyngbya sp. FACHB-36 2692808 Bacteria Bacteria 67.8 1.59e-12   NR WP_190340829.1 2692808 g17975 i0 51.7 0.957446808510638 60 28 95.7 1 4 183 43 101 WP_190340829.1 hypothetical protein [Leptolyngbya sp. FACHB-36] diamond 180 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-36
29884523 29884523 PRJNA168635_P_NODE_26991_length_167_cov_1.406780_g26575_i0 PRJNA168635 26991 167 1.40678 2.3493226 Leptolyngbya sp. FACHB-36 2692808 Bacteria Bacteria 41.2 0.0444   NR WP_206754536.1 2692808 g26575 i0 57.5 0.718562874251497 40 16 71.9 1 47 166 6 44 WP_206754536.1 hypothetical protein [Leptolyngbya sp. FACHB-36] diamond 120 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-36
29947599 29947599 PRJNA168635_P_NODE_29691_length_164_cov_1.434783_g29275_i0 PRJNA168635 29691 164 1.434783 2.35304412 unclassified Cyanobium 2627006 Bacteria Bacteria 63.9 2.74e-11   NR WP_255016868.1 2627006 g29275 i0 73.7 0.695121951219512 38 10 69.5 0 3 116 77 114 WP_255016868.1 MULTISPECIES: hypothetical protein [unclassified Cyanobium] diamond 114 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium  
30186406 30186406 PRJNA168635_P_NODE_33352_length_158_cov_2.963303_g32936_i0 PRJNA168635 33352 158 2.963303 4.68201874 Cyanophyceae 3028117 Bacteria Bacteria 63.9 3.88e-10   NR MCD8487952.1 2497424 g32936 i0 73.3 1.78481012658228 45 12 85.4 0 9 143 555 599 MCD8487952.1 hypothetical protein [Desertifilum sp.] diamond 282 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Desertifilales Desertifilaceae Desertifilum Desertifilum sp.
30390293 30390293 PRJNA168635_P_NODE_25293_length_169_cov_0.866667_g24877_i0 PRJNA168635 25293 169 0.866667 1.46466723 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 65.1 1.53e-10   NR HEY9805490.1 2364082 g24877 i0 57.4 1.08284023668639 61 19 95.9 1 167 6 170 230 HEY9805490.1 reverse transcriptase domain-containing protein [Candidatus Obscuribacterales bacterium] diamond 183 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31084991 31084991 PRJNA168635_P_NODE_28875_length_165_cov_0.896552_g28459_i0 PRJNA168635 28875 165 0.896552 1.4793108 Dolichospermum sp. 2720786 Bacteria Bacteria 55.5 6.65e-8   NR MFN9560458.1 2720786 g28459 i0 52.9 0.927272727272727 51 22 89.1 1 18 164 38 88 MFN9560458.1 hypothetical protein [Dolichospermum sp.] diamond 153 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp.
31432712 31432712 PRJNA168635_P_NODE_26396_length_168_cov_0.873950_g25980_i0 PRJNA168635 26396 168 0.87395 1.468236 Pseudanabaena sp. LacPavin_0818_WC45_MAG_42_6 2968984 Bacteria Bacteria 68.9 7.59e-12   NR MCX5935545.1 2968984 g25980 i0 72.5 0.714285714285714 40 11 71.4 0 121 2 458 497 MCX5935545.1 reverse transcriptase family protein [Pseudanabaena sp. LacPavin_0818_WC45_MAG_42_6] diamond 120 68.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. LacPavin_0818_WC45_MAG_42_6
31432713 31432713 PRJNA168635_P_NODE_28856_length_165_cov_0.896552_g28440_i0 PRJNA168635 28856 165 0.896552 1.4793108 Microcystis sp. M 1127 Bacteria Bacteria 92.4 3.59e-20   NR WP_287873650.1 2771111 g28440 i0 74.1 1.92727272727273 54 14 98.2 0 163 2 105 158 WP_287873650.1 hypothetical protein [Microcystis sp. M034S1] diamond 318 92.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. M034S1
31559463 31559463 PRJNA168635_P_NODE_20736_length_180_cov_1.496183_g20320_i0 PRJNA168635 20736 180 1.496183 2.6931294 Microcystis sp. M 1127 Bacteria Bacteria 100 2.76e-24   NR WP_287721938.1 2771120 g20320 i0 73.3 2 60 16 100 0 180 1 113 172 WP_287721938.1 hypothetical protein [Microcystis sp. M049S1] diamond 360 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. M049S1
32097029 32097029 PRJNA168635_P_NODE_23678_length_172_cov_1.731707_g23262_i0 PRJNA168635 23678 172 1.731707 2.97853604 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 80.5 7.14e-16   NR MEY3370667.1 2847862 g23262 i0 64.9 0.994186046511628 57 20 99.4 0 171 1 256 312 MEY3370667.1 hypothetical protein [Cyanobacteriota bacterium] diamond 171 80.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32255648 32255648 PRJNA168635_P_NODE_27238_length_167_cov_0.881356_g26822_i0 PRJNA168635 27238 167 0.881356 1.47186452 Calothrix sp. NIES-21 1187 Bacteria Bacteria 78.6 6.92e-16   NR WP_096607277.1 1954172 g26822 i0 61.1 2.91017964071856 54 21 97 0 2 163 92 145 WP_096607277.1 hypothetical protein [Calothrix sp. NIES-2100] diamond 486 78.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. NIES-2100
32540264 32540264 PRJNA168635_P_NODE_23679_length_172_cov_1.731707_g23263_i0 PRJNA168635 23679 172 1.731707 2.97853604 Cyanobacteria bacterium SZAS-4 2807733 Bacteria Bacteria 65.1 1.77e-10   NR MBS1954694.1 2807733 g23263 i0 74.4 0.75 43 10 73.3 1 137 12 264 306 MBS1954694.1 hypothetical protein [Cyanobacteria bacterium SZAS-4] diamond 129 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS-4
32886331 32886331 PRJNA168635_P_NODE_22060_length_176_cov_2.086614_g21644_i0 PRJNA168635 22060 176 2.086614 3.67244064 Leptolyngbya sp. FACHB-36 2692808 Bacteria Bacteria 51.6 1.11e-5   NR MBD2018666.1 2692808 g21644 i0 43.6 1.875 55 31 93.8 0 11 175 233 287 MBD2018666.1 tape measure protein [Leptolyngbya sp. FACHB-36] diamond 330 51.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-36

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