contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655546 | 1655546 | PRJNA315314_S_NODE_18422_length_192_cov_2.815951_g18101_i0 | PRJNA315314 | 18422 | 192 | 2.815951 | 5.40662592 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 2.3399999999999994e-23 | NR | PRP80538.1 | 1890364 | g18101 | i0 | 82 | 3.8125 | 61 | 11 | 95.3 | 0 | 185 | 3 | 539 | 599 | PRP80538.1 ABC transporter E family member 2-like [Planoprotostelium fungivorum] | diamond | 732 | 103 | 0.990291262135922 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26680223 | 26680223 | PRJNA315314_S_NODE_20481_length_183_cov_1.727273_g20160_i0 | PRJNA315314 | 20481 | 183 | 1.727273 | 3.16090959 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 49.7 | 5.65e-5 | NR | XP_003292987.1 | 5786 | g20160 | i0 | 53.7 | 5.65573770491803 | 41 | 16 | 62.3 | 1 | 180 | 67 | 244 | 284 | XP_003292987.1 spermidine synthase [Dictyostelium purpureum] | diamond | 1035 | 50.1 | 0.992015968063872 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 26775535 | 26775535 | PRJNA315314_S_NODE_31621_length_152_cov_1.154472_g31300_i0 | PRJNA315314 | 31621 | 152 | 1.154472 | 1.75479744 | Dictyosteliales | 2058949 | Evosea | other_Eukaryota | 55.8 | 1.27e-7 | NR | XP_636960.1 | 352472 | g31300 | i0 | 69.4 | 4.97368421052632 | 36 | 11 | 71.1 | 0 | 1 | 108 | 167 | 202 | XP_636960.1 hypothetical protein DDB_G0288053 [Dictyostelium discoideum AX4] | diamond | 756 | 56.2 | 0.99288256227758 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 26807074 | 26807074 | PRJNA315314_S_NODE_7621_length_292_cov_4.946768_g7300_i0 | PRJNA315314 | 7621 | 292 | 4.946768 | 14.44456256 | Dictyosteliales | 2058949 | Evosea | other_Eukaryota | 99 | 4.1200000000000003e-22 | NR | XP_643401.2 | 352472 | g7300 | i0 | 48.4 | 2.96917808219178 | 95 | 49 | 97.6 | 0 | 291 | 7 | 115 | 209 | XP_643401.2 S-adenosylmethionine decarboxylase [Dictyostelium discoideum AX4] | diamond | 867 | 100 | 0.99 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27863900 | 27863900 | PRJNA315314_S_NODE_15545_length_208_cov_1.497207_g15224_i0 | PRJNA315314 | 15545 | 208 | 1.497207 | 3.11419056 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 56.6 | 1.63e-7 | NR | XP_020433113.1 | 670386 | g15224 | i0 | 53.4 | 3.40384615384615 | 58 | 22 | 83.7 | 1 | 2 | 175 | 165 | 217 | XP_020433113.1 Rab GTPase [Heterostelium album PN500] | diamond | 708 | 56.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28671001 | 28671001 | PRJNA315314_S_NODE_24887_length_168_cov_1.928058_g24566_i0 | PRJNA315314 | 24887 | 168 | 1.928058 | 3.23913744 | Acytosteliaceae | 2058183 | Evosea | other_Eukaryota | 98.6 | 2.99e-22 | NR | XP_020429784.1 | 670386 | g24566 | i0 | 72.7 | 8.82142857142857 | 55 | 15 | 98.2 | 0 | 168 | 4 | 934 | 988 | XP_020429784.1 cobalamin-dependent methionine synthase [Heterostelium album PN500] | diamond | 1482 | 98.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28955276 | 28955276 | PRJNA315314_S_NODE_19548_length_187_cov_1.455696_g19227_i0 | PRJNA315314 | 19548 | 187 | 1.455696 | 2.72215152 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 1.12e-24 | NR | XP_003287730.1 | 5786 | g19227 | i0 | 75.8 | 34.8128342245989 | 62 | 15 | 99.5 | 0 | 2 | 187 | 160 | 221 | XP_003287730.1 40S ribosomal protein S2 [Dictyostelium purpureum] | diamond | 6510 | 103 | 0.990291262135922 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28969225 | 28969225 | PRJNA315314_S_NODE_28488_length_158_cov_2.627907_g28167_i0 | PRJNA315314 | 28488 | 158 | 2.627907 | 4.15209306 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 63.2 | 6.38e-10 | NR | KYQ96683.1 | 361077 | g28167 | i0 | 56 | 1.93670886075949 | 50 | 22 | 94.9 | 0 | 8 | 157 | 1 | 50 | KYQ96683.1 Mov34/MPN/PAD-1 family protein [Tieghemostelium lacteum] | diamond | 306 | 63.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 29316424 | 29316424 | PRJNA315314_S_NODE_24569_length_169_cov_1.464286_g24248_i0 | PRJNA315314 | 24569 | 169 | 1.464286 | 2.47464334 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 92.8 | 4.95e-21 | NR | XP_012758962.1 | 1410327 | g24248 | i0 | 76.4 | 2.92899408284024 | 55 | 13 | 97.6 | 0 | 3 | 167 | 217 | 271 | XP_012758962.1 hypothetical protein SAMD00019534_000750 [Acytostelium subglobosum LB1] | diamond | 495 | 92.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 29979525 | 29979525 | PRJNA315314_S_NODE_12871_length_227_cov_2.065657_g12550_i0 | PRJNA315314 | 12871 | 227 | 2.065657 | 4.68904139 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 47.8 | 5.09e-4 | NR | PRP88258.1 | 1890364 | g12550 | i0 | 34.9 | 1.62555066079295 | 63 | 37 | 81.9 | 2 | 3 | 188 | 326 | 385 | PRP88258.1 LPXTG-motif cell wall anchor domain-containing protein [Planoprotostelium fungivorum] | diamond | 369 | 47.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29979528 | 29979528 | PRJNA315314_S_NODE_15771_length_206_cov_3.802260_g15450_i0 | PRJNA315314 | 15771 | 206 | 3.80226 | 7.8326556 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 71.2 | 1.18e-13 | NR | KAH3759508.1 | 1580589 | g15450 | i0 | 56.5 | 1.00485436893204 | 69 | 25 | 97.6 | 2 | 2 | 202 | 10 | 75 | KAH3759508.1 hypothetical protein Pelo_8679 [Pelomyxa schiedti] | diamond | 207 | 71.2 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 30218162 | 30218162 | PRJNA315314_S_NODE_14812_length_212_cov_4.923497_g14491_i0 | PRJNA315314 | 14812 | 212 | 4.923497 | 10.43781364 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 91.3 | 1.06e-19 | NR | XP_004357207.1 | 261658 | g14491 | i0 | 69.8 | 3.55188679245283 | 63 | 18 | 89.2 | 1 | 22 | 210 | 78 | 139 | XP_004357207.1 S-adenosylmethionine decarboxylase [Cavenderia fasciculata] | diamond | 753 | 91.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30769530 | 30769530 | PRJNA315314_S_NODE_15874_length_206_cov_1.418079_g15553_i0 | PRJNA315314 | 15874 | 206 | 1.418079 | 2.92124274 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 63.2 | 2.27e-10 | NR | KAH3764251.1 | 1580589 | g15553 | i0 | 48.5 | 0.990291262135922 | 68 | 33 | 97.6 | 2 | 203 | 3 | 80 | 146 | KAH3764251.1 hypothetical protein Pelo_3898 [Pelomyxa schiedti] | diamond | 204 | 63.2 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 31306594 | 31306594 | PRJNA315314_S_NODE_11415_length_240_cov_3.127962_g11094_i0 | PRJNA315314 | 11415 | 240 | 3.127962 | 7.5071088 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 76.6 | 2.83e-14 | NR | PRP79852.1 | 1890364 | g11094 | i0 | 52.9 | 0.875 | 70 | 33 | 87.5 | 0 | 2 | 211 | 79 | 148 | PRP79852.1 hypothetical protein PROFUN_12464 [Planoprotostelium fungivorum] | diamond | 210 | 76.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31591550 | 31591550 | PRJNA315314_S_NODE_8036_length_285_cov_4.039062_g7715_i0 | PRJNA315314 | 8036 | 285 | 4.039062 | 11.5113267 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 50.4 | 1.16e-4 | NR | XP_004259638.1 | 370355 | g7715 | i0 | 42.6 | 1.75789473684211 | 54 | 29 | 55.8 | 2 | 280 | 122 | 334 | 386 | XP_004259638.1 hypothetical protein EIN_508680 [Entamoeba invadens IP1] | diamond | 501 | 50.4 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 31893501 | 31893501 | PRJNA315314_S_NODE_6477_length_317_cov_4.388889_g6156_i0 | PRJNA315314 | 6477 | 317 | 4.388889 | 13.91277813 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 133 | 3.16e-35 | NR | XP_003290851.1 | 5786 | g6156 | i0 | 64.8 | 15.8044164037855 | 105 | 36 | 99.4 | 1 | 1 | 315 | 128 | 231 | XP_003290851.1 uncharacterized protein DICPUDRAFT_49487 [Dictyostelium purpureum] | diamond | 5010 | 133 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32413981 | 32413981 | PRJNA315314_S_NODE_11399_length_240_cov_3.734597_g11078_i0 | PRJNA315314 | 11399 | 240 | 3.734597 | 8.9630328 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 70.1 | 7.92e-12 | NR | KAF2074889.1 | 133409 | g11078 | i0 | 50 | 2.0375 | 80 | 39 | 98.8 | 1 | 239 | 3 | 287 | 366 | KAF2074889.1 hypothetical protein CYY_003808 [Polysphondylium violaceum] | diamond | 489 | 70.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 32697908 | 32697908 | PRJNA315314_S_NODE_31540_length_152_cov_1.666667_g31219_i0 | PRJNA315314 | 31540 | 152 | 1.666667 | 2.53333384 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 69.3 | 4.48e-12 | NR | KAF2073598.1 | 133409 | g31219 | i0 | 60 | 0.986842105263158 | 50 | 20 | 98.7 | 0 | 152 | 3 | 112 | 161 | KAF2073598.1 hypothetical protein CYY_005087 [Polysphondylium violaceum] | diamond | 150 | 69.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum |
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);;