contig_metadata
5 rows where bioproject = "PRJNA1136505", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27639210 | 27639210 | PRJNA1136505_P_NODE_12704_length_1936_cov_7.066559_g8812_i0 | PRJNA1136505 | 12704 | 1936 | 7.066559 | 136.80858224 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 162 | 5.82e-38 | NR | MEZ0209192.1 | 2053589 | g8812 | i0 | 28.4 | 0.791838842975207 | 511 | 320 | 76.2 | 20 | 1478 | 3 | 102 | 585 | MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1533 | 162 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29375578 | 29375578 | PRJNA1136505_P_NODE_144829_length_245_cov_0.895349_g137969_i0 | PRJNA1136505 | 144829 | 245 | 0.895349 | 2.19360505 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 62 | 7.23e-10 | NR | MFA6609070.1 | 2053589 | g137969 | i0 | 45 | 0.979591836734694 | 80 | 40 | 98 | 1 | 243 | 4 | 32 | 107 | MFA6609070.1 NADAR family protein [Candidatus Paceibacterota bacterium] | diamond | 240 | 62 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31397709 | 31397709 | PRJNA1136505_P_NODE_19436_length_1194_cov_9.157003_g8812_i2 | PRJNA1136505 | 19436 | 1194 | 9.157003 | 109.33461582 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 160 | 3.4e-39 | NR | MEZ0209192.1 | 2053589 | g8812 | i2 | 30.8 | 1.00251256281407 | 399 | 234 | 96 | 18 | 1148 | 3 | 212 | 585 | MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1197 | 160 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31903595 | 31903595 | PRJNA1136505_P_NODE_17637_length_1351_cov_8.816901_g8812_i1 | PRJNA1136505 | 17637 | 1351 | 8.816901 | 119.11633251 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 136 | 1.71e-30 | NR | MEZ0209192.1 | 2053589 | g8812 | i1 | 30.5 | 0.837157660991858 | 377 | 209 | 78.4 | 18 | 1348 | 290 | 294 | 641 | MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1131 | 136 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32125345 | 32125345 | PRJNA1136505_P_NODE_115458_length_268_cov_1.682051_g108598_i0 | PRJNA1136505 | 115458 | 268 | 1.682051 | 4.50789668 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 46.6 | 0.00225 | NR | MEZ0209192.1 | 2053589 | g108598 | i0 | 34.5 | 0.940298507462687 | 84 | 52 | 91.8 | 2 | 4 | 249 | 199 | 281 | MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 252 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;