contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA454503" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26949494 | 26949494 | PRJNA454503_P_NODE_71822_length_206_cov_0.896552_g71493_i0 | PRJNA454503 | 71822 | 206 | 0.896552 | 1.84689712 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 44.7 | 0.00459 | NR | MEK7331166.1 | 2212470 | g71493 | i0 | 45.5 | 0.961165048543689 | 66 | 28 | 94.7 | 2 | 196 | 2 | 230 | 288 | MEK7331166.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 198 | 44.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 27012802 | 27012802 | PRJNA454503_P_NODE_44842_length_221_cov_1.625000_g44513_i0 | PRJNA454503 | 44842 | 221 | 1.625 | 3.59125 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 154 | 2.05e-41 | NR | MBI1146900.1 | 2026720 | g44513 | i0 | 98.6 | 0.990950226244344 | 73 | 1 | 99.1 | 0 | 219 | 1 | 485 | 557 | MBI1146900.1 M1 family metallopeptidase [Candidatus Saccharibacteria bacterium] | diamond | 219 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27771304 | 27771304 | PRJNA454503_P_NODE_79224_length_204_cov_0.909091_g78895_i0 | PRJNA454503 | 79224 | 204 | 0.909091 | 1.85454564 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 42 | 0.0418 | NR | NPV13357.1 | 2052148 | g78895 | i0 | 38.5 | 0.764705882352941 | 52 | 30 | 73.5 | 1 | 182 | 33 | 279 | 330 | NPV13357.1 hypothetical protein [candidate division WOR-3 bacterium] | diamond | 156 | 42 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 28592124 | 28592124 | PRJNA454503_P_NODE_29227_length_240_cov_1.871508_g28898_i0 | PRJNA454503 | 29227 | 240 | 1.871508 | 4.4916192 | Candidatus Saccharibacteria bacterium GW2 | 1619071 | Bacteria | Bacteria | 114 | 2.11e-27 | NR | KKW03366.1 | 1619071 | g28898 | i0 | 70 | 2 | 80 | 24 | 100 | 0 | 240 | 1 | 30 | 109 | KKW03366.1 MAG: ATP-dependent metalloprotease FtsH [Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9] | diamond | 480 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9 | ||||||
| 28876148 | 28876148 | PRJNA454503_P_NODE_41228_length_225_cov_1.756098_g40899_i0 | PRJNA454503 | 41228 | 225 | 1.756098 | 3.9512205 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 122 | 7.479999999999999e-31 | NR | MBP9779874.1 | 2044595 | g40899 | i0 | 87.7 | 0.866666666666667 | 65 | 8 | 86.7 | 0 | 197 | 3 | 1 | 65 | MBP9779874.1 glycine--tRNA ligase [Candidatus Altimarinota bacterium] | diamond | 195 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28939476 | 28939476 | PRJNA454503_P_NODE_66888_length_207_cov_1.780822_g66559_i0 | PRJNA454503 | 66888 | 207 | 1.780822 | 3.68630154 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 120 | 6.28e-30 | NR | MBB1531810.1 | 2026720 | g66559 | i0 | 91.3 | 2 | 69 | 6 | 100 | 0 | 1 | 207 | 56 | 124 | MBB1531810.1 PAS domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 414 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30771420 | 30771420 | PRJNA454503_P_NODE_9654_length_360_cov_1.334448_g9325_i0 | PRJNA454503 | 9654 | 360 | 1.334448 | 4.8040128 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 50.1 | 7.2e-5 | NR | MBN1151167.1 | 2052148 | g9325 | i0 | 47.4 | 0.316666666666667 | 38 | 20 | 31.7 | 0 | 308 | 195 | 36 | 73 | MBN1151167.1 cytochrome b5 domain-containing protein [candidate division WOR-3 bacterium] | diamond | 114 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 30834432 | 30834432 | PRJNA454503_P_NODE_69194_length_207_cov_0.890411_g68865_i0 | PRJNA454503 | 69194 | 207 | 0.890411 | 1.84315077 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 49.7 | 8.3e-5 | NR | HET9853444.1 | 2072417 | g68865 | i0 | 48.1 | 0.753623188405797 | 52 | 27 | 75.4 | 0 | 3 | 158 | 1181 | 1232 | HET9853444.1 GAF domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 156 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31149935 | 31149935 | PRJNA454503_P_NODE_29035_length_241_cov_1.000000_g28706_i0 | PRJNA454503 | 29035 | 241 | 1 | 2.41 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42.4 | 0.0487 | NR | HUC89337.1 | 2052139 | g28706 | i0 | 36.1 | 0.896265560165975 | 72 | 45 | 89.6 | 1 | 12 | 227 | 565 | 635 | HUC89337.1 type IV secretion system DNA-binding domain-containing protein [Patescibacteria group bacterium] | diamond | 216 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;