contig_metadata
21 rows where bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2571552 | 2571552 | PRJEB17675_P_NODE_3023_length_567_cov_1.872180_g2754_i0 | PRJEB17675 | 3023 | 567 | 1.87218 | 10.6152606 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 898 | 0 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g2754 | i0 | 95.263 | 107.589065255732 | 570 | 22 | 100 | 3 | 1 | 567 | 3558154 | 3558721 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 61003 | 898 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26589672 | 26589672 | PRJEB17675_P_NODE_12781_length_233_cov_2.808081_g12477_i0 | PRJEB17675 | 12781 | 233 | 2.808081 | 6.54282873 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 59.3 | 4.6e-8 | NR | MBU6495465.1 | 1978231 | g12477 | i0 | 39 | 1.98283261802575 | 77 | 47 | 99.1 | 0 | 232 | 2 | 360 | 436 | MBU6495465.1 M20/M25/M40 family metallo-hydrolase [Acidobacteriota bacterium] | diamond | 462 | 59.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26653020 | 26653020 | PRJEB17675_P_NODE_16441_length_198_cov_1.055215_g16137_i0 | PRJEB17675 | 16441 | 198 | 1.055215 | 2.0893257 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 75.5 | 1.46e-14 | NR | MCU1323060.1 | 2052142 | g16137 | i0 | 49.2 | 0.984848484848485 | 65 | 33 | 98.5 | 0 | 4 | 198 | 49 | 113 | MCU1323060.1 intracellular protease, PfpI family protein [Acidobacteriaceae bacterium] | diamond | 195 | 75.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 26969748 | 26969748 | PRJEB17675_P_NODE_1602_length_772_cov_2.302578_g1400_i0 | PRJEB17675 | 1602 | 772 | 2.302578 | 17.77590216 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 85.5 | 1.09e-15 | NR | MDT5123475.1 | 1978231 | g1400 | i0 | 36.7 | 0.645077720207254 | 166 | 95 | 63 | 5 | 713 | 228 | 79 | 238 | MDT5123475.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 498 | 85.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27033102 | 27033102 | PRJEB17675_P_NODE_17782_length_188_cov_1.026144_g17478_i0 | PRJEB17675 | 17782 | 188 | 1.026144 | 1.92915072 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 53.9 | 1.86e-6 | NR | MEM9293609.1 | 1978231 | g17478 | i0 | 41.2 | 1.56382978723404 | 51 | 30 | 81.4 | 0 | 155 | 3 | 226 | 276 | MEM9293609.1 S1/P1 nuclease [Acidobacteriota bacterium] | diamond | 294 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27286000 | 27286000 | PRJEB17675_P_NODE_17343_length_191_cov_1.224359_g17039_i0 | PRJEB17675 | 17343 | 191 | 1.224359 | 2.33852569 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 65.1 | 2.1e-10 | NR | HUR99567.1 | 2283092 | g17039 | i0 | 44.3 | 0.958115183246073 | 61 | 33 | 94.2 | 1 | 181 | 2 | 197 | 257 | HUR99567.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 183 | 65.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27286001 | 27286001 | PRJEB17675_P_NODE_1823_length_725_cov_4.459420_g1604_i0 | PRJEB17675 | 1823 | 725 | 4.45942 | 32.330795 | Candidatus Polarisedimenticolaceae bacterium | 2910585 | Bacteria | Bacteria | 115 | 2.11e-27 | NR | HEX5043875.1 | 2910585 | g1604 | i0 | 41.6 | 1.35310344827586 | 154 | 78 | 59.6 | 4 | 170 | 601 | 71 | 222 | HEX5043875.1 Hsp20/alpha crystallin family protein [Candidatus Polarisedimenticolaceae bacterium] | diamond | 981 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Candidatus Polarisedimenticolia | Candidatus Polarisedimenticolales | Candidatus Polarisedimenticolaceae | Candidatus Polarisedimenticolaceae bacterium | |||
| 27728531 | 27728531 | PRJEB17675_P_NODE_17744_length_188_cov_1.307190_g17440_i0 | PRJEB17675 | 17744 | 188 | 1.30719 | 2.4575172 | Acidobacteria bacterium Mor1 | 1660251 | Bacteria | Bacteria | 65.9 | 1.26e-10 | NR | ANM28726.1 | 1660251 | g17440 | i0 | 58.1 | 0.98936170212766 | 62 | 21 | 98.9 | 2 | 2 | 187 | 404 | 460 | ANM28726.1 hypothetical protein ABI59_02535 [Acidobacteria bacterium Mor1] | diamond | 186 | 65.9 | 1 | Bacteria | Acidobacteriota subdivision 22 | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium Mor1 | |||||
| 28359507 | 28359507 | PRJEB17675_P_NODE_9386_length_288_cov_1.154150_g9082_i0 | PRJEB17675 | 9386 | 288 | 1.15415 | 3.323952 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 44.7 | 0.00909 | NR | MBZ5553162.1 | 2081523 | g9082 | i0 | 32.5 | 0.802083333333333 | 77 | 52 | 80.2 | 0 | 245 | 15 | 30 | 106 | MBZ5553162.1 hypothetical protein [Terriglobia bacterium] | diamond | 231 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28763593 | 28763593 | PRJEB17675_P_NODE_11847_length_246_cov_1.663507_g11543_i0 | PRJEB17675 | 11847 | 246 | 1.663507 | 4.09222722 | Bacteria | 2 | Bacteria | Bacteria | 56.2 | 2.13e-7 | NR | OFW37348.1 | 1797193 | g11543 | i0 | 51.1 | 1.74390243902439 | 47 | 21 | 57.3 | 1 | 1 | 141 | 113 | 157 | OFW37348.1 MAG: hypothetical protein A3J29_18605 [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_67_14b] | diamond | 429 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RIFCSPLOWO2_12_FULL_67_14b | ||||||
| 28858299 | 28858299 | PRJEB17675_P_NODE_8208_length_316_cov_2.526690_g7904_i0 | PRJEB17675 | 8208 | 316 | 2.52669 | 7.9843404 | PVC group | 1783257 | Bacteria | Bacteria | 84 | 1.18e-16 | NR | PIE01050.1 | 1978231 | g7904 | i0 | 51.3 | 11.4588607594937 | 76 | 37 | 72.2 | 0 | 230 | 3 | 3 | 78 | PIE01050.1 MAG: malate dehydrogenase [Acidobacteriota bacterium] | diamond | 3621 | 84.7 | 0.991735537190083 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28927952 | 28927952 | PRJEB17675_P_NODE_4768_length_445_cov_2.065854_g4470_i0 | PRJEB17675 | 4768 | 445 | 2.065854 | 9.1930503 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 77.8 | 1.12e-13 | NR | HVM49420.1 | 3069120 | g4470 | i0 | 32.6 | 0.950561797752809 | 141 | 91 | 93 | 3 | 445 | 32 | 43 | 182 | HVM49420.1 TlpA disulfide reductase family protein [Candidatus Acidiferrum sp.] | diamond | 423 | 77.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 29054421 | 29054421 | PRJEB17675_P_NODE_2508_length_623_cov_4.911565_g2264_i0 | PRJEB17675 | 2508 | 623 | 4.911565 | 30.59904995 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 121 | 6.1899999999999995e-30 | NR | HEX3280956.1 | 2283092 | g2264 | i0 | 45.8 | 2.08025682182986 | 144 | 77 | 69.3 | 1 | 1 | 432 | 103 | 245 | HEX3280956.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 1296 | 121 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29243764 | 29243764 | PRJEB17675_P_NODE_17469_length_190_cov_1.290323_g17165_i0 | PRJEB17675 | 17469 | 190 | 1.290323 | 2.4516137 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 45.8 | 0.00151 | NR | HLK63344.1 | 2212468 | g17165 | i0 | 40.6 | 2.05263157894737 | 64 | 32 | 99.5 | 3 | 2 | 190 | 358 | 416 | HLK63344.1 metallophosphoesterase [Bryobacteraceae bacterium] | diamond | 390 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30318061 | 30318061 | PRJEB17675_P_NODE_18932_length_180_cov_1.655172_g18628_i0 | PRJEB17675 | 18932 | 180 | 1.655172 | 2.9793096 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 51.2 | 2.54e-6 | NR | MBC7798347.1 | 2283092 | g18628 | i0 | 60 | 1.8 | 35 | 14 | 58.3 | 0 | 1 | 105 | 75 | 109 | MBC7798347.1 DUF962 domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 324 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30412635 | 30412635 | PRJEB17675_P_NODE_4793_length_444_cov_1.564792_g4495_i0 | PRJEB17675 | 4793 | 444 | 1.564792 | 6.94767648 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 61.6 | 7.42e-8 | NR | HEV2349959.1 | 2081523 | g4495 | i0 | 40.6 | 1.07432432432432 | 96 | 50 | 61.5 | 3 | 15 | 287 | 168 | 261 | HEV2349959.1 kelch repeat-containing protein [Terriglobia bacterium] | diamond | 477 | 61.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 30854586 | 30854586 | PRJEB17675_P_NODE_1014_length_950_cov_5.206557_g859_i0 | PRJEB17675 | 1014 | 950 | 5.206557 | 49.4622915 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 310 | 1.1899999999999995e-101 | NR | MFN7987048.1 | 2651171 | g859 | i0 | 64.7 | 2.18210526315789 | 238 | 80 | 74.5 | 2 | 946 | 239 | 72 | 307 | MFN7987048.1 zinc metalloprotease [Thermoanaerobaculia bacterium] | diamond | 2073 | 310 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 31075944 | 31075944 | PRJEB17675_P_NODE_4395_length_466_cov_2.164733_g4098_i0 | PRJEB17675 | 4395 | 466 | 2.164733 | 10.08765578 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 114 | 3.98e-27 | NR | MDR3737318.1 | 2052142 | g4098 | i0 | 45.6 | 0.946351931330472 | 147 | 71 | 91.4 | 4 | 1 | 426 | 165 | 307 | MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 441 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 31803008 | 31803008 | PRJEB17675_P_NODE_19517_length_177_cov_0.957746_g19213_i0 | PRJEB17675 | 19517 | 177 | 0.957746 | 1.69521042 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 64.7 | 2.69e-10 | NR | HTA41332.1 | 2212468 | g19213 | i0 | 55.2 | 0.983050847457627 | 58 | 25 | 98.3 | 1 | 3 | 176 | 220 | 276 | HTA41332.1 M28 family peptidase [Bryobacteraceae bacterium] | diamond | 174 | 64.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31923220 | 31923220 | PRJEB17675_P_NODE_1097_length_918_cov_5.730464_g934_i0 | PRJEB17675 | 1097 | 918 | 5.730464 | 52.60565952 | Bacteria | 2 | Bacteria | Bacteria | 333 | 4.76e-111 | NR | MEP7354945.1 | 1978231 | g934 | i0 | 60.9 | 23.6307189542484 | 279 | 102 | 91.2 | 3 | 914 | 78 | 5 | 276 | MEP7354945.1 aldolase/citrate lyase family protein [Acidobacteriota bacterium] | diamond | 21693 | 334 | 0.997005988023952 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32056215 | 32056215 | PRJEB17675_P_NODE_18358_length_184_cov_1.342282_g18054_i0 | PRJEB17675 | 18358 | 184 | 1.342282 | 2.46979888 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 57.4 | 1.15e-7 | NR | MXY16799.1 | 1978231 | g18054 | i0 | 49.1 | 0.896739130434783 | 55 | 26 | 89.7 | 1 | 181 | 17 | 254 | 306 | MXY16799.1 Glu/Leu/Phe/Val dehydrogenase [Acidobacteriota bacterium] | diamond | 165 | 57.4 | 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);;