contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJEB6584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25931988 | 25931988 | PRJEB6584e_S_NODE_516_length_314_cov_42.430108_g501_i0 | PRJEB6584 | 516 | 314 | 42.430108 | 133.23053912 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 147 | 7.869999999999999e-43 | NR | KAH3766405.1 | 1580589 | g501 | i0 | 84.7 | 227.37898089172 | 85 | 13 | 81.2 | 0 | 312 | 58 | 54 | 138 | KAH3766405.1 histone H2B [Pelomyxa schiedti] | diamond | 71397 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26160752 | 26160752 | PRJEB6584o_S_NODE_853_length_625_cov_49.191525_g797_i0 | PRJEB6584 | 853 | 625 | 49.191525 | 307.44703125 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 107 | 1.94e-23 | NR | PRP81227.1 | 1890364 | g797 | i0 | 71.4 | 2.328 | 70 | 20 | 33.6 | 0 | 625 | 416 | 318 | 387 | PRP81227.1 S-adenosylmethionine synthetase [Planoprotostelium fungivorum] | diamond | 1455 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32980515 | 32980515 | PRJEB6584e_S_NODE_1779_length_211_cov_1.272727_g1764_i0 | PRJEB6584 | 1779 | 211 | 1.272727 | 2.68545397 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 62 | 3.82e-9 | NR | XP_003286736.1 | 5786 | g1764 | i0 | 51.7 | 3.21327014218009 | 58 | 27 | 82.5 | 1 | 3 | 176 | 648 | 704 | XP_003286736.1 uncharacterized protein DICPUDRAFT_46984 [Dictyostelium purpureum] | diamond | 678 | 62 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32997910 | 32997910 | PRJEB6584o_S_NODE_46371_length_168_cov_11.278195_g46263_i0 | PRJEB6584 | 46371 | 168 | 11.278195 | 18.9473676 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 68.2 | 1.38e-11 | NR | KAH3731747.1 | 1580589 | g46263 | i0 | 70 | 2.08928571428571 | 40 | 12 | 71.4 | 0 | 152 | 33 | 389 | 428 | KAH3731747.1 hypothetical protein Pelo_17418 [Pelomyxa schiedti] | diamond | 351 | 68.2 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 33014472 | 33014472 | PRJEB6584e_S_NODE_180_length_426_cov_12.048593_g165_i0 | PRJEB6584 | 180 | 426 | 12.048593 | 51.32700618 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 137 | 2.3e-35 | NR | XP_003291358.1 | 5786 | g165 | i0 | 53.1 | 1.00704225352113 | 143 | 60 | 99.3 | 2 | 425 | 3 | 316 | 453 | XP_003291358.1 actin binding protein [Dictyostelium purpureum] | diamond | 429 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 33025722 | 33025722 | PRJEB6584e_S_NODE_3036_length_172_cov_2.744526_g3021_i0 | PRJEB6584 | 3036 | 172 | 2.744526 | 4.72058472 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 45.1 | 0.00225 | NR | XP_004358193.1 | 261658 | g3021 | i0 | 74.1 | 0.976744186046512 | 27 | 7 | 47.1 | 0 | 171 | 91 | 532 | 558 | XP_004358193.1 putative non-transporter ABC protein [Cavenderia fasciculata] | diamond | 168 | 45.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 33048541 | 33048541 | PRJEB6584e_S_NODE_677_length_286_cov_12.960159_g662_i0 | PRJEB6584 | 677 | 286 | 12.960159 | 37.06605474 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 129 | 1.08e-33 | NR | XP_004350709.1 | 261658 | g662 | i0 | 80.2 | 5.41258741258741 | 86 | 17 | 90.2 | 0 | 275 | 18 | 3 | 88 | XP_004350709.1 uncharacterized protein DFA_11762 [Cavenderia fasciculata] | diamond | 1548 | 129 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 33048697 | 33048697 | PRJEB6584o_S_NODE_11933_length_254_cov_5.091324_g11825_i0 | PRJEB6584 | 11933 | 254 | 5.091324 | 12.93196296 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 49.7 | 6e-5 | NR | KAH3764251.1 | 1580589 | g11825 | i0 | 45.8 | 0.566929133858268 | 48 | 25 | 56.7 | 1 | 246 | 103 | 113 | 159 | KAH3764251.1 hypothetical protein Pelo_3898 [Pelomyxa schiedti] | diamond | 144 | 49.7 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 33082723 | 33082723 | PRJEB6584e_S_NODE_1230_length_240_cov_2.741463_g1215_i0 | PRJEB6584 | 1230 | 240 | 2.741463 | 6.5795112 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 67 | 9.23e-11 | NR | AAA29967.1 | 5791 | g1215 | i0 | 45.3 | 0.9375 | 75 | 41 | 93.8 | 0 | 238 | 14 | 181 | 255 | AAA29967.1 actin-binding protein [Physarum polycephalum] | diamond | 225 | 67 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 33082725 | 33082725 | PRJEB6584e_S_NODE_2566_length_183_cov_2.317568_g2551_i0 | PRJEB6584 | 2566 | 183 | 2.317568 | 4.24114944 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 90.1 | 3.4900000000000005e-21 | NR | KAF2075203.1 | 133409 | g2551 | i0 | 73.3 | 0.983606557377049 | 60 | 16 | 98.4 | 0 | 182 | 3 | 3 | 62 | KAF2075203.1 hypothetical protein CYY_003508 [Polysphondylium violaceum] | diamond | 180 | 90.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 33082965 | 33082965 | PRJEB6584o_S_NODE_17358_length_214_cov_3.675978_g17250_i0 | PRJEB6584 | 17358 | 214 | 3.675978 | 7.86659292 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 42 | 0.0495 | NR | KAH3758012.1 | 1580589 | g17250 | i0 | 50 | 0.672897196261682 | 48 | 21 | 63.1 | 2 | 214 | 80 | 597 | 644 | KAH3758012.1 cytohesin 1 [Pelomyxa schiedti] | diamond | 144 | 42 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 33099762 | 33099762 | PRJEB6584e_S_NODE_2902_length_175_cov_2.250000_g2887_i0 | PRJEB6584 | 2902 | 175 | 2.25 | 3.9375 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 88.2 | 1.44e-18 | NR | XP_004361176.1 | 261658 | g2887 | i0 | 70.7 | 7.85142857142857 | 58 | 17 | 99.4 | 0 | 2 | 175 | 183 | 240 | XP_004361176.1 chaperonin containing TCP1 gamma subunit [Cavenderia fasciculata] | diamond | 1374 | 88.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 33150963 | 33150963 | PRJEB6584e_S_NODE_1456_length_225_cov_1.452632_g1441_i0 | PRJEB6584 | 1456 | 225 | 1.452632 | 3.268422 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 46.6 | 1.82e-4 | NR | XP_004361785.1 | 261658 | g1441 | i0 | 68.8 | 0.426666666666667 | 32 | 10 | 42.7 | 0 | 217 | 122 | 15 | 46 | XP_004361785.1 actobindin [Cavenderia fasciculata] | diamond | 96 | 46.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 33162002 | 33162002 | PRJEB6584e_S_NODE_1728_length_213_cov_1.955056_g1713_i0 | PRJEB6584 | 1728 | 213 | 1.955056 | 4.16426928 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.6 | 9.65e-4 | NR | KYQ88739.1 | 361077 | g1713 | i0 | 40.6 | 1.94366197183099 | 69 | 37 | 95.8 | 2 | 211 | 8 | 138 | 203 | KYQ88739.1 ubiquitin-conjugating enzyme E2 [Tieghemostelium lacteum] | diamond | 414 | 46.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 33167938 | 33167938 | PRJEB6584e_S_NODE_1288_length_236_cov_4.228856_g1273_i0 | PRJEB6584 | 1288 | 236 | 4.228856 | 9.98010016 | Cavenderia deminutiva | 361123 | Evosea | other_Eukaryota | 94.7 | 1.67e-20 | NR | AOE43201.1 | 361123 | g1273 | i0 | 57 | 5.73305084745763 | 79 | 31 | 96.6 | 1 | 4 | 231 | 9 | 87 | AOE43201.1 glutamate-cysteine ligase [Cavenderia deminutiva] | diamond | 1353 | 94.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia deminutiva |
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);;