contig_metadata
18 rows where analysis = "diamond" and tax_phylum = "Candidatus Edwardsiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7045551 | 7045551 | PRJNA688352_P_NODE_8306_length_249_cov_0.875000_g8203_i0 | PRJNA688352 | 8306 | 249 | 0.875 | 2.17875 | Candidatus Edwardsbacteria bacterium RifOxyC12_full_54_24 | 1817854 | Bacteria | Bacteria | 144 | 5.6e-38 | NR | OGF01300.1 | 1817854 | g8203 | i0 | 84.1 | 0.987951807228916 | 82 | 13 | 98.8 | 0 | 248 | 3 | 99 | 180 | OGF01300.1 MAG: hypothetical protein A2502_00815 [Candidatus Edwardsbacteria bacterium RifOxyC12_full_54_24] | diamond | 246 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium RifOxyC12_full_54_24 | ||||||
| 16732798 | 16732798 | PRJNA1011844_P_NODE_119194_length_285_cov_1.113208_g110617_i0 | PRJNA1011844 | 119194 | 285 | 1.113208 | 3.1726428 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 79.3 | 3.5e-15 | NR | MEW6686044.1 | 2053551 | g110617 | i0 | 59.3 | 0.621052631578947 | 59 | 24 | 62.1 | 0 | 83 | 259 | 1 | 59 | MEW6686044.1 UDP-glucuronic acid decarboxylase family protein [Candidatus Edwardsbacteria bacterium] | diamond | 177 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 28091114 | 28091114 | PRJNA615351_P_NODE_51765_length_701_cov_7.662162_g9850_i5 | PRJNA615351 | 51765 | 701 | 7.662162 | 53.71175562 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 47 | 0.0428 | NR | MBU1355397.1 | 2053551 | g9850 | i5 | 26.9 | 0.714693295292439 | 167 | 102 | 71.5 | 4 | 504 | 4 | 54 | 200 | MBU1355397.1 tetratricopeptide repeat protein [Candidatus Edwardsbacteria bacterium] | diamond | 501 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 28459996 | 28459996 | PRJNA1123436_P_NODE_110866_length_246_cov_0.890173_g109652_i0 | PRJNA1123436 | 110866 | 246 | 0.890173 | 2.18982558 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 121 | 7.539999999999999e-31 | NR | MDI6740128.1 | 2053551 | g109652 | i0 | 76.9 | 0.951219512195122 | 78 | 18 | 95.1 | 0 | 2 | 235 | 45 | 122 | MDI6740128.1 hypothetical protein [Candidatus Edwardsbacteria bacterium] | diamond | 234 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 28915737 | 28915737 | PRJNA752278_P_NODE_19908_length_356_cov_1.045936_g19705_i0 | PRJNA752278 | 19908 | 356 | 1.045936 | 3.72353216 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 72 | 2.84e-12 | NR | MDI6738736.1 | 2053551 | g19705 | i0 | 39.8 | 1.23876404494382 | 93 | 52 | 76.7 | 2 | 2 | 274 | 174 | 264 | MDI6738736.1 alpha/beta hydrolase [Candidatus Edwardsbacteria bacterium] | diamond | 441 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 29229821 | 29229821 | PRJNA688352_P_NODE_7369_length_251_cov_0.865169_g7266_i0 | PRJNA688352 | 7369 | 251 | 0.865169 | 2.17157419 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 102 | 7.63e-24 | NR | MBU1356442.1 | 2053551 | g7266 | i0 | 75 | 0.764940239043825 | 64 | 16 | 76.5 | 0 | 192 | 1 | 109 | 172 | MBU1356442.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Edwardsbacteria bacterium] | diamond | 192 | 102 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 29502116 | 29502116 | PRJNA1148190_P_NODE_159190_length_417_cov_1.491279_g148023_i0 | PRJNA1148190 | 159190 | 417 | 1.491279 | 6.21863343 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 47.8 | 0.00128 | NR | MEW6687264.1 | 2053551 | g148023 | i0 | 31.1 | 0.762589928057554 | 106 | 54 | 65.5 | 5 | 276 | 4 | 5 | 106 | MEW6687264.1 hypothetical protein [Candidatus Edwardsbacteria bacterium] | diamond | 318 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 30607818 | 30607818 | PRJNA1148190_P_NODE_226153_length_357_cov_2.063380_g214983_i0 | PRJNA1148190 | 226153 | 357 | 2.06338 | 7.3662666 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 44.3 | 0.00747 | NR | MCU0608023.1 | 2053551 | g214983 | i0 | 29.9 | 0.73109243697479 | 87 | 50 | 66.4 | 2 | 76 | 312 | 18 | 101 | MCU0608023.1 hypothetical protein [Candidatus Edwardsbacteria bacterium] | diamond | 261 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 30896327 | 30896327 | PRJNA340009_P_NODE_23454_length_252_cov_1.911330_g23147_i0 | PRJNA340009 | 23454 | 252 | 1.91133 | 4.8165516 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 55.8 | 9.46e-7 | NR | MEW6687265.1 | 2053551 | g23147 | i0 | 38.2 | 0.80952380952381 | 68 | 41 | 81 | 1 | 37 | 240 | 189 | 255 | MEW6687265.1 hypothetical protein [Candidatus Edwardsbacteria bacterium] | diamond | 204 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 30914420 | 30914420 | PRJNA550047_P_NODE_238894_length_300_cov_20.154185_g236925_i0 | PRJNA550047 | 238894 | 300 | 20.154185 | 60.462555 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.4 | 0.00816 | NR | MCU0607806.1 | 2053551 | g236925 | i0 | 31.6 | 1.47 | 57 | 39 | 57 | 0 | 186 | 16 | 343 | 399 | MCU0607806.1 tetratricopeptide repeat protein [Candidatus Edwardsbacteria bacterium] | diamond | 441 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 30964744 | 30964744 | PRJNA600413_P_NODE_72254_length_185_cov_1.183824_g71553_i0 | PRJNA600413 | 72254 | 185 | 1.183824 | 2.1900744 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 62.8 | 7.96e-10 | NR | MBU1577558.1 | 2053551 | g71553 | i0 | 49.2 | 2.88648648648649 | 59 | 29 | 95.7 | 1 | 3 | 179 | 184 | 241 | MBU1577558.1 hypothetical protein [Candidatus Edwardsbacteria bacterium] | diamond | 534 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 31313712 | 31313712 | PRJNA661142_P_NODE_11695_length_166_cov_0.871795_g11630_i0 | PRJNA661142 | 11695 | 166 | 0.871795 | 1.4471797 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 58.5 | 3.4e-8 | NR | MEW6685952.1 | 2053551 | g11630 | i0 | 52.9 | 0.921686746987952 | 51 | 24 | 92.2 | 0 | 6 | 158 | 476 | 526 | MEW6685952.1 MG2 domain-containing protein [Candidatus Edwardsbacteria bacterium] | diamond | 153 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 31555850 | 31555850 | PRJNA1123436_P_NODE_119676_length_243_cov_0.905882_g118462_i0 | PRJNA1123436 | 119676 | 243 | 0.905882 | 2.20129326 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 112 | 2.57e-27 | NR | MEW6686036.1 | 2053551 | g118462 | i0 | 65 | 0.987654320987654 | 80 | 28 | 98.8 | 0 | 2 | 241 | 143 | 222 | MEW6686036.1 glycosyltransferase family 2 protein [Candidatus Edwardsbacteria bacterium] | diamond | 240 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 31980580 | 31980580 | PRJNA738523_P_NODE_12138_length_248_cov_0.880000_g12067_i0 | PRJNA738523 | 12138 | 248 | 0.88 | 2.1824 | Candidatus Edwardsbacteria bacterium RifOxyC12_full_54_24 | 1817854 | Bacteria | Bacteria | 44.7 | 0.00814 | NR | OGF05907.1 | 1817854 | g12067 | i0 | 39.3 | 0.67741935483871 | 56 | 34 | 67.7 | 0 | 47 | 214 | 427 | 482 | OGF05907.1 MAG: hypothetical protein A2502_08990 [Candidatus Edwardsbacteria bacterium RifOxyC12_full_54_24] | diamond | 168 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium RifOxyC12_full_54_24 | ||||||
| 32257649 | 32257649 | PRJNA438111_P_NODE_32098_length_210_cov_3.524862_g31473_i0 | PRJNA438111 | 32098 | 210 | 3.524862 | 7.4022102 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 51.6 | 1.68e-5 | NR | MEW6686141.1 | 2053551 | g31473 | i0 | 51.5 | 1.41428571428571 | 33 | 16 | 47.1 | 0 | 111 | 209 | 204 | 236 | MEW6686141.1 GNAT family N-acetyltransferase [Candidatus Edwardsbacteria bacterium] | diamond | 297 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 32304472 | 32304472 | PRJNA1148190_P_NODE_430879_length_280_cov_1.429952_g419706_i0 | PRJNA1148190 | 430879 | 280 | 1.429952 | 4.0038656 | Bacteria | 2 | Bacteria | Bacteria | 155 | 2.5899999999999993e-46 | NR | MDI6740731.1 | 2053551 | g419706 | i0 | 71.9 | 7.84285714285714 | 89 | 25 | 95.4 | 0 | 2 | 268 | 7 | 95 | MDI6740731.1 IS200/IS605 family transposase [Candidatus Edwardsbacteria bacterium] | diamond | 2196 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 33067932 | 33067932 | PRJNA1233465a_S_NODE_116573_length_216_cov_0.988024_g115299_i0 | PRJNA1233465 | 116573 | 216 | 0.988024 | 2.13413184 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 40.8 | 0.0407 | NR | MBU1357029.1 | 2053551 | g115299 | i0 | 41.9 | 0.597222222222222 | 43 | 25 | 59.7 | 0 | 135 | 7 | 45 | 87 | MBU1357029.1 hypothetical protein [Candidatus Edwardsbacteria bacterium] | diamond | 129 | 40.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria bacterium | ||||||
| 33081743 | 33081743 | PRJEB20058_P_NODE_204254_length_253_cov_2.661458_g201430_i0 | PRJEB20058 | 204254 | 253 | 2.661458 | 6.73348874 | Candidatus Edwardsbacteria bacterium | 2053551 | Bacteria | Bacteria | 138 | 5.31e-36 | NR | MBU1355752.1 | 2053551 | g201430 | i0 | 83.3 | 0.924901185770751 | 78 | 13 | 92.5 | 0 | 250 | 17 | 183 | 260 | MBU1355752.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Edwardsbacteria bacterium] | diamond | 234 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Edwardsiibacteriota | Candidatus Edwardsbacteria 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);;