contig_metadata
5 rows where bioproject = "PRJNA914897" and tax_phylum = "Candidatus Woeseibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27119102 | 27119102 | PRJNA914897_P_NODE_4902_length_904_cov_4.466907_g4566_i0 | PRJNA914897 | 4902 | 904 | 4.466907 | 40.380839279999996 | Candidatus Woesebacteria bacterium GW2 | 2026804 | Bacteria | Bacteria | 53.9 | 3.8e-4 | NR | KKR13707.1 | 1618551 | g4566 | i0 | 34.8 | 0.587389380530973 | 92 | 58 | 29.9 | 1 | 118 | 387 | 2 | 93 | KKR13707.1 MAG: Chaperone protein DnaJ [Candidatus Woesebacteria bacterium GW2011_GWA1_39_21b] | diamond | 531 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWA1_39_21b | ||||||
| 27814499 | 27814499 | PRJNA914897_P_NODE_23884_length_337_cov_1.102273_g23460_i0 | PRJNA914897 | 23884 | 337 | 1.102273 | 3.71466001 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 53.9 | 9.25e-6 | NR | HRN71286.1 | 2026804 | g23460 | i0 | 39.1 | 0.614243323442137 | 69 | 41 | 61.4 | 1 | 218 | 12 | 50 | 117 | HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 207 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 28256170 | 28256170 | PRJNA914897_P_NODE_6566_length_769_cov_2.998563_g6190_i0 | PRJNA914897 | 6566 | 769 | 2.998563 | 23.05894947 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 65.5 | 1.65e-8 | NR | HRN71286.1 | 2026804 | g6190 | i0 | 33.6 | 0.511053315994798 | 131 | 75 | 49.2 | 2 | 287 | 664 | 1 | 124 | HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 393 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 29708295 | 29708295 | PRJNA914897_P_NODE_1230_length_1560_cov_6.490249_g1099_i0 | PRJNA914897 | 1230 | 1560 | 6.490249 | 101.2478844 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 507 | 9.219999999999998e-177 | NR | HRN71286.1 | 2026804 | g1099 | i0 | 97.3 | 0.498076923076923 | 259 | 7 | 49.8 | 0 | 1243 | 467 | 1 | 259 | HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 777 | 507 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium | ||||||
| 31193186 | 31193186 | PRJNA914897_P_NODE_1195_length_1577_cov_4.919548_g1064_i0 | PRJNA914897 | 1195 | 1577 | 4.919548 | 77.58127196 | Candidatus Woesebacteria bacterium | 2026804 | Bacteria | Bacteria | 364 | 2.69e-120 | NR | HRN71286.1 | 2026804 | g1064 | i0 | 70.5 | 0.496512365250476 | 261 | 72 | 49.1 | 2 | 419 | 1192 | 1 | 259 | HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium] | diamond | 783 | 364 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria 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);;