contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8161575 | 8161575 | PRJNA541476_P_NODE_27887_length_253_cov_2.666667_g27681_i0 | PRJNA541476 | 27887 | 253 | 2.666667 | 6.74666751 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 117 | 6.79e-29 | NR | HMT09336.1 | 2283092 | g27681 | i0 | 82.6 | 23.6205533596838 | 69 | 9 | 78.3 | 1 | 253 | 56 | 77 | 145 | HMT09336.1 acyl-CoA carboxylase subunit beta [Pyrinomonadaceae bacterium] | diamond | 5976 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 23460846 | 23460846 | PRJNA541476_P_NODE_2259_length_785_cov_2.712079_g2081_i0 | PRJNA541476 | 2259 | 785 | 2.712079 | 21.28982015 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 364 | 4.05e-123 | NR | MEM7585604.1 | 1978231 | g2081 | i0 | 66.7 | 3.98980891719745 | 261 | 87 | 99.7 | 0 | 2 | 784 | 4 | 264 | MEM7585604.1 NAD-dependent epimerase/dehydratase family protein [Acidobacteriota bacterium] | diamond | 3132 | 364 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 24735223 | 24735223 | PRJNA541476_P_NODE_7720_length_407_cov_1.790419_g7516_i0 | PRJNA541476 | 7720 | 407 | 1.790419 | 7.28700533 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 3.65e-30 | NR | MCS6817120.1 | 2052146 | g7516 | i0 | 63.2 | 9.93611793611794 | 106 | 30 | 78.1 | 1 | 1 | 318 | 1354 | 1450 | MCS6817120.1 glutamate synthase large subunit [Blastocatellia bacterium] | diamond | 4044 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27046307 | 27046307 | PRJNA541476_P_NODE_25142_length_262_cov_2.328042_g24936_i0 | PRJNA541476 | 25142 | 262 | 2.328042 | 6.09947004 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 47.8 | 7.93e-4 | NR | HEV2323067.1 | 1964191 | g24936 | i0 | 36.5 | 2.45038167938931 | 74 | 46 | 84.7 | 1 | 242 | 21 | 116 | 188 | HEV2323067.1 hypothetical protein [Terracidiphilus sp.] | diamond | 642 | 47.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 27077881 | 27077881 | PRJNA541476_P_NODE_25462_length_261_cov_1.787234_g25256_i0 | PRJNA541476 | 25462 | 261 | 1.787234 | 4.66468074 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 108 | 3.43e-25 | NR | MFP5263770.1 | 2052146 | g25256 | i0 | 62.1 | 1 | 87 | 33 | 100 | 0 | 1 | 261 | 862 | 948 | MFP5263770.1 HYR domain-containing protein [Blastocatellia bacterium] | diamond | 261 | 108 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 27299186 | 27299186 | PRJNA541476_P_NODE_20803_length_279_cov_1.160194_g20597_i0 | PRJNA541476 | 20803 | 279 | 1.160194 | 3.23694126 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 74.7 | 3.31e-13 | NR | MDP9053174.1 | 1978231 | g20597 | i0 | 64.7 | 2.70967741935484 | 51 | 18 | 54.8 | 0 | 4 | 156 | 545 | 595 | MDP9053174.1 aminodeoxychorismate synthase component I [Acidobacteriota bacterium] | diamond | 756 | 74.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27646720 | 27646720 | PRJNA541476_P_NODE_10304_length_356_cov_1.098940_g10098_i0 | PRJNA541476 | 10304 | 356 | 1.09894 | 3.9122264 | Chloracidobacterium sp. CP2_5A | 2012633 | Bacteria | Bacteria | 142 | 1.87e-38 | NR | OYT71995.1 | 2012633 | g10098 | i0 | 64.7 | 10.8707865168539 | 116 | 40 | 97.8 | 1 | 8 | 355 | 65 | 179 | OYT71995.1 MAG: NADP-dependent oxidoreductase [Chloracidobacterium sp. CP2_5A] | diamond | 3870 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. CP2_5A | ||
| 27773038 | 27773038 | PRJNA541476_P_NODE_4504_length_539_cov_2.231760_g4305_i0 | PRJNA541476 | 4504 | 539 | 2.23176 | 12.0291864 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 128 | 1.9099999999999998e-31 | NR | MEW6732442.1 | 1978231 | g4305 | i0 | 52 | 0.951762523191095 | 171 | 75 | 91.8 | 3 | 20 | 514 | 180 | 349 | MEW6732442.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 513 | 128 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27993961 | 27993961 | PRJNA541476_P_NODE_35685_length_245_cov_1.790698_g35479_i0 | PRJNA541476 | 35685 | 245 | 1.790698 | 4.3872101 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 50.4 | 7.35e-5 | NR | MFP3938957.1 | 2651171 | g35479 | i0 | 40 | 0.673469387755102 | 55 | 30 | 63.7 | 1 | 2 | 157 | 101 | 155 | MFP3938957.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 165 | 50.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28103278 | 28103278 | PRJNA541476_P_NODE_1425_length_996_cov_14.148429_g1279_i0 | PRJNA541476 | 1425 | 996 | 14.148429 | 140.91835284 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 339 | 1.19e-102 | NR | MBS1768271.1 | 1978231 | g1279 | i0 | 48.7 | 2.13855421686747 | 355 | 157 | 99.7 | 2 | 993 | 1 | 1030 | 1383 | MBS1768271.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 2130 | 341 | 0.994134897360704 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28877827 | 28877827 | PRJNA541476_P_NODE_8168_length_396_cov_1.399381_g7964_i0 | PRJNA541476 | 8168 | 396 | 1.399381 | 5.54154876 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 47.8 | 0.00343 | NR | PYT13993.1 | 1978231 | g7964 | i0 | 66.7 | 0.204545454545455 | 27 | 9 | 20.5 | 0 | 7 | 87 | 331 | 357 | PYT13993.1 MAG: hypothetical protein DMF51_09540 [Acidobacteriota bacterium] | diamond | 81 | 47.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28909191 | 28909191 | PRJNA541476_P_NODE_14348_length_314_cov_2.008299_g14142_i0 | PRJNA541476 | 14348 | 314 | 2.008299 | 6.30605886 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 44.3 | 0.0251 | NR | HKG13456.1 | 2283092 | g14142 | i0 | 47.5 | 0.382165605095541 | 40 | 21 | 38.2 | 0 | 215 | 96 | 990 | 1029 | HKG13456.1 DNA/RNA non-specific endonuclease [Pyrinomonadaceae bacterium] | diamond | 120 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29113902 | 29113902 | PRJNA541476_P_NODE_26068_length_259_cov_1.763441_g25862_i0 | PRJNA541476 | 26068 | 259 | 1.763441 | 4.56731219 | Bacteria | 2 | Bacteria | Bacteria | 57.4 | 2.78e-7 | NR | PYQ17612.1 | 1978231 | g25862 | i0 | 47 | 3.08108108108108 | 66 | 28 | 76.4 | 2 | 60 | 257 | 30 | 88 | PYQ17612.1 MAG: hypothetical protein DMF80_00135 [Acidobacteriota bacterium] | diamond | 798 | 57.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29808349 | 29808349 | PRJNA541476_P_NODE_21571_length_275_cov_3.282178_g21365_i0 | PRJNA541476 | 21571 | 275 | 3.282178 | 9.0259895 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52 | 2.97e-5 | NR | WP_015896997.1 | 33973 | g21365 | i0 | 56.5 | 1.93090909090909 | 46 | 20 | 50.2 | 0 | 1 | 138 | 320 | 365 | WP_015896997.1 MULTISPECIES: pyruvate kinase [Acidobacterium] | diamond | 531 | 52 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacterium | |||
| 30077722 | 30077722 | PRJNA541476_P_NODE_29292_length_251_cov_2.595506_g29086_i0 | PRJNA541476 | 29292 | 251 | 2.595506 | 6.51472006 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 42.7 | 0.0373 | NR | HVO11384.1 | 2793154 | g29086 | i0 | 31.2 | 0.920318725099602 | 77 | 49 | 87.3 | 1 | 232 | 14 | 33 | 109 | HVO11384.1 GDSL-type esterase/lipase family protein [Vicinamibacteria bacterium] | diamond | 231 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria bacterium | |||||
| 30614898 | 30614898 | PRJNA541476_P_NODE_27873_length_253_cov_4.061111_g27667_i0 | PRJNA541476 | 27873 | 253 | 4.061111 | 10.27461083 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 60.1 | 2.73e-8 | NR | HLN02708.1 | 2212468 | g27667 | i0 | 40 | 2.84584980237154 | 80 | 41 | 87.7 | 2 | 31 | 252 | 63 | 141 | HLN02708.1 lipase family protein [Bryobacteraceae bacterium] | diamond | 720 | 60.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30646356 | 30646356 | PRJNA541476_P_NODE_26633_length_257_cov_2.086957_g26427_i0 | PRJNA541476 | 26633 | 257 | 2.086957 | 5.36347949 | Paludibaculum sp. | 1962912 | Bacteria | Bacteria | 43.1 | 0.0256 | NR | HEY3440495.1 | 1962912 | g26427 | i0 | 38.1 | 0.735408560311284 | 63 | 37 | 71.2 | 1 | 232 | 50 | 88 | 150 | HEY3440495.1 hypothetical protein [Paludibaculum sp.] | diamond | 189 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum sp. | ||
| 30709702 | 30709702 | PRJNA541476_P_NODE_35074_length_246_cov_0.901734_g34868_i0 | PRJNA541476 | 35074 | 246 | 0.901734 | 2.21826564 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 78.2 | 6.08e-16 | NR | HEV2709111.1 | 1934404 | g34868 | i0 | 50.8 | 1.69512195121951 | 65 | 28 | 79.3 | 1 | 5 | 199 | 101 | 161 | HEV2709111.1 HNH endonuclease [Edaphobacter sp.] | diamond | 417 | 78.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 31040877 | 31040877 | PRJNA541476_P_NODE_3575_length_613_cov_1.798148_g3382_i0 | PRJNA541476 | 3575 | 613 | 1.798148 | 11.02264724 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 211 | 3.2000000000000008e-65 | NR | WP_013569933.1 | 870903 | g3382 | i0 | 68.7 | 2.22675367047308 | 147 | 46 | 71.9 | 0 | 591 | 151 | 99 | 245 | WP_013569933.1 SDR family oxidoreductase [Terriglobus saanensis] | diamond | 1365 | 211 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus saanensis | ||
| 31183448 | 31183448 | PRJNA541476_P_NODE_37095_length_244_cov_1.228070_g36889_i0 | PRJNA541476 | 37095 | 244 | 1.22807 | 2.9964908 | Acidobacteria bacterium OLB17 | 1617423 | Bacteria | Bacteria | 42.7 | 0.0356 | NR | KXK02870.1 | 1617423 | g36889 | i0 | 40 | 0.614754098360656 | 50 | 30 | 61.5 | 0 | 235 | 86 | 6 | 55 | KXK02870.1 MAG: hypothetical protein UZ17_ACD001001318 [Acidobacteria bacterium OLB17] | diamond | 150 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium OLB17 | ||||||
| 31310092 | 31310092 | PRJNA541476_P_NODE_17495_length_294_cov_1.366516_g17289_i0 | PRJNA541476 | 17495 | 294 | 1.366516 | 4.01755704 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 139 | 4.97e-38 | NR | MES1211409.1 | 1978231 | g17289 | i0 | 62.2 | 3 | 98 | 35 | 100 | 1 | 1 | 294 | 163 | 258 | MES1211409.1 bifunctional aspartate kinase/diaminopimelate decarboxylase [Acidobacteriota bacterium] | diamond | 882 | 139 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31373599 | 31373599 | PRJNA541476_P_NODE_10516_length_353_cov_1.960714_g10310_i0 | PRJNA541476 | 10516 | 353 | 1.960714 | 6.92132042 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 47 | 0.00415 | NR | HEX3878382.1 | 2212468 | g10310 | i0 | 35.1 | 0.654390934844193 | 77 | 46 | 62 | 2 | 108 | 326 | 558 | 634 | HEX3878382.1 caspase family protein [Bryobacteraceae bacterium] | diamond | 231 | 47 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31816224 | 31816224 | PRJNA541476_P_NODE_2577_length_735_cov_1.283988_g2392_i0 | PRJNA541476 | 2577 | 735 | 1.283988 | 9.4373118 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 47 | 0.0493 | NR | MFN0121065.1 | 2052146 | g2392 | i0 | 27.6 | 0.857142857142857 | 210 | 118 | 78.4 | 9 | 97 | 672 | 197 | 390 | MFN0121065.1 PQQ-binding-like beta-propeller repeat protein [Blastocatellia bacterium] | diamond | 630 | 47 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 32544246 | 32544246 | PRJNA541476_P_NODE_31539_length_249_cov_1.431818_g31333_i0 | PRJNA541476 | 31539 | 249 | 1.431818 | 3.56522682 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 53.5 | 6.19e-6 | NR | HEV8582174.1 | 2651171 | g31333 | i0 | 40.8 | 1.62650602409639 | 76 | 33 | 86.7 | 4 | 33 | 248 | 70 | 137 | HEV8582174.1 Vps62-related protein [Thermoanaerobaculia bacterium] | diamond | 405 | 53.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32575818 | 32575818 | PRJNA541476_P_NODE_7199_length_421_cov_1.758621_g6995_i0 | PRJNA541476 | 7199 | 421 | 1.758621 | 7.40379441 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 60.1 | 1.75e-7 | NR | HKC55295.1 | 2910147 | g6995 | i0 | 38.7 | 2.26603325415677 | 106 | 59 | 74.8 | 4 | 315 | 1 | 31 | 131 | HKC55295.1 phycobilisome rod-core linker polypeptide [Vicinamibacterales bacterium] | diamond | 954 | 60.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32858947 | 32858947 | PRJNA541476_P_NODE_32540_length_248_cov_1.485714_g32334_i0 | PRJNA541476 | 32540 | 248 | 1.485714 | 3.68457072 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 62 | 6.2e-9 | NR | TDI13400.1 | 1978231 | g32334 | i0 | 38.6 | 1.70564516129032 | 70 | 35 | 84.7 | 1 | 211 | 2 | 310 | 371 | TDI13400.1 MAG: M20/M25/M40 family metallo-hydrolase [Acidobacteriota bacterium] | diamond | 423 | 62 | 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);;