RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA493828 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
20876754 20876754 PRJNA493828_P_NODE_6517_length_434_cov_5.778393_g6117_i0 PRJNA493828 6517 434 5.778393 25.07822562 Synechococcus sp. J7-Johnson 2823737 Bacteria Bacteria 200 2.6e-59   NR WP_255095230.1 2823737 g6117 i0 72.5 3.58064516129032 131 30 86.4 1 2 376 342 472 WP_255095230.1 DUF1254 domain-containing protein [Synechococcus sp. J7-Johnson] diamond 1554 200 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. J7-Johnson
24700436 24700436 PRJNA493828_P_NODE_14480_length_310_cov_5.189873_g14061_i0 PRJNA493828 14480 310 5.189873 16.0886063 Chroococcidiopsis sp. SAG 2 3088168 Bacteria Bacteria 188 5.779999999999999e-55   NR WP_317106213.1 171389 g14061 i0 87.9 1.03548387096774 107 8 98.7 1 308 3 107 213 WP_317106213.1 benzoate-CoA ligase family protein [Chroococcidiopsis sp. SAG 2025] diamond 321 188 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. SAG 2025
27329907 27329907 PRJNA493828_P_NODE_23123_length_276_cov_5.561576_g22704_i0 PRJNA493828 23123 276 5.561576 15.34994976 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 157 5.48e-43   NR HEY9781000.1 3088178 g22704 i0 82.4 0.989130434782609 91 16 98.9 0 4 276 298 388 HEY9781000.1 iron uptake porin [Leptolyngbyaceae cyanobacterium] diamond 273 157 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
27897999 27897999 PRJNA493828_P_NODE_46745_length_206_cov_5.360902_g46326_i0 PRJNA493828 46745 206 5.360902 11.04345812 Planktothrix sp. UBA8402 2055759 Bacteria Bacteria 44.7 0.00376   NR HAN73257.1 2055759 g46326 i0 48.8 2.6504854368932 43 22 62.6 0 141 13 147 189 HAN73257.1 hypothetical protein [Planktothrix sp. UBA8402] diamond 546 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. UBA8402
28940280 28940280 PRJNA493828_P_NODE_38968_length_242_cov_0.911243_g38549_i0 PRJNA493828 38968 242 0.911243 2.20520806 Planktothrix sp. UBA8402 2055759 Bacteria Bacteria 64.7 2e-10   NR HAN73257.1 2055759 g38549 i0 59.7 2.35537190082645 62 23 76.9 2 55 240 3 62 HAN73257.1 hypothetical protein [Planktothrix sp. UBA8402] diamond 570 64.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. UBA8402
29161337 29161337 PRJNA493828_P_NODE_28469_length_260_cov_1.802139_g28050_i0 PRJNA493828 28469 260 1.802139 4.6855614 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 146 2.64e-39   NR HCF27942.1 2055787 g28050 i0 74.4 0.992307692307692 86 22 99.2 0 3 260 234 319 HCF27942.1 hypothetical protein [Cyanobacteria bacterium UBA11049] diamond 258 146 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
29192831 29192831 PRJNA493828_P_NODE_44749_length_221_cov_4.797297_g44330_i0 PRJNA493828 44749 221 4.797297 10.60202637 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 49.3 3.6e-5   NR MEL7523918.1 3023125 g44330 i0 43.4 0.719457013574661 53 30 71.9 0 220 62 8 60 MEL7523918.1 hypothetical protein [Cyanobacteria bacterium J06553_1] diamond 159 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
29318895 29318895 PRJNA493828_P_NODE_23389_length_276_cov_1.310345_g22970_i0 PRJNA493828 23389 276 1.310345 3.6165522 Planktothrix sp. UBA8402 2055759 Bacteria Bacteria 114 3.36e-28   NR HAN73253.1 2055759 g22970 i0 65.8 0.858695652173913 79 27 85.9 0 40 276 40 118 HAN73253.1 hypothetical protein [Planktothrix sp. UBA8402] diamond 237 114 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. UBA8402
29744800 29744800 PRJNA493828_P_NODE_48090_length_199_cov_4.841270_g47671_i0 PRJNA493828 48090 199 4.84127 9.6341273 Bacteria 2 Bacteria Bacteria 47 6.39e-4   NR MEB3171217.1 2588875 g47671 i0 60.5 2.89447236180905 38 15 57.3 0 194 81 360 397 MEB3171217.1 glycosyltransferase [Synechococcaceae cyanobacterium] diamond 576 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae   Synechococcaceae cyanobacterium
30108438 30108438 PRJNA493828_P_NODE_42012_length_233_cov_3.231250_g41593_i0 PRJNA493828 42012 233 3.23125 7.5288125 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 44.7 0.00668   NR MEL7520264.1 3023125 g41593 i0 47.8 0.592274678111588 46 22 56.7 1 67 198 9 54 MEL7520264.1 hypothetical protein [Cyanobacteria bacterium J06553_1] diamond 138 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1
30171590 30171590 PRJNA493828_P_NODE_29352_length_258_cov_1.302703_g28933_i0 PRJNA493828 29352 258 1.302703 3.36097374 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 143 9.41e-40   NR HEY9779215.1 3088178 g28933 i0 97.3 1.74418604651163 75 2 87.2 0 238 14 89 163 HEY9779215.1 DUF1517 domain-containing protein [Leptolyngbyaceae cyanobacterium] diamond 450 143 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
32068301 32068301 PRJNA493828_P_NODE_28998_length_259_cov_1.032258_g28579_i0 PRJNA493828 28998 259 1.032258 2.67354822 Planktothrix sp. UBA8402 2055759 Bacteria Bacteria 96.7 1.69e-21   NR HAN73253.1 2055759 g28579 i0 58.5 0.94980694980695 82 34 95 0 1 246 135 216 HAN73253.1 hypothetical protein [Planktothrix sp. UBA8402] diamond 246 96.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. UBA8402
32668999 32668999 PRJNA493828_P_NODE_30060_length_256_cov_1.448087_g29641_i0 PRJNA493828 30060 256 1.448087 3.70710272 Planktothrix sp. UBA8402 2055759 Bacteria Bacteria 75.1 1.35e-13   NR HAN73253.1 2055759 g29641 i0 61.2 0.57421875 49 19 57.4 0 246 100 52 100 HAN73253.1 hypothetical protein [Planktothrix sp. UBA8402] diamond 147 75.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. UBA8402
32826564 32826564 PRJNA493828_P_NODE_36580_length_245_cov_0.895349_g36161_i0 PRJNA493828 36580 245 0.895349 2.19360505 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 106 1.1e-25   NR MEY3767063.1 2847862 g36161 i0 100 0.673469387755102 55 0 67.3 0 243 79 259 313 MEY3767063.1 hypothetical protein [Cyanobacteriota bacterium] diamond 165 106 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);;