contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA576995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26858463 | 26858463 | PRJNA576995_P_NODE_7881_length_563_cov_1.165306_g7294_i0 | PRJNA576995 | 7881 | 563 | 1.165306 | 6.56067278 | Chloracidobacterium sp. | 2099375 | Bacteria | Bacteria | 46.6 | 0.0334 | NR | MBO0857070.1 | 2099375 | g7294 | i0 | 34.1 | 0.436944937833037 | 82 | 49 | 42.1 | 2 | 332 | 96 | 777 | 856 | MBO0857070.1 TonB-dependent receptor [Chloracidobacterium sp.] | diamond | 246 | 46.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium sp. | ||
| 27111008 | 27111008 | PRJNA576995_P_NODE_13002_length_419_cov_1.112717_g12410_i0 | PRJNA576995 | 13002 | 419 | 1.112717 | 4.66228423 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 66.6 | 1.12e-9 | NR | MDQ7006302.1 | 1978231 | g12410 | i0 | 32.1 | 0.98090692124105 | 137 | 86 | 95.9 | 3 | 403 | 2 | 207 | 339 | MDQ7006302.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 411 | 66.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27774711 | 27774711 | PRJNA576995_P_NODE_28164_length_288_cov_1.018605_g27572_i0 | PRJNA576995 | 28164 | 288 | 1.018605 | 2.9335824 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 43.1 | 0.0435 | NR | HSU81087.1 | 2651171 | g27572 | i0 | 39.7 | 0.760416666666667 | 73 | 35 | 66.7 | 3 | 275 | 84 | 113 | 185 | HSU81087.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 219 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28153635 | 28153635 | PRJNA576995_P_NODE_33145_length_260_cov_1.524064_g32553_i0 | PRJNA576995 | 33145 | 260 | 1.524064 | 3.9625664 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 111 | 3.47e-27 | NR | NNE67555.1 | 2283092 | g32553 | i0 | 64.9 | 3.53076923076923 | 77 | 27 | 88.8 | 0 | 238 | 8 | 1 | 77 | NNE67555.1 NAD(P)-dependent alcohol dehydrogenase [Pyrinomonadaceae bacterium] | diamond | 918 | 111 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29132387 | 29132387 | PRJNA576995_P_NODE_43009_length_241_cov_0.916667_g42417_i0 | PRJNA576995 | 43009 | 241 | 0.916667 | 2.20916747 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 78.6 | 1.57e-15 | NR | HEY0558441.1 | 2651171 | g42417 | i0 | 59.7 | 0.95850622406639 | 77 | 30 | 94.6 | 1 | 2 | 229 | 150 | 226 | HEY0558441.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 231 | 78.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29668615 | 29668615 | PRJNA576995_P_NODE_42550_length_242_cov_0.911243_g41958_i0 | PRJNA576995 | 42550 | 242 | 0.911243 | 2.20520806 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.9 | 0.0144 | NR | HEX9423353.1 | 2283092 | g41958 | i0 | 38.7 | 0.768595041322314 | 62 | 33 | 76.9 | 2 | 53 | 238 | 495 | 551 | HEX9423353.1 FAD-dependent oxidoreductase [Pyrinomonadaceae bacterium] | diamond | 186 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31881090 | 31881090 | PRJNA576995_P_NODE_29017_length_283_cov_1.466667_g28425_i0 | PRJNA576995 | 29017 | 283 | 1.466667 | 4.15066761 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 59.7 | 1.53e-8 | NR | MCU1289316.1 | 1978231 | g28425 | i0 | 44.9 | 1.80212014134276 | 69 | 38 | 73.1 | 0 | 1 | 207 | 99 | 167 | MCU1289316.1 hspA 1 [Acidobacteriota bacterium] | diamond | 510 | 59.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32451066 | 32451066 | PRJNA576995_P_NODE_43159_length_241_cov_0.916667_g42567_i0 | PRJNA576995 | 43159 | 241 | 0.916667 | 2.20916747 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 101 | 1.81e-23 | NR | HLJ46112.1 | 2212468 | g42567 | i0 | 53.8 | 1.94190871369295 | 78 | 34 | 97.1 | 1 | 2 | 235 | 183 | 258 | HLJ46112.1 NADP-dependent oxidoreductase [Bryobacteraceae bacterium] | diamond | 468 | 101 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32514361 | 32514361 | PRJNA576995_P_NODE_34759_length_251_cov_0.865169_g34167_i0 | PRJNA576995 | 34759 | 251 | 0.865169 | 2.17157419 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 160 | 3.5599999999999997e-48 | NR | MCI0390920.1 | 1978231 | g34167 | i0 | 94 | 0.99203187250996006 | 83 | 5 | 99.2 | 0 | 249 | 1 | 49 | 131 | MCI0390920.1 TlpA family protein disulfide reductase [Acidobacteriota bacterium] | diamond | 249 | 160 | 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);;