contig_metadata
17 rows where bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3127801 | 3127801 | PRJNA603943_P_NODE_26903_length_343_cov_0.940741_g26711_i0 | PRJNA603943 | 26903 | 343 | 0.940741 | 3.22674163 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 250 | 1.07e-61 | NTclustered | gi|119552593|gb|EF140724.1| | 5791 | g26711 | i0 | 82.034 | 42.7842565597668 | 295 | 51 | 86 | 2 | 47 | 340 | 127 | 420 | Physarum polycephalum 14-3-3-like protein mRNA, complete cds | blastn | 14675 | 250 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 12057334 | 12057334 | PRJNA603943_P_NODE_70590_length_241_cov_0.869048_g70398_i0 | PRJNA603943 | 70590 | 241 | 0.869048 | 2.09440568 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 116 | 5.96e-29 | NR | PRP83118.1 | 1890364 | g70398 | i0 | 76.3 | 0.946058091286307 | 76 | 18 | 94.6 | 0 | 241 | 14 | 316 | 391 | PRP83118.1 60S ribosomal protein L3 [Planoprotostelium fungivorum] | diamond | 228 | 116 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 22254789 | 22254789 | PRJNA603943_P_NODE_57738_length_248_cov_0.880000_g57546_i0 | PRJNA603943 | 57738 | 248 | 0.88 | 2.1824 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 444 | 3.17e-120 | NTclustered | gi|37515398|emb|AJ584697.1| | 159720 | g57546 | i0 | 99.19 | 78.2459677419355 | 247 | 0 | 99 | 2 | 2 | 248 | 7775 | 7531 | Fuligo septica 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene, isolate NY-1 | blastn | 19405 | 444 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica | ||
| 26890381 | 26890381 | PRJNA603943_P_NODE_61481_length_246_cov_0.890173_g61289_i0 | PRJNA603943 | 61481 | 246 | 0.890173 | 2.18982558 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 72.8 | 1.01e-12 | NR | XP_004357450.1 | 261658 | g61289 | i0 | 45.7 | 4.9390243902439 | 81 | 42 | 98.8 | 1 | 3 | 245 | 761 | 839 | XP_004357450.1 glycogen phosphorylase 2 [Cavenderia fasciculata] | diamond | 1215 | 72.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 27617199 | 27617199 | PRJNA603943_P_NODE_59864_length_247_cov_0.885057_g59672_i0 | PRJNA603943 | 59864 | 247 | 0.885057 | 2.18609079 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 69.7 | 1.02e-11 | NR | XP_020438415.1 | 670386 | g59672 | i0 | 49.2 | 0.716599190283401 | 59 | 30 | 71.7 | 0 | 188 | 12 | 111 | 169 | XP_020438415.1 hypothetical protein PPL_00100 [Heterostelium album PN500] | diamond | 177 | 69.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 27901028 | 27901028 | PRJNA603943_P_NODE_19305_length_388_cov_1.466667_g19113_i0 | PRJNA603943 | 19305 | 388 | 1.466667 | 5.69066796 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 139 | 1.03e-36 | NR | PRP82211.1 | 1890364 | g19113 | i0 | 67 | 1.39948453608247 | 91 | 28 | 68.8 | 1 | 388 | 122 | 289 | 379 | PRP82211.1 hypothetical protein PROFUN_10420 [Planoprotostelium fungivorum] | diamond | 543 | 139 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28532876 | 28532876 | PRJNA603943_P_NODE_24167_length_357_cov_0.982394_g23975_i0 | PRJNA603943 | 24167 | 357 | 0.982394 | 3.50714658 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 86.3 | 7.16e-17 | NR | KYQ91468.1 | 361077 | g23975 | i0 | 57.4 | 0.512605042016807 | 61 | 24 | 49.6 | 1 | 164 | 340 | 200 | 260 | KYQ91468.1 ZZ-type zinc finger-containing protein [Tieghemostelium lacteum] | diamond | 183 | 86.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 29556181 | 29556181 | PRJNA603943_P_NODE_70030_length_241_cov_0.916667_g69838_i0 | PRJNA603943 | 70030 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.5 | 3.25e-17 | NR | KAF2074649.1 | 133409 | g69838 | i0 | 54.7 | 5.90041493775934 | 64 | 29 | 79.7 | 0 | 201 | 10 | 49 | 112 | KAF2074649.1 hypothetical protein CYY_004044 [Polysphondylium violaceum] | diamond | 1422 | 85.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 29700558 | 29700558 | PRJNA603943_P_NODE_27110_length_342_cov_0.955390_g26918_i0 | PRJNA603943 | 27110 | 342 | 0.95539 | 3.2674338 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 167 | 5.86e-46 | NR | PRP82164.1 | 1890364 | g26918 | i0 | 80 | 1.7719298245614 | 95 | 19 | 83.3 | 0 | 57 | 341 | 462 | 556 | PRP82164.1 hypothetical protein PROFUN_10435 [Planoprotostelium fungivorum] | diamond | 606 | 167 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30142807 | 30142807 | PRJNA603943_P_NODE_65932_length_243_cov_1.352941_g65740_i0 | PRJNA603943 | 65932 | 243 | 1.352941 | 3.28764663 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 85.9 | 2.18e-17 | NR | PRP89791.1 | 1890364 | g65740 | i0 | 50.6 | 1.74074074074074 | 81 | 40 | 100 | 0 | 243 | 1 | 348 | 428 | PRP89791.1 hypothetical protein PROFUN_00133 [Planoprotostelium fungivorum] | diamond | 423 | 85.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31009467 | 31009467 | PRJNA603943_P_NODE_46034_length_272_cov_1.547739_g45842_i0 | PRJNA603943 | 46034 | 272 | 1.547739 | 4.20985008 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 7.36e-24 | NR | XP_004361085.1 | 261658 | g45842 | i0 | 56.7 | 1.96323529411765 | 90 | 39 | 99.3 | 0 | 272 | 3 | 186 | 275 | XP_004361085.1 uncharacterized protein DFA_05366 [Cavenderia fasciculata] | diamond | 534 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 31091025 | 31091025 | PRJNA603943_P_NODE_57415_length_248_cov_2.297143_g57223_i0 | PRJNA603943 | 57415 | 248 | 2.297143 | 5.69691464 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 52 | 1.4e-5 | NR | PRP80471.1 | 1890364 | g57223 | i0 | 30.5 | 0.991935483870968 | 82 | 57 | 99.2 | 0 | 1 | 246 | 69 | 150 | PRP80471.1 synaptobrevin domain-containing protein [Planoprotostelium fungivorum] | diamond | 246 | 52 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31976493 | 31976493 | PRJNA603943_P_NODE_24318_length_356_cov_1.070671_g24126_i0 | PRJNA603943 | 24318 | 356 | 1.070671 | 3.81158876 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 53.5 | 2.28e-6 | NR | XP_012753426.1 | 1410327 | g24126 | i0 | 71.4 | 0.353932584269663 | 42 | 12 | 35.4 | 0 | 14 | 139 | 23 | 64 | XP_012753426.1 hypothetical protein SAMD00019534_068600 [Acytostelium subglobosum LB1] | diamond | 126 | 53.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 32229910 | 32229910 | PRJNA603943_P_NODE_65058_length_244_cov_0.900585_g64866_i0 | PRJNA603943 | 65058 | 244 | 0.900585 | 2.1974274 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 145 | 1.35e-39 | NR | PRP88822.1 | 1890364 | g64866 | i0 | 77.5 | 0.983606557377049 | 80 | 18 | 98.4 | 0 | 242 | 3 | 343 | 422 | PRP88822.1 serine carboxypeptidase S10 family member 1-like [Planoprotostelium fungivorum] | diamond | 240 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32261645 | 32261645 | PRJNA603943_P_NODE_35418_length_308_cov_1.195745_g35226_i0 | PRJNA603943 | 35418 | 308 | 1.195745 | 3.6828946 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 85.1 | 6.22e-17 | NR | PRP89226.1 | 1890364 | g35226 | i0 | 48.2 | 0.808441558441558 | 83 | 39 | 80.8 | 2 | 265 | 17 | 26 | 104 | PRP89226.1 hypothetical protein PROFUN_02100 [Planoprotostelium fungivorum] | diamond | 249 | 85.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32274814 | 32274814 | PRJNA603943_P_NODE_57358_length_249_cov_0.875000_g57166_i0 | PRJNA603943 | 57358 | 249 | 0.875 | 2.17875 | root | 1 | Root_unresolved | Root_unresolved | 88.2 | 4.06e-18 | NR | AOE43259.1 | 361085 | g57166 | i0 | 54.4 | 1.93975903614458 | 79 | 36 | 95.2 | 0 | 11 | 247 | 682 | 760 | AOE43259.1 xanthine dehydrogenase [Synstelium polycarpum] | diamond | 483 | 88.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Synstelium | Synstelium polycarpum | ||||
| 32622335 | 32622335 | PRJNA603943_P_NODE_18020_length_399_cov_0.944785_g17828_i0 | PRJNA603943 | 18020 | 399 | 0.944785 | 3.76969215 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 120 | 3.4e-30 | NR | XP_003283736.1 | 5786 | g17828 | i0 | 48.3 | 3.42857142857143 | 120 | 59 | 88.7 | 2 | 397 | 44 | 204 | 322 | XP_003283736.1 uncharacterized protein DICPUDRAFT_147411 [Dictyostelium purpureum] | diamond | 1368 | 120 | 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);;