contig_metadata
13 rows where bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27269985 | 27269985 | PRJNA615351_P_NODE_166103_length_169_cov_2.388060_g152003_i0 | PRJNA615351 | 166103 | 169 | 2.38806 | 4.0358214 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 48.9 | 9.11e-5 | NR | MFH1508187.1 | 2035772 | g152003 | i0 | 42.3 | 0.923076923076923 | 52 | 30 | 92.3 | 0 | 156 | 1 | 196 | 247 | MFH1508187.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 156 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27617714 | 27617714 | PRJNA615351_P_NODE_66264_length_534_cov_3.645291_g52566_i0 | PRJNA615351 | 66264 | 534 | 3.645291 | 19.46585394 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 46.6 | 0.0239 | NR | MCX5694726.1 | 2035772 | g52566 | i0 | 30.8 | 1.49438202247191 | 133 | 76 | 72.5 | 4 | 489 | 103 | 143 | 263 | MCX5694726.1 ATP-binding protein [Candidatus Omnitrophota bacterium] | diamond | 798 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 27838282 | 27838282 | PRJNA615351_P_NODE_115084_length_264_cov_1.860262_g100985_i0 | PRJNA615351 | 115084 | 264 | 1.860262 | 4.91109168 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 90.9 | 1.6400000000000002e-21 | NR | MBF0385486.1 | 2035772 | g100985 | i0 | 54.1 | 1.80681818181818 | 74 | 34 | 84.1 | 0 | 38 | 259 | 4 | 77 | MBF0385486.1 divalent-cation tolerance protein CutA [Candidatus Omnitrophota bacterium] | diamond | 477 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28059592 | 28059592 | PRJNA615351_P_NODE_93225_length_349_cov_1.936306_g79139_i0 | PRJNA615351 | 93225 | 349 | 1.936306 | 6.75770794 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 47 | 0.00336 | NR | MBI3320694.1 | 2035772 | g79139 | i0 | 36.1 | 0.713467048710602 | 83 | 36 | 71.3 | 2 | 281 | 33 | 161 | 226 | MBI3320694.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 249 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28185632 | 28185632 | PRJNA615351_P_NODE_32786_length_1060_cov_3.308293_g24073_i0 | PRJNA615351 | 32786 | 1060 | 3.308293 | 35.0679058 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 62.8 | 1.15e-6 | NR | MBI3307397.1 | 2035772 | g24073 | i0 | 37.4 | 0.679245283018868 | 115 | 62 | 32.5 | 2 | 21 | 365 | 519 | 623 | MBI3307397.1 IGHMBP2 family helicase [Candidatus Omnitrophota bacterium] | diamond | 720 | 62.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 28533305 | 28533305 | PRJNA615351_P_NODE_161767_length_174_cov_2.280576_g147667_i0 | PRJNA615351 | 161767 | 174 | 2.280576 | 3.96820224 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.4 | 0.012 | NR | MBU4457231.1 | 2035772 | g147667 | i0 | 42.6 | 0.931034482758621 | 54 | 31 | 93.1 | 0 | 167 | 6 | 78 | 131 | MBU4457231.1 4Fe-4S dicluster domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 162 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30080343 | 30080343 | PRJNA615351_P_NODE_7852_length_2257_cov_5.326733_g5593_i0 | PRJNA615351 | 7852 | 2257 | 5.326733 | 120.22436381 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 54.7 | 0.00107 | NR | MFA5039993.1 | 2035772 | g5593 | i0 | 41.1 | 0.191404519273372 | 73 | 35 | 9.7 | 3 | 1218 | 1436 | 156 | 220 | MFA5039993.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 432 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30093114 | 30093114 | PRJNA615351_P_NODE_113692_length_268_cov_2.120172_g99593_i0 | PRJNA615351 | 113692 | 268 | 2.120172 | 5.68206096 | Bacteria | 2 | Bacteria | Bacteria | 47.8 | 6.88e-4 | NR | OGW74628.1 | 1801818 | g99593 | i0 | 46.8 | 1.61194029850746 | 47 | 22 | 49.3 | 1 | 134 | 3 | 175 | 221 | OGW74628.1 MAG: hypothetical protein A2Z72_06185 [Omnitrophica bacterium RBG_13_46_9] | diamond | 432 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium RBG_13_46_9 | |||||
| 30302141 | 30302141 | PRJNA615351_P_NODE_67472_length_523_cov_3.274590_g53697_i0 | PRJNA615351 | 67472 | 523 | 3.27459 | 17.1261057 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 181 | 6.69e-53 | NR | MCD4779571.1 | 2035772 | g53697 | i0 | 58.5 | 6.95219885277247 | 171 | 61 | 94.1 | 5 | 493 | 2 | 3 | 170 | MCD4779571.1 thioredoxin-disulfide reductase [Candidatus Omnitrophota bacterium] | diamond | 3636 | 181 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30743873 | 30743873 | PRJNA615351_P_NODE_124594_length_238_cov_2.625616_g110494_i0 | PRJNA615351 | 124594 | 238 | 2.625616 | 6.24896608 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.4 | 0.0468 | NR | MDD5097078.1 | 2035772 | g110494 | i0 | 39.1 | 0.80672268907563 | 64 | 36 | 78.2 | 2 | 220 | 35 | 302 | 364 | MDD5097078.1 cysteine--tRNA ligase [Candidatus Omnitrophota bacterium] | diamond | 192 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31818873 | 31818873 | PRJNA615351_P_NODE_98537_length_324_cov_2.269896_g84440_i0 | PRJNA615351 | 98537 | 324 | 2.269896 | 7.35446304 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 79.3 | 1.41e-14 | NR | HXV19224.1 | 2035772 | g84440 | i0 | 44.3 | 3.55555555555556 | 97 | 53 | 89.8 | 1 | 291 | 1 | 37 | 132 | HXV19224.1 Tex family protein [Candidatus Omnitrophota bacterium] | diamond | 1152 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32103579 | 32103579 | PRJNA615351_P_NODE_49258_length_738_cov_2.840683_g37280_i0 | PRJNA615351 | 49258 | 738 | 2.840683 | 20.96424054 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 94.7 | 1.73e-18 | NR | MEW5894417.1 | 2035772 | g37280 | i0 | 28.6 | 0.894308943089431 | 220 | 141 | 84.6 | 5 | 7 | 630 | 131 | 346 | MEW5894417.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 660 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32357082 | 32357082 | PRJNA615351_P_NODE_86199_length_387_cov_1.860795_g72130_i0 | PRJNA615351 | 86199 | 387 | 1.860795 | 7.20127665 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 116 | 6.86e-28 | NR | MCA9432615.1 | 2035772 | g72130 | i0 | 57.7 | 2.4031007751938 | 104 | 38 | 79.1 | 4 | 79 | 384 | 193 | 292 | MCA9432615.1 alpha-galactosidase [Candidatus Omnitrophota bacterium] | diamond | 930 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;