contig_metadata
18 rows where bioproject = "PRJNA229468" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4884540 | 4884540 | PRJNA229468_S_NODE_144_length_403_cov_3.576271_g131_i0 | PRJNA229468 | 144 | 403 | 3.576271 | 14.41237213 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 499 | 1.15e-136 | NTclustered | gi|330841829|ref|XM_003292845.1| | 5786 | g131 | i0 | 89.421 | 97.8957816377171 | 397 | 40 | 98 | 2 | 8 | 403 | 550 | 945 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_73394), mRNA | blastn | 39452 | 499 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 6159315 | 6159315 | PRJNA229468_S_NODE_5_length_1253_cov_6.700997_g4_i0 | PRJNA229468 | 5 | 1253 | 6.700997 | 83.96349241 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 680 | 1.4699999999999996e-243 | NR | PRP87501.1 | 1890364 | g4 | i0 | 84.8 | 8.96169193934557 | 401 | 61 | 96 | 0 | 1 | 1203 | 32 | 432 | PRP87501.1 elongation factor 1 alpha [Planoprotostelium fungivorum] | diamond | 11229 | 680 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 14396337 | 14396337 | PRJNA229468_S_NODE_412_length_244_cov_2.041026_g399_i0 | PRJNA229468 | 412 | 244 | 2.041026 | 4.98010344 | Lamproderma scintillans | 1115720 | Evosea | other_Eukaryota | 254 | 5.62e-63 | NTclustered | gi|2306687673|gb|MZ234286.1| | 1115720 | g399 | i0 | 85.597 | 73.0409836065574 | 243 | 33 | 99 | 2 | 3 | 244 | 161 | 402 | Lamproderma scintillans voucher LE297459 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 17822 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans | ||
| 23319338 | 23319338 | PRJNA229468_S_NODE_819_length_184_cov_1.096296_g806_i0 | PRJNA229468 | 819 | 184 | 1.096296 | 2.01718464 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 78.6 | 3.77e-15 | NR | KYR02245.1 | 361077 | g806 | i0 | 57.6 | 0.96195652173913 | 59 | 25 | 96.2 | 0 | 6 | 182 | 6 | 64 | KYR02245.1 40S ribosomal protein SA [Tieghemostelium lacteum] | diamond | 177 | 78.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 26884298 | 26884298 | PRJNA229468_S_NODE_361_length_264_cov_3.669767_g348_i0 | PRJNA229468 | 361 | 264 | 3.669767 | 9.68818488 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 58.9 | 4.5e-9 | NR | PRP89373.1 | 1890364 | g348 | i0 | 64.4 | 0.988636363636364 | 87 | 29 | 97.7 | 2 | 259 | 2 | 3 | 88 | PRP89373.1 hypothetical protein PROFUN_01236 [Planoprotostelium fungivorum] | diamond | 261 | 58.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27786887 | 27786887 | PRJNA229468_S_NODE_1124_length_165_cov_0.879310_g1111_i0 | PRJNA229468 | 1124 | 165 | 0.87931 | 1.4508615 | Evosea | 2605435 | Evosea | other_Eukaryota | 50.4 | 1.63e-5 | NR | XP_020437879.1 | 670386 | g1111 | i0 | 43.4 | 1.92727272727273 | 53 | 30 | 96.4 | 0 | 164 | 6 | 12 | 64 | XP_020437879.1 hypothetical protein PPL_01003 [Heterostelium album PN500] | diamond | 318 | 50.8 | 0.992125984251969 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 27863581 | 27863581 | PRJNA229468_S_NODE_1085_length_166_cov_1.299145_g1072_i0 | PRJNA229468 | 1085 | 166 | 1.299145 | 2.1565807 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 84.7 | 3e-18 | NR | PRP82908.1 | 1890364 | g1072 | i0 | 74.1 | 0.975903614457831 | 54 | 14 | 97.6 | 0 | 164 | 3 | 110 | 163 | PRP82908.1 40S ribosomal protein S6 [Planoprotostelium fungivorum] | diamond | 162 | 84.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28021701 | 28021701 | PRJNA229468_S_NODE_445_length_235_cov_1.220430_g432_i0 | PRJNA229468 | 445 | 235 | 1.22043 | 2.8680105 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 75.5 | 9.64e-14 | NR | KAH3743581.1 | 1580589 | g432 | i0 | 49.4 | 0.982978723404255 | 77 | 39 | 98.3 | 0 | 3 | 233 | 937 | 1013 | KAH3743581.1 alpha-actinin A [Pelomyxa schiedti] | diamond | 231 | 75.5 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28084589 | 28084589 | PRJNA229468_S_NODE_505_length_223_cov_0.879310_g492_i0 | PRJNA229468 | 505 | 223 | 0.87931 | 1.9608613 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 56.6 | 3.02e-7 | NR | KAH3756034.1 | 1580589 | g492 | i0 | 37.9 | 0.887892376681614 | 66 | 40 | 88.8 | 1 | 24 | 221 | 49 | 113 | KAH3756034.1 3-isopropylmalate dehydratase [Pelomyxa schiedti] | diamond | 198 | 56.6 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28905371 | 28905371 | PRJNA229468_S_NODE_188_length_352_cov_0.963696_g175_i0 | PRJNA229468 | 188 | 352 | 0.963696 | 3.39220992 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 106 | 1.15e-25 | NR | KAH3756076.1 | 1580589 | g175 | i0 | 48.6 | 0.946022727272727 | 111 | 56 | 93.8 | 1 | 22 | 351 | 60 | 170 | KAH3756076.1 glycoside hydrolase family 25 protein [Pelomyxa schiedti] | diamond | 333 | 106 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29491646 | 29491646 | PRJNA229468_S_NODE_430_length_239_cov_1.342105_g417_i0 | PRJNA229468 | 430 | 239 | 1.342105 | 3.20763095 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 1.65e-27 | NR | XP_003291358.1 | 5786 | g417 | i0 | 57.7 | 22.2928870292887 | 78 | 33 | 97.9 | 0 | 239 | 6 | 265 | 342 | XP_003291358.1 actin binding protein [Dictyostelium purpureum] | diamond | 5328 | 114 | 0.991228070175439 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 29852921 | 29852921 | PRJNA229468_S_NODE_391_length_251_cov_1.009901_g378_i0 | PRJNA229468 | 391 | 251 | 1.009901 | 2.53485151 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 72 | 2.03e-12 | NR | KYR02947.1 | 361077 | g378 | i0 | 63.8 | 0.824701195219124 | 69 | 24 | 81.3 | 1 | 209 | 6 | 735 | 803 | KYR02947.1 I/LWEQ domain-containing protein [Tieghemostelium lacteum] | diamond | 207 | 72 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 29979211 | 29979211 | PRJNA229468_S_NODE_731_length_192_cov_1.069930_g718_i0 | PRJNA229468 | 731 | 192 | 1.06993 | 2.0542656 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 67 | 5.31e-11 | NR | XP_003284159.1 | 5786 | g718 | i0 | 55.9 | 9.625 | 59 | 26 | 92.2 | 0 | 192 | 16 | 16 | 74 | XP_003284159.1 uncharacterized protein DICPUDRAFT_27275, partial [Dictyostelium purpureum] | diamond | 1848 | 67 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 30642553 | 30642553 | PRJNA229468_S_NODE_533_length_217_cov_1.113095_g520_i0 | PRJNA229468 | 533 | 217 | 1.113095 | 2.41541615 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 58.5 | 6.94e-8 | NR | KYQ89057.1 | 361077 | g520 | i0 | 51.4 | 0.967741935483871 | 70 | 34 | 96.8 | 0 | 215 | 6 | 655 | 724 | KYQ89057.1 major vault protein [Tieghemostelium lacteum] | diamond | 210 | 58.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30769172 | 30769172 | PRJNA229468_S_NODE_1134_length_165_cov_0.879310_g1121_i0 | PRJNA229468 | 1134 | 165 | 0.87931 | 1.4508615 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 97.8 | 1.54e-23 | NR | XP_004352159.1 | 261658 | g1121 | i0 | 85.2 | 1.96363636363636 | 54 | 8 | 98.2 | 0 | 162 | 1 | 149 | 202 | XP_004352159.1 40S ribosomal protein S3 [Cavenderia fasciculata] | diamond | 324 | 97.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 32223799 | 32223799 | PRJNA229468_S_NODE_158_length_383_cov_4.443114_g145_i0 | PRJNA229468 | 158 | 383 | 4.443114 | 17.01712662 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 130 | 2.3e-35 | NR | PRP86688.1 | 1890364 | g145 | i0 | 56.1 | 1.93472584856397 | 123 | 52 | 94.8 | 2 | 3 | 365 | 84 | 206 | PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum] | diamond | 741 | 130 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32540338 | 32540338 | PRJNA229468_S_NODE_1019_length_169_cov_1.458333_g1006_i0 | PRJNA229468 | 1019 | 169 | 1.458333 | 2.46458277 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 65.9 | 9.64e-11 | NR | PRP88631.1 | 1890364 | g1006 | i0 | 78.4 | 0.656804733727811 | 37 | 8 | 65.7 | 0 | 114 | 4 | 377 | 413 | PRP88631.1 hypothetical protein PROFUN_03042 [Planoprotostelium fungivorum] | diamond | 111 | 65.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32666113 | 32666113 | PRJNA229468_S_NODE_580_length_212_cov_0.938650_g567_i0 | PRJNA229468 | 580 | 212 | 0.93865 | 1.989938 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 55.5 | 8.14e-7 | NR | XP_003288439.1 | 5786 | g567 | i0 | 41.4 | 4.13207547169811 | 70 | 40 | 99.1 | 1 | 1 | 210 | 773 | 841 | XP_003288439.1 uncharacterized protein DICPUDRAFT_47922 [Dictyostelium purpureum] | diamond | 876 | 55.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;