contig_metadata
4 rows where bioproject = "PRJNA379145" and tax_phylum = "Candidatus Hydrogenedentota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24626943 | 24626943 | PRJNA379145_P_NODE_23200_length_528_cov_13.923232_g21220_i0 | PRJNA379145 | 23200 | 528 | 13.923232 | 73.51466496 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 188 | 6.47e-58 | NR | MFC1734511.1 | 2030809 | g21220 | i0 | 63.1 | 4.82954545454545 | 141 | 51 | 80.1 | 1 | 512 | 90 | 17 | 156 | MFC1734511.1 arsenate reductase ArsC [Candidatus Hydrogenedentota bacterium] | diamond | 2550 | 188 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 27485785 | 27485785 | PRJNA379145_P_NODE_4463_length_1404_cov_3.167761_g3907_i0 | PRJNA379145 | 4463 | 1404 | 3.167761 | 44.47536444 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 340 | 9.1e-109 | NR | NUM56236.1 | 2030809 | g3907 | i0 | 42.7 | 2.88675213675214 | 450 | 240 | 95.7 | 8 | 60 | 1403 | 35 | 468 | NUM56236.1 flavin monoamine oxidase family protein [Candidatus Hydrogenedentota bacterium] | diamond | 4053 | 340 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 29064609 | 29064609 | PRJNA379145_P_NODE_5148_length_1323_cov_2.498450_g4523_i0 | PRJNA379145 | 5148 | 1323 | 2.49845 | 33.0544935 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 237 | 7.4e-67 | NR | MBN2310942.1 | 2030809 | g4523 | i0 | 41.4 | 1.33786848072562 | 295 | 164 | 66.7 | 4 | 1259 | 378 | 225 | 511 | MBN2310942.1 right-handed parallel beta-helix repeat-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 1770 | 237 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 32224823 | 32224823 | PRJNA379145_P_NODE_73438_length_152_cov_1.058824_g71283_i0 | PRJNA379145 | 73438 | 152 | 1.058824 | 1.60941248 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 68.6 | 8.35e-12 | NR | HOZ45348.1 | 2030809 | g71283 | i0 | 58.7 | 1.83552631578947 | 46 | 19 | 90.8 | 0 | 6 | 143 | 262 | 307 | HOZ45348.1 FAD-dependent oxidoreductase [Candidatus Hydrogenedentota bacterium] | diamond | 279 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota 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);;