contig_metadata
17 rows where bioproject = "PRJNA293022", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 373341 | 373341 | PRJNA293022_P_NODE_57841_length_183_cov_1.432836_g57104_i0 | PRJNA293022 | 57841 | 183 | 1.432836 | 2.62208988 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 95.1 | 7.76e-22 | NR | KAH3761736.1 | 1580589 | g57104 | i0 | 66.7 | 5.01639344262295 | 60 | 19 | 96.7 | 1 | 1 | 177 | 46 | 105 | KAH3761736.1 protein disulfide-isomerase A6 [Pelomyxa schiedti] | diamond | 918 | 95.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 11851971 | 11851971 | PRJNA293022_P_NODE_47470_length_202_cov_2.640523_g46733_i0 | PRJNA293022 | 47470 | 202 | 2.640523 | 5.33385646 | Heterostelium pallidum | 13642 | Evosea | other_Eukaryota | 84.2 | 6.24e-12 | NTclustered | gi|160688721|gb|EU275726.1| | 13642 | g46733 | i0 | 80.531 | 70.6336633663366 | 113 | 19 | 55 | 3 | 6 | 116 | 21962 | 21851 | Polysphondylium pallidum strain PN500 mitochondrion, complete genome | blastn | 14268 | 84.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium pallidum | ||
| 11852130 | 11852130 | PRJNA293022_P_NODE_79450_length_162_cov_0.920354_g78713_i0 | PRJNA293022 | 79450 | 162 | 0.920354 | 1.49097348 | Heterostelium pallidum | 13642 | Evosea | other_Eukaryota | 111 | 2.19e-20 | NTclustered | gi|60117108|ref|NC_006862.1| | 13642 | g78713 | i0 | 92.5 | 9.24691358024691 | 80 | 3 | 48 | 3 | 4 | 81 | 261 | 183 | Polysphondylium pallidum mitochondrion, complete genome | blastn | 1498 | 111 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium pallidum | ||
| 14402439 | 14402439 | PRJNA293022_P_NODE_78752_length_162_cov_1.123894_g78015_i0 | PRJNA293022 | 78752 | 162 | 1.123894 | 1.82070828 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 279 | 5.68e-71 | NTclustered | gi|262262901|gb|FJ766444.1| | 472931 | g78015 | i0 | 98.125 | 2.98765432098765 | 160 | 3 | 99 | 0 | 1 | 160 | 740 | 581 | Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence | blastn | 484 | 279 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 16950705 | 16950705 | PRJNA293022_P_NODE_46654_length_204_cov_2.000000_g45917_i0 | PRJNA293022 | 46654 | 204 | 2 | 4.08 | Entamoeba invadens | 33085 | Evosea | other_Eukaryota | 52.8 | 0.018 | NTclustered | gi|471207746|ref|XM_004260429.1| | 370355 | g45917 | i0 | 100 | 0.137254901960784 | 28 | 0 | 14 | 0 | 140 | 167 | 433 | 406 | Entamoeba invadens IP1 hypothetical protein (EIN_432580) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 19499296 | 19499296 | PRJNA293022_P_NODE_65856_length_171_cov_0.852459_g65119_i0 | PRJNA293022 | 65856 | 171 | 0.852459 | 1.45770489 | Phalansterium sp. PJK-2012 | 1267188 | Evosea | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|429125732|gb|KC121006.1| | 1267188 | g65119 | i0 | 100 | 0.16374269005848 | 28 | 0 | 16 | 0 | 9 | 36 | 1417 | 1390 | Phalansterium sp. PJK-2012 mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium sp. PJK-2012 | ||||
| 22049909 | 22049909 | PRJNA293022_P_NODE_71238_length_167_cov_0.881356_g70501_i0 | PRJNA293022 | 71238 | 167 | 0.881356 | 1.47186452 | Coremiostelium polycephalum | 142831 | Evosea | other_Eukaryota | 93.5 | 8.25e-15 | NTclustered | gi|85062629|gb|DQ340387.1| | 142831 | g70501 | i0 | 88.312 | 48.059880239521 | 77 | 9 | 46 | 0 | 77 | 153 | 12448 | 12524 | Dictyostelium polycephalum 17S ribosomal RNA, 5.8S ribosomal RNA, and 26S ribosomal RNA genes, complete sequence | blastn | 8026 | 93.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Coremiostelium | Coremiostelium polycephalum | |||
| 23325272 | 23325272 | PRJNA293022_P_NODE_27379_length_269_cov_1.654545_g26642_i0 | PRJNA293022 | 27379 | 269 | 1.654545 | 4.45072605 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 473 | 4.439999999999999e-129 | NTclustered | gi|262262901|gb|FJ766444.1| | 472931 | g26642 | i0 | 98.513 | 64.2044609665428 | 269 | 2 | 99 | 1 | 1 | 267 | 271 | 3 | Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence | blastn | 17271 | 473 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 23325293 | 23325293 | PRJNA293022_P_NODE_33659_length_241_cov_1.755208_g32922_i0 | PRJNA293022 | 33659 | 241 | 1.755208 | 4.23005128 | Entamoeba gingivalis | 38877 | Evosea | other_Eukaryota | 442 | 1.0999999999999999e-119 | NTclustered | gi|2425687086|gb|OQ225454.1| | 38877 | g32922 | i0 | 100 | 85.7551867219917 | 239 | 0 | 99 | 0 | 1 | 239 | 371 | 133 | Entamoeba gingivalis isolate IH_ST2 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 20667 | 442 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba gingivalis | |||
| 23325393 | 23325393 | PRJNA293022_P_NODE_59479_length_180_cov_1.923664_g58742_i0 | PRJNA293022 | 59479 | 180 | 1.923664 | 3.4625952 | Perichaena vermicularis | 2715190 | Evosea | other_Eukaryota | 141 | 3.17e-29 | NTclustered | gi|1883421894|gb|MT162157.1| | 2715190 | g58742 | i0 | 83.784 | 85.0555555555556 | 148 | 24 | 82 | 0 | 1 | 148 | 968 | 821 | Perichaena vermicularis voucher BR<BEL>:5020025765604 elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 15310 | 141 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Perichaena | Perichaena vermicularis | ||
| 26725608 | 26725608 | PRJNA293022_P_NODE_67961_length_169_cov_0.866667_g67224_i0 | PRJNA293022 | 67961 | 169 | 0.866667 | 1.46466723 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 61.6 | 2.9e-9 | NR | XP_003285271.1 | 5786 | g67224 | i0 | 59.1 | 0.781065088757396 | 44 | 18 | 78.1 | 0 | 167 | 36 | 78 | 121 | XP_003285271.1 uncharacterized protein DICPUDRAFT_76201 [Dictyostelium purpureum] | diamond | 132 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 26884527 | 26884527 | PRJNA293022_P_NODE_74201_length_165_cov_0.896552_g73464_i0 | PRJNA293022 | 74201 | 165 | 0.896552 | 1.4793108 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 85.1 | 1.55e-17 | NR | KAH3763756.1 | 1580589 | g73464 | i0 | 72.2 | 1.96363636363636 | 54 | 15 | 98.2 | 0 | 162 | 1 | 61 | 114 | KAH3763756.1 major vault protein [Pelomyxa schiedti] | diamond | 324 | 85.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26996744 | 26996744 | PRJNA293022_P_NODE_74062_length_165_cov_0.896552_g73325_i0 | PRJNA293022 | 74062 | 165 | 0.896552 | 1.4793108 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.5 | 1.98e-6 | NR | XP_004359736.1 | 261658 | g73325 | i0 | 49 | 2.85454545454545 | 51 | 26 | 92.7 | 0 | 163 | 11 | 593 | 643 | XP_004359736.1 putative phosphatidylinositol phosphate kinase [Cavenderia fasciculata] | diamond | 471 | 53.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28242598 | 28242598 | PRJNA293022_P_NODE_39246_length_223_cov_1.183908_g38509_i0 | PRJNA293022 | 39246 | 223 | 1.183908 | 2.64011484 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 81.6 | 1.34e-17 | NR | XP_003284479.1 | 5786 | g38509 | i0 | 54 | 0.847533632286996 | 63 | 29 | 84.8 | 0 | 193 | 5 | 86 | 148 | XP_003284479.1 uncharacterized protein DICPUDRAFT_148253 [Dictyostelium purpureum] | diamond | 189 | 81.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28905603 | 28905603 | PRJNA293022_P_NODE_65068_length_172_cov_1.252033_g64331_i0 | PRJNA293022 | 65068 | 172 | 1.252033 | 2.15349676 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 67.8 | 2.11e-11 | NR | PRP80058.1 | 1890364 | g64331 | i0 | 62.3 | 0.924418604651163 | 53 | 20 | 92.4 | 0 | 159 | 1 | 212 | 264 | PRP80058.1 tripeptidyl peptidase I precursor [Planoprotostelium fungivorum] | diamond | 159 | 67.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30186486 | 30186486 | PRJNA293022_P_NODE_25272_length_281_cov_1.551724_g24535_i0 | PRJNA293022 | 25272 | 281 | 1.551724 | 4.36034444 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.6 | 3.7e-13 | NR | KAF2071651.1 | 133409 | g24535 | i0 | 40.2 | 1.97508896797153 | 92 | 53 | 98.2 | 1 | 277 | 2 | 79 | 168 | KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum] | diamond | 555 | 71.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 30390582 | 30390582 | PRJNA293022_P_NODE_55593_length_187_cov_1.079710_g54856_i0 | PRJNA293022 | 55593 | 187 | 1.07971 | 2.0190577 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 58.2 | 4.78e-9 | NR | XP_004350852.1 | 261658 | g54856 | i0 | 45.6 | 0.914438502673797 | 57 | 31 | 91.4 | 0 | 185 | 15 | 36 | 92 | XP_004350852.1 40S ribosomal protein S25 [Cavenderia fasciculata] | diamond | 171 | 58.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata |
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);;