contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA922890" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3449150 | 3449150 | PRJNA922890_P_NODE_56523_length_260_cov_1.387435_g56113_i0 | PRJNA922890 | 56523 | 260 | 1.387435 | 3.607331 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 87 | 6.91e-19 | NR | PRP85435.1 | 1890364 | g56113 | i0 | 58.1 | 0.992307692307692 | 86 | 35 | 99.2 | 1 | 260 | 3 | 91 | 175 | PRP85435.1 component of cytosolic 80S ribosome and 40S small subunit [Planoprotostelium fungivorum] | diamond | 258 | 87 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 14926595 | 14926595 | PRJNA922890_P_NODE_75612_length_232_cov_0.883436_g75202_i0 | PRJNA922890 | 75612 | 232 | 0.883436 | 2.04957152 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 118 | 4.87e-29 | NR | XP_003285685.1 | 5786 | g75202 | i0 | 71.4 | 5.97413793103448 | 77 | 22 | 99.6 | 0 | 1 | 231 | 259 | 335 | XP_003285685.1 uncharacterized protein DICPUDRAFT_53740 [Dictyostelium purpureum] | diamond | 1386 | 118 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 26676165 | 26676165 | PRJNA922890_P_NODE_75821_length_232_cov_0.883436_g75411_i0 | PRJNA922890 | 75821 | 232 | 0.883436 | 2.04957152 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 89 | 1.11e-18 | NR | PRP78298.1 | 1890364 | g75411 | i0 | 63.1 | 0.84051724137931 | 65 | 22 | 81.5 | 2 | 191 | 3 | 213 | 277 | PRP78298.1 hypothetical protein PROFUN_13832 [Planoprotostelium fungivorum] | diamond | 195 | 89 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26739333 | 26739333 | PRJNA922890_P_NODE_68661_length_235_cov_1.506024_g68251_i0 | PRJNA922890 | 68661 | 235 | 1.506024 | 3.5391564 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 83.6 | 7.65e-18 | NR | PRP76965.1 | 1890364 | g68251 | i0 | 70.7 | 0.740425531914894 | 58 | 13 | 74 | 2 | 6 | 179 | 74 | 127 | PRP76965.1 hypothetical protein PROFUN_14666 [Planoprotostelium fungivorum] | diamond | 174 | 83.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26771483 | 26771483 | PRJNA922890_P_NODE_66581_length_237_cov_1.464286_g66171_i0 | PRJNA922890 | 66581 | 237 | 1.464286 | 3.47035782 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 69.3 | 1.5e-11 | NR | XP_012759458.1 | 1410327 | g66171 | i0 | 44.7 | 0.962025316455696 | 76 | 42 | 96.2 | 0 | 9 | 236 | 2390 | 2465 | XP_012759458.1 hypothetical protein SAMD00019534_005710 [Acytostelium subglobosum LB1] | diamond | 228 | 69.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 28130251 | 28130251 | PRJNA922890_P_NODE_79225_length_230_cov_0.906832_g78815_i0 | PRJNA922890 | 79225 | 230 | 0.906832 | 2.0857136 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 75.5 | 9.19e-14 | NR | KAF2068463.1 | 133409 | g78815 | i0 | 53.9 | 1.9695652173913 | 76 | 35 | 99.1 | 0 | 228 | 1 | 734 | 809 | KAF2068463.1 hypothetical protein CYY_010210 [Polysphondylium violaceum] | diamond | 453 | 75.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 28477482 | 28477482 | PRJNA922890_P_NODE_52346_length_270_cov_1.154229_g51936_i0 | PRJNA922890 | 52346 | 270 | 1.154229 | 3.1164183 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 79.7 | 5.29e-15 | NR | XP_020435067.1 | 670386 | g51936 | i0 | 42.5 | 1.98888888888889 | 87 | 48 | 94.4 | 1 | 16 | 270 | 729 | 815 | XP_020435067.1 Ras guanine nucleotide exchange factor [Heterostelium album PN500] | diamond | 537 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28516362 | 28516362 | PRJNA922890_P_NODE_67907_length_236_cov_0.874251_g67497_i0 | PRJNA922890 | 67907 | 236 | 0.874251 | 2.06323236 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 61.6 | 7.72e-9 | NR | KAF2076491.1 | 133409 | g67497 | i0 | 61.4 | 3.35593220338983 | 44 | 17 | 55.9 | 0 | 1 | 132 | 2196 | 2239 | KAF2076491.1 hypothetical protein CYY_002231 [Polysphondylium violaceum] | diamond | 792 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 28635579 | 28635579 | PRJNA922890_P_NODE_16187_length_475_cov_1.748768_g15777_i0 | PRJNA922890 | 16187 | 475 | 1.748768 | 8.306648 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 167 | 7.239999999999999e-48 | NR | KYR02370.1 | 361077 | g15777 | i0 | 59 | 4.25684210526316 | 134 | 54 | 84 | 1 | 399 | 1 | 161 | 294 | KYR02370.1 AhpC/TSA family protein [Tieghemostelium lacteum] | diamond | 2022 | 167 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30656547 | 30656547 | PRJNA922890_P_NODE_72853_length_233_cov_0.890244_g72443_i0 | PRJNA922890 | 72853 | 233 | 0.890244 | 2.07426852 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 79.7 | 3.14e-15 | NR | PRP78340.1 | 1890364 | g72443 | i0 | 57.1 | 0.991416309012876 | 77 | 30 | 96.6 | 2 | 228 | 4 | 795 | 870 | PRP78340.1 hypothetical protein PROFUN_11380 [Planoprotostelium fungivorum] | diamond | 231 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31604950 | 31604950 | PRJNA922890_P_NODE_67536_length_236_cov_1.736527_g67126_i0 | PRJNA922890 | 67536 | 236 | 1.736527 | 4.09820372 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 94.4 | 2.36e-20 | NR | PRP80037.1 | 1890364 | g67126 | i0 | 59.5 | 1.00423728813559 | 79 | 31 | 99.2 | 1 | 234 | 1 | 993 | 1071 | PRP80037.1 WD repeat domain 35-like [Planoprotostelium fungivorum] | diamond | 237 | 94.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31984406 | 31984406 | PRJNA922890_P_NODE_38418_length_312_cov_1.152263_g38008_i0 | PRJNA922890 | 38418 | 312 | 1.152263 | 3.59506056 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 122 | 6.98e-32 | NR | PRP84553.1 | 1890364 | g38008 | i0 | 68.8 | 0.894230769230769 | 93 | 28 | 88.5 | 1 | 35 | 310 | 100 | 192 | PRP84553.1 hypothetical protein PROFUN_05888 [Planoprotostelium fungivorum] | diamond | 279 | 122 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32047832 | 32047832 | PRJNA922890_P_NODE_60838_length_250_cov_1.314917_g60428_i0 | PRJNA922890 | 60838 | 250 | 1.314917 | 3.2872925 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 125 | 4.46e-35 | NR | XP_004362999.1 | 261658 | g60428 | i0 | 81.2 | 3.312 | 69 | 13 | 82.8 | 0 | 43 | 249 | 7 | 75 | XP_004362999.1 cytochrome c [Cavenderia fasciculata] | diamond | 828 | 125 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 32047834 | 32047834 | PRJNA922890_P_NODE_83878_length_228_cov_0.905660_g83468_i0 | PRJNA922890 | 83878 | 228 | 0.90566 | 2.0649048 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 132 | 2.22e-36 | NR | PRP74248.1 | 1890364 | g83468 | i0 | 82.9 | 1 | 76 | 13 | 100 | 0 | 228 | 1 | 125 | 200 | PRP74248.1 hypothetical protein PROFUN_11995 [Planoprotostelium fungivorum] | diamond | 228 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32522681 | 32522681 | PRJNA922890_P_NODE_65679_length_239_cov_1.452941_g65269_i0 | PRJNA922890 | 65679 | 239 | 1.452941 | 3.47252899 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 62.4 | 3.85e-9 | NR | KYQ91236.1 | 361077 | g65269 | i0 | 69 | 1.64435146443515 | 42 | 13 | 52.7 | 0 | 14 | 139 | 264 | 305 | KYQ91236.1 putative protein tyrosine phosphatase [Tieghemostelium lacteum] | diamond | 393 | 62.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum |
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);;