contig_metadata
17 rows where bioproject = "PRJEB75230" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20537819 | 20537819 | PRJEB75230_P_NODE_20477_length_382_cov_1.423948_g20295_i0 | PRJEB75230 | 20477 | 382 | 1.423948 | 5.43948136 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 132 | 4.38e-36 | NR | MBL8086383.1 | 2711154 | g20295 | i0 | 74.2 | 0.698952879581152 | 89 | 19 | 66.8 | 1 | 327 | 73 | 56 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 267 | 132 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 26781141 | 26781141 | PRJEB75230_P_NODE_29421_length_351_cov_1.104317_g29239_i0 | PRJEB75230 | 29421 | 351 | 1.104317 | 3.87615267 | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | 1801609 | Bacteria | Bacteria | 51.6 | 8.42e-5 | NR | OGI09100.1 | 1801609 | g29239 | i0 | 51.2 | 0.683760683760684 | 41 | 20 | 35 | 0 | 127 | 5 | 122 | 162 | OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11] | diamond | 240 | 51.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | |||||
| 26812741 | 26812741 | PRJEB75230_P_NODE_26621_length_359_cov_1.615385_g26439_i0 | PRJEB75230 | 26621 | 359 | 1.615385 | 5.79923215 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 172 | 3.06e-49 | NR | MBX3149802.1 | 2364082 | g26439 | i0 | 65.3 | 2.96657381615599 | 118 | 41 | 98.6 | 0 | 355 | 2 | 165 | 282 | MBX3149802.1 NAD(P)-binding domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 1065 | 172 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27002357 | 27002357 | PRJEB75230_P_NODE_27162_length_358_cov_0.719298_g26980_i0 | PRJEB75230 | 27162 | 358 | 0.719298 | 2.57508684 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 96.3 | 3.29e-22 | NR | MBL8086383.1 | 2711154 | g26980 | i0 | 74.2 | 0.553072625698324 | 66 | 13 | 52 | 1 | 3 | 188 | 58 | 123 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 198 | 96.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 27539846 | 27539846 | PRJEB75230_P_NODE_171044_length_243_cov_0.905882_g170862_i0 | PRJEB75230 | 171044 | 243 | 0.905882 | 2.20129326 | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | 2013813 | Bacteria | Bacteria | 43.1 | 0.0262 | NR | PKL76409.1 | 2013813 | g170862 | i0 | 37.7 | 0.950617283950617 | 77 | 35 | 93.8 | 3 | 240 | 13 | 118 | 182 | PKL76409.1 MAG: sulfate adenylyltransferase subunit CysD [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1] | diamond | 231 | 43.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium HGW-Melainabacteria-1 | |||||
| 27658990 | 27658990 | PRJEB75230_P_NODE_45264_length_319_cov_1.252033_g45082_i0 | PRJEB75230 | 45264 | 319 | 1.252033 | 3.99398527 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 132 | 4.1600000000000003e-36 | NR | MBI3590799.1 | 2052166 | g45082 | i0 | 59.3 | 5.90595611285266 | 108 | 40 | 97.8 | 2 | 6 | 317 | 85 | 192 | MBI3590799.1 SDR family oxidoreductase [Candidatus Melainabacteria bacterium] | diamond | 1884 | 133 | 0.992481203007519 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27950304 | 27950304 | PRJEB75230_P_NODE_157985_length_245_cov_0.895349_g157803_i0 | PRJEB75230 | 157985 | 245 | 0.895349 | 2.19360505 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 100 | 2.5e-24 | NR | MBL8086383.1 | 2711154 | g157803 | i0 | 71.8 | 0.869387755102041 | 71 | 16 | 82 | 1 | 2 | 202 | 74 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 213 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28013560 | 28013560 | PRJEB75230_P_NODE_15265_length_412_cov_1.814159_g15083_i0 | PRJEB75230 | 15265 | 412 | 1.814159 | 7.47433508 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 101 | 4.52e-23 | NR | MFA6211348.1 | 2364082 | g15083 | i0 | 53.9 | 1.5873786407767 | 89 | 38 | 64.8 | 1 | 141 | 407 | 52 | 137 | MFA6211348.1 NUDIX domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 654 | 101 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28265762 | 28265762 | PRJEB75230_P_NODE_113806_length_253_cov_1.711111_g113624_i0 | PRJEB75230 | 113806 | 253 | 1.711111 | 4.32911083 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 45.1 | 0.00395 | NR | MBL8086383.1 | 2711154 | g113624 | i0 | 64.1 | 0.462450592885375 | 39 | 13 | 45.1 | 1 | 248 | 135 | 106 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 117 | 45.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28392269 | 28392269 | PRJEB75230_P_NODE_3746_length_704_cov_3.115689_g3572_i0 | PRJEB75230 | 3746 | 704 | 3.115689 | 21.93445056 | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | 1801609 | Bacteria | Bacteria | 58.5 | 4.36e-6 | NR | OGI09100.1 | 1801609 | g3572 | i0 | 52.5 | 0.703125 | 40 | 19 | 17 | 0 | 148 | 29 | 127 | 166 | OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11] | diamond | 495 | 58.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 | |||||
| 28581857 | 28581857 | PRJEB75230_P_NODE_132667_length_249_cov_0.875000_g132485_i0 | PRJEB75230 | 132667 | 249 | 0.875 | 2.17875 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 56.6 | 1.78e-7 | NR | MBL8086383.1 | 2711154 | g132485 | i0 | 71.8 | 0.469879518072289 | 39 | 11 | 47 | 0 | 245 | 129 | 106 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 117 | 56.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29781487 | 29781487 | PRJEB75230_P_NODE_146231_length_247_cov_0.885057_g146049_i0 | PRJEB75230 | 146231 | 247 | 0.885057 | 2.18609079 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 46.6 | 0.00174 | NR | MCC6979099.1 | 2052166 | g146049 | i0 | 33.8 | 1.74898785425101 | 65 | 43 | 78.9 | 0 | 52 | 246 | 542 | 606 | MCC6979099.1 protein kinase [Candidatus Melainabacteria bacterium] | diamond | 432 | 46.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30097292 | 30097292 | PRJEB75230_P_NODE_171472_length_243_cov_0.905882_g171290_i0 | PRJEB75230 | 171472 | 243 | 0.905882 | 2.20129326 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 160 | 3.15e-46 | NR | RTL45965.1 | 2052166 | g171290 | i0 | 91.3 | 0.987654320987654 | 80 | 7 | 98.8 | 0 | 2 | 241 | 221 | 300 | RTL45965.1 MAG: hypothetical protein EKK48_01085 [Candidatus Melainabacteria bacterium] | diamond | 240 | 160 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30192105 | 30192105 | PRJEB75230_P_NODE_28412_length_354_cov_1.081851_g28230_i0 | PRJEB75230 | 28412 | 354 | 1.081851 | 3.82975254 | Vampirovibrio chlorellavorus | 758823 | Bacteria | Bacteria | 52.4 | 3.78e-5 | NR | WP_303673549.1 | 758823 | g28230 | i0 | 30.2 | 1.55932203389831 | 86 | 50 | 72.9 | 1 | 270 | 13 | 41 | 116 | WP_303673549.1 class I SAM-dependent methyltransferase [Vampirovibrio chlorellavorus] | diamond | 552 | 52.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio chlorellavorus | ||
| 30476714 | 30476714 | PRJEB75230_P_NODE_60073_length_299_cov_1.606195_g59891_i0 | PRJEB75230 | 60073 | 299 | 1.606195 | 4.80252305 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 122 | 6.32e-33 | NR | MBL8086383.1 | 2711154 | g59891 | i0 | 77.8 | 0.812709030100334 | 81 | 14 | 77.3 | 1 | 299 | 69 | 62 | 142 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 243 | 122 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31456370 | 31456370 | PRJEB75230_P_NODE_152936_length_245_cov_1.877907_g152754_i0 | PRJEB75230 | 152936 | 245 | 1.877907 | 4.60087215 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 90.9 | 1.02e-20 | NR | MBL8086383.1 | 2711154 | g152754 | i0 | 70.1 | 0.820408163265306 | 67 | 16 | 77.1 | 1 | 54 | 242 | 56 | 122 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 201 | 90.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31551435 | 31551435 | PRJEB75230_P_NODE_32776_length_342_cov_1.527881_g32594_i0 | PRJEB75230 | 32776 | 342 | 1.527881 | 5.22535302 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 76.6 | 1.19e-14 | NR | MBL8086383.1 | 2711154 | g32594 | i0 | 52.1 | 0.640350877192982 | 73 | 34 | 64 | 1 | 10 | 228 | 70 | 141 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 219 | 76.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. |
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);;