contig_metadata
17 rows where bioproject = "PRJEB76780", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16715391 | 16715391 | PRJEB76780_P_NODE_10094_length_255_cov_1.285714_g9994_i0 | PRJEB76780 | 10094 | 255 | 1.285714 | 3.2785707 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 118 | 1.31e-30 | NR | HET9942311.1 | 2081523 | g9994 | i0 | 68.2 | 1 | 85 | 27 | 100 | 0 | 1 | 255 | 101 | 185 | HET9942311.1 enoyl-CoA hydratase-related protein [Terriglobia bacterium] | diamond | 255 | 118 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 16715397 | 16715397 | PRJEB76780_P_NODE_10774_length_251_cov_1.601124_g10674_i0 | PRJEB76780 | 10774 | 251 | 1.601124 | 4.01882124 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 154 | 2.1199999999999998e-42 | NR | MBS1786194.1 | 1978231 | g10674 | i0 | 90.4 | 3.9681274900398402 | 83 | 8 | 99.2 | 0 | 251 | 3 | 389 | 471 | MBS1786194.1 amidohydrolase [Acidobacteriota bacterium] | diamond | 996 | 154 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 19264247 | 19264247 | PRJEB76780_P_NODE_10976_length_251_cov_0.876404_g10876_i0 | PRJEB76780 | 10976 | 251 | 0.876404 | 2.19977404 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 228 | 3.5199999999999986e-55 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g10876 | i0 | 85.202 | 10.4501992031873 | 223 | 31 | 88 | 2 | 6 | 227 | 1102071 | 1101850 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 2623 | 228 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26590758 | 26590758 | PRJEB76780_P_NODE_2861_length_487_cov_1.432367_g2761_i0 | PRJEB76780 | 2861 | 487 | 1.432367 | 6.97562729 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 184 | 3.5e-53 | NR | HEX8197009.1 | 2283092 | g2761 | i0 | 56.3 | 1.90349075975359 | 160 | 70 | 98.6 | 0 | 8 | 487 | 14 | 173 | HEX8197009.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 927 | 184 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27223690 | 27223690 | PRJEB76780_P_NODE_8323_length_281_cov_1.125000_g8223_i0 | PRJEB76780 | 8323 | 281 | 1.125 | 3.16125 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 69.7 | 1.38e-11 | NR | MBM3735564.1 | 1978231 | g8223 | i0 | 43.5 | 0.907473309608541 | 85 | 43 | 85.4 | 2 | 42 | 281 | 83 | 167 | MBM3735564.1 DUF2278 family protein [Acidobacteriota bacterium] | diamond | 255 | 69.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27879828 | 27879828 | PRJEB76780_P_NODE_11725_length_248_cov_0.891429_g11625_i0 | PRJEB76780 | 11725 | 248 | 0.891429 | 2.21074392 | Bacteria | 2 | Bacteria | Bacteria | 55.1 | 1.63e-6 | NR | MBM3735564.1 | 1978231 | g11625 | i0 | 47.1 | 1.93548387096774 | 51 | 26 | 61.7 | 1 | 166 | 14 | 4 | 53 | MBM3735564.1 DUF2278 family protein [Acidobacteriota bacterium] | diamond | 480 | 55.5 | 0.992792792792793 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28360589 | 28360589 | PRJEB76780_P_NODE_886_length_882_cov_1.458591_g803_i0 | PRJEB76780 | 886 | 882 | 1.458591 | 12.86477262 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 82.4 | 2.32e-13 | NR | HXS11305.1 | 2052142 | g803 | i0 | 33 | 0.731292517006803 | 215 | 134 | 71.8 | 8 | 861 | 229 | 219 | 427 | HXS11305.1 Ig-like domain repeat protein [Acidobacteriaceae bacterium] | diamond | 645 | 82.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 28606032 | 28606032 | PRJEB76780_P_NODE_6227_length_324_cov_0.932271_g6127_i0 | PRJEB76780 | 6227 | 324 | 0.932271 | 3.02055804 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 102 | 1.37e-22 | NR | MDA0205526.1 | 1978231 | g6127 | i0 | 51.9 | 6.89814814814815 | 106 | 50 | 98.1 | 1 | 6 | 323 | 270 | 374 | MDA0205526.1 SLC13 family permease [Acidobacteriota bacterium] | diamond | 2235 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28676592 | 28676592 | PRJEB76780_P_NODE_9807_length_259_cov_1.672043_g9707_i0 | PRJEB76780 | 9807 | 259 | 1.672043 | 4.33059137 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 55.1 | 1.98e-6 | NR | HVS13692.1 | 2651171 | g9707 | i0 | 36.3 | 3.44015444015444 | 80 | 49 | 90.3 | 1 | 17 | 250 | 77 | 156 | HVS13692.1 CHRD domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 891 | 55.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28732389 | 28732389 | PRJEB76780_P_NODE_6067_length_328_cov_0.894118_g5967_i0 | PRJEB76780 | 6067 | 328 | 0.894118 | 2.93270704 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 117 | 4.37e-28 | NR | MEM1247880.1 | 1978231 | g5967 | i0 | 58.9 | 8.12195121951219 | 90 | 37 | 82.3 | 0 | 278 | 9 | 6 | 95 | MEM1247880.1 bifunctional sulfate adenylyltransferase/adenylylsulfate kinase [Acidobacteriota bacterium] | diamond | 2664 | 118 | 0.991525423728814 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28897362 | 28897362 | PRJEB76780_P_NODE_12208_length_246_cov_0.901734_g12108_i0 | PRJEB76780 | 12208 | 246 | 0.901734 | 2.21826564 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 54.3 | 3.32e-6 | NR | MBL8216997.1 | 2026791 | g12108 | i0 | 41 | 0.74390243902439 | 61 | 36 | 74.4 | 0 | 183 | 1 | 30 | 90 | MBL8216997.1 ankyrin repeat domain-containing protein [Bryobacterales bacterium] | diamond | 183 | 54.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 29995524 | 29995524 | PRJEB76780_P_NODE_6211_length_324_cov_1.243028_g6111_i0 | PRJEB76780 | 6211 | 324 | 1.243028 | 4.02741072 | root | 1 | Root_unresolved | Root_unresolved | 99 | 4.449999999999999e-24 | NR | HEY4492495.1 | 1978231 | g6111 | i0 | 59.7 | 6.98148148148148 | 77 | 30 | 70.4 | 1 | 229 | 2 | 8 | 84 | HEY4492495.1 glycine cleavage system protein GcvH [Acidobacteriota bacterium] | diamond | 2262 | 100 | 0.99 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31108334 | 31108334 | PRJEB76780_P_NODE_9955_length_257_cov_1.271739_g9855_i0 | PRJEB76780 | 9955 | 257 | 1.271739 | 3.26836923 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.5 | 0.0222 | NR | TDI23913.1 | 1978231 | g9855 | i0 | 32.8 | 0.747081712062257 | 64 | 43 | 74.7 | 0 | 59 | 250 | 14 | 77 | TDI23913.1 MAG: cyclase family protein [Acidobacteriota bacterium] | diamond | 192 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31740826 | 31740826 | PRJEB76780_P_NODE_1317_length_720_cov_3.041731_g1224_i0 | PRJEB76780 | 1317 | 720 | 3.041731 | 21.9004632 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 114 | 1.21e-25 | NR | HUO59097.1 | 2952895 | g1224 | i0 | 33.9 | 1.03333333333333 | 248 | 151 | 99.2 | 7 | 715 | 2 | 127 | 371 | HUO59097.1 hypothetical protein [Candidatus Acidiferrales bacterium] | diamond | 744 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 31772534 | 31772534 | PRJEB76780_P_NODE_11057_length_250_cov_1.457627_g10957_i0 | PRJEB76780 | 11057 | 250 | 1.457627 | 3.6440675 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 138 | 1.26e-36 | NR | MDQ3634614.1 | 1978231 | g10957 | i0 | 77.1 | 10.032 | 83 | 18 | 98.4 | 1 | 4 | 249 | 30 | 112 | MDQ3634614.1 NADP-dependent isocitrate dehydrogenase [Acidobacteriota bacterium] | diamond | 2508 | 138 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32081626 | 32081626 | PRJEB76780_P_NODE_11778_length_248_cov_0.891429_g11678_i0 | PRJEB76780 | 11778 | 248 | 0.891429 | 2.21074392 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.3 | 5.19e-17 | NR | MBP8274522.1 | 1978231 | g11678 | i0 | 51.4 | 5.29838709677419 | 72 | 35 | 87.1 | 0 | 33 | 248 | 188 | 259 | MBP8274522.1 PAS domain S-box protein [Acidobacteriota bacterium] | diamond | 1314 | 85.1 | 0.990599294947121 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32839600 | 32839600 | PRJEB76780_P_NODE_12500_length_245_cov_0.906977_g12400_i0 | PRJEB76780 | 12500 | 245 | 0.906977 | 2.22209365 | PVC group | 1783257 | Bacteria | Bacteria | 59.7 | 3.51e-8 | NR | HMF76292.1 | 2212468 | g12400 | i0 | 36.9 | 7.66530612244898 | 84 | 45 | 94.3 | 3 | 236 | 6 | 79 | 161 | HMF76292.1 GMC family oxidoreductase N-terminal domain-containing protein [Bryobacteraceae bacterium] | diamond | 1878 | 59.7 | 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);;