contig_metadata
12 rows where bioproject = "PRJNA666695", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14662495 | 14662495 | PRJNA666695_S_NODE_9292_length_562_cov_3.641075_g8279_i0 | PRJNA666695 | 9292 | 562 | 3.641075 | 20.4628415 | Minisyncoccus archaeiphilus | 3238481 | Bacteria | Bacteria | 91.6 | 1.17e-13 | NTclustered | gi|2849250805|dbj|AP038758.1| | 3238481 | g8279 | i0 | 84.783 | 0.784697508896797 | 92 | 13 | 16 | 1 | 428 | 519 | 752380 | 752470 | Candidatus Minisyncoccus archaeophilus PMX.108 DNA, complete genome | blastn | 441 | 91.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Minisyncoccales | Minisyncoccaceae | Minisyncoccus | Minisyncoccus archaeiphilus | ||
| 27808267 | 27808267 | PRJNA666695_S_NODE_171164_length_164_cov_1.495935_g170070_i0 | PRJNA666695 | 171164 | 164 | 1.495935 | 2.4533334 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.00679 | NR | MDD4661977.1 | 2053589 | g170070 | i0 | 60.6 | 1.68292682926829 | 33 | 12 | 60.4 | 1 | 6 | 104 | 310 | 341 | MDD4661977.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 276 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29008199 | 29008199 | PRJNA666695_S_NODE_32408_length_346_cov_6.481967_g31314_i0 | PRJNA666695 | 32408 | 346 | 6.481967 | 22.42760582 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 111 | 1.36e-28 | NR | MDD5050120.1 | 2053589 | g31314 | i0 | 46.1 | 0.997109826589595 | 115 | 54 | 99.7 | 2 | 2 | 346 | 47 | 153 | MDD5050120.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 345 | 111 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29102746 | 29102746 | PRJNA666695_S_NODE_47988_length_298_cov_3.579767_g46894_i0 | PRJNA666695 | 47988 | 298 | 3.579767 | 10.66770566 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 99.8 | 1.03e-24 | NR | MDR3570671.1 | 2053589 | g46894 | i0 | 58 | 1.00671140939597 | 100 | 36 | 94.6 | 2 | 293 | 12 | 9 | 108 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 300 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30081316 | 30081316 | PRJNA666695_S_NODE_151392_length_176_cov_3.407407_g150298_i0 | PRJNA666695 | 151392 | 176 | 3.407407 | 5.99703632 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 64.7 | 3.35e-11 | NR | MDR3571063.1 | 2053589 | g150298 | i0 | 68.8 | 0.818181818181818 | 48 | 15 | 81.8 | 0 | 2 | 145 | 107 | 154 | MDR3571063.1 prohibitin family protein [Candidatus Paceibacterota bacterium] | diamond | 144 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30239539 | 30239539 | PRJNA666695_S_NODE_65352_length_264_cov_2.228700_g64258_i0 | PRJNA666695 | 65352 | 264 | 2.2287 | 5.883768 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 49.7 | 1.74e-4 | NR | MEX0598419.1 | 2053589 | g64258 | i0 | 52.5 | 0.454545454545455 | 40 | 19 | 45.5 | 0 | 1 | 120 | 403 | 442 | MEX0598419.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 120 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30271406 | 30271406 | PRJNA666695_S_NODE_59292_length_274_cov_5.231760_g58198_i0 | PRJNA666695 | 59292 | 274 | 5.23176 | 14.3350224 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 73.2 | 1.16e-14 | NR | MDR3572201.1 | 2053589 | g58198 | i0 | 77.6 | 0.536496350364963 | 49 | 11 | 53.6 | 0 | 194 | 48 | 40 | 88 | MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 147 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30650026 | 30650026 | PRJNA666695_S_NODE_25493_length_378_cov_8.198813_g24400_i0 | PRJNA666695 | 25493 | 378 | 8.198813 | 30.99151314 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 65.9 | 5.64e-10 | NR | MDR3581800.1 | 2053589 | g24400 | i0 | 47.9 | 1.74603174603175 | 71 | 37 | 56.3 | 0 | 376 | 164 | 173 | 243 | MDR3581800.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 660 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32041453 | 32041453 | PRJNA666695_S_NODE_188758_length_154_cov_1.221239_g187664_i0 | PRJNA666695 | 188758 | 154 | 1.221239 | 1.88070806 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.0017 | NR | HEY6021105.1 | 2053589 | g187664 | i0 | 67.9 | 1.09090909090909 | 28 | 9 | 54.5 | 0 | 69 | 152 | 81 | 108 | HEY6021105.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32073064 | 32073064 | PRJNA666695_S_NODE_31938_length_348_cov_4.397394_g30844_i0 | PRJNA666695 | 31938 | 348 | 4.397394 | 15.30293112 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.8 | 0.00499 | NR | MDR3549026.1 | 2053589 | g30844 | i0 | 52.6 | 0.327586206896552 | 38 | 18 | 32.8 | 0 | 346 | 233 | 95 | 132 | MDR3549026.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 114 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32136374 | 32136374 | PRJNA666695_S_NODE_121038_length_200_cov_1.157233_g119944_i0 | PRJNA666695 | 121038 | 200 | 1.157233 | 2.314466 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 45.4 | 6.93e-4 | NR | MDR3582048.1 | 2053589 | g119944 | i0 | 37.5 | 0.96 | 64 | 40 | 96 | 0 | 196 | 5 | 15 | 78 | MDR3582048.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 192 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32673516 | 32673516 | PRJNA666695_S_NODE_177000_length_160_cov_2.705882_g175906_i0 | PRJNA666695 | 177000 | 160 | 2.705882 | 4.3294112 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52.8 | 1.52e-6 | NR | MBP6869096.1 | 2053589 | g175906 | i0 | 57.5 | 3.20625 | 40 | 17 | 75 | 0 | 2 | 121 | 134 | 173 | MBP6869096.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Candidatus Paceibacterota bacterium] | diamond | 513 | 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);;