contig_metadata
7 rows where bioproject = "PRJNA688736", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3218473 | 3218473 | PRJNA688736_P_NODE_23083_length_328_cov_1.890196_g22798_i0 | PRJNA688736 | 23083 | 328 | 1.890196 | 6.19984288 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 355 | 2.1e-93 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g22798 | i0 | 86.239 | 237.32012195122 | 327 | 45 | 99 | 0 | 2 | 328 | 3559342 | 3559016 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 77841 | 355 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 12146729 | 12146729 | PRJNA688736_P_NODE_14490_length_401_cov_2.009146_g14205_i0 | PRJNA688736 | 14490 | 401 | 2.009146 | 8.05667546 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 603 | 8.459999999999999e-168 | NTclustered | gi|1958093598|gb|CP065003.1| | 1978231 | g14205 | i0 | 94.207 | 317.558603491272 | 397 | 20 | 99 | 2 | 1 | 395 | 318071 | 317676 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome | blastn | 127341 | 603 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 15970724 | 15970724 | PRJNA688736_P_NODE_4293_length_691_cov_1.135922_g4027_i0 | PRJNA688736 | 4293 | 691 | 1.135922 | 7.84922102 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 1164 | 0 | NTclustered | gi|112980873|gb|DQ829677.1| | 171953 | g4027 | i0 | 97.106 | 396 | 691 | 19 | 100 | 1 | 1 | 691 | 1886 | 1197 | Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence | blastn | 273636 | 1164 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 18519551 | 18519551 | PRJNA688736_P_NODE_2015_length_948_cov_1.934857_g1831_i0 | PRJNA688736 | 2015 | 948 | 1.934857 | 18.34244436 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 138 | 3.18e-32 | NR | PYX61602.1 | 1978231 | g1831 | i0 | 57.4 | 0.604430379746835 | 115 | 49 | 36.4 | 0 | 904 | 560 | 873 | 987 | PYX61602.1 MAG: hypothetical protein DMG74_22350, partial [Acidobacteriota bacterium] | diamond | 573 | 139 | 0.992805755395683 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28187443 | 28187443 | PRJNA688736_P_NODE_13886_length_409_cov_0.866071_g13601_i0 | PRJNA688736 | 13886 | 409 | 0.866071 | 3.54223039 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 44.7 | 0.0421 | NR | MEO7793186.1 | 2651171 | g13601 | i0 | 31.7 | 0.601466992665037 | 82 | 49 | 55.7 | 2 | 69 | 296 | 119 | 199 | MEO7793186.1 apolipoprotein N-acyltransferase [Thermoanaerobaculia bacterium] | diamond | 246 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29639799 | 29639799 | PRJNA688736_P_NODE_37190_length_262_cov_1.650794_g36905_i0 | PRJNA688736 | 37190 | 262 | 1.650794 | 4.32508028 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 71.2 | 2.15e-12 | NR | HEX3104862.1 | 2282142 | g36905 | i0 | 50 | 0.778625954198473 | 68 | 34 | 77.9 | 0 | 6 | 209 | 4 | 71 | HEX3104862.1 DUF4238 domain-containing protein [Terriglobales bacterium] | diamond | 204 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31883855 | 31883855 | PRJNA688736_P_NODE_28437_length_299_cov_2.238938_g28152_i0 | PRJNA688736 | 28437 | 299 | 2.238938 | 6.69442462 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.1 | 0.0432 | NR | HUI56417.1 | 2212468 | g28152 | i0 | 38.9 | 0.54180602006689 | 54 | 31 | 54.2 | 1 | 172 | 11 | 33 | 84 | HUI56417.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 162 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;