contig_metadata
6 rows where bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13062538 | 13062538 | PRJNA1159911_P_NODE_98031_length_243_cov_0.905882_g97489_i0 | PRJNA1159911 | 98031 | 243 | 0.905882 | 2.20129326 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 150 | 3.02e-41 | NR | MBY0277780.1 | 2838779 | g97489 | i0 | 92.6 | 1 | 81 | 6 | 100 | 0 | 1 | 243 | 234 | 314 | MBY0277780.1 sigma-54 dependent transcriptional regulator [Candidatus Binatia bacterium] | diamond | 243 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 19433819 | 19433819 | PRJNA1159911_P_NODE_4416_length_1695_cov_9.353884_g254_i6 | PRJNA1159911 | 4416 | 1695 | 9.353884 | 158.5483338 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 549 | 4.0799999999999997e-190 | NR | HSR58777.1 | 2785449 | g254 | i6 | 86.9 | 1.08318584070796 | 313 | 41 | 55.4 | 0 | 981 | 43 | 94 | 406 | HSR58777.1 IS3 family transposase [Candidatus Binataceae bacterium] | diamond | 1836 | 549 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 20710069 | 20710069 | PRJNA1159911_P_NODE_87657_length_251_cov_0.865169_g87115_i0 | PRJNA1159911 | 87657 | 251 | 0.865169 | 2.17157419 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 134 | 3.5499999999999998e-34 | NR | MFN8603416.1 | 2838779 | g87115 | i0 | 82.9 | 0.9800796812749 | 82 | 14 | 98 | 0 | 4 | 249 | 624 | 705 | MFN8603416.1 ATP-binding protein [Candidatus Binatia bacterium] | diamond | 246 | 134 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 23260659 | 23260659 | PRJNA1159911_P_NODE_779_length_4345_cov_6.945693_g254_i4 | PRJNA1159911 | 779 | 4345 | 6.945693 | 301.79036085 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 549 | 3.3e-179 | NR | HSR58777.1 | 2785449 | g254 | i4 | 86.9 | 0.422554660529344 | 313 | 41 | 21.6 | 0 | 4028 | 3090 | 94 | 406 | HSR58777.1 IS3 family transposase [Candidatus Binataceae bacterium] | diamond | 1836 | 549 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28493244 | 28493244 | PRJNA1159911_P_NODE_92427_length_247_cov_0.885057_g91885_i0 | PRJNA1159911 | 92427 | 247 | 0.885057 | 2.18609079 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 91.7 | 5.58e-21 | NR | MFN8600253.1 | 2838779 | g91885 | i0 | 61.7 | 0.983805668016194 | 81 | 31 | 98.4 | 0 | 247 | 5 | 48 | 128 | MFN8600253.1 PadR family transcriptional regulator [Candidatus Binatia bacterium] | diamond | 243 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29156443 | 29156443 | PRJNA1159911_P_NODE_88849_length_250_cov_0.870056_g88307_i0 | PRJNA1159911 | 88849 | 250 | 0.870056 | 2.17514 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 145 | 2.78e-39 | NR | MBY0275855.1 | 2838779 | g88307 | i0 | 98.6 | 0.852 | 71 | 1 | 85.2 | 0 | 215 | 3 | 1 | 71 | MBY0275855.1 efflux RND transporter periplasmic adaptor subunit [Candidatus Binatia bacterium] | diamond | 213 | 145 | 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);;