contig_metadata
24 rows where bioproject = "PRJNA704949", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3244842 | 3244842 | PRJNA704949_P_NODE_1965183_length_168_cov_0.873950_g1949844_i0 | PRJNA704949 | 1965183 | 168 | 0.87395 | 1.468236 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 278 | 2.14e-70 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g1949844 | i0 | 96.429 | 1 | 168 | 6 | 100 | 0 | 1 | 168 | 585814 | 585647 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 168 | 278 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 4515161 | 4515161 | PRJNA704949_P_NODE_1132664_length_241_cov_1.114583_g1117328_i0 | PRJNA704949 | 1132664 | 241 | 1.114583 | 2.68614503 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 130 | 1.05e-35 | NR | RKW24780.1 | 2044595 | g1117328 | i0 | 95.6 | 0.846473029045643 | 68 | 3 | 84.6 | 0 | 222 | 19 | 165 | 232 | RKW24780.1 MAG: 3-methyladenine DNA glycosylase [Candidatus Altimarinota bacterium] | diamond | 204 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 4529643 | 4529643 | PRJNA704949_P_NODE_850024_length_287_cov_2.180672_g834690_i0 | PRJNA704949 | 850024 | 287 | 2.180672 | 6.25852864 | Bacteria | 2 | Bacteria | Bacteria | 177 | 9.49e-50 | NR | RKW23813.1 | 2044595 | g834690 | i0 | 100 | 1.86062717770035 | 89 | 0 | 93 | 0 | 3 | 269 | 623 | 711 | RKW23813.1 MAG: hypothetical protein D8B45_02995 [Candidatus Altimarinota bacterium] | diamond | 534 | 177 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 7077852 | 7077852 | PRJNA704949_P_NODE_605866_length_348_cov_3.742475_g590543_i0 | PRJNA704949 | 605866 | 348 | 3.742475 | 13.023813 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 241 | 2.09e-76 | NR | RKW20028.1 | 2044595 | g590543 | i0 | 99.1 | 0.991379310344828 | 115 | 1 | 99.1 | 0 | 3 | 347 | 207 | 321 | RKW20028.1 MAG: serine--tRNA ligase [Candidatus Altimarinota bacterium] | diamond | 345 | 241 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 8339690 | 8339690 | PRJNA704949_P_NODE_1071567_length_249_cov_2.150000_g1056231_i0 | PRJNA704949 | 1071567 | 249 | 2.15 | 5.3535 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 116 | 4.69e-28 | NR | RKW23823.1 | 2044595 | g1056231 | i0 | 96.6 | 1.42168674698795 | 59 | 2 | 71.1 | 0 | 53 | 229 | 145 | 203 | RKW23823.1 MAG: pyruvate, phosphate dikinase, partial [Candidatus Altimarinota bacterium] | diamond | 354 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 18542515 | 18542515 | PRJNA704949_P_NODE_1596155_length_193_cov_1.201389_g1580816_i0 | PRJNA704949 | 1596155 | 193 | 1.201389 | 2.31868077 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 346 | 6.82e-91 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g1580816 | i0 | 98.964 | 1 | 193 | 2 | 100 | 0 | 1 | 193 | 710241 | 710433 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 193 | 346 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 21102515 | 21102515 | PRJNA704949_P_NODE_709697_length_319_cov_2.388889_g694368_i0 | PRJNA704949 | 709697 | 319 | 2.388889 | 7.62055591 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 95.3 | 4.9e-15 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g694368 | i0 | 74.583 | 5.42319749216301 | 240 | 50 | 73 | 9 | 86 | 318 | 511500 | 511265 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1730 | 95.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 27019918 | 27019918 | PRJNA704949_P_NODE_1945382_length_169_cov_0.866667_g1930043_i0 | PRJNA704949 | 1945382 | 169 | 0.866667 | 1.46466723 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 57 | 1.23e-7 | NR | MDD2871506.1 | 2044595 | g1930043 | i0 | 86.2 | 0.514792899408284 | 29 | 4 | 51.5 | 0 | 89 | 3 | 108 | 136 | MDD2871506.1 formate C-acetyltransferase [Candidatus Altimarinota bacterium] | diamond | 87 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27051651 | 27051651 | PRJNA704949_P_NODE_2009282_length_167_cov_0.881356_g1993943_i0 | PRJNA704949 | 2009282 | 167 | 0.881356 | 1.47186452 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 92.8 | 2.34e-20 | NR | RKW21506.1 | 2044595 | g1993943 | i0 | 100 | 0.844311377245509 | 47 | 0 | 84.4 | 0 | 26 | 166 | 356 | 402 | RKW21506.1 MAG: Fe-S cluster assembly protein SufB [Candidatus Altimarinota bacterium] | diamond | 141 | 92.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27177556 | 27177556 | PRJNA704949_P_NODE_1339862_length_216_cov_1.862275_g1324524_i0 | PRJNA704949 | 1339862 | 216 | 1.862275 | 4.022514 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 122 | 2.94e-31 | NR | RKW24482.1 | 2044595 | g1324524 | i0 | 84.5 | 0.986111111111111 | 71 | 11 | 98.6 | 0 | 215 | 3 | 209 | 279 | RKW24482.1 MAG: hypothetical protein D8B45_02210, partial [Candidatus Altimarinota bacterium] | diamond | 213 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27462464 | 27462464 | PRJNA704949_P_NODE_1833823_length_175_cov_1.539683_g1818484_i0 | PRJNA704949 | 1833823 | 175 | 1.539683 | 2.69444525 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 99.8 | 8.67e-25 | NR | RKW21157.1 | 2044595 | g1818484 | i0 | 100 | 0.84 | 49 | 0 | 84 | 0 | 28 | 174 | 19 | 67 | RKW21157.1 MAG: hypothetical protein D8B45_06350 [Candidatus Altimarinota bacterium] | diamond | 147 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27567827 | 27567827 | PRJNA704949_P_NODE_1556824_length_196_cov_1.414966_g1541485_i0 | PRJNA704949 | 1556824 | 196 | 1.414966 | 2.77333336 | Bacteria | 2 | Bacteria | Bacteria | 107 | 7.35e-27 | NR | RKW20008.1 | 2044595 | g1541485 | i0 | 100 | 1.56122448979592 | 51 | 0 | 78.1 | 0 | 21 | 173 | 97 | 147 | RKW20008.1 MAG: hypothetical protein D8B45_08065 [Candidatus Altimarinota bacterium] | diamond | 306 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 27915131 | 27915131 | PRJNA704949_P_NODE_1964125_length_168_cov_0.873950_g1948786_i0 | PRJNA704949 | 1964125 | 168 | 0.87395 | 1.468236 | Bacteria | 2 | Bacteria | Bacteria | 111 | 7.91e-30 | NR | RAL56234.1 | 1914866 | g1948786 | i0 | 100 | 1.94642857142857 | 55 | 0 | 98.2 | 0 | 166 | 2 | 25 | 79 | RAL56234.1 hypothetical protein BLM37_01775 [Candidatus Gracilibacteria bacterium GN02-873] | diamond | 327 | 111 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium GN02-873 | ||||||
| 29104186 | 29104186 | PRJNA704949_P_NODE_1479908_length_203_cov_1.012987_g1464570_i0 | PRJNA704949 | 1479908 | 203 | 1.012987 | 2.05636361 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 133 | 1.0599999999999998e-37 | NR | RKW22872.1 | 2044595 | g1464570 | i0 | 98.4 | 0.931034482758621 | 63 | 1 | 93.1 | 0 | 202 | 14 | 69 | 131 | RKW22872.1 MAG: hypothetical protein D8B45_04255 [Candidatus Altimarinota bacterium] | diamond | 189 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29104348 | 29104348 | PRJNA704949_P_NODE_1952008_length_168_cov_1.747899_g1936669_i0 | PRJNA704949 | 1952008 | 168 | 1.747899 | 2.93647032 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 86.7 | 3.45e-18 | NR | RKW24482.1 | 2044595 | g1936669 | i0 | 80 | 0.892857142857143 | 50 | 10 | 89.3 | 0 | 11 | 160 | 147 | 196 | RKW24482.1 MAG: hypothetical protein D8B45_02210, partial [Candidatus Altimarinota bacterium] | diamond | 150 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29798517 | 29798517 | PRJNA704949_P_NODE_1271411_length_224_cov_1.188571_g1256074_i0 | PRJNA704949 | 1271411 | 224 | 1.188571 | 2.66239904 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 73.6 | 3.93e-13 | NR | MDO4874412.1 | 2044595 | g1256074 | i0 | 64.4 | 0.790178571428571 | 59 | 21 | 79 | 0 | 191 | 15 | 331 | 389 | MDO4874412.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 177 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30557106 | 30557106 | PRJNA704949_P_NODE_740753_length_312_cov_1.022814_g725424_i0 | PRJNA704949 | 740753 | 312 | 1.022814 | 3.19117968 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 144 | 8.76e-41 | NR | RKW22980.1 | 2044595 | g725424 | i0 | 92.2 | 0.740384615384615 | 77 | 6 | 74 | 0 | 311 | 81 | 99 | 175 | RKW22980.1 MAG: DUF4956 domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 231 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30820799 | 30820799 | PRJNA704949_P_NODE_518134_length_378_cov_2.212766_g502853_i0 | PRJNA704949 | 518134 | 378 | 2.212766 | 8.36425548 | Bacteria | 2 | Bacteria | Bacteria | 171 | 8.499999999999998e-48 | NR | RKW22241.1 | 2044595 | g502853 | i0 | 70.7 | 1.80952380952381 | 116 | 34 | 92.1 | 0 | 357 | 10 | 117 | 232 | RKW22241.1 MAG: DUF4153 domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 684 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30936610 | 30936610 | PRJNA704949_P_NODE_774294_length_304_cov_1.223529_g758963_i0 | PRJNA704949 | 774294 | 304 | 1.223529 | 3.71952816 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 183 | 1.21e-51 | NR | MBB1554449.1 | 2044595 | g758963 | i0 | 96.8 | 0.927631578947368 | 94 | 3 | 92.8 | 0 | 23 | 304 | 338 | 431 | MBB1554449.1 penicillin-binding protein 2 [Candidatus Altimarinota bacterium] | diamond | 282 | 183 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31167983 | 31167983 | PRJNA704949_P_NODE_2152895_length_162_cov_1.840708_g2137556_i0 | PRJNA704949 | 2152895 | 162 | 1.840708 | 2.98194696 | Bacteria | 2 | Bacteria | Bacteria | 71.2 | 1.12e-12 | NR | RKW21685.1 | 2044595 | g2137556 | i0 | 96.9 | 1.77777777777778 | 32 | 1 | 59.3 | 0 | 132 | 37 | 1517 | 1548 | RKW21685.1 MAG: hypothetical protein D8B45_05685, partial [Candidatus Altimarinota bacterium] | diamond | 288 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31231330 | 31231330 | PRJNA704949_P_NODE_847355_length_288_cov_1.389121_g832021_i0 | PRJNA704949 | 847355 | 288 | 1.389121 | 4.00066848 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 95.9 | 2.39e-21 | NR | NJM06486.1 | 2044595 | g832021 | i0 | 54.2 | 2.78125 | 96 | 43 | 100 | 1 | 1 | 288 | 9 | 103 | NJM06486.1 SDR family oxidoreductase [Candidatus Altimarinota bacterium] | diamond | 801 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32264738 | 32264738 | PRJNA704949_P_NODE_171138_length_626_cov_1.793761_g157389_i0 | PRJNA704949 | 171138 | 626 | 1.793761 | 11.22894386 | Candidatus Gracilibacteria bacterium GN | 2044595 | Bacteria | Bacteria | 367 | 1.07e-117 | NR | RAL55368.1 | 1914866 | g157389 | i0 | 99.5 | 0.996805111821086 | 208 | 1 | 99.7 | 0 | 1 | 624 | 113 | 320 | RAL55368.1 hypothetical protein BLM37_03915 [Candidatus Gracilibacteria bacterium GN02-873] | diamond | 624 | 367 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium GN02-873 | ||||||
| 32706462 | 32706462 | PRJNA704949_P_NODE_1171720_length_236_cov_1.080214_g1156383_i0 | PRJNA704949 | 1171720 | 236 | 1.080214 | 2.54930504 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 45.4 | 0.00255 | NR | MCK9272071.1 | 2044595 | g1156383 | i0 | 81.8 | 0.851694915254237 | 22 | 4 | 28 | 0 | 121 | 56 | 170 | 191 | MCK9272071.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 201 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32706625 | 32706625 | PRJNA704949_P_NODE_1715440_length_184_cov_1.155556_g1700101_i0 | PRJNA704949 | 1715440 | 184 | 1.155556 | 2.12622304 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 122 | 4.6699999999999996e-32 | NR | MBF0981206.1 | 2044595 | g1700101 | i0 | 96.7 | 0.994565217391304 | 61 | 2 | 99.5 | 0 | 2 | 184 | 227 | 287 | MBF0981206.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 183 | 122 | 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);;