contig_metadata
13 rows where bioproject = "PRJNA404067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26726871 | 26726871 | PRJNA404067_P_NODE_30121_length_211_cov_1.373333_g29734_i0 | PRJNA404067 | 30121 | 211 | 1.373333 | 2.89773263 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 41.2 | 0.0479 | NR | MEO5646609.1 | 2053589 | g29734 | i0 | 69 | 0.412322274881517 | 29 | 9 | 41.2 | 0 | 211 | 125 | 118 | 146 | MEO5646609.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 87 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26854171 | 26854171 | PRJNA404067_P_NODE_28301_length_215_cov_1.272727_g27914_i0 | PRJNA404067 | 28301 | 215 | 1.272727 | 2.73636305 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 97.4 | 9.05e-24 | NR | HXF44039.1 | 2053589 | g27914 | i0 | 77.4 | 1.78604651162791 | 62 | 14 | 86.5 | 0 | 30 | 215 | 15 | 76 | HXF44039.1 phBC6A51 family helix-turn-helix protein [Candidatus Paceibacterota bacterium] | diamond | 384 | 97.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26854181 | 26854181 | PRJNA404067_P_NODE_45581_length_164_cov_5.000000_g45194_i0 | PRJNA404067 | 45581 | 164 | 5 | 8.2 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 62 | 1.37e-9 | NR | MFA6050174.1 | 2053589 | g45194 | i0 | 61.1 | 4.92073170731707 | 54 | 20 | 98.8 | 1 | 163 | 2 | 8 | 60 | MFA6050174.1 helix-turn-helix domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 807 | 62 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27296700 | 27296700 | PRJNA404067_P_NODE_28563_length_214_cov_1.758170_g28176_i0 | PRJNA404067 | 28563 | 214 | 1.75817 | 3.7624838 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 51.2 | 2.54e-5 | NR | MBI5151333.1 | 2053589 | g28176 | i0 | 86.7 | 0.420560747663551 | 30 | 3 | 40.7 | 1 | 3 | 89 | 640 | 669 | MBI5151333.1 DEAD/DEAH box helicase family protein [Candidatus Paceibacterota bacterium] | diamond | 90 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28180636 | 28180636 | PRJNA404067_P_NODE_38526_length_201_cov_1.128571_g38139_i0 | PRJNA404067 | 38526 | 201 | 1.128571 | 2.26842771 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 107 | 5.36e-27 | NR | MBP9763348.1 | 2053589 | g38139 | i0 | 96.1 | 0.761194029850746 | 51 | 2 | 76.1 | 0 | 155 | 3 | 1 | 51 | MBP9763348.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 153 | 107 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28780594 | 28780594 | PRJNA404067_P_NODE_24667_length_224_cov_0.932515_g24280_i0 | PRJNA404067 | 24667 | 224 | 0.932515 | 2.0888336 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 101 | 5.34e-23 | NR | MFA6432623.1 | 2053589 | g24280 | i0 | 77 | 0.991071428571429 | 74 | 16 | 97.8 | 1 | 6 | 224 | 13 | 86 | MFA6432623.1 preprotein translocase subunit SecA [Candidatus Paceibacterota bacterium] | diamond | 222 | 101 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28970247 | 28970247 | PRJNA404067_P_NODE_35188_length_204_cov_1.503497_g34801_i0 | PRJNA404067 | 35188 | 204 | 1.503497 | 3.06713388 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 106 | 8.95e-26 | NR | MFA6458833.1 | 2053589 | g34801 | i0 | 89.3 | 0.823529411764706 | 56 | 6 | 82.4 | 0 | 169 | 2 | 102 | 157 | MFA6458833.1 reverse transcriptase/maturase family protein [Candidatus Paceibacterota bacterium] | diamond | 168 | 106 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29222980 | 29222980 | PRJNA404067_P_NODE_27729_length_216_cov_1.741935_g27342_i0 | PRJNA404067 | 27729 | 216 | 1.741935 | 3.7625796 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 92 | 1.09e-19 | NR | MBP6858256.1 | 2053589 | g27342 | i0 | 95.8 | 1.33333333333333 | 48 | 2 | 66.7 | 0 | 190 | 47 | 258 | 305 | MBP6858256.1 FAD-binding oxidoreductase [Candidatus Paceibacterota bacterium] | diamond | 288 | 92 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29696018 | 29696018 | PRJNA404067_P_NODE_43790_length_175_cov_4.508772_g43403_i0 | PRJNA404067 | 43790 | 175 | 4.508772 | 7.890351 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.3 | 0.00412 | NR | MFA5133101.1 | 2053589 | g43403 | i0 | 35.1 | 0.977142857142857 | 57 | 37 | 97.7 | 0 | 3 | 173 | 119 | 175 | MFA5133101.1 glycosyltransferase [Candidatus Paceibacterota bacterium] | diamond | 171 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30423336 | 30423336 | PRJNA404067_P_NODE_31813_length_208_cov_1.435374_g31426_i0 | PRJNA404067 | 31813 | 208 | 1.435374 | 2.98557792 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 85.1 | 2.82e-17 | NR | MFA6050233.1 | 2053589 | g31426 | i0 | 72.5 | 0.995192307692308 | 69 | 18 | 98.1 | 1 | 4 | 207 | 142 | 210 | MFA6050233.1 DNA translocase FtsK 4TM domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 207 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30423337 | 30423337 | PRJNA404067_P_NODE_35433_length_204_cov_0.965035_g35046_i0 | PRJNA404067 | 35433 | 204 | 0.965035 | 1.9686714 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 83.6 | 4.97e-17 | NR | HQV64705.1 | 2053589 | g35046 | i0 | 82.2 | 0.661764705882353 | 45 | 8 | 66.2 | 0 | 136 | 2 | 304 | 348 | HQV64705.1 PilT/PilU family type 4a pilus ATPase [Candidatus Paceibacterota bacterium] | diamond | 135 | 83.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31117829 | 31117829 | PRJNA404067_P_NODE_25795_length_221_cov_0.875000_g25408_i0 | PRJNA404067 | 25795 | 221 | 0.875 | 1.93375 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 80.9 | 1.02e-15 | NR | MFA6314973.1 | 2053589 | g25408 | i0 | 74 | 0.678733031674208 | 50 | 13 | 67.9 | 0 | 72 | 221 | 215 | 264 | MFA6314973.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 150 | 80.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32415131 | 32415131 | PRJNA404067_P_NODE_32599_length_207_cov_1.616438_g32212_i0 | PRJNA404067 | 32599 | 207 | 1.616438 | 3.34602666 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 84.7 | 3.82e-17 | NR | MFA7192260.1 | 2053589 | g32212 | i0 | 61.2 | 0.971014492753623 | 67 | 26 | 97.1 | 0 | 201 | 1 | 297 | 363 | MFA7192260.1 ABC transporter ATP-binding protein [Candidatus Paceibacterota bacterium] | diamond | 201 | 84.7 | 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);;