contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA404067" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5518335 | 5518335 | PRJNA404067_P_NODE_24565_length_224_cov_1.263804_g24178_i0 | PRJNA404067 | 24565 | 224 | 1.263804 | 2.83092096 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 144 | 7.53e-38 | NR | MDB5162878.1 | 2026720 | g24178 | i0 | 90.5 | 6.9375 | 74 | 7 | 99.1 | 0 | 222 | 1 | 744 | 817 | MDB5162878.1 dnaE [Candidatus Saccharibacteria bacterium] | diamond | 1554 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 11893440 | 11893440 | PRJNA404067_P_NODE_29750_length_212_cov_1.033113_g29363_i0 | PRJNA404067 | 29750 | 212 | 1.033113 | 2.19019956 | Candidatus Saccharimonadaceae | 2171986 | Bacteria | Bacteria | 129 | 3.3000000000000003e-34 | NR | TWP26382.1 | 713049 | g29363 | i0 | 100 | 5.94339622641509 | 70 | 0 | 99.1 | 0 | 2 | 211 | 224 | 293 | TWP26382.1 F0F1 ATP synthase subunit alpha, partial [TM7 phylum sp. oral taxon 346] | diamond | 1260 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 346 | ||||||
| 23366458 | 23366458 | PRJNA404067_P_NODE_10899_length_326_cov_2.045283_g10514_i0 | PRJNA404067 | 10899 | 326 | 2.045283 | 6.66762258 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 143 | 1.1099999999999998e-37 | NR | MBX6334820.1 | 2026720 | g10514 | i0 | 68.2 | 0.984662576687117 | 107 | 34 | 98.5 | 0 | 1 | 321 | 438 | 544 | MBX6334820.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 321 | 143 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 26885801 | 26885801 | PRJNA404067_P_NODE_32061_length_208_cov_0.870748_g31674_i0 | PRJNA404067 | 32061 | 208 | 0.870748 | 1.81115584 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 99.8 | 1.56e-24 | NR | MBP9827410.1 | 2026720 | g31674 | i0 | 71.4 | 2.01923076923077 | 70 | 19 | 99.5 | 1 | 207 | 1 | 29 | 98 | MBP9827410.1 PDZ domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 420 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27043823 | 27043823 | PRJNA404067_P_NODE_39962_length_197_cov_2.536765_g39575_i0 | PRJNA404067 | 39962 | 197 | 2.536765 | 4.99742705 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 89.7 | 4.43e-20 | NR | HMI09518.1 | 2973664 | g39575 | i0 | 69.2 | 0.989847715736041 | 65 | 20 | 99 | 0 | 1 | 195 | 114 | 178 | HMI09518.1 alpha/beta fold hydrolase [Candidatus Saccharimonadales bacterium] | diamond | 195 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27486250 | 27486250 | PRJNA404067_P_NODE_32143_length_208_cov_0.870748_g31756_i0 | PRJNA404067 | 32143 | 208 | 0.870748 | 1.81115584 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 120 | 9.59e-32 | NR | NCU37987.1 | 2026720 | g31756 | i0 | 82.1 | 0.966346153846154 | 67 | 12 | 96.6 | 0 | 8 | 208 | 165 | 231 | NCU37987.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 201 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27644326 | 27644326 | PRJNA404067_P_NODE_31404_length_209_cov_0.864865_g31017_i0 | PRJNA404067 | 31404 | 209 | 0.864865 | 1.80756785 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 56.6 | 1.62e-8 | NR | WP_260764205.1 | 2665156 | g31017 | i0 | 80 | 0.430622009569378 | 30 | 6 | 43.1 | 0 | 2 | 91 | 55 | 84 | WP_260764205.1 glutaredoxin domain-containing protein [Candidatus Mycosynbacter amalyticus] | diamond | 90 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 29222974 | 29222974 | PRJNA404067_P_NODE_13029_length_290_cov_1.768559_g12642_i0 | PRJNA404067 | 13029 | 290 | 1.768559 | 5.1288211 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 121 | 8.189999999999999e-31 | NR | HEY5268269.1 | 2973664 | g12642 | i0 | 53.6 | 1.00344827586207 | 97 | 44 | 99.3 | 1 | 288 | 1 | 140 | 236 | HEY5268269.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 291 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29222984 | 29222984 | PRJNA404067_P_NODE_38589_length_201_cov_1.014286_g38202_i0 | PRJNA404067 | 38589 | 201 | 1.014286 | 2.03871486 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 48.9 | 1.39e-4 | NR | HSW96360.1 | 2973664 | g38202 | i0 | 35 | 0.895522388059702 | 60 | 39 | 89.6 | 0 | 199 | 20 | 126 | 185 | HSW96360.1 PEP-utilizing enzyme [Candidatus Saccharimonadales bacterium] | diamond | 180 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29285800 | 29285800 | PRJNA404067_P_NODE_25149_length_222_cov_5.347826_g24762_i0 | PRJNA404067 | 25149 | 222 | 5.347826 | 11.87217372 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 75.1 | 1.1e-13 | NR | MCA9333652.1 | 2026720 | g24762 | i0 | 52.6 | 1.02702702702703 | 76 | 33 | 98.6 | 2 | 221 | 3 | 582 | 657 | MCA9333652.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 228 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30549314 | 30549314 | PRJNA404067_P_NODE_24513_length_224_cov_1.539877_g24126_i0 | PRJNA404067 | 24513 | 224 | 1.539877 | 3.44932448 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 44.7 | 0.00597 | NR | MDB5186664.1 | 2026720 | g24126 | i0 | 88.5 | 1.04464285714286 | 26 | 3 | 34.8 | 0 | 223 | 146 | 404 | 429 | MDB5186664.1 Trigger factor [Candidatus Saccharibacteria bacterium] | diamond | 234 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30738863 | 30738863 | PRJNA404067_P_NODE_26874_length_218_cov_1.433121_g26487_i0 | PRJNA404067 | 26874 | 218 | 1.433121 | 3.12420378 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 84.7 | 3.42e-18 | NR | MBC7546490.1 | 2026720 | g26487 | i0 | 59.7 | 1.84403669724771 | 67 | 27 | 92.2 | 0 | 16 | 216 | 1 | 67 | MBC7546490.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 402 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31640692 | 31640692 | PRJNA404067_P_NODE_19536_length_238_cov_2.265537_g19149_i0 | PRJNA404067 | 19536 | 238 | 2.265537 | 5.39197806 | root | 1 | Root_unresolved | Root_unresolved | 91.3 | 2.98e-19 | NR | MBX6334148.1 | 2026720 | g19149 | i0 | 57.5 | 3.97058823529412 | 80 | 33 | 99.6 | 1 | 1 | 237 | 1296 | 1375 | MBX6334148.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium] | diamond | 945 | 91.7 | 0.995637949836423 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32083632 | 32083632 | PRJNA404067_P_NODE_27878_length_216_cov_1.283871_g27491_i0 | PRJNA404067 | 27878 | 216 | 1.283871 | 2.77316136 | Bacteria | 2 | Bacteria | Bacteria | 80.5 | 1.31e-15 | NR | MBP7834939.1 | 2026720 | g27491 | i0 | 86.3 | 1.51388888888889 | 51 | 7 | 70.8 | 0 | 64 | 216 | 410 | 460 | MBP7834939.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 327 | 80.9 | 0.995055624227441 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32510200 | 32510200 | PRJNA404067_P_NODE_40779_length_193_cov_5.575758_g40392_i0 | PRJNA404067 | 40779 | 193 | 5.575758 | 10.76121294 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 52.4 | 6.77e-6 | NR | HSW85844.1 | 2973664 | g40392 | i0 | 45.5 | 0.854922279792746 | 55 | 30 | 85.5 | 0 | 167 | 3 | 59 | 113 | HSW85844.1 COX aromatic rich motif-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 165 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 32762086 | 32762086 | PRJNA404067_P_NODE_23400_length_227_cov_1.277108_g23013_i0 | PRJNA404067 | 23400 | 227 | 1.277108 | 2.89903516 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 57 | 1.54e-8 | NR | MEP7205163.1 | 2026720 | g23013 | i0 | 54.5 | 1.17621145374449 | 44 | 20 | 58.1 | 0 | 179 | 48 | 4 | 47 | MEP7205163.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 267 | 57 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32762089 | 32762089 | PRJNA404067_P_NODE_29640_length_212_cov_1.364238_g29253_i0 | PRJNA404067 | 29640 | 212 | 1.364238 | 2.89218456 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 49.3 | 6.21e-5 | NR | HSE28976.1 | 2973664 | g29253 | i0 | 50.7 | 0.976415094339623 | 69 | 32 | 94.8 | 2 | 4 | 204 | 5 | 73 | HSE28976.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 207 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;