RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA811237", tax_kingdom = "Bacillati" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 22 ✖

tax_kingdom 1

  • Bacillati · 22 ✖

bioproject 1

  • PRJNA811237 · 22 ✖
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
19935478 19935478 PRJNA811237_S_NODE_4556_length_339_cov_1.024138_g4316_i0 PRJNA811237 4556 339 1.024138 3.47182782 Annamia dubia NIES-4383 2759045 Bacteria Bacteria 105 8.05e-24   NR BDG64460.1 2759045 g4316 i0 50 1.98230088495575 112 56 99.1 0 3 338 594 705 BDG64460.1 hypothetical protein Anndu_18350 [Annamia dubia NIES-4383] diamond 672 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Annamia Annamia dubia
24175232 24175232 PRJNA811237_S_NODE_34119_length_162_cov_0.902655_g33879_i0 PRJNA811237 34119 162 0.902655 1.4623011 Hassallia 482629 Bacteria Bacteria 300 4.36e-77   NTclustered gi|1519336825|gb|MK211226.1| 2489140 g33879 i0 100 236.759259259259 162 0 100 0 1 162 2382 2221 Hassallia byssoidea KZ-2-2-3 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence blastn 38355 300 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Tolypothrichaceae Hassallia Hassallia byssoidea
27410984 27410984 PRJNA811237_S_NODE_14363_length_213_cov_1.243902_g14123_i0 PRJNA811237 14363 213 1.243902 2.64951126 Bacteria 2 Bacteria Bacteria 45.4 0.00278   NR WP_015148360.1 118323 g14123 i0 47.4 5.73239436619718 57 23 80.3 1 212 42 315 364 WP_015148360.1 heavy metal translocating P-type ATPase [Oscillatoria acuminata] diamond 1221 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria acuminata
27433694 27433694 PRJNA811237_S_NODE_18183_length_196_cov_1.387755_g17943_i0 PRJNA811237 18183 196 1.387755 2.7199998 Phormidium tenue 126344 Bacteria Bacteria 69.7 6.14e-12   NR MBD3881245.1 2692911 g17943 i0 45.3 0.979591836734694 64 35 98 0 2 193 348 411 MBD3881245.1 folate/biopterin family MFS transporter [Phormidium tenue FACHB-886] diamond 192 69.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium tenue
28001971 28001971 PRJNA811237_S_NODE_31325_length_164_cov_0.886957_g31085_i0 PRJNA811237 31325 164 0.886957 1.45460948 Okeania sp. SIO1I7 2607772 Bacteria Bacteria 62.8 1.08e-9   NR WP_293114881.1 2607772 g31085 i0 59.6 0.859756097560976 47 18 86 1 162 22 382 427 WP_293114881.1 cholesterol oxidase substrate-binding domain-containing protein [Okeania sp. SIO1I7] diamond 141 62.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO1I7
28096527 28096527 PRJNA811237_S_NODE_20425_length_188_cov_1.100719_g20185_i0 PRJNA811237 20425 188 1.100719 2.06935172 Richelia sp. SM2_1_7 2720465 Bacteria Bacteria 61.6 3.69e-9   NR NJL81556.1 2720465 g20185 i0 48.3 0.957446808510638 60 30 94.1 1 11 187 137 196 NJL81556.1 hypothetical protein [Richelia sp. SM2_1_7] diamond 180 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Richelia Richelia sp. SM2_1_7
28159873 28159873 PRJNA811237_S_NODE_13365_length_219_cov_0.900000_g13125_i0 PRJNA811237 13365 219 0.9 1.971 Cyanobacteria bacterium SZAS LIN-3 2807732 Bacteria Bacteria 71.2 2.32e-12   NR MBS1993531.1 2807732 g13125 i0 53.4 0.794520547945205 58 27 79.5 0 175 2 4 61 MBS1993531.1 putrescine aminotransferase [Cyanobacteria bacterium SZAS LIN-3] diamond 174 71.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS LIN-3
28191032 28191032 PRJNA811237_S_NODE_26146_length_170_cov_1.454545_g25906_i0 PRJNA811237 26146 170 1.454545 2.4727265 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 57 1.27e-7   NR HEY9667823.1 3081323 g25906 i0 66.7 1.30588235294118 39 13 68.8 0 52 168 4 42 HEY9667823.1 DnaJ domain-containing protein [Coleofasciculaceae cyanobacterium] diamond 222 57 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
28421308 28421308 PRJNA811237_S_NODE_31966_length_164_cov_0.886957_g31726_i0 PRJNA811237 31966 164 0.886957 1.45460948 Bacillati 1783272 Bacteria Bacteria 45.8 0.00101   NR WP_280657229.1 75695 g31726 i0 44.2 1.66463414634146 52 23 84.1 1 141 4 72 123 WP_280657229.1 peptidoglycan-binding protein [Umezakia ovalisporum] diamond 273 45.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Umezakia Umezakia ovalisporum
28854155 28854155 PRJNA811237_S_NODE_31788_length_164_cov_0.886957_g31548_i0 PRJNA811237 31788 164 0.886957 1.45460948 Synechococcales cyanobacterium 2478492 Bacteria Bacteria 70.1 1.73e-12   NR MEB3293718.1 2478492 g31548 i0 57.7 1.82926829268293 52 20 91.5 1 13 162 4 55 MEB3293718.1 alpha/beta hydrolase-fold protein [Synechococcales cyanobacterium] diamond 300 70.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales     Synechococcales cyanobacterium
28949288 28949288 PRJNA811237_S_NODE_8028_length_265_cov_1.361111_g7788_i0 PRJNA811237 8028 265 1.361111 3.60694415 Synechococcus sp. 1G1 1131 Bacteria Bacteria 41.2 0.0296   NR WP_094555144.1 2025605 g7788 i0 37.5 0.724528301886792 64 37 69.1 1 33 215 16 79 WP_094555144.1 hypothetical protein [Synechococcus sp. 1G10] diamond 192 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. 1G10
28989683 28989683 PRJNA811237_S_NODE_12148_length_226_cov_1.440678_g11908_i0 PRJNA811237 12148 226 1.440678 3.25593228 Bacteria 2 Bacteria Bacteria 134 2.35e-34   NR MBS2009294.1 2807730 g11908 i0 75.7 2.89380530973451 74 18 98.2 0 224 3 462 535 MBS2009294.1 5-histidylcysteine sulfoxide synthase [Cyanobacteria bacterium SZAS TMP-1] diamond 654 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium SZAS TMP-1
29043929 29043929 PRJNA811237_S_NODE_3368_length_394_cov_2.663768_g3128_i0 PRJNA811237 3368 394 2.663768 10.49524592 Symploca sp. SIO2E6 2607809 Bacteria Bacteria 75.9 1.19e-13   NR NET60595.1 2607809 g3128 i0 42.3 0.791878172588833 104 56 79.2 2 324 13 114 213 NET60595.1 CAP domain-containing protein [Symploca sp. SIO2E6] diamond 312 75.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Symploca Symploca sp. SIO2E6
29422443 29422443 PRJNA811237_S_NODE_31109_length_164_cov_1.226087_g30869_i0 PRJNA811237 31109 164 1.226087 2.01078268 Phormidium sp. CCY1219 2886104 Bacteria Bacteria 42.4 0.0178   NR WP_324632720.1 2886104 g30869 i0 55.3 0.859756097560976 47 20 84.1 1 6 143 148 194 WP_324632720.1 CHAT domain-containing protein [Phormidium sp. CCY1219] diamond 141 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium sp. CCY1219
30054075 30054075 PRJNA811237_S_NODE_231_length_1354_cov_6.971648_g104_i0 PRJNA811237 231 1354 6.971648 94.39611392 Nostoc cycadae 246795 Bacteria Bacteria 79 1.78e-12   NR WP_245894956.1 246795 g104 i0 32 0.429837518463811 194 115 40.5 5 26 574 50 237 WP_245894956.1 CAP domain-containing protein [Nostoc cycadae] diamond 582 79 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc cycadae
30559556 30559556 PRJNA811237_S_NODE_6253_length_295_cov_1.463415_g6013_i0 PRJNA811237 6253 295 1.463415 4.31707425 Pleurocapsa minor 54308 Bacteria Bacteria 98.2 2e-21   NR MBW4437514.1 2839663 g6013 i0 50.5 2.73559322033898 95 47 96.6 0 8 292 103 197 MBW4437514.1 glycosyltransferase [Pleurocapsa minor GSE-CHR-MK 17-07R] diamond 807 98.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa minor
30780933 30780933 PRJNA811237_S_NODE_8514_length_259_cov_1.214286_g8274_i0 PRJNA811237 8514 259 1.214286 3.14500074 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 140 1.04e-38   NR MBX9694561.1 2847862 g8274 i0 76.7 0.996138996138996 86 20 99.6 0 258 1 227 312 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 258 140 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31096796 31096796 PRJNA811237_S_NODE_25915_length_171_cov_1.114754_g25675_i0 PRJNA811237 25915 171 1.114754 1.90622934 Symploca sp. SIO2G7 2607798 Bacteria Bacteria 45.4 0.00156   NR NEP56870.1 2607798 g25675 i0 52.5 0.701754385964912 40 16 70.2 1 50 169 8 44 NEP56870.1 hypothetical protein [Symploca sp. SIO2G7] diamond 120 45.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Symploca Symploca sp. SIO2G7
31105582 31105582 PRJNA811237_S_NODE_34015_length_162_cov_0.902655_g33775_i0 PRJNA811237 34015 162 0.902655 1.4623011 root 1 Root_unresolved Root_unresolved 88.6 8.28e-19   NR WP_019504331.1 118161 g33775 i0 81.1 20.5925925925926 53 10 98.1 0 3 161 208 260 WP_019504331.1 Re/Si-specific NAD(P)(+) transhydrogenase subunit alpha [Pleurocapsa sp. PCC 7319] diamond 3336 88.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Pleurocapsa Pleurocapsa sp. PCC 7319
31349947 31349947 PRJNA811237_S_NODE_9896_length_244_cov_1.292308_g9656_i0 PRJNA811237 9896 244 1.292308 3.15323152 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 111 1.53e-27   NR MBX9694561.1 2847862 g9656 i0 71.1 0.934426229508197 76 21 92.2 1 227 3 84 159 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 228 111 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31453678 31453678 PRJNA811237_S_NODE_4276_length_351_cov_1.572848_g4036_i0 PRJNA811237 4276 351 1.572848 5.52069648 Symploca 105591 Bacteria Bacteria 82.8 1.15e-15   NR NER96649.1 2607763 g4036 i0 45.7 1.60683760683761 94 51 80.3 0 61 342 67 160 NER96649.1 urea transporter [Symploca sp. SIO1B1] diamond 564 82.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Symploca Symploca sp. SIO1B1
31508129 31508129 PRJNA811237_S_NODE_24976_length_173_cov_3.201613_g24736_i0 PRJNA811237 24976 173 3.201613 5.53879049 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 60.1 1.1e-8   NR MEY3867947.1 2847862 g24736 i0 53.8 0.901734104046243 52 24 90.2 0 15 170 627 678 MEY3867947.1 hypothetical protein [Cyanobacteriota bacterium] diamond 156 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium

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