contig_metadata
23 rows where bioproject = "PRJNA896973", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2519642 | 2519642 | PRJNA896973_P_NODE_17802_length_273_cov_0.935000_g17708_i0 | PRJNA896973 | 17802 | 273 | 0.935 | 2.55255 | Acidobacterium | 33973 | Bacteria | Bacteria | 483 | 7.5e-132 | NTclustered | gi|470484216|ref|NR_076636.1| | 33075 | g17708 | i0 | 98.535 | 102.201465201465 | 273 | 4 | 100 | 0 | 1 | 273 | 707 | 979 | Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence | blastn | 27901 | 483 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacterium | Acidobacterium capsulatum | ||
| 3424255 | 3424255 | PRJNA896973_S_NODE_2783_length_244_cov_3.070175_g2769_i0 | PRJNA896973 | 2783 | 244 | 3.070175 | 7.491227 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 364 | 2.489999999999999e-96 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g2769 | i0 | 96 | 131.561475409836 | 225 | 8 | 92 | 1 | 17 | 241 | 3299054 | 3299277 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 32101 | 364 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 8526077 | 8526077 | PRJNA896973_P_NODE_26707_length_243_cov_0.905882_g26613_i0 | PRJNA896973 | 26707 | 243 | 0.905882 | 2.20129326 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 311 | 3.27e-80 | NTclustered | gi|2874253786|emb|OY969770.1| | 2952895 | g26613 | i0 | 90 | 98.4814814814815 | 240 | 24 | 99 | 0 | 4 | 243 | 4657673 | 4657434 | MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1 | blastn | 23931 | 311 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 12352141 | 12352141 | PRJNA896973_P_NODE_22850_length_249_cov_0.880682_g22756_i0 | PRJNA896973 | 22850 | 249 | 0.880682 | 2.19289818 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 372 | 1.52e-98 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g22756 | i0 | 93.574 | 148.21686746988 | 249 | 16 | 100 | 0 | 1 | 249 | 2365900 | 2365652 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 36906 | 372 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14901398 | 14901398 | PRJNA896973_P_NODE_7892_length_381_cov_1.493506_g7798_i0 | PRJNA896973 | 7892 | 381 | 1.493506 | 5.69025786 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 127 | 4.01e-31 | NR | HVN82611.1 | 2081523 | g7798 | i0 | 52.8 | 1.98425196850394 | 125 | 58 | 97.6 | 1 | 2 | 373 | 935 | 1059 | HVN82611.1 hypothetical protein [Terriglobia bacterium] | diamond | 756 | 127 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 25098992 | 25098992 | PRJNA896973_P_NODE_11880_length_321_cov_1.653226_g11786_i0 | PRJNA896973 | 11880 | 321 | 1.653226 | 5.30685546 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 130 | 2.61e-35 | NR | HEX8119292.1 | 2283092 | g11786 | i0 | 91.1 | 0.738317757009346 | 79 | 7 | 73.8 | 0 | 237 | 1 | 1 | 79 | HEX8119292.1 3-hydroxyacyl-CoA dehydrogenase family protein [Pyrinomonadaceae bacterium] | diamond | 237 | 130 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26834319 | 26834319 | PRJNA896973_P_NODE_23681_length_248_cov_0.880000_g23587_i0 | PRJNA896973 | 23681 | 248 | 0.88 | 2.1824 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 55.5 | 1.26e-6 | NR | MBA3914522.1 | 2282142 | g23587 | i0 | 68.9 | 0.544354838709677 | 45 | 11 | 50.8 | 1 | 247 | 122 | 385 | 429 | MBA3914522.1 aspartate aminotransferase family protein [Terriglobales bacterium] | diamond | 135 | 55.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27181951 | 27181951 | PRJNA896973_P_NODE_14622_length_295_cov_1.040541_g14528_i0 | PRJNA896973 | 14622 | 295 | 1.040541 | 3.06959595 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 81.6 | 3.56e-16 | NR | HEV3253640.1 | 2952895 | g14528 | i0 | 47.5 | 1.00677966101695 | 99 | 51 | 99.7 | 1 | 294 | 1 | 44 | 142 | HEV3253640.1 hypothetical protein [Candidatus Acidiferrales bacterium] | diamond | 297 | 81.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 27435187 | 27435187 | PRJNA896973_P_NODE_26723_length_243_cov_0.905882_g26629_i0 | PRJNA896973 | 26723 | 243 | 0.905882 | 2.20129326 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 69.7 | 7.32e-12 | NR | MBX9603669.1 | 2212468 | g26629 | i0 | 66.1 | 0.691358024691358 | 56 | 19 | 69.1 | 0 | 69 | 236 | 1 | 56 | MBX9603669.1 VWA domain-containing protein [Bryobacteraceae bacterium] | diamond | 168 | 69.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28066402 | 28066402 | PRJNA896973_P_NODE_23645_length_248_cov_0.880000_g23551_i0 | PRJNA896973 | 23645 | 248 | 0.88 | 2.1824 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 159 | 1.81e-46 | NR | MBX9601119.1 | 2212468 | g23551 | i0 | 92.7 | 0.991935483870968 | 82 | 6 | 99.2 | 0 | 3 | 248 | 115 | 196 | MBX9601119.1 menaquinone biosynthesis protein [Bryobacteraceae bacterium] | diamond | 246 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28571552 | 28571552 | PRJNA896973_S_NODE_1427_length_320_cov_1.230769_g1413_i0 | PRJNA896973 | 1427 | 320 | 1.230769 | 3.9384608 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.0136 | NR | MEP6801116.1 | 1978231 | g1413 | i0 | 35.9 | 0.6 | 64 | 38 | 60 | 2 | 20 | 211 | 344 | 404 | MEP6801116.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 192 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28926561 | 28926561 | PRJNA896973_P_NODE_27728_length_241_cov_1.761905_g27634_i0 | PRJNA896973 | 27728 | 241 | 1.761905 | 4.24619105 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 149 | 1.89e-40 | NR | HTY85574.1 | 1964179 | g27634 | i0 | 86.3 | 15.9336099585062 | 80 | 11 | 99.6 | 0 | 2 | 241 | 384 | 463 | HTY85574.1 sulfotransferase [Silvibacterium sp.] | diamond | 3840 | 150 | 0.993333333333333 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Silvibacterium | Silvibacterium sp. | ||
| 28982295 | 28982295 | PRJNA896973_P_NODE_15688_length_287_cov_1.065421_g15594_i0 | PRJNA896973 | 15688 | 287 | 1.065421 | 3.05775827 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 178 | 1.82e-49 | NR | HEX6183262.1 | 2283092 | g15594 | i0 | 88.4 | 1.98606271777003 | 95 | 11 | 99.3 | 0 | 285 | 1 | 126 | 220 | HEX6183262.1 DUF1565 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 570 | 178 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29992587 | 29992587 | PRJNA896973_P_NODE_25651_length_245_cov_0.895349_g25557_i0 | PRJNA896973 | 25651 | 245 | 0.895349 | 2.19360505 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 72.4 | 5.76e-14 | NR | HYL14595.1 | 2282142 | g25557 | i0 | 72.2 | 0.661224489795918 | 54 | 15 | 66.1 | 0 | 5 | 166 | 83 | 136 | HYL14595.1 heavy metal-responsive transcriptional regulator [Terriglobales bacterium] | diamond | 162 | 72.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 29992588 | 29992588 | PRJNA896973_P_NODE_29211_length_205_cov_4.909091_g29117_i0 | PRJNA896973 | 29211 | 205 | 4.909091 | 10.06363655 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 1.67e-12 | NR | MDT4968561.1 | 1978231 | g29117 | i0 | 43.3 | 0.980487804878049 | 67 | 38 | 98 | 0 | 3 | 203 | 126 | 192 | MDT4968561.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 201 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30213532 | 30213532 | PRJNA896973_P_NODE_23312_length_248_cov_2.388571_g23218_i0 | PRJNA896973 | 23312 | 248 | 2.3885710000000002 | 5.92365608 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 94.7 | 2e-20 | NR | HEY9435469.1 | 2052146 | g23218 | i0 | 55.7 | 1.91129032258065 | 79 | 35 | 95.6 | 0 | 248 | 12 | 631 | 709 | HEY9435469.1 hypothetical protein [Blastocatellia bacterium] | diamond | 474 | 94.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30435164 | 30435164 | PRJNA896973_P_NODE_24533_length_246_cov_1.878613_g24439_i0 | PRJNA896973 | 24533 | 246 | 1.878613 | 4.62138798 | Candidatus Sulfotelmatobacter sp. | 2771375 | Bacteria | Bacteria | 102 | 3.07e-23 | NR | HEY6768979.1 | 2771375 | g24439 | i0 | 56.8 | 0.98780487804878 | 81 | 35 | 98.8 | 0 | 3 | 245 | 5 | 85 | HEY6768979.1 triple tyrosine motif-containing protein [Candidatus Sulfotelmatobacter sp.] | diamond | 243 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Candidatus Sulfotelmatobacter sp. | ||
| 30845651 | 30845651 | PRJNA896973_P_NODE_18894_length_266_cov_1.217617_g18800_i0 | PRJNA896973 | 18894 | 266 | 1.217617 | 3.23886122 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 127 | 6.31e-32 | NR | HWO39108.1 | 3069120 | g18800 | i0 | 69.8 | 1.93984962406015 | 86 | 26 | 97 | 0 | 262 | 5 | 453 | 538 | HWO39108.1 prolyl oligopeptidase family serine peptidase [Candidatus Acidiferrum sp.] | diamond | 516 | 127 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 31066971 | 31066971 | PRJNA896973_S_NODE_2295_length_263_cov_2.631579_g2281_i0 | PRJNA896973 | 2295 | 263 | 2.631579 | 6.92105277 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 159 | 5.54e-46 | NR | HSD29211.1 | 2793154 | g2281 | i0 | 91.6 | 2.84030418250951 | 83 | 7 | 94.7 | 0 | 251 | 3 | 38 | 120 | HSD29211.1 dihydroorotate dehydrogenase [Vicinamibacteria bacterium] | diamond | 747 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 31383033 | 31383033 | PRJNA896973_P_NODE_11256_length_328_cov_1.149020_g11162_i0 | PRJNA896973 | 11256 | 328 | 1.14902 | 3.7687856 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.0138 | NR | MDA1313252.1 | 1978231 | g11162 | i0 | 47.4 | 0.347560975609756 | 38 | 16 | 34.8 | 1 | 186 | 299 | 299 | 332 | MDA1313252.1 glycosyltransferase [Acidobacteriota bacterium] | diamond | 114 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31422225 | 31422225 | PRJNA896973_P_NODE_24016_length_247_cov_1.327586_g23922_i0 | PRJNA896973 | 24016 | 247 | 1.327586 | 3.27913742 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.8 | 0.00312 | NR | HUQ91205.1 | 2212468 | g23922 | i0 | 73.9 | 0.558704453441296 | 23 | 6 | 27.9 | 0 | 179 | 247 | 1 | 23 | HUQ91205.1 site-specific integrase [Bryobacteraceae bacterium] | diamond | 138 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32015559 | 32015559 | PRJNA896973_P_NODE_22618_length_250_cov_0.870056_g22524_i0 | PRJNA896973 | 22618 | 250 | 0.870056 | 2.17514 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 140 | 2.33e-41 | NR | HEX7316061.1 | 2283092 | g22524 | i0 | 90.1 | 4.32 | 71 | 7 | 85.2 | 0 | 214 | 2 | 3 | 73 | HEX7316061.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 1080 | 140 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32363838 | 32363838 | PRJNA896973_P_NODE_11319_length_327_cov_1.472441_g11225_i0 | PRJNA896973 | 11319 | 327 | 1.4724410000000001 | 4.81488207 | Candidatus Solibacter sp. | 2068625 | Bacteria | Bacteria | 42.7 | 0.0338 | NR | MEO8369265.1 | 2068625 | g11225 | i0 | 35.7 | 0.513761467889908 | 56 | 31 | 51.4 | 1 | 180 | 13 | 4 | 54 | MEO8369265.1 hypothetical protein [Candidatus Solibacter sp.] | diamond | 168 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter sp. |
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);;