contig_metadata
9 rows where bioproject = "PRJNA902848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16184714 | 16184714 | PRJNA902848_P_NODE_14253_length_251_cov_0.876404_g14203_i0 | PRJNA902848 | 14253 | 251 | 0.876404 | 2.19977404 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 81.3 | 6.82e-16 | NR | XP_012755419.1 | 1410327 | g14203 | i0 | 41 | 1.9840637450199201 | 83 | 49 | 99.2 | 0 | 251 | 3 | 259 | 341 | XP_012755419.1 hypothetical protein SAMD00019534_044750 [Acytostelium subglobosum LB1] | diamond | 498 | 81.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 17460205 | 17460205 | PRJNA902848_P_NODE_18854_length_244_cov_0.912281_g18804_i0 | PRJNA902848 | 18854 | 244 | 0.912281 | 2.22596564 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 142 | 7.08e-39 | NR | XP_003294367.1 | 5786 | g18804 | i0 | 81.3 | 6.88524590163934 | 80 | 15 | 98.4 | 0 | 2 | 241 | 94 | 173 | XP_003294367.1 uncharacterized protein DICPUDRAFT_51465 [Dictyostelium purpureum] | diamond | 1680 | 142 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21284162 | 21284162 | PRJNA902848_P_NODE_9177_length_295_cov_1.405405_g9127_i0 | PRJNA902848 | 9177 | 295 | 1.405405 | 4.14594475 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 159 | 8.11e-43 | NR | PRP85693.1 | 1890364 | g9127 | i0 | 80.6 | 2.77627118644068 | 93 | 18 | 94.6 | 0 | 284 | 6 | 2385 | 2477 | PRP85693.1 hypothetical protein PROFUN_06527 [Planoprotostelium fungivorum] | diamond | 819 | 159 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 23834027 | 23834027 | PRJNA902848_P_NODE_13059_length_253_cov_0.866667_g13009_i0 | PRJNA902848 | 13059 | 253 | 0.866667 | 2.19266751 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 193 | 1.3e-44 | NTclustered | gi|831757828|ref|XM_012893698.1| | 1410327 | g13009 | i0 | 82.222 | 0.889328063241107 | 225 | 38 | 89 | 2 | 5 | 228 | 1137 | 914 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 225 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 25108100 | 25108100 | PRJNA902848_P_NODE_3200_length_439_cov_1.377049_g3150_i0 | PRJNA902848 | 3200 | 439 | 1.377049 | 6.04524511 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 184 | 1.94e-56 | NR | XP_020428647.1 | 670386 | g3150 | i0 | 70.1 | 1.92710706150342 | 144 | 41 | 98.4 | 1 | 6 | 437 | 9 | 150 | XP_020428647.1 S60 ribosomal protein L17 [Heterostelium album PN500] | diamond | 846 | 184 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 27024183 | 27024183 | PRJNA902848_P_NODE_16342_length_248_cov_0.891429_g16292_i0 | PRJNA902848 | 16342 | 248 | 0.891429 | 2.21074392 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 62.4 | 4.72e-9 | NR | PRP87603.1 | 1890364 | g16292 | i0 | 50.9 | 0.689516129032258 | 57 | 28 | 69 | 0 | 77 | 247 | 570 | 626 | PRP87603.1 putative Xaa-Pro aminopeptidase 3 [Planoprotostelium fungivorum] | diamond | 171 | 62.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28003637 | 28003637 | PRJNA902848_P_NODE_8465_length_305_cov_1.344828_g8415_i0 | PRJNA902848 | 8465 | 305 | 1.344828 | 4.1017254 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 90.5 | 2.89e-19 | NR | KAH3764570.1 | 1580589 | g8415 | i0 | 59 | 0.816393442622951 | 83 | 31 | 80.7 | 2 | 296 | 51 | 196 | 276 | KAH3764570.1 RRM domain [Pelomyxa schiedti] | diamond | 249 | 90.5 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29992748 | 29992748 | PRJNA902848_P_NODE_7791_length_315_cov_1.057851_g7741_i0 | PRJNA902848 | 7791 | 315 | 1.057851 | 3.33223065 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 99 | 7.94e-24 | NR | XP_004366312.1 | 261658 | g7741 | i0 | 46.3 | 1.84761904761905 | 95 | 49 | 90.5 | 2 | 31 | 315 | 8 | 100 | XP_004366312.1 ubiquitin-conjugating enzyme E2 [Cavenderia fasciculata] | diamond | 582 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30529690 | 30529690 | PRJNA902848_P_NODE_13513_length_252_cov_1.508380_g13463_i0 | PRJNA902848 | 13513 | 252 | 1.50838 | 3.8011176 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 127 | 3.83e-36 | NR | XP_004362999.1 | 261658 | g13463 | i0 | 70.1 | 2.61904761904762 | 77 | 23 | 91.7 | 0 | 233 | 3 | 1 | 77 | XP_004362999.1 cytochrome c [Cavenderia fasciculata] | diamond | 660 | 127 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata |
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);;