contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28201668 | 28201668 | PRJEB29441_P_NODE_38726_length_167_cov_1.296610_g38285_i0 | PRJEB29441 | 38726 | 167 | 1.29661 | 2.1653387 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 102 | 9.93e-25 | NR | XP_002676405.1 | 5762 | g38285 | i0 | 92.9 | 1.0059880239521 | 56 | 3 | 98.8 | 1 | 166 | 2 | 75 | 130 | XP_002676405.1 uncharacterized protein NAEGRDRAFT_49668 [Naegleria gruberi] | diamond | 168 | 102 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29426566 | 29426566 | PRJEB29441_P_NODE_42709_length_164_cov_0.886957_g42268_i0 | PRJEB29441 | 42709 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.8 | 1.38e-25 | NR | XP_002681511.1 | 5762 | g42268 | i0 | 68.5 | 6.91463414634146 | 54 | 17 | 98.8 | 0 | 3 | 164 | 7 | 60 | XP_002681511.1 uncharacterized protein NAEGRDRAFT_4809, partial [Naegleria gruberi] | diamond | 1134 | 99.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29622244 | 29622244 | PRJEB29441_P_NODE_42970_length_164_cov_0.886957_g42529_i0 | PRJEB29441 | 42970 | 164 | 0.886957 | 1.45460948 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 101 | 2.2699999999999994e-23 | NR | XP_002672418.1 | 5762 | g42529 | i0 | 88.9 | 0.98780487804878 | 54 | 6 | 98.8 | 0 | 164 | 3 | 1623 | 1676 | XP_002672418.1 dedicator of cytokinesis 4 [Naegleria gruberi] | diamond | 162 | 101 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29970040 | 29970040 | PRJEB29441_P_NODE_41531_length_165_cov_0.879310_g41090_i0 | PRJEB29441 | 41531 | 165 | 0.87931 | 1.4508615 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 61.2 | 3.8e-9 | NR | KAL0490473.1 | 1008807 | g41090 | i0 | 64.9 | 1.34545454545455 | 37 | 13 | 67.3 | 0 | 39 | 149 | 1202 | 1238 | KAL0490473.1 hypothetical protein AKO1_009512 [Acrasis kona] | diamond | 222 | 61.2 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30222758 | 30222758 | PRJEB29441_P_NODE_42932_length_164_cov_0.886957_g42491_i0 | PRJEB29441 | 42932 | 164 | 0.886957 | 1.45460948 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 101 | 1.5099999999999998e-23 | NR | XP_002672777.1 | 5762 | g42491 | i0 | 90.7 | 0.98780487804878 | 54 | 5 | 98.8 | 0 | 164 | 3 | 208 | 261 | XP_002672777.1 uncharacterized protein NAEGRDRAFT_52059 [Naegleria gruberi] | diamond | 162 | 101 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31107374 | 31107374 | PRJEB29441_P_NODE_44135_length_163_cov_0.894737_g43694_i0 | PRJEB29441 | 44135 | 163 | 0.894737 | 1.45842131 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 103 | 3.35e-24 | NR | XP_002674266.1 | 5762 | g43694 | i0 | 86.8 | 0.975460122699387 | 53 | 7 | 97.5 | 0 | 3 | 161 | 174 | 226 | XP_002674266.1 iron hydrogenase [Naegleria gruberi] | diamond | 159 | 103 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32625493 | 32625493 | PRJEB29441_P_NODE_39420_length_167_cov_0.864407_g38979_i0 | PRJEB29441 | 39420 | 167 | 0.864407 | 1.44355969 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 58.9 | 2.58e-8 | NR | XP_002673389.1 | 5762 | g38979 | i0 | 61.5 | 0.934131736526946 | 52 | 20 | 93.4 | 0 | 5 | 160 | 773 | 824 | XP_002673389.1 kinesin-3 [Naegleria gruberi] | diamond | 156 | 58.9 | 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);;