contig_metadata
9 rows where bioproject = "PRJNA950981", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26645472 | 26645472 | PRJNA950981_P_NODE_3221_length_535_cov_1.181818_g3047_i0 | PRJNA950981 | 3221 | 535 | 1.181818 | 6.3227263 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 114 | 1.37e-25 | NR | MEZ0208986.1 | 2053589 | g3047 | i0 | 36.4 | 0.986915887850467 | 176 | 109 | 98.7 | 1 | 534 | 7 | 1313 | 1485 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 528 | 114 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26962113 | 26962113 | PRJNA950981_P_NODE_17122_length_252_cov_0.871508_g16946_i0 | PRJNA950981 | 17122 | 252 | 0.871508 | 2.19620016 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 59.7 | 2.41e-8 | NR | MEZ0208896.1 | 2053589 | g16946 | i0 | 43.9 | 0.976190476190476 | 82 | 43 | 97.6 | 2 | 250 | 5 | 131 | 209 | MEZ0208896.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 246 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27941681 | 27941681 | PRJNA950981_P_NODE_9065_length_335_cov_1.190840_g8889_i0 | PRJNA950981 | 9065 | 335 | 1.19084 | 3.989314 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 78.6 | 3.06e-14 | NR | MEZ0208986.1 | 2053589 | g8889 | i0 | 39.6 | 0.904477611940299 | 101 | 60 | 90.4 | 1 | 318 | 16 | 800 | 899 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 303 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28193977 | 28193977 | PRJNA950981_P_NODE_5286_length_423_cov_1.777143_g5110_i0 | PRJNA950981 | 5286 | 423 | 1.777143 | 7.51731489 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 90.9 | 4.25e-18 | NR | MEZ0208986.1 | 2053589 | g5110 | i0 | 40 | 0.815602836879433 | 115 | 69 | 81.6 | 0 | 418 | 74 | 1377 | 1491 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 345 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28762417 | 28762417 | PRJNA950981_P_NODE_20407_length_245_cov_0.877907_g20231_i0 | PRJNA950981 | 20407 | 245 | 0.877907 | 2.15087215 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 53.1 | 8.38e-6 | NR | MEZ0208986.1 | 2053589 | g20231 | i0 | 40 | 0.979591836734694 | 80 | 48 | 98 | 0 | 244 | 5 | 1243 | 1322 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 240 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28920200 | 28920200 | PRJNA950981_P_NODE_15568_length_261_cov_1.234043_g15392_i0 | PRJNA950981 | 15568 | 261 | 1.234043 | 3.22085223 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 54.3 | 3.98e-6 | NR | MEZ0208986.1 | 2053589 | g15392 | i0 | 43.3 | 1.03448275862069 | 90 | 41 | 97.7 | 3 | 260 | 6 | 1240 | 1324 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 270 | 54.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29425352 | 29425352 | PRJNA950981_P_NODE_19949_length_246_cov_0.901734_g19773_i0 | PRJNA950981 | 19949 | 246 | 0.901734 | 2.21826564 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67.8 | 5.86e-11 | NR | MEZ0208986.1 | 2053589 | g19773 | i0 | 45.6 | 0.963414634146341 | 79 | 42 | 96.3 | 1 | 2 | 238 | 1097 | 1174 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 237 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31131146 | 31131146 | PRJNA950981_P_NODE_7975_length_353_cov_1.114286_g7799_i0 | PRJNA950981 | 7975 | 353 | 1.114286 | 3.93342958 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 111 | 1.3e-25 | NR | MEZ0208986.1 | 2053589 | g7799 | i0 | 56 | 0.926345609065156 | 109 | 44 | 90.9 | 2 | 32 | 352 | 1273 | 1379 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 327 | 111 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32460119 | 32460119 | PRJNA950981_P_NODE_20919_length_243_cov_1.835294_g20743_i0 | PRJNA950981 | 20919 | 243 | 1.835294 | 4.45976442 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 62.4 | 4.63e-9 | NR | MEZ0208986.1 | 2053589 | g20743 | i0 | 35.1 | 0.950617283950617 | 77 | 50 | 95.1 | 0 | 240 | 10 | 950 | 1026 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 231 | 62.4 | 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);;