contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA724039" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22388457 | 22388457 | PRJNA724039_S_NODE_11518_length_190_cov_1.248366_g11311_i0 | PRJNA724039 | 11518 | 190 | 1.248366 | 2.3718954 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 67 | 5.42e-12 | NR | PRP74141.1 | 1890364 | g11311 | i0 | 70.3 | 1.01052631578947 | 64 | 13 | 96.3 | 4 | 184 | 2 | 1 | 61 | PRP74141.1 histone H2A [Planoprotostelium fungivorum] | diamond | 192 | 67 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26799007 | 26799007 | PRJNA724039_S_NODE_9061_length_217_cov_3.366667_g8854_i0 | PRJNA724039 | 9061 | 217 | 3.366667 | 7.30566739 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 63.9 | 9.1e-10 | NR | KYQ96878.1 | 361077 | g8854 | i0 | 46.8 | 0.857142857142857 | 62 | 33 | 85.7 | 0 | 217 | 32 | 691 | 752 | KYQ96878.1 gelation factor [Tieghemostelium lacteum] | diamond | 186 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 27052336 | 27052336 | PRJNA724039_S_NODE_5302_length_303_cov_1.733083_g5095_i0 | PRJNA724039 | 5302 | 303 | 1.733083 | 5.25124149 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 153 | 1.1099999999999998e-41 | NR | AAG31138.1 | 5791 | g5095 | i0 | 69.9 | 1.01980198019802 | 103 | 28 | 99 | 1 | 302 | 3 | 202 | 304 | AAG31138.1 fragmin60 [Physarum polycephalum] | diamond | 309 | 153 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 27820843 | 27820843 | PRJNA724039_S_NODE_11204_length_193_cov_1.301282_g10997_i0 | PRJNA724039 | 11204 | 193 | 1.301282 | 2.51147426 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 90.1 | 4.69e-21 | NR | XP_004366312.1 | 261658 | g10997 | i0 | 61 | 2.75129533678756 | 59 | 23 | 91.7 | 0 | 180 | 4 | 46 | 104 | XP_004366312.1 ubiquitin-conjugating enzyme E2 [Cavenderia fasciculata] | diamond | 531 | 90.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28252300 | 28252300 | PRJNA724039_S_NODE_15666_length_161_cov_1.895161_g15459_i0 | PRJNA724039 | 15666 | 161 | 1.895161 | 3.05120921 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 75.1 | 4.75e-14 | NR | KAH3744683.1 | 1580589 | g15459 | i0 | 59.6 | 1.97515527950311 | 52 | 21 | 96.9 | 0 | 157 | 2 | 1543 | 1594 | KAH3744683.1 hypothetical protein Pelo_13925 [Pelomyxa schiedti] | diamond | 318 | 75.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28915158 | 28915158 | PRJNA724039_S_NODE_17628_length_152_cov_1.695652_g17421_i0 | PRJNA724039 | 17628 | 152 | 1.695652 | 2.57739104 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 52.4 | 1.83e-6 | NR | PRP78810.1 | 1890364 | g17421 | i0 | 56.3 | 0.947368421052632 | 48 | 21 | 94.7 | 0 | 148 | 5 | 106 | 153 | PRP78810.1 hypothetical protein PROFUN_00983 [Planoprotostelium fungivorum] | diamond | 144 | 52.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29168220 | 29168220 | PRJNA724039_S_NODE_10489_length_200_cov_1.754601_g10282_i0 | PRJNA724039 | 10489 | 200 | 1.754601 | 3.509202 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 63.2 | 1.33e-9 | NR | KYQ96878.1 | 361077 | g10282 | i0 | 46.8 | 1.89 | 62 | 31 | 93 | 1 | 192 | 7 | 379 | 438 | KYQ96878.1 gelation factor [Tieghemostelium lacteum] | diamond | 378 | 63.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30463381 | 30463381 | PRJNA724039_S_NODE_15193_length_164_cov_1.212598_g14986_i0 | PRJNA724039 | 15193 | 164 | 1.212598 | 1.98866072 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 73.2 | 7.27e-14 | NR | ATE46695.1 | 1890364 | g14986 | i0 | 74.1 | 0.98780487804878 | 54 | 14 | 98.8 | 0 | 162 | 1 | 112 | 165 | ATE46695.1 ATPase subunit 6 [Planoprotostelium fungivorum] | diamond | 162 | 73.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31063527 | 31063527 | PRJNA724039_S_NODE_7115_length_252_cov_2.311628_g6908_i0 | PRJNA724039 | 7115 | 252 | 2.311628 | 5.82530256 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 61.2 | 1.26e-8 | NR | XP_020436833.1 | 670386 | g6908 | i0 | 37.9 | 1.42857142857143 | 66 | 41 | 78.6 | 0 | 205 | 8 | 688 | 753 | XP_020436833.1 gelation factor [Heterostelium album PN500] | diamond | 360 | 61.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 31484867 | 31484867 | PRJNA724039_S_NODE_16276_length_158_cov_1.355372_g16069_i0 | PRJNA724039 | 16276 | 158 | 1.355372 | 2.14148776 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 3.59e-16 | NR | KAF2075930.1 | 133409 | g16069 | i0 | 65.4 | 11.8481012658228 | 52 | 18 | 98.7 | 0 | 156 | 1 | 90 | 141 | KAF2075930.1 hypothetical protein CYY_002778 [Polysphondylium violaceum] | diamond | 1872 | 80.9 | 0.995055624227441 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 31695727 | 31695727 | PRJNA724039_S_NODE_7157_length_251_cov_2.144860_g6950_i0 | PRJNA724039 | 7157 | 251 | 2.14486 | 5.3835986 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 67.4 | 8.49e-11 | NR | KAH3767700.1 | 1580589 | g6950 | i0 | 42.4 | 1.01593625498008 | 85 | 46 | 98 | 2 | 247 | 2 | 485 | 569 | KAH3767700.1 gelation factor [Pelomyxa schiedti] | diamond | 255 | 67.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 31948665 | 31948665 | PRJNA724039_S_NODE_13257_length_176_cov_1.402878_g13050_i0 | PRJNA724039 | 13257 | 176 | 1.402878 | 2.46906528 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 79.7 | 5.29e-16 | NR | XP_003287614.1 | 5786 | g13050 | i0 | 75 | 0.886363636363636 | 52 | 12 | 88.6 | 1 | 176 | 21 | 245 | 295 | XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum] | diamond | 156 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32053995 | 32053995 | PRJNA724039_S_NODE_6998_length_255_cov_2.110092_g6791_i0 | PRJNA724039 | 6998 | 255 | 2.110092 | 5.3807346 | Evosea | 2605435 | Evosea | other_Eukaryota | 107 | 9.889999999999999e-28 | NR | KYR02504.1 | 361077 | g6791 | i0 | 63.4 | 4.75294117647059 | 82 | 30 | 96.5 | 0 | 246 | 1 | 34 | 115 | KYR02504.1 actin binding protein [Tieghemostelium lacteum] | diamond | 1212 | 108 | 0.990740740740741 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32233857 | 32233857 | PRJNA724039_S_NODE_9398_length_213_cov_1.460227_g9191_i0 | PRJNA724039 | 9398 | 213 | 1.460227 | 3.11028351 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 112 | 1.36e-28 | NR | PRP75505.1 | 1890364 | g9191 | i0 | 71.8 | 1 | 71 | 20 | 100 | 0 | 1 | 213 | 190 | 260 | PRP75505.1 40S ribosomal protein S4, X isoform-like [Planoprotostelium fungivorum] | diamond | 213 | 112 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32391777 | 32391777 | PRJNA724039_S_NODE_16899_length_155_cov_1.983051_g16692_i0 | PRJNA724039 | 16899 | 155 | 1.983051 | 3.07372905 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 78.6 | 2.61e-15 | NR | PRP86149.1 | 1890364 | g16692 | i0 | 70 | 0.967741935483871 | 50 | 15 | 96.8 | 0 | 150 | 1 | 566 | 615 | PRP86149.1 40S ribosomal protein S16-like [Planoprotostelium fungivorum] | diamond | 150 | 78.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;