contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA293022" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 373341 | 373341 | PRJNA293022_P_NODE_57841_length_183_cov_1.432836_g57104_i0 | PRJNA293022 | 57841 | 183 | 1.432836 | 2.62208988 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 95.1 | 7.76e-22 | NR | KAH3761736.1 | 1580589 | g57104 | i0 | 66.7 | 5.01639344262295 | 60 | 19 | 96.7 | 1 | 1 | 177 | 46 | 105 | KAH3761736.1 protein disulfide-isomerase A6 [Pelomyxa schiedti] | diamond | 918 | 95.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26725608 | 26725608 | PRJNA293022_P_NODE_67961_length_169_cov_0.866667_g67224_i0 | PRJNA293022 | 67961 | 169 | 0.866667 | 1.46466723 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 61.6 | 2.9e-9 | NR | XP_003285271.1 | 5786 | g67224 | i0 | 59.1 | 0.781065088757396 | 44 | 18 | 78.1 | 0 | 167 | 36 | 78 | 121 | XP_003285271.1 uncharacterized protein DICPUDRAFT_76201 [Dictyostelium purpureum] | diamond | 132 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 26884527 | 26884527 | PRJNA293022_P_NODE_74201_length_165_cov_0.896552_g73464_i0 | PRJNA293022 | 74201 | 165 | 0.896552 | 1.4793108 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 85.1 | 1.55e-17 | NR | KAH3763756.1 | 1580589 | g73464 | i0 | 72.2 | 1.96363636363636 | 54 | 15 | 98.2 | 0 | 162 | 1 | 61 | 114 | KAH3763756.1 major vault protein [Pelomyxa schiedti] | diamond | 324 | 85.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26996744 | 26996744 | PRJNA293022_P_NODE_74062_length_165_cov_0.896552_g73325_i0 | PRJNA293022 | 74062 | 165 | 0.896552 | 1.4793108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.5 | 1.98e-6 | NR | XP_004359736.1 | 261658 | g73325 | i0 | 49 | 2.85454545454545 | 51 | 26 | 92.7 | 0 | 163 | 11 | 593 | 643 | XP_004359736.1 putative phosphatidylinositol phosphate kinase [Cavenderia fasciculata] | diamond | 471 | 53.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28134219 | 28134219 | PRJNA293022_P_NODE_44225_length_210_cov_1.074534_g43488_i0 | PRJNA293022 | 44225 | 210 | 1.074534 | 2.2565214 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 111 | 1.6e-26 | NR | XP_004332832.1 | 1257118 | g43488 | i0 | 75.4 | 2.95714285714286 | 69 | 17 | 98.6 | 0 | 207 | 1 | 373 | 441 | XP_004332832.1 Prokumamolisin, putative [Acanthamoeba castellanii str. Neff] | diamond | 621 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28242598 | 28242598 | PRJNA293022_P_NODE_39246_length_223_cov_1.183908_g38509_i0 | PRJNA293022 | 39246 | 223 | 1.183908 | 2.64011484 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 81.6 | 1.34e-17 | NR | XP_003284479.1 | 5786 | g38509 | i0 | 54 | 0.847533632286996 | 63 | 29 | 84.8 | 0 | 193 | 5 | 86 | 148 | XP_003284479.1 uncharacterized protein DICPUDRAFT_148253 [Dictyostelium purpureum] | diamond | 189 | 81.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28432253 | 28432253 | PRJNA293022_P_NODE_37826_length_227_cov_1.713483_g37089_i0 | PRJNA293022 | 37826 | 227 | 1.713483 | 3.88960641 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 73.6 | 2.55e-13 | NR | XP_004341732.1 | 1257118 | g37089 | i0 | 87.8 | 1.08370044052863 | 41 | 5 | 54.2 | 0 | 3 | 125 | 269 | 309 | XP_004341732.1 uncharacterized protein ACA1_198710 [Acanthamoeba castellanii str. Neff] | diamond | 246 | 73.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28463932 | 28463932 | PRJNA293022_P_NODE_72066_length_166_cov_0.888889_g71329_i0 | PRJNA293022 | 72066 | 166 | 0.888889 | 1.47555574 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87.8 | 1.05e-20 | NR | XP_004358072.1 | 1257118 | g71329 | i0 | 74.1 | 3.90361445783133 | 54 | 14 | 97.6 | 0 | 164 | 3 | 25 | 78 | XP_004358072.1 ribosomal protein L31e, putative [Acanthamoeba castellanii str. Neff] | diamond | 648 | 87.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28905603 | 28905603 | PRJNA293022_P_NODE_65068_length_172_cov_1.252033_g64331_i0 | PRJNA293022 | 65068 | 172 | 1.252033 | 2.15349676 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 67.8 | 2.11e-11 | NR | PRP80058.1 | 1890364 | g64331 | i0 | 62.3 | 0.924418604651163 | 53 | 20 | 92.4 | 0 | 159 | 1 | 212 | 264 | PRP80058.1 tripeptidyl peptidase I precursor [Planoprotostelium fungivorum] | diamond | 159 | 67.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29032364 | 29032364 | PRJNA293022_P_NODE_75908_length_164_cov_0.904348_g75171_i0 | PRJNA293022 | 75908 | 164 | 0.904348 | 1.48313072 | Paramoeba pemaquidensis | 180228 | Discosea | other_Eukaryota | 99 | 6.819999999999999e-23 | NR | AEL74961.1 | 180228 | g75171 | i0 | 86.8 | 1.86585365853659 | 53 | 7 | 97 | 0 | 161 | 3 | 196 | 248 | AEL74961.1 alpha-tubulin, partial [Paramoeba pemaquidensis] | diamond | 306 | 99 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba pemaquidensis | ||
| 30186486 | 30186486 | PRJNA293022_P_NODE_25272_length_281_cov_1.551724_g24535_i0 | PRJNA293022 | 25272 | 281 | 1.551724 | 4.36034444 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.6 | 3.7e-13 | NR | KAF2071651.1 | 133409 | g24535 | i0 | 40.2 | 1.97508896797153 | 92 | 53 | 98.2 | 1 | 277 | 2 | 79 | 168 | KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum] | diamond | 555 | 71.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 30218115 | 30218115 | PRJNA293022_P_NODE_30772_length_253_cov_1.147059_g30035_i0 | PRJNA293022 | 30772 | 253 | 1.147059 | 2.90205927 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 2.29e-33 | NR | XP_004333102.1 | 1257118 | g30035 | i0 | 71.4 | 1.99209486166008 | 84 | 24 | 99.6 | 0 | 253 | 2 | 48 | 131 | XP_004333102.1 ribosomal protein L32, putative [Acanthamoeba castellanii str. Neff] | diamond | 504 | 121 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30390582 | 30390582 | PRJNA293022_P_NODE_55593_length_187_cov_1.079710_g54856_i0 | PRJNA293022 | 55593 | 187 | 1.07971 | 2.0190577 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 58.2 | 4.78e-9 | NR | XP_004350852.1 | 261658 | g54856 | i0 | 45.6 | 0.914438502673797 | 57 | 31 | 91.4 | 0 | 185 | 15 | 36 | 92 | XP_004350852.1 40S ribosomal protein S25 [Cavenderia fasciculata] | diamond | 171 | 58.2 | 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);;