contig_metadata
7 rows where bioproject = "PRJNA312899", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27674773 | 27674773 | PRJNA312899_P_NODE_75604_length_185_cov_1.500000_g75162_i0 | PRJNA312899 | 75604 | 185 | 1.5 | 2.775 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.4 | 0.00185 | NR | MDD5638921.1 | 2053589 | g75162 | i0 | 41.4 | 0.940540540540541 | 58 | 31 | 90.8 | 2 | 18 | 185 | 216 | 272 | MDD5638921.1 CapA family protein [Candidatus Paceibacterota bacterium] | diamond | 174 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29821340 | 29821340 | PRJNA312899_P_NODE_97031_length_163_cov_0.894737_g96589_i0 | PRJNA312899 | 97031 | 163 | 0.894737 | 1.45842131 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79.3 | 8.2e-16 | NR | HRZ86159.1 | 2053589 | g96589 | i0 | 63 | 0.993865030674847 | 54 | 20 | 99.4 | 0 | 162 | 1 | 97 | 150 | HRZ86159.1 ribonuclease H-like domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 162 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29884904 | 29884904 | PRJNA312899_P_NODE_31391_length_328_cov_4.326165_g30949_i0 | PRJNA312899 | 31391 | 328 | 4.326165 | 14.1898212 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 201 | 4.1899999999999995e-61 | NR | HYF29023.1 | 2053589 | g30949 | i0 | 87.2 | 4.98475609756098 | 109 | 14 | 99.7 | 0 | 328 | 2 | 228 | 336 | HYF29023.1 tRNA guanosine(34) transglycosylase Tgt [Candidatus Paceibacterota bacterium] | diamond | 1635 | 201 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30168884 | 30168884 | PRJNA312899_P_NODE_72332_length_189_cov_1.457143_g71890_i0 | PRJNA312899 | 72332 | 189 | 1.457143 | 2.75400027 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 50.1 | 1.08e-5 | NR | HMO78307.1 | 2053589 | g71890 | i0 | 57.8 | 0.714285714285714 | 45 | 19 | 71.4 | 0 | 53 | 187 | 4 | 48 | HMO78307.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 135 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30485103 | 30485103 | PRJNA312899_P_NODE_90353_length_166_cov_0.871795_g89911_i0 | PRJNA312899 | 90353 | 166 | 0.871795 | 1.4471797 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 84.7 | 1.75e-17 | NR | MBP6866553.1 | 2053589 | g89911 | i0 | 74.5 | 1.98795180722892 | 55 | 14 | 99.4 | 0 | 166 | 2 | 234 | 288 | MBP6866553.1 DUF4147 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 330 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31939140 | 31939140 | PRJNA312899_P_NODE_86337_length_167_cov_0.864407_g85895_i0 | PRJNA312899 | 86337 | 167 | 0.864407 | 1.44355969 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 77.4 | 7.92e-15 | NR | HEY0947890.1 | 2053589 | g85895 | i0 | 69.2 | 1.86826347305389 | 52 | 16 | 93.4 | 0 | 5 | 160 | 341 | 392 | HEY0947890.1 site-specific DNA-methyltransferase [Candidatus Paceibacterota bacterium] | diamond | 312 | 77.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32382281 | 32382281 | PRJNA312899_P_NODE_96539_length_163_cov_0.894737_g96097_i0 | PRJNA312899 | 96539 | 163 | 0.894737 | 1.45842131 | Minisyncoccia bacterium | 3120121 | Bacteria | Bacteria | 60.8 | 2.51e-9 | NR | MFN3188851.1 | 3120121 | g96097 | i0 | 49.1 | 0.975460122699387 | 53 | 27 | 97.5 | 0 | 3 | 161 | 49 | 101 | MFN3188851.1 hypothetical protein [Minisyncoccia bacterium] | diamond | 159 | 60.8 | 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);;