contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26662093 | 26662093 | PRJNA168635_P_NODE_29501_length_164_cov_2.460870_g29085_i0 | PRJNA168635 | 29501 | 164 | 2.46087 | 4.0358268 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 93.6 | 4.5e-21 | NR | MFA6269663.1 | 2053589 | g29085 | i0 | 78.8 | 0.951219512195122 | 52 | 11 | 95.1 | 0 | 158 | 3 | 147 | 198 | MFA6269663.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 156 | 93.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26978962 | 26978962 | PRJNA168635_P_NODE_34242_length_155_cov_3.632075_g33826_i0 | PRJNA168635 | 34242 | 155 | 3.632075 | 5.62971625 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 65.1 | 8.3e-11 | NR | HNU95674.1 | 2053589 | g33826 | i0 | 67.5 | 0.774193548387097 | 40 | 13 | 77.4 | 0 | 120 | 1 | 110 | 149 | HNU95674.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 120 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27231915 | 27231915 | PRJNA168635_P_NODE_19443_length_184_cov_1.851852_g19027_i0 | PRJNA168635 | 19443 | 184 | 1.851852 | 3.40740768 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 62 | 2.72e-9 | NR | HEY9583670.1 | 2053589 | g19027 | i0 | 54.1 | 0.994565217391304 | 61 | 26 | 99.5 | 1 | 184 | 2 | 496 | 554 | HEY9583670.1 DNA primase [Candidatus Paceibacterota bacterium] | diamond | 183 | 62 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27421790 | 27421790 | PRJNA168635_P_NODE_34563_length_154_cov_3.523810_g34147_i0 | PRJNA168635 | 34563 | 154 | 3.52381 | 5.4266674 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 9.27e-4 | NR | MEX0918437.1 | 2053589 | g34147 | i0 | 52 | 1.83116883116883 | 50 | 21 | 97.4 | 1 | 152 | 3 | 21 | 67 | MEX0918437.1 DUF378 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 282 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27660561 | 27660561 | PRJNA168635_P_NODE_22604_length_175_cov_1.301587_g22188_i0 | PRJNA168635 | 22604 | 175 | 1.301587 | 2.27777725 | Bacteria | 2 | Bacteria | Bacteria | 118 | 5.9599999999999994e-30 | NR | HRH22627.1 | 2053589 | g22188 | i0 | 100 | 16.9028571428571 | 58 | 0 | 99.4 | 0 | 174 | 1 | 51 | 108 | HRH22627.1 cell division protein FtsZ [Candidatus Paceibacterota bacterium] | diamond | 2958 | 118 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27674341 | 27674341 | PRJNA168635_P_NODE_15044_length_207_cov_3.348101_g14628_i0 | PRJNA168635 | 15044 | 207 | 3.348101 | 6.93056907 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.3 | 0.00293 | NR | MBP6974587.1 | 2053589 | g14628 | i0 | 54.1 | 1.10144927536232 | 37 | 17 | 53.6 | 0 | 32 | 142 | 107 | 143 | MBP6974587.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 228 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28116076 | 28116076 | PRJNA168635_P_NODE_17265_length_192_cov_4.762238_g16849_i0 | PRJNA168635 | 17265 | 192 | 4.762238 | 9.14349696 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 81.6 | 3.67e-16 | NR | HEY1041565.1 | 2053589 | g16849 | i0 | 65.1 | 0.984375 | 63 | 22 | 98.4 | 0 | 190 | 2 | 3105 | 3167 | HEY1041565.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 189 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28368679 | 28368679 | PRJNA168635_P_NODE_27366_length_167_cov_0.881356_g26950_i0 | PRJNA168635 | 27366 | 167 | 0.881356 | 1.47186452 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 75.9 | 2.78e-14 | NR | MFA7285702.1 | 2053589 | g26950 | i0 | 78.2 | 0.988023952095808 | 55 | 12 | 98.8 | 0 | 2 | 166 | 2431 | 2485 | MFA7285702.1 autotransporter-associated beta strand repeat-containing protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 75.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28495229 | 28495229 | PRJNA168635_P_NODE_26487_length_168_cov_0.873950_g26071_i0 | PRJNA168635 | 26487 | 168 | 0.87395 | 1.468236 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.9 | 0.00523 | NR | MFA6270290.1 | 2053589 | g26071 | i0 | 50 | 0.607142857142857 | 34 | 17 | 60.7 | 0 | 166 | 65 | 311 | 344 | MFA6270290.1 phage portal protein [Candidatus Paceibacterota bacterium] | diamond | 102 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28526851 | 28526851 | PRJNA168635_P_NODE_24687_length_170_cov_1.537190_g24271_i0 | PRJNA168635 | 24687 | 170 | 1.53719 | 2.613223 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 80.5 | 5.28e-17 | NR | MBP9757577.1 | 2053589 | g24271 | i0 | 69.1 | 0.970588235294118 | 55 | 16 | 97.1 | 1 | 6 | 170 | 35 | 88 | MBP9757577.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 80.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28684718 | 28684718 | PRJNA168635_P_NODE_22467_length_175_cov_1.642857_g22051_i0 | PRJNA168635 | 22467 | 175 | 1.642857 | 2.87499975 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 81.6 | 6.89e-17 | NR | MFA6459612.1 | 2053589 | g22051 | i0 | 90 | 0.685714285714286 | 40 | 4 | 68.6 | 0 | 172 | 53 | 227 | 266 | MFA6459612.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 120 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28716180 | 28716180 | PRJNA168635_P_NODE_27727_length_166_cov_1.769231_g27311_i0 | PRJNA168635 | 27727 | 166 | 1.769231 | 2.93692346 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 68.9 | 7.26e-12 | NR | MFA5166569.1 | 2053589 | g27311 | i0 | 59.3 | 0.975903614457831 | 54 | 22 | 97.6 | 0 | 164 | 3 | 314 | 367 | MFA5166569.1 ATP-dependent helicase [Candidatus Paceibacterota bacterium] | diamond | 162 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28810444 | 28810444 | PRJNA168635_P_NODE_21548_length_177_cov_4.656250_g21132_i0 | PRJNA168635 | 21548 | 177 | 4.65625 | 8.2415625 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 72 | 7.36e-13 | NR | HOO48005.1 | 2053589 | g21132 | i0 | 61 | 2 | 59 | 19 | 100 | 1 | 177 | 1 | 292 | 346 | HOO48005.1 helix-turn-helix domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 354 | 72 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29144690 | 29144690 | PRJNA168635_P_NODE_14669_length_210_cov_2.881988_g14253_i0 | PRJNA168635 | 14669 | 210 | 2.881988 | 6.0521748 | Bacteria | 2 | Bacteria | Bacteria | 70.5 | 3.92e-12 | NR | MFA6554219.1 | 2053589 | g14253 | i0 | 100 | 1.94285714285714 | 34 | 0 | 48.6 | 0 | 108 | 209 | 5 | 38 | MFA6554219.1 LysM domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 408 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29442029 | 29442029 | PRJNA168635_P_NODE_27470_length_167_cov_0.881356_g27054_i0 | PRJNA168635 | 27470 | 167 | 0.881356 | 1.47186452 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 93.2 | 1.4200000000000002e-21 | NR | MCU0678474.1 | 2053589 | g27054 | i0 | 89.1 | 0.988023952095808 | 55 | 6 | 98.8 | 0 | 165 | 1 | 28 | 82 | MCU0678474.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 93.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29536994 | 29536994 | PRJNA168635_P_NODE_22130_length_176_cov_1.614173_g21714_i0 | PRJNA168635 | 22130 | 176 | 1.614173 | 2.84094448 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 107 | 9.82e-26 | NR | HXK38131.1 | 2053589 | g21714 | i0 | 94.8 | 0.988636363636364 | 58 | 3 | 98.9 | 0 | 1 | 174 | 331 | 388 | HXK38131.1 sigma-70 family RNA polymerase sigma factor [Candidatus Paceibacterota bacterium] | diamond | 174 | 107 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30168510 | 30168510 | PRJNA168635_P_NODE_26312_length_168_cov_0.873950_g25896_i0 | PRJNA168635 | 26312 | 168 | 0.87395 | 1.468236 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 55.5 | 4.35e-7 | NR | MDR3571053.1 | 2053589 | g25896 | i0 | 49.1 | 0.982142857142857 | 55 | 28 | 98.2 | 0 | 3 | 167 | 841 | 895 | MDR3571053.1 tail fiber domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 55.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30863729 | 30863729 | PRJNA168635_P_NODE_25514_length_169_cov_0.866667_g25098_i0 | PRJNA168635 | 25514 | 169 | 0.866667 | 1.46466723 | Minisyncoccia bacterium | 3120121 | Bacteria | Bacteria | 61.2 | 1.1e-9 | NR | MFT7645060.1 | 3120121 | g25098 | i0 | 53.6 | 1.84615384615385 | 56 | 26 | 99.4 | 0 | 168 | 1 | 52 | 107 | MFT7645060.1 hypothetical protein [Minisyncoccia bacterium] | diamond | 312 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Minisyncoccia bacterium | |||||
| 31084983 | 31084983 | PRJNA168635_P_NODE_17055_length_193_cov_7.500000_g16639_i0 | PRJNA168635 | 17055 | 193 | 7.5 | 14.475 | Minisyncoccia bacterium | 3120121 | Bacteria | Bacteria | 43.1 | 0.0102 | NR | MFT7645060.1 | 3120121 | g16639 | i0 | 83.3 | 0.373056994818653 | 24 | 4 | 37.3 | 0 | 73 | 2 | 45 | 68 | MFT7645060.1 hypothetical protein [Minisyncoccia bacterium] | diamond | 72 | 43.1 | 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);;