contig_metadata
8 rows where bioproject = "PRJNA689790", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1944818 | 1944818 | PRJNA689790_S_NODE_9122_length_196_cov_1.471698_g9007_i0 | PRJNA689790 | 9122 | 196 | 1.471698 | 2.88452808 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 99 | 1.44e-22 | NR | MBV9773168.1 | 2026742 | g9007 | i0 | 79.7 | 3.91836734693878 | 64 | 13 | 98 | 0 | 4 | 195 | 64 | 127 | MBV9773168.1 acetyl-CoA C-acetyltransferase [Gemmatimonadota bacterium] | diamond | 768 | 99 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27050804 | 27050804 | PRJNA689790_S_NODE_482_length_1051_cov_2.671598_g435_i0 | PRJNA689790 | 482 | 1051 | 2.671598 | 28.07849498 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 179 | 2.8399999999999997e-46 | NR | MBL8996915.1 | 2026742 | g435 | i0 | 41.4 | 2.31493815413892 | 268 | 140 | 73.6 | 6 | 226 | 999 | 545 | 805 | MBL8996915.1 Ig-like domain-containing protein [Gemmatimonadota bacterium] | diamond | 2433 | 179 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27125066 | 27125066 | PRJNA689790_S_NODE_5542_length_255_cov_1.903670_g5427_i0 | PRJNA689790 | 5542 | 255 | 1.90367 | 4.8543585 | root | 1 | Root_unresolved | Root_unresolved | 94.4 | 3.1e-20 | NR | HUP18400.1 | 2026742 | g5427 | i0 | 55.7 | 14.0588235294118 | 88 | 29 | 94.1 | 3 | 7 | 246 | 525 | 610 | HUP18400.1 choice-of-anchor B family protein [Gemmatimonadota bacterium] | diamond | 3585 | 94.7 | 0.996832101372756 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27145149 | 27145149 | PRJNA689790_S_NODE_7462_length_216_cov_2.832402_g7347_i0 | PRJNA689790 | 7462 | 216 | 2.832402 | 6.11798832 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 42.4 | 0.0344 | NR | MFI5231936.1 | 2448054 | g7347 | i0 | 43.4 | 0.736111111111111 | 53 | 30 | 73.6 | 0 | 15 | 173 | 238 | 290 | MFI5231936.1 CHASE3 domain-containing protein [Gemmatimonadales bacterium] | diamond | 159 | 42.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29198293 | 29198293 | PRJNA689790_S_NODE_509_length_1015_cov_4.352761_g459_i0 | PRJNA689790 | 509 | 1015 | 4.352761 | 44.18052415 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 160 | 3.94e-43 | NR | HEX2217275.1 | 2448054 | g459 | i0 | 42.8 | 0.614778325123153 | 208 | 113 | 60.9 | 5 | 1009 | 392 | 42 | 245 | HEX2217275.1 leishmanolysin-related zinc metalloendopeptidase [Gemmatimonadales bacterium] | diamond | 624 | 160 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30019328 | 30019328 | PRJNA689790_S_NODE_10871_length_180_cov_1.909091_g10756_i0 | PRJNA689790 | 10871 | 180 | 1.909091 | 3.4363638 | uncultured Gemmatimonadota bacterium | 203437 | Bacteria | Bacteria | 41.6 | 0.0423 | NR | CAA9322050.1 | 203437 | g10756 | i0 | 53.1 | 0.533333333333333 | 32 | 15 | 53.3 | 0 | 153 | 58 | 336 | 367 | CAA9322050.1 MAG: 3-oxoacyl-[acyl-carrier-protein] synthase, KASII, partial [uncultured Gemmatimonadota bacterium] | diamond | 96 | 41.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | uncultured Gemmatimonadota bacterium | |||||
| 30524641 | 30524641 | PRJNA689790_S_NODE_14173_length_160_cov_2.845528_g14058_i0 | PRJNA689790 | 14173 | 160 | 2.845528 | 4.5528448 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 43.5 | 0.00612 | NR | MBI4521706.1 | 2026742 | g14058 | i0 | 41.7 | 0.9 | 48 | 27 | 90 | 1 | 158 | 15 | 133 | 179 | MBI4521706.1 peptidase [Gemmatimonadota bacterium] | diamond | 144 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32358921 | 32358921 | PRJNA689790_S_NODE_16219_length_152_cov_1.695652_g16104_i0 | PRJNA689790 | 16219 | 152 | 1.695652 | 2.57739104 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 77 | 8.71e-15 | NR | HEY0673359.1 | 2910168 | g16104 | i0 | 70 | 6.53289473684211 | 50 | 15 | 98.7 | 0 | 2 | 151 | 1395 | 1444 | HEY0673359.1 glucoamylase family protein [Longimicrobiales bacterium] | diamond | 993 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales 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);;