contig_metadata
10 rows where 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 777050 | 777050 | PRJNA792582_P_NODE_49441_length_251_cov_1.730337_g48627_i0 | PRJNA792582 | 49441 | 251 | 1.730337 | 4.34314587 | Candidatus Ozemobacteraceae bacterium | 2818468 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2907625676|emb|OZ223236.1| | 2818468 | g48627 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 53 | 80 | 2192588 | 2192615 | MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Ozemobacteria | Candidatus Ozemobacteraceae | Candidatus Ozemobacteraceae bacterium | |||||
| 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 | ||||||
| 12256718 | 12256718 | PRJNA792582_P_NODE_52150_length_249_cov_0.875000_g51336_i0 | PRJNA792582 | 52150 | 249 | 0.875 | 2.17875 | Candidatus Saccharibacteria bacterium oral taxon 488 | 713059 | Bacteria | Bacteria | 449 | 6.840000000000001e-122 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g51336 | i0 | 99.197 | 147.18875502008 | 249 | 2 | 100 | 0 | 1 | 249 | 150804 | 150556 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 36650 | 449 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 16079631 | 16079631 | PRJNA792582_P_NODE_53073_length_248_cov_0.880000_g52259_i0 | PRJNA792582 | 53073 | 248 | 0.88 | 2.1824 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 324 | 4.31e-84 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g52259 | i0 | 92.478 | 79.4354838709677 | 226 | 17 | 91 | 0 | 3 | 228 | 814360 | 814135 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 19700 | 324 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria 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);;