contig_metadata
24 rows where bioproject = "PRJNA169559", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5468344 | 5468344 | PRJNA169559_P_NODE_31745_length_257_cov_8.614035_g29669_i0 | PRJNA169559 | 31745 | 257 | 8.614035 | 22.13806995 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2874253836|emb|OY969886.1| | 171953 | g29669 | i0 | 96.875 | 0.124513618677043 | 32 | 1 | 12 | 0 | 44 | 75 | 2338574 | 2338543 | MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 9293289 | 9293289 | PRJNA169559_P_NODE_6328_length_675_cov_84.348297_g4877_i0 | PRJNA169559 | 6328 | 675 | 84.348297 | 569.35100475 | uncultured Granulicella sp. | 1241325 | Bacteria | Bacteria | 1042 | 0 | NTclustered | gi|2626255659|emb|OY843766.1| | 1241325 | g4877 | i0 | 94.527 | 125.782222222222 | 676 | 35 | 100 | 2 | 1 | 675 | 3194607 | 3193933 | MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1 | blastn | 84903 | 1042 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | uncultured Granulicella sp. | ||
| 10568879 | 10568879 | PRJNA169559_P_NODE_1029_length_1591_cov_62.464149_g532_i0 | PRJNA169559 | 1029 | 1591 | 62.464149 | 993.80461059 | uncultured Granulicella sp. | 1241325 | Bacteria | Bacteria | 2617 | 0 | NTclustered | gi|2836016426|emb|OZ196157.1| | 1241325 | g532 | i0 | 96.361 | 98.7762413576367 | 1594 | 53 | 100 | 5 | 1 | 1591 | 1018306 | 1019897 | MAG: uncultured Granulicella sp. isolate 532c3363-cb9a-4ff4-a964-62ae8f4e4543 genome assembly, chromosome: 1 | blastn | 157153 | 2617 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | uncultured Granulicella sp. | ||
| 10569270 | 10569270 | PRJNA169559_P_NODE_7949_length_602_cov_83.949389_g6351_i0 | PRJNA169559 | 7949 | 602 | 83.949389 | 505.37532178 | Terriglobus roseus | 392734 | Bacteria | Bacteria | 1051 | 0 | NTclustered | gi|390410848|gb|CP003379.1| | 926566 | g6351 | i0 | 98.173 | 94.1013289036545 | 602 | 11 | 100 | 0 | 1 | 602 | 926797 | 927398 | Terriglobus roseus DSM 18391, complete genome | blastn | 56649 | 1051 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus roseus | ||
| 23316916 | 23316916 | PRJNA169559_P_NODE_1019_length_1602_cov_59.736173_g526_i0 | PRJNA169559 | 1019 | 1602 | 59.736173 | 956.97349146 | Terriglobus roseus | 392734 | Bacteria | Bacteria | 2680 | 0 | NTclustered | gi|390410848|gb|CP003379.1| | 926566 | g526 | i0 | 96.836 | 97.7609238451935 | 1612 | 35 | 100 | 14 | 1 | 1602 | 2078639 | 2077034 | Terriglobus roseus DSM 18391, complete genome | blastn | 156613 | 2680 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus roseus | ||
| 26978973 | 26978973 | PRJNA169559_P_NODE_21142_length_356_cov_1.993884_g19081_i0 | PRJNA169559 | 21142 | 356 | 1.993884 | 7.09822704 | Silvibacterium dinghuense | 1560006 | Bacteria | Bacteria | 62 | 3.38e-9 | NR | WP_164981590.1 | 1560006 | g19081 | i0 | 47.1 | 1.71910112359551 | 68 | 35 | 57.3 | 1 | 230 | 27 | 90 | 156 | WP_164981590.1 GyrI-like domain-containing protein [Silvibacterium dinghuense] | diamond | 612 | 62 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Silvibacterium | Silvibacterium dinghuense | ||
| 27755379 | 27755379 | PRJNA169559_P_NODE_44144_length_222_cov_2.165803_g42067_i0 | PRJNA169559 | 44144 | 222 | 2.165803 | 4.80808266 | Bacteria | 2 | Bacteria | Bacteria | 61.2 | 8.55e-9 | NR | PYX09814.1 | 1978231 | g42067 | i0 | 72.5 | 8.10810810810811 | 40 | 11 | 54.1 | 0 | 120 | 1 | 83 | 122 | PYX09814.1 MAG: aspartate aminotransferase family protein [Acidobacteriota bacterium] | diamond | 1800 | 61.6 | 0.993506493506494 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28305636 | 28305636 | PRJNA169559_P_NODE_7606_length_616_cov_3.011925_g6039_i0 | PRJNA169559 | 7606 | 616 | 3.011925 | 18.553458 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 75.1 | 8.17e-12 | NR | HTX34442.1 | 2212468 | g6039 | i0 | 32.9 | 1.52922077922078 | 146 | 79 | 70.6 | 3 | 159 | 593 | 226 | 353 | HTX34442.1 NHL repeat-containing protein [Bryobacteraceae bacterium] | diamond | 942 | 75.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28558390 | 28558390 | PRJNA169559_P_NODE_9647_length_546_cov_67.818182_g6613_i2 | PRJNA169559 | 9647 | 546 | 67.818182 | 370.28727372 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 91.3 | 3.55e-20 | NR | MDQ7008653.1 | 1978231 | g6613 | i2 | 62.7 | 2.25824175824176 | 83 | 30 | 45.1 | 1 | 414 | 169 | 25 | 107 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 1233 | 91.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28621520 | 28621520 | PRJNA169559_P_NODE_3287_length_917_cov_3.291667_g2232_i0 | PRJNA169559 | 3287 | 917 | 3.291667 | 30.18458639 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 80.5 | 1.24e-12 | NR | MEK6288952.1 | 1978231 | g2232 | i0 | 32.9 | 1.50490730643402 | 231 | 133 | 73.9 | 7 | 779 | 102 | 94 | 307 | MEK6288952.1 Calx-beta domain-containing protein [Acidobacteriota bacterium] | diamond | 1380 | 80.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29095117 | 29095117 | PRJNA169559_P_NODE_40408_length_234_cov_1.409756_g38331_i0 | PRJNA169559 | 40408 | 234 | 1.409756 | 3.29882904 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 42.4 | 0.0463 | NR | HYS54496.1 | 2651171 | g38331 | i0 | 35.1 | 0.948717948717949 | 74 | 46 | 94.9 | 2 | 226 | 5 | 458 | 529 | HYS54496.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 222 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29316014 | 29316014 | PRJNA169559_P_NODE_32829_length_254_cov_1.382222_g30753_i0 | PRJNA169559 | 32829 | 254 | 1.382222 | 3.51084388 | Terriglobus aquaticus | 940139 | Bacteria | Bacteria | 48.1 | 1.46e-4 | NR | WP_263414657.1 | 940139 | g30753 | i0 | 59.5 | 1.31102362204724 | 37 | 15 | 43.7 | 0 | 143 | 253 | 53 | 89 | WP_263414657.1 RidA family protein [Terriglobus aquaticus] | diamond | 333 | 48.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus aquaticus | ||
| 29473606 | 29473606 | PRJNA169559_P_NODE_9550_length_549_cov_11.861538_g7826_i0 | PRJNA169559 | 9550 | 549 | 11.861538 | 65.11984362 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 132 | 2.58e-36 | NR | MDQ7008653.1 | 1978231 | g7826 | i0 | 76.8 | 0.519125683060109 | 95 | 22 | 51.9 | 0 | 464 | 180 | 17 | 111 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 285 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29820964 | 29820964 | PRJNA169559_P_NODE_9511_length_550_cov_67.372361_g6613_i1 | PRJNA169559 | 9511 | 550 | 67.372361 | 370.5479855 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 91.3 | 3.66e-20 | NR | MDQ7008653.1 | 1978231 | g6613 | i1 | 62.7 | 2.24181818181818 | 83 | 30 | 44.7 | 1 | 418 | 173 | 25 | 107 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 1233 | 91.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30010892 | 30010892 | PRJNA169559_P_NODE_12831_length_468_cov_79.763098_g6613_i5 | PRJNA169559 | 12831 | 468 | 79.763098 | 373.29129864 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 91.3 | 1.61e-20 | NR | MDQ7008653.1 | 1978231 | g6613 | i5 | 62.7 | 2.63461538461538 | 83 | 30 | 52.6 | 1 | 336 | 91 | 25 | 107 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 1233 | 91.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30863742 | 30863742 | PRJNA169559_P_NODE_32794_length_254_cov_1.662222_g30718_i0 | PRJNA169559 | 32794 | 254 | 1.662222 | 4.22204388 | Terriglobus aquaticus | 940139 | Bacteria | Bacteria | 63.5 | 1.58e-10 | NR | WP_263414657.1 | 940139 | g30718 | i0 | 62.5 | 1.12204724409449 | 48 | 18 | 56.7 | 0 | 110 | 253 | 42 | 89 | WP_263414657.1 RidA family protein [Terriglobus aquaticus] | diamond | 285 | 63.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus aquaticus | ||
| 30958695 | 30958695 | PRJNA169559_P_NODE_10274_length_528_cov_70.210421_g6613_i4 | PRJNA169559 | 10274 | 528 | 70.210421 | 370.71102288 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 91.3 | 2.98e-20 | NR | MDQ7008653.1 | 1978231 | g6613 | i4 | 62.7 | 2.33522727272727 | 83 | 30 | 46.6 | 1 | 396 | 151 | 25 | 107 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 1233 | 91.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31464637 | 31464637 | PRJNA169559_P_NODE_396_length_3151_cov_5.296925_g145_i0 | PRJNA169559 | 396 | 3151 | 5.296925 | 166.90610675 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 178 | 1.98e-41 | NR | HYT66950.1 | 2910147 | g145 | i0 | 45.8 | 0.237067597588067 | 249 | 117 | 23.2 | 7 | 1260 | 1991 | 115 | 350 | HYT66950.1 DUF4394 domain-containing protein [Vicinamibacterales bacterium] | diamond | 747 | 178 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31591096 | 31591096 | PRJNA169559_P_NODE_2976_length_960_cov_3.266380_g1967_i0 | PRJNA169559 | 2976 | 960 | 3.26638 | 31.357248 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 56.6 | 8.78e-5 | NR | HVI73141.1 | 2283092 | g1967 | i0 | 31.9 | 1.48125 | 163 | 90 | 49.4 | 4 | 822 | 349 | 11 | 157 | HVI73141.1 Calx-beta domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 1422 | 56.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31748926 | 31748926 | PRJNA169559_P_NODE_10237_length_529_cov_69.940000_g6613_i3 | PRJNA169559 | 10237 | 529 | 69.94 | 369.9826 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 91.3 | 2.98e-20 | NR | MDQ7008653.1 | 1978231 | g6613 | i3 | 62.7 | 2.33081285444234 | 83 | 30 | 46.5 | 1 | 133 | 378 | 25 | 107 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 1233 | 91.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32002166 | 32002166 | PRJNA169559_P_NODE_8238_length_591_cov_62.446619_g6613_i0 | PRJNA169559 | 8238 | 591 | 62.446619 | 369.05951829 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 94 | 4.88e-21 | NR | MDQ7008653.1 | 1978231 | g6613 | i0 | 56.3 | 1.59390862944162 | 103 | 43 | 51.8 | 2 | 384 | 79 | 6 | 107 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 942 | 94 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32128919 | 32128919 | PRJNA169559_P_NODE_13098_length_463_cov_3.317972_g11204_i0 | PRJNA169559 | 13098 | 463 | 3.317972 | 15.36221036 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 46.2 | 0.0212 | NR | HEV8435020.1 | 2651171 | g11204 | i0 | 29.6 | 0.809935205183585 | 125 | 74 | 77.8 | 4 | 384 | 25 | 444 | 559 | HEV8435020.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 375 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32192096 | 32192096 | PRJNA169559_P_NODE_398_length_3135_cov_5.364456_g145_i1 | PRJNA169559 | 398 | 3135 | 5.364456 | 168.1756956 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 178 | 1.95e-41 | NR | HYT66950.1 | 2910147 | g145 | i1 | 45.8 | 0.238277511961722 | 249 | 117 | 23.3 | 7 | 1892 | 1161 | 115 | 350 | HYT66950.1 DUF4394 domain-containing protein [Vicinamibacterales bacterium] | diamond | 747 | 178 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32540277 | 32540277 | PRJNA169559_P_NODE_24199_length_312_cov_2.151943_g22123_i0 | PRJNA169559 | 24199 | 312 | 2.151943 | 6.71406216 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 51.2 | 8.91e-5 | NR | HLJ49807.1 | 2212468 | g22123 | i0 | 39.8 | 0.894230769230769 | 93 | 54 | 87.5 | 2 | 273 | 1 | 56 | 148 | HLJ49807.1 ankyrin repeat domain-containing protein [Bryobacteraceae bacterium] | diamond | 279 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;