contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3812567 | 3812567 | PRJNA946307_P_NODE_34083_length_225_cov_1.761364_g33209_i0 | PRJNA946307 | 34083 | 225 | 1.761364 | 3.963069 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 79.3 | 3.76e-15 | NR | PRP86903.1 | 1890364 | g33209 | i0 | 75.5 | 0.653333333333333 | 49 | 9 | 61.3 | 1 | 224 | 87 | 887 | 935 | PRP86903.1 elongation factor 2-like isoform 1 [Planoprotostelium fungivorum] | diamond | 147 | 79.3 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 14955068 | 14955068 | PRJNA946307_P_NODE_35372_length_221_cov_4.994186_g34498_i0 | PRJNA946307 | 35372 | 221 | 4.994186 | 11.03715106 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 103 | 1.41e-23 | NR | ATE46682.1 | 472931 | g34498 | i0 | 62.4 | 2.52488687782805 | 93 | 11 | 93.7 | 1 | 15 | 221 | 154 | 246 | ATE46682.1 NADH dehydrogenase subunit 5 [Protostelium mycophagum] | diamond | 558 | 103 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 28004796 | 28004796 | PRJNA946307_P_NODE_117045_length_176_cov_2.976378_g116171_i0 | PRJNA946307 | 117045 | 176 | 2.976378 | 5.23842528 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 79.7 | 1.05e-15 | NR | ATE46686.1 | 472931 | g116171 | i0 | 94.9 | 0.664772727272727 | 39 | 2 | 66.5 | 0 | 174 | 58 | 185 | 223 | ATE46686.1 cytochrome b [Protostelium mycophagum] | diamond | 117 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 28067775 | 28067775 | PRJNA946307_P_NODE_96865_length_185_cov_4.080882_g95991_i0 | PRJNA946307 | 96865 | 185 | 4.080882 | 7.5496317 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 83.2 | 9.24e-17 | NR | ATE46683.1 | 472931 | g95991 | i0 | 75.9 | 0.875675675675676 | 54 | 13 | 87.6 | 0 | 169 | 8 | 424 | 477 | ATE46683.1 ATPase subunit 1 [Protostelium mycophagum] | diamond | 162 | 83.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 28099260 | 28099260 | PRJNA946307_P_NODE_28865_length_241_cov_2.989583_g27991_i0 | PRJNA946307 | 28865 | 241 | 2.989583 | 7.20489503 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 53.9 | 3.94e-6 | NR | ATE46691.1 | 472931 | g27991 | i0 | 75.9 | 0.360995850622407 | 29 | 7 | 36.1 | 0 | 15 | 101 | 203 | 231 | ATE46691.1 NADH dehydrogenase subunit 2 [Protostelium mycophagum] | diamond | 87 | 53.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 28895258 | 28895258 | PRJNA946307_P_NODE_96208_length_186_cov_1.408759_g95334_i0 | PRJNA946307 | 96208 | 186 | 1.408759 | 2.62029174 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 3.66e-6 | NR | PRP83468.1 | 1890364 | g95334 | i0 | 46.4 | 5.16129032258065 | 56 | 29 | 90.3 | 1 | 184 | 17 | 677 | 731 | PRP83468.1 retrotransposon nucleocapsid protein, partial [Planoprotostelium fungivorum] | diamond | 960 | 53.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28920050 | 28920050 | PRJNA946307_P_NODE_14068_length_346_cov_3.858586_g13198_i0 | PRJNA946307 | 14068 | 346 | 3.858586 | 13.35070756 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 127 | 6.129999999999999e-32 | NR | ATE46683.1 | 472931 | g13198 | i0 | 81 | 0.684971098265896 | 79 | 15 | 68.5 | 0 | 331 | 95 | 149 | 227 | ATE46683.1 ATPase subunit 1 [Protostelium mycophagum] | diamond | 237 | 127 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 29362331 | 29362331 | PRJNA946307_P_NODE_131689_length_170_cov_1.603306_g130815_i0 | PRJNA946307 | 131689 | 170 | 1.603306 | 2.7256202 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 47.8 | 1.85e-4 | NR | ATE46706.1 | 1890364 | g130815 | i0 | 58.8 | 1.21764705882353 | 34 | 14 | 60 | 0 | 19 | 120 | 10 | 43 | ATE46706.1 NADH dehydrogenase subunit 6 [Planoprotostelium fungivorum] | diamond | 207 | 47.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29614500 | 29614500 | PRJNA946307_P_NODE_107590_length_181_cov_1.272727_g106716_i0 | PRJNA946307 | 107590 | 181 | 1.272727 | 2.30363587 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 42 | 0.0316 | NR | PRP82419.1 | 1890364 | g106716 | i0 | 39.6 | 0.878453038674033 | 53 | 32 | 87.8 | 0 | 162 | 4 | 62 | 114 | PRP82419.1 Fanconi anemia group I protein [Planoprotostelium fungivorum] | diamond | 159 | 42 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30126659 | 30126659 | PRJNA946307_P_NODE_145792_length_166_cov_0.871795_g144918_i0 | PRJNA946307 | 145792 | 166 | 0.871795 | 1.4471797 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 4.72e-5 | NR | AAG31138.1 | 5791 | g144918 | i0 | 46 | 3.52409638554217 | 50 | 26 | 90.4 | 1 | 151 | 2 | 373 | 421 | AAG31138.1 fragmin60 [Physarum polycephalum] | diamond | 585 | 49.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 30657358 | 30657358 | PRJNA946307_P_NODE_87813_length_189_cov_4.492857_g86939_i0 | PRJNA946307 | 87813 | 189 | 4.492857 | 8.49149973 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 107 | 2.97e-25 | NR | XP_003290441.1 | 5786 | g86939 | i0 | 86.7 | 2.85714285714286 | 60 | 8 | 95.2 | 0 | 184 | 5 | 427 | 486 | XP_003290441.1 uncharacterized protein DICPUDRAFT_92487 [Dictyostelium purpureum] | diamond | 540 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 31257635 | 31257635 | PRJNA946307_P_NODE_108335_length_180_cov_2.709924_g107461_i0 | PRJNA946307 | 108335 | 180 | 2.709924 | 4.8778632 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 71.2 | 1.39e-12 | NR | KAH3756088.1 | 1580589 | g107461 | i0 | 55.6 | 0.9 | 54 | 24 | 90 | 0 | 18 | 179 | 539 | 592 | KAH3756088.1 Ubiquitin fusion degradation UFD1 family protein [Pelomyxa schiedti] | diamond | 162 | 71.2 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 31352685 | 31352685 | PRJNA946307_P_NODE_18136_length_301_cov_4.369048_g17265_i0 | PRJNA946307 | 18136 | 301 | 4.369048 | 13.15083448 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 50.8 | 9.7e-5 | NR | ATE46686.1 | 472931 | g17265 | i0 | 72.4 | 0.289036544850498 | 29 | 8 | 28.9 | 0 | 12 | 98 | 340 | 368 | ATE46686.1 cytochrome b [Protostelium mycophagum] | diamond | 87 | 50.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 31637167 | 31637167 | PRJNA946307_P_NODE_146616_length_165_cov_5.431034_g145742_i0 | PRJNA946307 | 146616 | 165 | 5.431034 | 8.9612061 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 42 | 0.0243 | NR | PRP86855.1 | 1890364 | g145742 | i0 | 41.5 | 0.963636363636364 | 53 | 29 | 96.4 | 2 | 164 | 6 | 157 | 207 | PRP86855.1 O-linked GlcNAc transferase like protein [Planoprotostelium fungivorum] | diamond | 159 | 42 | 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);;