contig_metadata
19 rows where bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 357026 | 357026 | PRJNA1249535_S_NODE_260301_length_274_cov_3.815920_g256918_i0 | PRJNA1249535 | 260301 | 274 | 3.81592 | 10.4556208 | Sulfidibacter corallicola | 2818388 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2013124720|gb|CP071793.1| | 2818388 | g256918 | i0 | 100 | 0.105839416058394 | 29 | 0 | 11 | 0 | 226 | 254 | 534362 | 534390 | Sulfidibacter corallicola strain M133 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Acanthopleuribacterales | Acanthopleuribacteraceae | Sulfidibacter | Sulfidibacter corallicola | ||
| 15660073 | 15660073 | PRJNA1249535_S_NODE_263753_length_272_cov_4.477387_g260370_i0 | PRJNA1249535 | 263753 | 272 | 4.477387 | 12.17849264 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 52.8 | 0.025 | NTclustered | gi|2874253980|emb|OY970305.1| | 194844 | g260370 | i0 | 100 | 0.102941176470588 | 28 | 0 | 10 | 0 | 33 | 60 | 1766496 | 1766523 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD03726.bin.c.10 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 27105139 | 27105139 | PRJNA1249535_S_NODE_169802_length_323_cov_2.956000_g166419_i0 | PRJNA1249535 | 169802 | 323 | 2.956 | 9.54788 | Holophagaceae bacterium | 2052165 | Bacteria | Bacteria | 87.8 | 5.84e-19 | NR | HJV89547.1 | 2052165 | g166419 | i0 | 44.8 | 0.975232198142415 | 105 | 56 | 97.5 | 1 | 1 | 315 | 68 | 170 | HJV89547.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Holophagaceae bacterium] | diamond | 315 | 87.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae bacterium | |||
| 27547673 | 27547673 | PRJNA1249535_S_NODE_283324_length_262_cov_1.693122_g279941_i0 | PRJNA1249535 | 283324 | 262 | 1.693122 | 4.43597964 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0473 | NR | MEM8998310.1 | 1978231 | g279941 | i0 | 30.6 | 0.709923664122137 | 62 | 43 | 71 | 0 | 68 | 253 | 532 | 593 | MEM8998310.1 penicillin acylase family protein [Acidobacteriota bacterium] | diamond | 186 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27579151 | 27579151 | PRJNA1249535_S_NODE_126104_length_351_cov_14.863309_g122721_i0 | PRJNA1249535 | 126104 | 351 | 14.863309 | 52.17021459 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 41.6 | 0.0433 | NR | GIU80903.1 | 2212468 | g122721 | i0 | 38.8 | 0.572649572649573 | 67 | 36 | 54.7 | 2 | 327 | 136 | 5 | 69 | GIU80903.1 MAG: hypothetical protein KatS3mg005_4141 [Bryobacteraceae bacterium] | diamond | 201 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28337018 | 28337018 | PRJNA1249535_S_NODE_175966_length_319_cov_5.199187_g172583_i0 | PRJNA1249535 | 175966 | 319 | 5.199187 | 16.58540653 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.0142 | NR | MEP7012518.1 | 1978231 | g172583 | i0 | 36.5 | 0.695924764890282 | 74 | 45 | 68.7 | 2 | 273 | 55 | 302 | 374 | MEP7012518.1 tetratricopeptide repeat protein [Acidobacteriota bacterium] | diamond | 222 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28400186 | 28400186 | PRJNA1249535_S_NODE_288646_length_259_cov_1.827957_g285263_i0 | PRJNA1249535 | 288646 | 259 | 1.827957 | 4.73440863 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.9 | 0.0166 | NR | MCI0408320.1 | 1978231 | g285263 | i0 | 40.9 | 1.52895752895753 | 66 | 27 | 66 | 2 | 84 | 254 | 99 | 161 | MCI0408320.1 pyridine nucleotide-disulfide oxidoreductase [Acidobacteriota bacterium] | diamond | 396 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28936999 | 28936999 | PRJNA1249535_S_NODE_205068_length_303_cov_5.586957_g201685_i0 | PRJNA1249535 | 205068 | 303 | 5.586957 | 16.92847971 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 42 | 0.0492 | NR | HLI83616.1 | 2212468 | g201685 | i0 | 54.8 | 0.306930693069307 | 31 | 14 | 30.7 | 0 | 134 | 42 | 66 | 96 | HLI83616.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 93 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29031911 | 29031911 | PRJNA1249535_S_NODE_308048_length_248_cov_4.948571_g304665_i0 | PRJNA1249535 | 308048 | 248 | 4.948571 | 12.27245608 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 40 | 0.0499 | NR | MDQ6786973.1 | 1978231 | g304665 | i0 | 39 | 0.713709677419355 | 59 | 29 | 62.9 | 1 | 223 | 68 | 1 | 59 | MDQ6786973.1 16S rRNA (adenine(1518)-N(6)/adenine(1519)-N(6))-dimethyltransferase [Acidobacteriota bacterium] | diamond | 177 | 40 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29189682 | 29189682 | PRJNA1249535_S_NODE_260109_length_274_cov_4.517413_g256726_i0 | PRJNA1249535 | 260109 | 274 | 4.517413 | 12.37771162 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0392 | NR | MBI3950142.1 | 1978231 | g256726 | i0 | 31.9 | 0.788321167883212 | 72 | 44 | 77.7 | 2 | 243 | 31 | 128 | 195 | MBI3950142.1 glutamate--tRNA ligase [Acidobacteriota bacterium] | diamond | 216 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29315842 | 29315842 | PRJNA1249535_S_NODE_327969_length_236_cov_2.595092_g324586_i0 | PRJNA1249535 | 327969 | 236 | 2.595092 | 6.12441712 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 42.4 | 0.0466 | NR | HMB51991.1 | 2651171 | g324586 | i0 | 43.5 | 0.584745762711864 | 46 | 24 | 55.9 | 1 | 13 | 144 | 74 | 119 | HMB51991.1 multiheme c-type cytochrome [Thermoanaerobaculia bacterium] | diamond | 138 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29978984 | 29978984 | PRJNA1249535_S_NODE_315631_length_244_cov_6.233918_g312248_i0 | PRJNA1249535 | 315631 | 244 | 6.233918 | 15.21075992 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 42 | 0.0368 | NR | HEX5084671.1 | 2052146 | g312248 | i0 | 37.7 | 0.651639344262295 | 53 | 33 | 65.2 | 0 | 162 | 4 | 1 | 53 | HEX5084671.1 beta-L-arabinofuranosidase domain-containing protein [Blastocatellia bacterium] | diamond | 159 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30831912 | 30831912 | PRJNA1249535_S_NODE_150374_length_335_cov_2.740458_g146991_i0 | PRJNA1249535 | 150374 | 335 | 2.740458 | 9.1805343 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.5 | 0.0376 | NR | HEY6121378.1 | 2283092 | g146991 | i0 | 34.3 | 0.6 | 67 | 38 | 60 | 2 | 69 | 269 | 82 | 142 | HEY6121378.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 201 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31432473 | 31432473 | PRJNA1249535_S_NODE_112296_length_363_cov_3.034483_g108913_i0 | PRJNA1249535 | 112296 | 363 | 3.034483 | 11.01517329 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 95.1 | 6.57e-20 | NR | MCY3929922.1 | 1978231 | g108913 | i0 | 53.2 | 1.30578512396694 | 79 | 37 | 65.3 | 0 | 126 | 362 | 500 | 578 | MCY3929922.1 reverse transcriptase domain-containing protein [Acidobacteriota bacterium] | diamond | 474 | 95.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32223468 | 32223468 | PRJNA1249535_S_NODE_158198_length_330_cov_2.754864_g154815_i0 | PRJNA1249535 | 158198 | 330 | 2.754864 | 9.0910512 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 46.2 | 0.00553 | NR | MCM3869231.1 | 2283092 | g154815 | i0 | 30.3 | 1.38181818181818 | 76 | 45 | 63.6 | 3 | 60 | 269 | 129 | 202 | MCM3869231.1 Fic family protein [Pyrinomonadaceae bacterium] | diamond | 456 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32445180 | 32445180 | PRJNA1249535_S_NODE_313299_length_246_cov_1.352601_g309916_i0 | PRJNA1249535 | 313299 | 246 | 1.352601 | 3.32739846 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.8 | 0.00318 | NR | RPJ63142.1 | 1978231 | g309916 | i0 | 31.1 | 1.80487804878049 | 74 | 51 | 90.2 | 0 | 234 | 13 | 216 | 289 | RPJ63142.1 MAG: phospholipid carrier-dependent glycosyltransferase, partial [Acidobacteriota bacterium] | diamond | 444 | 45.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32634202 | 32634202 | PRJNA1249535_S_NODE_330180_length_234_cov_2.552795_g326797_i0 | PRJNA1249535 | 330180 | 234 | 2.552795 | 5.9735403 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0323 | NR | MBV9210182.1 | 1978231 | g326797 | i0 | 43.5 | 0.58974358974359 | 46 | 26 | 59 | 0 | 74 | 211 | 213 | 258 | MBV9210182.1 glycosyltransferase family 39 protein [Acidobacteriota bacterium] | diamond | 138 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32715295 | 32715295 | PRJNA1249535_S_NODE_156160_length_331_cov_3.844961_g152777_i0 | PRJNA1249535 | 156160 | 331 | 3.844961 | 12.72682091 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 97.4 | 1.09e-22 | NR | OFW37905.1 | 1797188 | g152777 | i0 | 47.2 | 10.785498489426 | 106 | 49 | 93.4 | 3 | 317 | 9 | 43 | 144 | OFW37905.1 MAG: ATP-dependent Clp endopeptidase, proteolytic subunit ClpP [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_60_22] | diamond | 3570 | 98.2 | 0.991853360488798 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RIFCSPLOWO2_12_FULL_60_22 | ||||||
| 32854744 | 32854744 | PRJNA1249535_S_NODE_201700_length_305_cov_3.887931_g198317_i0 | PRJNA1249535 | 201700 | 305 | 3.887931 | 11.85818955 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.5 | 0.038 | NR | MBM3784234.1 | 1978231 | g198317 | i0 | 51 | 0.481967213114754 | 49 | 24 | 48.2 | 0 | 269 | 123 | 148 | 196 | MBM3784234.1 DUF3500 domain-containing protein [Acidobacteriota bacterium] | diamond | 147 | 43.5 | 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);;