contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5733927 | 5733927 | PRJNA666695_S_NODE_125145_length_196_cov_2.374194_g124051_i0 | PRJNA666695 | 125145 | 196 | 2.374194 | 4.65342024 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 87.8 | 9.51e-20 | NR | MBX9809928.1 | 2044595 | g124051 | i0 | 87.5 | 0.73469387755102 | 48 | 6 | 73.5 | 0 | 196 | 53 | 142 | 189 | MBX9809928.1 sigma-70 family RNA polymerase sigma factor [Candidatus Altimarinota bacterium] | diamond | 144 | 87.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 17208452 | 17208452 | PRJNA666695_S_NODE_123654_length_197_cov_3.750000_g122560_i0 | PRJNA666695 | 123654 | 197 | 3.75 | 7.3875 | Bacteria | 2 | Bacteria | Bacteria | 106 | 1.46e-25 | NR | PIQ41343.1 | 1974579 | g122560 | i0 | 84.6 | 7.91878172588832 | 65 | 10 | 99 | 0 | 3 | 197 | 184 | 248 | PIQ41343.1 MAG: DEAD/DEAH box helicase, partial [Candidatus Gracilibacteria bacterium CG12_big_fil_rev_8_21_14_0_65_38_15] | diamond | 1560 | 107 | 0.990654205607477 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG12_big_fil_rev_8_21_14_0_65_38_15 | ||||||
| 19757094 | 19757094 | PRJNA666695_S_NODE_111716_length_208_cov_2.203593_g110622_i0 | PRJNA666695 | 111716 | 208 | 2.203593 | 4.58347344 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 120 | 7.589999999999999e-30 | NR | MBX9808813.1 | 2044595 | g110622 | i0 | 85.5 | 0.995192307692308 | 69 | 10 | 99.5 | 0 | 2 | 208 | 770 | 838 | MBX9808813.1 ATP-dependent Clp protease ATP-binding subunit [Candidatus Altimarinota bacterium] | diamond | 207 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 20289477 | 20289477 | PRJNA666695_S_NODE_49856_length_294_cov_2.071146_g48762_i0 | PRJNA666695 | 49856 | 294 | 2.071146 | 6.08916924 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 176 | 2.09e-50 | NR | MBX9809704.1 | 2044595 | g48762 | i0 | 92.8 | 5.89795918367347 | 97 | 7 | 99 | 0 | 292 | 2 | 82 | 178 | MBX9809704.1 translational GTPase TypA [Candidatus Altimarinota bacterium] | diamond | 1734 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 23583139 | 23583139 | PRJNA666695_S_NODE_125719_length_196_cov_1.412903_g124625_i0 | PRJNA666695 | 125719 | 196 | 1.412903 | 2.76928988 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 106 | 8.71e-25 | NR | MDD2694056.1 | 2044595 | g124625 | i0 | 87.7 | 1.74489795918367 | 57 | 7 | 87.2 | 0 | 196 | 26 | 752 | 808 | MDD2694056.1 type I DNA topoisomerase [Candidatus Altimarinota bacterium] | diamond | 342 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 26840734 | 26840734 | PRJNA666695_S_NODE_190661_length_153_cov_1.232143_g189567_i0 | PRJNA666695 | 190661 | 153 | 1.232143 | 1.88517879 | Bacteria | 2 | Bacteria | Bacteria | 84.3 | 2.18e-17 | NR | MFA5843086.1 | 2044595 | g189567 | i0 | 76 | 38.0196078431373 | 50 | 12 | 98 | 0 | 151 | 2 | 400 | 449 | MFA5843086.1 ATP-binding cassette domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 5817 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27081477 | 27081477 | PRJNA666695_S_NODE_14522_length_469_cov_7.196262_g13435_i0 | PRJNA666695 | 14522 | 469 | 7.196262 | 33.75046878 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 59.7 | 4.4e-7 | NR | MDD3646848.1 | 2044595 | g13435 | i0 | 31.2 | 3.12153518123667 | 109 | 67 | 66.5 | 2 | 407 | 96 | 3 | 108 | MDD3646848.1 Ig-like domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 1464 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27902647 | 27902647 | PRJNA666695_S_NODE_88605_length_232_cov_2.408377_g87511_i0 | PRJNA666695 | 88605 | 232 | 2.408377 | 5.58743464 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 134 | 2.35e-34 | NR | MBX9809032.1 | 2044595 | g87511 | i0 | 84.2 | 0.982758620689655 | 76 | 12 | 98.3 | 0 | 232 | 5 | 513 | 588 | MBX9809032.1 beta-propeller domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 228 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28029222 | 28029222 | PRJNA666695_S_NODE_43445_length_310_cov_2.565056_g42351_i0 | PRJNA666695 | 43445 | 310 | 2.565056 | 7.9516736 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 106 | 3.79e-24 | NR | MBX9809025.1 | 2044595 | g42351 | i0 | 66.3 | 0.803225806451613 | 83 | 28 | 80.3 | 0 | 61 | 309 | 309 | 391 | MBX9809025.1 biotin/lipoyl-binding protein [Candidatus Altimarinota bacterium] | diamond | 249 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28123806 | 28123806 | PRJNA666695_S_NODE_151645_length_176_cov_2.385185_g150551_i0 | PRJNA666695 | 151645 | 176 | 2.385185 | 4.1979256 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 118 | 2.6199999999999997e-30 | NR | MBX9808805.1 | 2044595 | g150551 | i0 | 96.6 | 0.988636363636364 | 58 | 2 | 98.9 | 0 | 3 | 176 | 228 | 285 | MBX9808805.1 histidine--tRNA ligase [Candidatus Altimarinota bacterium] | diamond | 174 | 118 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28218244 | 28218244 | PRJNA666695_S_NODE_13926_length_477_cov_7.206422_g12839_i0 | PRJNA666695 | 13926 | 477 | 7.206422 | 34.37463294 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 59.3 | 6.48e-7 | NR | MDD3646848.1 | 2044595 | g12839 | i0 | 31.2 | 2.31446540880503 | 109 | 67 | 65.4 | 2 | 63 | 374 | 3 | 108 | MDD3646848.1 Ig-like domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 1104 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29512954 | 29512954 | PRJNA666695_S_NODE_95550_length_224_cov_3.267760_g94456_i0 | PRJNA666695 | 95550 | 224 | 3.26776 | 7.3197824 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 129 | 6.919999999999999e-34 | NR | MBC7503922.1 | 2044595 | g94456 | i0 | 89.2 | 0.991071428571429 | 74 | 8 | 99.1 | 0 | 3 | 224 | 6 | 79 | MBC7503922.1 S1 RNA-binding domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 222 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29575937 | 29575937 | PRJNA666695_S_NODE_144950_length_181_cov_1.971429_g143856_i0 | PRJNA666695 | 144950 | 181 | 1.971429 | 3.56828649 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 60.8 | 6.67e-9 | NR | MBX9809025.1 | 2044595 | g143856 | i0 | 70 | 0.662983425414365 | 40 | 12 | 66.3 | 0 | 181 | 62 | 432 | 471 | MBX9809025.1 biotin/lipoyl-binding protein [Candidatus Altimarinota bacterium] | diamond | 120 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29670540 | 29670540 | PRJNA666695_S_NODE_147930_length_179_cov_1.666667_g146836_i0 | PRJNA666695 | 147930 | 179 | 1.666667 | 2.98333393 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 72 | 1.7e-13 | NR | MBX9809335.1 | 2044595 | g146836 | i0 | 82.9 | 0.687150837988827 | 41 | 7 | 68.7 | 0 | 57 | 179 | 101 | 141 | MBX9809335.1 PKD domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 123 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29860411 | 29860411 | PRJNA666695_S_NODE_90551_length_230_cov_1.947090_g89457_i0 | PRJNA666695 | 90551 | 230 | 1.94709 | 4.478307 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 60.1 | 2.39e-8 | NR | MBX9809298.1 | 2044595 | g89457 | i0 | 83.9 | 0.404347826086957 | 31 | 5 | 40.4 | 0 | 90 | 182 | 446 | 476 | MBX9809298.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 93 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31535515 | 31535515 | PRJNA666695_S_NODE_69396_length_257_cov_6.375000_g68302_i0 | PRJNA666695 | 69396 | 257 | 6.375 | 16.38375 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 62.4 | 2.4e-9 | NR | MDD3302265.1 | 2044595 | g68302 | i0 | 42.9 | 0.735408560311284 | 63 | 35 | 73.5 | 1 | 255 | 67 | 149 | 210 | MDD3302265.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 189 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31693348 | 31693348 | PRJNA666695_S_NODE_123097_length_198_cov_1.757962_g122003_i0 | PRJNA666695 | 123097 | 198 | 1.757962 | 3.48076476 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 65.1 | 2.64e-10 | NR | MBC7498862.1 | 2044595 | g122003 | i0 | 72.1 | 1.95454545454545 | 43 | 12 | 65.2 | 0 | 68 | 196 | 238 | 280 | MBC7498862.1 ABC-F family ATP-binding cassette domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 387 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium |
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);;