contig_metadata
4 rows where bioproject = "PRJNA1059246", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20138029 | 20138029 | PRJNA1059246_P_NODE_9856_length_768_cov_8.048921_g9318_i0 | PRJNA1059246 | 9856 | 768 | 8.048921 | 61.81571328 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 100 | 1.2800000000000001e-22 | NR | HSQ35968.1 | 2838779 | g9318 | i0 | 44 | 1.09375 | 134 | 73 | 52 | 2 | 421 | 23 | 15 | 147 | HSQ35968.1 Hsp20/alpha crystallin family protein [Candidatus Binatia bacterium] | diamond | 840 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29435125 | 29435125 | PRJNA1059246_P_NODE_63430_length_249_cov_1.750000_g62804_i0 | PRJNA1059246 | 63430 | 249 | 1.75 | 4.3575 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 67.4 | 8.13e-11 | NR | MFB3060024.1 | 2838779 | g62804 | i0 | 54.4 | 1.63855421686747 | 68 | 30 | 81.9 | 1 | 209 | 6 | 510 | 576 | MFB3060024.1 M1 family metallopeptidase [Candidatus Binatia bacterium] | diamond | 408 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29530179 | 29530179 | PRJNA1059246_P_NODE_45870_length_308_cov_1.310638_g45244_i0 | PRJNA1059246 | 45870 | 308 | 1.310638 | 4.03676504 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 99.8 | 2.06e-23 | NR | HEY8518108.1 | 2838779 | g45244 | i0 | 58.8 | 1.55844155844156 | 80 | 32 | 77.9 | 1 | 4 | 243 | 144 | 222 | HEY8518108.1 dienelactone hydrolase family protein [Candidatus Binatia bacterium] | diamond | 480 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 30698865 | 30698865 | PRJNA1059246_P_NODE_71274_length_242_cov_0.911243_g70648_i0 | PRJNA1059246 | 71274 | 242 | 0.911243 | 2.20520806 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 77.4 | 2.1e-14 | NR | HEX9143080.1 | 2838779 | g70648 | i0 | 54.5 | 3.27272727272727 | 66 | 25 | 81.8 | 1 | 2 | 199 | 47 | 107 | HEX9143080.1 glutathione-disulfide reductase [Candidatus Binatia bacterium] | diamond | 792 | 77.4 | 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);;