contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA734348" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27747645 | 27747645 | PRJNA734348_P_NODE_94044_length_251_cov_0.865169_g93346_i0 | PRJNA734348 | 94044 | 251 | 0.865169 | 2.17157419 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 45.1 | 0.00594 | NR | KAL0483031.1 | 1008807 | g93346 | i0 | 30.9 | 0.968127490039841 | 81 | 47 | 86.1 | 2 | 235 | 20 | 90 | 170 | KAL0483031.1 developmentally-regulated protein [Acrasis kona] | diamond | 243 | 45.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28568265 | 28568265 | PRJNA734348_P_NODE_58767_length_281_cov_1.240385_g58070_i0 | PRJNA734348 | 58767 | 281 | 1.240385 | 3.48548185 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 94 | 5.9e-20 | NR | XP_044558001.1 | 5763 | g58070 | i0 | 48.9 | 1.9644128113879 | 92 | 45 | 98.2 | 1 | 280 | 5 | 825 | 914 | XP_044558001.1 uncharacterized protein FDP41_008495 [Naegleria fowleri] | diamond | 552 | 94 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28600057 | 28600057 | PRJNA734348_P_NODE_59147_length_280_cov_2.396135_g58450_i0 | PRJNA734348 | 59147 | 280 | 2.396135 | 6.709178 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 114 | 8.500000000000001e-28 | NR | KAL0487828.1 | 1008807 | g58450 | i0 | 70.7 | 0.803571428571429 | 75 | 21 | 80.4 | 1 | 55 | 279 | 106 | 179 | KAL0487828.1 NAD-dependent protein deacetylase sirtuin [Acrasis kona] | diamond | 225 | 114 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28852277 | 28852277 | PRJNA734348_P_NODE_114288_length_245_cov_2.267442_g113590_i0 | PRJNA734348 | 114288 | 245 | 2.267442 | 5.5552329 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 64.7 | 5.01e-10 | NR | KAL0489468.1 | 1008807 | g113590 | i0 | 73.7 | 0.46530612244898 | 38 | 10 | 46.5 | 0 | 3 | 116 | 256 | 293 | KAL0489468.1 hypothetical protein AKO1_009188 [Acrasis kona] | diamond | 114 | 64.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29714841 | 29714841 | PRJNA734348_P_NODE_117270_length_245_cov_0.895349_g116572_i0 | PRJNA734348 | 117270 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 97.1 | 6.449999999999999e-23 | NR | XP_002676609.1 | 5762 | g116572 | i0 | 62 | 7.76326530612245 | 71 | 27 | 86.9 | 0 | 214 | 2 | 3 | 73 | XP_002676609.1 uncharacterized protein NAEGRDRAFT_83175 [Naegleria gruberi] | diamond | 1902 | 97.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29831238 | 29831238 | PRJNA734348_P_NODE_107011_length_247_cov_1.413793_g106313_i0 | PRJNA734348 | 107011 | 247 | 1.413793 | 3.49206871 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 99 | 1.1200000000000001e-22 | NR | KAJ9461876.1 | 91374 | g106313 | i0 | 51.2 | 2.98785425101215 | 82 | 38 | 99.6 | 1 | 247 | 2 | 125 | 204 | KAJ9461876.1 Guanine nucleotide-binding protein subunit beta-like protein [Diplonema papillatum] | diamond | 738 | 99 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 29894587 | 29894587 | PRJNA734348_P_NODE_116711_length_245_cov_0.895349_g116013_i0 | PRJNA734348 | 116711 | 245 | 0.895349 | 2.19360505 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 84.7 | 4.9e-18 | NR | KAL0484198.1 | 1008807 | g116013 | i0 | 56.8 | 0.906122448979592 | 74 | 31 | 89.4 | 1 | 219 | 1 | 1 | 74 | KAL0484198.1 ribosomal protein L10 [Acrasis kona] | diamond | 222 | 84.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30242125 | 30242125 | PRJNA734348_P_NODE_53392_length_286_cov_2.136150_g52695_i0 | PRJNA734348 | 53392 | 286 | 2.13615 | 6.109389 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 107 | 1.2e-24 | NR | KAL0489076.1 | 1008807 | g52695 | i0 | 63.7 | 1.91958041958042 | 91 | 32 | 94.4 | 1 | 2 | 271 | 264 | 354 | KAL0489076.1 sodium/potassium-transporting ATPase subunit alpha [Acrasis kona] | diamond | 549 | 107 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30526348 | 30526348 | PRJNA734348_P_NODE_71833_length_268_cov_1.466667_g71135_i0 | PRJNA734348 | 71833 | 268 | 1.466667 | 3.93066756 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 133 | 6.02e-34 | NR | CUG90367.1 | 75058 | g71135 | i0 | 69.7 | 0.996268656716418 | 89 | 27 | 99.6 | 0 | 267 | 1 | 598 | 686 | CUG90367.1 trifunctional enzyme alpha precursor-like protein, putative [Bodo saltans] | diamond | 267 | 133 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31094990 | 31094990 | PRJNA734348_P_NODE_111355_length_246_cov_0.890173_g110657_i0 | PRJNA734348 | 111355 | 246 | 0.890173 | 2.18982558 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 46.6 | 0.00168 | NR | XP_002679855.1 | 5762 | g110657 | i0 | 37.5 | 0.780487804878049 | 64 | 38 | 76.8 | 2 | 202 | 14 | 30 | 92 | XP_002679855.1 uncharacterized protein NAEGRDRAFT_65017 [Naegleria gruberi] | diamond | 192 | 46.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32107189 | 32107189 | PRJNA734348_P_NODE_99578_length_249_cov_0.875000_g98880_i0 | PRJNA734348 | 99578 | 249 | 0.875 | 2.17875 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 55.8 | 9.56e-7 | NR | XP_002681531.1 | 5762 | g98880 | i0 | 39.8 | 1 | 83 | 46 | 97.6 | 3 | 244 | 2 | 480 | 560 | XP_002681531.1 uncharacterized protein NAEGRDRAFT_78426 [Naegleria gruberi] | diamond | 249 | 55.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32550449 | 32550449 | PRJNA734348_P_NODE_131459_length_241_cov_1.452381_g130761_i0 | PRJNA734348 | 131459 | 241 | 1.452381 | 3.50023821 | Stachyamoeba lipophora | 463046 | Heterolobosea | other_Eukaryota | 88.2 | 2.95e-18 | NR | YP_009118153.1 | 463046 | g130761 | i0 | 55.7 | 0.983402489626556 | 79 | 35 | 98.3 | 0 | 3 | 239 | 62 | 140 | YP_009118153.1 NADH dehydrogenase subunit 4 [Stachyamoeba lipophora] | diamond | 237 | 88.2 | 1 | Eukaryota | Discoba | Heterolobosea | Gruberellidae | Stachyamoeba | Stachyamoeba lipophora | ||||
| 32581898 | 32581898 | PRJNA734348_P_NODE_133759_length_241_cov_0.916667_g133061_i0 | PRJNA734348 | 133759 | 241 | 0.916667 | 2.20916747 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 56.2 | 6.38e-7 | NR | KAL0478229.1 | 1008807 | g133061 | i0 | 43.9 | 0.70954356846473 | 57 | 32 | 71 | 0 | 4 | 174 | 472 | 528 | KAL0478229.1 TPR repeat-containing protein [Acrasis kona] | diamond | 171 | 56.2 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32676034 | 32676034 | PRJNA734348_P_NODE_90020_length_252_cov_1.720670_g89322_i0 | PRJNA734348 | 90020 | 252 | 1.72067 | 4.3360884 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 61.6 | 9.38e-9 | NR | CUF26021.1 | 75058 | g89322 | i0 | 38.6 | 0.988095238095238 | 83 | 50 | 98.8 | 1 | 1 | 249 | 63 | 144 | CUF26021.1 membrane-associated protein, putative [Bodo saltans] | diamond | 249 | 61.6 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans |
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);;