contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA352850" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22072868 | 22072868 | PRJNA352850_P_NODE_64298_length_285_cov_2.338983_g61465_i0 | PRJNA352850 | 64298 | 285 | 2.338983 | 6.66610155 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 85.5 | 1.97e-17 | NR | KAH3722847.1 | 1580589 | g61465 | i0 | 42 | 1.43157894736842 | 88 | 50 | 92.6 | 1 | 275 | 12 | 216 | 302 | KAH3722847.1 thioredoxin 1 [Pelomyxa schiedti] | diamond | 408 | 85.5 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26758184 | 26758184 | PRJNA352850_P_NODE_63741_length_287_cov_1.747899_g60908_i0 | PRJNA352850 | 63741 | 287 | 1.747899 | 5.01647013 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 92.4 | 2.22e-19 | NR | KAH3743669.1 | 1580589 | g60908 | i0 | 48 | 1.04529616724739 | 100 | 47 | 99.3 | 1 | 287 | 3 | 871 | 970 | KAH3743669.1 protein mono-ADP-ribosyltransferase PARP6 [Pelomyxa schiedti] | diamond | 300 | 92.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26853542 | 26853542 | PRJNA352850_P_NODE_72861_length_263_cov_0.953271_g70028_i0 | PRJNA352850 | 72861 | 263 | 0.953271 | 2.50710273 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 46.2 | 0.00273 | NR | XP_004348706.1 | 1257118 | g70028 | i0 | 40.8 | 1.11787072243346 | 49 | 29 | 55.9 | 0 | 239 | 93 | 338 | 386 | XP_004348706.1 uncharacterized protein ACA1_126730 [Acanthamoeba castellanii str. Neff] | diamond | 294 | 46.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27422709 | 27422709 | PRJNA352850_P_NODE_33903_length_448_cov_3.428571_g31073_i0 | PRJNA352850 | 33903 | 448 | 3.428571 | 15.35999808 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 65.9 | 3.19e-9 | NR | XP_004339528.1 | 1257118 | g31073 | i0 | 37.1 | 0.703125 | 105 | 61 | 67 | 1 | 397 | 98 | 2745 | 2849 | XP_004339528.1 HEAT repeat domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 315 | 65.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27485623 | 27485623 | PRJNA352850_P_NODE_17143_length_726_cov_4.344165_g14461_i0 | PRJNA352850 | 17143 | 726 | 4.344165 | 31.5386379 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 186 | 3.5199999999999996e-52 | NR | XP_012755355.1 | 1410327 | g14461 | i0 | 44.8 | 0.801652892561983 | 194 | 97 | 80.2 | 4 | 54 | 635 | 257 | 440 | XP_012755355.1 hypothetical protein SAMD00019534_044110 [Acytostelium subglobosum LB1] | diamond | 582 | 186 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 27895973 | 27895973 | PRJNA352850_P_NODE_28805_length_502_cov_5.889625_g25979_i0 | PRJNA352850 | 28805 | 502 | 5.889625 | 29.5659175 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 208 | 4.33e-61 | NR | XP_004358064.1 | 1257118 | g25979 | i0 | 70.3 | 0.884462151394422 | 148 | 43 | 87.8 | 1 | 17 | 457 | 431 | 578 | XP_004358064.1 HEAT repeat containing protein, partial [Acanthamoeba castellanii str. Neff] | diamond | 444 | 208 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28274855 | 28274855 | PRJNA352850_P_NODE_41006_length_393_cov_1.662791_g38174_i0 | PRJNA352850 | 41006 | 393 | 1.662791 | 6.53476863 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 137 | 5.4799999999999994e-37 | NR | PRP84833.1 | 1890364 | g38174 | i0 | 55.4 | 0.99236641221374 | 130 | 53 | 95.4 | 2 | 1 | 375 | 134 | 263 | PRP84833.1 hypothetical protein PROFUN_07487 [Planoprotostelium fungivorum] | diamond | 390 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29853763 | 29853763 | PRJNA352850_P_NODE_46271_length_360_cov_4.064309_g43438_i0 | PRJNA352850 | 46271 | 360 | 4.064309 | 14.6315124 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 114 | 3.4200000000000003e-29 | NR | XP_004352065.1 | 1257118 | g43438 | i0 | 52.1 | 1.00833333333333 | 121 | 56 | 100 | 2 | 1 | 360 | 54 | 173 | XP_004352065.1 ribosomal protein S7e, putative [Acanthamoeba castellanii str. Neff] | diamond | 363 | 114 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30043160 | 30043160 | PRJNA352850_P_NODE_5511_length_1700_cov_4.203513_g3812_i0 | PRJNA352850 | 5511 | 1700 | 4.203513 | 71.459721 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 369 | 3.62e-117 | NR | XP_003284160.1 | 5786 | g3812 | i0 | 38.9 | 1.97470588235294 | 561 | 325 | 97.9 | 12 | 3 | 1667 | 42 | 590 | XP_003284160.1 uncharacterized protein DICPUDRAFT_27222 [Dictyostelium purpureum] | diamond | 3357 | 369 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 30391247 | 30391247 | PRJNA352850_P_NODE_65193_length_282_cov_3.296137_g62360_i0 | PRJNA352850 | 65193 | 282 | 3.296137 | 9.29510634 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 50.4 | 9.47e-5 | NR | XP_004355166.1 | 261658 | g62360 | i0 | 44.4 | 0.478723404255319 | 45 | 25 | 47.9 | 0 | 145 | 279 | 155 | 199 | XP_004355166.1 uncharacterized protein DFA_07670 [Cavenderia fasciculata] | diamond | 135 | 50.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30485601 | 30485601 | PRJNA352850_P_NODE_23593_length_577_cov_4.568182_g20782_i0 | PRJNA352850 | 23593 | 577 | 4.568182 | 26.35841014 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 172 | 4.88e-48 | NR | PRP80250.1 | 1890364 | g20782 | i0 | 54.5 | 0.811091854419411 | 156 | 57 | 79.5 | 4 | 3 | 461 | 301 | 445 | PRP80250.1 hypothetical protein PROFUN_12189 [Planoprotostelium fungivorum] | diamond | 468 | 172 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32872941 | 32872941 | PRJNA352850_P_NODE_27860_length_514_cov_3.739785_g25036_i0 | PRJNA352850 | 27860 | 514 | 3.739785 | 19.2224949 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 231 | 4.649999999999999e-72 | NR | XP_001134587.1 | 352472 | g25036 | i0 | 73.6 | 2.58560311284047 | 148 | 39 | 86.4 | 0 | 3 | 446 | 220 | 367 | XP_001134587.1 4-hydroxyphenylpyruvate dioxygenase [Dictyostelium discoideum AX4] | diamond | 1329 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;