contig_metadata
8 rows where bioproject = "PRJNA977246", tax_phylum = "Candidatus Aenigmatarchaeota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16571429 | 16571429 | PRJNA977246_S_NODE_32953_length_210_cov_10823.182320_g31961_i0 | PRJNA977246 | 32953 | 210 | 10823.18232 | 22728.682872 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 61.6 | 9.8e-10 | NR | MEM0332943.1 | 3121606 | g31961 | i0 | 84.8 | 0.928571428571429 | 33 | 5 | 47.1 | 0 | 5 | 103 | 133 | 165 | MEM0332943.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 195 | 61.6 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27152108 | 27152108 | PRJNA977246_S_NODE_22362_length_285_cov_16.128906_g21370_i0 | PRJNA977246 | 22362 | 285 | 16.128906 | 45.9673821 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 156 | 1.3499999999999997e-42 | NR | MCC5994651.1 | 3121606 | g21370 | i0 | 86.8 | 0.957894736842105 | 91 | 12 | 95.8 | 0 | 12 | 284 | 424 | 514 | MCC5994651.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 273 | 156 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27310848 | 27310848 | PRJNA977246_S_NODE_38483_length_187_cov_2.582278_g37491_i0 | PRJNA977246 | 38483 | 187 | 2.582278 | 4.82885986 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 43.5 | 0.00873 | NR | MCC5994609.1 | 3121606 | g37491 | i0 | 100 | 0.336898395721925 | 21 | 0 | 33.7 | 0 | 65 | 3 | 1 | 21 | MCC5994609.1 PD-(D/E)XK nuclease family protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 63 | 43.5 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 29709934 | 29709934 | PRJNA977246_S_NODE_21070_length_298_cov_3.178439_g20078_i0 | PRJNA977246 | 21070 | 298 | 3.178439 | 9.47174822 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 145 | 1.96e-39 | NR | MCC5994578.1 | 3121606 | g20078 | i0 | 76.5 | 0.986577181208054 | 98 | 18 | 98.7 | 1 | 3 | 296 | 81 | 173 | MCC5994578.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 294 | 145 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31131708 | 31131708 | PRJNA977246_S_NODE_37575_length_190_cov_8.161491_g36583_i0 | PRJNA977246 | 37575 | 190 | 8.161491 | 15.5068329 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 123 | 5.269999999999999e-31 | NR | MCC5994579.1 | 3121606 | g36583 | i0 | 100 | 0.963157894736842 | 61 | 0 | 96.3 | 0 | 189 | 7 | 192 | 252 | MCC5994579.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 183 | 123 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31321615 | 31321615 | PRJNA977246_S_NODE_37275_length_192_cov_2.000000_g36283_i0 | PRJNA977246 | 37275 | 192 | 2 | 3.84 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 126 | 2.34e-33 | NR | MCC5994686.1 | 3121606 | g36283 | i0 | 93.8 | 1 | 64 | 4 | 100 | 0 | 192 | 1 | 259 | 322 | MCC5994686.1 ATP-binding protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 192 | 126 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31416583 | 31416583 | PRJNA977246_S_NODE_31076_length_220_cov_6.230366_g30084_i0 | PRJNA977246 | 31076 | 220 | 6.230366 | 13.7068052 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 137 | 9.45e-39 | NR | MCC5994628.1 | 3121606 | g30084 | i0 | 94.5 | 0.995454545454545 | 73 | 4 | 99.5 | 0 | 220 | 2 | 131 | 203 | MCC5994628.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 219 | 137 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32397415 | 32397415 | PRJNA977246_S_NODE_23259_length_277_cov_5.572581_g22267_i0 | PRJNA977246 | 23259 | 277 | 5.572581 | 15.43604937 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 157 | 5.389999999999999e-47 | NR | MEM0332955.1 | 3121606 | g22267 | i0 | 95.3 | 0.931407942238267 | 86 | 4 | 93.1 | 0 | 277 | 20 | 83 | 168 | MEM0332955.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 258 | 157 | 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);;