contig_metadata
19 rows where bioproject = "PRJNA879314", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9785720 | 9785720 | PRJNA879314_P_NODE_568_length_554_cov_1.417879_g518_i0 | PRJNA879314 | 568 | 554 | 1.417879 | 7.85504966 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 343 | 1.73e-114 | NR | MDD3190650.1 | 2053589 | g518 | i0 | 95.7 | 2.96750902527076 | 184 | 8 | 99.6 | 0 | 1 | 552 | 104 | 287 | MDD3190650.1 F0F1 ATP synthase subunit beta [Candidatus Paceibacterota bacterium] | diamond | 1644 | 343 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 13611495 | 13611495 | PRJNA879314_P_NODE_3851_length_265_cov_1.218750_g3801_i0 | PRJNA879314 | 3851 | 265 | 1.21875 | 3.2296875 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 175 | 1.19e-48 | NR | MFA7171188.1 | 2053589 | g3801 | i0 | 93.2 | 2.98867924528302 | 88 | 6 | 99.6 | 0 | 264 | 1 | 898 | 985 | MFA7171188.1 DNA-directed RNA polymerase subunit beta' [Candidatus Paceibacterota bacterium] | diamond | 792 | 175 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26802038 | 26802038 | PRJNA879314_P_NODE_581_length_549_cov_0.983193_g531_i0 | PRJNA879314 | 581 | 549 | 0.983193 | 5.39772957 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 85.1 | 1.76e-18 | NR | MDD3006963.1 | 2053589 | g531 | i0 | 72 | 0.819672131147541 | 50 | 14 | 27.3 | 0 | 152 | 301 | 1 | 50 | MDD3006963.1 lysine biosynthesis protein LysW [Candidatus Paceibacterota bacterium] | diamond | 450 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27655763 | 27655763 | PRJNA879314_P_NODE_5844_length_251_cov_0.876404_g5794_i0 | PRJNA879314 | 5844 | 251 | 0.876404 | 2.19977404 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 55.8 | 7.49e-7 | NR | MDD3190947.1 | 2053589 | g5794 | i0 | 33 | 3.14342629482072 | 88 | 54 | 99.2 | 2 | 1 | 249 | 70 | 157 | MDD3190947.1 TIGR00282 family metallophosphoesterase [Candidatus Paceibacterota bacterium] | diamond | 789 | 55.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28192079 | 28192079 | PRJNA879314_P_NODE_9066_length_246_cov_0.861272_g9016_i0 | PRJNA879314 | 9066 | 246 | 0.861272 | 2.11872912 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52.8 | 1.1e-5 | NR | MDD3006631.1 | 2053589 | g9016 | i0 | 62.5 | 0.780487804878049 | 32 | 12 | 39 | 0 | 238 | 143 | 475 | 506 | MDD3006631.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 192 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28886834 | 28886834 | PRJNA879314_P_NODE_6448_length_250_cov_0.881356_g6398_i0 | PRJNA879314 | 6448 | 250 | 0.881356 | 2.20339 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.9 | 7.85e-8 | NR | MDD3190458.1 | 2053589 | g6398 | i0 | 44 | 3.288 | 91 | 38 | 93.6 | 4 | 15 | 248 | 643 | 733 | MDD3190458.1 beta-propeller domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 822 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29013551 | 29013551 | PRJNA879314_P_NODE_1848_length_337_cov_0.833333_g1798_i0 | PRJNA879314 | 1848 | 337 | 0.833333 | 2.80833221 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 176 | 7.21e-50 | NR | MDD3940351.1 | 2053589 | g1798 | i0 | 71.2 | 1.97626112759644 | 111 | 32 | 98.8 | 0 | 5 | 337 | 265 | 375 | MDD3940351.1 pyridoxal-dependent decarboxylase [Candidatus Paceibacterota bacterium] | diamond | 666 | 176 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29108037 | 29108037 | PRJNA879314_P_NODE_1048_length_414_cov_1.284457_g998_i0 | PRJNA879314 | 1048 | 414 | 1.284457 | 5.31765198 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 204 | 1.66e-62 | NR | MDD3190166.1 | 2053589 | g998 | i0 | 67.2 | 4.94927536231884 | 137 | 45 | 99.3 | 0 | 3 | 413 | 3 | 139 | MDD3190166.1 thiamine pyrophosphate-dependent enzyme [Candidatus Paceibacterota bacterium] | diamond | 2049 | 204 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29202810 | 29202810 | PRJNA879314_P_NODE_2489_length_305_cov_1.008621_g2439_i0 | PRJNA879314 | 2489 | 305 | 1.008621 | 3.07629405 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 114 | 1.0600000000000002e-27 | NR | MFA6097875.1 | 2053589 | g2439 | i0 | 59.4 | 2.93114754098361 | 101 | 41 | 99.3 | 0 | 3 | 305 | 66 | 166 | MFA6097875.1 DNA recombination protein RmuC [Candidatus Paceibacterota bacterium] | diamond | 894 | 114 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29431460 | 29431460 | PRJNA879314_P_NODE_7309_length_248_cov_0.891429_g7259_i0 | PRJNA879314 | 7309 | 248 | 0.891429 | 2.21074392 | Bacillati | 1783272 | Bacteria | Bacteria | 63.5 | 1.91e-9 | NR | HEU0085857.1 | 2053589 | g7259 | i0 | 47.1 | 3.60483870967742 | 85 | 33 | 93.1 | 2 | 18 | 248 | 642 | 722 | HEU0085857.1 immunoglobulin-like domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 894 | 63.9 | 0.993740219092332 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29929112 | 29929112 | PRJNA879314_P_NODE_3371_length_277_cov_1.147059_g3321_i0 | PRJNA879314 | 3371 | 277 | 1.147059 | 3.17735343 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 129 | 2.7499999999999996e-32 | NR | MDD3006733.1 | 2053589 | g3321 | i0 | 68.1 | 3.92057761732852 | 91 | 29 | 98.6 | 0 | 275 | 3 | 609 | 699 | MDD3006733.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1086 | 129 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30781976 | 30781976 | PRJNA879314_P_NODE_3334_length_278_cov_0.897561_g3284_i0 | PRJNA879314 | 3334 | 278 | 0.897561 | 2.49521958 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 56.6 | 1.97e-7 | NR | MFA7170109.1 | 2053589 | g3284 | i0 | 37.8 | 0.798561151079137 | 74 | 46 | 79.9 | 0 | 1 | 222 | 88 | 161 | MFA7170109.1 regulatory protein RecX [Candidatus Paceibacterota bacterium] | diamond | 222 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30876770 | 30876770 | PRJNA879314_P_NODE_2074_length_324_cov_1.203187_g2024_i0 | PRJNA879314 | 2074 | 324 | 1.203187 | 3.89832588 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 147 | 1.23e-38 | NR | MDD3292739.1 | 2053589 | g2024 | i0 | 65.1 | 3.92592592592593 | 106 | 37 | 98.1 | 0 | 319 | 2 | 245 | 350 | MDD3292739.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 1272 | 147 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31066608 | 31066608 | PRJNA879314_P_NODE_2895_length_290_cov_1.078341_g2845_i0 | PRJNA879314 | 2895 | 290 | 1.078341 | 3.1271889 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 136 | 4.67e-38 | NR | MDD3190360.1 | 2053589 | g2845 | i0 | 70.8 | 0.993103448275862 | 96 | 28 | 99.3 | 0 | 1 | 288 | 80 | 175 | MDD3190360.1 50S ribosomal protein L3 [Candidatus Paceibacterota bacterium] | diamond | 288 | 136 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31350985 | 31350985 | PRJNA879314_P_NODE_7776_length_248_cov_0.880000_g7726_i0 | PRJNA879314 | 7776 | 248 | 0.88 | 2.1824 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 127 | 6.189999999999999e-32 | NR | MFA7169741.1 | 2053589 | g7726 | i0 | 80.5 | 0.991935483870968 | 82 | 16 | 99.2 | 0 | 3 | 248 | 359 | 440 | MFA7169741.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Paceibacterota bacterium] | diamond | 246 | 127 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31983427 | 31983427 | PRJNA879314_P_NODE_2438_length_307_cov_1.333333_g2388_i0 | PRJNA879314 | 2438 | 307 | 1.333333 | 4.09333231 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 83.6 | 2.72e-16 | NR | MDD3190193.1 | 2053589 | g2388 | i0 | 39.6 | 1.03583061889251 | 106 | 59 | 99.7 | 4 | 306 | 1 | 224 | 328 | MDD3190193.1 pilin [Candidatus Paceibacterota bacterium] | diamond | 318 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32521719 | 32521719 | PRJNA879314_P_NODE_8439_length_247_cov_0.873563_g8389_i0 | PRJNA879314 | 8439 | 247 | 0.873563 | 2.15770061 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.7 | 9.53e-22 | NR | MDD3006331.1 | 2053589 | g8389 | i0 | 61 | 0.995951417004049 | 82 | 29 | 99.6 | 2 | 1 | 246 | 33 | 111 | MDD3006331.1 NUDIX domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 246 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32616105 | 32616105 | PRJNA879314_P_NODE_6660_length_249_cov_1.329545_g6610_i0 | PRJNA879314 | 6660 | 249 | 1.329545 | 3.31056705 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.7 | 4.1e-22 | NR | MDD3190195.1 | 2053589 | g6610 | i0 | 58.6 | 2.51807228915663 | 70 | 29 | 84.3 | 0 | 210 | 1 | 18 | 87 | MDD3190195.1 class I SAM-dependent methyltransferase [Candidatus Paceibacterota bacterium] | diamond | 627 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32812909 | 32812909 | PRJNA879314_P_NODE_8280_length_247_cov_0.896552_g8230_i0 | PRJNA879314 | 8280 | 247 | 0.896552 | 2.21448344 | Bacteria | 2 | Bacteria | Bacteria | 103 | 1.3799999999999998e-23 | NR | MFA7171404.1 | 2053589 | g8230 | i0 | 60.5 | 5.96356275303644 | 81 | 31 | 98.4 | 1 | 2 | 244 | 396 | 475 | MFA7171404.1 glucose-1-phosphate thymidylyltransferase [Candidatus Paceibacterota bacterium] | diamond | 1473 | 103 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;