contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Eiseniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26978096 | 26978096 | PRJNA1237347_P_NODE_298442_length_335_cov_1.454198_g291869_i0 | PRJNA1237347 | 298442 | 335 | 1.454198 | 4.8715633 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 98.2 | 3.9e-21 | NR | MBU1699851.1 | 2212470 | g291869 | i0 | 44.6 | 1.76417910447761 | 112 | 40 | 93.1 | 3 | 19 | 330 | 876 | 973 | MBU1699851.1 histidine kinase [Candidatus Eiseniibacteriota bacterium] | diamond | 591 | 98.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 27799765 | 27799765 | PRJNA1237347_P_NODE_305484_length_330_cov_1.782101_g298911_i0 | PRJNA1237347 | 305484 | 330 | 1.782101 | 5.8809333 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 75.1 | 4.54e-13 | NR | HEV8128297.1 | 2212470 | g298911 | i0 | 40.2 | 0.836363636363636 | 92 | 55 | 83.6 | 0 | 50 | 325 | 325 | 416 | HEV8128297.1 MASE1 domain-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 276 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 28607481 | 28607481 | PRJNA1237347_P_NODE_475967_length_251_cov_0.865169_g469394_i0 | PRJNA1237347 | 475967 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 70.5 | 7.16e-12 | NR | NOT34626.1 | 2212470 | g469394 | i0 | 48.7 | 4.75697211155379 | 76 | 35 | 90.8 | 1 | 17 | 244 | 1303 | 1374 | NOT34626.1 S8 family serine peptidase [Candidatus Eiseniibacteriota bacterium] | diamond | 1194 | 70.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 30673033 | 30673033 | PRJNA1237347_P_NODE_171813_length_479_cov_3.857143_g165243_i0 | PRJNA1237347 | 171813 | 479 | 3.857143 | 18.47571497 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 46.6 | 0.0167 | NR | HEU4334576.1 | 2212470 | g165243 | i0 | 33 | 0.64509394572025 | 103 | 56 | 57 | 3 | 284 | 12 | 85 | 186 | HEU4334576.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 309 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31843024 | 31843024 | PRJNA1237347_P_NODE_369917_length_293_cov_1.050000_g363344_i0 | PRJNA1237347 | 369917 | 293 | 1.05 | 3.0765 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 94 | 6.84e-20 | NR | HKQ58973.1 | 2212470 | g363344 | i0 | 54.8 | 0.860068259385666 | 84 | 37 | 85 | 1 | 271 | 23 | 45 | 128 | HKQ58973.1 T9SS type A sorting domain-containing protein [Candidatus Eiseniibacteriota bacterium] | diamond | 252 | 94 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32286208 | 32286208 | PRJNA1237347_P_NODE_179999_length_465_cov_1.344388_g173428_i0 | PRJNA1237347 | 179999 | 465 | 1.344388 | 6.2514042 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 92 | 9.43e-19 | NR | HET9950385.1 | 2212470 | g173428 | i0 | 35.9 | 2.94838709677419 | 153 | 90 | 98.7 | 3 | 463 | 5 | 115 | 259 | HET9950385.1 phosphate ABC transporter substrate-binding protein PstS [Candidatus Eiseniibacteriota bacterium] | diamond | 1371 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 32885709 | 32885709 | PRJNA1237347_P_NODE_468620_length_252_cov_1.318436_g462047_i0 | PRJNA1237347 | 468620 | 252 | 1.318436 | 3.32245872 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 108 | 3.95e-25 | NR | MCC6350133.1 | 2212470 | g462047 | i0 | 58.5 | 2.92857142857143 | 82 | 34 | 97.6 | 0 | 3 | 248 | 897 | 978 | MCC6350133.1 hypothetical protein [Candidatus Eiseniibacteriota bacterium] | diamond | 738 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota 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);;