contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26714149 | 26714149 | PRJNA743294_P_NODE_49881_length_249_cov_0.886364_g49425_i0 | PRJNA743294 | 49881 | 249 | 0.886364 | 2.20704636 | Bacteria | 2 | Bacteria | Bacteria | 55.1 | 1.83e-6 | NR | MDR3692587.1 | 1936159 | g49425 | i0 | 44.9 | 1.87951807228916 | 78 | 39 | 92.8 | 3 | 249 | 19 | 221 | 295 | MDR3692587.1 ankyrin repeat domain-containing protein [Fimbriimonas sp.] | diamond | 468 | 55.1 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 26735657 | 26735657 | PRJNA743294_P_NODE_16901_length_392_cov_2.081505_g16445_i0 | PRJNA743294 | 16901 | 392 | 2.081505 | 8.1594996 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 61.6 | 1.58e-8 | NR | HTE17486.1 | 2033014 | g16445 | i0 | 32.3 | 2.51785714285714 | 124 | 78 | 94.1 | 3 | 20 | 388 | 83 | 201 | HTE17486.1 hypothetical protein [Armatimonadota bacterium] | diamond | 987 | 61.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27084294 | 27084294 | PRJNA743294_P_NODE_34482_length_286_cov_2.051643_g34026_i0 | PRJNA743294 | 34482 | 286 | 2.051643 | 5.86769898 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 75.9 | 1.95e-14 | NR | MFM9872807.1 | 2682144 | g34026 | i0 | 43 | 0.828671328671329 | 79 | 45 | 82.9 | 0 | 237 | 1 | 111 | 189 | MFM9872807.1 carbonate dehydratase [Fimbriimonadaceae bacterium] | diamond | 237 | 75.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 27905219 | 27905219 | PRJNA743294_P_NODE_43125_length_260_cov_2.347594_g42669_i0 | PRJNA743294 | 43125 | 260 | 2.347594 | 6.1037444 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 88.2 | 3.83e-18 | NR | MEI7986864.1 | 2033014 | g42669 | i0 | 58.6 | 3.25384615384615 | 70 | 29 | 80.8 | 0 | 2 | 211 | 288 | 357 | MEI7986864.1 phosphodiester glycosidase family protein [Armatimonadota bacterium] | diamond | 846 | 88.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29294712 | 29294712 | PRJNA743294_P_NODE_48269_length_251_cov_0.876404_g47813_i0 | PRJNA743294 | 48269 | 251 | 0.876404 | 2.19977404 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 75.5 | 9.75e-14 | NR | MCL6534642.1 | 2033014 | g47813 | i0 | 42.2 | 0.99203187250996006 | 83 | 43 | 99.2 | 2 | 251 | 3 | 75 | 152 | MCL6534642.1 alpha/beta hydrolase [Armatimonadota bacterium] | diamond | 249 | 75.5 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30147096 | 30147096 | PRJNA743294_P_NODE_26692_length_320_cov_1.263158_g26236_i0 | PRJNA743294 | 26692 | 320 | 1.263158 | 4.0421056 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 89.7 | 2.57e-18 | NR | MCE9558308.1 | 2033014 | g26236 | i0 | 46.7 | 1.8375 | 105 | 49 | 98.4 | 2 | 315 | 1 | 242 | 339 | MCE9558308.1 vanadium-dependent haloperoxidase [Armatimonadota bacterium] | diamond | 588 | 89.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30557959 | 30557959 | PRJNA743294_P_NODE_49113_length_250_cov_0.881356_g48657_i0 | PRJNA743294 | 49113 | 250 | 0.881356 | 2.20339 | Fimbriimonadales bacterium | 2682145 | Bacteria | Bacteria | 69.7 | 1.3e-11 | NR | MEJ5294576.1 | 2682145 | g48657 | i0 | 85 | 0.48 | 40 | 6 | 48 | 0 | 249 | 130 | 180 | 219 | MEJ5294576.1 hypothetical protein [Fimbriimonadales bacterium] | diamond | 120 | 69.7 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadales bacterium | ||||
| 31284844 | 31284844 | PRJNA743294_P_NODE_48315_length_251_cov_0.876404_g47859_i0 | PRJNA743294 | 48315 | 251 | 0.876404 | 2.19977404 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 47 | 3.02e-4 | NR | HEY3378629.1 | 2033014 | g47859 | i0 | 60 | 0.418326693227092 | 35 | 14 | 41.8 | 0 | 250 | 146 | 55 | 89 | HEY3378629.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium] | diamond | 105 | 47 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32644587 | 32644587 | PRJNA743294_P_NODE_42860_length_261_cov_1.601064_g42404_i0 | PRJNA743294 | 42860 | 261 | 1.601064 | 4.17877704 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 90.9 | 5.54e-19 | NR | HIE50768.1 | 2033014 | g42404 | i0 | 45.9 | 5.18390804597701 | 85 | 43 | 94.3 | 1 | 261 | 16 | 351 | 435 | HIE50768.1 glycoside hydrolase family 2 protein [Armatimonadota bacterium] | diamond | 1353 | 90.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;