RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB10320 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
11491490 11491490 PRJEB10320_P_NODE_1430_length_875_cov_3.303571_g1281_i0 PRJEB10320 1430 875 3.303571 28.90624625 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 322 2.1499999999999993e-107   NR HEY9757260.1 3088181 g1281 i0 71.4 5.18057142857143 252 63 86.4 4 36 791 1 243 HEY9757260.1 SDR family oxidoreductase [Oculatellaceae cyanobacterium] diamond 4533 322 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
14041586 14041586 PRJEB10320_P_NODE_1392_length_885_cov_3.229412_g1243_i0 PRJEB10320 1392 885 3.229412 28.5802962 Bacillati 1783272 Bacteria Bacteria 319 2.7799999999999997e-106   NR MBX3072817.1 2364082 g1243 i0 70.3 3.37627118644068 249 68 84.4 4 799 53 1 243 MBX3072817.1 SDR family oxidoreductase [Candidatus Obscuribacterales bacterium] diamond 2988 319 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
25208523 25208523 PRJEB10320_P_NODE_22980_length_174_cov_1.489209_g22722_i0 PRJEB10320 22980 174 1.489209 2.59122366 Bacillati 1783272 Bacteria Bacteria 89.4 2.5e-19   NR PSP18950.1 1919134 g22722 i0 67.2 13.9827586206897 58 19 100 0 1 174 138 195 PSP18950.1 MAG: hydroxyacid dehydrogenase [Cyanobacteria bacterium QS_8_64_29] diamond 2433 89.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium QS_8_64_29
26684421 26684421 PRJEB10320_P_NODE_6821_length_396_cov_1.432133_g6566_i0 PRJEB10320 6821 396 1.432133 5.67124668 Dolichospermum sp. 2720786 Bacteria Bacteria 49.3 9.83e-4   NR MBJ7298695.1 2720786 g6566 i0 48.8 0.325757575757576 43 22 32.6 0 76 204 95 137 MBJ7298695.1 hypothetical protein [Dolichospermum sp.] diamond 129 49.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp.
26747443 26747443 PRJEB10320_P_NODE_661_length_1199_cov_30.818729_g557_i0 PRJEB10320 661 1199 30.818729 369.51656071 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 464 1.2099999999999997e-160   NR MBX9694561.1 2847862 g557 i0 73.4 2.4395329441201 308 77 75.8 2 1150 242 15 322 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 2925 464 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
26937666 26937666 PRJEB10320_P_NODE_19122_length_199_cov_0.975610_g18864_i0 PRJEB10320 19122 199 0.97561 1.9414639 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 95.9 8.04e-24   NR MBX9695544.1 2847862 g18864 i0 63.3 1.19095477386935 79 16 99.5 2 2 199 9 87 MBX9695544.1 hypothetical protein [Cyanobacteriota bacterium] diamond 237 95.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27948779 27948779 PRJEB10320_P_NODE_25225_length_163_cov_1.242188_g24967_i0 PRJEB10320 25225 163 1.242188 2.02476644 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 93.2 1.9300000000000003e-21   NR MBX9693789.1 2847862 g24967 i0 86.8 0.975460122699387 53 7 97.5 0 161 3 178 230 MBX9693789.1 hypothetical protein [Cyanobacteriota bacterium] diamond 159 93.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27980363 27980363 PRJEB10320_P_NODE_20865_length_187_cov_1.302632_g20607_i0 PRJEB10320 20865 187 1.302632 2.43592184 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 117 9.55e-33   NR MBX9694013.1 2847862 g20607 i0 88.5 0.978609625668449 61 7 97.9 0 185 3 23 83 MBX9694013.1 hypothetical protein [Cyanobacteriota bacterium] diamond 183 117 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28517163 28517163 PRJEB10320_P_NODE_847_length_1088_cov_4.545109_g496_i1 PRJEB10320 847 1088 4.545109 49.45078592 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 61.6 1.91e-6   NR MBX9692038.1 2847862 g496 i1 27 0.540441176470588 196 109 47.2 5 1 513 15 201 MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium] diamond 588 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28605735 28605735 PRJEB10320_P_NODE_6587_length_404_cov_4.097561_g6332_i0 PRJEB10320 6587 404 4.097561 16.55414644 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 122 2.7899999999999996e-31   NR WP_017314218.1 221287 g6332 i0 59.8 8.62128712871287 117 46 86.1 1 403 56 135 251 WP_017314218.1 SDR family oxidoreductase [Mastigocladopsis repens] diamond 3483 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Symphyonemataceae Mastigocladopsis Mastigocladopsis repens
28889791 28889791 PRJEB10320_P_NODE_12128_length_273_cov_1.504202_g11870_i0 PRJEB10320 12128 273 1.504202 4.10647146 Nostoc 1177 Bacteria Bacteria 55.5 1.78e-6   NR WP_318670528.1 1306274 g11870 i0 43.1 8.43956043956044 72 39 79.1 1 38 253 434 503 WP_318670528.1 hypothetical protein [Nostoc flagelliforme] diamond 2304 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc flagelliforme
29053959 29053959 PRJEB10320_P_NODE_16148_length_224_cov_1.047619_g15890_i0 PRJEB10320 16148 224 1.047619 2.34666656 Candidatus Margulisiibacteriota bacterium 2053573 Bacteria Bacteria 102 2.1e-23   NR MFA5878985.1 2053573 g15890 i0 71.6 1.98214285714286 74 20 99.1 1 1 222 754 826 MFA5878985.1 pyruvate, phosphate dikinase [Candidatus Margulisiibacteriota bacterium] diamond 444 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Margulisiibacteriota         Candidatus Margulisiibacteriota bacterium
29053974 29053974 PRJEB10320_P_NODE_7268_length_380_cov_1.979710_g7012_i0 PRJEB10320 7268 380 1.97971 7.522898 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 67.4 3.39e-10   NR MBX9692038.1 2847862 g7012 i0 42.1 0.75 95 34 75 2 2 286 300 373 MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium] diamond 285 67.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29432444 29432444 PRJEB10320_P_NODE_22110_length_179_cov_1.666667_g21852_i0 PRJEB10320 22110 179 1.666667 2.98333393 Cyanobacteria bacterium P01_A01_bin.83 3023254 Bacteria Bacteria 64.7 2.82e-10   NR MEM7590515.1 3023254 g21852 i0 54.4 11.3128491620112 57 26 95.5 0 178 8 110 166 MEM7590515.1 peroxidase family protein [Cyanobacteria bacterium P01_A01_bin.83] diamond 2025 64.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.83
29457908 29457908 PRJEB10320_P_NODE_26070_length_159_cov_1.556452_g25812_i0 PRJEB10320 26070 159 1.556452 2.47475868 Prochlorococcus 1218 Bacteria Bacteria 41.2 0.0431   NR WP_011131866.1 1218 g25812 i0 47.4 1.43396226415094 38 18 71.7 1 159 46 151 186 WP_011131866.1 MULTISPECIES: sulfate adenylyltransferase [Prochlorococcus] diamond 228 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus  
29716624 29716624 PRJEB10320_P_NODE_19670_length_195_cov_1.500000_g19412_i0 PRJEB10320 19670 195 1.5 2.925 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 119 2.9999999999999998e-33   NR MBX9695136.1 2847862 g19412 i0 88.9 0.969230769230769 63 7 96.9 0 2 190 7 69 MBX9695136.1 hypothetical protein [Cyanobacteriota bacterium] diamond 189 119 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30254193 30254193 PRJEB10320_P_NODE_9952_length_311_cov_1.880435_g9694_i0 PRJEB10320 9952 311 1.880435 5.84815285 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 145 1.1099999999999999e-42   NR MBX9692690.1 2847862 g9694 i0 90.1 0.684887459807074 71 7 68.5 0 2 214 47 117 MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium] diamond 213 145 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30311499 30311499 PRJEB10320_P_NODE_8372_length_348_cov_2.159744_g8114_i0 PRJEB10320 8372 348 2.159744 7.51590912 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 55.8 2.09e-7   NR WP_193939243.1 230752 g8114 i0 38.5 2.68965517241379 78 36 56.9 3 348 151 13 90 WP_193939243.1 hypothetical protein, partial [Cuspidothrix issatschenkoi] diamond 936 56.2 0.99288256227758 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Cuspidothrix Cuspidothrix issatschenkoi
30380696 30380696 PRJEB10320_P_NODE_9553_length_319_cov_2.352113_g9295_i0 PRJEB10320 9553 319 2.352113 7.50324047 Phormidesmis priestleyi Ana 1666911 Bacteria Bacteria 127 1.11e-33   NR KPQ32261.1 1666911 g9295 i0 64.2 4.94670846394984 106 36 97.8 1 318 7 114 219 KPQ32261.1 MAG: Dehydrogenase [Phormidesmis priestleyi Ana] diamond 1578 127 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Phormidesmis Phormidesmis priestleyi
30854172 30854172 PRJEB10320_P_NODE_594_length_1254_cov_4.916325_g496_i0 PRJEB10320 594 1254 4.916325 61.6507155 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 61.6 2.62e-6   NR MBX9692038.1 2847862 g496 i0 27 0.4688995215311 196 109 40.9 5 1 513 15 201 MBX9692038.1 hypothetical protein [Cyanobacteriota bacterium] diamond 588 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31012190 31012190 PRJEB10320_P_NODE_18555_length_203_cov_1.428571_g18297_i0 PRJEB10320 18555 203 1.428571 2.89999913 Gloeomargarita sp. GMQP_bins_25 3064321 Bacteria Bacteria 114 6.99e-28   NR MEN9235966.1 3064321 g18297 i0 80.6 2.97044334975369 67 13 99 0 1 201 297 363 MEN9235966.1 ATP-dependent zinc metalloprotease FtsH3 [Gloeomargarita sp. GMQP_bins_25] diamond 603 114 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gloeomargaritales Gloeomargaritaceae Gloeomargarita Gloeomargarita sp. GMQP_bins_25
31423140 31423140 PRJEB10320_P_NODE_13596_length_253_cov_1.027523_g13338_i0 PRJEB10320 13596 253 1.027523 2.59963319 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 145 3.53e-39   NR MBX9694651.1 2847862 g13338 i0 84.5 0.99604743083004 84 13 99.6 0 253 2 131 214 MBX9694651.1 nicotinate phosphoribosyltransferase [Cyanobacteriota bacterium] diamond 252 145 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31992528 31992528 PRJEB10320_P_NODE_16818_length_218_cov_1.256831_g16560_i0 PRJEB10320 16818 218 1.256831 2.73989158 candidate division WOR-1 bacterium DG_54_3 1703775 Bacteria Bacteria 43.1 0.0201   NR KPJ65960.1 1703775 g16560 i0 41.2 0.701834862385321 51 30 70.2 0 2 154 680 730 KPJ65960.1 MAG: hypothetical protein AMJ44_09185 [candidate division WOR-1 bacterium DG_54_3] diamond 153 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati           candidate division WOR-1 bacterium DG_54_3
32309294 32309294 PRJEB10320_P_NODE_16819_length_218_cov_1.202186_g16561_i0 PRJEB10320 16819 218 1.202186 2.62076548 Coleofasciculaceae cyanobacterium 3081323 Bacteria Bacteria 65.1 3.33e-11   NR MEO8890074.1 3081323 g16561 i0 49.2 2.38073394495413 61 30 83.9 1 217 35 38 97 MEO8890074.1 HHL1-like protein [Coleofasciculaceae cyanobacterium] diamond 519 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium
32366345 32366345 PRJEB10320_P_NODE_25439_length_162_cov_1.086614_g25181_i0 PRJEB10320 25439 162 1.086614 1.76031468 Crocosphaera 263510 Bacteria Bacteria 70.5 2.09e-12   NR WP_190273828.1 263510 g25181 i0 67.9 7.59259259259259 53 17 98.1 0 162 4 483 535 WP_190273828.1 MULTISPECIES: ABC transporter ATP-binding protein/permease [Crocosphaera] diamond 1230 70.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Crocosphaera  
32593751 32593751 PRJEB10320_P_NODE_8920_length_334_cov_1.471572_g8662_i0 PRJEB10320 8920 334 1.471572 4.91505048 Desmonostoc muscorum 1179 Bacteria Bacteria 76.6 1.3e-14   NR MBX9256189.1 2756293 g8662 i0 37.9 1.87724550898204 103 56 92.5 2 334 26 61 155 MBX9256189.1 secretion protein [Desmonostoc muscorum CCALA 125] diamond 627 76.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Desmonostoc Desmonostoc muscorum

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