contig_metadata
12 rows where bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17970956 | 17970956 | PRJEB50332_P_NODE_12695_length_211_cov_0.866667_g12613_i0 | PRJEB50332 | 12695 | 211 | 0.866667 | 1.82866737 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 385 | 1.61e-102 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g12613 | i0 | 99.526 | 1 | 211 | 1 | 100 | 0 | 1 | 211 | 5532 | 5322 | D.iridis LSU rRNA gene | blastn | 211 | 385 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 18842891 | 18842891 | PRJEB50332_P_NODE_735_length_631_cov_1.971930_g658_i0 | PRJEB50332 | 735 | 631 | 1.97193 | 12.4428783 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 191 | 4.33e-59 | NR | XP_004339588.1 | 1257118 | g658 | i0 | 87.9 | 1.01743264659271 | 107 | 13 | 50.9 | 0 | 616 | 296 | 5 | 111 | XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 642 | 191 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19245037 | 19245037 | PRJEB50332_P_NODE_2216_length_378_cov_1.542587_g2135_i0 | PRJEB50332 | 2216 | 378 | 1.542587 | 5.83097886 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 62.1 | 5.98e-5 | NTclustered | gi|1160555948|ref|XM_020573799.1| | 670386 | g2135 | i0 | 85.965 | 0.150793650793651 | 57 | 8 | 15 | 0 | 14 | 70 | 93 | 149 | Polysphondylium pallidum PN500 40S ribosomal protein S30 (rps30-2), partial mRNA | blastn | 57 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 26748198 | 26748198 | PRJEB50332_P_NODE_10781_length_220_cov_1.528302_g10699_i0 | PRJEB50332 | 10781 | 220 | 1.528302 | 3.3622644 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 88.6 | 1.4e-18 | NR | XP_012747785.1 | 1410327 | g10699 | i0 | 61.1 | 1.96363636363636 | 72 | 28 | 98.2 | 0 | 216 | 1 | 301 | 372 | XP_012747785.1 hypothetical protein SAMD00019534_124630 [Acytostelium subglobosum LB1] | diamond | 432 | 88.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 27602423 | 27602423 | PRJEB50332_P_NODE_5884_length_256_cov_1.333333_g5802_i0 | PRJEB50332 | 5884 | 256 | 1.333333 | 3.41333248 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 62.4 | 5.25e-9 | NR | AAA75489.1 | 44689 | g5802 | i0 | 40.6 | 0.80859375 | 69 | 41 | 80.9 | 0 | 243 | 37 | 11 | 79 | AAA75489.1 fimbrin [Dictyostelium discoideum] | diamond | 207 | 62.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27722243 | 27722243 | PRJEB50332_P_NODE_17804_length_202_cov_0.921986_g17722_i0 | PRJEB50332 | 17804 | 202 | 0.921986 | 1.86241172 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82 | 3.03e-16 | NR | XP_647027.1 | 352472 | g17722 | i0 | 57.5 | 7.76732673267327 | 73 | 24 | 98 | 1 | 3 | 200 | 408 | 480 | XP_647027.1 hypothetical protein DDB_G0268868 [Dictyostelium discoideum AX4] | diamond | 1569 | 82.8 | 0.990338164251208 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27785192 | 27785192 | PRJEB50332_P_NODE_9064_length_230_cov_1.153846_g8982_i0 | PRJEB50332 | 9064 | 230 | 1.153846 | 2.6538458 | root | 1 | Root_unresolved | Root_unresolved | 115 | 1.67e-28 | NR | XP_003288790.1 | 5786 | g8982 | i0 | 73.7 | 8.92173913043478 | 76 | 20 | 99.1 | 0 | 2 | 229 | 80 | 155 | XP_003288790.1 mitochondrial isovaleryl-CoA dehydrogenase [Dictyostelium purpureum] | diamond | 2052 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28454938 | 28454938 | PRJEB50332_P_NODE_2046_length_393_cov_1.373494_g1965_i0 | PRJEB50332 | 2046 | 393 | 1.373494 | 5.39783142 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 61.6 | 4.28e-8 | NR | KAH3758824.1 | 1580589 | g1965 | i0 | 35.3 | 0.648854961832061 | 85 | 55 | 64.9 | 0 | 392 | 138 | 297 | 381 | KAH3758824.1 hypothetical protein Pelo_9343 [Pelomyxa schiedti] | diamond | 255 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29149778 | 29149778 | PRJEB50332_P_NODE_10769_length_220_cov_1.622642_g10687_i0 | PRJEB50332 | 10769 | 220 | 1.622642 | 3.5698124 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 57.4 | 1.91e-7 | NR | KYQ88348.1 | 361077 | g10687 | i0 | 36.1 | 1.59545454545455 | 72 | 46 | 98.2 | 0 | 5 | 220 | 103 | 174 | KYQ88348.1 peptidase S8 and S53 domain-containing protein [Tieghemostelium lacteum] | diamond | 351 | 57.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30381496 | 30381496 | PRJEB50332_P_NODE_573_length_719_cov_3.273556_g503_i0 | PRJEB50332 | 573 | 719 | 3.273556 | 23.53686764 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 59.3 | 4.16e-6 | NR | KAH3758402.1 | 1580589 | g503 | i0 | 37.3 | 0.312934631432545 | 75 | 43 | 30.9 | 2 | 289 | 68 | 312 | 383 | KAH3758402.1 hypothetical protein Pelo_9791 [Pelomyxa schiedti] | diamond | 225 | 59.3 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32088268 | 32088268 | PRJEB50332_P_NODE_5758_length_258_cov_1.918782_g5676_i0 | PRJEB50332 | 5758 | 258 | 1.918782 | 4.95045756 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 101 | 1.16e-22 | NR | XP_020434874.1 | 670386 | g5676 | i0 | 54.8 | 1.95348837209302 | 84 | 38 | 97.7 | 0 | 252 | 1 | 554 | 637 | XP_020434874.1 glycyl-tRNA synthetase [Heterostelium album PN500] | diamond | 504 | 101 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 32688718 | 32688718 | PRJEB50332_P_NODE_9440_length_227_cov_2.078313_g9358_i0 | PRJEB50332 | 9440 | 227 | 2.078313 | 4.71777051 | Entamoeba nuttalli | 412467 | Evosea | other_Eukaryota | 43.9 | 0.012 | NR | GAB1218791.1 | 412467 | g9358 | i0 | 44.7 | 1.86343612334802 | 47 | 26 | 62.1 | 0 | 220 | 80 | 749 | 795 | GAB1218791.1 hypothetical protein ENUP19_0004G0019 [Entamoeba nuttalli] | diamond | 423 | 43.9 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba nuttalli |
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);;