contig_metadata
9 rows where bioproject = "PRJNA771359", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 747051 | 747051 | PRJNA771359_S_NODE_3841_length_171_cov_7.761194_g3758_i0 | PRJNA771359 | 3841 | 171 | 7.761194 | 13.27164174 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 250 | 4.73e-62 | NTclustered | gi|470237391|ref|XM_004350602.1| | 261658 | g3758 | i0 | 92.982 | 99.9239766081871 | 171 | 12 | 100 | 0 | 1 | 171 | 393 | 223 | Cavenderia fasciculata actin (DFA_11706), partial mRNA | blastn | 17087 | 250 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 3298221 | 3298221 | PRJNA771359_S_NODE_1843_length_246_cov_1.325359_g1760_i0 | PRJNA771359 | 1843 | 246 | 1.325359 | 3.26038314 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 153 | 3.88e-41 | NR | AAA33205.1 | 44689 | g1760 | i0 | 89 | 10 | 82 | 9 | 100 | 0 | 246 | 1 | 458 | 539 | AAA33205.1 elongation factor 2 [Dictyostelium discoideum] | diamond | 2460 | 154 | 0.993506493506494 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5035091 | 5035091 | PRJNA771359_S_NODE_2944_length_195_cov_2.069620_g2861_i0 | PRJNA771359 | 2944 | 195 | 2.06962 | 4.035759 | Flamella | 490353 | Evosea | other_Eukaryota | 359 | 8.87e-95 | NTclustered | gi|163943979|gb|EU186023.1| | 490516 | g2861 | i0 | 100 | 99.4923076923077 | 194 | 0 | 99 | 0 | 2 | 195 | 928 | 735 | Flamella balnearia 18S ribosomal RNA gene, partial sequence | blastn | 19401 | 359 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella balnearia | |||
| 13500771 | 13500771 | PRJNA771359_S_NODE_2091_length_230_cov_2.844560_g2008_i0 | PRJNA771359 | 2091 | 230 | 2.84456 | 6.542488 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 116 | 2.54e-30 | NR | XP_003283628.1 | 5786 | g2008 | i0 | 72 | 4.89130434782609 | 75 | 21 | 97.8 | 0 | 3 | 227 | 48 | 122 | XP_003283628.1 40S ribosomal protein S6 [Dictyostelium purpureum] | diamond | 1125 | 116 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 19873805 | 19873805 | PRJNA771359_S_NODE_2496_length_212_cov_1.205714_g2413_i0 | PRJNA771359 | 2496 | 212 | 1.205714 | 2.55611368 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 125 | 1.4099999999999998e-31 | NR | PRP84231.1 | 1890364 | g2413 | i0 | 94.3 | 1.9811320754717 | 70 | 4 | 99.1 | 0 | 1 | 210 | 973 | 1042 | PRP84231.1 sensor histidine kinase/response regulator [Planoprotostelium fungivorum] | diamond | 420 | 125 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 24973645 | 24973645 | PRJNA771359_S_NODE_2280_length_222_cov_2.486486_g2197_i0 | PRJNA771359 | 2280 | 222 | 2.486486 | 5.51999892 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 1.26e-36 | NR | KAF2070957.1 | 133409 | g2197 | i0 | 80.6 | 8.7027027027027 | 72 | 14 | 97.3 | 0 | 220 | 5 | 8 | 79 | KAF2070957.1 hypothetical protein CYY_007730 [Polysphondylium violaceum] | diamond | 1932 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 24973679 | 24973679 | PRJNA771359_S_NODE_4320_length_163_cov_1.230159_g4237_i0 | PRJNA771359 | 4320 | 163 | 1.230159 | 2.00515917 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 62.1 | 2.26e-5 | NTclustered | gi|1160575580|ref|XM_020582530.1| | 670386 | g4237 | i0 | 85.246 | 1.23312883435583 | 61 | 7 | 37 | 2 | 52 | 111 | 448 | 507 | Polysphondylium pallidum PN500 S60 ribosomal protein L34 (rpl34), partial mRNA | blastn | 201 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 29927086 | 29927086 | PRJNA771359_S_NODE_431_length_462_cov_1.637647_g350_i0 | PRJNA771359 | 431 | 462 | 1.637647 | 7.56592914 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 133 | 2.02e-33 | NR | PRP74799.1 | 1890364 | g350 | i0 | 52.7 | 0.850649350649351 | 131 | 59 | 85.1 | 1 | 459 | 67 | 387 | 514 | PRP74799.1 actin binding protein [Planoprotostelium fungivorum] | diamond | 393 | 133 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32392838 | 32392838 | PRJNA771359_S_NODE_2839_length_199_cov_2.129630_g2756_i0 | PRJNA771359 | 2839 | 199 | 2.12963 | 4.2379637 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 98.6 | 1.13e-23 | NR | KAH3757673.1 | 1580589 | g2756 | i0 | 64.6 | 4.95979899497487 | 65 | 23 | 98 | 0 | 195 | 1 | 34 | 98 | KAH3757673.1 60S ribosomal protein L10a [Pelomyxa schiedti] | diamond | 987 | 98.6 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti |
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);;