contig_metadata
7 rows where bioproject = "PRJNA799842", tax_clade = "FCB group" and tax_phylum = "Candidatus Hydrogenedentota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27275348 | 27275348 | PRJNA799842_P_NODE_183803_length_242_cov_0.911243_g182230_i0 | PRJNA799842 | 183803 | 242 | 0.911243 | 2.20520806 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 74.3 | 2.74e-13 | NR | HRI87723.1 | 2030809 | g182230 | i0 | 45.7 | 3.47107438016529 | 70 | 37 | 86.8 | 1 | 11 | 220 | 505 | 573 | HRI87723.1 glycosyltransferase family 39 protein [Candidatus Hydrogenedentota bacterium] | diamond | 840 | 74.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 27717838 | 27717838 | PRJNA799842_P_NODE_172984_length_244_cov_0.900585_g171411_i0 | PRJNA799842 | 172984 | 244 | 0.900585 | 2.1974274 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 75.9 | 1.61e-15 | NR | HOV76326.1 | 2030809 | g171411 | i0 | 90.7 | 0.528688524590164 | 43 | 4 | 52.9 | 0 | 78 | 206 | 1 | 43 | HOV76326.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 129 | 75.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 28506793 | 28506793 | PRJNA799842_P_NODE_120487_length_267_cov_1.144330_g118914_i0 | PRJNA799842 | 120487 | 267 | 1.14433 | 3.0553611 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 135 | 2.38e-39 | NR | HOV76325.1 | 2030809 | g118914 | i0 | 84.2 | 0.853932584269663 | 76 | 12 | 85.4 | 0 | 229 | 2 | 1 | 76 | HOV76325.1 D-alanyl-D-alanine carboxypeptidase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 228 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 29453636 | 29453636 | PRJNA799842_P_NODE_155870_length_247_cov_0.885057_g154297_i0 | PRJNA799842 | 155870 | 247 | 0.885057 | 2.18609079 | Candidatus Abyssobacteria bacterium SURF_5 | 2093360 | Bacteria | Bacteria | 63.9 | 7.63e-11 | NR | RJP22240.1 | 2093360 | g154297 | i0 | 68.9 | 0.546558704453441 | 45 | 14 | 54.7 | 0 | 12 | 146 | 74 | 118 | RJP22240.1 MAG: hypothetical protein C4520_08565 [Candidatus Abyssobacteria bacterium SURF_5] | diamond | 135 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Abyssobacteria | Candidatus Abyssobacteria bacterium SURF_5 | ||||
| 29643104 | 29643104 | PRJNA799842_P_NODE_157150_length_247_cov_0.885057_g155577_i0 | PRJNA799842 | 157150 | 247 | 0.885057 | 2.18609079 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 81.3 | 9.83e-16 | NR | RMH29754.1 | 2030809 | g155577 | i0 | 57.8 | 0.777327935222672 | 64 | 27 | 77.7 | 0 | 54 | 245 | 46 | 109 | RMH29754.1 MAG: insulinase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 192 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 30631574 | 30631574 | PRJNA799842_P_NODE_146133_length_249_cov_0.875000_g144560_i0 | PRJNA799842 | 146133 | 249 | 0.875 | 2.17875 | FCB group | 1783270 | Bacteria | Bacteria | 46.6 | 0.0017 | NR | MBL7646584.1 | 2030809 | g144560 | i0 | 70.4 | 0.698795180722892 | 27 | 8 | 32.5 | 0 | 244 | 164 | 462 | 488 | MBL7646584.1 ADP-ribosylglycohydrolase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 174 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 31222848 | 31222848 | PRJNA799842_P_NODE_143335_length_250_cov_0.870056_g141762_i0 | PRJNA799842 | 143335 | 250 | 0.870056 | 2.17514 | Candidatus Abyssobacteria bacterium SURF_17 | 2093361 | Bacteria | Bacteria | 90.5 | 6.21e-19 | NR | RJP70535.1 | 2093361 | g141762 | i0 | 54.7 | 0.9 | 75 | 34 | 90 | 0 | 3 | 227 | 562 | 636 | RJP70535.1 MAG: hypothetical protein C4532_09165 [Candidatus Abyssobacteria bacterium SURF_17] | diamond | 225 | 90.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Abyssobacteria | Candidatus Abyssobacteria bacterium SURF_17 |
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);;