RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA376117 · 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
27485710 27485710 PRJNA376117_P_NODE_40223_length_245_cov_0.895349_g39921_i0 PRJNA376117 40223 245 0.895349 2.19360505 Pseudanabaena sp. ELA607 3064511 Bacteria Bacteria 71.6 1.71e-14   NR MEI6429300.1 3064511 g39921 i0 78 0.502040816326531 41 9 50.2 0 163 41 9 49 MEI6429300.1 hypothetical protein [Pseudanabaena sp. ELA607] diamond 123 71.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. ELA607
27517266 27517266 PRJNA376117_P_NODE_21883_length_295_cov_2.806306_g21581_i0 PRJNA376117 21883 295 2.806306 8.2786027 Allocoleopsis franciscana 2886352 Bacteria Bacteria 68.6 1.17e-11   NR WP_041780282.1 2886352 g21581 i0 44.8 3.36610169491525 87 46 88.5 2 291 31 16 100 WP_041780282.1 vWA domain-containing protein [Allocoleopsis franciscana] diamond 993 68.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Allocoleopsis Allocoleopsis franciscana
27927735 27927735 PRJNA376117_P_NODE_30625_length_262_cov_2.211640_g30323_i0 PRJNA376117 30625 262 2.21164 5.7944968 Alkalinema sp. CACIAM 7 3100328 Bacteria Bacteria 183 1.2199999999999999e-54   NR OUC11604.1 1934309 g30323 i0 100 0.99618320610687 87 0 99.6 0 262 2 254 340 OUC11604.1 MAG: hypothetical protein B0A82_26875 [Alkalinema sp. CACIAM 70d] diamond 261 183 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Alkalinema Alkalinema sp. CACIAM 70d
28022596 28022596 PRJNA376117_P_NODE_39705_length_245_cov_3.819767_g39403_i0 PRJNA376117 39705 245 3.819767 9.35842915 Cyanobacteria bacterium J06639_1 3023214 Bacteria Bacteria 42 0.0495   NR MEO1133969.1 3023214 g39403 i0 35.1 0.697959183673469 57 30 69.8 1 66 236 90 139 MEO1133969.1 YwiC-like family protein [Cyanobacteria bacterium J06639_1] diamond 171 42 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06639_1
28053904 28053904 PRJNA376117_P_NODE_21265_length_299_cov_4.464602_g20963_i0 PRJNA376117 21265 299 4.464602 13.34915998 Okeania sp. SIO2D1 2607792 Bacteria Bacteria 72.4 7.86e-14   NR NES65768.1 2607792 g20963 i0 37.1 0.973244147157191 97 59 95.3 1 292 8 8 104 NES65768.1 hypothetical protein [Okeania sp. SIO2D1] diamond 291 72.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO2D1
28180094 28180094 PRJNA376117_P_NODE_32246_length_256_cov_2.016393_g31944_i0 PRJNA376117 32246 256 2.016393 5.16196608 Nostoc linckia 92942 Bacteria Bacteria 47 0.00126   NR WP_368731841.1 92942 g31944 i0 77.4 1.67578125 31 7 36.3 0 163 255 27 57 WP_368731841.1 MHYT domain-containing protein, partial [Nostoc linckia] diamond 429 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc linckia
28481591 28481591 PRJNA376117_P_NODE_27306_length_275_cov_1.128713_g27004_i0 PRJNA376117 27306 275 1.128713 3.10396075 Scytonema 1203 Bacteria Bacteria 65.9 4.07e-10   NR MEC4817083.1 2684455 g27004 i0 36.3 3.97090909090909 91 55 99.3 1 2 274 823 910 MEC4817083.1 CHAT domain-containing protein [Scytonema sp. PMC 1069.18] diamond 1092 65.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. PMC 1069.18
28496186 28496186 PRJNA376117_P_NODE_27467_length_274_cov_1.512438_g27165_i0 PRJNA376117 27467 274 1.512438 4.14408012 Okeania sp. SIO2D1 2607792 Bacteria Bacteria 67.8 3.64e-12   NR NES65768.1 2607792 g27165 i0 37.1 0.974452554744526 89 54 95.3 1 266 6 8 96 NES65768.1 hypothetical protein [Okeania sp. SIO2D1] diamond 267 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO2D1
28891851 28891851 PRJNA376117_P_NODE_17668_length_328_cov_5.501961_g17366_i0 PRJNA376117 17668 328 5.501961 18.04643208 root 1 Root_unresolved Root_unresolved 75.1 1.26e-14   NR WP_375470271.1 340711 g17366 i0 35.2 1.8109756097561 108 67 96 3 316 2 17 124 WP_375470271.1 CVNH domain-containing protein [uncultured Nostoc sp.] diamond 594 75.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc uncultured Nostoc sp.
29190793 29190793 PRJNA376117_P_NODE_14269_length_362_cov_2.840830_g13967_i0 PRJNA376117 14269 362 2.84083 10.2838046 Nostoc sp. 1180 Bacteria Bacteria 92 5.97e-21   NR WP_334858291.1 1180 g13967 i0 75.5 1.38397790055249 53 13 43.9 0 159 1 2 54 WP_334858291.1 coactosin family protein [Nostoc sp.] diamond 501 92 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
29270755 29270755 PRJNA376117_P_NODE_32989_length_253_cov_2.488889_g32687_i0 PRJNA376117 32989 253 2.488889 6.29688917 Nostocales 1161 Bacteria Bacteria 59.3 6.25e-8   NR MBW4628362.1 1049025 g32687 i0 76.3 3.68774703557312 38 9 45.1 0 13 126 541 578 MBW4628362.1 AAA-like domain-containing protein [Brasilonema octagenarum HA4186-MV1] diamond 933 59.7 0.993299832495812 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Brasilonema Brasilonema octagenarum
29569476 29569476 PRJNA376117_P_NODE_25990_length_279_cov_1.495146_g25688_i0 PRJNA376117 25990 279 1.495146 4.17145734 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 82 1.56e-16   NR MBX9696048.1 2847862 g25688 i0 54.2 0.774193548387097 72 33 77.4 0 55 270 2 73 MBX9696048.1 hypothetical protein [Cyanobacteriota bacterium] diamond 216 82 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30232846 30232846 PRJNA376117_P_NODE_30772_length_262_cov_1.359788_g30470_i0 PRJNA376117 30772 262 1.359788 3.56264456 Atlanticothrix silvestris 2840444 Bacteria Bacteria 102 6.61e-23   NR WP_214442558.1 2840444 g30470 i0 53.5 0.984732824427481 86 39 98.5 1 4 261 360 444 WP_214442558.1 acylase [Atlanticothrix silvestris] diamond 258 102 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Atlanticothrix Atlanticothrix silvestris
31497148 31497148 PRJNA376117_P_NODE_22656_length_290_cov_2.654378_g22354_i0 PRJNA376117 22656 290 2.654378 7.6976962 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 64.7 5.58e-11   NR HEY9799329.1 3088178 g22354 i0 33.7 1.90344827586207 89 55 91 2 24 287 23 108 HEY9799329.1 hypothetical protein [Leptolyngbyaceae cyanobacterium] diamond 552 64.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
31528732 31528732 PRJNA376117_P_NODE_25456_length_281_cov_1.370192_g25154_i0 PRJNA376117 25456 281 1.370192 3.85023952 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 205 1.96e-61   NR PZM81480.1 2052166 g25154 i0 98.9 0.99288256227758 93 1 99.3 0 279 1 82 174 PZM81480.1 MAG: hypothetical protein DKT66_19935 [Candidatus Melainabacteria bacterium] diamond 279 205 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
31686662 31686662 PRJNA376117_P_NODE_19217_length_315_cov_1.909091_g18915_i0 PRJNA376117 19217 315 1.909091 6.01363665 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 64.3 2.16e-9   NR MDX2272534.1 2847862 g18915 i0 31.7 1.97142857142857 104 70 99 1 3 314 325 427 MDX2272534.1 hypothetical protein [Cyanobacteriota bacterium] diamond 621 64.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31798549 31798549 PRJNA376117_P_NODE_2217_length_1006_cov_2.758842_g1970_i0 PRJNA376117 2217 1006 2.758842 27.75395052 Bacillati 1783272 Bacteria Bacteria 79 5.01e-12   NR WP_193950673.1 1828643 g1970 i0 31.1 1.80417495029821 148 95 44.1 2 21 464 464 604 WP_193950673.1 thioester reductase domain-containing protein, partial [Nostoc sp. LEGE 12450] diamond 1815 79.7 0.991217063989962 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. LEGE 12450
32097969 32097969 PRJNA376117_P_NODE_24938_length_283_cov_1.100000_g24636_i0 PRJNA376117 24938 283 1.1 3.113 Nostoc sp. 1180 Bacteria Bacteria 147 2.1399999999999993e-43   NR WP_334858291.1 1180 g24636 i0 74.2 1.97173144876325 93 24 98.6 0 281 3 43 135 WP_334858291.1 coactosin family protein [Nostoc sp.] diamond 558 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
32431672 32431672 PRJNA376117_P_NODE_45259_length_227_cov_3.701299_g44957_i0 PRJNA376117 45259 227 3.701299 8.40194873 Pseudanabaena 1152 Bacteria Bacteria 60.1 2.27e-8   NR WP_019499601.1 118173 g44957 i0 42.1 3.01321585903084 76 40 97.8 2 5 226 312 385 WP_019499601.1 fatty acid desaturase [Pseudanabaena sp. PCC 6802] diamond 684 60.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena sp. PCC 6802
32635343 32635343 PRJNA376117_P_NODE_25960_length_279_cov_1.684466_g25658_i0 PRJNA376117 25960 279 1.684466 4.69966014 Prochlorothrix sp. 54309 Bacteria Bacteria 75.5 1.79e-13   NR MEB3162773.1 54309 g25658 i0 42.1 3.02150537634409 95 48 94.6 2 264 1 528 622 MEB3162773.1 adenylate/guanylate cyclase domain-containing protein [Prochlorothrix sp.] diamond 843 75.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Prochlorotrichales Prochlorotrichaceae Prochlorothrix Prochlorothrix sp.
32872959 32872959 PRJNA376117_P_NODE_39400_length_246_cov_0.890173_g39098_i0 PRJNA376117 39400 246 0.890173 2.18982558 Moorena 1155738 Bacteria Bacteria 73.9 2.56e-13   NR WP_293047493.1 2607819 g39098 i0 43.8 5.65853658536585 80 44 97.6 1 242 3 182 260 WP_293047493.1 NAD/NADP octopine/nopaline dehydrogenase family protein [Moorena sp. SIO1F2] diamond 1392 73.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena sp. SIO1F2

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