contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26614014 | 26614014 | PRJNA951810_P_NODE_63381_length_310_cov_3.054852_g63038_i0 | PRJNA951810 | 63381 | 310 | 3.054852 | 9.4700412 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 66.2 | 3.8e-10 | NR | NUM56038.1 | 2030809 | g63038 | i0 | 69.8 | 0.416129032258065 | 43 | 12 | 40.6 | 1 | 184 | 309 | 207 | 249 | NUM56038.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 129 | 66.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 27000309 | 27000309 | PRJNA951810_P_NODE_120262_length_280_cov_1.859903_g119917_i0 | PRJNA951810 | 120262 | 280 | 1.859903 | 5.2077284 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 46.2 | 0.00285 | NR | MEA3364521.1 | 2030809 | g119917 | i0 | 27.2 | 4.5 | 81 | 58 | 86.8 | 1 | 10 | 252 | 88 | 167 | MEA3364521.1 tetratricopeptide repeat protein [Candidatus Hydrogenedentota bacterium] | diamond | 1260 | 46.6 | 0.991416309012876 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 27885005 | 27885005 | PRJNA951810_P_NODE_169605_length_242_cov_8.378698_g169260_i0 | PRJNA951810 | 169605 | 242 | 8.378698 | 20.27644916 | FCB group | 1783270 | Bacteria | Bacteria | 80.1 | 1.15e-15 | NR | MCC6486919.1 | 2030809 | g169260 | i0 | 62.3 | 4.5495867768595 | 53 | 20 | 65.7 | 0 | 83 | 241 | 14 | 66 | MCC6486919.1 DUF1738 domain-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 1101 | 80.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 29236280 | 29236280 | PRJNA951810_P_NODE_113329_length_284_cov_6.488152_g112985_i0 | PRJNA951810 | 113329 | 284 | 6.488152 | 18.42635168 | Candidatus Hydrogenedens sp. | 2654184 | Bacteria | Bacteria | 73.6 | 1.21e-13 | NR | HOV31865.1 | 2654184 | g112985 | i0 | 47.9 | 1.48943661971831 | 71 | 35 | 73.9 | 2 | 18 | 227 | 95 | 164 | HOV31865.1 HNH endonuclease [Candidatus Hydrogenedens sp.] | diamond | 423 | 73.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentaceae | Candidatus Hydrogenedens | Candidatus Hydrogenedens sp. | |
| 29330939 | 29330939 | PRJNA951810_P_NODE_22649_length_421_cov_9.997126_g22311_i0 | PRJNA951810 | 22649 | 421 | 9.997126 | 42.08790046 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 84.7 | 5.25e-16 | NR | MFM1921954.1 | 2030809 | g22311 | i0 | 45 | 1.90973871733967 | 131 | 69 | 93.3 | 1 | 397 | 5 | 138 | 265 | MFM1921954.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 804 | 84.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 29804545 | 29804545 | PRJNA951810_P_NODE_40991_length_310_cov_11.561181_g40648_i0 | PRJNA951810 | 40991 | 310 | 11.561181 | 35.8396611 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 79.7 | 5.11e-15 | NR | MBP8129111.1 | 2030809 | g40648 | i0 | 69.4 | 0.948387096774194 | 49 | 15 | 47.4 | 0 | 148 | 2 | 202 | 250 | MBP8129111.1 sugar ABC transporter permease [Candidatus Hydrogenedentota bacterium] | diamond | 294 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 30057179 | 30057179 | PRJNA951810_P_NODE_43211_length_310_cov_8.464135_g42868_i0 | PRJNA951810 | 43211 | 310 | 8.464135 | 26.2388185 | Candidatus Hydrogenedens sp. | 2654184 | Bacteria | Bacteria | 45.8 | 0.00674 | NR | MBI1317691.1 | 2654184 | g42868 | i0 | 25.2 | 1.0741935483871 | 111 | 73 | 98.7 | 2 | 309 | 4 | 392 | 501 | MBI1317691.1 hypothetical protein [Candidatus Hydrogenedens sp.] | diamond | 333 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentia | Candidatus Hydrogenedentales | Candidatus Hydrogenedentaceae | Candidatus Hydrogenedens | Candidatus Hydrogenedens sp. | |
| 30562549 | 30562549 | PRJNA951810_P_NODE_3193_length_1014_cov_7.712009_g2999_i0 | PRJNA951810 | 3193 | 1014 | 7.712009 | 78.19977126 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 156 | 2.4599999999999998e-40 | NR | GMV91659.1 | 2030809 | g2999 | i0 | 36.1 | 4.05029585798817 | 269 | 149 | 73.4 | 6 | 20 | 763 | 108 | 374 | GMV91659.1 MAG: alginate lyase [Candidatus Hydrogenedentota bacterium] | diamond | 4107 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 30847222 | 30847222 | PRJNA951810_P_NODE_49234_length_310_cov_5.755274_g48891_i0 | PRJNA951810 | 49234 | 310 | 5.755274 | 17.8413494 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 60.8 | 3.79e-8 | NR | HRT22054.1 | 2030809 | g48891 | i0 | 33.6 | 3.10645161290323 | 107 | 47 | 80.3 | 1 | 43 | 291 | 59 | 165 | HRT22054.1 FG-GAP-like repeat-containing protein [Candidatus Hydrogenedentota bacterium] | diamond | 963 | 60.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Hydrogenedentota | Candidatus Hydrogenedentota bacterium | |||||
| 31827195 | 31827195 | PRJNA951810_P_NODE_73257_length_299_cov_9.455752_g72913_i0 | PRJNA951810 | 73257 | 299 | 9.455752 | 28.27269848 | Candidatus Hydrogenedentota bacterium | 2030809 | Bacteria | Bacteria | 58.2 | 6.47e-8 | NR | MBM3289409.1 | 2030809 | g72913 | i0 | 46.8 | 0.77257525083612 | 77 | 37 | 73.2 | 4 | 222 | 4 | 51 | 127 | MBM3289409.1 hypothetical protein [Candidatus Hydrogenedentota bacterium] | diamond | 231 | 58.2 | 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);;