contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27896590 | 27896590 | PRJNA407368_S_NODE_8865_length_170_cov_2.531915_g8763_i0 | PRJNA407368 | 8865 | 170 | 2.531915 | 4.3042555 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 107 | 1.7e-25 | NR | XP_002674724.1 | 5762 | g8763 | i0 | 98.2 | 0.988235294117647 | 56 | 1 | 98.8 | 0 | 168 | 1 | 527 | 582 | XP_002674724.1 uncharacterized protein NAEGRDRAFT_70116 [Naegleria gruberi] | diamond | 168 | 107 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28275478 | 28275478 | PRJNA407368_S_NODE_10046_length_156_cov_1.818898_g9944_i0 | PRJNA407368 | 10046 | 156 | 1.818898 | 2.83748088 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 106 | 4.88e-28 | NR | XP_002670564.1 | 5762 | g9944 | i0 | 98 | 0.980769230769231 | 51 | 1 | 98.1 | 0 | 155 | 3 | 81 | 131 | XP_002670564.1 uncharacterized protein NAEGRDRAFT_59665 [Naegleria gruberi] | diamond | 153 | 106 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30075327 | 30075327 | PRJNA407368_S_NODE_10692_length_150_cov_1.256198_g10590_i0 | PRJNA407368 | 10692 | 150 | 1.256198 | 1.8842970000000001 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 92 | 3.51e-21 | NR | XP_002670780.1 | 5762 | g10590 | i0 | 92 | 1 | 50 | 4 | 100 | 0 | 1 | 150 | 129 | 178 | XP_002670780.1 uncharacterized protein NAEGRDRAFT_81767 [Naegleria gruberi] | diamond | 150 | 92 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30644007 | 30644007 | PRJNA407368_S_NODE_9673_length_160_cov_2.076336_g9571_i0 | PRJNA407368 | 9673 | 160 | 2.076336 | 3.3221376 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 107 | 8.37e-26 | NR | XP_002673143.1 | 5762 | g9571 | i0 | 98.1 | 0.99375 | 53 | 1 | 99.4 | 0 | 2 | 160 | 347 | 399 | XP_002673143.1 UDP-glucose pyrophosphorylase 2-like protein [Naegleria gruberi] | diamond | 159 | 107 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30802091 | 30802091 | PRJNA407368_S_NODE_6434_length_210_cov_2.375691_g6332_i0 | PRJNA407368 | 6434 | 210 | 2.375691 | 4.9889511 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 83.6 | 1.02e-16 | NR | XP_002670340.1 | 5762 | g6332 | i0 | 79.6 | 0.771428571428571 | 54 | 11 | 77.1 | 0 | 168 | 7 | 586 | 639 | XP_002670340.1 uncharacterized protein NAEGRDRAFT_81874 [Naegleria gruberi] | diamond | 162 | 83.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31687264 | 31687264 | PRJNA407368_S_NODE_4557_length_266_cov_3.097046_g4455_i0 | PRJNA407368 | 4557 | 266 | 3.097046 | 8.23814236 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 62 | 7.86e-9 | NR | XP_002682034.1 | 5762 | g4455 | i0 | 82.6 | 0.778195488721805 | 69 | 12 | 77.8 | 0 | 207 | 1 | 78 | 146 | XP_002682034.1 uncharacterized protein NAEGRDRAFT_78127 [Naegleria gruberi] | diamond | 207 | 62 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31971983 | 31971983 | PRJNA407368_S_NODE_9838_length_158_cov_2.007752_g9736_i0 | PRJNA407368 | 9838 | 158 | 2.007752 | 3.17224816 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 72 | 5.18e-13 | NR | XP_002680679.1 | 5762 | g9736 | i0 | 63.5 | 0.987341772151899 | 52 | 19 | 98.7 | 0 | 158 | 3 | 57 | 108 | XP_002680679.1 von Willebrand factor type A domain-containing protein [Naegleria gruberi] | diamond | 156 | 72 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32066867 | 32066867 | PRJNA407368_S_NODE_3298_length_324_cov_12.938983_g3196_i0 | PRJNA407368 | 3298 | 324 | 12.938983 | 41.92230492 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 121 | 1.99e-29 | NR | XP_002673222.1 | 5762 | g3196 | i0 | 84.4 | 0.592592592592593 | 64 | 10 | 59.3 | 0 | 131 | 322 | 904 | 967 | XP_002673222.1 leucine rich repeat protein [Naegleria gruberi] | diamond | 192 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;