RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 22 ✖

bioproject 1

  • PRJNA438572 · 22 ✖

analysis 1

  • diamond · 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
5538654 5538654 PRJNA438572_P_NODE_1605_length_751_cov_2.912979_g1501_i0 PRJNA438572 1605 751 2.912979 21.87647229 Cyanothece 43988 Bacteria Bacteria 226 1.34e-71   NR NEQ95720.1 2607797 g1501 i0 70.9 3.54727030625832 148 43 59.1 0 70 513 2 149 NEQ95720.1 nucleoside-diphosphate kinase [Cyanothece sp. SIO2G6] diamond 2664 228 0.991228070175439 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Cyanothecaceae Cyanothece Cyanothece sp. SIO2G6
10638993 10638993 PRJNA438572_P_NODE_3209_length_549_cov_3.415966_g3091_i0 PRJNA438572 3209 549 3.415966 18.75365334 Gloeobacter morelensis 2907343 Bacteria Bacteria 200 1.62e-62   NR WP_230840127.1 2907343 g3091 i0 67.3 4.07650273224044 147 48 80.3 0 503 63 2 148 WP_230840127.1 nucleoside-diphosphate kinase [Gloeobacter morelensis] diamond 2238 200 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gloeobacterales Gloeobacteraceae Gloeobacter Gloeobacter morelensis
20217258 20217258 PRJNA438572_P_NODE_22856_length_244_cov_0.912281_g22737_i0 PRJNA438572 22856 244 0.912281 2.22596564 Okeania sp. KiyG1 2720165 Bacteria Bacteria 165 2.81e-48   NR WP_202223773.1 2720165 g22737 i0 98.8 4.97950819672131 81 1 99.6 0 2 244 83 163 WP_202223773.1 RluA family pseudouridine synthase [Okeania sp. KiyG1] diamond 1215 165 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. KiyG1
27138827 27138827 PRJNA438572_P_NODE_9782_length_327_cov_1.228346_g9663_i0 PRJNA438572 9782 327 1.228346 4.01669142 Annamia dubia NIES-4383 2759045 Bacteria Bacteria 43.5 0.046   NR BDG65086.1 2759045 g9663 i0 43.6 0.357798165137615 39 22 35.8 0 171 55 48 86 BDG65086.1 hypothetical protein Anndu_24610 [Annamia dubia NIES-4383] diamond 117 43.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Annamia Annamia dubia
27865534 27865534 PRJNA438572_P_NODE_18865_length_250_cov_0.881356_g18746_i0 PRJNA438572 18865 250 0.881356 2.20339 Aliterella atlantica 1827278 Bacteria Bacteria 52 1.94e-5   NR WP_045054900.1 1827278 g18746 i0 92.6 0.636 27 2 32.4 0 248 168 273 299 WP_045054900.1 SDR family NAD(P)-dependent oxidoreductase [Aliterella atlantica] diamond 159 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
28055013 28055013 PRJNA438572_P_NODE_23005_length_244_cov_0.912281_g22886_i0 PRJNA438572 23005 244 0.912281 2.22596564 Oculatellaceae cyanobacterium Prado106 2929566 Bacteria Bacteria 80.1 2.63e-15   NR MCU0568319.1 2929566 g22886 i0 53.3 0.922131147540984 75 35 92.2 0 19 243 53 127 MCU0568319.1 hypothetical protein [Oculatellaceae cyanobacterium Prado106] diamond 225 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium Prado106
28307798 28307798 PRJNA438572_P_NODE_4946_length_446_cov_1.898123_g4827_i0 PRJNA438572 4946 446 1.898123 8.46562858 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 82.4 1.25e-16   NR MDY7014335.1 2847862 g4827 i0 37.9 0.94170403587444 140 84 93.5 2 24 440 17 154 MDY7014335.1 hypothetical protein [Cyanobacteriota bacterium] diamond 420 82.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29191915 29191915 PRJNA438572_P_NODE_21749_length_246_cov_0.901734_g21630_i0 PRJNA438572 21749 246 0.901734 2.21826564 Nostoc sp. CENA543 1869241 Bacteria Bacteria 55.8 9.08e-7   NR WP_103136775.1 1869241 g21630 i0 50.9 2.3780487804878 53 26 64.6 0 162 4 215 267 WP_103136775.1 tetratricopeptide repeat protein [Nostoc sp. CENA543] diamond 585 55.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CENA543
29223539 29223539 PRJNA438572_P_NODE_12989_length_287_cov_1.242991_g12870_i0 PRJNA438572 12989 287 1.242991 3.56738417 Hydrocoleum sp. CS-953 1671698 Bacteria Bacteria 184 3.73e-52   NR WP_094671205.1 1671698 g12870 i0 86.3 2.97909407665505 95 13 99.3 0 286 2 503 597 WP_094671205.1 molybdopterin oxidoreductase family protein [Hydrocoleum sp. CS-953] diamond 855 184 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Hydrocoleum Hydrocoleum sp. CS-953
29444140 29444140 PRJNA438572_P_NODE_21250_length_247_cov_0.873563_g21131_i0 PRJNA438572 21250 247 0.873563 2.15770061 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 132 1.4e-33   NR WP_233220837.1 2107693 g21131 i0 79 1.96761133603239 81 17 98.4 0 3 245 246 326 WP_233220837.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Chlorogloea sp. CCALA 695] diamond 486 132 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
29444150 29444150 PRJNA438572_P_NODE_4610_length_459_cov_2.020725_g4491_i0 PRJNA438572 4610 459 2.020725 9.27512775 Pseudanabaenaceae cyanobacterium bins.39 2971805 Bacteria Bacteria 70.9 3.21e-12   NR MDX2254595.1 2971805 g4491 i0 36.8 3.69281045751634 144 67 83 4 77 457 1 137 MDX2254595.1 universal stress protein [Pseudanabaenaceae cyanobacterium bins.39] diamond 1695 70.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium bins.39
30202134 30202134 PRJNA438572_P_NODE_22192_length_245_cov_0.906977_g22073_i0 PRJNA438572 22192 245 0.906977 2.22209365 Moorena producens 1155739 Bacteria Bacteria 85.9 1.21e-17   NR WP_071103261.1 1155739 g22073 i0 51.9 0.991836734693878 81 35 98 2 6 245 182 259 WP_071103261.1 FG-GAP repeat domain-containing protein [Moorena producens] diamond 243 85.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena producens
30218593 30218593 PRJNA438572_P_NODE_15112_length_268_cov_1.087179_g14993_i0 PRJNA438572 15112 268 1.087179 2.91363972 Microcoleaceae 1892252 Bacteria Bacteria 109 1.98e-25   NR WP_094671829.1 1671698 g14993 i0 56.2 1.99253731343284 89 39 99.6 0 268 2 46 134 WP_094671829.1 EAL domain-containing protein, partial [Hydrocoleum sp. CS-953] diamond 534 109 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Hydrocoleum Hydrocoleum sp. CS-953
30486826 30486826 PRJNA438572_P_NODE_20493_length_248_cov_0.891429_g20374_i0 PRJNA438572 20493 248 0.891429 2.21074392 Crinalium sp. 3088173 Bacteria Bacteria 91.3 3.17e-19   NR HEY9622064.1 3088173 g20374 i0 62.2 0.895161290322581 74 27 89.5 1 223 2 433 505 HEY9622064.1 family 1 glycosylhydrolase [Crinalium sp.] diamond 222 91.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Crinalium Crinalium sp.
30581287 30581287 PRJNA438572_P_NODE_19933_length_249_cov_0.880682_g19814_i0 PRJNA438572 19933 249 0.880682 2.19289818 Nostoc sp. C3-bin3 2769069 Bacteria Bacteria 155 6.96e-44   NR MBD0390070.1 2769069 g19814 i0 96.3 0.987951807228916 82 3 98.8 0 2 247 140 221 MBD0390070.1 adenylate/guanylate cyclase domain-containing protein [Nostoc sp. C3-bin3] diamond 246 155 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. C3-bin3
30802672 30802672 PRJNA438572_P_NODE_15134_length_267_cov_1.984536_g15015_i0 PRJNA438572 15134 267 1.984536 5.29871112 Leptolyngbya sp. FACHB-261 2692806 Bacteria Bacteria 65.5 4.77e-10   NR WP_190800488.1 2692806 g15015 i0 43.9 2.92134831460674 82 46 92.1 0 3 248 309 390 WP_190800488.1 N-acetylmuramoyl-L-alanine amidase [Leptolyngbya sp. FACHB-261] diamond 780 65.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-261
30945497 30945497 PRJNA438572_P_NODE_17134_length_253_cov_0.866667_g17015_i0 PRJNA438572 17134 253 0.866667 2.19266751 root 1 Root_unresolved Root_unresolved 68.6 3.36e-11   NR MEB3268269.1 47254 g17015 i0 38.6 13.7905138339921 83 51 98.4 0 1 249 299 381 MEB3268269.1 folate/biopterin family MFS transporter [Leptolyngbya sp.] diamond 3489 68.9 0.995645863570392 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp.
31055782 31055782 PRJNA438572_P_NODE_3055_length_561_cov_2.940574_g2937_i0 PRJNA438572 3055 561 2.940574 16.49662014 Coleofasciculus chthonoplastes 64178 Bacteria Bacteria 71.6 9.97e-12   NR WP_006099189.1 64178 g2937 i0 55.2 1.86096256684492 58 26 31 0 396 223 48 105 WP_006099189.1 NADPH-dependent FMN reductase [Coleofasciculus chthonoplastes] diamond 1044 71.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus chthonoplastes
31339914 31339914 PRJNA438572_P_NODE_15576_length_264_cov_0.994764_g15457_i0 PRJNA438572 15576 264 0.994764 2.62617696 Cyanobacteria bacterium UBA11372 2055768 Bacteria Bacteria 44.7 0.0103   NR HAX77374.1 2055768 g15457 i0 43.2 0.5 44 25 50 0 1 132 18 61 HAX77374.1 hypothetical protein [Cyanobacteria bacterium UBA11372] diamond 132 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11372
31687823 31687823 PRJNA438572_P_NODE_17817_length_252_cov_0.871508_g17698_i0 PRJNA438572 17817 252 0.871508 2.19620016 Phormidium yuhuli 2974039 Bacteria Bacteria 125 2.52e-33   NR WP_252664073.1 2974039 g17698 i0 70.7 1.95238095238095 82 24 97.6 0 7 252 24 105 WP_252664073.1 phosphoadenosine phosphosulfate reductase [Phormidium yuhuli] diamond 492 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium yuhuli
31719525 31719525 PRJNA438572_P_NODE_21437_length_246_cov_0.901734_g21318_i0 PRJNA438572 21437 246 0.901734 2.21826564 Okeania sp. SIO3I5 2607805 Bacteria Bacteria 82.8 6.09e-17   NR WP_293131241.1 2607805 g21318 i0 94.6 1.35365853658537 37 2 45.1 0 111 1 1 37 WP_293131241.1 HAD family hydrolase [Okeania sp. SIO3I5] diamond 333 82.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO3I5
32099106 32099106 PRJNA438572_P_NODE_2518_length_617_cov_3.422794_g2402_i0 PRJNA438572 2518 617 3.422794 21.11863898 Synechococcus sp. CPC35 2024880 Bacteria Bacteria 146 2.0099999999999998e-40   NR MAB55741.1 2024880 g2402 i0 59.6 33.9432739059968 146 54 69.5 2 18 446 55 198 MAB55741.1 hypothetical protein [Synechococcus sp. CPC35] diamond 20943 147 0.993197278911565 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. CPC35

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