contig_metadata
11 rows where bioproject = "PRJNA1226487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18186529 | 18186529 | PRJNA1226487_P_NODE_54795_length_265_cov_1.604167_g54693_i0 | PRJNA1226487 | 54795 | 265 | 1.604167 | 4.25104255 | Bacteria | 2 | Bacteria | Bacteria | 139 | 7.16e-36 | NR | MBN9501973.1 | 2033014 | g54693 | i0 | 76.5 | 1.94716981132075 | 85 | 20 | 96.2 | 0 | 9 | 263 | 409 | 493 | MBN9501973.1 DNA mismatch repair protein MutS [Armatimonadota bacterium] | diamond | 516 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 20173139 | 20173139 | PRJNA1226487_P_NODE_52276_length_269_cov_1.571429_g52174_i0 | PRJNA1226487 | 52276 | 269 | 1.571429 | 4.22714401 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 108 | 1.71e-25 | NR | MEZ0325255.1 | 1936159 | g52174 | i0 | 96.2 | 1.72862453531599 | 52 | 2 | 58 | 0 | 268 | 113 | 455 | 506 | MEZ0325255.1 DUF1501 domain-containing protein [Fimbriimonas sp.] | diamond | 465 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 20736511 | 20736511 | PRJNA1226487_P_NODE_69597_length_247_cov_1.408046_g69495_i0 | PRJNA1226487 | 69597 | 247 | 1.408046 | 3.47787362 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 141 | 9.11e-37 | NR | HEY0868259.1 | 1936159 | g69495 | i0 | 83.8 | 3.88663967611336 | 80 | 13 | 97.2 | 0 | 240 | 1 | 509 | 588 | HEY0868259.1 aconitate hydratase AcnA [Fimbriimonas sp.] | diamond | 960 | 141 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 23287156 | 23287156 | PRJNA1226487_P_NODE_23159_length_344_cov_15.206642_g23057_i0 | PRJNA1226487 | 23159 | 344 | 15.206642 | 52.31084848 | Chthonomonas calidirosea | 454171 | Bacteria | Bacteria | 274 | 6.379999999999998e-69 | NTclustered | gi|510021827|emb|HF951689.1| | 1303518 | g23057 | i0 | 83.784 | 54.5901162790698 | 296 | 41 | 84 | 2 | 10 | 299 | 613631 | 613337 | Chthonomonas calidirosea T49 complete genome | blastn | 18779 | 274 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonas | Chthonomonas calidirosea | ||
| 29409475 | 29409475 | PRJNA1226487_P_NODE_45329_length_280_cov_1.487923_g45227_i0 | PRJNA1226487 | 45329 | 280 | 1.487923 | 4.1661844 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 132 | 6.529999999999999e-37 | NR | MBC8066233.1 | 2682144 | g45227 | i0 | 71.7 | 0.985714285714286 | 92 | 26 | 98.6 | 0 | 3 | 278 | 44 | 135 | MBC8066233.1 PEP-CTERM sorting domain-containing protein [Fimbriimonadaceae bacterium] | diamond | 276 | 132 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 29535848 | 29535848 | PRJNA1226487_P_NODE_69350_length_247_cov_1.770115_g69248_i0 | PRJNA1226487 | 69350 | 247 | 1.770115 | 4.37218405 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 108 | 3.52e-25 | NR | MBC8065250.1 | 2682144 | g69248 | i0 | 86.7 | 0.728744939271255 | 60 | 8 | 72.9 | 0 | 181 | 2 | 1 | 60 | MBC8065250.1 tetratricopeptide repeat protein [Fimbriimonadaceae bacterium] | diamond | 180 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30326049 | 30326049 | PRJNA1226487_P_NODE_52932_length_268_cov_1.579487_g52830_i0 | PRJNA1226487 | 52932 | 268 | 1.579487 | 4.23302516 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 154 | 2.74e-41 | NR | MBC8066000.1 | 2682144 | g52830 | i0 | 83.1 | 2.98880597014925 | 89 | 15 | 99.6 | 0 | 268 | 2 | 95 | 183 | MBC8066000.1 D-alanine--D-alanine ligase [Fimbriimonadaceae bacterium] | diamond | 801 | 154 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30926041 | 30926041 | PRJNA1226487_P_NODE_56134_length_263_cov_1.621053_g56032_i0 | PRJNA1226487 | 56134 | 263 | 1.621053 | 4.26336939 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 148 | 4.1e-39 | NR | MBC8064208.1 | 2682144 | g56032 | i0 | 85.1 | 0.992395437262357 | 87 | 13 | 99.2 | 0 | 262 | 2 | 334 | 420 | MBC8064208.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 261 | 148 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 31431561 | 31431561 | PRJNA1226487_P_NODE_47716_length_276_cov_1.517241_g47614_i0 | PRJNA1226487 | 47716 | 276 | 1.517241 | 4.18758516 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 45.1 | 0.00134 | NR | MCC2672968.1 | 2033014 | g47614 | i0 | 42.4 | 0.641304347826087 | 59 | 32 | 62 | 1 | 98 | 268 | 10 | 68 | MCC2672968.1 hypothetical protein [Armatimonadota bacterium] | diamond | 177 | 45.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31779372 | 31779372 | PRJNA1226487_P_NODE_67917_length_248_cov_1.760000_g67815_i0 | PRJNA1226487 | 67917 | 248 | 1.76 | 4.3648 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 78.2 | 1.31e-14 | NR | MCC7229389.1 | 2682144 | g67815 | i0 | 48.8 | 0.991935483870968 | 82 | 42 | 99.2 | 0 | 247 | 2 | 252 | 333 | MCC7229389.1 hypothetical protein [Fimbriimonadaceae bacterium] | diamond | 246 | 78.2 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 32380781 | 32380781 | PRJNA1226487_P_NODE_52279_length_269_cov_1.571429_g52177_i0 | PRJNA1226487 | 52279 | 269 | 1.571429 | 4.22714401 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 144 | 1.78e-38 | NR | HJP83832.1 | 2682144 | g52177 | i0 | 85.3 | 1.6728624535316 | 75 | 11 | 83.6 | 0 | 267 | 43 | 114 | 188 | HJP83832.1 M14 family metallopeptidase [Fimbriimonadaceae bacterium] | diamond | 450 | 144 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae 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);;