contig_metadata
19 rows where bioproject = "PRJNA725806", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5815510 | 5815510 | PRJNA725806_P_NODE_47365_length_252_cov_26.646512_g47068_i0 | PRJNA725806 | 47365 | 252 | 26.646512 | 67.14921024 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 60.2 | 1.37e-4 | NTclustered | gi|2874253721|emb|OY969563.1| | 2952895 | g47068 | i0 | 83.824 | 0.615079365079365 | 68 | 6 | 26 | 5 | 164 | 228 | 2593387 | 2593322 | MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1 | blastn | 155 | 60.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 8847474 | 8847474 | PRJNA725806_P_NODE_29287_length_288_cov_11.661355_g28990_i0 | PRJNA725806 | 29287 | 288 | 11.661355 | 33.5847024 | Bacteria | 2 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2874253854|emb|OY969910.1| | 171953 | g28990 | i0 | 100 | 0.513888888888889 | 29 | 0 | 10 | 0 | 234 | 262 | 667265 | 667293 | MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1 | blastn | 148 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13465632 | 13465632 | PRJNA725806_P_NODE_25391_length_299_cov_6.095420_g25094_i0 | PRJNA725806 | 25391 | 299 | 6.09542 | 18.2253058 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 69.4 | 2.76e-7 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g25094 | i0 | 91.837 | 17.5986622073579 | 49 | 4 | 16 | 0 | 144 | 192 | 2147292 | 2147244 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 5262 | 69.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13465650 | 13465650 | PRJNA725806_P_NODE_3231_length_493_cov_45.953947_g2973_i0 | PRJNA725806 | 3231 | 493 | 45.953947 | 226.55295871 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 54.7 | 0.013 | NTclustered | gi|2874253721|emb|OY969563.1| | 2952895 | g2973 | i0 | 82.353 | 0.314401622718053 | 68 | 7 | 13 | 5 | 107 | 171 | 2593387 | 2593322 | MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1 | blastn | 155 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 16497432 | 16497432 | PRJNA725806_P_NODE_41233_length_263_cov_2.300885_g40936_i0 | PRJNA725806 | 41233 | 263 | 2.300885 | 6.05132755 | Bacteria | 2 | Bacteria | Bacteria | 117 | 7.95e-29 | NR | MDY7092827.1 | 1978231 | g40936 | i0 | 71.8 | 10.6425855513308 | 78 | 22 | 89 | 0 | 249 | 16 | 242 | 319 | MDY7092827.1 DUF1501 domain-containing protein [Acidobacteriota bacterium] | diamond | 2799 | 118 | 0.991525423728814 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 18563601 | 18563601 | PRJNA725806_P_NODE_20455_length_315_cov_20.302158_g20159_i0 | PRJNA725806 | 20455 | 315 | 20.302158 | 63.9517977 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 60.2 | 1.76e-4 | NTclustered | gi|2874253721|emb|OY969563.1| | 2952895 | g20159 | i0 | 83.824 | 0.492063492063492 | 68 | 6 | 21 | 5 | 173 | 237 | 2593322 | 2593387 | MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1 | blastn | 155 | 60.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 20320887 | 20320887 | PRJNA725806_P_NODE_30556_length_285_cov_11.270161_g30259_i0 | PRJNA725806 | 30556 | 285 | 11.270161 | 32.11995885 | Bacteria | 2 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|2874253854|emb|OY969910.1| | 171953 | g30259 | i0 | 100 | 0.403508771929825 | 28 | 0 | 10 | 0 | 252 | 279 | 667266 | 667293 | MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1 | blastn | 115 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26862745 | 26862745 | PRJNA725806_P_NODE_18621_length_323_cov_6.653846_g18327_i0 | PRJNA725806 | 18621 | 323 | 6.653846 | 21.49192258 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 43.5 | 0.0381 | NR | HEU5235197.1 | 2282142 | g18327 | i0 | 30.9 | 0.631578947368421 | 68 | 47 | 63.2 | 0 | 264 | 61 | 11 | 78 | HEU5235197.1 hypothetical protein [Terriglobales bacterium] | diamond | 204 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 28220656 | 28220656 | PRJNA725806_P_NODE_130566_length_178_cov_4.992908_g130264_i0 | PRJNA725806 | 130566 | 178 | 4.992908 | 8.88737624 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 64.3 | 3.18e-10 | NR | HEX8649824.1 | 2283092 | g130264 | i0 | 57.4 | 0.792134831460674 | 47 | 20 | 79.2 | 0 | 152 | 12 | 26 | 72 | HEX8649824.1 RICIN domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 141 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28315653 | 28315653 | PRJNA725806_P_NODE_137166_length_175_cov_1.543478_g136864_i0 | PRJNA725806 | 137166 | 175 | 1.543478 | 2.7010865 | Acanthopleuribacter pedis | 442870 | Bacteria | Bacteria | 52 | 8.25e-6 | NR | WP_207863224.1 | 442870 | g136864 | i0 | 49 | 0.874285714285714 | 51 | 26 | 87.4 | 0 | 169 | 17 | 7 | 57 | WP_207863224.1 PEP/pyruvate-binding domain-containing protein [Acanthopleuribacter pedis] | diamond | 153 | 52 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Acanthopleuribacterales | Acanthopleuribacteraceae | Acanthopleuribacter | Acanthopleuribacter pedis | ||
| 28799284 | 28799284 | PRJNA725806_P_NODE_134367_length_176_cov_4.071942_g134065_i0 | PRJNA725806 | 134367 | 176 | 4.071942 | 7.16661792 | Bacteria | 2 | Bacteria | Bacteria | 42 | 0.0286 | NR | MDE0621699.1 | 2026791 | g134065 | i0 | 38.3 | 1.73863636363636 | 47 | 29 | 80.1 | 0 | 3 | 143 | 144 | 190 | MDE0621699.1 hypothetical protein [Bryobacterales bacterium] | diamond | 306 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 28978788 | 28978788 | PRJNA725806_P_NODE_90588_length_204_cov_6.131737_g90286_i0 | PRJNA725806 | 90588 | 204 | 6.131737 | 12.50874348 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 44.3 | 0.0064 | NR | MBV9217172.1 | 1978231 | g90286 | i0 | 55.2 | 0.426470588235294 | 29 | 13 | 42.6 | 0 | 112 | 26 | 713 | 741 | MBV9217172.1 TonB-dependent receptor [Acidobacteriota bacterium] | diamond | 87 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29451925 | 29451925 | PRJNA725806_P_NODE_690_length_805_cov_10.755208_g542_i0 | PRJNA725806 | 690 | 805 | 10.755208 | 86.5794244 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 66.2 | 2.5e-8 | NR | HSY47318.1 | 2651171 | g542 | i0 | 24.4 | 1.88944099378882 | 258 | 164 | 94.7 | 9 | 7 | 768 | 35 | 265 | HSY47318.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 1521 | 66.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29588558 | 29588558 | PRJNA725806_P_NODE_77350_length_216_cov_2.167598_g77049_i0 | PRJNA725806 | 77350 | 216 | 2.167598 | 4.68201168 | Acidobacteriota | 57723 | Bacteria | Bacteria | 43.1 | 0.0192 | NR | HZQ92083.1 | 2282142 | g77049 | i0 | 46.9 | 1.95833333333333 | 49 | 25 | 66.7 | 1 | 3 | 146 | 298 | 346 | HZQ92083.1 serine hydrolase [Terriglobales bacterium] | diamond | 423 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 30146750 | 30146750 | PRJNA725806_P_NODE_1392_length_633_cov_12.968121_g1183_i0 | PRJNA725806 | 1392 | 633 | 12.968121 | 82.08820593 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 60.8 | 6.25e-7 | NR | HSY47318.1 | 2651171 | g1183 | i0 | 24.9 | 0.971563981042654 | 205 | 128 | 96.2 | 6 | 7 | 615 | 35 | 215 | HSY47318.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 615 | 60.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30431843 | 30431843 | PRJNA725806_P_NODE_65053_length_229_cov_1.182292_g64754_i0 | PRJNA725806 | 65053 | 229 | 1.182292 | 2.70744868 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 51.2 | 2.96e-5 | NR | HEY2014734.1 | 2212468 | g64754 | i0 | 46.7 | 0.786026200873362 | 60 | 26 | 78.6 | 1 | 18 | 197 | 4 | 57 | HEY2014734.1 J domain-containing protein [Bryobacteraceae bacterium] | diamond | 180 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30842256 | 30842256 | PRJNA725806_P_NODE_3034_length_502_cov_4.741935_g2782_i0 | PRJNA725806 | 3034 | 502 | 4.741935 | 23.8045137 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 82.8 | 3.67e-17 | NR | HYG80720.1 | 2283092 | g2782 | i0 | 54.3 | 0.561752988047809 | 94 | 31 | 55.6 | 4 | 2 | 280 | 18 | 100 | HYG80720.1 jacalin-like lectin [Pyrinomonadaceae bacterium] | diamond | 282 | 82.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31421420 | 31421420 | PRJNA725806_P_NODE_158456_length_165_cov_1.195312_g158154_i0 | PRJNA725806 | 158456 | 165 | 1.195312 | 1.9722648 | Bacteria | 2 | Bacteria | Bacteria | 88.2 | 1.28e-18 | NR | MEP6704879.1 | 1978231 | g158154 | i0 | 87.5 | 3.49090909090909 | 48 | 6 | 87.3 | 0 | 22 | 165 | 389 | 436 | MEP6704879.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 576 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32843644 | 32843644 | PRJNA725806_P_NODE_180080_length_156_cov_1.302521_g179778_i0 | PRJNA725806 | 180080 | 156 | 1.302521 | 2.03193276 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82 | 1.58e-16 | NR | MEO8505809.1 | 1978231 | g179778 | i0 | 64.7 | 24.5192307692308 | 51 | 18 | 98.1 | 0 | 155 | 3 | 57 | 107 | MEO8505809.1 glutamine--tRNA ligase/YqeY domain fusion protein [Acidobacteriota bacterium] | diamond | 3825 | 82 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;