contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA796975" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27148280 | 27148280 | PRJNA796975_S_NODE_10702_length_166_cov_0.871795_g10625_i0 | PRJNA796975 | 10702 | 166 | 0.871795 | 1.4471797 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 102 | 5.31e-25 | NR | HEV7698630.1 | 2283092 | g10625 | i0 | 81.5 | 1.95180722891566 | 54 | 10 | 97.6 | 0 | 4 | 165 | 196 | 249 | HEV7698630.1 SGNH/GDSL hydrolase family protein [Pyrinomonadaceae bacterium] | diamond | 324 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27338474 | 27338474 | PRJNA796975_S_NODE_3503_length_237_cov_1.356383_g3426_i0 | PRJNA796975 | 3503 | 237 | 1.356383 | 3.21462771 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 144 | 7.37e-39 | NR | MEN6533728.1 | 2212468 | g3426 | i0 | 87.2 | 0.987341772151899 | 78 | 10 | 98.7 | 0 | 3 | 236 | 186 | 263 | MEN6533728.1 terminase family protein [Bryobacteraceae bacterium] | diamond | 234 | 144 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27843433 | 27843433 | PRJNA796975_S_NODE_12884_length_163_cov_1.342105_g12807_i0 | PRJNA796975 | 12884 | 163 | 1.342105 | 2.18763115 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 48.5 | 7.74e-5 | NR | HZT31021.1 | 2212468 | g12807 | i0 | 48.1 | 0.957055214723926 | 52 | 27 | 95.7 | 0 | 8 | 163 | 24 | 75 | HZT31021.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 156 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28064590 | 28064590 | PRJNA796975_S_NODE_8725_length_171_cov_1.672131_g8648_i0 | PRJNA796975 | 8725 | 171 | 1.672131 | 2.85934401 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 106 | 2.77e-25 | NR | MEN6533728.1 | 2212468 | g8648 | i0 | 85.7 | 0.982456140350877 | 56 | 8 | 98.2 | 0 | 3 | 170 | 320 | 375 | MEN6533728.1 terminase family protein [Bryobacteraceae bacterium] | diamond | 168 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28159541 | 28159541 | PRJNA796975_S_NODE_4445_length_218_cov_1.307692_g4368_i0 | PRJNA796975 | 4445 | 218 | 1.307692 | 2.85076856 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 72.8 | 4.95e-13 | NR | MEN6537327.1 | 2212468 | g4368 | i0 | 50.6 | 1.05963302752294 | 77 | 33 | 99.1 | 1 | 218 | 3 | 154 | 230 | MEN6537327.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 231 | 72.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28443685 | 28443685 | PRJNA796975_S_NODE_4426_length_218_cov_2.414201_g4349_i0 | PRJNA796975 | 4426 | 218 | 2.414201 | 5.26295818 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 54.3 | 2.14e-6 | NR | MEN6537229.1 | 2212468 | g4349 | i0 | 56 | 0.688073394495413 | 50 | 22 | 68.8 | 0 | 68 | 217 | 215 | 264 | MEN6537229.1 tail fiber domain-containing protein [Bryobacteraceae bacterium] | diamond | 150 | 54.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28475111 | 28475111 | PRJNA796975_S_NODE_8946_length_170_cov_0.975207_g8869_i0 | PRJNA796975 | 8946 | 170 | 0.975207 | 1.6578519 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 68.6 | 6.9e-12 | NR | HEY0876424.1 | 2910147 | g8869 | i0 | 68.5 | 0.952941176470588 | 54 | 17 | 95.3 | 0 | 169 | 8 | 37 | 90 | HEY0876424.1 SDR family oxidoreductase [Vicinamibacterales bacterium] | diamond | 162 | 68.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28633157 | 28633157 | PRJNA796975_S_NODE_4047_length_225_cov_0.982955_g3970_i0 | PRJNA796975 | 4047 | 225 | 0.982955 | 2.21164875 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 129 | 1.32e-34 | NR | MEN6537326.1 | 2212468 | g3970 | i0 | 87.8 | 1.97333333333333 | 74 | 9 | 98.7 | 0 | 3 | 224 | 90 | 163 | MEN6537326.1 phage major capsid protein [Bryobacteraceae bacterium] | diamond | 444 | 129 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29264224 | 29264224 | PRJNA796975_S_NODE_10249_length_166_cov_1.145299_g10172_i0 | PRJNA796975 | 10249 | 166 | 1.145299 | 1.90119634 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 83.6 | 5.17e-17 | NR | MEN6608653.1 | 2212468 | g10172 | i0 | 72.2 | 0.975903614457831 | 54 | 15 | 97.6 | 0 | 3 | 164 | 78 | 131 | MEN6608653.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 162 | 83.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29327467 | 29327467 | PRJNA796975_S_NODE_12069_length_164_cov_0.886957_g11992_i0 | PRJNA796975 | 12069 | 164 | 0.886957 | 1.45460948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 106 | 7.11e-26 | NR | MCY7345741.1 | 2283092 | g11992 | i0 | 90.7 | 2.96341463414634 | 54 | 5 | 98.8 | 0 | 162 | 1 | 172 | 225 | MCY7345741.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex transferase subunit TsaD [Pyrinomonadaceae bacterium] | diamond | 486 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29579882 | 29579882 | PRJNA796975_S_NODE_4690_length_214_cov_1.545455_g4613_i0 | PRJNA796975 | 4690 | 214 | 1.545455 | 3.3072737 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 78.2 | 5.1e-15 | NR | MEN6537327.1 | 2212468 | g4613 | i0 | 64.6 | 0.911214953271028 | 65 | 23 | 91.1 | 0 | 198 | 4 | 62 | 126 | MEN6537327.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 195 | 78.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30148489 | 30148489 | PRJNA796975_S_NODE_9972_length_167_cov_0.864407_g9895_i0 | PRJNA796975 | 9972 | 167 | 0.864407 | 1.44355969 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 88.2 | 7.09e-19 | NR | MBX7172178.1 | 2283092 | g9895 | i0 | 72.7 | 0.988023952095808 | 55 | 15 | 98.8 | 0 | 165 | 1 | 55 | 109 | MBX7172178.1 FAD-dependent oxidoreductase [Pyrinomonadaceae bacterium] | diamond | 165 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31190978 | 31190978 | PRJNA796975_S_NODE_6115_length_195_cov_1.150685_g6038_i0 | PRJNA796975 | 6115 | 195 | 1.150685 | 2.24383575 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 55.8 | 4.7e-7 | NR | HEX8147995.1 | 2283092 | g6038 | i0 | 65.1 | 1.95384615384615 | 43 | 15 | 66.2 | 0 | 131 | 3 | 17 | 59 | HEX8147995.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Pyrinomonadaceae bacterium] | diamond | 381 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31358686 | 31358686 | PRJNA796975_S_NODE_11276_length_165_cov_0.879310_g11199_i0 | PRJNA796975 | 11276 | 165 | 0.87931 | 1.4508615 | Bacteria | 2 | Bacteria | Bacteria | 122 | 2.63e-31 | NR | MEO8072733.1 | 1978231 | g11199 | i0 | 96.4 | 15 | 55 | 2 | 100 | 0 | 1 | 165 | 258 | 312 | MEO8072733.1 nucleotide sugar dehydrogenase [Acidobacteriota bacterium] | diamond | 2475 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31728925 | 31728925 | PRJNA796975_S_NODE_7337_length_183_cov_1.141791_g7260_i0 | PRJNA796975 | 7337 | 183 | 1.141791 | 2.08947753 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 69.7 | 4.77e-12 | NR | MEN6537322.1 | 2212468 | g7260 | i0 | 53.2 | 1.01639344262295 | 62 | 25 | 98.4 | 2 | 181 | 2 | 323 | 382 | MEN6537322.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 186 | 69.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32709061 | 32709061 | PRJNA796975_S_NODE_5060_length_208_cov_1.283019_g4983_i0 | PRJNA796975 | 5060 | 208 | 1.283019 | 2.66867952 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 132 | 1.5e-34 | NR | MEN6533728.1 | 2212468 | g4983 | i0 | 89.9 | 1.99038461538462 | 69 | 7 | 99.5 | 0 | 2 | 208 | 71 | 139 | MEN6533728.1 terminase family protein [Bryobacteraceae bacterium] | diamond | 414 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32709063 | 32709063 | PRJNA796975_S_NODE_7820_length_179_cov_0.961538_g7743_i0 | PRJNA796975 | 7820 | 179 | 0.961538 | 1.72115302 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 79.3 | 1.81e-15 | NR | MEN6537228.1 | 2212468 | g7743 | i0 | 57.6 | 0.988826815642458 | 59 | 25 | 98.9 | 0 | 3 | 179 | 84 | 142 | MEN6537228.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 177 | 79.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;