contig_metadata
15 rows where bioproject = "PRJNA495391", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19601593 | 19601593 | PRJNA495391_S_NODE_10916_length_363_cov_3.853659_g9864_i0 | PRJNA495391 | 10916 | 363 | 3.853659 | 13.98878217 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 177 | 7.159999999999998e-54 | NR | XP_003293545.1 | 5786 | g9864 | i0 | 77.1 | 2.74380165289256 | 109 | 25 | 90.1 | 0 | 1 | 327 | 92 | 200 | XP_003293545.1 uncharacterized protein DICPUDRAFT_90286 [Dictyostelium purpureum] | diamond | 996 | 177 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 24701728 | 24701728 | PRJNA495391_S_NODE_13980_length_320_cov_1.715789_g12928_i0 | PRJNA495391 | 13980 | 320 | 1.715789 | 5.4905248 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 166 | 2.04e-45 | NR | KYQ90830.1 | 361077 | g12928 | i0 | 79.6 | 3.84375 | 98 | 20 | 91.9 | 0 | 318 | 25 | 698 | 795 | KYQ90830.1 aconitase [Tieghemostelium lacteum] | diamond | 1230 | 166 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 27393199 | 27393199 | PRJNA495391_S_NODE_33863_length_209_cov_2.189655_g32811_i0 | PRJNA495391 | 33863 | 209 | 2.189655 | 4.57637895 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 52.4 | 9.66e-6 | NR | PRP76907.1 | 1890364 | g32811 | i0 | 50.9 | 0.760765550239234 | 53 | 26 | 76.1 | 0 | 207 | 49 | 875 | 927 | PRP76907.1 hypothetical protein PROFUN_06185 [Planoprotostelium fungivorum] | diamond | 159 | 52.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27550745 | 27550745 | PRJNA495391_S_NODE_13324_length_328_cov_1.747440_g12272_i0 | PRJNA495391 | 13324 | 328 | 1.74744 | 5.7316032 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 43.9 | 0.0244 | NR | PRP80562.1 | 1890364 | g12272 | i0 | 45.2 | 0.567073170731707 | 62 | 33 | 56.7 | 1 | 327 | 142 | 67 | 127 | PRP80562.1 hypothetical protein PROFUN_11875 [Planoprotostelium fungivorum] | diamond | 186 | 43.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27582413 | 27582413 | PRJNA495391_S_NODE_41144_length_191_cov_2.134615_g40092_i0 | PRJNA495391 | 41144 | 191 | 2.134615 | 4.07711465 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 107 | 2.74e-25 | NR | XP_004355130.1 | 261658 | g40092 | i0 | 72.9 | 10.0052356020942 | 70 | 12 | 99 | 1 | 189 | 1 | 45 | 114 | XP_004355130.1 cyclophilin B [Cavenderia fasciculata] | diamond | 1911 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28008671 | 28008671 | PRJNA495391_S_NODE_41125_length_191_cov_2.262821_g40073_i0 | PRJNA495391 | 41125 | 191 | 2.262821 | 4.32198811 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 79 | 3.21e-15 | NR | XP_003285395.1 | 5786 | g40073 | i0 | 64.1 | 2.01047120418848 | 64 | 22 | 99 | 1 | 191 | 3 | 582 | 645 | XP_003285395.1 uncharacterized protein DICPUDRAFT_149253 [Dictyostelium purpureum] | diamond | 384 | 79.7 | 0.991217063989962 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28134931 | 28134931 | PRJNA495391_S_NODE_48605_length_177_cov_1.746479_g47553_i0 | PRJNA495391 | 48605 | 177 | 1.746479 | 3.09126783 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 77.8 | 5.71e-15 | NR | XP_001733005.1 | 352472 | g47553 | i0 | 59.7 | 2.10169491525424 | 62 | 21 | 98.3 | 1 | 176 | 3 | 306 | 367 | XP_001733005.1 glutathione S-transferase domain-containing protein [Dictyostelium discoideum AX4] | diamond | 372 | 77.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 28845260 | 28845260 | PRJNA495391_S_NODE_22288_length_254_cov_2.707763_g21236_i0 | PRJNA495391 | 22288 | 254 | 2.707763 | 6.87771802 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 101 | 9.26e-24 | NR | PRP89333.1 | 1890364 | g21236 | i0 | 58.5 | 0.968503937007874 | 82 | 34 | 96.9 | 0 | 253 | 8 | 190 | 271 | PRP89333.1 NmrA family protein [Planoprotostelium fungivorum] | diamond | 246 | 101 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29350721 | 29350721 | PRJNA495391_S_NODE_43489_length_186_cov_2.284768_g42437_i0 | PRJNA495391 | 43489 | 186 | 2.284768 | 4.24966848 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 57.8 | 3.26e-8 | NR | KAH3758809.1 | 1580589 | g42437 | i0 | 44.1 | 1.93548387096774 | 59 | 33 | 95.2 | 0 | 180 | 4 | 16 | 74 | KAH3758809.1 60s ribosomal protein l9-1 [Pelomyxa schiedti] | diamond | 360 | 57.8 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29602900 | 29602900 | PRJNA495391_S_NODE_68170_length_153_cov_1.152542_g67118_i0 | PRJNA495391 | 68170 | 153 | 1.152542 | 1.76338926 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 95.1 | 1.14e-21 | NR | PRP75453.1 | 1890364 | g67118 | i0 | 76 | 0.980392156862745 | 50 | 12 | 98 | 0 | 151 | 2 | 111 | 160 | PRP75453.1 hypothetical protein PROFUN_15738 [Planoprotostelium fungivorum] | diamond | 150 | 95.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31404342 | 31404342 | PRJNA495391_S_NODE_67856_length_153_cov_1.584746_g66804_i0 | PRJNA495391 | 67856 | 153 | 1.584746 | 2.42466138 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 95.5 | 6.44e-23 | NR | PRP83496.1 | 1890364 | g66804 | i0 | 80 | 0.980392156862745 | 50 | 10 | 98 | 0 | 3 | 152 | 88 | 137 | PRP83496.1 60S ribosomal protein L27a-like [Planoprotostelium fungivorum] | diamond | 150 | 95.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31499236 | 31499236 | PRJNA495391_S_NODE_21216_length_261_cov_1.300885_g20164_i0 | PRJNA495391 | 21216 | 261 | 1.300885 | 3.39530985 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 131 | 1.67e-35 | NR | PRP75505.1 | 1890364 | g20164 | i0 | 67.1 | 0.977011494252874 | 85 | 28 | 97.7 | 0 | 260 | 6 | 123 | 207 | PRP75505.1 40S ribosomal protein S4, X isoform-like [Planoprotostelium fungivorum] | diamond | 255 | 131 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32574963 | 32574963 | PRJNA495391_S_NODE_35639_length_204_cov_2.213018_g34587_i0 | PRJNA495391 | 35639 | 204 | 2.213018 | 4.51455672 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 58.9 | 4.38e-8 | NR | PRP78186.1 | 1890364 | g34587 | i0 | 69 | 0.617647058823529 | 42 | 11 | 61.8 | 1 | 1 | 126 | 281 | 320 | PRP78186.1 hypothetical protein PROFUN_11316 [Planoprotostelium fungivorum] | diamond | 126 | 58.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32574966 | 32574966 | PRJNA495391_S_NODE_4019_length_637_cov_2.544850_g3019_i0 | PRJNA495391 | 4019 | 637 | 2.54485 | 16.2106945 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 55.1 | 3.69e-5 | NR | XP_003284626.1 | 5786 | g3019 | i0 | 34 | 0.456828885400314 | 97 | 61 | 45.7 | 1 | 334 | 44 | 128 | 221 | XP_003284626.1 uncharacterized protein DICPUDRAFT_75603 [Dictyostelium purpureum] | diamond | 291 | 55.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32669070 | 32669070 | PRJNA495391_S_NODE_21420_length_259_cov_2.629464_g20368_i0 | PRJNA495391 | 21420 | 259 | 2.629464 | 6.81031176 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 78.2 | 2.95e-15 | NR | PRP84296.1 | 1890364 | g20368 | i0 | 59.3 | 0.938223938223938 | 81 | 33 | 93.8 | 0 | 250 | 8 | 156 | 236 | PRP84296.1 hypothetical protein PROFUN_07597 [Planoprotostelium fungivorum] | diamond | 243 | 78.2 | 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);;