contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1111448" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16794348 | 16794348 | PRJNA1111448_S_NODE_101914_length_269_cov_2.841837_g101091_i0 | PRJNA1111448 | 101914 | 269 | 2.841837 | 7.64454153 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 2e-34 | NR | XP_003293531.1 | 5786 | g101091 | i0 | 68.3 | 8.4089219330855 | 82 | 26 | 91.4 | 0 | 269 | 24 | 102 | 183 | XP_003293531.1 ribosomal protein L11 [Dictyostelium purpureum] | diamond | 2262 | 127 | 0.992125984251969 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27162437 | 27162437 | PRJNA1111448_S_NODE_79702_length_296_cov_2.035874_g78879_i0 | PRJNA1111448 | 79702 | 296 | 2.035874 | 6.02618704 | Vannella simplex | 197532 | Discosea | other_Eukaryota | 77.4 | 1.88e-15 | NR | AUO29161.1 | 197532 | g78879 | i0 | 52.2 | 0.699324324324324 | 69 | 33 | 69.9 | 0 | 87 | 293 | 31 | 99 | AUO29161.1 ribosomal protein L16 [Vannella simplex] | diamond | 207 | 77.4 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella simplex | |||
| 27920597 | 27920597 | PRJNA1111448_S_NODE_123085_length_249_cov_3.107955_g122262_i0 | PRJNA1111448 | 123085 | 249 | 3.107955 | 7.73880795 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 78.2 | 2.87e-16 | NR | XP_004348720.1 | 1257118 | g122262 | i0 | 52 | 0.903614457831325 | 75 | 32 | 90.4 | 2 | 1 | 225 | 60 | 130 | XP_004348720.1 actin binding protein [Acanthamoeba castellanii str. Neff] | diamond | 225 | 78.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28015523 | 28015523 | PRJNA1111448_S_NODE_108105_length_263_cov_1.215789_g107282_i0 | PRJNA1111448 | 108105 | 263 | 1.215789 | 3.19752507 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 51.6 | 3.69e-5 | NR | XP_640711.1 | 352472 | g107282 | i0 | 32.8 | 0.695817490494297 | 61 | 41 | 69.6 | 0 | 5 | 187 | 1098 | 1158 | XP_640711.1 hypothetical protein DDB_G0281485 [Dictyostelium discoideum AX4] | diamond | 183 | 51.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 28583862 | 28583862 | PRJNA1111448_S_NODE_80727_length_295_cov_1.162162_g79904_i0 | PRJNA1111448 | 80727 | 295 | 1.162162 | 3.4283779 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 73.6 | 4.84e-13 | NR | XP_003287614.1 | 5786 | g79904 | i0 | 78.4 | 0.51864406779661 | 51 | 11 | 51.9 | 0 | 293 | 141 | 189 | 239 | XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum] | diamond | 153 | 73.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 29332735 | 29332735 | PRJNA1111448_S_NODE_128989_length_246_cov_1.578035_g128166_i0 | PRJNA1111448 | 128989 | 246 | 1.578035 | 3.8819661 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.4 | 1.6e-18 | NR | PRP88103.1 | 1890364 | g128166 | i0 | 49.4 | 1.89024390243902 | 79 | 39 | 96.3 | 1 | 1 | 237 | 1634 | 1711 | PRP88103.1 intraflagellar transport protein [Planoprotostelium fungivorum] | diamond | 465 | 89.7 | 0.996655518394649 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30668119 | 30668119 | PRJNA1111448_S_NODE_28273_length_417_cov_2.415698_g27450_i0 | PRJNA1111448 | 28273 | 417 | 2.415698 | 10.07346066 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 114 | 1.78e-26 | NR | PRP74799.1 | 1890364 | g27450 | i0 | 48 | 0.884892086330935 | 123 | 62 | 88.5 | 1 | 415 | 47 | 392 | 512 | PRP74799.1 actin binding protein [Planoprotostelium fungivorum] | diamond | 369 | 114 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31015687 | 31015687 | PRJNA1111448_S_NODE_80035_length_296_cov_1.035874_g79212_i0 | PRJNA1111448 | 80035 | 296 | 1.035874 | 3.06618704 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 65.1 | 1.01e-9 | NR | XP_020436557.1 | 670386 | g79212 | i0 | 51.5 | 0.668918918918919 | 66 | 32 | 66.9 | 0 | 1 | 198 | 1263 | 1328 | XP_020436557.1 elongation protein 1 [Heterostelium album PN500] | diamond | 198 | 65.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 31204826 | 31204826 | PRJNA1111448_S_NODE_105935_length_265_cov_1.604167_g105112_i0 | PRJNA1111448 | 105935 | 265 | 1.604167 | 4.25104255 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 75.5 | 1.47e-13 | NR | XP_004334027.1 | 1257118 | g105112 | i0 | 47.4 | 0.860377358490566 | 76 | 37 | 86 | 1 | 264 | 37 | 555 | 627 | XP_004334027.1 alphaactinin, putative [Acanthamoeba castellanii str. Neff] | diamond | 228 | 75.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31837688 | 31837688 | PRJNA1111448_S_NODE_86577_length_287_cov_2.093458_g85754_i0 | PRJNA1111448 | 86577 | 287 | 2.093458 | 6.00822446 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 119 | 2.0899999999999996e-31 | NR | KYQ91511.1 | 361077 | g85754 | i0 | 60.4 | 0.951219512195122 | 91 | 36 | 95.1 | 0 | 285 | 13 | 127 | 217 | KYQ91511.1 elongation factor 1b [Tieghemostelium lacteum] | diamond | 273 | 119 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32588521 | 32588521 | PRJNA1111448_S_NODE_104119_length_267_cov_1.484536_g103296_i0 | PRJNA1111448 | 104119 | 267 | 1.484536 | 3.96371112 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 3.63e-5 | NR | KAH3765792.1 | 1580589 | g103296 | i0 | 37.5 | 3.70786516853933 | 88 | 54 | 98.9 | 1 | 2 | 265 | 376 | 462 | KAH3765792.1 Poly(ADP-ribose) polymerase, regulatory domain [Pelomyxa schiedti] | diamond | 990 | 51.6 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32723084 | 32723084 | PRJNA1111448_S_NODE_121620_length_250_cov_1.740113_g120797_i0 | PRJNA1111448 | 121620 | 250 | 1.740113 | 4.3502825 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 70.5 | 2.02e-12 | NR | XP_020437626.1 | 670386 | g120797 | i0 | 47.9 | 0.852 | 71 | 35 | 82.8 | 1 | 2 | 208 | 154 | 224 | XP_020437626.1 vacuolar H+-ATPase E subunit [Heterostelium album PN500] | diamond | 213 | 70.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;