RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1158727 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
9231134 9231134 PRJNA1158727_P_NODE_103288_length_288_cov_1.251163_g95827_i0 PRJNA1158727 103288 288 1.251163 3.60334944 Microseira 1609595 Bacteria Bacteria 191 6.089999999999998e-54   NR WP_226592904.1 467598 g95827 i0 99 2 96 1 100 0 288 1 745 840 WP_226592904.1 peptidase domain-containing ABC transporter [Microseira wollei] diamond 576 192 0.994791666666667 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Aerosakkonematales Aerosakkonemataceae Microseira Microseira wollei
15606233 15606233 PRJNA1158727_P_NODE_116793_length_271_cov_1.474747_g109332_i0 PRJNA1158727 116793 271 1.474747 3.99656437 Richelia sp. RM2_1_2 2720436 Bacteria Bacteria 79 3.27e-16   NR NJO63435.1 2720436 g109332 i0 51.1 0.996309963099631 90 38 99.6 3 271 2 14 97 NJO63435.1 NUDIX domain-containing protein [Richelia sp. RM2_1_2] diamond 270 79 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Richelia Richelia sp. RM2_1_2
24530016 24530016 PRJNA1158727_P_NODE_144320_length_248_cov_0.880000_g136858_i0 PRJNA1158727 144320 248 0.88 2.1824 Aliterella atlantica 1827278 Bacteria Bacteria 145 2.71e-40   NR WP_045053065.1 1827278 g136858 i0 87.8 0.991935483870968 82 10 99.2 0 1 246 79 160 WP_045053065.1 anthranilate phosphoribosyltransferase family protein [Aliterella atlantica] diamond 246 145 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
26806519 26806519 PRJNA1158727_P_NODE_135361_length_251_cov_0.865169_g127899_i0 PRJNA1158727 135361 251 0.865169 2.17157419 Bacillati 1783272 Bacteria Bacteria 43.5 0.00985   NR NDE38816.1 2461364 g127899 i0 54.8 1.55378486055777 42 19 50.2 0 127 2 18 59 NDE38816.1 hypothetical protein [Synechococcaceae bacterium WBA_2_066] diamond 390 43.9 0.990888382687927 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae bacterium WBA_2_066
26850638 26850638 PRJNA1158727_P_NODE_115881_length_272_cov_1.547739_g108420_i0 PRJNA1158727 115881 272 1.547739 4.20985008 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 175 5.089999999999999e-52   NR HEY9782601.1 3088178 g108420 i0 96.7 1.98529411764706 90 2 99.3 1 3 272 191 279 HEY9782601.1 PstS family phosphate ABC transporter substrate-binding protein [Leptolyngbyaceae cyanobacterium] diamond 540 175 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
27134754 27134754 PRJNA1158727_P_NODE_104722_length_286_cov_1.446009_g97261_i0 PRJNA1158727 104722 286 1.446009 4.13558574 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 172 6.349999999999999e-52   NR MBA4075678.1 2067979 g97261 i0 90.5 0.996503496503496 95 9 99.7 0 286 2 48 142 MBA4075678.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 285 172 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
27786441 27786441 PRJNA1158727_P_NODE_139264_length_250_cov_0.870056_g131802_i0 PRJNA1158727 139264 250 0.870056 2.17514 Coleofasciculaceae 1892251 Bacteria Bacteria 50.4 6.55e-5   NR WP_044210526.1 64178 g131802 i0 63.6 1.068 33 12 39.6 0 150 248 4 36 WP_044210526.1 ABC transporter permease [Coleofasciculus chthonoplastes] diamond 267 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus chthonoplastes
27818017 27818017 PRJNA1158727_P_NODE_135844_length_251_cov_0.865169_g128382_i0 PRJNA1158727 135844 251 0.865169 2.17157419 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 63.2 2.66e-9   NR WP_099700634.1 2049454 g128382 i0 60.4 3.1195219123506 53 21 63.3 0 3 161 70 122 WP_099700634.1 FG-GAP repeat protein [Gloeocapsopsis sp. IPPAS B-1203] diamond 783 63.5 0.995275590551181 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsopsis Gloeocapsopsis sp. IPPAS B-1203
29554212 29554212 PRJNA1158727_P_NODE_160530_length_242_cov_0.911243_g153068_i0 PRJNA1158727 160530 242 0.911243 2.20520806 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 59.7 9.67e-10   NR WP_054466059.1 132607 g153068 i0 50 3.24793388429752 60 29 74.4 1 236 57 7 65 WP_054466059.1 MULTISPECIES: hypothetical protein [Planktothricoides] diamond 786 59.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Planktothricoides  
29850899 29850899 PRJNA1158727_P_NODE_111391_length_278_cov_1.121951_g103930_i0 PRJNA1158727 111391 278 1.121951 3.11902378 Synechocystis sp. B12 2764086 Bacteria Bacteria 42.7 0.0475   NR WLT40268.1 2764086 g103930 i0 29.6 0.58273381294964 54 38 58.3 0 95 256 131 184 WLT40268.1 hypothetical protein NON20_23675 [Synechocystis sp. B12] diamond 162 42.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. B12
29977105 29977105 PRJNA1158727_P_NODE_108571_length_281_cov_1.480769_g101110_i0 PRJNA1158727 108571 281 1.480769 4.16096089 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 154 5.42e-46   NR HCF25636.1 2055787 g101110 i0 87.1 0.99288256227758 93 12 99.3 0 3 281 35 127 HCF25636.1 biopolymer transporter ExbD [Cyanobacteria bacterium UBA11049] diamond 279 154 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
30388326 30388326 PRJNA1158727_P_NODE_164933_length_237_cov_2.817073_g157471_i0 PRJNA1158727 164933 237 2.817073 6.67646301 Pseudanabaena biceps 927669 Bacteria Bacteria 46.2 0.00208   NR NUN66916.1 927669 g157471 i0 48.8 0.518987341772152 41 21 51.9 0 237 115 92 132 NUN66916.1 relaxase/mobilization nuclease domain-containing protein [Pseudanabaena biceps] diamond 123 46.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena biceps
31114372 31114372 PRJNA1158727_P_NODE_124515_length_262_cov_1.629630_g117054_i0 PRJNA1158727 124515 262 1.62963 4.2696306 Cyanobacteria bacterium PR.3.49 2067978 Bacteria Bacteria 137 4.44e-40   NR MBA3858196.1 2067978 g117054 i0 87.7 0.83587786259542 73 9 83.6 0 220 2 1 73 MBA3858196.1 hypothetical protein [Cyanobacteria bacterium PR.3.49] diamond 219 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.3.49
31335778 31335778 PRJNA1158727_P_NODE_154056_length_244_cov_0.900585_g146594_i0 PRJNA1158727 154056 244 0.900585 2.1974274 Drouetiella sp. 3088174 Bacteria Bacteria 118 1.11e-28   NR HEY9730308.1 3088174 g146594 i0 74.1 0.995901639344262 81 21 99.6 0 244 2 138 218 HEY9730308.1 ATP-binding protein [Drouetiella sp.] diamond 243 118 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Drouetiella Drouetiella sp.
31450275 31450275 PRJNA1158727_P_NODE_164516_length_239_cov_3.126506_g157054_i0 PRJNA1158727 164516 239 3.126506 7.47234934 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 54.7 2.13e-6   NR WP_193925692.1 945768 g157054 i0 70.6 2.86192468619247 34 10 42.7 0 133 234 5 38 WP_193925692.1 circadian clock protein KaiC [Plectonema radiosum] diamond 684 55.1 0.992740471869329 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Plectonema Plectonema radiosum
31620518 31620518 PRJNA1158727_P_NODE_119356_length_268_cov_1.482051_g111895_i0 PRJNA1158727 119356 268 1.482051 3.97189668 Cyanomargarita calcarea 1982362 Bacteria Bacteria 42.4 0.0343   NR MBW4670816.1 2839659 g111895 i0 34.4 0.682835820895522 61 38 68.3 1 209 27 17 75 MBW4670816.1 hypothetical protein [Cyanomargarita calcarea GSE-NOS-MK-12-04C] diamond 183 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Cyanomargaritaceae Cyanomargarita Cyanomargarita calcarea
31841783 31841783 PRJNA1158727_P_NODE_139877_length_249_cov_1.545455_g132415_i0 PRJNA1158727 139877 249 1.545455 3.84818295 Sphaerospermopsis sp. 3100406 Bacteria Bacteria 103 6.910000000000001e-27   NR MEB3148512.1 3100406 g132415 i0 98 1.20481927710843 50 1 60.2 0 1 150 19 68 MEB3148512.1 hypothetical protein [Sphaerospermopsis sp.] diamond 300 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Sphaerospermopsis Sphaerospermopsis sp.
31873544 31873544 PRJNA1158727_P_NODE_106957_length_283_cov_1.466667_g99496_i0 PRJNA1158727 106957 283 1.466667 4.15066761 Leptolyngbya sp. FACHB-541 2692810 Bacteria Bacteria 101 1.18e-22   NR WP_190797464.1 2692810 g99496 i0 57.1 2.93639575971731 91 38 96.5 1 281 9 550 639 WP_190797464.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Leptolyngbya sp. FACHB-541] diamond 831 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-541
32367798 32367798 PRJNA1158727_P_NODE_154479_length_244_cov_0.900585_g147017_i0 PRJNA1158727 154479 244 0.900585 2.1974274 Crocosphaera 263510 Bacteria Bacteria 44.3 0.00621   NR WP_339390355.1 263511 g147017 i0 36.4 2.8155737704918 77 43 87.3 3 239 27 92 168 WP_339390355.1 hypothetical protein, partial [Crocosphaera watsonii] diamond 687 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera Crocosphaera watsonii
32683291 32683291 PRJNA1158727_P_NODE_146760_length_247_cov_0.885057_g139298_i0 PRJNA1158727 146760 247 0.885057 2.18609079 Cyanophyceae 3028117 Bacteria Bacteria 157 1.81e-44   NR WP_293229252.1 2798816 g139298 i0 95.1 2.98785425101215 82 4 99.6 0 247 2 8 89 WP_293229252.1 Fic family protein [Microcoleus sp. PH2017_05_CCC_O_A] diamond 738 157 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. PH2017_05_CCC_O_A
32821548 32821548 PRJNA1158727_P_NODE_111780_length_277_cov_1.509804_g104319_i0 PRJNA1158727 111780 277 1.509804 4.18215708 Aliterella atlantica 1827278 Bacteria Bacteria 92.8 1.3100000000000002e-21   NR WP_045054872.1 1827278 g104319 i0 88.9 0.584837545126354 54 6 58.5 0 99 260 1 54 WP_045054872.1 salt stress protein, Slr1339 family [Aliterella atlantica] diamond 162 92.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica

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