contig_metadata
17 rows where bioproject = "PRJNA1073005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5289759 | 5289759 | PRJNA1073005_P_NODE_4265_length_482_cov_1.672372_g4146_i0 | PRJNA1073005 | 4265 | 482 | 1.672372 | 8.06083304 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 231 | 1.01e-74 | NR | KAF2075979.1 | 133409 | g4146 | i0 | 75.2 | 12.5601659751037 | 153 | 38 | 95.2 | 0 | 466 | 8 | 1 | 153 | KAF2075979.1 hypothetical protein CYY_002735 [Polysphondylium violaceum] | diamond | 6054 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 7839603 | 7839603 | PRJNA1073005_P_NODE_7287_length_311_cov_1.294118_g7168_i0 | PRJNA1073005 | 7287 | 311 | 1.294118 | 4.02470698 | Dictyosteliales | 2058949 | Evosea | other_Eukaryota | 145 | 5.829999999999998e-42 | NR | KAF2075979.1 | 133409 | g7168 | i0 | 71.4 | 2.84565916398714 | 98 | 28 | 94.5 | 0 | 295 | 2 | 4 | 101 | KAF2075979.1 hypothetical protein CYY_002735 [Polysphondylium violaceum] | diamond | 885 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 10390273 | 10390273 | PRJNA1073005_P_NODE_6889_length_329_cov_0.976562_g6770_i0 | PRJNA1073005 | 6889 | 329 | 0.976562 | 3.21288898 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|470247896|ref|XM_004366774.1| | 261658 | g6770 | i0 | 100 | 0.0851063829787234 | 28 | 0 | 9 | 0 | 225 | 252 | 1265 | 1238 | Cavenderia fasciculata uncharacterized protein (DFA_02446), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 18038704 | 18038704 | PRJNA1073005_P_NODE_9535_length_247_cov_0.885057_g9416_i0 | PRJNA1073005 | 9535 | 247 | 0.885057 | 2.18609079 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 75.9 | 4.05e-14 | NR | KAH3763381.1 | 1580589 | g9416 | i0 | 64.5 | 1.49392712550607 | 62 | 21 | 75.3 | 1 | 190 | 5 | 4 | 64 | KAH3763381.1 RRM domain [Pelomyxa schiedti] | diamond | 369 | 75.9 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 19312674 | 19312674 | PRJNA1073005_P_NODE_9436_length_248_cov_0.880000_g9317_i0 | PRJNA1073005 | 9436 | 248 | 0.88 | 2.1824 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 150 | 4.19e-43 | NR | XP_020429869.1 | 670386 | g9317 | i0 | 84.1 | 2.9758064516129 | 82 | 13 | 99.2 | 0 | 2 | 247 | 21 | 102 | XP_020429869.1 subunit of heterodimeric actin capping protein cap32/34 [Heterostelium album PN500] | diamond | 738 | 150 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 26687494 | 26687494 | PRJNA1073005_P_NODE_5821_length_380_cov_0.983713_g5702_i0 | PRJNA1073005 | 5821 | 380 | 0.983713 | 3.7381094 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 44.7 | 0.0339 | NR | PRP85297.1 | 1890364 | g5702 | i0 | 48.8 | 0.339473684210526 | 43 | 22 | 33.9 | 0 | 130 | 2 | 110 | 152 | PRP85297.1 hypothetical protein PROFUN_06899 [Planoprotostelium fungivorum] | diamond | 129 | 44.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26750472 | 26750472 | PRJNA1073005_P_NODE_9641_length_246_cov_0.890173_g9522_i0 | PRJNA1073005 | 9641 | 246 | 0.890173 | 2.18982558 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 102 | 1.24e-24 | NR | XP_020431228.1 | 670386 | g9522 | i0 | 57.3 | 7.91463414634146 | 82 | 35 | 100 | 0 | 246 | 1 | 139 | 220 | XP_020431228.1 20S proteasome subunit C2 [Heterostelium album PN500] | diamond | 1947 | 102 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 26940736 | 26940736 | PRJNA1073005_P_NODE_6742_length_336_cov_1.106464_g6623_i0 | PRJNA1073005 | 6742 | 336 | 1.106464 | 3.71771904 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 137 | 1.43e-38 | NR | PRP79838.1 | 1890364 | g6623 | i0 | 65 | 4.63392857142857 | 103 | 36 | 92 | 0 | 327 | 19 | 60 | 162 | PRP79838.1 60S ribosomal protein L44-like [Planoprotostelium fungivorum] | diamond | 1557 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27257014 | 27257014 | PRJNA1073005_P_NODE_10043_length_243_cov_0.905882_g9924_i0 | PRJNA1073005 | 10043 | 243 | 0.905882 | 2.20129326 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 129 | 9.49e-34 | NR | PRP73564.1 | 1890364 | g9924 | i0 | 71.3 | 0.987654320987654 | 80 | 23 | 98.8 | 0 | 2 | 241 | 160 | 239 | PRP73564.1 tryptophan--tRNA ligase, cytoplasmic [Planoprotostelium fungivorum] | diamond | 240 | 129 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28614907 | 28614907 | PRJNA1073005_P_NODE_10127_length_243_cov_0.882353_g10008_i0 | PRJNA1073005 | 10127 | 243 | 0.882353 | 2.14411779 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 80.1 | 2.01e-15 | NR | PRP84918.1 | 1890364 | g10008 | i0 | 41.2 | 1.04938271604938 | 85 | 45 | 98.8 | 2 | 240 | 1 | 46 | 130 | PRP84918.1 hypothetical protein PROFUN_07572 [Planoprotostelium fungivorum] | diamond | 255 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28994034 | 28994034 | PRJNA1073005_P_NODE_8068_length_280_cov_1.922705_g7949_i0 | PRJNA1073005 | 8068 | 280 | 1.922705 | 5.383574 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 55.5 | 1.6e-6 | NR | XP_642667.1 | 352472 | g7949 | i0 | 38.8 | 0.910714285714286 | 85 | 40 | 88.9 | 3 | 14 | 262 | 82 | 156 | XP_642667.1 hypothetical protein DDB_G0277473 [Dictyostelium discoideum AX4] | diamond | 255 | 55.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 29458567 | 29458567 | PRJNA1073005_P_NODE_9150_length_250_cov_0.870056_g9031_i0 | PRJNA1073005 | 9150 | 250 | 0.870056 | 2.17514 | Acytosteliaceae | 2058183 | Evosea | other_Eukaryota | 114 | 3.53e-27 | NR | XP_020432601.1 | 670386 | g9031 | i0 | 67.1 | 1.968 | 82 | 27 | 98.4 | 0 | 248 | 3 | 203 | 284 | XP_020432601.1 major vault protein [Heterostelium album PN500] | diamond | 492 | 114 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 29458568 | 29458568 | PRJNA1073005_P_NODE_9810_length_245_cov_0.895349_g9691_i0 | PRJNA1073005 | 9810 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 138 | 1.79e-36 | NR | XP_003285028.1 | 5786 | g9691 | i0 | 79.7 | 24.465306122449 | 79 | 16 | 96.7 | 0 | 242 | 6 | 175 | 253 | XP_003285028.1 uncharacterized protein DICPUDRAFT_45843 [Dictyostelium purpureum] | diamond | 5994 | 138 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 30257318 | 30257318 | PRJNA1073005_P_NODE_9492_length_247_cov_1.321839_g9373_i0 | PRJNA1073005 | 9492 | 247 | 1.321839 | 3.26494233 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 55.5 | 1.32e-6 | NR | XP_020434057.1 | 670386 | g9373 | i0 | 38.8 | 0.97165991902834 | 80 | 42 | 97.2 | 1 | 243 | 4 | 621 | 693 | XP_020434057.1 protein phosphatase 2C [Heterostelium album PN500] | diamond | 240 | 55.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 30699199 | 30699199 | PRJNA1073005_P_NODE_9034_length_251_cov_0.865169_g8915_i0 | PRJNA1073005 | 9034 | 251 | 0.865169 | 2.17157419 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 101 | 6.88e-25 | NR | PRP75574.1 | 1890364 | g8915 | i0 | 59 | 0.99203187250996006 | 83 | 27 | 90.8 | 2 | 22 | 249 | 15 | 97 | PRP75574.1 hypothetical protein PROFUN_15685 [Planoprotostelium fungivorum] | diamond | 249 | 101 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30888886 | 30888886 | PRJNA1073005_P_NODE_8794_length_255_cov_1.598901_g8675_i0 | PRJNA1073005 | 8794 | 255 | 1.598901 | 4.07719755 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 107 | 4.94e-27 | NR | PRP86688.1 | 1890364 | g8675 | i0 | 62.4 | 3 | 85 | 32 | 100 | 0 | 1 | 255 | 87 | 171 | PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum] | diamond | 765 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32217159 | 32217159 | PRJNA1073005_P_NODE_6718_length_337_cov_1.303030_g6599_i0 | PRJNA1073005 | 6718 | 337 | 1.30303 | 4.3912111 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 120 | 2.08e-31 | NR | PRP86688.1 | 1890364 | g6599 | i0 | 58.8 | 0.908011869436202 | 102 | 42 | 90.8 | 0 | 317 | 12 | 80 | 181 | PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum] | diamond | 306 | 120 | 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);;