contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA971676" and tax_phylum = "Candidatus Aerophobota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3495279 | 3495279 | PRJNA971676_P_NODE_17763_length_247_cov_0.885057_g17674_i0 | PRJNA971676 | 17763 | 247 | 0.885057 | 2.18609079 | Candidatus Aerophobota bacterium | 2030807 | Bacteria | Bacteria | 164 | 9.55e-47 | NR | HDZ50087.1 | 2030807 | g17674 | i0 | 98.8 | 0.983805668016194 | 81 | 1 | 98.4 | 0 | 3 | 245 | 250 | 330 | HDZ50087.1 phosphomethylpyrimidine synthase ThiC [Candidatus Aerophobetes bacterium] | diamond | 243 | 164 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 27342243 | 27342243 | PRJNA971676_P_NODE_19043_length_246_cov_0.890173_g18954_i0 | PRJNA971676 | 19043 | 246 | 0.890173 | 2.18982558 | Candidatus Aerophobota bacterium | 2030807 | Bacteria | Bacteria | 82.8 | 2.87e-16 | NR | MCK4617260.1 | 2030807 | g18954 | i0 | 51.3 | 0.951219512195122 | 78 | 38 | 95.1 | 0 | 236 | 3 | 184 | 261 | MCK4617260.1 hypothetical protein [Candidatus Aerophobetes bacterium] | diamond | 234 | 82.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 27658034 | 27658034 | PRJNA971676_P_NODE_20244_length_244_cov_0.900585_g20155_i0 | PRJNA971676 | 20244 | 244 | 0.900585 | 2.1974274 | Candidatus Aerophobetes bacterium | 2030807 | Bacteria | Bacteria | 145 | 3.98e-38 | NR | TEU02904.1 | 2030807 | g20155 | i0 | 91.4 | 1.95491803278689 | 81 | 7 | 99.6 | 0 | 1 | 243 | 507 | 587 | TEU02904.1 MAG: DNA-directed RNA polymerase subunit beta [Candidatus Aerophobetes bacterium] | diamond | 477 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobota bacterium | ||||||
| 27822174 | 27822174 | PRJNA971676_P_NODE_14004_length_251_cov_0.865169_g13915_i0 | PRJNA971676 | 14004 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 136 | 6.85e-36 | NR | TKJ46869.1 | 2012485 | g13915 | i0 | 93.2 | 1.76892430278884 | 74 | 5 | 88.4 | 0 | 1 | 222 | 390 | 463 | TKJ46869.1 MAG: hypothetical protein CEE34_06700 [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 444 | 136 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a | ||||||
| 29394469 | 29394469 | PRJNA971676_P_NODE_15369_length_250_cov_0.870056_g15280_i0 | PRJNA971676 | 15369 | 250 | 0.870056 | 2.17514 | Candidatus Aerophobetes bacterium Ae_b3b | 2012486 | Bacteria | Bacteria | 159 | 1.6299999999999999e-43 | NR | TKJ45774.1 | 2012486 | g15280 | i0 | 92.6 | 1.956 | 81 | 6 | 97.2 | 0 | 3 | 245 | 305 | 385 | TKJ45774.1 MAG: transketolase [Candidatus Aerophobetes bacterium Ae_b3b] | diamond | 489 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3b | ||||||
| 29646578 | 29646578 | PRJNA971676_P_NODE_23110_length_241_cov_0.916667_g23021_i0 | PRJNA971676 | 23110 | 241 | 0.916667 | 2.20916747 | Candidatus Aerophobetes bacterium Ae_b3b | 2012486 | Bacteria | Bacteria | 149 | 1.59e-42 | NR | TKJ41455.1 | 2012486 | g23021 | i0 | 96.3 | 0.995850622406639 | 80 | 3 | 99.6 | 0 | 241 | 2 | 130 | 209 | TKJ41455.1 MAG: ribonuclease Z, partial [Candidatus Aerophobetes bacterium Ae_b3b] | diamond | 240 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3b | ||||||
| 31890844 | 31890844 | PRJNA971676_P_NODE_18497_length_246_cov_0.890173_g18408_i0 | PRJNA971676 | 18497 | 246 | 0.890173 | 2.18982558 | Candidatus Aerophobetes bacterium Ae_b3a | 2012485 | Bacteria | Bacteria | 160 | 8.399999999999998e-44 | NR | TKJ45819.1 | 2012485 | g18408 | i0 | 97.5 | 0.98780487804878 | 81 | 2 | 98.8 | 0 | 245 | 3 | 152 | 232 | TKJ45819.1 MAG: 5-oxoprolinase [Candidatus Aerophobetes bacterium Ae_b3a] | diamond | 243 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aerophobota | Candidatus Aerophobetes bacterium Ae_b3a |
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);;