contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27077526 | 27077526 | PRJNA529241_P_NODE_455162_length_155_cov_0.991525_g452840_i0 | PRJNA529241 | 455162 | 155 | 0.991525 | 1.53686375 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 55.8 | 2.65e-7 | NR | XP_004341947.1 | 1257118 | g452840 | i0 | 55.8 | 0.832258064516129 | 43 | 19 | 83.2 | 0 | 1 | 129 | 692 | 734 | XP_004341947.1 gelation factor, putative [Acanthamoeba castellanii str. Neff] | diamond | 129 | 55.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27077559 | 27077559 | PRJNA529241_P_NODE_551622_length_151_cov_1.710526_g549300_i0 | PRJNA529241 | 551622 | 151 | 1.710526 | 2.58289426 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 51.2 | 1.02e-5 | NR | XP_004337717.1 | 1257118 | g549300 | i0 | 55.1 | 0.973509933774834 | 49 | 15 | 97.4 | 1 | 4 | 150 | 121 | 162 | XP_004337717.1 ribosomal L18p/L5e family [Acanthamoeba castellanii str. Neff] | diamond | 147 | 51.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27772680 | 27772680 | PRJNA529241_P_NODE_391044_length_173_cov_2.397059_g388722_i0 | PRJNA529241 | 391044 | 173 | 2.397059 | 4.14691207 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 50.4 | 9.2e-6 | NR | YP_003540828.1 | 5778 | g388722 | i0 | 92 | 0.433526011560694 | 25 | 2 | 43.4 | 0 | 3 | 77 | 56 | 80 | YP_003540828.1 ribosomal protein S11 [Vermamoeba vermiformis] | diamond | 75 | 50.4 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28419250 | 28419250 | PRJNA529241_P_NODE_300606_length_173_cov_3.536765_g298284_i0 | PRJNA529241 | 300606 | 173 | 3.536765 | 6.11860345 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 53.9 | 1.64e-6 | NR | XP_004362729.1 | 261658 | g298284 | i0 | 59.5 | 1.45664739884393 | 42 | 15 | 69.4 | 1 | 121 | 2 | 249 | 290 | XP_004362729.1 putative CMF receptor CMFR1 [Cavenderia fasciculata] | diamond | 252 | 53.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 29067105 | 29067105 | PRJNA529241_P_NODE_392488_length_173_cov_2.360294_g390166_i0 | PRJNA529241 | 392488 | 173 | 2.360294 | 4.08330862 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 59.3 | 9.26e-9 | NR | PRP78360.1 | 1890364 | g390166 | i0 | 50.9 | 0.988439306358382 | 57 | 23 | 98.8 | 1 | 3 | 173 | 122 | 173 | PRP78360.1 hypothetical protein PROFUN_13755 [Planoprotostelium fungivorum] | diamond | 171 | 59.3 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29319441 | 29319441 | PRJNA529241_P_NODE_143689_length_189_cov_1.763158_g141367_i0 | PRJNA529241 | 143689 | 189 | 1.763158 | 3.33236862 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 43.1 | 0.013 | NR | XP_004367870.1 | 1257118 | g141367 | i0 | 44.2 | 1.53968253968254 | 52 | 29 | 82.5 | 0 | 187 | 32 | 284 | 335 | XP_004367870.1 ribosomal protein L4/L1 family [Acanthamoeba castellanii str. Neff] | diamond | 291 | 43.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29351242 | 29351242 | PRJNA529241_P_NODE_438229_length_161_cov_1.258065_g435907_i0 | PRJNA529241 | 438229 | 161 | 1.258065 | 2.02548465 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 91.3 | 9.86e-21 | NR | XP_644192.1 | 352472 | g435907 | i0 | 75.5 | 2.96273291925466 | 53 | 13 | 98.8 | 0 | 161 | 3 | 95 | 147 | XP_644192.1 60S ribosomal protein L8 [Dictyostelium discoideum AX4] | diamond | 477 | 91.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 29603345 | 29603345 | PRJNA529241_P_NODE_247870_length_173_cov_4.477941_g245548_i0 | PRJNA529241 | 247870 | 173 | 4.477941 | 7.74683793 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 74.7 | 7.71e-14 | NR | KYQ94354.1 | 361077 | g245548 | i0 | 66.7 | 0.988439306358382 | 57 | 15 | 98.8 | 1 | 3 | 173 | 676 | 728 | KYQ94354.1 hypothetical protein DLAC_04650 [Tieghemostelium lacteum] | diamond | 171 | 74.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 29776651 | 29776651 | PRJNA529241_P_NODE_346291_length_173_cov_2.911765_g343969_i0 | PRJNA529241 | 346291 | 173 | 2.911765 | 5.03735345 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 8.45e-4 | NR | PRP89446.1 | 1890364 | g343969 | i0 | 72 | 0.867052023121387 | 25 | 7 | 43.4 | 0 | 2 | 76 | 27 | 51 | PRP89446.1 Diacetyl/L-xylulose reductase [Planoprotostelium fungivorum] | diamond | 150 | 46.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30488194 | 30488194 | PRJNA529241_P_NODE_192933_length_173_cov_6.750000_g190611_i0 | PRJNA529241 | 192933 | 173 | 6.75 | 11.6775 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 62.8 | 1.24e-9 | NR | XP_004334568.1 | 1257118 | g190611 | i0 | 59 | 1.05780346820809 | 61 | 19 | 98.8 | 2 | 171 | 1 | 98 | 156 | XP_004334568.1 paired amphipathic helix protein sin3, putative [Acanthamoeba castellanii str. Neff] | diamond | 183 | 62.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30677563 | 30677563 | PRJNA529241_P_NODE_145613_length_188_cov_1.807947_g143291_i0 | PRJNA529241 | 145613 | 188 | 1.807947 | 3.39894036 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 86.7 | 2.31e-19 | NR | XP_004336000.1 | 1257118 | g143291 | i0 | 67.7 | 3.95744680851064 | 62 | 20 | 98.9 | 0 | 2 | 187 | 28 | 89 | XP_004336000.1 ribosomal protein S4, putative, partial [Acanthamoeba castellanii str. Neff] | diamond | 744 | 86.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31404846 | 31404846 | PRJNA529241_P_NODE_394736_length_173_cov_2.279412_g392414_i0 | PRJNA529241 | 394736 | 173 | 2.279412 | 3.94338276 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 43.1 | 0.0107 | NR | XP_004333480.1 | 1257118 | g392414 | i0 | 72 | 0.84971098265896 | 25 | 7 | 43.4 | 0 | 173 | 99 | 369 | 393 | XP_004333480.1 uncharacterized protein ACA1_122080 [Acanthamoeba castellanii str. Neff] | diamond | 147 | 43.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;