contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1111077" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2765541 | 2765541 | PRJNA1111077_P_NODE_31303_length_249_cov_1.670455_g31082_i0 | PRJNA1111077 | 31303 | 249 | 1.670455 | 4.15943295 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 102 | 1.48e-25 | NR | XP_004353558.1 | 1257118 | g31082 | i0 | 70 | 1.67469879518072 | 70 | 21 | 84.3 | 0 | 248 | 39 | 98 | 167 | XP_004353558.1 uncharacterized protein ACA1_144210 [Acanthamoeba castellanii str. Neff] | diamond | 417 | 102 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5317806 | 5317806 | PRJNA1111077_P_NODE_34145_length_245_cov_0.895349_g33924_i0 | PRJNA1111077 | 34145 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99 | 1.49e-22 | NR | XP_003284553.1 | 5786 | g33924 | i0 | 65.7 | 6.41632653061224 | 67 | 23 | 82 | 0 | 214 | 14 | 108 | 174 | XP_003284553.1 uncharacterized protein DICPUDRAFT_96752 [Dictyostelium purpureum] | diamond | 1572 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7867401 | 7867401 | PRJNA1111077_P_NODE_22447_length_279_cov_1.233010_g22226_i0 | PRJNA1111077 | 22447 | 279 | 1.23301 | 3.4400979 | Evosea | 2605435 | Evosea | other_Eukaryota | 174 | 4.089999999999999e-52 | NR | XP_020429869.1 | 670386 | g22226 | i0 | 83.9 | 6 | 93 | 15 | 100 | 0 | 279 | 1 | 35 | 127 | XP_020429869.1 subunit of heterodimeric actin capping protein cap32/34 [Heterostelium album PN500] | diamond | 1674 | 174 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 7867536 | 7867536 | PRJNA1111077_P_NODE_28127_length_258_cov_2.102703_g27906_i0 | PRJNA1111077 | 28127 | 258 | 2.102703 | 5.42497374 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 107 | 1.0799999999999999e-24 | NR | XP_004336225.1 | 1257118 | g27906 | i0 | 65.9 | 7.62790697674419 | 82 | 28 | 95.3 | 0 | 250 | 5 | 262 | 343 | XP_004336225.1 gammaadaptin 1, putative [Acanthamoeba castellanii str. Neff] | diamond | 1968 | 107 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11693294 | 11693294 | PRJNA1111077_P_NODE_22870_length_277_cov_2.215686_g22649_i0 | PRJNA1111077 | 22870 | 277 | 2.215686 | 6.13745022 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 124 | 3.56e-31 | NR | XP_004334355.1 | 1257118 | g22649 | i0 | 56 | 1.9927797833935 | 91 | 40 | 98.6 | 0 | 276 | 4 | 315 | 405 | XP_004334355.1 protein disulfideisomerase domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 552 | 124 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11693366 | 11693366 | PRJNA1111077_P_NODE_25490_length_268_cov_1.579487_g25269_i0 | PRJNA1111077 | 25490 | 268 | 1.579487 | 4.23302516 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 133 | 4.47e-34 | NR | PRP86558.1 | 1890364 | g25269 | i0 | 70.2 | 0.940298507462687 | 84 | 25 | 94 | 0 | 252 | 1 | 440 | 523 | PRP86558.1 ribosomal protein S18 isoform 1 [Planoprotostelium fungivorum] | diamond | 252 | 133 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27162375 | 27162375 | PRJNA1111077_P_NODE_34242_length_245_cov_0.895349_g34021_i0 | PRJNA1111077 | 34242 | 245 | 0.895349 | 2.19360505 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 89.7 | 1.58e-21 | NR | XP_004352995.1 | 1257118 | g34021 | i0 | 62.1 | 1.7265306122449 | 66 | 25 | 80.8 | 0 | 2 | 199 | 5 | 70 | XP_004352995.1 uncharacterized protein ACA1_070880 [Acanthamoeba castellanii str. Neff] | diamond | 423 | 89.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27185297 | 27185297 | PRJNA1111077_P_NODE_12822_length_331_cov_2.003876_g12601_i0 | PRJNA1111077 | 12822 | 331 | 2.003876 | 6.63282956 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 201 | 5.45e-58 | NR | XP_003292154.1 | 5786 | g12601 | i0 | 85.5 | 6.97885196374622 | 110 | 16 | 99.7 | 0 | 1 | 330 | 451 | 560 | XP_003292154.1 major vault protein-alpha [Dictyostelium purpureum] | diamond | 2310 | 201 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27541762 | 27541762 | PRJNA1111077_P_NODE_27704_length_260_cov_1.529412_g27483_i0 | PRJNA1111077 | 27704 | 260 | 1.529412 | 3.9764712 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 59.3 | 6.65e-8 | NR | KYQ89250.1 | 361077 | g27483 | i0 | 32.6 | 1.96153846153846 | 86 | 56 | 99.2 | 2 | 3 | 260 | 480 | 563 | KYQ89250.1 hypothetical protein DLAC_09905, partial [Tieghemostelium lacteum] | diamond | 510 | 59.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 27636591 | 27636591 | PRJNA1111077_P_NODE_36244_length_242_cov_0.911243_g36023_i0 | PRJNA1111077 | 36244 | 242 | 0.911243 | 2.20520806 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 72 | 1.79e-12 | NR | XP_004341420.1 | 1257118 | g36023 | i0 | 48.1 | 0.954545454545455 | 77 | 37 | 95.5 | 1 | 6 | 236 | 478 | 551 | XP_004341420.1 vacuolar sorting protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 231 | 72 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28046873 | 28046873 | PRJNA1111077_P_NODE_32205_length_248_cov_0.880000_g31984_i0 | PRJNA1111077 | 32205 | 248 | 0.88 | 2.1824 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 47.8 | 6.43e-4 | NR | KAH3757540.1 | 1580589 | g31984 | i0 | 35.4 | 0.991935483870968 | 82 | 48 | 98 | 3 | 5 | 247 | 254 | 331 | KAH3757540.1 hypothetical protein Pelo_10656 [Pelomyxa schiedti] | diamond | 246 | 47.8 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28962773 | 28962773 | PRJNA1111077_P_NODE_27908_length_259_cov_1.655914_g27687_i0 | PRJNA1111077 | 27908 | 259 | 1.655914 | 4.28881726 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 132 | 1.79e-36 | NR | PRP80408.1 | 1890364 | g27687 | i0 | 77.6 | 35.4440154440154 | 85 | 19 | 98.5 | 0 | 2 | 256 | 60 | 144 | PRP80408.1 40S ribosomal protein S9 [Planoprotostelium fungivorum] | diamond | 9180 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29878349 | 29878349 | PRJNA1111077_P_NODE_25011_length_270_cov_1.375635_g24790_i0 | PRJNA1111077 | 25011 | 270 | 1.375635 | 3.7142145 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 97.4 | 3.18e-21 | NR | XP_004339747.1 | 1257118 | g24790 | i0 | 52.7 | 1.01111111111111 | 91 | 42 | 100 | 1 | 270 | 1 | 923 | 1013 | XP_004339747.1 leucine rich repeat domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 273 | 97.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30004661 | 30004661 | PRJNA1111077_P_NODE_14771_length_310_cov_5.088608_g14550_i0 | PRJNA1111077 | 14771 | 310 | 5.088608 | 15.7746848 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 48.5 | 4.23e-4 | NR | KYQ93088.1 | 361077 | g14550 | i0 | 42.6 | 1.96451612903226 | 47 | 26 | 45.5 | 1 | 148 | 8 | 82 | 127 | KYQ93088.1 Ras GTPase [Tieghemostelium lacteum] | diamond | 609 | 48.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30130602 | 30130602 | PRJNA1111077_P_NODE_26632_length_264_cov_1.612565_g26411_i0 | PRJNA1111077 | 26632 | 264 | 1.612565 | 4.2571716 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 155 | 1.56e-41 | NR | PRP86903.1 | 1890364 | g26411 | i0 | 83.9 | 1.97727272727273 | 87 | 14 | 98.9 | 0 | 2 | 262 | 246 | 332 | PRP86903.1 elongation factor 2-like isoform 1 [Planoprotostelium fungivorum] | diamond | 522 | 155 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30352678 | 30352678 | PRJNA1111077_P_NODE_35392_length_243_cov_0.905882_g35171_i0 | PRJNA1111077 | 35392 | 243 | 0.905882 | 2.20129326 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 82.8 | 3.03e-16 | NR | PRP82175.1 | 1890364 | g35171 | i0 | 53.7 | 1.01234567901235 | 82 | 37 | 100 | 1 | 243 | 1 | 598 | 679 | PRP82175.1 Ras GTPase-activating protein [Planoprotostelium fungivorum] | diamond | 246 | 82.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30573022 | 30573022 | PRJNA1111077_P_NODE_12893_length_330_cov_2.311284_g12672_i0 | PRJNA1111077 | 12893 | 330 | 2.311284 | 7.6272372 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 94.4 | 3.51e-20 | NR | KAH3758824.1 | 1580589 | g12672 | i0 | 47.7 | 0.990909090909091 | 109 | 53 | 97.3 | 3 | 325 | 5 | 241 | 347 | KAH3758824.1 hypothetical protein Pelo_9343 [Pelomyxa schiedti] | diamond | 327 | 94.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 31901054 | 31901054 | PRJNA1111077_P_NODE_29497_length_253_cov_1.516667_g29276_i0 | PRJNA1111077 | 29497 | 253 | 1.516667 | 3.83716751 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 59.3 | 6.09e-8 | NR | KYQ91298.1 | 361077 | g29276 | i0 | 41 | 2.20553359683794 | 61 | 36 | 72.3 | 0 | 253 | 71 | 465 | 525 | KYQ91298.1 eIF-3 zeta [Tieghemostelium lacteum] | diamond | 558 | 59.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32154231 | 32154231 | PRJNA1111077_P_NODE_34098_length_245_cov_0.895349_g33877_i0 | PRJNA1111077 | 34098 | 245 | 0.895349 | 2.19360505 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 70.9 | 6.74e-13 | NR | PRP89677.1 | 1890364 | g33877 | i0 | 53.3 | 0.918367346938776 | 75 | 34 | 91.8 | 1 | 226 | 2 | 7 | 80 | PRP89677.1 COMM domain-containing protein 9-like [Planoprotostelium fungivorum] | diamond | 225 | 70.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32808638 | 32808638 | PRJNA1111077_P_NODE_24020_length_273_cov_2.370000_g23799_i0 | PRJNA1111077 | 24020 | 273 | 2.37 | 6.4701 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 150 | 1.6799999999999994e-42 | NR | XP_003287614.1 | 5786 | g23799 | i0 | 85.6 | 4.9010989010989 | 90 | 12 | 98.9 | 1 | 273 | 4 | 126 | 214 | XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum] | diamond | 1338 | 150 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;