contig_metadata
9 rows where bioproject = "PRJNA556992", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26729731 | 26729731 | PRJNA556992_P_NODE_1116901_length_209_cov_4.139706_g1114710_i0 | PRJNA556992 | 1116901 | 209 | 4.139706 | 8.65198554 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 43.9 | 0.00935 | NR | MBI2583953.1 | 3121606 | g1114710 | i0 | 36.4 | 0.789473684210526 | 55 | 30 | 78.9 | 1 | 35 | 199 | 14 | 63 | MBI2583953.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Aenigmatarchaeota archaeon] | diamond | 165 | 43.9 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 27868131 | 27868131 | PRJNA556992_P_NODE_550885_length_263_cov_1.468421_g548696_i0 | PRJNA556992 | 550885 | 263 | 1.468421 | 3.86194723 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 89.7 | 1.46e-18 | NR | MEM5877540.1 | 3121606 | g548696 | i0 | 48.2 | 0.96958174904943 | 85 | 44 | 97 | 0 | 263 | 9 | 444 | 528 | MEM5877540.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 255 | 89.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 28152405 | 28152405 | PRJNA556992_P_NODE_1159785_length_199_cov_6.285714_g1157594_i0 | PRJNA556992 | 1159785 | 199 | 6.285714 | 12.50857086 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 66.2 | 1.07e-10 | NR | MBN2042812.1 | 3121606 | g1157594 | i0 | 48.5 | 1.92964824120603 | 66 | 34 | 99.5 | 0 | 198 | 1 | 160 | 225 | MBN2042812.1 leucyl aminopeptidase [Candidatus Aenigmatarchaeota archaeon] | diamond | 384 | 66.2 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 28500101 | 28500101 | PRJNA556992_P_NODE_9667_length_1068_cov_6.285427_g8265_i0 | PRJNA556992 | 9667 | 1068 | 6.285427 | 67.12836036 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 122 | 2.02e-29 | NR | MEM0325232.1 | 3121606 | g8265 | i0 | 46.6 | 0.373595505617978 | 133 | 71 | 37.4 | 0 | 2 | 400 | 43 | 175 | MEM0325232.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 399 | 122 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 30899922 | 30899922 | PRJNA556992_P_NODE_1079354_length_217_cov_8.125000_g1077163_i0 | PRJNA556992 | 1079354 | 217 | 8.125 | 17.63125 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 79 | 1.01e-15 | NR | MBL7206280.1 | 3121606 | g1077163 | i0 | 59.7 | 0.926267281105991 | 67 | 27 | 92.6 | 0 | 12 | 212 | 39 | 105 | MBL7206280.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 201 | 79 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31184134 | 31184134 | PRJNA556992_P_NODE_541415_length_263_cov_7.178947_g539226_i0 | PRJNA556992 | 541415 | 263 | 7.178947 | 18.88063061 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 80.9 | 1.82e-15 | NR | MEM5877846.1 | 3121606 | g539226 | i0 | 67.2 | 0.695817490494297 | 61 | 20 | 69.6 | 0 | 81 | 263 | 64 | 124 | MEM5877846.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 183 | 80.9 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 31753852 | 31753852 | PRJNA556992_P_NODE_844437_length_243_cov_5.194118_g842247_i0 | PRJNA556992 | 844437 | 243 | 5.194118 | 12.62170674 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 64.7 | 5.61e-10 | NR | MFH1421029.1 | 3121606 | g842247 | i0 | 55.3 | 1.18518518518519 | 47 | 21 | 58 | 0 | 230 | 90 | 291 | 337 | MFH1421029.1 radical SAM protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 288 | 64.7 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32228264 | 32228264 | PRJNA556992_P_NODE_131438_length_373_cov_1.466667_g129251_i0 | PRJNA556992 | 131438 | 373 | 1.466667 | 5.47066791 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 98.2 | 2.8400000000000003e-21 | NR | MEM5877656.1 | 3121606 | g129251 | i0 | 49.5 | 1.83378016085791 | 105 | 48 | 82.8 | 2 | 62 | 370 | 230 | 331 | MEM5877656.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 684 | 98.2 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota archaeon | ||||||
| 32513320 | 32513320 | PRJNA556992_P_NODE_401099_length_276_cov_3.192118_g398910_i0 | PRJNA556992 | 401099 | 276 | 3.192118 | 8.81024568 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 63.2 | 1.61e-9 | NR | MEM5877626.1 | 3121606 | g398910 | i0 | 37 | 2 | 92 | 56 | 98.9 | 2 | 4 | 276 | 125 | 215 | MEM5877626.1 TrmH family RNA methyltransferase [Candidatus Aenigmatarchaeota archaeon] | diamond | 552 | 63.2 | 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);;