contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA826497" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26927916 | 26927916 | PRJNA826497_S_NODE_4562_length_233_cov_2.875000_g4522_i0 | PRJNA826497 | 4562 | 233 | 2.875 | 6.69875 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 57 | 3.09e-7 | NR | XP_002673062.1 | 5762 | g4522 | i0 | 50.9 | 0.733905579399142 | 57 | 28 | 73.4 | 0 | 232 | 62 | 765 | 821 | XP_002673062.1 uncharacterized protein NAEGRDRAFT_56300 [Naegleria gruberi] | diamond | 171 | 57 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27117466 | 27117466 | PRJNA826497_S_NODE_7222_length_205_cov_6.034884_g7182_i0 | PRJNA826497 | 7222 | 205 | 6.034884 | 12.3715122 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 45.8 | 0.00187 | NR | XP_002675446.1 | 5762 | g7182 | i0 | 44.3 | 1.02439024390244 | 70 | 14 | 82 | 3 | 4 | 171 | 485 | 543 | XP_002675446.1 uncharacterized protein NAEGRDRAFT_69418 [Naegleria gruberi] | diamond | 210 | 45.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28854365 | 28854365 | PRJNA826497_S_NODE_19588_length_151_cov_13.389831_g19548_i0 | PRJNA826497 | 19588 | 151 | 13.389831 | 20.21864481 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 58.9 | 1.76e-8 | NR | XP_044559060.1 | 5763 | g19548 | i0 | 50 | 0.993377483443709 | 50 | 25 | 99.3 | 0 | 150 | 1 | 199 | 248 | XP_044559060.1 uncharacterized protein FDP41_006379 [Naegleria fowleri] | diamond | 150 | 58.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30844451 | 30844451 | PRJNA826497_S_NODE_4374_length_235_cov_4.034653_g4334_i0 | PRJNA826497 | 4374 | 235 | 4.034653 | 9.48143455 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 75.1 | 7.06e-15 | NR | XP_044558447.1 | 5763 | g4334 | i0 | 57.9 | 0.970212765957447 | 76 | 31 | 97 | 1 | 233 | 6 | 68 | 142 | XP_044558447.1 uncharacterized protein FDP41_007121 [Naegleria fowleri] | diamond | 228 | 75.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30939301 | 30939301 | PRJNA826497_S_NODE_6714_length_210_cov_3.265537_g6674_i0 | PRJNA826497 | 6714 | 210 | 3.265537 | 6.8576277 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 63.2 | 1.55e-9 | NR | XP_002674918.1 | 5762 | g6674 | i0 | 51 | 2.2 | 51 | 25 | 72.9 | 0 | 1 | 153 | 592 | 642 | XP_002674918.1 PAP2_haloperoxidase domain-containing protein [Naegleria gruberi] | diamond | 462 | 63.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31539947 | 31539947 | PRJNA826497_S_NODE_17916_length_156_cov_2.617886_g17876_i0 | PRJNA826497 | 17916 | 156 | 2.617886 | 4.08390216 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 95.1 | 3.9300000000000005e-21 | NR | XP_002683269.1 | 5762 | g17876 | i0 | 86 | 0.961538461538462 | 50 | 7 | 96.2 | 0 | 6 | 155 | 548 | 597 | XP_002683269.1 uncharacterized protein NAEGRDRAFT_61560 [Naegleria gruberi] | diamond | 150 | 95.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31634607 | 31634607 | PRJNA826497_S_NODE_7876_length_200_cov_13.305389_g7836_i0 | PRJNA826497 | 7876 | 200 | 13.305389 | 26.610778 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 128 | 3.86e-35 | NR | XP_002668849.1 | 5762 | g7836 | i0 | 96.7 | 0.915 | 61 | 2 | 91.5 | 0 | 200 | 18 | 86 | 146 | XP_002668849.1 uncharacterized protein NAEGRDRAFT_44887 [Naegleria gruberi] | diamond | 183 | 128 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32140953 | 32140953 | PRJNA826497_S_NODE_3478_length_249_cov_4.069444_g3438_i0 | PRJNA826497 | 3478 | 249 | 4.069444 | 10.13291556 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 98.2 | 2.2699999999999994e-23 | NR | XP_002676856.1 | 5762 | g3438 | i0 | 65.8 | 0.91566265060241 | 76 | 26 | 91.6 | 0 | 244 | 17 | 127 | 202 | XP_002676856.1 rho family small GTPase [Naegleria gruberi] | diamond | 228 | 98.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32677969 | 32677969 | PRJNA826497_S_NODE_18680_length_154_cov_2.099174_g18640_i0 | PRJNA826497 | 18680 | 154 | 2.099174 | 3.23272796 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 77.4 | 8.75e-17 | NR | XP_044542829.1 | 51637 | g18640 | i0 | 80 | 0.974025974025974 | 50 | 10 | 97.4 | 0 | 1 | 150 | 9 | 58 | XP_044542829.1 uncharacterized protein C9374_011944 [Naegleria lovaniensis] | diamond | 150 | 77.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis |
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);;