contig_metadata
13 rows where bioproject = "PRJNA864829" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2512379 | 2512379 | PRJNA864829_S_NODE_1522_length_409_cov_3.288889_g1436_i0 | PRJNA864829 | 1522 | 409 | 3.288889 | 13.45155601 | Bacteria | 2 | Bacteria | Bacteria | 189 | 2.8699999999999998e-43 | NTclustered | gi|2814788387|emb|OY762897.2| | 2838779 | g1436 | i0 | 76.238 | 69.520782396088 | 404 | 69 | 95 | 23 | 21 | 409 | 595944 | 595553 | MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1 | blastn | 28434 | 189 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 3397997 | 3397997 | PRJNA864829_S_NODE_12483_length_181_cov_1.712121_g12397_i0 | PRJNA864829 | 12483 | 181 | 1.712121 | 3.09893901 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 169 | 1.4599999999999998e-37 | NTclustered | gi|2546137839|emb|OY282432.1| | 3036252 | g12397 | i0 | 87.248 | 48.1381215469613 | 149 | 17 | 82 | 2 | 9 | 156 | 2261845 | 2261698 | MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 | blastn | 8713 | 169 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 7614907 | 7614907 | PRJNA864829_S_NODE_4066_length_285_cov_1.364407_g3980_i0 | PRJNA864829 | 4066 | 285 | 1.364407 | 3.88855995 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 68.2 | 2.34e-12 | NR | HEX7409976.1 | 2838779 | g3980 | i0 | 62.5 | 0.673684210526316 | 64 | 21 | 67.4 | 1 | 84 | 275 | 1 | 61 | HEX7409976.1 peptidoglycan-binding domain-containing protein [Candidatus Binatia bacterium] | diamond | 192 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 9775306 | 9775306 | PRJNA864829_S_NODE_3828_length_290_cov_2.929461_g3742_i0 | PRJNA864829 | 3828 | 290 | 2.929461 | 8.4954369 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 241 | 5.340000000000001e-59 | NTclustered | gi|2546137839|emb|OY282432.1| | 3036252 | g3742 | i0 | 82.253 | 105.955172413793 | 293 | 38 | 99 | 11 | 5 | 290 | 2262509 | 2262794 | MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 | blastn | 30727 | 241 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 11051007 | 11051007 | PRJNA864829_S_NODE_1889_length_374_cov_2.756923_g1803_i0 | PRJNA864829 | 1889 | 374 | 2.756923 | 10.31089202 | uncultured Candidatus Binatia bacterium | 3036252 | Bacteria | Bacteria | 195 | 5.59e-45 | NTclustered | gi|2891481979|emb|OZ219754.1| | 3036252 | g1803 | i0 | 76.684 | 63.7941176470588 | 386 | 69 | 100 | 16 | 1 | 374 | 2070086 | 2070462 | MAG: uncultured Candidatus Binatia bacterium isolate 58a26a4a-5c73-4e1d-804e-87f8126ae6b7 genome assembly, chromosome: 1 | blastn | 23859 | 195 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | uncultured Candidatus Binatia bacterium | |||||
| 17425453 | 17425453 | PRJNA864829_S_NODE_1714_length_389_cov_47.250000_g1628_i0 | PRJNA864829 | 1714 | 389 | 47.25 | 183.8025 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 296 | 1.56e-75 | NTclustered | gi|2621703606|emb|OY761465.1| | 2838779 | g1628 | i0 | 85.971 | 486.706940874036 | 278 | 37 | 71 | 2 | 112 | 389 | 3394159 | 3394434 | MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1 | blastn | 189329 | 296 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 22523973 | 22523973 | PRJNA864829_S_NODE_13118_length_177_cov_1.750000_g13032_i0 | PRJNA864829 | 13118 | 177 | 1.75 | 3.0975 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 92.4 | 3.58e-20 | NR | MFI5367200.1 | 2838779 | g13032 | i0 | 79.3 | 0.983050847457627 | 58 | 12 | 98.3 | 0 | 176 | 3 | 24 | 81 | MFI5367200.1 sigma-54-dependent transcriptional regulator [Candidatus Binatia bacterium] | diamond | 174 | 92.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 27529065 | 27529065 | PRJNA864829_S_NODE_9203_length_206_cov_2.828025_g9117_i0 | PRJNA864829 | 9203 | 206 | 2.828025 | 5.8257315 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 42 | 0.0441 | NR | MFQ5666412.1 | 2838779 | g9117 | i0 | 42.6 | 0.990291262135922 | 68 | 39 | 99 | 0 | 1 | 204 | 317 | 384 | MFQ5666412.1 chromosome segregation protein SMC [Candidatus Binatia bacterium] | diamond | 204 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29234151 | 29234151 | PRJNA864829_S_NODE_9029_length_208_cov_2.283019_g8943_i0 | PRJNA864829 | 9029 | 208 | 2.283019 | 4.74867952 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 68.2 | 2.56e-11 | NR | MFQ5665161.1 | 2838779 | g8943 | i0 | 44.9 | 0.995192307692308 | 69 | 34 | 93.8 | 1 | 14 | 208 | 252 | 320 | MFQ5665161.1 FG-GAP-like repeat-containing protein [Candidatus Binatia bacterium] | diamond | 207 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29400048 | 29400048 | PRJNA864829_S_NODE_5849_length_249_cov_1.875000_g5763_i0 | PRJNA864829 | 5849 | 249 | 1.875 | 4.66875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 142 | 3.76e-37 | NR | GIW43802.1 | 2838779 | g5763 | i0 | 78.3 | 4 | 83 | 18 | 100 | 0 | 1 | 249 | 60 | 142 | GIW43802.1 MAG: ribonucleoside-diphosphate reductase subunit alpha [Candidatus Binatia bacterium] | diamond | 996 | 143 | 0.993006993006993 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29802332 | 29802332 | PRJNA864829_S_NODE_5511_length_254_cov_2.478049_g5425_i0 | PRJNA864829 | 5511 | 254 | 2.478049 | 6.29424446 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 144 | 1.31e-39 | NR | MFI5366530.1 | 2838779 | g5425 | i0 | 82.1 | 0.992125984251969 | 84 | 14 | 99.2 | 1 | 2 | 253 | 67 | 149 | MFI5366530.1 Coenzyme F420 hydrogenase/dehydrogenase, beta subunit C-terminal domain [Candidatus Binatia bacterium] | diamond | 252 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30118183 | 30118183 | PRJNA864829_S_NODE_8252_length_216_cov_1.724551_g8166_i0 | PRJNA864829 | 8252 | 216 | 1.724551 | 3.72503016 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 52.8 | 7.81e-6 | NR | HLK10506.1 | 2838779 | g8166 | i0 | 44.6 | 2.75 | 56 | 31 | 77.8 | 0 | 1 | 168 | 304 | 359 | HLK10506.1 sulfatase-like hydrolase/transferase [Candidatus Binatia bacterium] | diamond | 594 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30592161 | 30592161 | PRJNA864829_S_NODE_9673_length_202_cov_1.490196_g9587_i0 | PRJNA864829 | 9673 | 202 | 1.490196 | 3.01019592 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 73.6 | 2.96e-13 | NR | MFI5396453.1 | 2838779 | g9587 | i0 | 56.1 | 0.98019801980198 | 66 | 29 | 98 | 0 | 4 | 201 | 224 | 289 | MFI5396453.1 GumC family protein [Candidatus Binatia bacterium] | diamond | 198 | 73.6 | 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);;