contig_metadata
17 rows where bioproject = "PRJNA615351", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6974177 | 6974177 | PRJNA615351_P_NODE_33166_length_1051_cov_5.619094_g24375_i0 | PRJNA615351 | 33166 | 1051 | 5.619094 | 59.05667794 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 141 | 4.24e-35 | NR | MFA6006130.1 | 2053589 | g24375 | i0 | 33.2 | 3.476688867745 | 301 | 177 | 81.1 | 7 | 893 | 42 | 35 | 328 | MFA6006130.1 redox-regulated ATPase YchF [Candidatus Paceibacterota bacterium] | diamond | 3654 | 141 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26668667 | 26668667 | PRJNA615351_P_NODE_24841_length_1285_cov_4.064800_g9888_i1 | PRJNA615351 | 24841 | 1285 | 4.0648 | 52.23268 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 60.1 | 1.36e-5 | NR | MDR3547318.1 | 2053589 | g9888 | i1 | 34.8 | 0.639688715953307 | 132 | 74 | 29.2 | 5 | 1265 | 891 | 314 | 440 | MDR3547318.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 822 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27143232 | 27143232 | PRJNA615351_P_NODE_2302_length_3467_cov_8.144522_g1578_i1 | PRJNA615351 | 2302 | 3467 | 8.144522 | 282.37057774 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 82.4 | 1.1e-11 | NR | MDR3548749.1 | 2053589 | g1578 | i1 | 23.4 | 0.776175367753101 | 501 | 325 | 40.8 | 13 | 1432 | 20 | 468 | 939 | MDR3548749.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 2691 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27428235 | 27428235 | PRJNA615351_P_NODE_13723_length_1772_cov_4.168682_g9888_i0 | PRJNA615351 | 13723 | 1772 | 4.1686820000000004 | 73.86904504 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 60.1 | 2.51e-5 | NR | MDR3547318.1 | 2053589 | g9888 | i0 | 34.8 | 0.463882618510158 | 132 | 74 | 21.2 | 5 | 21 | 395 | 314 | 440 | MDR3547318.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 822 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28154487 | 28154487 | PRJNA615351_P_NODE_27265_length_1212_cov_2.207307_g19855_i0 | PRJNA615351 | 27265 | 1212 | 2.207307 | 26.75256084 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 48.9 | 0.0458 | NR | MDR3547186.1 | 2053589 | g19855 | i0 | 22.1 | 0.571782178217822 | 231 | 166 | 55.2 | 7 | 7 | 675 | 539 | 763 | MDR3547186.1 PAS domain S-box protein [Candidatus Paceibacterota bacterium] | diamond | 693 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28924850 | 28924850 | PRJNA615351_P_NODE_91908_length_355_cov_3.790625_g77823_i0 | PRJNA615351 | 91908 | 355 | 3.790625 | 13.45671875 | Bacteria | 2 | Bacteria | Bacteria | 48.9 | 8.66e-4 | NR | HEY1041479.1 | 2053589 | g77823 | i0 | 34.6 | 6.65070422535211 | 104 | 52 | 85.4 | 4 | 51 | 353 | 206 | 296 | HEY1041479.1 helix-turn-helix domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 2361 | 49.3 | 0.991886409736308 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29228075 | 29228075 | PRJNA615351_P_NODE_39709_length_906_cov_3.058553_g9888_i2 | PRJNA615351 | 39709 | 906 | 3.058553 | 27.71049018 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 60.1 | 5.22e-6 | NR | MDR3547318.1 | 2053589 | g9888 | i2 | 34.8 | 0.9072847682119212 | 132 | 74 | 41.4 | 5 | 21 | 395 | 314 | 440 | MDR3547318.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 822 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29322409 | 29322409 | PRJNA615351_P_NODE_26189_length_1243_cov_10.668046_g14858_i3 | PRJNA615351 | 26189 | 1243 | 10.668046 | 132.60381178 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67 | 7.96e-8 | NR | MDD3006790.1 | 2053589 | g14858 | i3 | 29.5 | 0.46580852775543 | 193 | 118 | 42.5 | 4 | 194 | 721 | 35 | 226 | MDD3006790.1 HD domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 579 | 67 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30428350 | 30428350 | PRJNA615351_P_NODE_183213_length_153_cov_1.694915_g169113_i0 | PRJNA615351 | 183213 | 153 | 1.694915 | 2.59321995 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.00605 | NR | MEZ0209192.1 | 2053589 | g169113 | i0 | 40.4 | 0.92156862745098 | 47 | 24 | 84.3 | 2 | 153 | 25 | 428 | 474 | MEZ0209192.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 141 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30807166 | 30807166 | PRJNA615351_P_NODE_27194_length_1213_cov_30.343803_g19804_i0 | PRJNA615351 | 27194 | 1213 | 30.343803 | 368.07033039 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 142 | 1.12e-37 | NR | MDR3549538.1 | 2053589 | g19804 | i0 | 66.3 | 0.24237427864798 | 98 | 33 | 24.2 | 0 | 1166 | 873 | 8 | 105 | MDR3549538.1 small nuclear ribonucleoprotein Sm D2 [Candidatus Paceibacterota bacterium] | diamond | 294 | 142 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31502714 | 31502714 | PRJNA615351_P_NODE_20216_length_1455_cov_11.451408_g14677_i0 | PRJNA615351 | 20216 | 1455 | 11.451408 | 166.6179864 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67 | 1.16e-7 | NR | MDD3006790.1 | 2053589 | g14677 | i0 | 29.5 | 0.397938144329897 | 193 | 118 | 36.3 | 4 | 1262 | 735 | 35 | 226 | MDD3006790.1 HD domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 579 | 67 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31692302 | 31692302 | PRJNA615351_P_NODE_20537_length_1443_cov_2.223011_g14912_i0 | PRJNA615351 | 20537 | 1443 | 2.223011 | 32.07804873 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 91.7 | 7.26e-16 | NR | MDR3547564.1 | 2053589 | g14912 | i0 | 27.3 | 0.509355509355509 | 245 | 169 | 50.5 | 5 | 376 | 1104 | 5 | 242 | MDR3547564.1 ion transporter [Candidatus Paceibacterota bacterium] | diamond | 735 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31881996 | 31881996 | PRJNA615351_P_NODE_2937_length_3200_cov_7.642654_g1578_i2 | PRJNA615351 | 2937 | 3200 | 7.642654 | 244.564928 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 89.7 | 5.5e-14 | NR | MDR3548749.1 | 2053589 | g1578 | i2 | 20.3 | 1.0265625 | 1095 | 652 | 99.1 | 30 | 11 | 3181 | 28 | 939 | MDR3548749.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 3285 | 89.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32008684 | 32008684 | PRJNA615351_P_NODE_2278_length_3476_cov_8.152863_g1578_i0 | PRJNA615351 | 2278 | 3476 | 8.152863 | 283.39351788 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 82.4 | 1.1e-11 | NR | MDR3548749.1 | 2053589 | g1578 | i0 | 23.4 | 0.774165707710011 | 501 | 325 | 40.7 | 13 | 2045 | 3457 | 468 | 939 | MDR3548749.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 2691 | 82.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32388363 | 32388363 | PRJNA615351_P_NODE_37719_length_946_cov_4.045005_g27924_i0 | PRJNA615351 | 37719 | 946 | 4.045005 | 38.2657473 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 172 | 3.629999999999999e-48 | NR | HRT55051.1 | 2053589 | g27924 | i0 | 41.1 | 3.35517970401691 | 270 | 125 | 85.6 | 7 | 96 | 905 | 14 | 249 | HRT55051.1 DNA alkylation repair protein [Candidatus Paceibacterota bacterium] | diamond | 3174 | 172 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32735788 | 32735788 | PRJNA615351_P_NODE_37720_length_946_cov_3.915477_g27924_i1 | PRJNA615351 | 37720 | 946 | 3.915477 | 37.04041242 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 175 | 2.31e-49 | NR | HRT55051.1 | 2053589 | g27924 | i1 | 41.5 | 3.35517970401691 | 270 | 124 | 85.6 | 7 | 96 | 905 | 14 | 249 | HRT55051.1 DNA alkylation repair protein [Candidatus Paceibacterota bacterium] | diamond | 3174 | 175 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32766926 | 32766926 | PRJNA615351_P_NODE_144800_length_198_cov_1.472393_g130700_i0 | PRJNA615351 | 144800 | 198 | 1.472393 | 2.91533814 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52.8 | 4.77e-6 | NR | MDR3548581.1 | 2053589 | g130700 | i0 | 50.9 | 0.803030303030303 | 53 | 24 | 80.3 | 1 | 196 | 38 | 110 | 160 | MDR3548581.1 methyltransferase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 159 | 52.8 | 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);;