RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA975724" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 27 ✖

bioproject 1

  • PRJNA975724 · 27 ✖
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
1266751 1266751 PRJNA975724_S_NODE_22401_length_375_cov_6.665563_g22220_i0 PRJNA975724 22401 375 6.665563 24.99586125 filamentous cyanobacterium CCP5 2107701 Bacteria Bacteria 128 4.8099999999999994e-35   NR PSN10069.1 2107701 g22220 i0 73.2 1.312 82 22 65.6 0 1 246 68 149 PSN10069.1 nucleoside-diphosphate kinase [filamentous cyanobacterium CCP5] diamond 492 128 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         filamentous cyanobacterium CCP5
1266808 1266808 PRJNA975724_S_NODE_61_length_1931_cov_9.102260_g53_i0 PRJNA975724 61 1931 9.10226 175.7646406 Cyanophyceae 3028117 Bacteria Bacteria 2490 0   NTclustered gi|427983362|gb|CP003591.1| 1173025 g53 i0 90.245 184.563438632833 1917 171 99 13 1 1908 239856 237947 Geitlerinema sp. PCC 7407 chromosome, complete genome blastn 356392 2507 0.993218986836857 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Geitlerinematales Geitlerinemataceae Geitlerinema Geitlerinema sp. PCC 7407
4773678 4773678 PRJNA975724_S_NODE_10424_length_446_cov_17.289544_g10243_i0 PRJNA975724 10424 446 17.289544 77.11136624 Cyanophyceae 3028117 Bacteria Bacteria 119 2.63e-31   NR WP_199247450.1 222819 g10243 i0 68.2 2.95964125560538 88 28 59.2 0 446 183 64 151 WP_199247450.1 nucleoside-diphosphate kinase [[Phormidium] sp. ETS-05] diamond 1320 119 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Koinonema [Phormidium] sp. ETS-05
7323347 7323347 PRJNA975724_S_NODE_1066_length_788_cov_7.222378_g924_i0 PRJNA975724 1066 788 7.222378 56.91233864 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 357 6.580000000000001e-122   NR MFN4150446.1 2762020 g924 i0 75.6 0.890862944162436 234 53 87.6 1 691 2 1 234 MFN4150446.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 702 357 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
12424983 12424983 PRJNA975724_S_NODE_28530_length_353_cov_1.403571_g28349_i0 PRJNA975724 28530 353 1.403571 4.95460563 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 147 4.4e-41   NR MFN4150447.1 2762020 g28349 i0 67.3 0.8328611898017 98 32 83.3 0 1 294 189 286 MFN4150447.1 cytochrome c oxidase subunit II transmembrane domain-containing protein [Candidatus Sericytochromatia bacterium] diamond 294 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
14020608 14020608 PRJNA975724_S_NODE_16611_length_403_cov_6.412121_g16430_i0 PRJNA975724 16611 403 6.412121 25.84084763 Leptolyngbya 47251 Bacteria Bacteria 584 3.079999999999999e-162   NTclustered gi|965629957|dbj|AP017308.1| 1752064 g16430 i0 92.822 181.578163771712 404 27 100 2 1 403 1243806 1244208 Leptolyngbya sp. NIES-3755 DNA, complete genome blastn 73176 584 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-3755
16248374 16248374 PRJNA975724_S_NODE_16793_length_402_cov_5.389058_g16612_i0 PRJNA975724 16793 402 5.389058 21.66401316 Leptolyngbya sp. 7M 2812896 Bacteria Bacteria 141 8.000000000000001e-29   NTclustered gi|2028908486|gb|CP070897.1| 2812896 g16612 i0 80.097 3.96766169154229 206 27 50 9 74 274 2367003 2366807 Leptolyngbya sp. 7M chromosome blastn 1595 141 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. 7M
18798215 18798215 PRJNA975724_S_NODE_50655_length_296_cov_1.381166_g50474_i0 PRJNA975724 50655 296 1.381166 4.08825136 Kovacikia minuta 2931930 Bacteria Bacteria 52.8 0.027   NTclustered gi|2098452651|gb|CP083582.1| 2653194 g50474 i0 100 0.0945945945945946 28 0 9 0 155 182 3805526 3805553 Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Kovacikia Kovacikia minuta
23899417 23899417 PRJNA975724_S_NODE_71619_length_260_cov_1.737968_g71438_i0 PRJNA975724 71619 260 1.737968 4.5187168 Cyanophyceae 3028117 Bacteria Bacteria 131 3.23e-36   NR WP_009457652.1 372787 g71438 i0 85.5 25.7538461538462 76 11 87.7 0 259 32 142 217 WP_009457652.1 translation elongation factor Ts [Fischerella thermalis] diamond 6696 132 0.992424242424242 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Hapalosiphonaceae Fischerella Fischerella thermalis
26931094 26931094 PRJNA975724_S_NODE_4322_length_540_cov_7.233405_g4143_i0 PRJNA975724 4322 540 7.233405 39.060387 Allocoleopsis sp. 3088169 Bacteria Bacteria 58.5 2.42e-6   NR HEY9661701.1 3088169 g4143 i0 29.3 0.738888888888889 133 91 72.2 2 538 149 1278 1410 HEY9661701.1 reverse transcriptase domain-containing protein [Allocoleopsis sp.] diamond 399 58.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis sp.
26994118 26994118 PRJNA975724_S_NODE_82262_length_248_cov_0.880000_g82081_i0 PRJNA975724 82262 248 0.88 2.1824 Altericista sp. CCNU 3082949 Bacteria Bacteria 105 4.58e-25   NR WP_404784297.1 3082949 g82081 i0 67.2 0.774193548387097 64 21 77.4 0 233 42 251 314 WP_404784297.1 prolyl aminopeptidase [Altericista sp. CCNU0014] diamond 192 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales   Altericista Altericista sp. CCNU0014
27057633 27057633 PRJNA975724_S_NODE_75422_length_255_cov_1.269231_g75241_i0 PRJNA975724 75422 255 1.269231 3.23653905 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 57.8 1.71e-7   NR MFN4150447.1 2762020 g75241 i0 67.3 0.576470588235294 49 16 57.6 0 148 2 27 75 MFN4150447.1 cytochrome c oxidase subunit II transmembrane domain-containing protein [Candidatus Sericytochromatia bacterium] diamond 147 57.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
27278968 27278968 PRJNA975724_S_NODE_51323_length_295_cov_0.828829_g51142_i0 PRJNA975724 51323 295 0.828829 2.44504555 Calothrix sp. PCC 63 1187 Bacteria Bacteria 139 1.61e-39   NR WP_015198724.1 1170562 g51142 i0 71.1 10.0372881355932 97 28 98.6 0 2 292 80 176 WP_015198724.1 Dps family protein [Calothrix sp. PCC 6303] diamond 2961 139 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 6303
27310708 27310708 PRJNA975724_S_NODE_41103_length_317_cov_1.577869_g40922_i0 PRJNA975724 41103 317 1.577869 5.00184473 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 89.7 9.72e-20   NR MFN4151476.1 2762020 g40922 i0 58.4 0.728706624605678 77 32 72.9 0 296 66 120 196 MFN4151476.1 NADH-quinone oxidoreductase subunit J [Candidatus Sericytochromatia bacterium] diamond 231 89.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
27310712 27310712 PRJNA975724_S_NODE_59603_length_279_cov_2.349515_g59422_i0 PRJNA975724 59603 279 2.349515 6.55514685 Chroococcidiopsidales cyanobacterium LEGE 13417 1828829 Bacteria Bacteria 57 5.55e-7   NR MBE9016650.1 1828829 g59422 i0 57.9 0.408602150537634 38 16 40.9 0 20 133 957 994 MBE9016650.1 amino acid adenylation domain-containing protein [Chroococcidiopsidales cyanobacterium LEGE 13417] diamond 114 57 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales     Chroococcidiopsidales cyanobacterium LEGE 13417
28163161 28163161 PRJNA975724_S_NODE_71485_length_260_cov_2.379679_g71304_i0 PRJNA975724 71485 260 2.379679 6.1871654 Spirulinaceae cyanobacterium 3107590 Bacteria Bacteria 49.7 6.43e-5   NR MFP4006608.1 3107590 g71304 i0 47.7 1.01538461538462 44 23 50.8 0 3 134 109 152 MFP4006608.1 universal stress protein [Spirulinaceae cyanobacterium] diamond 264 49.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Spirulinales Spirulinaceae   Spirulinaceae cyanobacterium
28762855 28762855 PRJNA975724_S_NODE_93487_length_230_cov_2.261146_g93306_i0 PRJNA975724 93487 230 2.261146 5.2006358 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 127 1.51e-33   NR MFN4151019.1 2762020 g93306 i0 76.3 0.991304347826087 76 18 99.1 0 228 1 225 300 MFN4151019.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 228 127 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
28952656 28952656 PRJNA975724_S_NODE_73748_length_257_cov_1.788043_g73567_i0 PRJNA975724 73748 257 1.788043 4.59527051 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 115 1.55e-28   NR MFN4151019.1 2762020 g73567 i0 67.6 0.828793774319066 71 23 82.9 0 3 215 286 356 MFN4151019.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 213 115 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
28958860 28958860 PRJNA975724_S_NODE_85868_length_245_cov_1.343023_g85687_i0 PRJNA975724 85868 245 1.343023 3.29040635 Cyanophyceae 3028117 Bacteria Bacteria 51.6 2.64e-5   NR WP_162422319.1 2651157 g85687 i0 75 1.18775510204082 28 7 34.3 0 3 86 279 306 WP_162422319.1 UDP-glucuronic acid decarboxylase family protein [Myxacorys almedinensis] diamond 291 52 0.992307692307692 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Myxacorys Myxacorys almedinensis
29148478 29148478 PRJNA975724_S_NODE_22769_length_374_cov_2.445183_g22588_i0 PRJNA975724 22769 374 2.445183 9.14498442 Cyanothece 43988 Bacteria Bacteria 166 6.15e-50   NR HAG80897.1 2055765 g22588 i0 64.5 6.96256684491979 124 43 99.5 1 3 374 8 130 HAG80897.1 heat-shock protein [Cyanobacteria bacterium UBA12227] diamond 2604 166 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA12227
30126792 30126792 PRJNA975724_S_NODE_54192_length_289_cov_1.782407_g54011_i0 PRJNA975724 54192 289 1.782407 5.15115623 Cyanophyceae 3028117 Bacteria Bacteria 117 2.35e-30   NR WP_066378527.1 52271 g54011 i0 54.4 8.15916955017301 90 41 93.4 0 3 272 142 231 WP_066378527.1 TIGR04283 family arsenosugar biosynthesis glycosyltransferase [Anabaena sp. CA = ATCC 33047] diamond 2358 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. CA = ATCC 33047
31194645 31194645 PRJNA975724_S_NODE_80395_length_249_cov_2.068182_g80214_i0 PRJNA975724 80395 249 2.068182 5.14977318 unclassified Microcoleus 2642155 Bacteria Bacteria 65.9 2.71e-11   NR WP_293207554.1 2642155 g80214 i0 35.6 1.04819277108434 87 50 97.6 1 4 246 57 143 WP_293207554.1 MULTISPECIES: DUF6640 family protein [unclassified Microcoleus] diamond 261 65.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus  
31384960 31384960 PRJNA975724_S_NODE_66576_length_268_cov_1.184615_g66395_i0 PRJNA975724 66576 268 1.184615 3.1747682 Oscillatoriaceae cyanobacterium M33_DOE_052 2774340 Bacteria Bacteria 63.9 1.83e-9   NR HIK10929.1 2774340 g66395 i0 46.8 2.5634328358209 62 29 67.2 2 183 4 683 742 HIK10929.1 SBBP repeat-containing protein [Oscillatoriaceae cyanobacterium M33_DOE_052] diamond 687 63.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae   Oscillatoriaceae cyanobacterium M33_DOE_052
31732620 31732620 PRJNA975724_S_NODE_84417_length_246_cov_1.335260_g84236_i0 PRJNA975724 84417 246 1.33526 3.2847396 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 45.8 0.00298   NR MFN4151019.1 2762020 g84236 i0 67.9 0.341463414634146 28 9 34.1 0 11 94 191 218 MFN4151019.1 hypothetical protein [Candidatus Sericytochromatia bacterium] diamond 84 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
31833692 31833692 PRJNA975724_S_NODE_67417_length_266_cov_3.191710_g67236_i0 PRJNA975724 67417 266 3.19171 8.4899486 Planktothrix 54304 Bacteria Bacteria 66.2 1.33e-10   NR MBU6452548.1 2800110 g67236 i0 47.4 3.05639097744361 57 30 64.3 0 261 91 205 261 MBU6452548.1 alkaline phytoceramidase [Cyanobacteria bacterium REEB67] diamond 813 66.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
32270738 32270738 PRJNA975724_S_NODE_50838_length_296_cov_0.852018_g50657_i0 PRJNA975724 50838 296 0.852018 2.52197328 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 50.4 1.36e-4   NR HEY9756878.1 3088181 g50657 i0 36.5 0.972972972972973 96 54 93.2 3 21 296 113 205 HEY9756878.1 reverse transcriptase domain-containing protein [Oculatellaceae cyanobacterium] diamond 288 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
32397291 32397291 PRJNA975724_S_NODE_69979_length_262_cov_3.259259_g69798_i0 PRJNA975724 69979 262 3.259259 8.53925858 Oscillatoria sp. SIO1A7 2607767 Bacteria Bacteria 59.7 3.88e-8   NR NER37279.1 2607767 g69798 i0 41.5 1.48854961832061 65 38 74.4 0 259 65 226 290 NER37279.1 S-methyl-5'-thioadenosine phosphorylase [Oscillatoria sp. SIO1A7] diamond 390 59.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria sp. SIO1A7

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