contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26827619 | 26827619 | PRJNA630162_P_NODE_120921_length_174_cov_1.384000_g119398_i0 | PRJNA630162 | 120921 | 174 | 1.384 | 2.40816 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 106 | 5.83e-25 | NR | MBP6975019.1 | 2053589 | g119398 | i0 | 89.3 | 1.93103448275862 | 56 | 6 | 96.6 | 0 | 173 | 6 | 344 | 399 | MBP6975019.1 threonine--tRNA ligase [Candidatus Paceibacterota bacterium] | diamond | 336 | 106 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28028295 | 28028295 | PRJNA630162_P_NODE_118905_length_175_cov_1.428571_g117382_i0 | PRJNA630162 | 118905 | 175 | 1.428571 | 2.49999925 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79.7 | 5.78e-17 | NR | MFA5387275.1 | 2053589 | g117382 | i0 | 64.3 | 2.88 | 56 | 20 | 96 | 0 | 6 | 173 | 48 | 103 | MFA5387275.1 DnaT-like ssDNA-binding protein [Candidatus Paceibacterota bacterium] | diamond | 504 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28375639 | 28375639 | PRJNA630162_P_NODE_96826_length_187_cov_2.913043_g95303_i0 | PRJNA630162 | 96826 | 187 | 2.913043 | 5.44739041 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 84 | 2.54e-18 | NR | HEY4524106.1 | 2053589 | g95303 | i0 | 65 | 0.962566844919786 | 60 | 21 | 96.3 | 0 | 6 | 185 | 127 | 186 | HEY4524106.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 180 | 84 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28501945 | 28501945 | PRJNA630162_P_NODE_162207_length_162_cov_0.920354_g160684_i0 | PRJNA630162 | 162207 | 162 | 0.920354 | 1.49097348 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 53.5 | 9.07e-7 | NR | MBP6949104.1 | 2053589 | g160684 | i0 | 100 | 0.962962962962963 | 26 | 0 | 48.1 | 0 | 84 | 161 | 77 | 102 | MBP6949104.1 Hsp20/alpha crystallin family protein [Candidatus Paceibacterota bacterium] | diamond | 156 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28785859 | 28785859 | PRJNA630162_P_NODE_158407_length_162_cov_2.522124_g156884_i0 | PRJNA630162 | 158407 | 162 | 2.522124 | 4.08584088 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 47.8 | 2.18e-4 | NR | MFA5349116.1 | 2053589 | g156884 | i0 | 46.2 | 2.88888888888889 | 52 | 26 | 96.3 | 1 | 156 | 1 | 454 | 503 | MFA5349116.1 AAA family ATPase [Candidatus Paceibacterota bacterium] | diamond | 468 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29259511 | 29259511 | PRJNA630162_P_NODE_54949_length_238_cov_1.074074_g53426_i0 | PRJNA630162 | 54949 | 238 | 1.074074 | 2.55629612 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.7 | 0.00697 | NR | MFM7088008.1 | 2053589 | g53426 | i0 | 42.6 | 0.680672268907563 | 54 | 27 | 66.8 | 2 | 237 | 79 | 205 | 255 | MFM7088008.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 162 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29543658 | 29543658 | PRJNA630162_P_NODE_131470_length_169_cov_0.866667_g129947_i0 | PRJNA630162 | 131470 | 169 | 0.866667 | 1.46466723 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 65.9 | 9.59e-11 | NR | MFA6608538.1 | 2053589 | g129947 | i0 | 59.3 | 0.958579881656805 | 54 | 22 | 95.9 | 0 | 163 | 2 | 148 | 201 | MFA6608538.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 162 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29701276 | 29701276 | PRJNA630162_P_NODE_140870_length_167_cov_0.881356_g139347_i0 | PRJNA630162 | 140870 | 167 | 0.881356 | 1.47186452 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.1 | 0.00464 | NR | MFA5387312.1 | 2053589 | g139347 | i0 | 39.6 | 0.952095808383233 | 53 | 32 | 95.2 | 0 | 6 | 164 | 2 | 54 | MFA5387312.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 159 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29701295 | 29701295 | PRJNA630162_P_NODE_156130_length_163_cov_0.912281_g154607_i0 | PRJNA630162 | 156130 | 163 | 0.912281 | 1.48701803 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 71.2 | 1.07e-12 | NR | MEZ0209060.1 | 2053589 | g154607 | i0 | 56.9 | 0.938650306748466 | 51 | 22 | 93.9 | 0 | 158 | 6 | 646 | 696 | MEZ0209060.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 153 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29701299 | 29701299 | PRJNA630162_P_NODE_159570_length_162_cov_1.504425_g158047_i0 | PRJNA630162 | 159570 | 162 | 1.504425 | 2.4371685 | Candidatus Pacebacteria bacterium CG_4_1 | 1974760 | Bacteria | Bacteria | 61.6 | 1.66e-9 | NR | PIY79457.1 | 1974760 | g158047 | i0 | 73.5 | 0.62962962962963 | 34 | 9 | 63 | 0 | 162 | 61 | 217 | 250 | PIY79457.1 MAG: hypothetical protein COY81_02415 [Candidatus Pacebacteria bacterium CG_4_10_14_0_8_um_filter_43_12] | diamond | 102 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Pacebacteria bacterium CG_4_10_14_0_8_um_filter_43_12 | ||||||
| 30080497 | 30080497 | PRJNA630162_P_NODE_151152_length_164_cov_1.400000_g149629_i0 | PRJNA630162 | 151152 | 164 | 1.4 | 2.296 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.1 | 0.00103 | NR | MCF7865100.1 | 2053589 | g149629 | i0 | 51.1 | 0.823170731707317 | 45 | 22 | 82.3 | 0 | 22 | 156 | 109 | 153 | MCF7865100.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 135 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30775870 | 30775870 | PRJNA630162_P_NODE_120094_length_174_cov_2.160000_g118571_i0 | PRJNA630162 | 120094 | 174 | 2.16 | 3.7584 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.5 | 2.97e-8 | NR | MBP6888362.1 | 2053589 | g118571 | i0 | 48.2 | 0.96551724137931 | 56 | 29 | 96.6 | 0 | 172 | 5 | 137 | 192 | MBP6888362.1 A/G-specific adenine glycosylase [Candidatus Paceibacterota bacterium] | diamond | 168 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30838955 | 30838955 | PRJNA630162_P_NODE_136354_length_168_cov_0.873950_g134831_i0 | PRJNA630162 | 136354 | 168 | 0.87395 | 1.468236 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 57 | 1.1e-7 | NR | MCF7865690.1 | 2053589 | g134831 | i0 | 54.7 | 0.946428571428571 | 53 | 19 | 94.6 | 1 | 6 | 164 | 19 | 66 | MCF7865690.1 protein translocase subunit SecF [Candidatus Paceibacterota bacterium] | diamond | 159 | 57 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31122912 | 31122912 | PRJNA630162_P_NODE_117135_length_176_cov_1.370079_g115612_i0 | PRJNA630162 | 117135 | 176 | 1.370079 | 2.41133904 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 39.7 | 0.0391 | NR | MEX0595307.1 | 2053589 | g115612 | i0 | 36.5 | 0.886363636363636 | 52 | 32 | 88.6 | 1 | 173 | 18 | 18 | 68 | MEX0595307.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 156 | 39.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31471484 | 31471484 | PRJNA630162_P_NODE_93076_length_190_cov_1.248227_g91553_i0 | PRJNA630162 | 93076 | 190 | 1.248227 | 2.3716313 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 69.3 | 1.06e-12 | NR | MBP6948505.1 | 2053589 | g91553 | i0 | 68.8 | 1.70526315789474 | 48 | 15 | 75.8 | 0 | 148 | 5 | 50 | 97 | MBP6948505.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 324 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31692643 | 31692643 | PRJNA630162_P_NODE_65677_length_218_cov_2.082840_g64154_i0 | PRJNA630162 | 65677 | 218 | 2.08284 | 4.5405912 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 41.6 | 0.0135 | NR | MFA5937434.1 | 2053589 | g64154 | i0 | 41 | 1.67889908256881 | 61 | 31 | 77.1 | 1 | 170 | 3 | 13 | 73 | MFA5937434.1 30S ribosomal protein S20 [Candidatus Paceibacterota bacterium] | diamond | 366 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31882166 | 31882166 | PRJNA630162_P_NODE_100697_length_185_cov_1.845588_g99174_i0 | PRJNA630162 | 100697 | 185 | 1.845588 | 3.4143378 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 80.1 | 2.41e-16 | NR | MBP6974648.1 | 2053589 | g99174 | i0 | 68.4 | 2.77297297297297 | 57 | 18 | 92.4 | 0 | 12 | 182 | 1 | 57 | MBP6974648.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 513 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31977172 | 31977172 | PRJNA630162_P_NODE_100358_length_185_cov_2.397059_g98835_i0 | PRJNA630162 | 100358 | 185 | 2.397059 | 4.43455915 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 89.7 | 1.72e-19 | NR | MBP6974368.1 | 2053589 | g98835 | i0 | 75.9 | 1.75135135135135 | 54 | 13 | 87.6 | 0 | 21 | 182 | 146 | 199 | MBP6974368.1 RluA family pseudouridine synthase [Candidatus Paceibacterota bacterium] | diamond | 324 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32198994 | 32198994 | PRJNA630162_P_NODE_98058_length_187_cov_1.166667_g96535_i0 | PRJNA630162 | 98058 | 187 | 1.166667 | 2.18166729 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 75.5 | 7.38e-16 | NR | MBP9782576.1 | 2053589 | g96535 | i0 | 100 | 0.561497326203209 | 35 | 0 | 56.1 | 0 | 180 | 76 | 71 | 105 | MBP9782576.1 KH domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 105 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32830311 | 32830311 | PRJNA630162_P_NODE_108980_length_180_cov_1.977099_g107457_i0 | PRJNA630162 | 108980 | 180 | 1.977099 | 3.5587782 | Candidatus Pacebacteria bacterium CG_4_1 | 1974759 | Bacteria | Bacteria | 95.9 | 2.1e-23 | NR | PIY80637.1 | 1974759 | g107457 | i0 | 67.2 | 0.966666666666667 | 58 | 19 | 96.7 | 0 | 6 | 179 | 46 | 103 | PIY80637.1 MAG: hypothetical protein COY80_01810, partial [Candidatus Pacebacteria bacterium CG_4_10_14_0_8_um_filter_42_14] | diamond | 174 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Pacebacteria bacterium CG_4_10_14_0_8_um_filter_42_14 |
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);;