contig_metadata
10 rows where bioproject = "PRJNA758398", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10943634 | 10943634 | PRJNA758398_S_NODE_15329_length_253_cov_2.044118_g15188_i0 | PRJNA758398 | 15329 | 253 | 2.044118 | 5.17161854 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 142 | 1.89e-41 | NR | MDR3570669.1 | 2053589 | g15188 | i0 | 92.3 | 0.924901185770751 | 78 | 6 | 92.5 | 0 | 251 | 18 | 36 | 113 | MDR3570669.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 234 | 142 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 12219709 | 12219709 | PRJNA758398_S_NODE_8130_length_338_cov_1.698962_g7989_i0 | PRJNA758398 | 8130 | 338 | 1.698962 | 5.74249156 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 117 | 1.8099999999999999e-31 | NR | MDR3570671.1 | 2053589 | g7989 | i0 | 72.2 | 0.798816568047337 | 90 | 21 | 76.3 | 2 | 263 | 6 | 1 | 90 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 270 | 117 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 19866689 | 19866689 | PRJNA758398_S_NODE_34576_length_182_cov_1.857143_g34435_i0 | PRJNA758398 | 34576 | 182 | 1.857143 | 3.38000026 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 91.7 | 4.11e-22 | NR | MDR3570670.1 | 2053589 | g34435 | i0 | 87 | 1.84615384615385 | 54 | 5 | 85.7 | 1 | 156 | 1 | 6 | 59 | MDR3570670.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 336 | 91.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26736124 | 26736124 | PRJNA758398_S_NODE_34261_length_183_cov_1.514925_g34120_i0 | PRJNA758398 | 34261 | 183 | 1.514925 | 2.77231275 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 42.7 | 0.0155 | NR | HXK39761.1 | 2053589 | g34120 | i0 | 41.1 | 0.918032786885246 | 56 | 32 | 90.2 | 1 | 169 | 5 | 178 | 233 | HXK39761.1 META domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 168 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26989534 | 26989534 | PRJNA758398_S_NODE_28102_length_199_cov_1.360000_g27961_i0 | PRJNA758398 | 28102 | 199 | 1.36 | 2.7064 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 74.7 | 1.05e-13 | NR | MDR3570663.1 | 2053589 | g27961 | i0 | 56.3 | 1.92964824120603 | 64 | 26 | 96.5 | 1 | 6 | 197 | 362 | 423 | MDR3570663.1 beta-Ala-His dipeptidase [Candidatus Paceibacterota bacterium] | diamond | 384 | 74.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27811358 | 27811358 | PRJNA758398_S_NODE_15704_length_251_cov_1.262376_g15563_i0 | PRJNA758398 | 15704 | 251 | 1.262376 | 3.16856376 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 80.1 | 2.69e-15 | NR | MEX0598393.1 | 2053589 | g15563 | i0 | 62.9 | 1.49402390438247 | 62 | 23 | 74.1 | 0 | 208 | 23 | 4 | 65 | MEX0598393.1 UvrD-helicase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 375 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28474306 | 28474306 | PRJNA758398_S_NODE_9266_length_317_cov_1.794776_g9125_i0 | PRJNA758398 | 9266 | 317 | 1.794776 | 5.68943992 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 59.7 | 3.94e-8 | NR | MDR3549290.1 | 2053589 | g9125 | i0 | 55.8 | 0.842271293375394 | 43 | 19 | 40.7 | 0 | 159 | 287 | 11 | 53 | MDR3549290.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 267 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31001026 | 31001026 | PRJNA758398_S_NODE_36714_length_178_cov_1.023256_g36573_i0 | PRJNA758398 | 36714 | 178 | 1.023256 | 1.82139568 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.9 | 2.58e-9 | NR | MDR3570671.1 | 2053589 | g36573 | i0 | 54 | 0.842696629213483 | 50 | 23 | 84.3 | 0 | 16 | 165 | 12 | 61 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 150 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32171273 | 32171273 | PRJNA758398_S_NODE_16278_length_247_cov_1.287879_g16137_i0 | PRJNA758398 | 16278 | 247 | 1.287879 | 3.18106113 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 66.2 | 2.55e-12 | NR | HRH31009.1 | 2053589 | g16137 | i0 | 64.6 | 0.582995951417004 | 48 | 17 | 58.3 | 0 | 245 | 102 | 18 | 65 | HRH31009.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 144 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32392551 | 32392551 | PRJNA758398_S_NODE_1399_length_761_cov_8.341292_g1292_i0 | PRJNA758398 | 1399 | 761 | 8.341292 | 63.47723212 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 78.6 | 8.07e-15 | NR | MDR3572201.1 | 2053589 | g1292 | i0 | 80.9 | 0.185282522996058 | 47 | 9 | 18.5 | 0 | 710 | 570 | 42 | 88 | MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 141 | 78.6 | 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);;