contig_metadata
4 rows where bioproject = "PRJNA352850", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13148414 | 13148414 | PRJNA352850_P_NODE_14111_length_838_cov_4.353612_g11542_i0 | PRJNA352850 | 14111 | 838 | 4.353612 | 36.48326856 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 375 | 2.03e-126 | NR | MDQ2731611.1 | 2033014 | g11542 | i0 | 59.9 | 1.97255369928401 | 277 | 111 | 99.2 | 0 | 838 | 8 | 86 | 362 | MDQ2731611.1 glycoside hydrolase family 27 protein [Armatimonadota bacterium] | diamond | 1653 | 375 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26790088 | 26790088 | PRJNA352850_P_NODE_38761_length_408_cov_2.805014_g35929_i0 | PRJNA352850 | 38761 | 408 | 2.805014 | 11.44445712 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 122 | 8.3e-30 | NR | MFQ6098154.1 | 2033014 | g35929 | i0 | 68 | 1.10294117647059 | 75 | 24 | 55.1 | 0 | 233 | 9 | 28 | 102 | MFQ6098154.1 PKD domain-containing protein [Armatimonadota bacterium] | diamond | 450 | 122 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27770013 | 27770013 | PRJNA352850_P_NODE_10584_length_1037_cov_6.414980_g8253_i0 | PRJNA352850 | 10584 | 1037 | 6.41498 | 66.5233426 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 112 | 4.569999999999999e-23 | NR | MDQ2730579.1 | 2033014 | g8253 | i0 | 35.7 | 0.616200578592093 | 213 | 132 | 61.3 | 4 | 1036 | 401 | 460 | 668 | MDQ2730579.1 hypothetical protein [Armatimonadota bacterium] | diamond | 639 | 112 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29821845 | 29821845 | PRJNA352850_P_NODE_86371_length_230_cov_2.209945_g83538_i0 | PRJNA352850 | 86371 | 230 | 2.209945 | 5.0828735 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 144 | 1.13e-40 | NR | MDQ3812905.1 | 2033014 | g83538 | i0 | 93.4 | 6.86086956521739 | 76 | 5 | 99.1 | 0 | 228 | 1 | 125 | 200 | MDQ3812905.1 sigma-70 family RNA polymerase sigma factor [Armatimonadota bacterium] | diamond | 1578 | 144 | 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);;