contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20703 | 20703 | PRJEB12237_P_NODE_5741_length_247_cov_1.320755_g5545_i0 | PRJEB12237 | 5741 | 247 | 1.320755 | 3.26226485 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 4.78e-34 | NR | XP_003290152.1 | 5786 | g5545 | i0 | 76.9 | 7.40890688259109 | 78 | 18 | 94.7 | 0 | 236 | 3 | 1 | 78 | XP_003290152.1 uncharacterized protein DICPUDRAFT_154640 [Dictyostelium purpureum] | diamond | 1830 | 130 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 2260897 | 2260897 | PRJEB12237_P_NODE_7702_length_200_cov_1.454545_g7506_i0 | PRJEB12237 | 7702 | 200 | 1.454545 | 2.90909 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 57.4 | 1.41e-7 | NR | PRP79145.1 | 1890364 | g7506 | i0 | 40.9 | 0.99 | 66 | 36 | 99 | 1 | 199 | 2 | 333 | 395 | PRP79145.1 aspartic proteinase-like protein 2 isoform 2 [Planoprotostelium fungivorum] | diamond | 198 | 57.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 16597466 | 16597466 | PRJEB12237_P_NODE_1454_length_598_cov_2.000000_g1281_i0 | PRJEB12237 | 1454 | 598 | 2 | 11.96 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 290 | 2.56e-93 | NR | KYQ90475.1 | 361077 | g1281 | i0 | 72.2 | 4.94147157190635 | 198 | 50 | 99.3 | 2 | 598 | 5 | 272 | 464 | KYQ90475.1 protein transport protein SEC61 alpha subunit [Tieghemostelium lacteum] | diamond | 2955 | 290 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 23937962 | 23937962 | PRJEB12237_P_NODE_5219_length_266_cov_1.151515_g5023_i0 | PRJEB12237 | 5219 | 266 | 1.151515 | 3.0630299 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 91.7 | 5.3100000000000005e-21 | NR | KAH3757948.1 | 1580589 | g5023 | i0 | 50 | 2.96616541353383 | 88 | 44 | 99.2 | 0 | 265 | 2 | 2 | 89 | KAH3757948.1 40S ribosomal protein S27a [Pelomyxa schiedti] | diamond | 789 | 91.7 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 27032928 | 27032928 | PRJEB12237_P_NODE_6742_length_220_cov_1.545946_g6546_i0 | PRJEB12237 | 6742 | 220 | 1.545946 | 3.4010812 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 46.2 | 0.00163 | NR | KAH3745657.1 | 1580589 | g6546 | i0 | 37.8 | 1.00909090909091 | 74 | 43 | 99.5 | 2 | 219 | 1 | 298 | 369 | KAH3745657.1 hypothetical protein Pelo_12951 [Pelomyxa schiedti] | diamond | 222 | 46.2 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 27127403 | 27127403 | PRJEB12237_P_NODE_1402_length_610_cov_2.606957_g1231_i0 | PRJEB12237 | 1402 | 610 | 2.606957 | 15.9024377 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 143 | 7.8e-38 | NR | PRP81988.1 | 1890364 | g1231 | i0 | 47.4 | 2.02622950819672 | 137 | 70 | 66.9 | 2 | 50 | 457 | 9 | 144 | PRP81988.1 putative nnucleoredoxin [Planoprotostelium fungivorum] | diamond | 1236 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27311402 | 27311402 | PRJEB12237_P_NODE_7783_length_199_cov_1.189024_g7587_i0 | PRJEB12237 | 7783 | 199 | 1.189024 | 2.36615776 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.2 | 8.34e-11 | NR | XP_640846.1 | 352472 | g7587 | i0 | 48.1 | 5.74371859296482 | 54 | 28 | 81.4 | 0 | 162 | 1 | 112 | 165 | XP_640846.1 Mov34/MPN/PAD-1 family protein [Dictyostelium discoideum AX4] | diamond | 1143 | 66.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27974275 | 27974275 | PRJEB12237_P_NODE_12125_length_150_cov_1.686957_g11929_i0 | PRJEB12237 | 12125 | 150 | 1.686957 | 2.5304355 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 59.7 | 1.1e-8 | NR | XP_003284548.1 | 5786 | g11929 | i0 | 56.5 | 3.8 | 46 | 20 | 92 | 0 | 7 | 144 | 265 | 310 | XP_003284548.1 uncharacterized protein DICPUDRAFT_148335 [Dictyostelium purpureum] | diamond | 570 | 60.1 | 0.993344425956739 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28012365 | 28012365 | PRJEB12237_P_NODE_7705_length_200_cov_1.448485_g7509_i0 | PRJEB12237 | 7705 | 200 | 1.448485 | 2.89697 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 80.1 | 5.53e-16 | NR | KYR02323.1 | 361077 | g7509 | i0 | 56.1 | 1.98 | 66 | 28 | 99 | 1 | 2 | 199 | 78 | 142 | KYR02323.1 actin bundling protein [Tieghemostelium lacteum] | diamond | 396 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 28075211 | 28075211 | PRJEB12237_P_NODE_4625_length_291_cov_1.699219_g4429_i0 | PRJEB12237 | 4625 | 291 | 1.699219 | 4.94472729 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 53.9 | 7.53e-6 | NR | XP_004363000.1 | 261658 | g4429 | i0 | 41.8 | 0.690721649484536 | 67 | 37 | 69.1 | 2 | 71 | 271 | 480 | 544 | XP_004363000.1 uncharacterized protein DFA_03396 [Cavenderia fasciculata] | diamond | 201 | 53.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28201402 | 28201402 | PRJEB12237_P_NODE_7906_length_197_cov_1.234568_g7710_i0 | PRJEB12237 | 7906 | 197 | 1.234568 | 2.43209896 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 66.6 | 3.42e-11 | NR | XP_020433716.1 | 670386 | g7710 | i0 | 45.3 | 1.90355329949239 | 64 | 35 | 97.5 | 0 | 192 | 1 | 122 | 185 | XP_020433716.1 component of the counting factor complex [Heterostelium album PN500] | diamond | 375 | 66.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28226596 | 28226596 | PRJEB12237_P_NODE_10226_length_166_cov_1.404580_g10030_i0 | PRJEB12237 | 10226 | 166 | 1.40458 | 2.3316028 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 70.9 | 1.6e-12 | NR | XP_004361449.1 | 261658 | g10030 | i0 | 60.7 | 6.07228915662651 | 56 | 21 | 99.4 | 1 | 1 | 165 | 685 | 740 | XP_004361449.1 uncharacterized protein DFA_05732 [Cavenderia fasciculata] | diamond | 1008 | 70.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28454399 | 28454399 | PRJEB12237_P_NODE_5186_length_267_cov_2.926724_g4990_i0 | PRJEB12237 | 5186 | 267 | 2.926724 | 7.81435308 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 95.9 | 5.55e-23 | NR | XP_012758992.1 | 1410327 | g4990 | i0 | 59.3 | 0.910112359550562 | 81 | 33 | 91 | 0 | 23 | 265 | 1 | 81 | XP_012758992.1 hypothetical protein SAMD00019534_001050 [Acytostelium subglobosum LB1] | diamond | 243 | 95.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 29022902 | 29022902 | PRJEB12237_P_NODE_10888_length_160_cov_1.352000_g10692_i0 | PRJEB12237 | 10888 | 160 | 1.352 | 2.1632 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 44.3 | 6.84e-4 | NR | PRP89373.1 | 1890364 | g10692 | i0 | 59 | 1.40625 | 39 | 16 | 73.1 | 0 | 41 | 157 | 4 | 42 | PRP89373.1 hypothetical protein PROFUN_01236 [Planoprotostelium fungivorum] | diamond | 225 | 44.3 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29306627 | 29306627 | PRJEB12237_P_NODE_4689_length_288_cov_1.798419_g4493_i0 | PRJEB12237 | 4689 | 288 | 1.798419 | 5.17944672 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 128 | 4.54e-32 | NR | PRP81845.1 | 1890364 | g4493 | i0 | 58.9 | 0.989583333333333 | 95 | 39 | 99 | 0 | 2 | 286 | 820 | 914 | PRP81845.1 P-type ATPase [Planoprotostelium fungivorum] | diamond | 285 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31296876 | 31296876 | PRJEB12237_P_NODE_7215_length_210_cov_0.908571_g7019_i0 | PRJEB12237 | 7215 | 210 | 0.908571 | 1.9079991 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 46.2 | 0.00142 | NR | KYQ89878.1 | 361077 | g7019 | i0 | 54.3 | 0.5 | 35 | 16 | 50 | 0 | 3 | 107 | 154 | 188 | KYQ89878.1 Ankyrin repeat-containing protein [Tieghemostelium lacteum] | diamond | 105 | 46.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32151086 | 32151086 | PRJEB12237_P_NODE_9458_length_175_cov_1.142857_g9262_i0 | PRJEB12237 | 9458 | 175 | 1.142857 | 1.99999975 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 73.9 | 1.5e-13 | NR | KYQ88330.1 | 361077 | g9262 | i0 | 56.9 | 0.994285714285714 | 58 | 25 | 99.4 | 0 | 1 | 174 | 922 | 979 | KYQ88330.1 NAD+ dependent glutamate dehydrogenase [Tieghemostelium lacteum] | diamond | 174 | 73.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32372677 | 32372677 | PRJEB12237_P_NODE_7519_length_203_cov_1.904762_g7323_i0 | PRJEB12237 | 7519 | 203 | 1.904762 | 3.86666686 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 70.1 | 2.92e-13 | NR | KAH3761877.1 | 1580589 | g7323 | i0 | 51.7 | 0.857142857142857 | 58 | 28 | 85.7 | 0 | 175 | 2 | 74 | 131 | KAH3761877.1 multiprotein-bridging factor 1b [Pelomyxa schiedti] | diamond | 174 | 70.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32556360 | 32556360 | PRJEB12237_P_NODE_7039_length_214_cov_0.882682_g6843_i0 | PRJEB12237 | 7039 | 214 | 0.882682 | 1.88893948 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 80.5 | 1.24e-15 | NR | XP_003290864.1 | 5786 | g6843 | i0 | 63.2 | 2.55140186915888 | 57 | 20 | 79.9 | 1 | 197 | 27 | 366 | 421 | XP_003290864.1 uncharacterized protein DICPUDRAFT_155396 [Dictyostelium purpureum] | diamond | 546 | 80.9 | 0.995055624227441 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32814241 | 32814241 | PRJEB12237_P_NODE_6200_length_234_cov_1.206030_g6004_i0 | PRJEB12237 | 6200 | 234 | 1.20603 | 2.8221102 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 129 | 4.42e-37 | NR | PRP89405.1 | 1890364 | g6004 | i0 | 73.7 | 1.92307692307692 | 76 | 20 | 97.4 | 0 | 229 | 2 | 5 | 80 | PRP89405.1 40S ribosomal protein S21 [Planoprotostelium fungivorum] | diamond | 450 | 129 | 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);;