contig_metadata
8 rows where bioproject = "PRJNA758398", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9668237 | 9668237 | PRJNA758398_S_NODE_28888_length_197_cov_1.371622_g28747_i0 | PRJNA758398 | 28888 | 197 | 1.371622 | 2.70209534 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 78.6 | 4.8e-15 | NR | MBT3217340.1 | 2026760 | g28747 | i0 | 72.3 | 6.45685279187817 | 47 | 13 | 71.6 | 0 | 189 | 49 | 784 | 830 | MBT3217340.1 aminomethyl-transferring glycine dehydrogenase [Fidelibacterota bacterium] | diamond | 1272 | 78.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 27116064 | 27116064 | PRJNA758398_S_NODE_43142_length_167_cov_0.864407_g43001_i0 | PRJNA758398 | 43142 | 167 | 0.864407 | 1.44355969 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 53.1 | 2.83e-6 | NR | MBT5225108.1 | 2026760 | g43001 | i0 | 45.5 | 1.90419161676647 | 55 | 30 | 98.8 | 0 | 3 | 167 | 807 | 861 | MBT5225108.1 serine hydrolase [Fidelibacterota bacterium] | diamond | 318 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 29620162 | 29620162 | PRJNA758398_S_NODE_26590_length_203_cov_1.896104_g26449_i0 | PRJNA758398 | 26590 | 203 | 1.896104 | 3.84909112 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47 | 6.94e-4 | NR | MBA93970.1 | 2026760 | g26449 | i0 | 35.6 | 5.30541871921182 | 73 | 41 | 99 | 3 | 203 | 3 | 298 | 370 | MBA93970.1 succinate-semialdehyde dehydrogenase [Fidelibacterota bacterium] | diamond | 1077 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30147555 | 30147555 | PRJNA758398_S_NODE_20252_length_226_cov_1.440678_g20111_i0 | PRJNA758398 | 20252 | 226 | 1.440678 | 3.25593228 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 57 | 2.77e-7 | NR | MAL64867.1 | 2026760 | g20111 | i0 | 50.9 | 4.04867256637168 | 55 | 27 | 73 | 0 | 226 | 62 | 88 | 142 | MAL64867.1 3-deoxy-7-phosphoheptulonate synthase class II [Fidelibacterota bacterium] | diamond | 915 | 57 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30558347 | 30558347 | PRJNA758398_S_NODE_15633_length_251_cov_1.821782_g15492_i0 | PRJNA758398 | 15633 | 251 | 1.821782 | 4.57267282 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 97.8 | 3.2800000000000002e-22 | NR | MAJ45170.1 | 2026760 | g15492 | i0 | 60.6 | 0.848605577689243 | 71 | 28 | 84.9 | 0 | 38 | 250 | 5 | 75 | MAJ45170.1 DNA (cytosine-5-)-methyltransferase [Fidelibacterota bacterium] | diamond | 213 | 97.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30716454 | 30716454 | PRJNA758398_S_NODE_47214_length_164_cov_2.217391_g47073_i0 | PRJNA758398 | 47214 | 164 | 2.217391 | 3.63652124 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 55.1 | 5.63e-7 | NR | MCJ7802940.1 | 2026760 | g47073 | i0 | 51.9 | 0.98780487804878 | 54 | 26 | 98.8 | 0 | 163 | 2 | 236 | 289 | MCJ7802940.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Fidelibacterota bacterium] | diamond | 162 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31579917 | 31579917 | PRJNA758398_S_NODE_22376_length_217_cov_1.988095_g22235_i0 | PRJNA758398 | 22376 | 217 | 1.988095 | 4.31416615 | FCB group | 1783270 | Bacteria | Bacteria | 60.8 | 1.11e-8 | NR | MFL3004892.1 | 2026760 | g22235 | i0 | 50.9 | 5.10138248847926 | 55 | 26 | 76 | 1 | 202 | 38 | 296 | 349 | MFL3004892.1 penicillin acylase family protein [Fidelibacterota bacterium] | diamond | 1107 | 61.2 | 0.993464052287582 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32865659 | 32865659 | PRJNA758398_S_NODE_10900_length_294_cov_1.665306_g10759_i0 | PRJNA758398 | 10900 | 294 | 1.665306 | 4.89599964 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 45.8 | 0.00328 | NR | MBI87127.1 | 2026760 | g10759 | i0 | 81.8 | 0.73469387755102 | 22 | 4 | 22.4 | 0 | 291 | 226 | 156 | 177 | MBI87127.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Fidelibacterota bacterium] | diamond | 216 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota 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);;