contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9705417 | 9705417 | PRJNA792582_P_NODE_53368_length_247_cov_1.465517_g52554_i0 | PRJNA792582 | 53368 | 247 | 1.465517 | 3.61982699 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 84.3 | 9.06e-17 | NR | HKA61253.1 | 2072417 | g52554 | i0 | 70.6 | 0.619433198380567 | 51 | 15 | 61.9 | 0 | 246 | 94 | 865 | 915 | HKA61253.1 ATP-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 153 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27464714 | 27464714 | PRJNA792582_P_NODE_22163_length_366_cov_1.266212_g21349_i0 | PRJNA792582 | 22163 | 366 | 1.266212 | 4.63433592 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 148 | 6.17e-41 | NR | HYF05772.1 | 2052139 | g21349 | i0 | 56.7 | 4 | 120 | 50 | 98.4 | 1 | 364 | 5 | 156 | 273 | HYF05772.1 chitinase [Patescibacteria group bacterium] | diamond | 1464 | 148 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28727581 | 28727581 | PRJNA792582_P_NODE_35007_length_291_cov_1.412844_g34193_i0 | PRJNA792582 | 35007 | 291 | 1.412844 | 4.11137604 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 43.9 | 0.00457 | NR | HRN86952.1 | 2099670 | g34193 | i0 | 50 | 0.43298969072165 | 42 | 21 | 43.3 | 0 | 259 | 134 | 47 | 88 | HRN86952.1 hypothetical protein [Candidatus Dojkabacteria bacterium] | diamond | 126 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 28916763 | 28916763 | PRJNA792582_P_NODE_53928_length_247_cov_0.885057_g53114_i0 | PRJNA792582 | 53928 | 247 | 0.885057 | 2.18609079 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 42.4 | 0.048 | NR | HEY3216751.1 | 2212470 | g53114 | i0 | 39.7 | 0.704453441295547 | 58 | 35 | 70.4 | 0 | 60 | 233 | 39 | 96 | HEY3216751.1 anti-sigma factor [Candidatus Eiseniibacteriota bacterium] | diamond | 174 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 29778603 | 29778603 | PRJNA792582_P_NODE_50811_length_250_cov_0.870056_g49997_i0 | PRJNA792582 | 50811 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 67.8 | 6.03e-11 | NR | MCL4419901.1 | 2052139 | g49997 | i0 | 62.3 | 1.476 | 69 | 23 | 82.8 | 1 | 250 | 44 | 173 | 238 | MCL4419901.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 369 | 67.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31001729 | 31001729 | PRJNA792582_P_NODE_44514_length_265_cov_2.656250_g43700_i0 | PRJNA792582 | 44514 | 265 | 2.65625 | 7.0390625 | Candidatus Harrisonbacteria bacterium CG1 | 2528272 | Bacteria | Bacteria | 42.7 | 0.0385 | NR | PIR86899.1 | 1974587 | g43700 | i0 | 34.7 | 0.815094339622642 | 72 | 41 | 74.7 | 1 | 219 | 22 | 29 | 100 | PIR86899.1 MAG: hypothetical protein COU11_03535 [Candidatus Harrisonbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_49_15] | diamond | 216 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Harrisoniibacteriota | Candidatus Harrisonbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_49_15 | ||||||
| 31349476 | 31349476 | PRJNA792582_P_NODE_51536_length_249_cov_1.346591_g50722_i0 | PRJNA792582 | 51536 | 249 | 1.346591 | 3.35301159 | Candidatus Saccharibacteria bacterium | 2026720 | Bacteria | Bacteria | 47 | 0.00124 | NR | PID32328.1 | 2026720 | g50722 | i0 | 37.5 | 0.674698795180723 | 56 | 35 | 67.5 | 0 | 9 | 176 | 239 | 294 | PID32328.1 MAG: hypothetical protein CR970_00990 [Candidatus Saccharibacteria bacterium] | diamond | 168 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;