contig_metadata
15 rows where bioproject = "PRJNA721440" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12189443 | 12189443 | PRJNA721440_S_NODE_13570_length_183_cov_1.261194_g13444_i0 | PRJNA721440 | 13570 | 183 | 1.261194 | 2.30798502 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 95.1 | 2.35e-21 | NR | MDX1520436.1 | 2052143 | g13444 | i0 | 84.8 | 20.016393442623 | 46 | 7 | 75.4 | 0 | 4 | 141 | 184 | 229 | MDX1520436.1 insulinase family protein [Anaerolineae bacterium] | diamond | 3663 | 95.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 12189457 | 12189457 | PRJNA721440_S_NODE_2010_length_389_cov_3.232353_g1884_i0 | PRJNA721440 | 2010 | 389 | 3.232353 | 12.57385317 | Caldilineae bacterium | 2420332 | Bacteria | Bacteria | 134 | 9.8e-34 | NR | RME54174.1 | 2420332 | g1884 | i0 | 57.4 | 2.96915167095116 | 129 | 55 | 99.5 | 0 | 388 | 2 | 146 | 274 | RME54174.1 MAG: sodium-translocating pyrophosphatase, partial [Caldilineae bacterium] | diamond | 1155 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineae bacterium | |||||
| 19837057 | 19837057 | PRJNA721440_S_NODE_10576_length_201_cov_1.026316_g10450_i0 | PRJNA721440 | 10576 | 201 | 1.026316 | 2.06289516 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 84 | 3.86e-18 | NR | HHB90088.1 | 2052143 | g10450 | i0 | 61.5 | 3.91044776119403 | 65 | 24 | 97 | 1 | 197 | 3 | 53 | 116 | HHB90088.1 translation elongation factor Ts [Anaerolineae bacterium] | diamond | 786 | 84 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 26682549 | 26682549 | PRJNA721440_S_NODE_22261_length_150_cov_8.029703_g22135_i0 | PRJNA721440 | 22261 | 150 | 8.029703 | 12.0445545 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 8.11e-5 | NR | MDY7040159.1 | 2026724 | g22135 | i0 | 54.8 | 2.56 | 42 | 18 | 82 | 1 | 14 | 136 | 128 | 169 | MDY7040159.1 DUF5519 family protein [Chloroflexota bacterium] | diamond | 384 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27431563 | 27431563 | PRJNA721440_S_NODE_15503_length_174_cov_2.200000_g15377_i0 | PRJNA721440 | 15503 | 174 | 2.2 | 3.828 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.4 | 0.00151 | NR | MCI0439151.1 | 2026724 | g15377 | i0 | 53.8 | 0.672413793103448 | 39 | 18 | 67.2 | 0 | 47 | 163 | 2 | 40 | MCI0439151.1 NUDIX domain-containing protein [Chloroflexota bacterium] | diamond | 117 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28157765 | 28157765 | PRJNA721440_S_NODE_4725_length_272_cov_2.690583_g4599_i0 | PRJNA721440 | 4725 | 272 | 2.690583 | 7.31838576 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 43.1 | 0.0354 | NR | MBF8267512.1 | 2026734 | g4599 | i0 | 35.8 | 0.738970588235294 | 67 | 39 | 69.5 | 2 | 57 | 245 | 224 | 290 | MBF8267512.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 201 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29136577 | 29136577 | PRJNA721440_S_NODE_8689_length_215_cov_2.807229_g8563_i0 | PRJNA721440 | 8689 | 215 | 2.807229 | 6.03554235 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 53.1 | 5.56e-6 | NR | HND47414.1 | 2073117 | g8563 | i0 | 35.7 | 0.976744186046512 | 70 | 43 | 94.9 | 2 | 213 | 10 | 739 | 808 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 210 | 53.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29609559 | 29609559 | PRJNA721440_S_NODE_12530_length_188_cov_3.503597_g12404_i0 | PRJNA721440 | 12530 | 188 | 3.503597 | 6.58676236 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 65.1 | 1.56e-10 | NR | MBC7811795.1 | 2052143 | g12404 | i0 | 56.7 | 2.77659574468085 | 60 | 25 | 95.7 | 1 | 182 | 3 | 13 | 71 | MBC7811795.1 lysophospholipase [Anaerolineae bacterium] | diamond | 522 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29767645 | 29767645 | PRJNA721440_S_NODE_13071_length_185_cov_3.544118_g12945_i0 | PRJNA721440 | 13071 | 185 | 3.544118 | 6.5566183 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 61.2 | 2.85e-9 | NR | MBM4434004.1 | 2026724 | g12945 | i0 | 67.5 | 4.39459459459459 | 40 | 13 | 64.9 | 0 | 128 | 9 | 36 | 75 | MBM4434004.1 putative 4-mercaptohistidine N1-methyltransferase [Chloroflexota bacterium] | diamond | 813 | 61.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30778795 | 30778795 | PRJNA721440_S_NODE_11614_length_194_cov_1.731034_g11488_i0 | PRJNA721440 | 11614 | 194 | 1.731034 | 3.35820596 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.3 | 0.00562 | NR | PIE81201.1 | 2026724 | g11488 | i0 | 71.4 | 0.865979381443299 | 28 | 8 | 43.3 | 0 | 194 | 111 | 230 | 257 | PIE81201.1 MAG: peptidase S9 [Chloroflexota bacterium] | diamond | 168 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31442510 | 31442510 | PRJNA721440_S_NODE_3016_length_327_cov_3.050360_g2890_i0 | PRJNA721440 | 3016 | 327 | 3.05036 | 9.9746772 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 93.2 | 1.97e-19 | NR | HND47414.1 | 2073117 | g2890 | i0 | 47.1 | 0.935779816513762 | 102 | 50 | 89.9 | 1 | 319 | 26 | 543 | 644 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 306 | 93.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32011928 | 32011928 | PRJNA721440_S_NODE_2918_length_331_cov_3.843972_g2792_i0 | PRJNA721440 | 2918 | 331 | 3.843972 | 12.72354732 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 71.2 | 1.03e-11 | NR | HND47413.1 | 2073117 | g2792 | i0 | 36.9 | 0.933534743202417 | 103 | 64 | 92.4 | 1 | 307 | 2 | 151 | 253 | HND47413.1 Ty1/Copia family ribonuclease HI [Anaerolineales bacterium] | diamond | 309 | 71.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32328674 | 32328674 | PRJNA721440_S_NODE_3419_length_309_cov_1.396154_g3293_i0 | PRJNA721440 | 3419 | 309 | 1.396154 | 4.31411586 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 45.1 | 0.0126 | NR | HEX9269468.1 | 3047546 | g3293 | i0 | 33.7 | 0.980582524271845 | 101 | 50 | 91.3 | 3 | 295 | 14 | 876 | 966 | HEX9269468.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 303 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 32423268 | 32423268 | PRJNA721440_S_NODE_9219_length_210_cov_9.739130_g9093_i0 | PRJNA721440 | 9219 | 210 | 9.73913 | 20.452173 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 68.9 | 1.39e-11 | NR | HND47414.1 | 2073117 | g9093 | i0 | 53.6 | 0.985714285714286 | 69 | 32 | 98.6 | 0 | 3 | 209 | 652 | 720 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 207 | 68.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32770169 | 32770169 | PRJNA721440_S_NODE_9160_length_211_cov_1.802469_g9034_i0 | PRJNA721440 | 9160 | 211 | 1.802469 | 3.80320959 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 46.6 | 0.0011 | NR | HND47414.1 | 2073117 | g9034 | i0 | 40.7 | 0.838862559241706 | 59 | 33 | 82.5 | 2 | 208 | 35 | 147 | 204 | HND47414.1 hypothetical protein [Anaerolineales bacterium] | diamond | 177 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales 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);;