contig_metadata
11 rows where bioproject = "PRJEB28062", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25592 | 25592 | PRJEB28062_P_NODE_84861_length_361_cov_7.475694_g82499_i0 | PRJEB28062 | 84861 | 361 | 7.475694 | 26.98725534 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 113 | 2.93e-27 | NR | MFA6797494.1 | 2053589 | g82499 | i0 | 46.9 | 0.939058171745152 | 113 | 58 | 92.2 | 1 | 342 | 10 | 193 | 305 | MFA6797494.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 339 | 113 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 3851937 | 3851937 | PRJEB28062_P_NODE_92804_length_336_cov_6.201521_g90442_i0 | PRJEB28062 | 92804 | 336 | 6.201521 | 20.83711056 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 193 | 7.57e-58 | NR | MDR3519341.1 | 2053589 | g90442 | i0 | 91.3 | 0.919642857142857 | 103 | 9 | 92 | 0 | 26 | 334 | 292 | 394 | MDR3519341.1 bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [Candidatus Paceibacterota bacterium] | diamond | 309 | 193 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26653063 | 26653063 | PRJEB28062_P_NODE_30641_length_665_cov_106.761824_g28352_i0 | PRJEB28062 | 30641 | 665 | 106.761824 | 709.9661296 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 146 | 3.939999999999999e-40 | NR | MFA6049656.1 | 2053589 | g28352 | i0 | 46.5 | 0.77593984962406 | 172 | 79 | 74.9 | 4 | 595 | 98 | 8 | 172 | MFA6049656.1 ribonuclease H-like YkuK family protein [Candidatus Paceibacterota bacterium] | diamond | 516 | 146 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27033181 | 27033181 | PRJEB28062_P_NODE_99302_length_317_cov_1.750000_g96940_i0 | PRJEB28062 | 99302 | 317 | 1.75 | 5.5475 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 64.3 | 2.51e-9 | NR | MBP6881035.1 | 2053589 | g96940 | i0 | 48.2 | 0.529968454258675 | 56 | 29 | 53 | 0 | 317 | 150 | 2691 | 2746 | MBP6881035.1 DUF2341 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 168 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27127614 | 27127614 | PRJEB28062_P_NODE_16622_length_931_cov_2.827506_g14698_i0 | PRJEB28062 | 16622 | 931 | 2.827506 | 26.32408086 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 538 | 7.85e-191 | NR | MFA5433203.1 | 2053589 | g14698 | i0 | 98.5 | 0.873254564983888 | 271 | 4 | 87.3 | 0 | 929 | 117 | 3 | 273 | MFA5433203.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 813 | 538 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29243789 | 29243789 | PRJEB28062_P_NODE_111429_length_282_cov_9.459330_g109066_i0 | PRJEB28062 | 111429 | 282 | 9.45933 | 26.6753106 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 145 | 4.75e-39 | NR | MFA5131709.1 | 2053589 | g109066 | i0 | 70.9 | 0.914893617021277 | 86 | 25 | 91.5 | 0 | 3 | 260 | 34 | 119 | MFA5131709.1 thrombospondin type 3 repeat-containing protein [Candidatus Paceibacterota bacterium] | diamond | 258 | 145 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29496325 | 29496325 | PRJEB28062_P_NODE_127870_length_245_cov_1.790698_g125506_i0 | PRJEB28062 | 127870 | 245 | 1.790698 | 4.3872101 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 125 | 3.829999999999999e-31 | NR | MBP6945901.1 | 2053589 | g125506 | i0 | 97.1 | 0.83265306122449 | 68 | 2 | 83.3 | 0 | 5 | 208 | 203 | 270 | MBP6945901.1 elongation factor G [Candidatus Paceibacterota bacterium] | diamond | 204 | 125 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30033354 | 30033354 | PRJEB28062_P_NODE_95571_length_328_cov_3.254902_g93209_i0 | PRJEB28062 | 95571 | 328 | 3.254902 | 10.67607856 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 71.2 | 2.16e-12 | NR | MBP7770745.1 | 2053589 | g93209 | i0 | 56.1 | 0.521341463414634 | 57 | 25 | 52.1 | 0 | 137 | 307 | 2 | 58 | MBP7770745.1 GNAT family N-acetyltransferase [Candidatus Paceibacterota bacterium] | diamond | 171 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31012640 | 31012640 | PRJEB28062_P_NODE_110455_length_285_cov_2.900943_g108092_i0 | PRJEB28062 | 110455 | 285 | 2.900943 | 8.26768755 | Candidatus Spechtbacterales bacterium | 3085100 | Bacteria | Bacteria | 152 | 1.4e-40 | NR | MEX2145101.1 | 3085100 | g108092 | i0 | 78.7 | 0.989473684210526 | 94 | 20 | 98.9 | 0 | 3 | 284 | 168 | 261 | MEX2145101.1 ATP cone domain-containing protein [Candidatus Spechtbacterales bacterium] | diamond | 282 | 152 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Candidatus Spechtbacterales | Candidatus Spechtbacterales bacterium | |||||
| 32087961 | 32087961 | PRJEB28062_P_NODE_69838_length_412_cov_3.053097_g67477_i0 | PRJEB28062 | 69838 | 412 | 3.053097 | 12.57875964 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 119 | 1.07e-29 | NR | MBP6868848.1 | 2053589 | g67477 | i0 | 65.4 | 0.589805825242718 | 81 | 28 | 59 | 0 | 263 | 21 | 28 | 108 | MBP6868848.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 243 | 119 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32814437 | 32814437 | PRJEB28062_P_NODE_27020_length_714_cov_21.093604_g24765_i0 | PRJEB28062 | 27020 | 714 | 21.093604 | 150.60833256 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 117 | 3.62e-29 | NR | MEX0597809.1 | 2053589 | g24765 | i0 | 65.1 | 0.348739495798319 | 83 | 29 | 34.9 | 0 | 176 | 424 | 70 | 152 | MEX0597809.1 macro domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 249 | 117 | 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);;