contig_metadata
14 rows where bioproject = "PRJNA533114", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27077759 | 27077759 | PRJNA533114_P_NODE_91622_length_253_cov_1.711111_g91370_i0 | PRJNA533114 | 91622 | 253 | 1.711111 | 4.32911083 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 50.4 | 7.91e-5 | NR | MDR3547381.1 | 2053589 | g91370 | i0 | 37.7 | 0.723320158102767 | 61 | 38 | 72.3 | 0 | 183 | 1 | 92 | 152 | MDR3547381.1 trypsin-like serine protease [Candidatus Paceibacterota bacterium] | diamond | 183 | 50.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27140519 | 27140519 | PRJNA533114_P_NODE_23662_length_466_cov_1.811705_g23412_i0 | PRJNA533114 | 23662 | 466 | 1.811705 | 8.4425453 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 61.6 | 8.81e-8 | NR | MBP9715533.1 | 2053589 | g23412 | i0 | 34.8 | 0.592274678111588 | 92 | 57 | 58.6 | 3 | 181 | 453 | 291 | 380 | MBP9715533.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 276 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27203867 | 27203867 | PRJNA533114_P_NODE_24142_length_462_cov_1.187661_g23892_i0 | PRJNA533114 | 24142 | 462 | 1.187661 | 5.48699382 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67.8 | 1.33e-10 | NR | MBP9757628.1 | 2053589 | g23892 | i0 | 43.2 | 1.0974025974026 | 88 | 45 | 55.2 | 2 | 203 | 457 | 5 | 90 | MBP9757628.1 gamma-glutamylcyclotransferase [Candidatus Paceibacterota bacterium] | diamond | 507 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29256385 | 29256385 | PRJNA533114_P_NODE_46649_length_343_cov_2.274074_g46397_i0 | PRJNA533114 | 46649 | 343 | 2.274074 | 7.80007382 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 89.4 | 3.83e-18 | NR | MDR3582248.1 | 2053589 | g46397 | i0 | 45.2 | 1.00583090379009 | 115 | 61 | 98.8 | 2 | 2 | 340 | 148 | 262 | MDR3582248.1 clusterin-associated protein 1 [Candidatus Paceibacterota bacterium] | diamond | 345 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29414383 | 29414383 | PRJNA533114_P_NODE_46089_length_345_cov_1.691176_g45837_i0 | PRJNA533114 | 46089 | 345 | 1.691176 | 5.8345572 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 95.5 | 2.74e-22 | NR | MDR3571063.1 | 2053589 | g45837 | i0 | 69.6 | 0.6 | 69 | 21 | 60 | 0 | 344 | 138 | 84 | 152 | MDR3571063.1 prohibitin family protein [Candidatus Paceibacterota bacterium] | diamond | 207 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29666732 | 29666732 | PRJNA533114_P_NODE_40350_length_365_cov_1.760274_g40098_i0 | PRJNA533114 | 40350 | 365 | 1.760274 | 6.4250001 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 129 | 2.87e-32 | NR | MDR3558125.1 | 2053589 | g40098 | i0 | 53.7 | 0.994520547945206 | 121 | 56 | 99.5 | 0 | 1 | 363 | 284 | 404 | MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 363 | 129 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29888286 | 29888286 | PRJNA533114_P_NODE_56251_length_316_cov_2.839506_g55999_i0 | PRJNA533114 | 56251 | 316 | 2.839506 | 8.97283896 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 108 | 4.8e-25 | NR | MDR3570663.1 | 2053589 | g55999 | i0 | 53.9 | 0.968354430379747 | 102 | 45 | 96.8 | 1 | 10 | 315 | 338 | 437 | MDR3570663.1 beta-Ala-His dipeptidase [Candidatus Paceibacterota bacterium] | diamond | 306 | 108 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29951244 | 29951244 | PRJNA533114_P_NODE_100791_length_248_cov_1.594286_g100539_i0 | PRJNA533114 | 100791 | 248 | 1.594286 | 3.95382928 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.1 | 0.0291 | NR | MFA5840653.1 | 2053589 | g100539 | i0 | 62.1 | 0.350806451612903 | 29 | 11 | 35.1 | 0 | 204 | 118 | 670 | 698 | MFA5840653.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 87 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30772871 | 30772871 | PRJNA533114_P_NODE_15954_length_566_cov_1.344828_g15707_i0 | PRJNA533114 | 15954 | 566 | 1.344828 | 7.61172648 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 162 | 2.3e-43 | NR | MBP9771973.1 | 2053589 | g15707 | i0 | 50 | 1.87102473498233 | 176 | 88 | 93.3 | 0 | 29 | 556 | 240 | 415 | MBP9771973.1 SulP family inorganic anion transporter [Candidatus Paceibacterota bacterium] | diamond | 1059 | 162 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30772941 | 30772941 | PRJNA533114_P_NODE_63834_length_299_cov_0.792035_g63582_i0 | PRJNA533114 | 63834 | 299 | 0.792035 | 2.36818465 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 60.1 | 3.5e-8 | NR | MDD5032571.1 | 2053589 | g63582 | i0 | 73.7 | 0.381270903010033 | 38 | 9 | 38.1 | 1 | 3 | 116 | 106 | 142 | MDD5032571.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 114 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31309885 | 31309885 | PRJNA533114_P_NODE_23215_length_471_cov_0.907035_g22965_i0 | PRJNA533114 | 23215 | 471 | 0.907035 | 4.27213485 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 154 | 2.74e-41 | NR | MFA6414676.1 | 2053589 | g22965 | i0 | 55.1 | 2.80891719745223 | 147 | 61 | 93.6 | 3 | 20 | 460 | 1 | 142 | MFA6414676.1 saccharopine dehydrogenase C-terminal domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 1323 | 154 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31531566 | 31531566 | PRJNA533114_P_NODE_40896_length_363_cov_1.582759_g40644_i0 | PRJNA533114 | 40896 | 363 | 1.582759 | 5.74541517 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 194 | 7.209999999999999e-57 | NR | MDR3558125.1 | 2053589 | g40644 | i0 | 70.8 | 0.991735537190083 | 120 | 35 | 99.2 | 0 | 4 | 363 | 163 | 282 | MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 360 | 194 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32512455 | 32512455 | PRJNA533114_P_NODE_123119_length_213_cov_4.342857_g122867_i0 | PRJNA533114 | 123119 | 213 | 4.342857 | 9.25028541 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79 | 4.57e-17 | NR | MDR3549538.1 | 2053589 | g122867 | i0 | 65.5 | 0.774647887323944 | 55 | 19 | 77.5 | 0 | 168 | 4 | 8 | 62 | MDR3549538.1 small nuclear ribonucleoprotein Sm D2 [Candidatus Paceibacterota bacterium] | diamond | 165 | 79 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32858726 | 32858726 | PRJNA533114_P_NODE_31940_length_405_cov_2.030120_g31688_i0 | PRJNA533114 | 31940 | 405 | 2.03012 | 8.221986 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 100 | 1.11e-21 | NR | MDR3558125.1 | 2053589 | g31688 | i0 | 48.8 | 0.896296296296296 | 121 | 53 | 83 | 2 | 1 | 336 | 336 | 456 | MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 363 | 100 | 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);;