contig_metadata
17 rows where bioproject = "PRJNA274362", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6748367 | 6748367 | PRJNA274362_S_NODE_28846_length_177_cov_0.812500_g28726_i0 | PRJNA274362 | 28846 | 177 | 0.8125 | 1.438125 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 228 | 2.3099999999999997e-55 | NTclustered | gi|2874253677|emb|OY969111.1| | 171953 | g28726 | i0 | 89.944 | 420.050847457627 | 179 | 14 | 100 | 4 | 1 | 177 | 715842 | 716018 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 | blastn | 74349 | 228 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6748430 | 6748430 | PRJNA274362_S_NODE_32106_length_169_cov_0.866667_g31986_i0 | PRJNA274362 | 32106 | 169 | 0.866667 | 1.46466723 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 156 | 1.05e-33 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g31986 | i0 | 83.237 | 229.10650887574 | 173 | 25 | 100 | 2 | 1 | 169 | 2368258 | 2368430 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 38719 | 156 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 8023840 | 8023840 | PRJNA274362_S_NODE_20287_length_205_cov_1.211538_g20167_i0 | PRJNA274362 | 20287 | 205 | 1.211538 | 2.4836529 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 326 | 9.55e-85 | NTclustered | gi|112980873|gb|DQ829677.1| | 171953 | g20167 | i0 | 96.02 | 310.439024390244 | 201 | 6 | 98 | 2 | 6 | 205 | 1538 | 1339 | Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence | blastn | 63640 | 326 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 9298877 | 9298877 | PRJNA274362_S_NODE_35748_length_164_cov_1.069565_g35628_i0 | PRJNA274362 | 35748 | 164 | 1.069565 | 1.7540866 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 281 | 1.6000000000000001e-71 | NTclustered | gi|31789410|gb|AY281354.1| | 171953 | g35628 | i0 | 97.561 | 99.2682926829268 | 164 | 4 | 100 | 0 | 1 | 164 | 37605 | 37442 | Uncultured Acidobacteria bacterium clone 38c7 genomic sequence | blastn | 16280 | 281 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 11849281 | 11849281 | PRJNA274362_S_NODE_28090_length_179_cov_1.076923_g27970_i0 | PRJNA274362 | 28090 | 179 | 1.076923 | 1.92769217 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 287 | 3.82e-73 | NTclustered | gi|31789387|gb|AY281353.1| | 171953 | g27970 | i0 | 96.023 | 272.094972067039 | 176 | 7 | 98 | 0 | 1 | 176 | 29593 | 29418 | Uncultured Acidobacteria bacterium clone 32d1 genomic sequence | blastn | 48705 | 287 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 11849386 | 11849386 | PRJNA274362_S_NODE_33290_length_167_cov_1.305085_g33170_i0 | PRJNA274362 | 33290 | 167 | 1.305085 | 2.17949195 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 204 | 3.65e-48 | NTclustered | gi|31789363|gb|AY281352.1| | 171953 | g33170 | i0 | 88.824 | 151.137724550898 | 170 | 13 | 100 | 6 | 1 | 167 | 4165 | 3999 | Uncultured Acidobacteria bacterium clone 23k22 genomic sequence | blastn | 25240 | 204 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 15673040 | 15673040 | PRJNA274362_S_NODE_12753_length_248_cov_3.959799_g12633_i0 | PRJNA274362 | 12753 | 248 | 3.959799 | 9.82030152 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 357 | 4.24e-94 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g12633 | i0 | 93.061 | 104.241935483871 | 245 | 16 | 100 | 1 | 4 | 248 | 3558344 | 3558101 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 25852 | 357 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 17636171 | 17636171 | PRJNA274362_S_NODE_22254_length_197_cov_1.837838_g22134_i0 | PRJNA274362 | 22254 | 197 | 1.837838 | 3.62054086 | Bacteria | 2 | Bacteria | Bacteria | 315 | 1.9699999999999998e-81 | NTclustered | gi|76574290|gb|DQ139438.1| | 171953 | g22134 | i0 | 95.431 | 99.2741116751269 | 197 | 9 | 100 | 0 | 1 | 197 | 572 | 768 | Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence | blastn | 19557 | 315 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22047019 | 22047019 | PRJNA274362_S_NODE_21238_length_201_cov_1.394737_g21118_i0 | PRJNA274362 | 21238 | 201 | 1.394737 | 2.80342137 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 244 | 2.69e-60 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g21118 | i0 | 93.333 | 260.393034825871 | 165 | 11 | 82 | 0 | 35 | 199 | 4784651 | 4784815 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 52339 | 244 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 23322481 | 23322481 | PRJNA274362_S_NODE_19459_length_208_cov_2.000000_g19339_i0 | PRJNA274362 | 19459 | 208 | 2 | 4.16 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 381 | 2.0499999999999995e-101 | NTclustered | gi|157142641|gb|EU122912.1| | 171953 | g19339 | i0 | 100 | 98.7548076923077 | 206 | 0 | 99 | 0 | 1 | 206 | 212 | 7 | Uncultured Acidobacteria bacterium clone REF-050 16S ribosomal RNA gene, partial sequence | blastn | 20541 | 381 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 27136837 | 27136837 | PRJNA274362_S_NODE_36762_length_163_cov_0.912281_g36642_i0 | PRJNA274362 | 36762 | 163 | 0.912281 | 1.48701803 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 91.7 | 6.37e-20 | NR | HEY2495666.1 | 2976921 | g36642 | i0 | 80.8 | 0.957055214723926 | 52 | 10 | 95.7 | 0 | 3 | 158 | 271 | 322 | HEY2495666.1 glycerol kinase GlpK [Candidatus Angelobacter sp.] | diamond | 156 | 91.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 27547953 | 27547953 | PRJNA274362_S_NODE_17984_length_215_cov_1.500000_g17864_i0 | PRJNA274362 | 17984 | 215 | 1.5 | 3.225 | Candidatus Korobacter sp. | 2510641 | Bacteria | Bacteria | 43.5 | 0.014 | NR | HEY3926946.1 | 2510641 | g17864 | i0 | 35.6 | 1.01860465116279 | 73 | 43 | 96.3 | 1 | 214 | 8 | 326 | 398 | HEY3926946.1 SLBB domain-containing protein [Candidatus Korobacter sp.] | diamond | 219 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Korobacter | Candidatus Korobacter sp. | ||
| 28148058 | 28148058 | PRJNA274362_S_NODE_30785_length_172_cov_0.813008_g30665_i0 | PRJNA274362 | 30785 | 172 | 0.813008 | 1.39837376 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 39.7 | 0.0313 | NR | HJW95184.1 | 2651171 | g30665 | i0 | 54.3 | 0.61046511627907 | 35 | 16 | 61 | 0 | 3 | 107 | 2 | 36 | HJW95184.1 2-oxoisovalerate dehydrogenase [Thermoanaerobaculia bacterium] | diamond | 105 | 39.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28905448 | 28905448 | PRJNA274362_S_NODE_28268_length_178_cov_1.573643_g28148_i0 | PRJNA274362 | 28268 | 178 | 1.573643 | 2.80108454 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.4 | 4.52e-4 | NR | MDQ7008653.1 | 1978231 | g28148 | i0 | 65.9 | 0.691011235955056 | 41 | 14 | 69.1 | 0 | 55 | 177 | 8 | 48 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 123 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31545671 | 31545671 | PRJNA274362_S_NODE_25976_length_185_cov_1.411765_g25856_i0 | PRJNA274362 | 25976 | 185 | 1.411765 | 2.61176525 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 115 | 1.98e-29 | NR | HEX8472789.1 | 2283092 | g25856 | i0 | 91.8 | 10.7837837837838 | 61 | 5 | 98.9 | 0 | 183 | 1 | 39 | 99 | HEX8472789.1 glycoside hydrolase family 19 protein [Pyrinomonadaceae bacterium] | diamond | 1995 | 116 | 0.991379310344828 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32413727 | 32413727 | PRJNA274362_S_NODE_27479_length_180_cov_2.198473_g27359_i0 | PRJNA274362 | 27479 | 180 | 2.198473 | 3.9572514 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 67.4 | 3.1e-11 | NR | MDR3736699.1 | 2052142 | g27359 | i0 | 52.5 | 0.983333333333333 | 59 | 28 | 98.3 | 0 | 179 | 3 | 337 | 395 | MDR3736699.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 177 | 67.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 32697621 | 32697621 | PRJNA274362_S_NODE_36060_length_164_cov_0.895652_g35940_i0 | PRJNA274362 | 36060 | 164 | 0.895652 | 1.46886928 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 47.4 | 2.99e-4 | NR | HKR11015.1 | 2283092 | g35940 | i0 | 60.6 | 0.603658536585366 | 33 | 13 | 60.4 | 0 | 36 | 134 | 138 | 170 | HKR11015.1 hemopexin repeat-containing protein [Pyrinomonadaceae bacterium] | diamond | 99 | 47.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;