contig_metadata
13 rows where bioproject = "PRJNA667863", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4991774 | 4991774 | PRJNA667863_P_NODE_1064_length_491_cov_2.354067_g1031_i0 | PRJNA667863 | 1064 | 491 | 2.354067 | 11.55846897 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 784 | 0 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g1031 | i0 | 95.528 | 134.598778004073 | 492 | 19 | 100 | 2 | 1 | 491 | 3299369 | 3298880 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 66088 | 787 | 0.996188055908513 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 7012450 | 7012450 | PRJNA667863_P_NODE_11966_length_250_cov_0.870056_g11932_i0 | PRJNA667863 | 11966 | 250 | 0.870056 | 2.17514 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 153 | 2e-43 | NR | MEO7274018.1 | 2910147 | g11932 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 2 | 250 | 199 | 281 | MEO7274018.1 M28 family peptidase [Vicinamibacterales bacterium] | diamond | 249 | 153 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 12642778 | 12642778 | PRJNA667863_P_NODE_5250_length_298_cov_2.573333_g5216_i0 | PRJNA667863 | 5250 | 298 | 2.573333 | 7.66853234 | Bacteria | 2 | Bacteria | Bacteria | 496 | 1.06e-135 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g5216 | i0 | 96.644 | 152.244966442953 | 298 | 10 | 100 | 0 | 1 | 298 | 4841781 | 4841484 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 45369 | 501 | 0.99001996007984 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 27050102 | 27050102 | PRJNA667863_P_NODE_9442_length_261_cov_1.367021_g9408_i0 | PRJNA667863 | 9442 | 261 | 1.367021 | 3.56792481 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.4 | 0.0048 | NR | GMU63875.1 | 1978231 | g9408 | i0 | 39.5 | 3.81609195402299 | 81 | 41 | 93.1 | 3 | 2 | 244 | 74 | 146 | GMU63875.1 MAG: quinone oxidoreductase [Acidobacteriota bacterium] | diamond | 996 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27820316 | 27820316 | PRJNA667863_P_NODE_10904_length_252_cov_4.581006_g10870_i0 | PRJNA667863 | 10904 | 252 | 4.581006 | 11.54413512 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 2.65e-26 | NR | OFV81400.1 | 1797171 | g10870 | i0 | 57.8 | 9.88095238095238 | 83 | 35 | 98.8 | 0 | 250 | 2 | 137 | 219 | OFV81400.1 MAG: dioxygenase [Acidobacteria bacterium RBG_13_68_16] | diamond | 2490 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RBG_13_68_16 | ||||||
| 27965938 | 27965938 | PRJNA667863_P_NODE_18665_length_226_cov_2.568627_g18631_i0 | PRJNA667863 | 18665 | 226 | 2.568627 | 5.80509702 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 144 | 1.93e-40 | NR | HEY8561679.1 | 2283092 | g18631 | i0 | 90.4 | 2.96017699115044 | 73 | 7 | 96.9 | 0 | 2 | 220 | 80 | 152 | HEY8561679.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 669 | 144 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28408073 | 28408073 | PRJNA667863_P_NODE_10406_length_255_cov_2.439560_g10372_i0 | PRJNA667863 | 10406 | 255 | 2.43956 | 6.220878 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 125 | 1.3899999999999998e-32 | NR | HEY6362167.1 | 2910147 | g10372 | i0 | 77.8 | 0.952941176470588 | 81 | 18 | 95.3 | 0 | 254 | 12 | 266 | 346 | HEY6362167.1 DUF3810 family protein [Vicinamibacterales bacterium] | diamond | 243 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28439731 | 28439731 | PRJNA667863_P_NODE_2206_length_383_cov_3.012903_g2172_i0 | PRJNA667863 | 2206 | 383 | 3.012903 | 11.53941849 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 57.8 | 9.48e-7 | NR | QQS48225.1 | 1978231 | g2172 | i0 | 50.9 | 0.415143603133159 | 53 | 25 | 41.5 | 1 | 234 | 76 | 259 | 310 | QQS48225.1 MAG: hypothetical protein IPM66_06180 [Acidobacteriota bacterium] | diamond | 159 | 57.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28483260 | 28483260 | PRJNA667863_P_NODE_4846_length_305_cov_2.758621_g4812_i0 | PRJNA667863 | 4846 | 305 | 2.758621 | 8.41379405 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 81.6 | 1.7e-15 | NR | PYV17540.1 | 1978231 | g4812 | i0 | 51.1 | 1.75081967213115 | 88 | 37 | 84.6 | 3 | 31 | 288 | 84 | 167 | PYV17540.1 MAG: hypothetical protein DMG21_08170 [Acidobacteriota bacterium] | diamond | 534 | 81.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28786724 | 28786724 | PRJNA667863_P_NODE_14847_length_245_cov_0.895349_g14813_i0 | PRJNA667863 | 14847 | 245 | 0.895349 | 2.19360505 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 149 | 3.63e-41 | NR | HEY2822687.1 | 3069120 | g14813 | i0 | 92.6 | 0.991836734693878 | 81 | 6 | 99.2 | 0 | 2 | 244 | 12 | 92 | HEY2822687.1 MFS transporter [Candidatus Acidiferrum sp.] | diamond | 243 | 149 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 29702168 | 29702168 | PRJNA667863_P_NODE_1350_length_449_cov_2.819149_g1316_i0 | PRJNA667863 | 1350 | 449 | 2.819149 | 12.65797901 | Candidatus Acidiferrum sp. | 3069120 | Bacteria | Bacteria | 63.5 | 1.89e-8 | NR | HVM47257.1 | 3069120 | g1316 | i0 | 45 | 0.534521158129176 | 80 | 40 | 52.8 | 2 | 204 | 440 | 67 | 143 | HVM47257.1 hypothetical protein [Candidatus Acidiferrum sp.] | diamond | 240 | 63.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrum | Candidatus Acidiferrum sp. | |||
| 30535946 | 30535946 | PRJNA667863_P_NODE_6533_length_283_cov_1.195238_g6499_i0 | PRJNA667863 | 6533 | 283 | 1.195238 | 3.38252354 | Bacteria | 2 | Bacteria | Bacteria | 50.4 | 1.08e-4 | NR | MDE3156438.1 | 1978231 | g6499 | i0 | 53.5 | 1.36749116607774 | 43 | 20 | 45.6 | 0 | 76 | 204 | 155 | 197 | MDE3156438.1 thrombospondin type-1 domain-containing protein [Acidobacteriota bacterium] | diamond | 387 | 50.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31788165 | 31788165 | PRJNA667863_P_NODE_6077_length_287_cov_1.537383_g6043_i0 | PRJNA667863 | 6077 | 287 | 1.537383 | 4.41228921 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 46.2 | 0.00368 | NR | HMB54986.1 | 2651171 | g6043 | i0 | 35.3 | 1.81881533101045 | 85 | 52 | 87.8 | 2 | 25 | 276 | 320 | 402 | HMB54986.1 wax ester/triacylglycerol synthase family O-acyltransferase [Thermoanaerobaculia bacterium] | diamond | 522 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia 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);;