contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26783033 | 26783033 | PRJNA1103784_P_NODE_6201_length_248_cov_1.388571_g6146_i0 | PRJNA1103784 | 6201 | 248 | 1.388571 | 3.44365608 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 64.7 | 7.21e-10 | NR | XP_643949.1 | 352472 | g6146 | i0 | 47.6 | 0.762096774193548 | 63 | 33 | 76.2 | 0 | 192 | 4 | 171 | 233 | XP_643949.1 hypothetical protein DDB_G0274325 [Dictyostelium discoideum AX4] | diamond | 189 | 64.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27857306 | 27857306 | PRJNA1103784_P_NODE_4505_length_272_cov_1.281407_g4450_i0 | PRJNA1103784 | 4505 | 272 | 1.281407 | 3.48542704 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 83.2 | 1.23e-16 | NR | XP_004352561.1 | 1257118 | g4450 | i0 | 43.8 | 0.981617647058823 | 89 | 50 | 98.2 | 0 | 268 | 2 | 212 | 300 | XP_004352561.1 EF hand domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 267 | 83.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28394066 | 28394066 | PRJNA1103784_P_NODE_5886_length_250_cov_0.870056_g5831_i0 | PRJNA1103784 | 5886 | 250 | 0.870056 | 2.17514 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 100 | 5.02e-23 | NR | XP_012756598.1 | 1410327 | g5831 | i0 | 58.5 | 0.984 | 82 | 30 | 98.4 | 1 | 249 | 4 | 183 | 260 | XP_012756598.1 hypothetical protein SAMD00019534_030110 [Acytostelium subglobosum LB1] | diamond | 246 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 28488914 | 28488914 | PRJNA1103784_P_NODE_4147_length_279_cov_1.470874_g4092_i0 | PRJNA1103784 | 4147 | 279 | 1.470874 | 4.10373846 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 64.3 | 1.41e-9 | NR | XP_020428762.1 | 670386 | g4092 | i0 | 37 | 1.73118279569892 | 81 | 51 | 87.1 | 0 | 245 | 3 | 383 | 463 | XP_020428762.1 dynactin 50 kDa subunit [Heterostelium album PN500] | diamond | 483 | 64.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28678469 | 28678469 | PRJNA1103784_P_NODE_7347_length_243_cov_0.905882_g7292_i0 | PRJNA1103784 | 7347 | 243 | 0.905882 | 2.20129326 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 42.7 | 0.0369 | NR | XP_012752371.1 | 1410327 | g7292 | i0 | 34.7 | 0.888888888888889 | 72 | 32 | 88.9 | 1 | 226 | 11 | 304 | 360 | XP_012752371.1 hypothetical protein SAMD00019534_078770 [Acytostelium subglobosum LB1] | diamond | 216 | 42.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 28954000 | 28954000 | PRJNA1103784_P_NODE_7068_length_244_cov_0.912281_g7013_i0 | PRJNA1103784 | 7068 | 244 | 0.912281 | 2.22596564 | root | 1 | Root_unresolved | Root_unresolved | 105 | 4.59e-25 | NR | XP_643167.1 | 352472 | g7013 | i0 | 59.3 | 4.95491803278689 | 81 | 33 | 99.6 | 0 | 243 | 1 | 240 | 320 | XP_643167.1 NAD-dependent epimerase/dehydratase family protein [Dictyostelium discoideum AX4] | diamond | 1209 | 105 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 29341458 | 29341458 | PRJNA1103784_P_NODE_1569_length_410_cov_1.451039_g1514_i0 | PRJNA1103784 | 1569 | 410 | 1.451039 | 5.9492599 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 117 | 9.19e-29 | NR | KYQ89807.1 | 361077 | g1514 | i0 | 46.9 | 5.49512195121951 | 128 | 61 | 93.7 | 2 | 26 | 409 | 15 | 135 | KYQ89807.1 hypothetical protein DLAC_09777 [Tieghemostelium lacteum] | diamond | 2253 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30058824 | 30058824 | PRJNA1103784_P_NODE_7811_length_241_cov_0.916667_g7756_i0 | PRJNA1103784 | 7811 | 241 | 0.916667 | 2.20916747 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 60.5 | 1.19e-8 | NR | XP_635380.1 | 352472 | g7756 | i0 | 54.9 | 2.06639004149378 | 51 | 23 | 63.5 | 0 | 154 | 2 | 26 | 76 | XP_635380.1 NADH dehydrogenase [Dictyostelium discoideum AX4] | diamond | 498 | 60.8 | 0.995065789473684 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 30469930 | 30469930 | PRJNA1103784_P_NODE_3933_length_284_cov_1.393365_g3878_i0 | PRJNA1103784 | 3933 | 284 | 1.393365 | 3.9571566 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 97.8 | 1.58e-21 | NR | XP_004350597.1 | 261658 | g3878 | i0 | 50.5 | 3.84507042253521 | 93 | 43 | 98.2 | 1 | 283 | 5 | 74 | 163 | XP_004350597.1 oxysterol binding family protein [Cavenderia fasciculata] | diamond | 1092 | 97.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 31268422 | 31268422 | PRJNA1103784_P_NODE_5435_length_254_cov_1.657459_g5380_i0 | PRJNA1103784 | 5435 | 254 | 1.657459 | 4.20994586 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 109 | 1.19e-25 | NR | PRP80096.1 | 1890364 | g5380 | i0 | 60.5 | 0.897637795275591 | 76 | 30 | 89.8 | 0 | 230 | 3 | 619 | 694 | PRP80096.1 glycosyltransferase, CAZy family GT4 [Planoprotostelium fungivorum] | diamond | 228 | 109 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31417800 | 31417800 | PRJNA1103784_P_NODE_5396_length_255_cov_1.269231_g5341_i0 | PRJNA1103784 | 5396 | 255 | 1.269231 | 3.23653905 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 1.7e-26 | NR | XP_643401.2 | 352472 | g5341 | i0 | 67.9 | 1.88235294117647 | 78 | 24 | 90.6 | 1 | 255 | 25 | 205 | 282 | XP_643401.2 S-adenosylmethionine decarboxylase [Dictyostelium discoideum AX4] | diamond | 480 | 110 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31647746 | 31647746 | PRJNA1103784_P_NODE_3877_length_285_cov_2.344340_g3822_i0 | PRJNA1103784 | 3877 | 285 | 2.34434 | 6.681369 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 105 | 1.14e-26 | NR | XP_004348720.1 | 1257118 | g3822 | i0 | 58.5 | 0.863157894736842 | 82 | 34 | 86.3 | 0 | 10 | 255 | 47 | 128 | XP_004348720.1 actin binding protein [Acanthamoeba castellanii str. Neff] | diamond | 246 | 105 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31711220 | 31711220 | PRJNA1103784_P_NODE_6197_length_248_cov_1.428571_g6142_i0 | PRJNA1103784 | 6197 | 248 | 1.428571 | 3.54285608 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 80.9 | 1.77e-16 | NR | XP_643135.1 | 352472 | g6142 | i0 | 51.4 | 0.895161290322581 | 74 | 36 | 89.5 | 0 | 13 | 234 | 148 | 221 | XP_643135.1 hypothetical protein DDB_G0276479 [Dictyostelium discoideum AX4] | diamond | 222 | 80.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31892259 | 31892259 | PRJNA1103784_P_NODE_1717_length_396_cov_1.191950_g1662_i0 | PRJNA1103784 | 1717 | 396 | 1.19195 | 4.720122 | root | 1 | Root_unresolved | Root_unresolved | 182 | 1.41e-52 | NR | PRP82528.1 | 1890364 | g1662 | i0 | 68.8 | 2.91666666666667 | 128 | 40 | 97 | 0 | 394 | 11 | 303 | 430 | PRP82528.1 L-lysine 6-transaminase [Planoprotostelium fungivorum] | diamond | 1155 | 182 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31900988 | 31900988 | PRJNA1103784_P_NODE_7897_length_240_cov_2.305389_g7842_i0 | PRJNA1103784 | 7897 | 240 | 2.305389 | 5.5329336 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 119 | 4.43e-29 | NR | PRP72804.1 | 1890364 | g7842 | i0 | 63.6 | 0.9625 | 77 | 27 | 95 | 1 | 235 | 8 | 241 | 317 | PRP72804.1 hypothetical protein PROFUN_07704 [Planoprotostelium fungivorum] | diamond | 231 | 119 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32493631 | 32493631 | PRJNA1103784_P_NODE_3899_length_285_cov_1.283019_g3844_i0 | PRJNA1103784 | 3899 | 285 | 1.283019 | 3.65660415 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.0328 | NR | PRP83486.1 | 1890364 | g3844 | i0 | 42.2 | 2.10526315789474 | 64 | 27 | 66.3 | 3 | 93 | 281 | 315 | 369 | PRP83486.1 hypothetical protein PROFUN_04360 [Planoprotostelium fungivorum] | diamond | 600 | 43.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32817327 | 32817327 | PRJNA1103784_P_NODE_5840_length_250_cov_0.870056_g5785_i0 | PRJNA1103784 | 5840 | 250 | 0.870056 | 2.17514 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 68.6 | 8.1e-12 | NR | XP_012748052.1 | 1410327 | g5785 | i0 | 45.3 | 3.54 | 75 | 41 | 90 | 0 | 233 | 9 | 121 | 195 | XP_012748052.1 hypothetical protein SAMD00019534_122220, partial [Acytostelium subglobosum LB1] | diamond | 885 | 68.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 32817328 | 32817328 | PRJNA1103784_P_NODE_7460_length_242_cov_2.278107_g7405_i0 | PRJNA1103784 | 7460 | 242 | 2.278107 | 5.51301894 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 55.5 | 2.47e-7 | NR | KYR02504.1 | 361077 | g7405 | i0 | 39 | 1.93388429752066 | 77 | 40 | 95.5 | 3 | 11 | 241 | 23 | 92 | KYR02504.1 actin binding protein [Tieghemostelium lacteum] | diamond | 468 | 55.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum |
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);;