contig_metadata
9 rows where bioproject = "PRJNA752278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24954841 | 24954841 | PRJNA752278_P_NODE_85620_length_248_cov_0.880000_g85417_i0 | PRJNA752278 | 85620 | 248 | 0.88 | 2.1824 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 161 | 2.44e-47 | NR | MBM3460133.1 | 2033014 | g85417 | i0 | 81.7 | 1.98387096774194 | 82 | 15 | 99.2 | 0 | 247 | 2 | 178 | 259 | MBM3460133.1 DUF1549 domain-containing protein [Armatimonadota bacterium] | diamond | 492 | 161 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26641255 | 26641255 | PRJNA752278_P_NODE_2541_length_749_cov_1.213018_g2353_i0 | PRJNA752278 | 2541 | 749 | 1.213018 | 9.08550482 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 55.8 | 6.3e-5 | NR | HLK59180.1 | 2739509 | g2353 | i0 | 42.9 | 0.700934579439252 | 70 | 40 | 28 | 0 | 662 | 453 | 162 | 231 | HLK59180.1 ankyrin repeat domain-containing protein [Chthonomonadaceae bacterium] | diamond | 525 | 55.8 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 27400612 | 27400612 | PRJNA752278_P_NODE_53783_length_273_cov_2.800000_g53580_i0 | PRJNA752278 | 53783 | 273 | 2.8 | 7.644 | Armatimonas sp. | 1872638 | Bacteria | Bacteria | 52.4 | 4.75e-6 | NR | WP_395088970.1 | 1872638 | g53580 | i0 | 65.1 | 0.472527472527473 | 43 | 15 | 47.3 | 0 | 129 | 1 | 1 | 43 | WP_395088970.1 helix-turn-helix domain-containing protein [Armatimonas sp.] | diamond | 129 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas sp. | ||
| 27558125 | 27558125 | PRJNA752278_P_NODE_2944_length_707_cov_1.611987_g2753_i0 | PRJNA752278 | 2944 | 707 | 1.611987 | 11.396748090000001 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 56.6 | 1.96e-6 | NR | HEY3378629.1 | 2033014 | g2753 | i0 | 45.9 | 0.258840169731259 | 61 | 33 | 25.9 | 0 | 638 | 456 | 25 | 85 | HEY3378629.1 ankyrin repeat domain-containing protein [Armatimonadota bacterium] | diamond | 183 | 56.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27600011 | 27600011 | PRJNA752278_P_NODE_7304_length_509_cov_2.674312_g7101_i0 | PRJNA752278 | 7304 | 509 | 2.674312 | 13.61224808 | Bacteria | 2 | Bacteria | Bacteria | 141 | 5.109999999999999e-40 | NR | WP_184192813.1 | 685828 | g7101 | i0 | 55.5 | 7.19056974459725 | 119 | 51 | 69 | 1 | 397 | 47 | 3 | 121 | WP_184192813.1 group I truncated hemoglobin [Armatimonas rosea] | diamond | 3660 | 142 | 0.992957746478873 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Armatimonadales | Armatimonadaceae | Armatimonas | Armatimonas rosea | ||
| 30337663 | 30337663 | PRJNA752278_P_NODE_79672_length_250_cov_1.740113_g79469_i0 | PRJNA752278 | 79672 | 250 | 1.740113 | 4.3502825 | Chthonomonadaceae bacterium | 2739509 | Bacteria | Bacteria | 50.8 | 3.41e-5 | NR | HLJ56773.1 | 2739509 | g79469 | i0 | 57.9 | 0.456 | 38 | 16 | 45.6 | 0 | 245 | 132 | 26 | 63 | HLJ56773.1 tetratricopeptide repeat protein [Chthonomonadaceae bacterium] | diamond | 114 | 50.8 | 1 | Bacteria | Bacillati | Armatimonadota | Chthonomonadia | Chthonomonadales | Chthonomonadaceae | Chthonomonadaceae bacterium | |||
| 30400860 | 30400860 | PRJNA752278_P_NODE_75473_length_253_cov_1.322222_g75270_i0 | PRJNA752278 | 75473 | 253 | 1.322222 | 3.34522166 | Fimbriimonas sp. | 1936159 | Bacteria | Bacteria | 43.9 | 0.0159 | NR | MDR3688675.1 | 1936159 | g75270 | i0 | 43.9 | 0.675889328063241 | 57 | 27 | 61.7 | 2 | 171 | 16 | 6 | 62 | MDR3688675.1 methylmalonyl Co-A mutase-associated GTPase MeaB [Fimbriimonas sp.] | diamond | 171 | 43.9 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas sp. | ||
| 30811097 | 30811097 | PRJNA752278_P_NODE_31574_length_304_cov_6.813853_g31371_i0 | PRJNA752278 | 31574 | 304 | 6.813853 | 20.71411312 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 78.2 | 9.66e-15 | NR | MCX6344657.1 | 2033014 | g31371 | i0 | 52 | 0.740131578947368 | 75 | 36 | 74 | 0 | 225 | 1 | 2 | 76 | MCX6344657.1 bifunctional methylenetetrahydrofolate dehydrogenase/methenyltetrahydrofolate cyclohydrolase FolD [Armatimonadota bacterium] | diamond | 225 | 78.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32202562 | 32202562 | PRJNA752278_P_NODE_84158_length_249_cov_0.875000_g83955_i0 | PRJNA752278 | 84158 | 249 | 0.875 | 2.17875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 52 | 2.24e-5 | NR | MEI6501742.1 | 2033014 | g83955 | i0 | 38.4 | 0.879518072289157 | 73 | 45 | 88 | 0 | 219 | 1 | 26 | 98 | MEI6501742.1 hypothetical protein [Armatimonadota bacterium] | diamond | 219 | 52 | 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);;