contig_metadata
11 rows where bioproject = "PRJNA690592", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Binatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671242 | 671242 | PRJNA690592_S_NODE_179401_length_255_cov_1.527473_g178387_i0 | PRJNA690592 | 179401 | 255 | 1.527473 | 3.89505615 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 65.8 | 2.98e-6 | NTclustered | gi|2546137839|emb|OY282432.1| | 3036252 | g178387 | i0 | 100 | 0.137254901960784 | 35 | 0 | 14 | 0 | 25 | 59 | 2719579 | 2719545 | MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 | blastn | 35 | 65.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 7050460 | 7050460 | PRJNA690592_S_NODE_52966_length_429_cov_1.460674_g51952_i0 | PRJNA690592 | 52966 | 429 | 1.460674 | 6.26629146 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 179 | 9.71e-53 | NR | GIW43074.1 | 2838779 | g51952 | i0 | 57.9 | 3.91608391608392 | 140 | 55 | 95.1 | 1 | 428 | 21 | 195 | 334 | GIW43074.1 MAG: hypothetical protein KatS3mg077_0356 [Candidatus Binatia bacterium] | diamond | 1680 | 179 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 17249794 | 17249794 | PRJNA690592_S_NODE_67754_length_385_cov_2.131410_g66740_i0 | PRJNA690592 | 67754 | 385 | 2.13141 | 8.2059285 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 205 | 1.24e-60 | NR | HKD65657.1 | 2785449 | g66740 | i0 | 69.8 | 4.9012987012987 | 126 | 38 | 98.2 | 0 | 383 | 6 | 228 | 353 | HKD65657.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Candidatus Binataceae bacterium] | diamond | 1887 | 205 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 27683073 | 27683073 | PRJNA690592_S_NODE_214324_length_241_cov_1.375000_g213310_i0 | PRJNA690592 | 214324 | 241 | 1.375 | 3.31375 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 44.3 | 0.00983 | NR | MFB3061144.1 | 2838779 | g213310 | i0 | 45.7 | 0.896265560165975 | 35 | 19 | 43.6 | 0 | 226 | 122 | 266 | 300 | MFB3061144.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Binatia bacterium] | diamond | 216 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28219187 | 28219187 | PRJNA690592_S_NODE_129546_length_295_cov_1.180180_g128532_i0 | PRJNA690592 | 129546 | 295 | 1.18018 | 3.481531 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 43.9 | 0.0267 | NR | MFN2425242.1 | 2838779 | g128532 | i0 | 30.9 | 0.691525423728814 | 68 | 47 | 69.2 | 0 | 63 | 266 | 498 | 565 | MFN2425242.1 trehalose-phosphatase [Candidatus Binatia bacterium] | diamond | 204 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28693215 | 28693215 | PRJNA690592_S_NODE_117487_length_307_cov_1.311966_g116473_i0 | PRJNA690592 | 117487 | 307 | 1.311966 | 4.02773562 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 48.9 | 5.58e-4 | NR | HEY2773178.1 | 2838779 | g116473 | i0 | 56.5 | 1.08469055374593 | 69 | 27 | 66.4 | 2 | 274 | 71 | 831 | 897 | HEY2773178.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 333 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30630836 | 30630836 | PRJNA690592_S_NODE_215893_length_241_cov_0.916667_g214879_i0 | PRJNA690592 | 215893 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 89.4 | 8.55e-20 | NR | HKA27739.1 | 2838779 | g214879 | i0 | 52.6 | 4.80497925311203 | 78 | 37 | 97.1 | 0 | 6 | 239 | 86 | 163 | HKA27739.1 enoyl-CoA hydratase-related protein [Candidatus Binatia bacterium] | diamond | 1158 | 90.1 | 0.992230854605993 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31156346 | 31156346 | PRJNA690592_S_NODE_136895_length_288_cov_1.409302_g135881_i0 | PRJNA690592 | 136895 | 288 | 1.409302 | 4.05878976 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 48.9 | 3.71e-4 | NR | HXU10525.1 | 2838779 | g135881 | i0 | 38.9 | 2.17708333333333 | 72 | 38 | 69.8 | 4 | 7 | 207 | 8 | 78 | HXU10525.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 627 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32169191 | 32169191 | PRJNA690592_S_NODE_4018_length_1303_cov_2.854472_g3586_i0 | PRJNA690592 | 4018 | 1303 | 2.854472 | 37.19377016 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 50.1 | 0.0258 | NR | MFN8544034.1 | 2838779 | g3586 | i0 | 64.5 | 0.0713737528779739 | 31 | 11 | 7.1 | 0 | 1148 | 1056 | 523 | 553 | MFN8544034.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 93 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32422072 | 32422072 | PRJNA690592_S_NODE_188699_length_250_cov_1.305085_g187685_i0 | PRJNA690592 | 188699 | 250 | 1.305085 | 3.2627125 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 101 | 1.6000000000000002e-23 | NR | HEY2387469.1 | 2838779 | g187685 | i0 | 66.3 | 0.996 | 83 | 28 | 99.6 | 0 | 250 | 2 | 104 | 186 | HEY2387469.1 quinone oxidoreductase [Candidatus Binatia bacterium] | diamond | 249 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32832137 | 32832137 | PRJNA690592_S_NODE_61620_length_401_cov_2.856707_g60606_i0 | PRJNA690592 | 61620 | 401 | 2.856707 | 11.45539507 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 130 | 5.72e-32 | NR | MDP6559983.1 | 2838779 | g60606 | i0 | 50.8 | 3.89027431421446 | 130 | 64 | 97.3 | 0 | 2 | 391 | 715 | 844 | MDP6559983.1 M1 family metallopeptidase [Candidatus Binatia bacterium] | diamond | 1560 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia 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);;