contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 474734 | 474734 | PRJNA493828_P_NODE_28481_length_260_cov_1.647059_g28062_i0 | PRJNA493828 | 28481 | 260 | 1.647059 | 4.2823534 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 106 | 7.94e-27 | NR | HEU4510996.1 | 2283092 | g28062 | i0 | 100 | 1.10769230769231 | 47 | 0 | 54.2 | 0 | 260 | 120 | 131 | 177 | HEU4510996.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 288 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 474862 | 474862 | PRJNA493828_P_NODE_37261_length_244_cov_0.900585_g36842_i0 | PRJNA493828 | 37261 | 244 | 0.900585 | 2.1974274 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 167 | 1.12e-47 | NR | MCD9187173.1 | 2283092 | g36842 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 244 | 2 | 404 | 484 | MCD9187173.1 type VI secretion system contractile sheath large subunit [Pyrinomonadaceae bacterium] | diamond | 243 | 167 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 3025810 | 3025810 | PRJNA493828_P_NODE_41863_length_234_cov_2.546584_g41444_i0 | PRJNA493828 | 41863 | 234 | 2.546584 | 5.95900656 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 145 | 2.85e-40 | NR | HJT28574.1 | 2283092 | g41444 | i0 | 92.3 | 1 | 78 | 6 | 100 | 0 | 1 | 234 | 46 | 123 | HJT28574.1 sigma-54 dependent transcriptional regulator [Pyrinomonadaceae bacterium] | diamond | 234 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 4934868 | 4934868 | PRJNA493828_P_NODE_42844_length_230_cov_3.133758_g42425_i0 | PRJNA493828 | 42844 | 230 | 3.133758 | 7.2076434 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 114 | 1.92e-28 | NR | HTH00434.1 | 2910147 | g42425 | i0 | 82.3 | 4.04347826086957 | 62 | 11 | 80.9 | 0 | 2 | 187 | 310 | 371 | HTH00434.1 lactonase family protein [Vicinamibacterales bacterium] | diamond | 930 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 26950183 | 26950183 | PRJNA493828_P_NODE_27082_length_264_cov_1.994764_g26663_i0 | PRJNA493828 | 27082 | 264 | 1.994764 | 5.26617696 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 165 | 6.54e-49 | NR | HQU86907.1 | 2283092 | g26663 | i0 | 93.1 | 4.98863636363636 | 87 | 6 | 98.9 | 0 | 1 | 261 | 152 | 238 | HQU86907.1 hydrogenase formation protein HypD [Pyrinomonadaceae bacterium] | diamond | 1317 | 165 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26981977 | 26981977 | PRJNA493828_P_NODE_33222_length_249_cov_2.232955_g32803_i0 | PRJNA493828 | 33222 | 249 | 2.232955 | 5.56005795 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 168 | 3.05e-50 | NR | HET9268245.1 | 2910147 | g32803 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 2 | 247 | 14 | 95 | HET9268245.1 PP2C family protein-serine/threonine phosphatase [Vicinamibacterales bacterium] | diamond | 246 | 168 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27361597 | 27361597 | PRJNA493828_P_NODE_32883_length_250_cov_0.870056_g32464_i0 | PRJNA493828 | 32883 | 250 | 0.870056 | 2.17514 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 54.7 | 2.48e-6 | NR | HEY6929205.1 | 2651171 | g32464 | i0 | 41.5 | 3.936 | 82 | 46 | 98.4 | 2 | 3 | 248 | 236 | 315 | HEY6929205.1 kelch repeat-containing protein [Thermoanaerobaculia bacterium] | diamond | 984 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27503475 | 27503475 | PRJNA493828_P_NODE_41123_length_236_cov_4.944785_g40704_i0 | PRJNA493828 | 41123 | 236 | 4.944785 | 11.6696926 | Acidobacteriota | 57723 | Bacteria | Bacteria | 128 | 3.02e-35 | NR | HMC73635.1 | 2282142 | g40704 | i0 | 82.7 | 4.76694915254237 | 75 | 13 | 95.3 | 0 | 2 | 226 | 115 | 189 | HMC73635.1 PP2C family protein-serine/threonine phosphatase [Terriglobales bacterium] | diamond | 1125 | 128 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27519283 | 27519283 | PRJNA493828_P_NODE_9423_length_369_cov_4.175676_g9006_i0 | PRJNA493828 | 9423 | 369 | 4.175676 | 15.40824444 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 87 | 3.84e-19 | NR | HEY8561019.1 | 2283092 | g9006 | i0 | 66.2 | 0.601626016260163 | 74 | 20 | 58.5 | 3 | 367 | 152 | 37 | 107 | HEY8561019.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 222 | 87 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27566290 | 27566290 | PRJNA493828_P_NODE_39264_length_241_cov_2.958333_g38845_i0 | PRJNA493828 | 39264 | 241 | 2.958333 | 7.12958253 | Acidobacteriota | 57723 | Bacteria | Bacteria | 142 | 1.4099999999999998e-37 | NR | MBK8464424.1 | 2099375 | g38845 | i0 | 90 | 2.98755186721992 | 80 | 8 | 99.6 | 0 | 2 | 241 | 539 | 618 | MBK8464424.1 DNA mismatch repair endonuclease MutL [Chloracidobacterium sp.] | diamond | 720 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 27803564 | 27803564 | PRJNA493828_P_NODE_48464_length_197_cov_5.524194_g48045_i0 | PRJNA493828 | 48464 | 197 | 5.524194 | 10.88266218 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 73.6 | 1.43e-13 | NR | MBA3784245.1 | 1978231 | g48045 | i0 | 72.4 | 1.84263959390863 | 58 | 15 | 86.8 | 1 | 7 | 177 | 116 | 173 | MBA3784245.1 prepilin peptidase [Acidobacteriota bacterium] | diamond | 363 | 73.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28024527 | 28024527 | PRJNA493828_P_NODE_15665_length_310_cov_2.827004_g15246_i0 | PRJNA493828 | 15665 | 310 | 2.827004 | 8.7637124 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 48.1 | 9.22e-4 | NR | HEX9000641.1 | 2052146 | g15246 | i0 | 95.7 | 0.22258064516129 | 23 | 1 | 22.3 | 0 | 240 | 308 | 1 | 23 | HEX9000641.1 TIM barrel protein [Blastocatellia bacterium] | diamond | 69 | 48.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28813518 | 28813518 | PRJNA493828_P_NODE_45108_length_218_cov_4.800000_g44689_i0 | PRJNA493828 | 45108 | 218 | 4.8 | 10.464 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 87 | 2.6e-18 | NR | HZF36679.1 | 2976921 | g44689 | i0 | 57.5 | 1.0045871559633 | 73 | 30 | 99.1 | 1 | 1 | 216 | 184 | 256 | HZF36679.1 hypothetical protein [Candidatus Angelobacter sp.] | diamond | 219 | 87 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 29098054 | 29098054 | PRJNA493828_P_NODE_20028_length_287_cov_2.887850_g19609_i0 | PRJNA493828 | 20028 | 287 | 2.88785 | 8.2881295 | Holophagaceae bacterium | 2052165 | Bacteria | Bacteria | 100 | 6.61e-23 | NR | MCE1204299.1 | 2052165 | g19609 | i0 | 70.1 | 1.4006968641115 | 67 | 20 | 70 | 0 | 286 | 86 | 287 | 353 | MCE1204299.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Holophagaceae bacterium] | diamond | 402 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae bacterium | |||
| 29287283 | 29287283 | PRJNA493828_P_NODE_27809_length_262_cov_1.629630_g27390_i0 | PRJNA493828 | 27809 | 262 | 1.62963 | 4.2696306 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 77 | 1.81e-14 | NR | MBY0372684.1 | 2212468 | g27390 | i0 | 68.7 | 0.767175572519084 | 67 | 18 | 75.6 | 3 | 214 | 17 | 5 | 69 | MBY0372684.1 DUF4384 domain-containing protein [Bryobacteraceae bacterium] | diamond | 201 | 77 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29413614 | 29413614 | PRJNA493828_P_NODE_6429_length_437_cov_2.447802_g6029_i0 | PRJNA493828 | 6429 | 437 | 2.447802 | 10.69689474 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 192 | 1.03e-59 | NR | HQU85456.1 | 2283092 | g6029 | i0 | 80.9 | 0.933638443935927 | 136 | 23 | 93.4 | 1 | 1 | 408 | 16 | 148 | HQU85456.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 408 | 192 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30756068 | 30756068 | PRJNA493828_P_NODE_33914_length_248_cov_3.017143_g33495_i0 | PRJNA493828 | 33914 | 248 | 3.017143 | 7.48251464 | Bacteria | 2 | Bacteria | Bacteria | 55.8 | 9.09e-7 | NR | PYT34377.1 | 1978231 | g33495 | i0 | 62.8 | 4.59677419354839 | 43 | 16 | 52 | 0 | 248 | 120 | 277 | 319 | PYT34377.1 MAG: aminotransferase [Acidobacteriota bacterium] | diamond | 1140 | 56.2 | 0.99288256227758 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30961643 | 30961643 | PRJNA493828_P_NODE_44334_length_225_cov_4.401316_g43915_i0 | PRJNA493828 | 44334 | 225 | 4.401316 | 9.902961 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 159 | 4.97e-49 | NR | MCC6537343.1 | 2026791 | g43915 | i0 | 98.7 | 1 | 75 | 1 | 100 | 0 | 1 | 225 | 16 | 90 | MCC6537343.1 hypothetical protein [Bryobacterales bacterium] | diamond | 225 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 30993208 | 30993208 | PRJNA493828_P_NODE_23894_length_274_cov_1.955224_g23475_i0 | PRJNA493828 | 23894 | 274 | 1.955224 | 5.35731376 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 157 | 1.28e-46 | NR | NJM52123.1 | 2052146 | g23475 | i0 | 81.3 | 0.996350364963504 | 91 | 17 | 99.6 | 0 | 274 | 2 | 9 | 99 | NJM52123.1 hypothetical protein [Blastocatellia bacterium] | diamond | 273 | 157 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31530832 | 31530832 | PRJNA493828_P_NODE_29136_length_258_cov_2.718919_g28717_i0 | PRJNA493828 | 29136 | 258 | 2.718919 | 7.01481102 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 130 | 2.84e-35 | NR | HZJ32385.1 | 2910147 | g28717 | i0 | 74.1 | 3.75581395348837 | 81 | 21 | 94.2 | 0 | 15 | 257 | 26 | 106 | HZJ32385.1 GDSL-type esterase/lipase family protein [Vicinamibacterales bacterium] | diamond | 969 | 130 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31562471 | 31562471 | PRJNA493828_P_NODE_24256_length_273_cov_1.715000_g23837_i0 | PRJNA493828 | 24256 | 273 | 1.715 | 4.68195 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 146 | 9.969999999999999e-43 | NR | MCD9187174.1 | 2283092 | g23837 | i0 | 100 | 0.791208791208791 | 72 | 0 | 79.1 | 0 | 57 | 272 | 1 | 72 | MCD9187174.1 type VI secretion system tube protein Hcp [Pyrinomonadaceae bacterium] | diamond | 216 | 146 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31846815 | 31846815 | PRJNA493828_P_NODE_26797_length_265_cov_1.604167_g26378_i0 | PRJNA493828 | 26797 | 265 | 1.604167 | 4.25104255 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 177 | 1.78e-49 | NR | MCD9185759.1 | 2283092 | g26378 | i0 | 96.4 | 0.950943396226415 | 84 | 3 | 95.1 | 0 | 5 | 256 | 604 | 687 | MCD9185759.1 TonB-dependent receptor [Pyrinomonadaceae bacterium] | diamond | 252 | 177 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31925763 | 31925763 | PRJNA493828_P_NODE_42277_length_232_cov_3.509434_g41858_i0 | PRJNA493828 | 42277 | 232 | 3.509434 | 8.14188688 | Bacteria | 2 | Bacteria | Bacteria | 159 | 4.68e-43 | NR | MBM3727883.1 | 1978231 | g41858 | i0 | 100 | 3.98275862068966 | 77 | 0 | 99.6 | 0 | 232 | 2 | 193 | 269 | MBM3727883.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 924 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32321845 | 32321845 | PRJNA493828_P_NODE_19199_length_290_cov_3.138249_g18780_i0 | PRJNA493828 | 19199 | 290 | 3.138249 | 9.1009221 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 180 | 5.989999999999998e-55 | NR | MBL8181253.1 | 2052146 | g18780 | i0 | 97.9 | 0.993103448275862 | 96 | 2 | 99.3 | 0 | 288 | 1 | 102 | 197 | MBL8181253.1 B-box zinc finger protein [Blastocatellia bacterium] | diamond | 288 | 180 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 32448334 | 32448334 | PRJNA493828_P_NODE_22979_length_277_cov_1.823529_g22560_i0 | PRJNA493828 | 22979 | 277 | 1.823529 | 5.05117533 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 98.6 | 8.930000000000001e-22 | NR | PYR32917.1 | 1978231 | g22560 | i0 | 73.8 | 0.703971119133574 | 65 | 17 | 70.4 | 0 | 276 | 82 | 395 | 459 | PYR32917.1 MAG: hypothetical protein DMF90_22550 [Acidobacteriota bacterium] | diamond | 195 | 98.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32448344 | 32448344 | PRJNA493828_P_NODE_35959_length_246_cov_0.890173_g35540_i0 | PRJNA493828 | 35959 | 246 | 0.890173 | 2.18982558 | Candidatus Sulfotelmatobacter sp. | 2771375 | Bacteria | Bacteria | 98.2 | 1.17e-21 | NR | HEY3620115.1 | 2771375 | g35540 | i0 | 55.6 | 0.98780487804878 | 81 | 36 | 98.8 | 0 | 245 | 3 | 375 | 455 | HEY3620115.1 DPP IV N-terminal domain-containing protein [Candidatus Sulfotelmatobacter sp.] | diamond | 243 | 98.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Candidatus Sulfotelmatobacter 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);;