contig_metadata
9 rows where bioproject = "PRJNA1010780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23953858 | 23953858 | PRJNA1010780_S_NODE_15879_length_512_cov_3.245283_g14643_i0 | PRJNA1010780 | 15879 | 512 | 3.245283 | 16.61584896 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 73.6 | 1.39e-13 | NR | HTH93272.1 | 2053589 | g14643 | i0 | 54.8 | 1.751953125 | 62 | 27 | 36.3 | 1 | 1 | 186 | 32 | 92 | HTH93272.1 RNA-binding protein [Candidatus Paceibacterota bacterium] | diamond | 897 | 73.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28234553 | 28234553 | PRJNA1010780_S_NODE_32686_length_245_cov_1.738095_g31397_i0 | PRJNA1010780 | 32686 | 245 | 1.738095 | 4.25833275 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 68.2 | 4.08e-11 | NR | MDD5431287.1 | 2053589 | g31397 | i0 | 65.2 | 0.563265306122449 | 46 | 16 | 56.3 | 0 | 108 | 245 | 213 | 258 | MDD5431287.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 138 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28455915 | 28455915 | PRJNA1010780_S_NODE_12406_length_645_cov_3.101639_g11314_i0 | PRJNA1010780 | 12406 | 645 | 3.101639 | 20.00557155 | Minisyncoccia bacterium | 3120121 | Bacteria | Bacteria | 69.7 | 2.64e-10 | NR | MFA9238562.1 | 3120121 | g11314 | i0 | 29.5 | 1.4093023255814 | 156 | 102 | 68.8 | 2 | 168 | 611 | 26 | 181 | MFA9238562.1 DNA ligase [Minisyncoccia bacterium] | diamond | 909 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Minisyncoccia bacterium | |||||
| 28519047 | 28519047 | PRJNA1010780_S_NODE_25367_length_312_cov_3.588448_g24078_i0 | PRJNA1010780 | 25367 | 312 | 3.588448 | 11.19595776 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 88.2 | 1.03e-18 | NR | MDD5165045.1 | 2053589 | g24078 | i0 | 49.4 | 0.817307692307692 | 85 | 43 | 81.7 | 0 | 264 | 10 | 79 | 163 | MDD5165045.1 NUDIX domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 255 | 88.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28929434 | 28929434 | PRJNA1010780_S_NODE_28688_length_277_cov_1.491736_g27399_i0 | PRJNA1010780 | 28688 | 277 | 1.491736 | 4.13210872 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 164 | 2.95e-45 | NR | MDP6249807.1 | 2053589 | g27399 | i0 | 77.2 | 3.985559566787 | 92 | 21 | 99.6 | 0 | 276 | 1 | 28 | 119 | MDP6249807.1 fused protease/ribonucleoside-triphosphate reductase [Candidatus Paceibacterota bacterium] | diamond | 1104 | 164 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30319527 | 30319527 | PRJNA1010780_S_NODE_35772_length_226_cov_2.963351_g34483_i0 | PRJNA1010780 | 35772 | 226 | 2.963351 | 6.69717326 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 49.3 | 1.4e-4 | NR | MDR3547592.1 | 2053589 | g34483 | i0 | 32.4 | 0.902654867256637 | 68 | 46 | 90.3 | 0 | 205 | 2 | 216 | 283 | MDR3547592.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 204 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30698003 | 30698003 | PRJNA1010780_S_NODE_22174_length_360_cov_2.178462_g20885_i0 | PRJNA1010780 | 22174 | 360 | 2.178462 | 7.8424632 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 44.3 | 0.00947 | NR | MCK9351335.1 | 2053589 | g20885 | i0 | 27.1 | 0.491666666666667 | 59 | 37 | 44.2 | 1 | 68 | 226 | 38 | 96 | MCK9351335.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 177 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30761362 | 30761362 | PRJNA1010780_S_NODE_18774_length_431_cov_2.272727_g17496_i0 | PRJNA1010780 | 18774 | 431 | 2.272727 | 9.79545337 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.034 | NR | MDR3582048.1 | 2053589 | g17496 | i0 | 51 | 0.354988399071926 | 51 | 24 | 35.5 | 1 | 431 | 279 | 65 | 114 | MDR3582048.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 153 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30792861 | 30792861 | PRJNA1010780_S_NODE_44874_length_189_cov_2.032468_g43585_i0 | PRJNA1010780 | 44874 | 189 | 2.032468 | 3.84136452 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 53.1 | 1.79e-6 | NR | NCN82385.1 | 2053589 | g43585 | i0 | 60 | 0.555555555555556 | 35 | 14 | 55.6 | 0 | 17 | 121 | 97 | 131 | NCN82385.1 nicotinate (nicotinamide) nucleotide adenylyltransferase [Candidatus Paceibacterota bacterium] | diamond | 105 | 53.1 | 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);;