contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1067370" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11659499 | 11659499 | PRJNA1067370_P_NODE_4490_length_827_cov_2.503979_g4014_i0 | PRJNA1067370 | 4490 | 827 | 2.503979 | 20.70790633 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 311 | 9.28e-102 | NR | HAJ56580.1 | 2035772 | g4014 | i0 | 59.2 | 1.93712212817412 | 267 | 109 | 96.9 | 0 | 803 | 3 | 2 | 268 | HAJ56580.1 erythromycin biosynthesis sensory transduction protein eryC1 [Candidatus Omnitrophota bacterium] | diamond | 1602 | 311 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27067080 | 27067080 | PRJNA1067370_P_NODE_16262_length_460_cov_1.705426_g15714_i0 | PRJNA1067370 | 16262 | 460 | 1.705426 | 7.8449596 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 62.8 | 3.29e-8 | NR | MDD5422892.1 | 2035772 | g15714 | i0 | 47.6 | 2.21739130434783 | 82 | 32 | 53.5 | 1 | 375 | 130 | 42 | 112 | MDD5422892.1 molecular chaperone DnaJ [Candidatus Omnitrophota bacterium] | diamond | 1020 | 62.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27320099 | 27320099 | PRJNA1067370_P_NODE_105543_length_243_cov_2.717647_g104994_i0 | PRJNA1067370 | 105543 | 243 | 2.717647 | 6.60388221 | Candidatus Saelkia tenebricola | 3041141 | Bacteria | Bacteria | 127 | 6.05e-33 | NR | MDP8233357.1 | 3041141 | g104994 | i0 | 80 | 1.97530864197531 | 80 | 16 | 98.8 | 0 | 242 | 3 | 36 | 115 | MDP8233357.1 phosphopyruvate hydratase [Candidatus Saelkia tenebricola] | diamond | 480 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Saelkia | Candidatus Saelkia tenebricola | ||||
| 29941044 | 29941044 | PRJNA1067370_P_NODE_79351_length_251_cov_1.174157_g78802_i0 | PRJNA1067370 | 79351 | 251 | 1.174157 | 2.94713407 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 60.1 | 2.18e-8 | NR | MEK6714813.1 | 2035772 | g78802 | i0 | 62.9 | 2.52191235059761 | 35 | 13 | 41.8 | 0 | 145 | 249 | 126 | 160 | MEK6714813.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 633 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30248685 | 30248685 | PRJNA1067370_P_NODE_59532_length_280_cov_2.434783_g58983_i0 | PRJNA1067370 | 59532 | 280 | 2.434783 | 6.8173924 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 142 | 1.7099999999999996e-40 | NR | NPU97984.1 | 2035772 | g58983 | i0 | 70.5 | 16.0714285714286 | 88 | 26 | 94.3 | 0 | 16 | 279 | 4 | 91 | NPU97984.1 DJ-1/PfpI family protein [Candidatus Omnitrophota bacterium] | diamond | 4500 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30383623 | 30383623 | PRJNA1067370_P_NODE_74093_length_258_cov_2.464865_g73544_i0 | PRJNA1067370 | 74093 | 258 | 2.464865 | 6.3593517 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.1 | 0.0326 | NR | MBN1869024.1 | 2035772 | g73544 | i0 | 33 | 1.05813953488372 | 91 | 42 | 83.7 | 1 | 37 | 252 | 324 | 414 | MBN1869024.1 tetratricopeptide repeat protein [Candidatus Omnitrophota bacterium] | diamond | 273 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32058597 | 32058597 | PRJNA1067370_P_NODE_100438_length_245_cov_0.895349_g99889_i0 | PRJNA1067370 | 100438 | 245 | 0.895349 | 2.19360505 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 62 | 6.19e-9 | NR | MEW5895050.1 | 2035772 | g99889 | i0 | 44.3 | 2.57142857142857 | 70 | 35 | 80.8 | 1 | 9 | 206 | 469 | 538 | MEW5895050.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 630 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32090347 | 32090347 | PRJNA1067370_P_NODE_31558_length_349_cov_1.086957_g31010_i0 | PRJNA1067370 | 31558 | 349 | 1.086957 | 3.79347993 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 83.2 | 8.17e-16 | NR | MEI6438038.1 | 2035772 | g31010 | i0 | 55.9 | 2.39828080229226 | 68 | 30 | 58.5 | 0 | 339 | 136 | 227 | 294 | MEI6438038.1 mucoidy inhibitor MuiA family protein [Candidatus Omnitrophota bacterium] | diamond | 837 | 83.2 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32406818 | 32406818 | PRJNA1067370_P_NODE_38299_length_324_cov_1.876494_g37751_i0 | PRJNA1067370 | 38299 | 324 | 1.876494 | 6.07984056 | Candidatus Omnitrophica bacterium CG | 2035772 | Bacteria | Bacteria | 112 | 1.39e-26 | NR | PIU41869.1 | 1974741 | g37751 | i0 | 55.3 | 4.85185185185185 | 103 | 37 | 95.4 | 2 | 16 | 324 | 77 | 170 | PIU41869.1 MAG: homospermidine synthase [Candidatus Omnitrophica bacterium CG07_land_8_20_14_0_80_42_15] | diamond | 1572 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Aquitaenariimonas | Candidatus Aquitaenariimonas noxiae |
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);;