contig_metadata
7 rows where bioproject = "PRJNA758398" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14768820 | 14768820 | PRJNA758398_S_NODE_44232_length_166_cov_0.871795_g44091_i0 | PRJNA758398 | 44232 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 99.4 | 1.2500000000000001e-22 | NR | MCC6318583.1 | 2026741 | g44091 | i0 | 87.3 | 1.98795180722892 | 55 | 7 | 99.4 | 0 | 2 | 166 | 134 | 188 | MCC6318583.1 bifunctional phosphoribosylaminoimidazolecarboxamide formyltransferase/IMP cyclohydrolase [Gemmatimonadaceae bacterium] | diamond | 330 | 99.8 | 0.995991983967936 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30179314 | 30179314 | PRJNA758398_S_NODE_36272_length_179_cov_0.915385_g36131_i0 | PRJNA758398 | 36272 | 179 | 0.915385 | 1.63853915 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 51.6 | 1.17e-5 | NR | HEX9936137.1 | 2029185 | g36131 | i0 | 45.3 | 1.72625698324022 | 53 | 25 | 88.8 | 2 | 18 | 176 | 564 | 612 | HEX9936137.1 lamin tail domain-containing protein [Longimicrobium sp.] | diamond | 309 | 51.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 30684867 | 30684867 | PRJNA758398_S_NODE_52673_length_162_cov_0.902655_g52532_i0 | PRJNA758398 | 52673 | 162 | 0.902655 | 1.4623011 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 52.8 | 9e-7 | NR | MBQ35773.1 | 2026741 | g52532 | i0 | 56.4 | 0.722222222222222 | 39 | 15 | 72.2 | 1 | 149 | 33 | 72 | 108 | MBQ35773.1 arsenate reductase [Gemmatimonadaceae bacterium] | diamond | 117 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31285262 | 31285262 | PRJNA758398_S_NODE_35115_length_181_cov_1.515152_g34974_i0 | PRJNA758398 | 35115 | 181 | 1.515152 | 2.74242512 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 56.6 | 2.04e-7 | NR | MBL8962063.1 | 2026742 | g34974 | i0 | 60 | 0.994475138121547 | 60 | 16 | 99.4 | 1 | 1 | 180 | 249 | 300 | MBL8962063.1 S8 family peptidase [Gemmatimonadota bacterium] | diamond | 180 | 56.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31706264 | 31706264 | PRJNA758398_S_NODE_22237_length_218_cov_1.201183_g22096_i0 | PRJNA758398 | 22237 | 218 | 1.201183 | 2.61857894 | Gemmatimonadota | 142182 | Bacteria | Bacteria | 59.7 | 2.48e-8 | NR | HKH91170.1 | 2026741 | g22096 | i0 | 53.1 | 3.56422018348624 | 64 | 30 | 88.1 | 0 | 218 | 27 | 244 | 307 | HKH91170.1 DUF2382 domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 777 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32044559 | 32044559 | PRJNA758398_S_NODE_27538_length_201_cov_1.006579_g27397_i0 | PRJNA758398 | 27538 | 201 | 1.006579 | 2.02322379 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 90.5 | 2.82e-19 | NR | HEX8433437.1 | 2029185 | g27397 | i0 | 74.5 | 3.04477611940298 | 51 | 13 | 76.1 | 0 | 49 | 201 | 330 | 380 | HEX8433437.1 phosphoenolpyruvate carboxykinase (ATP) [Longimicrobium sp.] | diamond | 612 | 90.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 32582552 | 32582552 | PRJNA758398_S_NODE_53819_length_161_cov_0.910714_g53678_i0 | PRJNA758398 | 53819 | 161 | 0.910714 | 1.46624954 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 50.4 | 1.15e-5 | NR | MDX1624763.1 | 2026742 | g53678 | i0 | 48.1 | 0.968944099378882 | 52 | 22 | 96.9 | 2 | 159 | 4 | 33 | 79 | MDX1624763.1 GNAT family N-acetyltransferase [Gemmatimonadota bacterium] | diamond | 156 | 50.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;