contig_metadata
8 rows where bioproject = "PRJNA743294", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26641034 | 26641034 | PRJNA743294_P_NODE_10001_length_500_cov_2.421546_g9545_i0 | PRJNA743294 | 10001 | 500 | 2.421546 | 12.10773 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 83.2 | 3.84e-15 | NR | MEC7856026.1 | 2026760 | g9545 | i0 | 29.5 | 0.996 | 166 | 117 | 99.6 | 0 | 498 | 1 | 268 | 433 | MEC7856026.1 M20/M25/M40 family metallo-hydrolase [Fidelibacterota bacterium] | diamond | 498 | 83.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27305648 | 27305648 | PRJNA743294_P_NODE_58363_length_233_cov_2.668750_g57907_i0 | PRJNA743294 | 58363 | 233 | 2.66875 | 6.2181875 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 81.3 | 4.47e-17 | NR | MFQ6612031.1 | 2026760 | g57907 | i0 | 61.4 | 4.46781115879828 | 57 | 22 | 73.4 | 0 | 228 | 58 | 108 | 164 | MFQ6612031.1 PLP-dependent cysteine synthase family protein [Fidelibacterota bacterium] | diamond | 1041 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28094901 | 28094901 | PRJNA743294_P_NODE_27385_length_316_cov_2.074074_g26929_i0 | PRJNA743294 | 27385 | 316 | 2.074074 | 6.55407384 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 119 | 3.25e-29 | NR | HJL75051.1 | 2026760 | g26929 | i0 | 56.4 | 5.36392405063291 | 94 | 41 | 89.2 | 0 | 1 | 282 | 331 | 424 | HJL75051.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Fidelibacterota bacterium] | diamond | 1695 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 28537179 | 28537179 | PRJNA743294_P_NODE_33907_length_288_cov_2.153488_g33451_i0 | PRJNA743294 | 33907 | 288 | 2.153488 | 6.20204544 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 98.2 | 1.71e-22 | NR | MCJ7802071.1 | 2026760 | g33451 | i0 | 50.5 | 2 | 95 | 46 | 97.9 | 1 | 287 | 6 | 115 | 209 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 576 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30337468 | 30337468 | PRJNA743294_P_NODE_5932_length_633_cov_3.244643_g5482_i0 | PRJNA743294 | 5932 | 633 | 3.244643 | 20.53859019 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 167 | 2.3399999999999997e-47 | NR | MBT5355788.1 | 2026760 | g5482 | i0 | 61.7 | 1.09952606635071 | 115 | 44 | 54.5 | 0 | 136 | 480 | 123 | 237 | MBT5355788.1 NAD-dependent epimerase/dehydratase family protein [Fidelibacterota bacterium] | diamond | 696 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30684387 | 30684387 | PRJNA743294_P_NODE_38573_length_273_cov_1.525000_g38117_i0 | PRJNA743294 | 38573 | 273 | 1.525 | 4.16325 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 72.4 | 1.89e-12 | NR | MBH49360.1 | 2026760 | g38117 | i0 | 41.6 | 0.978021978021978 | 89 | 52 | 97.8 | 0 | 6 | 272 | 206 | 294 | MBH49360.1 phosphoenolpyruvate carboxykinase (ATP) [Fidelibacterota bacterium] | diamond | 267 | 72.4 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31032339 | 31032339 | PRJNA743294_P_NODE_4155_length_744_cov_12.749627_g3750_i0 | PRJNA743294 | 4155 | 744 | 12.749627 | 94.85722488 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 52.8 | 1.9e-4 | NR | MFL3024673.1 | 2026760 | g3750 | i0 | 49.1 | 1.08064516129032 | 57 | 24 | 22.2 | 2 | 557 | 393 | 50 | 103 | MFL3024673.1 SOUL family heme-binding protein [Fidelibacterota bacterium] | diamond | 804 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31601354 | 31601354 | PRJNA743294_P_NODE_11516_length_468_cov_1.751899_g11060_i0 | PRJNA743294 | 11516 | 468 | 1.751899 | 8.19888732 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 66.6 | 1.88e-9 | NR | HIA94025.1 | 2026760 | g11060 | i0 | 33.9 | 3.80128205128205 | 112 | 61 | 69.2 | 3 | 145 | 468 | 308 | 410 | HIA94025.1 LamG domain-containing protein [Fidelibacterota bacterium] | diamond | 1779 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;