contig_metadata
13 rows where bioproject = "PRJNA556992", tax_kingdom = "Bacillati" and tax_phylum = "Candidatus Dormiibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 532051 | 532051 | PRJNA556992_P_NODE_710481_length_250_cov_4.745763_g708292_i0 | PRJNA556992 | 710481 | 250 | 4.745763 | 11.8644075 | Bacillati | 1783272 | Bacteria | Bacteria | 114 | 2.2000000000000004e-28 | NR | MDP9247345.1 | 2052315 | g708292 | i0 | 70.4 | 4.932 | 81 | 24 | 97.2 | 0 | 1 | 243 | 254 | 334 | MDP9247345.1 ATP-binding cassette domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 1233 | 115 | 0.991304347826087 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 23486247 | 23486247 | PRJNA556992_P_NODE_845719_length_243_cov_4.094118_g843529_i0 | PRJNA556992 | 845719 | 243 | 4.094118 | 9.94870674 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 60.2 | 1.31e-4 | NTclustered | gi|2874254030|emb|OY970355.1| | 2052315 | g843529 | i0 | 97.222 | 0.148148148148148 | 36 | 0 | 15 | 1 | 124 | 159 | 1530166 | 1530132 | MAG: Candidatus Dormibacteraeota bacterium isolate MFD10064.bin.c.1 genome assembly, chromosome: 1 | blastn | 36 | 60.2 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 26920653 | 26920653 | PRJNA556992_P_NODE_988102_length_231_cov_10.487342_g985912_i0 | PRJNA556992 | 988102 | 231 | 10.487342 | 24.22576002 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 60.5 | 1.71e-8 | NR | HLB77023.1 | 2052315 | g985912 | i0 | 49.3 | 0.896103896103896 | 69 | 33 | 87 | 1 | 29 | 229 | 175 | 243 | HLB77023.1 phosphotransferase [Candidatus Dormiibacterota bacterium] | diamond | 207 | 60.5 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 27426474 | 27426474 | PRJNA556992_P_NODE_573603_length_261_cov_1.638298_g571414_i0 | PRJNA556992 | 573603 | 261 | 1.638298 | 4.27595778 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 69.7 | 1.89e-12 | NR | HXJ75034.1 | 2052315 | g571414 | i0 | 45.3 | 0.988505747126437 | 86 | 41 | 97.7 | 2 | 256 | 2 | 51 | 131 | HXJ75034.1 DUF1559 domain-containing protein [Candidatus Dormiibacterota bacterium] | diamond | 258 | 69.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 27426572 | 27426572 | PRJNA556992_P_NODE_753443_length_248_cov_2.697143_g751254_i0 | PRJNA556992 | 753443 | 248 | 2.697143 | 6.68891464 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 43.1 | 0.0273 | NR | HYM53195.1 | 2052315 | g751254 | i0 | 36.2 | 0.834677419354839 | 69 | 44 | 83.5 | 0 | 10 | 216 | 57 | 125 | HYM53195.1 methionyl-tRNA formyltransferase [Candidatus Dormiibacterota bacterium] | diamond | 207 | 43.1 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 27725093 | 27725093 | PRJNA556992_P_NODE_903684_length_240_cov_4.215569_g901494_i0 | PRJNA556992 | 903684 | 240 | 4.215569 | 10.1173656 | PVC group | 1783257 | Bacteria | Bacteria | 86.7 | 1.26e-17 | NR | HXJ73401.1 | 2052315 | g901494 | i0 | 48.8 | 2 | 80 | 41 | 100 | 0 | 240 | 1 | 489 | 568 | HXJ73401.1 PAS domain S-box protein [Candidatus Dormiibacterota bacterium] | diamond | 480 | 86.7 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 27805470 | 27805470 | PRJNA556992_P_NODE_892384_length_241_cov_1.791667_g890194_i0 | PRJNA556992 | 892384 | 241 | 1.791667 | 4.31791747 | Candidatus Dormibacter sp. | 2973982 | Bacteria | Bacteria | 73.6 | 9.49e-14 | NR | MEO8899619.1 | 2973982 | g890194 | i0 | 51.4 | 3.64730290456432 | 72 | 35 | 89.6 | 0 | 21 | 236 | 46 | 117 | MEO8899619.1 response regulator transcription factor [Candidatus Dormibacter sp.] | diamond | 879 | 73.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormibacteria | Candidatus Dormibacterales | Candidatus Dormibacteraceae | Candidatus Dormiibacter | Candidatus Dormibacter sp. | ||
| 28071943 | 28071943 | PRJNA556992_P_NODE_594745_length_259_cov_2.564516_g592556_i0 | PRJNA556992 | 594745 | 259 | 2.564516 | 6.64209644 | Bacillati | 1783272 | Bacteria | Bacteria | 171 | 2.54e-50 | NR | HWN03667.1 | 2052315 | g592556 | i0 | 93 | 3.98455598455598 | 86 | 6 | 99.6 | 0 | 258 | 1 | 227 | 312 | HWN03667.1 LLM class flavin-dependent oxidoreductase [Candidatus Dormiibacterota bacterium] | diamond | 1032 | 171 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29257279 | 29257279 | PRJNA556992_P_NODE_501989_length_267_cov_1.788660_g499800_i0 | PRJNA556992 | 501989 | 267 | 1.78866 | 4.7757222 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 46.6 | 0.00212 | NR | HXP68359.1 | 2052315 | g499800 | i0 | 36.5 | 0.831460674157303 | 74 | 46 | 82 | 1 | 5 | 223 | 367 | 440 | HXP68359.1 transcription termination factor NusA [Candidatus Dormiibacterota bacterium] | diamond | 222 | 46.6 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 29477904 | 29477904 | PRJNA556992_P_NODE_1033990_length_227_cov_2.681818_g1031800_i0 | PRJNA556992 | 1033990 | 227 | 2.681818 | 6.08772686 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 132 | 1.93e-37 | NR | HSQ00553.1 | 2052315 | g1031800 | i0 | 88 | 0.991189427312775 | 75 | 9 | 99.1 | 0 | 1 | 225 | 71 | 145 | HSQ00553.1 hypothetical protein [Candidatus Dormiibacterota bacterium] | diamond | 225 | 132 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31721770 | 31721770 | PRJNA556992_P_NODE_1075637_length_218_cov_6.868966_g1073446_i0 | PRJNA556992 | 1075637 | 218 | 6.868966 | 14.97434588 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 85.1 | 2.57e-19 | NR | MBO0743934.1 | 2052315 | g1073446 | i0 | 66.7 | 2.79357798165138 | 69 | 23 | 95 | 0 | 208 | 2 | 1 | 69 | MBO0743934.1 DUF5615 family PIN-like protein [Candidatus Dormiibacterota bacterium] | diamond | 609 | 85.1 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 31943443 | 31943443 | PRJNA556992_P_NODE_740637_length_249_cov_1.454545_g738448_i0 | PRJNA556992 | 740637 | 249 | 1.454545 | 3.62181705 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 54.3 | 2.87e-6 | NR | HEY8736622.1 | 2052315 | g738448 | i0 | 36.8 | 0.91566265060241 | 76 | 46 | 90.4 | 2 | 248 | 24 | 36 | 110 | HEY8736622.1 ice-binding family protein [Candidatus Dormiibacterota bacterium] | diamond | 228 | 54.3 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota bacterium | ||||||
| 32292035 | 32292035 | PRJNA556992_P_NODE_678919_length_252_cov_4.324022_g676730_i0 | PRJNA556992 | 678919 | 252 | 4.324022 | 10.89653544 | Candidatus Dormiibacterota bacterium | 2052315 | Bacteria | Bacteria | 155 | 2.66e-44 | NR | HSU55198.1 | 2052315 | g676730 | i0 | 85.5 | 7.90476190476191 | 83 | 12 | 98.8 | 0 | 251 | 3 | 179 | 261 | HSU55198.1 ferrochelatase [Candidatus Dormiibacterota bacterium] | diamond | 1992 | 155 | 1 | Bacteria | Bacillati | Candidatus Dormiibacterota | Candidatus Dormiibacterota 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);;