contig_metadata
8 rows where bioproject = "PRJNA1020854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12482036 | 12482036 | PRJNA1020854_S_NODE_21390_length_235_cov_1496.165049_g18626_i0 | PRJNA1020854 | 21390 | 235 | 1496.165049 | 3515.98786515 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 71.6 | 5.62e-13 | NR | MEM0332964.1 | 3121606 | g18626 | i0 | 97.1 | 0.446808510638298 | 35 | 1 | 44.7 | 0 | 129 | 233 | 1 | 35 | MEM0332964.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 105 | 71.6 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 23113319 | 23113319 | PRJNA1020854_S_NODE_30759_length_185_cov_3309.711538_g27995_i0 | PRJNA1020854 | 30759 | 185 | 3309.711538 | 6122.9663453 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 91.3 | 1.33e-19 | NR | MCC5994579.1 | 3121606 | g27995 | i0 | 86 | 0.810810810810811 | 50 | 7 | 81.1 | 0 | 150 | 1 | 177 | 226 | MCC5994579.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 150 | 91.3 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 26876964 | 26876964 | PRJNA1020854_S_NODE_26661_length_203_cov_12.051724_g23897_i0 | PRJNA1020854 | 26661 | 203 | 12.051724 | 24.46499972 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 124 | 1.8e-32 | NR | MCC5994635.1 | 3121606 | g23897 | i0 | 93.4 | 0.901477832512315 | 61 | 4 | 90.1 | 0 | 21 | 203 | 175 | 235 | MCC5994635.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 183 | 124 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27666920 | 27666920 | PRJNA1020854_S_NODE_22824_length_225_cov_33.209184_g20060_i0 | PRJNA1020854 | 22824 | 225 | 33.209184 | 74.720664 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 121 | 5.839999999999999e-31 | NR | MCC5994730.1 | 3121606 | g20060 | i0 | 81.6 | 1.01333333333333 | 76 | 13 | 100 | 1 | 1 | 225 | 278 | 353 | MCC5994730.1 AAA family ATPase [Candidatus Aenigmatarchaeota archaeon] | diamond | 228 | 121 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29214112 | 29214112 | PRJNA1020854_S_NODE_29809_length_189_cov_4.506250_g27045_i0 | PRJNA1020854 | 29809 | 189 | 4.50625 | 8.5168125 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 46.6 | 7.81e-4 | NR | MEM0325281.1 | 3121606 | g27045 | i0 | 38.7 | 0.984126984126984 | 62 | 33 | 98.4 | 2 | 187 | 2 | 391 | 447 | MEM0325281.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 186 | 46.6 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29971695 | 29971695 | PRJNA1020854_S_NODE_41791_length_153_cov_11.717742_g39027_i0 | PRJNA1020854 | 41791 | 153 | 11.717742 | 17.92814526 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 77.4 | 1.15e-15 | NR | MCC5994628.1 | 3121606 | g39027 | i0 | 89.7 | 0.764705882352941 | 39 | 4 | 76.5 | 0 | 145 | 29 | 128 | 166 | MCC5994628.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 117 | 77.4 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 30256412 | 30256412 | PRJNA1020854_S_NODE_18292_length_262_cov_5.210300_g15528_i0 | PRJNA1020854 | 18292 | 262 | 5.2103 | 13.650986 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 160 | 5.04e-47 | NR | MCC5994609.1 | 3121606 | g15528 | i0 | 89.5 | 0.984732824427481 | 86 | 9 | 98.5 | 0 | 260 | 3 | 12 | 97 | MCC5994609.1 PD-(D/E)XK nuclease family protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 258 | 160 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32152951 | 32152951 | PRJNA1020854_S_NODE_35158_length_170_cov_11.063830_g32394_i0 | PRJNA1020854 | 35158 | 170 | 11.06383 | 18.808511 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 87.8 | 1.45e-18 | NR | MCC5994578.1 | 3121606 | g32394 | i0 | 76.8 | 0.988235294117647 | 56 | 8 | 98.8 | 1 | 169 | 2 | 69 | 119 | MCC5994578.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 168 | 87.8 | 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);;