contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1144090" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26806267 | 26806267 | PRJNA1144090_P_NODE_39701_length_409_cov_16.708333_g39166_i0 | PRJNA1144090 | 39701 | 409 | 16.708333 | 68.33708197 | Bacteria | 2 | Bacteria | Bacteria | 104 | 4.5e-26 | NR | MDB5169429.1 | 2026720 | g39166 | i0 | 55.4 | 6.62347188264059 | 83 | 37 | 60.9 | 0 | 291 | 43 | 5 | 87 | MDB5169429.1 rbpA [Candidatus Saccharibacteria bacterium] | diamond | 2709 | 105 | 0.990476190476191 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27291800 | 27291800 | PRJNA1144090_P_NODE_44423_length_385_cov_1.769231_g43888_i0 | PRJNA1144090 | 44423 | 385 | 1.769231 | 6.81153935 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 64.7 | 1.02e-9 | NR | HUD82748.1 | 2973664 | g43888 | i0 | 36.2 | 1.01298701298701 | 130 | 65 | 99.7 | 2 | 2 | 385 | 32 | 145 | HUD82748.1 WD40 repeat domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 390 | 64.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 28775778 | 28775778 | PRJNA1144090_P_NODE_72147_length_297_cov_3.897321_g71612_i0 | PRJNA1144090 | 72147 | 297 | 3.897321 | 11.57504337 | Candidatus Nanosynbacter sp. HMT-352 | 2899133 | Bacteria | Bacteria | 62.8 | 6.62e-9 | NR | WP_243777738.1 | 2899133 | g71612 | i0 | 43.3 | 0.909090909090909 | 90 | 46 | 88.9 | 3 | 270 | 7 | 340 | 426 | WP_243777738.1 RCC1 domain-containing protein [Candidatus Nanosynbacter sp. HMT-352] | diamond | 270 | 62.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Nanosynbacterales | Candidatus Nanosynbacteraceae | Candidatus Nanosynbacter | Candidatus Nanosynbacter sp. HMT-352 | ||
| 29375731 | 29375731 | PRJNA1144090_P_NODE_71369_length_299_cov_2.070796_g70834_i0 | PRJNA1144090 | 71369 | 299 | 2.070796 | 6.19168004 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 80.1 | 5.47e-15 | NR | HEY1085289.1 | 2973664 | g70834 | i0 | 41.9 | 0.862876254180602 | 86 | 46 | 82.3 | 2 | 21 | 266 | 504 | 589 | HEY1085289.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 258 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29533606 | 29533606 | PRJNA1144090_P_NODE_49570_length_362_cov_4.494810_g49035_i0 | PRJNA1144090 | 49570 | 362 | 4.49481 | 16.2712122 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 89.4 | 5.28e-18 | NR | HVS79003.1 | 2973664 | g49035 | i0 | 38.8 | 2.85082872928177 | 116 | 62 | 96.1 | 2 | 349 | 2 | 257 | 363 | HVS79003.1 glycine--tRNA ligase [Candidatus Saccharimonadales bacterium] | diamond | 1032 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30702416 | 30702416 | PRJNA1144090_P_NODE_85954_length_271_cov_2.272727_g85419_i0 | PRJNA1144090 | 85954 | 271 | 2.272727 | 6.15909017 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 44.3 | 0.00907 | NR | MBQ2638843.1 | 2026720 | g85419 | i0 | 35.3 | 0.940959409594096 | 85 | 43 | 93 | 4 | 257 | 6 | 85 | 158 | MBQ2638843.1 RsmD family RNA methyltransferase [Candidatus Saccharibacteria bacterium] | diamond | 255 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31840309 | 31840309 | PRJNA1144090_P_NODE_112937_length_243_cov_0.905882_g112402_i0 | PRJNA1144090 | 112937 | 243 | 0.905882 | 2.20129326 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 171 | 1.11e-50 | NR | MBB1562781.1 | 2026720 | g112402 | i0 | 98.8 | 2 | 81 | 1 | 100 | 0 | 1 | 243 | 67 | 147 | MBB1562781.1 glycine--tRNA ligase [Candidatus Saccharibacteria bacterium] | diamond | 486 | 171 | 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);;