contig_metadata
9 rows where bioproject = "PRJNA572587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26667726 | 26667726 | PRJNA572587_P_NODE_11721_length_342_cov_28.522184_g11393_i0 | PRJNA572587 | 11721 | 342 | 28.522184 | 97.54586928 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 100 | 7.61e-24 | NR | MEM0332942.1 | 3121606 | g11393 | i0 | 76.7 | 0.526315789473684 | 60 | 14 | 52.6 | 0 | 203 | 24 | 47 | 106 | MEM0332942.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 180 | 100 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27142362 | 27142362 | PRJNA572587_P_NODE_31002_length_199_cov_21.886667_g30674_i0 | PRJNA572587 | 31002 | 199 | 21.886667 | 43.55446733 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 105 | 5.3200000000000006e-27 | NR | MEM0332955.1 | 3121606 | g30674 | i0 | 93.2 | 0.889447236180904 | 59 | 4 | 88.9 | 0 | 197 | 21 | 86 | 144 | MEM0332955.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 177 | 105 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27490359 | 27490359 | PRJNA572587_P_NODE_17883_length_269_cov_15.095455_g17555_i0 | PRJNA572587 | 17883 | 269 | 15.095455 | 40.60677395 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 72 | 2.14e-12 | NR | MEM5804206.1 | 3121606 | g17555 | i0 | 52.4 | 2.74349442379182 | 82 | 38 | 90.3 | 1 | 27 | 269 | 240 | 321 | MEM5804206.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 738 | 72 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29542508 | 29542508 | PRJNA572587_P_NODE_39350_length_174_cov_20.984000_g39022_i0 | PRJNA572587 | 39350 | 174 | 20.984 | 36.51216 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 92.4 | 2.17e-20 | NR | MEM0332946.1 | 3121606 | g39022 | i0 | 93.8 | 0.827586206896552 | 48 | 3 | 82.8 | 0 | 149 | 6 | 11 | 58 | MEM0332946.1 transposase [Candidatus Aenigmatarchaeota archaeon] | diamond | 144 | 92.4 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29984765 | 29984765 | PRJNA572587_P_NODE_26431_length_217_cov_31.101190_g26103_i0 | PRJNA572587 | 26431 | 217 | 31.10119 | 67.4895823 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 66.2 | 1.38e-10 | NR | MEM0333111.1 | 3121606 | g26103 | i0 | 72.1 | 0.594470046082949 | 43 | 12 | 59.4 | 0 | 26 | 154 | 78 | 120 | MEM0333111.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 129 | 66.2 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 30806235 | 30806235 | PRJNA572587_P_NODE_13934_length_310_cov_5.386973_g13606_i0 | PRJNA572587 | 13934 | 310 | 5.386973 | 16.6996163 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 183 | 2.76e-54 | NR | MEM0332946.1 | 3121606 | g13606 | i0 | 91.8 | 0.938709677419355 | 97 | 8 | 93.9 | 0 | 20 | 310 | 129 | 225 | MEM0332946.1 transposase [Candidatus Aenigmatarchaeota archaeon] | diamond | 291 | 183 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31311771 | 31311771 | PRJNA572587_P_NODE_6055_length_504_cov_4.951648_g5734_i0 | PRJNA572587 | 6055 | 504 | 4.951648 | 24.95630592 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 91.7 | 4.86e-18 | NR | MEM0332881.1 | 3121606 | g5734 | i0 | 32.1 | 0.946428571428571 | 159 | 101 | 94.6 | 1 | 16 | 492 | 291 | 442 | MEM0332881.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 477 | 91.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31596742 | 31596742 | PRJNA572587_P_NODE_18656_length_263_cov_18.626168_g18328_i0 | PRJNA572587 | 18656 | 263 | 18.626168 | 48.98682184 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 127 | 1.41e-34 | NR | MCC5994628.1 | 3121606 | g18328 | i0 | 89.9 | 0.787072243346008 | 69 | 7 | 78.7 | 0 | 246 | 40 | 122 | 190 | MCC5994628.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 207 | 127 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31754590 | 31754590 | PRJNA572587_P_NODE_13997_length_309_cov_24.973077_g13669_i0 | PRJNA572587 | 13997 | 309 | 24.973077 | 77.16680793 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 95.5 | 3.51e-22 | NR | MEM0332948.1 | 3121606 | g13669 | i0 | 56.8 | 0.786407766990291 | 81 | 35 | 78.6 | 0 | 309 | 67 | 95 | 175 | MEM0332948.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 243 | 95.5 | 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);;