contig_metadata
8 rows where bioproject = "PRJNA379145", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27738648 | 27738648 | PRJNA379145_P_NODE_19164_length_616_cov_7.013722_g17331_i0 | PRJNA379145 | 19164 | 616 | 7.013722 | 43.20452752 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 231 | 8.95e-74 | NR | MFI5399156.1 | 2838779 | g17331 | i0 | 54.5 | 1.96266233766234 | 200 | 90 | 96.9 | 1 | 613 | 17 | 7 | 206 | MFI5399156.1 DJ-1/PfpI family protein [Candidatus Binatia bacterium] | diamond | 1209 | 231 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 28386809 | 28386809 | PRJNA379145_P_NODE_22206_length_547_cov_26.546693_g20257_i0 | PRJNA379145 | 22206 | 547 | 26.546693 | 145.21041071 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 128 | 1.7099999999999996e-34 | NR | HXN20051.1 | 2811406 | g20257 | i0 | 54.3 | 5.23765996343693 | 116 | 51 | 63.6 | 1 | 417 | 70 | 7 | 120 | HXN20051.1 rhodanese-like domain-containing protein [Candidatus Binatus sp.] | diamond | 2865 | 128 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 29222510 | 29222510 | PRJNA379145_P_NODE_39409_length_308_cov_1.956364_g37258_i0 | PRJNA379145 | 39409 | 308 | 1.956364 | 6.02560112 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 57 | 5.83e-7 | NR | HUS25389.1 | 2838779 | g37258 | i0 | 38.5 | 0.886363636363636 | 91 | 37 | 72.1 | 3 | 307 | 86 | 164 | 252 | HUS25389.1 SDR family oxidoreductase [Candidatus Binatia bacterium] | diamond | 273 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30706763 | 30706763 | PRJNA379145_P_NODE_25374_length_489_cov_2.745614_g23339_i0 | PRJNA379145 | 25374 | 489 | 2.7456140000000002 | 13.42605246 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 59.7 | 6.01e-7 | NR | MFN8546138.1 | 2838779 | g23339 | i0 | 31.7 | 0.852760736196319 | 139 | 91 | 85.3 | 2 | 445 | 29 | 595 | 729 | MFN8546138.1 putative metal-binding motif-containing protein [Candidatus Binatia bacterium] | diamond | 417 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30991377 | 30991377 | PRJNA379145_P_NODE_6574_length_1187_cov_2.126516_g5782_i0 | PRJNA379145 | 6574 | 1187 | 2.126516 | 25.24174492 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 351 | 5.36e-115 | NR | MEO6029074.1 | 2838779 | g5782 | i0 | 46.7 | 6.71524852569503 | 381 | 193 | 95.5 | 4 | 1138 | 5 | 2 | 375 | MEO6029074.1 CoA transferase [Candidatus Binatia bacterium] | diamond | 7971 | 351 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 31211953 | 31211953 | PRJNA379145_P_NODE_4075_length_1457_cov_3.340590_g3560_i0 | PRJNA379145 | 4075 | 1457 | 3.34059 | 48.6723963 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 182 | 1.22e-48 | NR | HZR84411.1 | 2838779 | g3560 | i0 | 30.7 | 2.30816746739876 | 378 | 224 | 75.6 | 11 | 271 | 1371 | 24 | 374 | HZR84411.1 hypothetical protein [Candidatus Binatia bacterium] | diamond | 3363 | 182 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 32382898 | 32382898 | PRJNA379145_P_NODE_719_length_2662_cov_7.767973_g599_i0 | PRJNA379145 | 719 | 2662 | 7.767973 | 206.78344126 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 57 | 2.66e-4 | NR | HSV05985.1 | 2811406 | g599 | i0 | 46.2 | 0.0732531930879038 | 65 | 32 | 7.3 | 2 | 2341 | 2535 | 160 | 221 | HSV05985.1 hypothetical protein [Candidatus Binatus sp.] | diamond | 195 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. | ||
| 32761600 | 32761600 | PRJNA379145_P_NODE_42580_length_282_cov_1.658635_g40428_i0 | PRJNA379145 | 42580 | 282 | 1.658635 | 4.6773507 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 88.2 | 4.9e-18 | NR | HET9063002.1 | 2838779 | g40428 | i0 | 47.3 | 2.96808510638298 | 93 | 46 | 98.9 | 1 | 1 | 279 | 206 | 295 | HET9063002.1 acetyl-CoA acetyltransferase [Candidatus Binatia bacterium] | diamond | 837 | 88.2 | 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);;