contig_metadata
10 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6061636 | 6061636 | PRJNA980839_P_NODE_196405_length_251_cov_1.825843_g192621_i0 | PRJNA980839 | 196405 | 251 | 1.825843 | 4.58286593 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 163 | 1.23e-46 | NR | HTD85916.1 | 2838779 | g192621 | i0 | 92.8 | 4.9601593625498 | 83 | 6 | 99.2 | 0 | 249 | 1 | 168 | 250 | HTD85916.1 acetolactate synthase large subunit [Candidatus Binatia bacterium] | diamond | 1245 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 26994395 | 26994395 | PRJNA980839_P_NODE_95522_length_373_cov_1.860000_g91738_i0 | PRJNA980839 | 95522 | 373 | 1.86 | 6.9378 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 184 | 3.979999999999999e-55 | NR | HUN59740.1 | 2785449 | g91738 | i0 | 71.8 | 0.997319034852547 | 124 | 35 | 99.7 | 0 | 372 | 1 | 17 | 140 | HUN59740.1 TniB family NTP-binding protein [Candidatus Binataceae bacterium] | diamond | 372 | 184 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28257842 | 28257842 | PRJNA980839_P_NODE_144606_length_292_cov_1.575342_g140822_i0 | PRJNA980839 | 144606 | 292 | 1.575342 | 4.59999864 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 119 | 5.7e-29 | NR | HSR57216.1 | 2785449 | g140822 | i0 | 64.3 | 1.00684931506849 | 98 | 34 | 99.7 | 1 | 292 | 2 | 52 | 149 | HSR57216.1 IS66 family transposase [Candidatus Binataceae bacterium] | diamond | 294 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 30089395 | 30089395 | PRJNA980839_P_NODE_222352_length_245_cov_0.895349_g218568_i0 | PRJNA980839 | 222352 | 245 | 0.895349 | 2.19360505 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 145 | 2.6499999999999994e-42 | NR | MBY0277085.1 | 2838779 | g218568 | i0 | 95.1 | 1.98367346938776 | 81 | 4 | 99.2 | 0 | 243 | 1 | 73 | 153 | MBY0277085.1 50S ribosomal protein L10 [Candidatus Binatia bacterium] | diamond | 486 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30152366 | 30152366 | PRJNA980839_P_NODE_153452_length_284_cov_1.436019_g149668_i0 | PRJNA980839 | 153452 | 284 | 1.436019 | 4.07829396 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 112 | 3.3499999999999996e-30 | NR | HZR84847.1 | 2838779 | g149668 | i0 | 66.7 | 0.823943661971831 | 78 | 26 | 82.4 | 0 | 284 | 51 | 10 | 87 | HZR84847.1 AtpZ/AtpI family protein [Candidatus Binatia bacterium] | diamond | 234 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30500264 | 30500264 | PRJNA980839_P_NODE_81213_length_417_cov_1.430233_g77429_i0 | PRJNA980839 | 81213 | 417 | 1.430233 | 5.96407161 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 179 | 1.17e-51 | NR | HVN84295.1 | 2838779 | g77429 | i0 | 64.7 | 1 | 139 | 48 | 100 | 1 | 417 | 1 | 176 | 313 | HVN84295.1 OprD family outer membrane porin [Candidatus Binatia bacterium] | diamond | 417 | 179 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31075061 | 31075061 | PRJNA980839_P_NODE_90615_length_386_cov_1.865815_g86831_i0 | PRJNA980839 | 90615 | 386 | 1.865815 | 7.2020459 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 129 | 1.04e-33 | NR | HZR81674.1 | 2838779 | g86831 | i0 | 68.6 | 1.58549222797927 | 102 | 32 | 79.3 | 0 | 384 | 79 | 216 | 317 | HZR81674.1 ornithine cyclodeaminase family protein [Candidatus Binatia bacterium] | diamond | 612 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31859355 | 31859355 | PRJNA980839_P_NODE_167637_length_272_cov_1.547739_g163853_i0 | PRJNA980839 | 167637 | 272 | 1.547739 | 4.20985008 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 143 | 5.88e-40 | NR | HJY82199.1 | 2838779 | g163853 | i0 | 73.3 | 4.96323529411765 | 90 | 24 | 99.3 | 0 | 3 | 272 | 153 | 242 | HJY82199.1 alpha/beta hydrolase [Candidatus Binatia bacterium] | diamond | 1350 | 143 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31985918 | 31985918 | PRJNA980839_P_NODE_150038_length_287_cov_1.434579_g146254_i0 | PRJNA980839 | 150038 | 287 | 1.434579 | 4.11724173 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 59.3 | 8.04e-8 | NR | HVA39887.1 | 2785449 | g146254 | i0 | 41.7 | 0.878048780487805 | 84 | 49 | 87.8 | 0 | 279 | 28 | 96 | 179 | HVA39887.1 hypothetical protein [Candidatus Binataceae bacterium] | diamond | 252 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 32049316 | 32049316 | PRJNA980839_P_NODE_208078_length_248_cov_1.760000_g204294_i0 | PRJNA980839 | 208078 | 248 | 1.76 | 4.3648 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 65.1 | 5.18e-10 | NR | MBY0279930.1 | 2838779 | g204294 | i0 | 88.9 | 0.435483870967742 | 36 | 4 | 43.5 | 0 | 2 | 109 | 456 | 491 | MBY0279930.1 cardiolipin synthase [Candidatus Binatia bacterium] | diamond | 108 | 65.1 | 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);;