contig_metadata
22 rows where bioproject = "PRJNA683669" and tax_clade = "Cyanobacteriota/Melainabacteria group"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12144396 | 12144396 | PRJNA683669_P_NODE_29930_length_246_cov_0.890173_g29698_i0 | PRJNA683669 | 29930 | 246 | 0.890173 | 2.18982558 | Nostoc sp. NIES-4103 | 2005458 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|1210228378|dbj|AP018288.1| | 2005458 | g29698 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 54 | 81 | 5747550 | 5747577 | Nostoc sp. NIES-4103 DNA, nearly complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | Nostoc | Nostoc sp. NIES-4103 | |
| 21067359 | 21067359 | PRJNA683669_P_NODE_16137_length_323_cov_0.924000_g15906_i0 | PRJNA683669 | 16137 | 323 | 0.924 | 2.98452 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 78.7 | 5e-10 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g15906 | i0 | 83.908 | 0.634674922600619 | 87 | 8 | 27 | 3 | 121 | 207 | 3851390 | 3851310 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 205 | 78.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 21576970 | 21576970 | PRJNA683669_P_NODE_10437_length_398_cov_1.366154_g10206_i0 | PRJNA683669 | 10437 | 398 | 1.366154 | 5.43729292 | root | 1 | Root_unresolved | Root_unresolved | 669 | 0 | NTclustered | gi|1214568504|dbj|LC176673.1| | 1211 | g10206 | i0 | 96.985 | 99.7763819095477 | 398 | 12 | 100 | 0 | 1 | 398 | 7 | 404 | Uncultured cyanobacterium gene for 16S ribosomal RNA, partial sequence, clone: MIU_SFDB_3_20 | blastn | 39711 | 669 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | uncultured cyanobacterium | |||||
| 22342235 | 22342235 | PRJNA683669_P_NODE_20718_length_284_cov_1.421801_g20486_i0 | PRJNA683669 | 20718 | 284 | 1.421801 | 4.03791484 | Allocoleopsis sp. | 3088169 | Bacteria | Bacteria | 175 | 6.719999999999998e-54 | NR | HEY9705532.1 | 3088169 | g20486 | i0 | 87.2 | 2.05985915492958 | 94 | 12 | 99.3 | 0 | 284 | 3 | 8 | 101 | HEY9705532.1 peptidylprolyl isomerase [Allocoleopsis sp.] | diamond | 585 | 175 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Coleofasciculales | Coleofasciculaceae | Allocoleopsis | Allocoleopsis sp. | |
| 27283470 | 27283470 | PRJNA683669_P_NODE_12503_length_366_cov_1.051195_g12272_i0 | PRJNA683669 | 12503 | 366 | 1.051195 | 3.8473737 | root | 1 | Root_unresolved | Root_unresolved | 71.6 | 5.15e-12 | NR | WP_015127343.1 | 99598 | g12272 | i0 | 40.2 | 1.89344262295082 | 117 | 60 | 95.9 | 4 | 5 | 355 | 47 | 153 | WP_015127343.1 CmcJ/NvfI family oxidoreductase [Calothrix sp. PCC 7507] | diamond | 693 | 71.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Calotrichaceae | Calothrix | Calothrix sp. PCC 7507 | |
| 27303541 | 27303541 | PRJNA683669_P_NODE_14423_length_341_cov_1.350746_g14192_i0 | PRJNA683669 | 14423 | 341 | 1.350746 | 4.60604386 | Synechococcaceae cyanobacterium RL_1_2 | 2720420 | Bacteria | Bacteria | 139 | 8.239999999999999e-38 | NR | NJN74983.1 | 2720420 | g14192 | i0 | 62.5 | 0.914956011730205 | 104 | 39 | 91.5 | 0 | 317 | 6 | 150 | 253 | NJN74983.1 S-methyl-5'-thioadenosine phosphorylase [Synechococcaceae cyanobacterium RL_1_2] | diamond | 312 | 139 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Synechococcales | Synechococcaceae | Synechococcaceae cyanobacterium RL_1_2 | ||
| 27366917 | 27366917 | PRJNA683669_P_NODE_34203_length_241_cov_0.916667_g33971_i0 | PRJNA683669 | 34203 | 241 | 0.916667 | 2.20916747 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 75.5 | 1.09e-13 | NR | HIA55216.1 | 2052166 | g33971 | i0 | 90 | 0.622406639004149 | 50 | 5 | 62.2 | 0 | 150 | 1 | 220 | 269 | HIA55216.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 150 | 75.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27694303 | 27694303 | PRJNA683669_P_NODE_29124_length_247_cov_0.885057_g28892_i0 | PRJNA683669 | 29124 | 247 | 0.885057 | 2.18609079 | Bacteria | 2 | Bacteria | Bacteria | 91.3 | 3.26e-19 | NR | MBX9567960.1 | 2364082 | g28892 | i0 | 54.1 | 4.73684210526316 | 74 | 34 | 89.9 | 0 | 238 | 17 | 192 | 265 | MBX9567960.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium] | diamond | 1170 | 91.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27820458 | 27820458 | PRJNA683669_P_NODE_28184_length_248_cov_1.714286_g27952_i0 | PRJNA683669 | 28184 | 248 | 1.714286 | 4.25142928 | Microcoleaceae | 1892252 | Bacteria | Bacteria | 42 | 0.00695 | NR | WP_293068700.1 | 2607784 | g27952 | i0 | 48.6 | 2.14112903225806 | 35 | 17 | 42.3 | 1 | 117 | 221 | 5 | 38 | WP_293068700.1 zinc ribbon domain-containing protein [Okeania sp. SIO2B3] | diamond | 531 | 42.4 | 0.990566037735849 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Microcoleaceae | Okeania | Okeania sp. SIO2B3 | |
| 27903205 | 27903205 | PRJNA683669_P_NODE_33825_length_241_cov_0.916667_g33593_i0 | PRJNA683669 | 33825 | 241 | 0.916667 | 2.20916747 | Cyanobacteria bacterium SZAS LIN-5 | 2807734 | Bacteria | Bacteria | 140 | 9.14e-39 | NR | MBS2005228.1 | 2807734 | g33593 | i0 | 82.3 | 0.983402489626556 | 79 | 14 | 98.3 | 0 | 239 | 3 | 211 | 289 | MBS2005228.1 tetratricopeptide repeat protein [Cyanobacteria bacterium SZAS LIN-5] | diamond | 237 | 140 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteria bacterium SZAS LIN-5 | |||||
| 27935060 | 27935060 | PRJNA683669_P_NODE_26145_length_251_cov_0.865169_g25913_i0 | PRJNA683669 | 26145 | 251 | 0.865169 | 2.17157419 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 178 | 1.74e-51 | NR | MBX9950078.1 | 2364082 | g25913 | i0 | 100 | 1.9840637450199201 | 83 | 0 | 99.2 | 0 | 249 | 1 | 418 | 500 | MBX9950078.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Obscuribacterales bacterium] | diamond | 498 | 178 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28187332 | 28187332 | PRJNA683669_P_NODE_20426_length_286_cov_1.084507_g20194_i0 | PRJNA683669 | 20426 | 286 | 1.084507 | 3.10169002 | Trichodesmium sp. St18_bin1 | 2954180 | Bacteria | Bacteria | 96.3 | 9.38e-21 | NR | MDE5080684.1 | 2954180 | g20194 | i0 | 53.3 | 0.965034965034965 | 92 | 39 | 95.5 | 2 | 281 | 9 | 170 | 258 | MDE5080684.1 5-histidylcysteine sulfoxide synthase [Trichodesmium sp. St18_bin1] | diamond | 276 | 96.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Microcoleaceae | Trichodesmium | Trichodesmium sp. St18_bin1 | |
| 29398941 | 29398941 | PRJNA683669_P_NODE_2649_length_809_cov_7.975543_g2454_i0 | PRJNA683669 | 2649 | 809 | 7.975543 | 64.52214287 | Leptolyngbya | 47251 | Bacteria | Bacteria | 59.7 | 4.61e-6 | NR | WP_316428033.1 | 1184 | g2454 | i0 | 58.2 | 0.407911001236094 | 55 | 21 | 20.4 | 2 | 795 | 631 | 474 | 526 | WP_316428033.1 hypothetical protein [Leptolyngbya boryana] | diamond | 330 | 59.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Leptolyngbyales | Leptolyngbyaceae | Leptolyngbya | Leptolyngbya boryana | |
| 30082001 | 30082001 | PRJNA683669_P_NODE_24272_length_262_cov_1.222222_g24040_i0 | PRJNA683669 | 24272 | 262 | 1.222222 | 3.20222164 | Synechococcus sp. UW14 | 1131 | Bacteria | Bacteria | 65.9 | 3.4e-10 | NR | WP_341899167.1 | 368503 | g24040 | i0 | 45.8 | 7.7175572519084 | 83 | 44 | 93.9 | 1 | 3 | 248 | 975 | 1057 | WP_341899167.1 5'-nucleotidase C-terminal domain-containing protein [Synechococcus sp. UW140] | diamond | 2022 | 65.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Synechococcales | Synechococcaceae | Synechococcus | Synechococcus sp. UW140 | |
| 30176846 | 30176846 | PRJNA683669_P_NODE_22972_length_270_cov_1.563452_g22740_i0 | PRJNA683669 | 22972 | 270 | 1.563452 | 4.2213204 | Synechococcus sp. GFB | 1131 | Bacteria | Bacteria | 136 | 1.11e-36 | NR | WP_082325844.1 | 1662190 | g22740 | i0 | 77.9 | 1.87777777777778 | 86 | 19 | 95.6 | 0 | 12 | 269 | 21 | 106 | WP_082325844.1 cysteine synthase A [Synechococcus sp. GFB01] | diamond | 507 | 136 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Synechococcales | Synechococcaceae | Synechococcus | Synechococcus sp. GFB01 | |
| 30524485 | 30524485 | PRJNA683669_P_NODE_9213_length_421_cov_1.709770_g8982_i0 | PRJNA683669 | 9213 | 421 | 1.70977 | 7.1981317 | Nostocales | 1161 | Bacteria | Bacteria | 90.5 | 5.77e-18 | NR | WP_051503061.1 | 1161 | g8982 | i0 | 39 | 1.98099762470309 | 141 | 78 | 99.8 | 3 | 1 | 420 | 1098 | 1231 | WP_051503061.1 MULTISPECIES: amino acid adenylation domain-containing protein [Nostocales] | diamond | 834 | 90.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | ||||
| 30587520 | 30587520 | PRJNA683669_P_NODE_16973_length_314_cov_2.875519_g16742_i0 | PRJNA683669 | 16973 | 314 | 2.875519 | 9.02912966 | Pseudanabaenaceae cyanobacterium | 3078745 | Bacteria | Bacteria | 80.5 | 3.47e-16 | NR | MFN3927180.1 | 3078745 | g16742 | i0 | 42.3 | 2.77070063694268 | 97 | 52 | 92.7 | 4 | 291 | 1 | 29 | 121 | MFN3927180.1 VWA domain-containing protein [Pseudanabaenaceae cyanobacterium] | diamond | 870 | 80.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Pseudanabaenales | Pseudanabaenaceae | Pseudanabaenaceae cyanobacterium | ||
| 30714023 | 30714023 | PRJNA683669_P_NODE_29434_length_247_cov_0.885057_g29202_i0 | PRJNA683669 | 29434 | 247 | 0.885057 | 2.18609079 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 160 | 7.46e-46 | NR | PZM82533.1 | 2052166 | g29202 | i0 | 100 | 0.995951417004049 | 82 | 0 | 99.6 | 0 | 1 | 246 | 125 | 206 | PZM82533.1 MAG: hypothetical protein DKT66_11080 [Candidatus Melainabacteria bacterium] | diamond | 246 | 160 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30757315 | 30757315 | PRJNA683669_P_NODE_2814_length_784_cov_1.884669_g2613_i0 | PRJNA683669 | 2814 | 784 | 1.884669 | 14.77580496 | Cyanophyceae | 3028117 | Bacteria | Bacteria | 94.4 | 2.51e-18 | NR | WP_265266472.1 | 54311 | g2613 | i0 | 33.3 | 3.06122448979592 | 267 | 148 | 94.9 | 10 | 3 | 746 | 100 | 355 | WP_265266472.1 amino acid ABC transporter substrate-binding protein [Spirulina subsalsa] | diamond | 2400 | 95.1 | 0.992639327024185 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Spirulinales | Spirulinaceae | Spirulina | Spirulina subsalsa | |
| 32390112 | 32390112 | PRJNA683669_P_NODE_31099_length_245_cov_0.895349_g30867_i0 | PRJNA683669 | 31099 | 245 | 0.895349 | 2.19360505 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 68.2 | 3.13e-11 | NR | PZM82581.1 | 2052166 | g30867 | i0 | 86.5 | 0.453061224489796 | 37 | 5 | 45.3 | 0 | 2 | 112 | 291 | 327 | PZM82581.1 MAG: hypothetical protein DKT66_11330 [Candidatus Melainabacteria bacterium] | diamond | 111 | 68.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32433595 | 32433595 | PRJNA683669_P_NODE_3859_length_663_cov_2.274576_g3638_i0 | PRJNA683669 | 3859 | 663 | 2.274576 | 15.08043888 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 50.1 | 0.00443 | NR | WP_069074215.1 | 457944 | g3638 | i0 | 27.8 | 4.33484162895928 | 97 | 64 | 43.9 | 1 | 2 | 292 | 4583 | 4673 | WP_069074215.1 non-ribosomal peptide synthetase [Nostoc sp. KVJ20] | diamond | 2874 | 50.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | Nostoc | Nostoc sp. KVJ20 | |
| 32906231 | 32906231 | PRJNA683669_P_NODE_13980_length_346_cov_1.974359_g13749_i0 | PRJNA683669 | 13980 | 346 | 1.974359 | 6.83128214 | Oscillatoriales | 1150 | Bacteria | Bacteria | 47 | 0.00417 | NR | WP_224413357.1 | 331517 | g13749 | i0 | 37 | 6.71965317919075 | 81 | 44 | 68.5 | 3 | 2 | 238 | 1433 | 1508 | WP_224413357.1 type I polyketide synthase [Oscillatoria salina] | diamond | 2325 | 47 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Oscillatoriaceae | Oscillatoria | Oscillatoria salina |
Advanced export
JSON shape: default, array, newline-delimited
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);;