contig_metadata
8 rows where bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18893843 | 18893843 | PRJNA1192965_P_NODE_2235_length_288_cov_1.432558_g2216_i0 | PRJNA1192965 | 2235 | 288 | 1.432558 | 4.12576704 | Evosea | 2605435 | Evosea | other_Eukaryota | 117 | 5.209999999999999e-32 | NR | KAF2076753.1 | 133409 | g2216 | i0 | 67.1 | 15.1458333333333 | 79 | 26 | 82.3 | 0 | 283 | 47 | 1 | 79 | KAF2076753.1 hypothetical protein CYY_001942 [Polysphondylium violaceum] | diamond | 4362 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 26819373 | 26819373 | PRJNA1192965_P_NODE_4041_length_247_cov_0.885057_g4022_i0 | PRJNA1192965 | 4041 | 247 | 0.885057 | 2.18609079 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 94 | 3.61e-20 | NR | PRP82197.1 | 1890364 | g4022 | i0 | 56.3 | 0.97165991902834 | 80 | 35 | 97.2 | 0 | 242 | 3 | 663 | 742 | PRP82197.1 hypothetical protein PROFUN_10406 [Planoprotostelium fungivorum] | diamond | 240 | 94 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27122691 | 27122691 | PRJNA1192965_P_NODE_2382_length_283_cov_1.100000_g2363_i0 | PRJNA1192965 | 2382 | 283 | 1.1 | 3.113 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 108 | 4.660000000000001e-27 | NR | KAF2074121.1 | 133409 | g2363 | i0 | 52.2 | 3.6678445229682 | 90 | 43 | 95.4 | 0 | 1 | 270 | 94 | 183 | KAF2074121.1 hypothetical protein CYY_004563 [Polysphondylium violaceum] | diamond | 1038 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 30925673 | 30925673 | PRJNA1192965_P_NODE_3214_length_252_cov_1.720670_g3195_i0 | PRJNA1192965 | 3214 | 252 | 1.72067 | 4.3360884 | Entamoeba dispar SAW76 | 46681 | Evosea | other_Eukaryota | 79.7 | 2.01e-16 | NR | XP_001735418.1 | 370354 | g3195 | i0 | 46.4 | 1 | 84 | 45 | 100 | 0 | 252 | 1 | 20 | 103 | XP_001735418.1 60S ribosomal protein L18A, putative [Entamoeba dispar SAW760] | diamond | 252 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 31020309 | 31020309 | PRJNA1192965_P_NODE_1355_length_349_cov_1.090580_g1336_i0 | PRJNA1192965 | 1355 | 349 | 1.09058 | 3.8061242 | Entamoeba dispar SAW76 | 46681 | Evosea | other_Eukaryota | 49.7 | 4.45e-4 | NR | XP_001737935.1 | 370354 | g1336 | i0 | 32.3 | 0.799426934097421 | 93 | 57 | 79.1 | 4 | 347 | 72 | 551 | 638 | XP_001737935.1 uncharacterized protein EDI_307930, partial [Entamoeba dispar SAW760] | diamond | 279 | 49.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 32082845 | 32082845 | PRJNA1192965_P_NODE_3358_length_251_cov_0.865169_g3339_i0 | PRJNA1192965 | 3358 | 251 | 0.865169 | 2.17157419 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 74.7 | 2.28e-13 | NR | CAA68685.1 | 44689 | g3339 | i0 | 47.4 | 1.86454183266932 | 78 | 40 | 93.2 | 1 | 236 | 3 | 727 | 803 | CAA68685.1 unnamed protein product [Dictyostelium discoideum] | diamond | 468 | 74.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 32254045 | 32254045 | PRJNA1192965_P_NODE_2238_length_288_cov_1.390698_g2219_i0 | PRJNA1192965 | 2238 | 288 | 1.390698 | 4.00521024 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 45.4 | 0.00111 | NR | PRP89373.1 | 1890364 | g2219 | i0 | 53.3 | 0.46875 | 45 | 21 | 46.9 | 0 | 255 | 121 | 4 | 48 | PRP89373.1 hypothetical protein PROFUN_01236 [Planoprotostelium fungivorum] | diamond | 135 | 45.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32412036 | 32412036 | PRJNA1192965_P_NODE_3439_length_250_cov_1.779661_g3420_i0 | PRJNA1192965 | 3439 | 250 | 1.779661 | 4.4491525 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 72 | 1.81e-13 | NR | KAF2071651.1 | 133409 | g3420 | i0 | 45.8 | 0.996 | 83 | 43 | 99.6 | 1 | 250 | 2 | 91 | 171 | KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum] | diamond | 249 | 72 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum |
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);;