RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA495391" 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 · 23 ✖

bioproject 1

  • PRJNA495391 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
27108361 27108361 PRJNA495391_S_NODE_57942_length_164_cov_0.914729_g56890_i0 PRJNA495391 57942 164 0.914729 1.50015556 Allocoleopsis sp. 3088169 Bacteria Bacteria 69.7 3.89e-12   NR WP_333480377.1 3088169 g56890 i0 66.7 0.823170731707317 45 15 82.3 0 4 138 420 464 WP_333480377.1 IS1182 family transposase [Allocoleopsis sp.] diamond 135 69.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis sp.
27266646 27266646 PRJNA495391_S_NODE_47683_length_179_cov_1.104167_g46631_i0 PRJNA495391 47683 179 1.104167 1.97645893 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 122 2.72e-33   NR WP_009630113.1 927677 g46631 i0 94.9 4.94413407821229 59 3 98.9 0 178 2 95 153 WP_009630113.1 IS630 family transposase [Synechocystis sp. PCC 7509] diamond 885 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
27298243 27298243 PRJNA495391_S_NODE_12283_length_342_cov_1.990228_g11231_i0 PRJNA495391 12283 342 1.990228 6.80657976 Okeania sp. SIO3B3 2607804 Bacteria Bacteria 167 3.6799999999999996e-47   NR NEP82436.1 2607804 g11231 i0 65.8 2.06140350877193 120 32 99.1 2 341 3 222 339 NEP82436.1 hypothetical protein [Okeania sp. SIO3B3] diamond 705 167 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO3B3
27298291 27298291 PRJNA495391_S_NODE_68003_length_153_cov_1.347458_g66951_i0 PRJNA495391 68003 153 1.347458 2.06161074 Leptolyngbya sp. Cla-17 2803751 Bacteria Bacteria 90.1 2.7800000000000003e-21   NR WP_171575850.1 2803751 g66951 i0 86.3 2 51 5 100 1 153 1 16 64 WP_171575850.1 transposase [Leptolyngbya sp. Cla-17] diamond 306 90.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. Cla-17
27329993 27329993 PRJNA495391_S_NODE_52123_length_171_cov_2.911765_g51071_i0 PRJNA495391 52123 171 2.911765 4.97911815 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 119 5.87e-32   NR WP_250121472.1 155894 g51071 i0 96.5 2 57 2 100 0 171 1 140 196 WP_250121472.1 IS1 family transposase [Chroococcidiopsis sp. CCMEE 29] diamond 342 119 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
27582424 27582424 PRJNA495391_S_NODE_56904_length_165_cov_1.500000_g55852_i0 PRJNA495391 56904 165 1.5 2.475 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 107 2.6799999999999998e-25   NR WP_199192199.1 2107693 g55852 i0 100 1 55 0 100 0 1 165 143 197 WP_199192199.1 mechanosensitive ion channel [Chlorogloea sp. CCALA 695] diamond 165 107 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
27709243 27709243 PRJNA495391_S_NODE_53244_length_170_cov_1.555556_g52192_i0 PRJNA495391 53244 170 1.555556 2.6444452 Nostocales cyanobacterium LE14-WE12 3030683 Bacteria Bacteria 52 5.23e-6   NR MDJ0504168.1 3030683 g52192 i0 42.9 1.97647058823529 56 29 98.8 2 170 3 16 68 MDJ0504168.1 HNH endonuclease [Nostocales cyanobacterium LE14-WE12] diamond 336 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales     Nostocales cyanobacterium LE14-WE12
27740704 27740704 PRJNA495391_S_NODE_9924_length_383_cov_2.617816_g8872_i0 PRJNA495391 9924 383 2.617816 10.02623528 Stigonema ocellatum 221293 Bacteria Bacteria 44.7 0.0326   NR MBR8836570.1 221294 g8872 i0 44.2 0.838120104438642 52 28 40.7 1 177 22 60 110 MBR8836570.1 hypothetical protein [Stigonema ocellatum SAG 48.90 = DSM 106950] diamond 321 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Stigonemataceae Stigonema Stigonema ocellatum
27993091 27993091 PRJNA495391_S_NODE_9825_length_385_cov_2.937143_g8773_i0 PRJNA495391 9825 385 2.937143 11.30800055 Cyanothece sp. SIO2G6 2607797 Bacteria Bacteria 68.9 1.11e-10   NR NEQ96500.1 2607797 g8773 i0 35 1.09090909090909 140 74 95.8 5 1 369 141 280 NEQ96500.1 hypothetical protein [Cyanothece sp. SIO2G6] diamond 420 68.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Cyanothecaceae Cyanothece Cyanothece sp. SIO2G6
28119155 28119155 PRJNA495391_S_NODE_28245_length_227_cov_2.078125_g27193_i0 PRJNA495391 28245 227 2.078125 4.71734375 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 58.9 6e-8   NR MBT9547365.1 2762020 g27193 i0 46.1 1.75770925110132 76 40 99.1 1 226 2 156 231 MBT9547365.1 thioester reductase domain-containing protein [Candidatus Sericytochromatia bacterium] diamond 399 58.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
28324120 28324120 PRJNA495391_S_NODE_28546_length_226_cov_1.910995_g27494_i0 PRJNA495391 28546 226 1.910995 4.3188487 Bacillati 1783272 Bacteria Bacteria 53.9 2.02e-6   NR HMP52588.1 2052166 g27494 i0 48.8 1.08849557522124 41 18 50.4 1 222 109 62 102 HMP52588.1 hypothetical protein [Candidatus Melainabacteria bacterium] diamond 246 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
28561413 28561413 PRJNA495391_S_NODE_51967_length_172_cov_1.270073_g50915_i0 PRJNA495391 51967 172 1.270073 2.18452556 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 114 5.68e-28   NR WP_106369763.1 2107693 g50915 i0 98.2 3.97674418604651 57 1 99.4 0 2 172 507 563 WP_106369763.1 scytonemin biosynthesis protein ScyA [Chlorogloea sp. CCALA 695] diamond 684 114 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
28813605 28813605 PRJNA495391_S_NODE_40548_length_192_cov_4.146497_g39496_i0 PRJNA495391 40548 192 4.146497 7.96127424 Prochlorothrix sp. 54309 Bacteria Bacteria 44.3 0.00319   NR MEB3273019.1 54309 g39496 i0 64.3 0.4375 28 10 43.8 0 173 90 99 126 MEB3273019.1 GNAT family N-acetyltransferase [Prochlorothrix sp.] diamond 84 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Prochlorotrichales Prochlorotrichaceae Prochlorothrix Prochlorothrix sp.
28940360 28940360 PRJNA495391_S_NODE_33028_length_212_cov_1.435028_g31976_i0 PRJNA495391 33028 212 1.435028 3.04225936 Dulcicalothrix desertica 32056 Bacteria Bacteria 52 1.32e-5   NR WP_127081281.1 32056 g31976 i0 52.6 1.07547169811321 38 18 53.8 0 16 129 148 185 WP_127081281.1 hypothetical protein [Dulcicalothrix desertica] diamond 228 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Dulcicalothrix Dulcicalothrix desertica
29982203 29982203 PRJNA495391_S_NODE_61031_length_160_cov_1.592000_g59979_i0 PRJNA495391 61031 160 1.592 2.5472 Leptolyngbya sp. NIES-21 47254 Bacteria Bacteria 97.8 2.45e-24   NR WP_058999196.1 1552121 g59979 i0 86.5 0.975 52 7 97.5 0 158 3 14 65 WP_058999196.1 ester cyclase [Leptolyngbya sp. NIES-2104] diamond 156 97.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. NIES-2104
30519323 30519323 PRJNA495391_S_NODE_42693_length_188_cov_1.594771_g41641_i0 PRJNA495391 42693 188 1.594771 2.99816948 Johanseniella sp. A1345 380087 Bacteria Bacteria 57 1.44e-7   NR ABN12951.1 380087 g41641 i0 43.5 0.98936170212766 62 35 98.9 0 2 187 23 84 ABN12951.1 hypothetical protein [Johanseniella sp. A1345] diamond 186 57 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Johanseniella Johanseniella sp. A1345
30708795 30708795 PRJNA495391_S_NODE_67914_length_153_cov_1.491525_g66862_i0 PRJNA495391 67914 153 1.491525 2.28203325 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 96.3 4.41e-22   NR WP_009631720.1 927677 g66862 i0 93.9 2.88235294117647 49 3 96.1 0 149 3 19 67 WP_009631720.1 tryptophan dehydrogenase ScyB [Synechocystis sp. PCC 7509] diamond 441 96.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
30803657 30803657 PRJNA495391_S_NODE_65934_length_155_cov_1.325000_g64882_i0 PRJNA495391 65934 155 1.325 2.05375 Chroococcidiopsis cubana 171392 Bacteria Bacteria 60.5 6.69e-10   NR MDZ4870646.1 388085 g64882 i0 65.9 0.851612903225806 44 15 85.2 0 2 133 86 129 MDZ4870646.1 hypothetical protein [Chroococcidiopsis cubana SAG 39.79] diamond 132 60.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis cubana
31024948 31024948 PRJNA495391_S_NODE_70295_length_151_cov_1.146552_g69243_i0 PRJNA495391 70295 151 1.146552 1.73129352 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 93.2 1.8e-20   NR WP_106368763.1 2107693 g69243 i0 100 0.993377483443709 50 0 99.3 0 151 2 13 62 WP_106368763.1 cobaltochelatase subunit CobN [Chlorogloea sp. CCALA 695] diamond 150 93.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
31720479 31720479 PRJNA495391_S_NODE_11117_length_360_cov_2.476923_g10065_i0 PRJNA495391 11117 360 2.476923 8.9169228 Nostoc sp. 1180 Bacteria Bacteria 223 2.9e-69   NR WP_335124067.1 1180 g10065 i0 88.3 4 120 14 100 0 360 1 13 132 WP_335124067.1 transposase [Nostoc sp.] diamond 1440 223 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
32242573 32242573 PRJNA495391_S_NODE_69738_length_151_cov_1.931034_g68686_i0 PRJNA495391 69738 151 1.931034 2.91586134 Bacillati 1783272 Bacteria Bacteria 65.9 6.95e-11   NR MFH7028545.1 1735366 g68686 i0 56 1.96688741721854 50 22 99.3 0 2 151 209 258 MFH7028545.1 DNA (cytosine-5-)-methyltransferase [Heteroscytonema crispum UTEX LB 1556] diamond 297 65.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Heteroscytonemataceae Heteroscytonema Heteroscytonema crispum
32353540 32353540 PRJNA495391_S_NODE_68839_length_152_cov_1.666667_g67787_i0 PRJNA495391 68839 152 1.666667 2.53333384 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 80.1 1.49e-17   NR PSB25295.1 2107693 g67787 i0 83.3 0.947368421052632 48 8 94.7 0 2 145 23 70 PSB25295.1 hypothetical protein C7B70_24900 [Chlorogloea sp. CCALA 695] diamond 144 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695
32384927 32384927 PRJNA495391_S_NODE_7779_length_436_cov_2.097257_g6728_i0 PRJNA495391 7779 436 2.097257 9.14404052 Chlorogloea sp. CCALA 695 2107693 Bacteria Bacteria 258 1.92e-80   NR WP_199192199.1 2107693 g6728 i0 97.9 0.997706422018349 145 3 99.8 0 1 435 189 333 WP_199192199.1 mechanosensitive ion channel [Chlorogloea sp. CCALA 695] diamond 435 258 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Entophysalidaceae Chlorogloea Chlorogloea sp. CCALA 695

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