contig_metadata
13 rows where bioproject = "PRJNA1028258", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28329857 | 28329857 | PRJNA1028258_P_NODE_154526_length_230_cov_0.881988_g153963_i0 | PRJNA1028258 | 154526 | 230 | 0.881988 | 2.0285724 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 90.9 | 1.6e-21 | NR | MDR3570670.1 | 2053589 | g153963 | i0 | 68.9 | 0.795652173913043 | 61 | 19 | 79.6 | 0 | 228 | 46 | 6 | 66 | MDR3570670.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 183 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28487961 | 28487961 | PRJNA1028258_P_NODE_167087_length_227_cov_0.898734_g166524_i0 | PRJNA1028258 | 167087 | 227 | 0.898734 | 2.04012618 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 47.4 | 4.24e-4 | NR | MDR3548969.1 | 2053589 | g166524 | i0 | 44.4 | 0.594713656387665 | 45 | 25 | 59.5 | 0 | 16 | 150 | 88 | 132 | MDR3548969.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 135 | 47.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28582705 | 28582705 | PRJNA1028258_P_NODE_18727_length_590_cov_1.403071_g18172_i0 | PRJNA1028258 | 18727 | 590 | 1.403071 | 8.2781189 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.7 | 0.0228 | NR | MDR3547919.1 | 2053589 | g18172 | i0 | 35.3 | 0.345762711864407 | 68 | 44 | 34.6 | 0 | 569 | 366 | 27 | 94 | MDR3547919.1 EF-hand domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 204 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29371995 | 29371995 | PRJNA1028258_P_NODE_76169_length_295_cov_1.265487_g75606_i0 | PRJNA1028258 | 76169 | 295 | 1.265487 | 3.73318665 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52 | 3.56e-5 | NR | MBP9715533.1 | 2053589 | g75606 | i0 | 44.6 | 1.07796610169492 | 56 | 31 | 56.9 | 0 | 66 | 233 | 260 | 315 | MBP9715533.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 318 | 52 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30066567 | 30066567 | PRJNA1028258_P_NODE_145092_length_232_cov_0.871166_g144529_i0 | PRJNA1028258 | 145092 | 232 | 0.871166 | 2.02110512 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.4 | 0.00369 | NR | MEZ0209192.1 | 2053589 | g144529 | i0 | 42.6 | 0.607758620689655 | 47 | 23 | 55.6 | 2 | 160 | 32 | 428 | 474 | MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 141 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30383032 | 30383032 | PRJNA1028258_P_NODE_169073_length_227_cov_0.898734_g168510_i0 | PRJNA1028258 | 169073 | 227 | 0.898734 | 2.04012618 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 54.3 | 2.15e-6 | NR | MDR3557904.1 | 2053589 | g168510 | i0 | 45.5 | 0.726872246696035 | 55 | 28 | 70 | 1 | 226 | 68 | 28 | 82 | MDR3557904.1 RING-HC finger protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30571991 | 30571991 | PRJNA1028258_P_NODE_62573_length_323_cov_1.118110_g62010_i0 | PRJNA1028258 | 62573 | 323 | 1.11811 | 3.6114953 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.7 | 0.00152 | NR | HET9641418.1 | 2053589 | g62010 | i0 | 50 | 0.334365325077399 | 36 | 18 | 33.4 | 0 | 173 | 280 | 23 | 58 | HET9641418.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 108 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31046445 | 31046445 | PRJNA1028258_P_NODE_87355_length_276_cov_1.193237_g86792_i0 | PRJNA1028258 | 87355 | 276 | 1.193237 | 3.29333412 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52 | 7.41e-6 | NR | MFA5166752.1 | 2053589 | g86792 | i0 | 64.4 | 0.489130434782609 | 45 | 16 | 48.9 | 0 | 136 | 2 | 1 | 45 | MFA5166752.1 dUTP diphosphatase [Candidatus Paceibacterota bacterium] | diamond | 135 | 52 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31109135 | 31109135 | PRJNA1028258_P_NODE_153955_length_230_cov_0.881988_g153392_i0 | PRJNA1028258 | 153955 | 230 | 0.881988 | 2.0285724 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 62 | 5e-9 | NR | MDR3558125.1 | 2053589 | g153392 | i0 | 47.4 | 0.991304347826087 | 76 | 35 | 97.8 | 3 | 230 | 6 | 407 | 478 | MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 228 | 62 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31172245 | 31172245 | PRJNA1028258_P_NODE_55795_length_340_cov_2.036900_g55232_i0 | PRJNA1028258 | 55795 | 340 | 2.0369 | 6.92546 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 103 | 7.56e-26 | NR | MDR3570671.1 | 2053589 | g55232 | i0 | 53.6 | 0.988235294117647 | 112 | 43 | 90.9 | 1 | 323 | 15 | 1 | 112 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 336 | 103 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32374677 | 32374677 | PRJNA1028258_P_NODE_120259_length_244_cov_1.411429_g119696_i0 | PRJNA1028258 | 120259 | 244 | 1.411429 | 3.44388676 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 47.8 | 2.93e-4 | NR | HYE23365.1 | 2053589 | g119696 | i0 | 33.9 | 0.762295081967213 | 62 | 38 | 72.5 | 1 | 218 | 42 | 103 | 164 | HYE23365.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 186 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32595987 | 32595987 | PRJNA1028258_P_NODE_111380_length_251_cov_1.560440_g110817_i0 | PRJNA1028258 | 111380 | 251 | 1.56044 | 3.9167044 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.5 | 1.87e-9 | NR | MDR3547486.1 | 2053589 | g110817 | i0 | 46.8 | 1.86454183266932 | 79 | 39 | 90.8 | 2 | 6 | 233 | 51 | 129 | MDR3547486.1 protein kinase [Candidatus Paceibacterota bacterium] | diamond | 468 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32753376 | 32753376 | PRJNA1028258_P_NODE_67540_length_312_cov_1.168724_g66977_i0 | PRJNA1028258 | 67540 | 312 | 1.168724 | 3.64641888 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.5 | 2e-7 | NR | MDR3547190.1 | 2053589 | g66977 | i0 | 51.9 | 0.5 | 52 | 23 | 48.1 | 1 | 187 | 38 | 139 | 190 | MDR3547190.1 alpha/beta hydrolase [Candidatus Paceibacterota bacterium] | diamond | 156 | 58.5 | 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);;