contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2106191 | 2106191 | PRJNA841653_P_NODE_46142_length_250_cov_0.870056_g45468_i0 | PRJNA841653 | 46142 | 250 | 0.870056 | 2.17514 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 142 | 6.14e-38 | NR | MEZ0371079.1 | 2762020 | g45468 | i0 | 84.8 | 1.896 | 79 | 12 | 94.8 | 0 | 13 | 249 | 256 | 334 | MEZ0371079.1 argininosuccinate lyase [Candidatus Sericytochromatia bacterium] | diamond | 474 | 142 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 13984673 | 13984673 | PRJNA841653_P_NODE_46291_length_250_cov_0.870056_g45617_i0 | PRJNA841653 | 46291 | 250 | 0.870056 | 2.17514 | Synechocystis sp. PCC 75 | 1143 | Bacteria | Bacteria | 149 | 1.12e-42 | NR | WP_009634388.1 | 927677 | g45617 | i0 | 88.9 | 2.928 | 81 | 9 | 97.2 | 0 | 7 | 249 | 28 | 108 | WP_009634388.1 TIGR00297 family protein [Synechocystis sp. PCC 7509] | diamond | 732 | 149 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Synechococcales | Merismopediaceae | Synechocystis | Synechocystis sp. PCC 7509 | |
| 26737743 | 26737743 | PRJNA841653_P_NODE_58601_length_243_cov_0.905882_g57927_i0 | PRJNA841653 | 58601 | 243 | 0.905882 | 2.20129326 | Chlorogloea sp. CCALA 695 | 2107693 | Bacteria | Bacteria | 163 | 6.77e-48 | NR | WP_106370117.1 | 2107693 | g57927 | i0 | 92.4 | 1.95061728395062 | 79 | 6 | 97.5 | 0 | 3 | 239 | 150 | 228 | WP_106370117.1 FAD-binding domain-containing protein [Chlorogloea sp. CCALA 695] | diamond | 474 | 163 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcales | Entophysalidaceae | Chlorogloea | Chlorogloea sp. CCALA 695 | |
| 26801432 | 26801432 | PRJNA841653_P_NODE_30461_length_295_cov_1.373874_g29787_i0 | PRJNA841653 | 30461 | 295 | 1.373874 | 4.0529283 | Gloeocapsa sp. UFS-A4-WI-NPMV-4B04 | 2839657 | Bacteria | Bacteria | 98.2 | 1.67e-21 | NR | MBW4638748.1 | 2839657 | g29787 | i0 | 50 | 1.40338983050847 | 138 | 27 | 97.6 | 2 | 1 | 288 | 16 | 153 | MBW4638748.1 hypothetical protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04] | diamond | 414 | 98.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcales | Chroococcaceae | Gloeocapsa | Gloeocapsa sp. UFS-A4-WI-NPMV-4B04 | |
| 28160334 | 28160334 | PRJNA841653_P_NODE_39965_length_261_cov_1.287234_g39291_i0 | PRJNA841653 | 39965 | 261 | 1.287234 | 3.35968074 | Leptolyngbya sp. | 47254 | Bacteria | Bacteria | 43.9 | 0.0182 | NR | HTL89916.1 | 47254 | g39291 | i0 | 39.6 | 0.609195402298851 | 53 | 31 | 60.9 | 1 | 161 | 3 | 16 | 67 | HTL89916.1 chloride channel protein [Leptolyngbya sp.] | diamond | 159 | 43.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Leptolyngbyales | Leptolyngbyaceae | Leptolyngbya | Leptolyngbya sp. | |
| 28191478 | 28191478 | PRJNA841653_P_NODE_59766_length_242_cov_0.911243_g59092_i0 | PRJNA841653 | 59766 | 242 | 0.911243 | 2.20520806 | Chlorogloea sp. CCALA 695 | 2107693 | Bacteria | Bacteria | 100 | 6.83e-23 | NR | WP_106367930.1 | 2107693 | g59092 | i0 | 81 | 0.71900826446281 | 58 | 11 | 71.9 | 0 | 68 | 241 | 1 | 58 | WP_106367930.1 Gfo/Idh/MocA family protein [Chlorogloea sp. CCALA 695] | diamond | 174 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcales | Entophysalidaceae | Chlorogloea | Chlorogloea sp. CCALA 695 | |
| 28223113 | 28223113 | PRJNA841653_P_NODE_54806_length_245_cov_0.895349_g54132_i0 | PRJNA841653 | 54806 | 245 | 0.895349 | 2.19360505 | Microcystis sp. | 1127 | Bacteria | Bacteria | 102 | 1.96e-24 | NR | WP_409944544.1 | 1127 | g54132 | i0 | 96.2 | 0.636734693877551 | 52 | 2 | 63.7 | 0 | 88 | 243 | 87 | 138 | WP_409944544.1 IS1 family transposase [Microcystis sp.] | diamond | 156 | 102 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcales | Microcystaceae | Microcystis | Microcystis sp. | |
| 28610657 | 28610657 | PRJNA841653_P_NODE_47167_length_249_cov_0.875000_g46493_i0 | PRJNA841653 | 47167 | 249 | 0.875 | 2.17875 | Microcoleus | 44471 | Bacteria | Bacteria | 91.3 | 2.54e-19 | NR | WP_332986366.1 | 2818558 | g46493 | i0 | 62.7 | 3 | 83 | 31 | 100 | 0 | 249 | 1 | 147 | 229 | WP_332986366.1 S-layer family protein, partial [Microcoleus sp. ARI1-A3] | diamond | 747 | 91.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Oscillatoriales | Microcoleaceae | Microcoleus | Microcoleus sp. ARI1-A3 | |
| 28728513 | 28728513 | PRJNA841653_P_NODE_58267_length_243_cov_0.905882_g57593_i0 | PRJNA841653 | 58267 | 243 | 0.905882 | 2.20129326 | Fortiea contorta | 1892405 | Bacteria | Bacteria | 47 | 0.00114 | NR | WP_017654844.1 | 1892405 | g57593 | i0 | 61.3 | 0.382716049382716 | 31 | 12 | 38.3 | 0 | 242 | 150 | 404 | 434 | WP_017654844.1 DNA polymerase III subunit gamma/tau [Fortiea contorta] | diamond | 93 | 47 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Fortieaceae | Fortiea | Fortiea contorta | |
| 28736944 | 28736944 | PRJNA841653_P_NODE_39007_length_264_cov_1.450262_g38333_i0 | PRJNA841653 | 39007 | 264 | 1.450262 | 3.82869168 | Cylindrospermum | 56106 | Bacteria | Bacteria | 56.6 | 6e-7 | NR | MBE9053717.1 | 1828825 | g38333 | i0 | 86.2 | 2.01136363636364 | 29 | 4 | 33 | 0 | 101 | 15 | 1 | 29 | MBE9053717.1 alkaline phosphatase family protein [Nostocales cyanobacterium LEGE 11386] | diamond | 531 | 57 | 0.992982456140351 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocales cyanobacterium LEGE 11386 | |||
| 29296820 | 29296820 | PRJNA841653_P_NODE_43469_length_251_cov_0.865169_g42795_i0 | PRJNA841653 | 43469 | 251 | 0.865169 | 2.17157419 | Nostoc sp. DedSLP | 1180 | Bacteria | Bacteria | 53.5 | 6.19e-6 | NR | WP_322698951.1 | 3075400 | g42795 | i0 | 45.3 | 2.16334661354582 | 64 | 35 | 76.5 | 0 | 193 | 2 | 100 | 163 | WP_322698951.1 reverse transcriptase family protein, partial [Nostoc sp. DedSLP03] | diamond | 543 | 53.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Nostocaceae | Nostoc | Nostoc sp. DedSLP03 | |
| 29360012 | 29360012 | PRJNA841653_P_NODE_53389_length_246_cov_0.872832_g52715_i0 | PRJNA841653 | 53389 | 246 | 0.872832 | 2.14716672 | Cyanobium sp. ATX-6F1 | 3137388 | Bacteria | Bacteria | 44.7 | 0.00775 | NR | WP_414026531.1 | 3137388 | g52715 | i0 | 40.7 | 0.658536585365854 | 54 | 28 | 62.2 | 2 | 181 | 29 | 275 | 327 | WP_414026531.1 CPBP family intramembrane glutamic endopeptidase [Cyanobium sp. ATX-6F1] | diamond | 162 | 44.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Synechococcales | Prochlorococcaceae | Cyanobium | Cyanobium sp. ATX-6F1 | |
| 29770265 | 29770265 | PRJNA841653_P_NODE_54251_length_245_cov_0.895349_g53577_i0 | PRJNA841653 | 54251 | 245 | 0.895349 | 2.19360505 | Candidatus Gastranaerophilaceae bacterium | 3022870 | Bacteria | Bacteria | 148 | 2.72e-40 | NR | MFA7659370.1 | 3022870 | g53577 | i0 | 85.2 | 1.98367346938776 | 81 | 12 | 99.2 | 0 | 1 | 243 | 372 | 452 | MFA7659370.1 ATP-binding cassette domain-containing protein [Candidatus Gastranaerophilaceae bacterium] | diamond | 486 | 148 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilaceae | Candidatus Gastranaerophilaceae bacterium | |||
| 29770269 | 29770269 | PRJNA841653_P_NODE_57831_length_243_cov_0.905882_g57157_i0 | PRJNA841653 | 57831 | 243 | 0.905882 | 2.20129326 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 149 | 1.21e-41 | NR | MBX3076952.1 | 2364082 | g57157 | i0 | 84.2 | 1.87654320987654 | 76 | 12 | 93.8 | 0 | 230 | 3 | 75 | 150 | MBX3076952.1 magnesium/cobalt transporter CorA [Candidatus Obscuribacterales bacterium] | diamond | 456 | 149 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30023299 | 30023299 | PRJNA841653_P_NODE_47331_length_249_cov_0.875000_g46657_i0 | PRJNA841653 | 47331 | 249 | 0.875 | 2.17875 | Fischerella major | 210993 | Bacteria | Bacteria | 41.2 | 0.0358 | NR | WP_073555418.1 | 210993 | g46657 | i0 | 36.2 | 0.566265060240964 | 47 | 30 | 56.6 | 0 | 239 | 99 | 48 | 94 | WP_073555418.1 hypothetical protein [Fischerella major] | diamond | 141 | 41.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Hapalosiphonaceae | Fischerella | Fischerella major | |
| 30086213 | 30086213 | PRJNA841653_P_NODE_39592_length_262_cov_1.560847_g38918_i0 | PRJNA841653 | 39592 | 262 | 1.560847 | 4.08941914 | Cyanobacteria bacterium UBA11049 | 2055787 | Bacteria | Bacteria | 148 | 3.31e-40 | NR | HCF28367.1 | 2055787 | g38918 | i0 | 83.7 | 0.984732824427481 | 86 | 14 | 98.5 | 0 | 260 | 3 | 308 | 393 | HCF28367.1 hypothetical protein [Cyanobacteria bacterium UBA11049] | diamond | 258 | 148 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanobacteria bacterium UBA11049 | |||||
| 31476964 | 31476964 | PRJNA841653_P_NODE_46956_length_249_cov_0.875000_g46282_i0 | PRJNA841653 | 46956 | 249 | 0.875 | 2.17875 | Chlorogloea sp. CCALA 695 | 2107693 | Bacteria | Bacteria | 132 | 5.29e-36 | NR | WP_106368265.1 | 2107693 | g46282 | i0 | 84.2 | 0.91566265060241 | 76 | 12 | 91.6 | 0 | 2 | 229 | 128 | 203 | WP_106368265.1 sugar phosphate isomerase/epimerase family protein [Chlorogloea sp. CCALA 695] | diamond | 228 | 132 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Chroococcales | Entophysalidaceae | Chlorogloea | Chlorogloea sp. CCALA 695 | |
| 31571875 | 31571875 | PRJNA841653_P_NODE_62176_length_241_cov_0.916667_g61502_i0 | PRJNA841653 | 62176 | 241 | 0.916667 | 2.20916747 | Spirulina sp. | 1157 | Bacteria | Bacteria | 144 | 3.78e-39 | NR | MFH7243822.1 | 1157 | g61502 | i0 | 92.8 | 1.71784232365145 | 69 | 5 | 85.9 | 0 | 25 | 231 | 374 | 442 | MFH7243822.1 DUF1254 domain-containing protein [Spirulina sp.] | diamond | 414 | 144 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Spirulinales | Spirulinaceae | Spirulina | Spirulina sp. | |
| 32362845 | 32362845 | PRJNA841653_P_NODE_60299_length_242_cov_0.911243_g59625_i0 | PRJNA841653 | 60299 | 242 | 0.911243 | 2.20520806 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 116 | 2.78e-28 | NR | MDX1986241.1 | 2711154 | g59625 | i0 | 69.6 | 0.979338842975207 | 79 | 24 | 97.9 | 0 | 238 | 2 | 403 | 481 | MDX1986241.1 IS1380 family transposase [Candidatus Obscuribacter sp.] | diamond | 237 | 116 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 32489355 | 32489355 | PRJNA841653_P_NODE_23819_length_334_cov_0.885057_g23145_i0 | PRJNA841653 | 23819 | 334 | 0.885057 | 2.95609038 | Mastigocladopsis repens | 221287 | Bacteria | Bacteria | 58.9 | 2.35e-7 | NR | WP_017317028.1 | 221287 | g23145 | i0 | 41.1 | 0.808383233532934 | 90 | 49 | 80.8 | 2 | 28 | 297 | 521 | 606 | WP_017317028.1 beta strand repeat-containing protein [Mastigocladopsis repens] | diamond | 270 | 58.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Cyanobacteriota | Cyanophyceae | Nostocales | Symphyonemataceae | Mastigocladopsis | Mastigocladopsis repens | |
| 32709860 | 32709860 | PRJNA841653_P_NODE_50360_length_247_cov_0.885057_g49686_i0 | PRJNA841653 | 50360 | 247 | 0.885057 | 2.18609079 | Candidatus Sericytochromatia bacterium | 2762020 | Bacteria | Bacteria | 87 | 3.21e-18 | NR | MFN8578816.1 | 2762020 | g49686 | i0 | 61.4 | 0.850202429149798 | 70 | 27 | 85 | 0 | 4 | 213 | 137 | 206 | MFN8578816.1 BatD family protein [Candidatus Sericytochromatia bacterium] | diamond | 210 | 87 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Sericytochromatia | Candidatus Sericytochromatia bacterium | |||||
| 32907199 | 32907199 | PRJNA841653_P_NODE_45200_length_250_cov_0.870056_g44526_i0 | PRJNA841653 | 45200 | 250 | 0.870056 | 2.17514 | Bacillati | 1783272 | Bacteria | Bacteria | 55.8 | 9.74e-7 | NR | OGI03100.1 | 1821775 | g44526 | i0 | 42.2 | 2.364 | 64 | 36 | 75.6 | 1 | 62 | 250 | 298 | 361 | OGI03100.1 MAG: hypothetical protein A2X42_00500 [Candidatus Margulisbacteria bacterium GWF2_38_17] | diamond | 591 | 55.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Margulisiibacteriota | Candidatus Margulisbacteria bacterium GWF2_38_17 |
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);;