contig_metadata
13 rows where bioproject = "PRJNA588137" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5668469 | 5668469 | PRJNA588137_S_NODE_1985_length_367_cov_1.309524_g1952_i0 | PRJNA588137 | 1985 | 367 | 1.309524 | 4.80595308 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 183 | 2.489999999999999e-55 | NR | ABL84200.1 | 5791 | g1952 | i0 | 78.9 | 6.00817438692098 | 123 | 25 | 99.7 | 1 | 2 | 367 | 5 | 127 | ABL84200.1 14-3-3-like protein [Physarum polycephalum] | diamond | 2205 | 184 | 0.994565217391304 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 5668498 | 5668498 | PRJNA588137_S_NODE_585_length_600_cov_1.366224_g554_i0 | PRJNA588137 | 585 | 600 | 1.366224 | 8.197344 | Evosea | 2605435 | Evosea | other_Eukaryota | 335 | 3.9699999999999996e-112 | NR | AAB69705.1 | 44689 | g554 | i0 | 82.4 | 11.94 | 199 | 35 | 99.5 | 0 | 3 | 599 | 77 | 275 | AAB69705.1 protein synthesis elongation factor 1-alpha, partial [Dictyostelium discoideum] | diamond | 7164 | 337 | 0.99406528189911 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19691185 | 19691185 | PRJNA588137_S_NODE_816_length_519_cov_1.322870_g783_i0 | PRJNA588137 | 816 | 519 | 1.32287 | 6.8656953 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 175 | 1.74e-50 | NR | KAF2078127.1 | 133409 | g783 | i0 | 50.3 | 2.89595375722543 | 173 | 78 | 98.3 | 3 | 512 | 3 | 104 | 271 | KAF2078127.1 hypothetical protein CYY_000598 [Polysphondylium violaceum] | diamond | 1503 | 175 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 27332731 | 27332731 | PRJNA588137_S_NODE_7003_length_250_cov_0.870056_g6970_i0 | PRJNA588137 | 7003 | 250 | 0.870056 | 2.17514 | Entamoeba dispar SAW76 | 46681 | Evosea | other_Eukaryota | 98.6 | 5.759999999999999e-23 | NR | XP_001736714.1 | 370354 | g6970 | i0 | 56 | 5.004 | 84 | 32 | 99.6 | 2 | 2 | 250 | 98 | 177 | XP_001736714.1 casein kinase, putative [Entamoeba dispar SAW760] | diamond | 1251 | 98.6 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 27553384 | 27553384 | PRJNA588137_S_NODE_7224_length_249_cov_0.875000_g7191_i0 | PRJNA588137 | 7224 | 249 | 0.875 | 2.17875 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 58.2 | 1.45e-7 | NR | XP_012751539.1 | 1410327 | g7191 | i0 | 40.3 | 2.66265060240964 | 72 | 43 | 86.7 | 0 | 217 | 2 | 231 | 302 | XP_012751539.1 hypothetical protein SAMD00019534_087280 [Acytostelium subglobosum LB1] | diamond | 663 | 58.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 27585178 | 27585178 | PRJNA588137_S_NODE_4704_length_279_cov_2.475728_g4671_i0 | PRJNA588137 | 4704 | 279 | 2.475728 | 6.90728112 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 147 | 7.26e-43 | NR | XP_004349731.1 | 1257118 | g4671 | i0 | 70.7 | 0.989247311827957 | 92 | 27 | 98.9 | 0 | 4 | 279 | 15 | 106 | XP_004349731.1 ribosomal protein S13p/S18e, putative [Acanthamoeba castellanii str. Neff] | diamond | 276 | 147 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27900760 | 27900760 | PRJNA588137_S_NODE_6645_length_251_cov_0.865169_g6612_i0 | PRJNA588137 | 6645 | 251 | 0.865169 | 2.17157419 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 67.8 | 4.21e-11 | NR | XP_004337970.1 | 1257118 | g6612 | i0 | 42.4 | 1.01593625498008 | 85 | 44 | 95.6 | 1 | 8 | 247 | 181 | 265 | XP_004337970.1 CBS domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 255 | 67.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28735356 | 28735356 | PRJNA588137_S_NODE_9687_length_244_cov_0.900585_g9654_i0 | PRJNA588137 | 9687 | 244 | 0.900585 | 2.1974274 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 106 | 1.22e-24 | NR | XP_004362768.1 | 261658 | g9654 | i0 | 64.6 | 2.91393442622951 | 79 | 26 | 97.1 | 2 | 239 | 3 | 408 | 484 | XP_004362768.1 class VII unconventional myosin [Cavenderia fasciculata] | diamond | 711 | 107 | 0.990654205607477 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 29668705 | 29668705 | PRJNA588137_S_NODE_8070_length_247_cov_1.017241_g8037_i0 | PRJNA588137 | 8070 | 247 | 1.017241 | 2.51258527 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 82.8 | 2.47e-16 | NR | XP_012755339.1 | 1410327 | g8037 | i0 | 48.8 | 1.9919028340081 | 82 | 42 | 99.6 | 0 | 246 | 1 | 100 | 181 | XP_012755339.1 hypothetical protein SAMD00019534_043950 [Acytostelium subglobosum LB1] | diamond | 492 | 82.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 29682223 | 29682223 | PRJNA588137_S_NODE_7530_length_249_cov_0.875000_g7497_i0 | PRJNA588137 | 7530 | 249 | 0.875 | 2.17875 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 60.1 | 1.23e-8 | NR | XP_004367175.1 | 261658 | g7497 | i0 | 41.5 | 8.36144578313253 | 65 | 35 | 78.3 | 1 | 249 | 55 | 89 | 150 | XP_004367175.1 uncharacterized protein DFA_07312 [Cavenderia fasciculata] | diamond | 2082 | 60.5 | 0.993388429752066 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30427672 | 30427672 | PRJNA588137_S_NODE_10193_length_243_cov_0.905882_g10160_i0 | PRJNA588137 | 10193 | 243 | 0.905882 | 2.20129326 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 88.2 | 3.09e-18 | NR | XP_642645.1 | 352472 | g10160 | i0 | 58.8 | 1.54320987654321 | 68 | 28 | 84 | 0 | 239 | 36 | 343 | 410 | XP_642645.1 ammonium transporter [Dictyostelium discoideum AX4] | diamond | 375 | 88.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31121968 | 31121968 | PRJNA588137_S_NODE_7255_length_249_cov_0.875000_g7222_i0 | PRJNA588137 | 7255 | 249 | 0.875 | 2.17875 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 43.1 | 0.029 | NR | XP_004184837.1 | 370355 | g7222 | i0 | 32.9 | 1.98795180722892 | 82 | 50 | 94 | 3 | 15 | 248 | 425 | 505 | XP_004184837.1 hypothetical protein EIN_040850 [Entamoeba invadens IP1] | diamond | 495 | 43.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 31691540 | 31691540 | PRJNA588137_S_NODE_5397_length_266_cov_1.196891_g5364_i0 | PRJNA588137 | 5397 | 266 | 1.196891 | 3.18373006 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 136 | 1.04e-38 | NR | XP_004333797.1 | 1257118 | g5364 | i0 | 80.7 | 6.94736842105263 | 88 | 15 | 99.2 | 1 | 1 | 264 | 32 | 117 | XP_004333797.1 ADPribosylation factor, putative [Acanthamoeba castellanii str. Neff] | diamond | 1848 | 136 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;