contig_metadata
22 rows where bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1238469 | 1238469 | PRJNA876641_P_NODE_20901_length_244_cov_0.900585_g20827_i0 | PRJNA876641 | 20901 | 244 | 0.900585 | 2.1974274 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 148 | 2.33e-39 | NR | HEX7315084.1 | 2283092 | g20827 | i0 | 93.6 | 0.959016393442623 | 78 | 5 | 95.9 | 0 | 10 | 243 | 21 | 98 | HEX7315084.1 FG-GAP-like repeat-containing protein [Pyrinomonadaceae bacterium] | diamond | 234 | 148 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 3403885 | 3403885 | PRJNA876641_P_NODE_15783_length_251_cov_0.865169_g15709_i0 | PRJNA876641 | 15783 | 251 | 0.865169 | 2.17157419 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 174 | 4.65e-39 | NTclustered | gi|2874253709|emb|OY969474.1| | 171953 | g15709 | i0 | 81.448 | 166.286852589641 | 221 | 33 | 95 | 8 | 36 | 251 | 1538110 | 1537893 | MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 | blastn | 41738 | 174 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 3403993 | 3403993 | PRJNA876641_P_NODE_21963_length_243_cov_0.905882_g21889_i0 | PRJNA876641 | 21963 | 243 | 0.905882 | 2.20129326 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 126 | 9.88e-33 | NR | HEV8159737.1 | 2283092 | g21889 | i0 | 77.5 | 0.987654320987654 | 80 | 18 | 98.8 | 0 | 241 | 2 | 195 | 274 | HEV8159737.1 gephyrin-like molybdotransferase Glp [Pyrinomonadaceae bacterium] | diamond | 240 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 12332417 | 12332417 | PRJNA876641_P_NODE_7130_length_311_cov_3.126050_g7056_i0 | PRJNA876641 | 7130 | 311 | 3.12605 | 9.7220155 | Geothrix sp. 21YS21S-2 | 3068893 | Bacteria | Bacteria | 65.8 | 3.73e-6 | NTclustered | gi|2566094019|gb|CP132910.1| | 3068893 | g7056 | i0 | 95.122 | 0.131832797427653 | 41 | 2 | 13 | 0 | 119 | 159 | 1463586 | 1463626 | Geothrix sp. 21YS21S-2 chromosome, complete genome | blastn | 41 | 65.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix sp. 21YS21S-2 | ||
| 26770421 | 26770421 | PRJNA876641_P_NODE_6881_length_315_cov_2.822314_g6807_i0 | PRJNA876641 | 6881 | 315 | 2.822314 | 8.8902891 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 121 | 4.04e-33 | NR | MDQ7008654.1 | 1978231 | g6807 | i0 | 77 | 0.828571428571429 | 87 | 19 | 82.9 | 1 | 315 | 55 | 26 | 111 | MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 261 | 121 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26801977 | 26801977 | PRJNA876641_P_NODE_10361_length_280_cov_1.289855_g10287_i0 | PRJNA876641 | 10361 | 280 | 1.289855 | 3.611594 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 109 | 1.26e-25 | NR | HTQ52887.1 | 2212468 | g10287 | i0 | 62.8 | 3.68571428571429 | 86 | 29 | 91.1 | 3 | 279 | 25 | 127 | 210 | HTQ52887.1 GH1 family beta-glucosidase [Bryobacteraceae bacterium] | diamond | 1032 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26841994 | 26841994 | PRJNA876641_P_NODE_19821_length_246_cov_0.890173_g19747_i0 | PRJNA876641 | 19821 | 246 | 0.890173 | 2.18982558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 68.6 | 2.76e-11 | NR | MBI2680140.1 | 332163 | g19747 | i0 | 56.9 | 4.74390243902439 | 65 | 23 | 78 | 2 | 54 | 245 | 5 | 65 | MBI2680140.1 DUF1624 domain-containing protein [Candidatus Solibacter usitatus] | diamond | 1167 | 68.9 | 0.995645863570392 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter usitatus | ||
| 27252851 | 27252851 | PRJNA876641_P_NODE_19623_length_246_cov_0.890173_g19549_i0 | PRJNA876641 | 19623 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 89.4 | 1.49e-18 | NR | MCC6264472.1 | 2026791 | g19549 | i0 | 64.8 | 32.6585365853659 | 71 | 25 | 86.6 | 0 | 3 | 215 | 115 | 185 | MCC6264472.1 molecular chaperone DnaK [Bryobacterales bacterium] | diamond | 8034 | 89.7 | 0.996655518394649 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 27466211 | 27466211 | PRJNA876641_P_NODE_10643_length_278_cov_1.809756_g10569_i0 | PRJNA876641 | 10643 | 278 | 1.809756 | 5.03112168 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 45.1 | 0.00814 | NR | HEX7177571.1 | 2283092 | g10569 | i0 | 46.8 | 0.507194244604317 | 47 | 20 | 50.7 | 1 | 138 | 278 | 258 | 299 | HEX7177571.1 bifunctional oligoribonuclease/PAP phosphatase NrnA [Pyrinomonadaceae bacterium] | diamond | 141 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29179257 | 29179257 | PRJNA876641_P_NODE_21629_length_243_cov_0.905882_g21555_i0 | PRJNA876641 | 21629 | 243 | 0.905882 | 2.20129326 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 64.3 | 3.75e-10 | NR | MBX3296917.1 | 1978231 | g21555 | i0 | 78.8 | 4.79012345679012 | 33 | 7 | 40.7 | 0 | 100 | 2 | 2 | 34 | MBX3296917.1 pirin family protein [Acidobacteriota bacterium] | diamond | 1164 | 64.7 | 0.993817619783617 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29202751 | 29202751 | PRJNA876641_P_NODE_1469_length_552_cov_4.519833_g1396_i0 | PRJNA876641 | 1469 | 552 | 4.519833 | 24.94947816 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 135 | 1.16e-37 | NR | MDQ7008653.1 | 1978231 | g1396 | i0 | 83.9 | 0.472826086956522 | 87 | 14 | 47.3 | 0 | 421 | 161 | 24 | 110 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 261 | 135 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29494848 | 29494848 | PRJNA876641_P_NODE_6970_length_314_cov_2.020747_g6896_i0 | PRJNA876641 | 6970 | 314 | 2.020747 | 6.34514558 | Bacteria | 2 | Bacteria | Bacteria | 53.1 | 1.85e-5 | NR | MBL0211669.1 | 2052165 | g6896 | i0 | 39.5 | 5.84713375796178 | 76 | 42 | 71.7 | 3 | 9 | 233 | 155 | 227 | MBL0211669.1 hypothetical protein [Holophagaceae bacterium] | diamond | 1836 | 53.5 | 0.992523364485981 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae bacterium | |||
| 29683950 | 29683950 | PRJNA876641_P_NODE_22530_length_242_cov_0.911243_g22456_i0 | PRJNA876641 | 22530 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.8 | 6.52e-17 | NR | HTR22663.1 | 2282142 | g22456 | i0 | 53.2 | 5.87603305785124 | 79 | 36 | 97.9 | 1 | 3 | 239 | 112 | 189 | HTR22663.1 DUF4197 domain-containing protein [Terriglobales bacterium] | diamond | 1422 | 82.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 29834121 | 29834121 | PRJNA876641_P_NODE_4671_length_359_cov_1.783217_g4597_i0 | PRJNA876641 | 4671 | 359 | 1.783217 | 6.40174903 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 88.6 | 4.16e-18 | NR | MDR3737318.1 | 2052142 | g4597 | i0 | 46.4 | 0.919220055710306 | 110 | 52 | 87.7 | 3 | 2 | 316 | 200 | 307 | MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 330 | 88.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 30181540 | 30181540 | PRJNA876641_P_NODE_17072_length_249_cov_1.562500_g16998_i0 | PRJNA876641 | 17072 | 249 | 1.5625 | 3.890625 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 129 | 9.61e-33 | NR | MBX9604362.1 | 2212468 | g16998 | i0 | 76.5 | 0.975903614457831 | 81 | 19 | 97.6 | 0 | 5 | 247 | 304 | 384 | MBX9604362.1 signal peptide peptidase SppA [Bryobacteraceae bacterium] | diamond | 243 | 129 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30253082 | 30253082 | PRJNA876641_P_NODE_21212_length_244_cov_0.900585_g21138_i0 | PRJNA876641 | 21212 | 244 | 0.900585 | 2.1974274 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 124 | 1.44e-31 | NR | MBM3767909.1 | 1978231 | g21138 | i0 | 72.7 | 14.4590163934426 | 77 | 21 | 94.7 | 0 | 12 | 242 | 229 | 305 | MBM3767909.1 malate synthase A [Acidobacteriota bacterium] | diamond | 3528 | 124 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31358997 | 31358997 | PRJNA876641_P_NODE_16716_length_250_cov_0.870056_g16642_i0 | PRJNA876641 | 16716 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 90.9 | 1.34e-19 | NR | MDQ3816894.1 | 1978231 | g16642 | i0 | 53 | 10.92 | 83 | 39 | 99.6 | 0 | 1 | 249 | 221 | 303 | MDQ3816894.1 DUF2891 domain-containing protein [Acidobacteriota bacterium] | diamond | 2730 | 90.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31540694 | 31540694 | PRJNA876641_P_NODE_17956_length_248_cov_0.880000_g17882_i0 | PRJNA876641 | 17956 | 248 | 0.88 | 2.1824 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.9 | 1.31e-9 | NR | MEJ2421092.1 | 1978231 | g17882 | i0 | 45.9 | 1.63306451612903 | 74 | 40 | 89.5 | 0 | 234 | 13 | 380 | 453 | MEJ2421092.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 405 | 63.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31730263 | 31730263 | PRJNA876641_P_NODE_2217_length_469_cov_2.068182_g2143_i0 | PRJNA876641 | 2217 | 469 | 2.068182 | 9.69977358 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 73.6 | 1.78e-13 | NR | MCI0662186.1 | 1978231 | g2143 | i0 | 42 | 1.18976545842217 | 88 | 51 | 56.3 | 0 | 320 | 57 | 3 | 90 | MCI0662186.1 RNA-binding protein [Acidobacteriota bacterium] | diamond | 558 | 73.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31801480 | 31801480 | PRJNA876641_P_NODE_9837_length_283_cov_1.380952_g9763_i0 | PRJNA876641 | 9837 | 283 | 1.380952 | 3.90809416 | Chloracidobacterium | 458032 | Bacteria | Bacteria | 106 | 6.96e-25 | NR | WP_058867807.1 | 458033 | g9763 | i0 | 58.6 | 3.81625441696113 | 87 | 36 | 92.2 | 0 | 262 | 2 | 142 | 228 | WP_058867807.1 dipeptidase [Chloracidobacterium thermophilum] | diamond | 1080 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium thermophilum | ||
| 32647154 | 32647154 | PRJNA876641_P_NODE_18280_length_248_cov_0.880000_g18206_i0 | PRJNA876641 | 18280 | 248 | 0.88 | 2.1824 | Sulfidibacter corallicola | 2818388 | Bacteria | Bacteria | 108 | 1.59e-25 | NR | WP_237377478.1 | 2818388 | g18206 | i0 | 62.2 | 0.991935483870968 | 82 | 30 | 98 | 1 | 243 | 1 | 140 | 221 | WP_237377478.1 aldehyde dehydrogenase [Sulfidibacter corallicola] | diamond | 246 | 108 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Acanthopleuribacterales | Acanthopleuribacteraceae | Sulfidibacter | Sulfidibacter corallicola | ||
| 32678740 | 32678740 | PRJNA876641_P_NODE_15580_length_251_cov_1.601124_g15506_i0 | PRJNA876641 | 15580 | 251 | 1.601124 | 4.01882124 | Luteitalea sp. | 2004800 | Bacteria | Bacteria | 45.4 | 0.00453 | NR | WP_291988344.1 | 2004800 | g15506 | i0 | 54.3 | 0.418326693227092 | 35 | 16 | 41.8 | 0 | 251 | 147 | 20 | 54 | WP_291988344.1 hypothetical protein [Luteitalea sp.] | diamond | 105 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacteraceae | Luteitalea | Luteitalea 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);;