contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26741189 | 26741189 | PRJNA994052_P_NODE_55421_length_233_cov_2.787500_g54166_i0 | PRJNA994052 | 55421 | 233 | 2.7875 | 6.494875 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 84 | 9.16e-17 | NR | PRP87109.1 | 1890364 | g54166 | i0 | 53.1 | 3.12875536480687 | 64 | 30 | 82.4 | 0 | 192 | 1 | 4 | 67 | PRP87109.1 peptidase M20 [Planoprotostelium fungivorum] | diamond | 729 | 84 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26931576 | 26931576 | PRJNA994052_P_NODE_21402_length_306_cov_4.738197_g20175_i0 | PRJNA994052 | 21402 | 306 | 4.738197 | 14.49888282 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 66.6 | 6.8e-12 | NR | AEF68171.1 | 5791 | g20175 | i0 | 88.2 | 0.333333333333333 | 34 | 4 | 33.3 | 0 | 143 | 42 | 57 | 90 | AEF68171.1 Sm-E-like protein [Physarum polycephalum] | diamond | 102 | 66.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 28258093 | 28258093 | PRJNA994052_P_NODE_69526_length_213_cov_15.914286_g68270_i0 | PRJNA994052 | 69526 | 213 | 15.914286 | 33.89742918 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52 | 1.42e-6 | NR | XP_003293203.1 | 5786 | g68270 | i0 | 63.2 | 0.535211267605634 | 38 | 14 | 53.5 | 0 | 187 | 74 | 59 | 96 | XP_003293203.1 uncharacterized protein DICPUDRAFT_93002 [Dictyostelium purpureum] | diamond | 114 | 52 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28384515 | 28384515 | PRJNA994052_P_NODE_57386_length_230_cov_6.503185_g56131_i0 | PRJNA994052 | 57386 | 230 | 6.503185 | 14.9573255 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 55.8 | 7.32e-7 | NR | XP_003290152.1 | 5786 | g56131 | i0 | 70.3 | 0.952173913043478 | 37 | 11 | 48.3 | 0 | 183 | 73 | 371 | 407 | XP_003290152.1 uncharacterized protein DICPUDRAFT_154640 [Dictyostelium purpureum] | diamond | 219 | 55.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28731924 | 28731924 | PRJNA994052_P_NODE_78087_length_203_cov_6.376923_g76830_i0 | PRJNA994052 | 78087 | 203 | 6.376923 | 12.94515369 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 61.6 | 4.08e-9 | NR | XP_004351803.1 | 261658 | g76830 | i0 | 79.1 | 0.635467980295567 | 43 | 9 | 63.5 | 0 | 3 | 131 | 278 | 320 | XP_004351803.1 succinate-CoA ligase [Cavenderia fasciculata] | diamond | 129 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 29331754 | 29331754 | PRJNA994052_P_NODE_22569_length_302_cov_21.240175_g21340_i0 | PRJNA994052 | 22569 | 302 | 21.240175 | 64.1453285 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 55.5 | 2.55e-6 | NR | XP_012752247.1 | 1410327 | g21340 | i0 | 29.3 | 1.1523178807947 | 116 | 53 | 86.4 | 1 | 301 | 41 | 321 | 436 | XP_012752247.1 hypothetical protein SAMD00019534_077530 [Acytostelium subglobosum LB1] | diamond | 348 | 55.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 31986161 | 31986161 | PRJNA994052_P_NODE_24878_length_295_cov_17.968468_g23642_i0 | PRJNA994052 | 24878 | 295 | 17.968468 | 53.0069806 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 95.9 | 5.22e-21 | NR | KYR00559.1 | 361077 | g23642 | i0 | 49.1 | 1.07796610169492 | 106 | 29 | 86.4 | 2 | 5 | 259 | 265 | 366 | KYR00559.1 transmembrane protein [Tieghemostelium lacteum] | diamond | 318 | 95.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32144538 | 32144538 | PRJNA994052_P_NODE_60398_length_225_cov_55.868421_g59142_i0 | PRJNA994052 | 60398 | 225 | 55.868421 | 125.70394725 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 58.2 | 1.05e-7 | NR | PRP74799.1 | 1890364 | g59142 | i0 | 70.5 | 0.586666666666667 | 44 | 13 | 58.7 | 0 | 205 | 74 | 472 | 515 | PRP74799.1 actin binding protein [Planoprotostelium fungivorum] | diamond | 132 | 58.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32397783 | 32397783 | PRJNA994052_P_NODE_23159_length_300_cov_28.211454_g21930_i0 | PRJNA994052 | 23159 | 300 | 28.211454 | 84.634362 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 55.1 | 3.37e-6 | NR | XP_012752247.1 | 1410327 | g21930 | i0 | 29.3 | 1.16 | 116 | 54 | 88 | 1 | 2 | 265 | 321 | 436 | XP_012752247.1 hypothetical protein SAMD00019534_077530 [Acytostelium subglobosum LB1] | diamond | 348 | 55.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;