contig_metadata
12 rows where bioproject = "PRJEB11748" and tax_phylum = "Candidatus Aenigmatarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26811388 | 26811388 | PRJEB11748_P_NODE_278121_length_230_cov_11.301775_g275938_i0 | PRJEB11748 | 278121 | 230 | 11.301775 | 25.9940825 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 73.9 | 1.54e-13 | NR | MEM5806776.1 | 3121606 | g275938 | i0 | 77.5 | 0.521739130434783 | 40 | 9 | 52.2 | 0 | 110 | 229 | 14 | 53 | MEM5806776.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 120 | 73.9 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 26874898 | 26874898 | PRJEB11748_P_NODE_156401_length_327_cov_13.274436_g154219_i0 | PRJEB11748 | 156401 | 327 | 13.274436 | 43.40740572 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 132 | 1.4799999999999998e-37 | NR | MEM5806782.1 | 3121606 | g154219 | i0 | 93 | 0.651376146788991 | 71 | 5 | 65.1 | 0 | 259 | 47 | 48 | 118 | MEM5806782.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 213 | 132 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27664995 | 27664995 | PRJEB11748_P_NODE_374984_length_183_cov_9.819672_g372801_i0 | PRJEB11748 | 374984 | 183 | 9.819672 | 17.96999976 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 105 | 3.23e-25 | NR | MCC5994686.1 | 3121606 | g372801 | i0 | 89.1 | 0.901639344262295 | 55 | 6 | 90.2 | 0 | 17 | 181 | 224 | 278 | MCC5994686.1 ATP-binding protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 165 | 105 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27791213 | 27791213 | PRJEB11748_P_NODE_379784_length_179_cov_14.228814_g377601_i0 | PRJEB11748 | 379784 | 179 | 14.228814 | 25.46957706 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 69.7 | 7.6e-14 | NR | MEM0333272.1 | 3121606 | g377601 | i0 | 87.2 | 0.653631284916201 | 39 | 5 | 65.4 | 0 | 62 | 178 | 15 | 53 | MEM0333272.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 117 | 69.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29117395 | 29117395 | PRJEB11748_P_NODE_385889_length_175_cov_5.789474_g383706_i0 | PRJEB11748 | 385889 | 175 | 5.789474 | 10.1315795 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 89.4 | 1.59e-20 | NR | MCC5994698.1 | 3121606 | g383706 | i0 | 88 | 0.857142857142857 | 50 | 6 | 85.7 | 0 | 175 | 26 | 86 | 135 | MCC5994698.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 150 | 89.4 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 30064444 | 30064444 | PRJEB11748_P_NODE_387052_length_174_cov_7.212389_g384869_i0 | PRJEB11748 | 387052 | 174 | 7.212389 | 12.54955686 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 41.6 | 0.0376 | NR | MEM0325281.1 | 3121606 | g384869 | i0 | 39.5 | 0.741379310344828 | 43 | 26 | 74.1 | 0 | 41 | 169 | 405 | 447 | MEM0325281.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 129 | 41.6 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 30254339 | 30254339 | PRJEB11748_P_NODE_277952_length_230_cov_19.946746_g275769_i0 | PRJEB11748 | 277952 | 230 | 19.946746 | 45.8775158 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 109 | 8.3e-26 | NR | MEM0333295.1 | 3121606 | g275769 | i0 | 86.2 | 0.847826086956522 | 65 | 9 | 84.8 | 0 | 204 | 10 | 110 | 174 | MEM0333295.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 195 | 109 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31201425 | 31201425 | PRJEB11748_P_NODE_175255_length_306_cov_14.579592_g173072_i0 | PRJEB11748 | 175255 | 306 | 14.579592 | 44.61355152 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 174 | 2.44e-48 | NR | MCD6381802.1 | 3121606 | g173072 | i0 | 79.8 | 0.92156862745098 | 94 | 19 | 92.2 | 0 | 23 | 304 | 534 | 627 | MCD6381802.1 N-6 DNA methylase [Candidatus Aenigmatarchaeota archaeon] | diamond | 282 | 174 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32087559 | 32087559 | PRJEB11748_P_NODE_178298_length_303_cov_13.545455_g176115_i0 | PRJEB11748 | 178298 | 303 | 13.545455 | 41.04272865 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 63.9 | 2.56e-9 | NR | MEM5868848.1 | 3121606 | g176115 | i0 | 34.8 | 0.910891089108911 | 92 | 59 | 90.1 | 1 | 20 | 292 | 340 | 431 | MEM5868848.1 HEPN domain-containing protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 276 | 63.9 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32087591 | 32087591 | PRJEB11748_P_NODE_220658_length_267_cov_2.325243_g218475_i0 | PRJEB11748 | 220658 | 267 | 2.325243 | 6.20839881 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 107 | 1.17e-27 | NR | MEM0332922.1 | 3121606 | g218475 | i0 | 83.1 | 0.662921348314607 | 59 | 10 | 66.3 | 0 | 265 | 89 | 63 | 121 | MEM0332922.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 177 | 107 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32372548 | 32372548 | PRJEB11748_P_NODE_247199_length_248_cov_14.951872_g245016_i0 | PRJEB11748 | 247199 | 248 | 14.951872 | 37.08064256 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 57.8 | 2.75e-8 | NR | MCC5994692.1 | 3121606 | g245016 | i0 | 84.8 | 0.399193548387097 | 33 | 5 | 39.9 | 0 | 226 | 128 | 102 | 134 | MCC5994692.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 99 | 57.8 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32845657 | 32845657 | PRJEB11748_P_NODE_334700_length_204_cov_8.132867_g332517_i0 | PRJEB11748 | 334700 | 204 | 8.132867 | 16.59104868 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 59.7 | 2.39e-8 | NR | MEM5806763.1 | 3121606 | g332517 | i0 | 78.3 | 1.01470588235294 | 69 | 7 | 89.7 | 1 | 183 | 1 | 284 | 352 | MEM5806763.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 207 | 59.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon |
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);;