contig_metadata
20 rows where bioproject = "PRJNA217180" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26852722 | 26852722 | PRJNA217180_P_NODE_11761_length_172_cov_1.292683_g11661_i0 | PRJNA217180 | 11761 | 172 | 1.292683 | 2.22341476 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 72.4 | 2.59e-14 | NR | MDD5068076.1 | 2053589 | g11661 | i0 | 64.3 | 0.976744186046512 | 56 | 20 | 97.7 | 0 | 171 | 4 | 41 | 96 | MDD5068076.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 168 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27073950 | 27073950 | PRJNA217180_P_NODE_9662_length_189_cov_1.285714_g9562_i0 | PRJNA217180 | 9662 | 189 | 1.285714 | 2.42999946 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 103 | 9.84e-25 | NR | MCF7865573.1 | 2053589 | g9562 | i0 | 77.4 | 0.984126984126984 | 62 | 14 | 98.4 | 0 | 2 | 187 | 155 | 216 | MCF7865573.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 186 | 103 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27295244 | 27295244 | PRJNA217180_P_NODE_12603_length_167_cov_0.864407_g12503_i0 | PRJNA217180 | 12603 | 167 | 0.864407 | 1.44355969 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 84.3 | 2.89e-17 | NR | MBP6869126.1 | 2053589 | g12503 | i0 | 83 | 3.68263473053892 | 53 | 5 | 95.2 | 1 | 3 | 161 | 324 | 372 | MBP6869126.1 translational GTPase TypA [Candidatus Paceibacterota bacterium] | diamond | 615 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27453385 | 27453385 | PRJNA217180_P_NODE_12503_length_167_cov_0.864407_g12403_i0 | PRJNA217180 | 12503 | 167 | 0.864407 | 1.44355969 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 86.7 | 4.98e-19 | NR | MEO5646333.1 | 2053589 | g12403 | i0 | 80 | 1.97604790419162 | 55 | 11 | 98.8 | 0 | 165 | 1 | 28 | 82 | MEO5646333.1 helix-turn-helix domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 330 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27642844 | 27642844 | PRJNA217180_P_NODE_15384_length_161_cov_0.910714_g15284_i0 | PRJNA217180 | 15384 | 161 | 0.910714 | 1.46624954 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 48.1 | 9.5e-5 | NR | HEY6020918.1 | 2053589 | g15284 | i0 | 49 | 0.91304347826087 | 49 | 25 | 91.3 | 0 | 161 | 15 | 6 | 54 | HEY6020918.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 147 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28558442 | 28558442 | PRJNA217180_P_NODE_14607_length_163_cov_0.894737_g14507_i0 | PRJNA217180 | 14607 | 163 | 0.894737 | 1.45842131 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 76.6 | 1.42e-14 | NR | HVY36120.1 | 2053589 | g14507 | i0 | 72.2 | 0.993865030674847 | 54 | 15 | 99.4 | 0 | 163 | 2 | 163 | 216 | HVY36120.1 phenylalanine--tRNA ligase subunit beta [Candidatus Paceibacterota bacterium] | diamond | 162 | 76.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28702480 | 28702480 | PRJNA217180_P_NODE_10027_length_186_cov_1.489051_g9927_i0 | PRJNA217180 | 10027 | 186 | 1.489051 | 2.76963486 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.6 | 2.3e-13 | NR | MEX1028154.1 | 2053589 | g9927 | i0 | 54.1 | 4.91935483870968 | 61 | 28 | 98.4 | 0 | 185 | 3 | 362 | 422 | MEX1028154.1 DNA methyltransferase [Candidatus Paceibacterota bacterium] | diamond | 915 | 73.9 | 0.995940460081191 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29126880 | 29126880 | PRJNA217180_P_NODE_13049_length_166_cov_0.871795_g12949_i0 | PRJNA217180 | 13049 | 166 | 0.871795 | 1.4471797 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 69.7 | 4.08e-12 | NR | MFA5987441.1 | 2053589 | g12949 | i0 | 54.5 | 1.96987951807229 | 55 | 25 | 99.4 | 0 | 2 | 166 | 693 | 747 | MFA5987441.1 AAA family ATPase [Candidatus Paceibacterota bacterium] | diamond | 327 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29284291 | 29284291 | PRJNA217180_P_NODE_15009_length_162_cov_0.902655_g14909_i0 | PRJNA217180 | 15009 | 162 | 0.902655 | 1.4623011 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 99 | 8.680000000000001e-26 | NR | HOV89030.1 | 2053589 | g14909 | i0 | 85.2 | 1 | 54 | 8 | 100 | 0 | 1 | 162 | 4 | 57 | HOV89030.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 162 | 99 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29442095 | 29442095 | PRJNA217180_P_NODE_15370_length_161_cov_0.910714_g15270_i0 | PRJNA217180 | 15370 | 161 | 0.910714 | 1.46624954 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.3 | 0.00351 | NR | MCF7864982.1 | 2053589 | g15270 | i0 | 76.9 | 0.484472049689441 | 26 | 6 | 48.4 | 0 | 159 | 82 | 252 | 277 | MCF7864982.1 aromatic amino acid ammonia-lyase [Candidatus Paceibacterota bacterium] | diamond | 78 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29726251 | 29726251 | PRJNA217180_P_NODE_14510_length_163_cov_0.894737_g14410_i0 | PRJNA217180 | 14510 | 163 | 0.894737 | 1.45842131 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.7 | 5.9e-21 | NR | MCU0678158.1 | 2053589 | g14410 | i0 | 92.5 | 0.975460122699387 | 53 | 4 | 97.5 | 0 | 3 | 161 | 255 | 307 | MCU0678158.1 efflux RND transporter permease subunit [Candidatus Paceibacterota bacterium] | diamond | 159 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29979185 | 29979185 | PRJNA217180_P_NODE_11411_length_175_cov_1.214286_g11311_i0 | PRJNA217180 | 11411 | 175 | 1.214286 | 2.1250005 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 55.1 | 2.99e-7 | NR | MFA6049656.1 | 2053589 | g11311 | i0 | 60.6 | 0.565714285714286 | 33 | 13 | 56.6 | 0 | 2 | 100 | 146 | 178 | MFA6049656.1 ribonuclease H-like YkuK family protein [Candidatus Paceibacterota bacterium] | diamond | 99 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30200140 | 30200140 | PRJNA217180_P_NODE_15012_length_162_cov_0.902655_g14912_i0 | PRJNA217180 | 15012 | 162 | 0.902655 | 1.4623011 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 48.1 | 1.52e-4 | NR | HEY6021369.1 | 2053589 | g14912 | i0 | 51.2 | 0.796296296296296 | 43 | 21 | 79.6 | 0 | 27 | 155 | 14 | 56 | HEY6021369.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 129 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31085050 | 31085050 | PRJNA217180_P_NODE_15435_length_161_cov_0.910714_g15335_i0 | PRJNA217180 | 15435 | 161 | 0.910714 | 1.46624954 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 51.2 | 1.24e-5 | NR | MFA6609189.1 | 2053589 | g15335 | i0 | 50 | 0.782608695652174 | 42 | 21 | 78.3 | 0 | 156 | 31 | 499 | 540 | MFA6609189.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 126 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31496283 | 31496283 | PRJNA217180_P_NODE_15456_length_161_cov_0.910714_g15356_i0 | PRJNA217180 | 15456 | 161 | 0.910714 | 1.46624954 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 83.2 | 6.71e-17 | NR | MEZ4104134.1 | 2053589 | g15356 | i0 | 73.6 | 0.987577639751553 | 53 | 14 | 98.8 | 0 | 1 | 159 | 452 | 504 | MEZ4104134.1 CTP synthase [Candidatus Paceibacterota bacterium] | diamond | 159 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31938775 | 31938775 | PRJNA217180_P_NODE_14357_length_163_cov_0.894737_g14257_i0 | PRJNA217180 | 14357 | 163 | 0.894737 | 1.45842131 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 56.2 | 1.06e-7 | NR | MFA6050501.1 | 2053589 | g14257 | i0 | 89.7 | 2.13496932515337 | 29 | 3 | 53.4 | 0 | 163 | 77 | 172 | 200 | MFA6050501.1 toprim domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 348 | 56.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32223780 | 32223780 | PRJNA217180_P_NODE_10238_length_185_cov_1.007353_g10138_i0 | PRJNA217180 | 10238 | 185 | 1.007353 | 1.86360305 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 108 | 2.89e-27 | NR | MCF7865031.1 | 2053589 | g10138 | i0 | 85.2 | 2.96756756756757 | 61 | 9 | 98.9 | 0 | 3 | 185 | 37 | 97 | MCF7865031.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 549 | 108 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32603214 | 32603214 | PRJNA217180_P_NODE_13480_length_165_cov_0.879310_g13380_i0 | PRJNA217180 | 13480 | 165 | 0.87931 | 1.4508615 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.7 | 1.29e-21 | NR | MFA5387279.1 | 2053589 | g13380 | i0 | 85.5 | 1.96363636363636 | 55 | 8 | 100 | 0 | 165 | 1 | 131 | 185 | MFA5387279.1 major capsid protein [Candidatus Paceibacterota bacterium] | diamond | 324 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32760602 | 32760602 | PRJNA217180_P_NODE_14400_length_163_cov_0.894737_g14300_i0 | PRJNA217180 | 14400 | 163 | 0.894737 | 1.45842131 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 65.9 | 8.49e-11 | NR | MFA6049671.1 | 2053589 | g14300 | i0 | 52.8 | 0.975460122699387 | 53 | 25 | 97.5 | 0 | 161 | 3 | 40 | 92 | MFA6049671.1 bifunctional DNA primase/polymerase [Candidatus Paceibacterota bacterium] | diamond | 159 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32791901 | 32791901 | PRJNA217180_P_NODE_13800_length_164_cov_0.886957_g13700_i0 | PRJNA217180 | 13800 | 164 | 0.886957 | 1.45460948 | Minisyncoccia bacterium | 3120121 | Bacteria | Bacteria | 46.6 | 3.68e-4 | NR | MFN3692627.1 | 3120121 | g13700 | i0 | 51 | 0.896341463414634 | 49 | 23 | 89.6 | 1 | 163 | 17 | 139 | 186 | MFN3692627.1 hypothetical protein [Minisyncoccia bacterium] | diamond | 147 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Minisyncoccia 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);;