contig_metadata
13 rows where bioproject = "PRJNA1068513" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181969 | 181969 | PRJNA1068513_S_NODE_6301_length_364_cov_2.175258_g6255_i0 | PRJNA1068513 | 6301 | 364 | 2.175258 | 7.91793912 | Angulamoeba sp. F2 | 1654984 | Evosea | other_Eukaryota | 608 | 1.629999999999999e-169 | NTclustered | gi|821394116|gb|KP864085.1| | 1654984 | g6255 | i0 | 96.97 | 73.3736263736264 | 363 | 10 | 99 | 1 | 2 | 364 | 162 | 523 | Angulamoeba sp. F2 small subunit ribosomal RNA gene, partial sequence | blastn | 26708 | 608 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Angulamoeba | Angulamoeba sp. F2 | ||||
| 1456480 | 1456480 | PRJNA1068513_S_NODE_11002_length_268_cov_1.287179_g10956_i0 | PRJNA1068513 | 11002 | 268 | 1.287179 | 3.44963972 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|831775930|ref|XM_012899194.1| | 1410327 | g10956 | i0 | 100 | 0.111940298507463 | 30 | 0 | 11 | 0 | 154 | 183 | 1476 | 1505 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 3564167 | 3564167 | PRJNA1068513_S_NODE_8683_length_307_cov_2.064103_g8637_i0 | PRJNA1068513 | 8683 | 307 | 2.064103 | 6.33679621 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 102 | 1.17e-22 | NR | KAF2078693.1 | 133409 | g8637 | i0 | 69.7 | 1.28990228013029 | 66 | 20 | 64.5 | 0 | 288 | 91 | 575 | 640 | KAF2078693.1 hypothetical protein CYY_000064 [Polysphondylium violaceum] | diamond | 396 | 103 | 0.990291262135922 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 13766948 | 13766948 | PRJNA1068513_S_NODE_8911_length_303_cov_1.860870_g8865_i0 | PRJNA1068513 | 8911 | 303 | 1.86087 | 5.6384361 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|470253207|ref|XM_004359645.1| | 261658 | g8865 | i0 | 100 | 0.277227722772277 | 28 | 0 | 9 | 0 | 260 | 287 | 891 | 918 | Cavenderia fasciculata uncharacterized protein (DFA_01737), partial mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 26805683 | 26805683 | PRJNA1068513_S_NODE_6961_length_346_cov_1.542125_g6915_i0 | PRJNA1068513 | 6961 | 346 | 1.542125 | 5.3357525 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 96.3 | 1.52e-21 | NR | XP_003284923.1 | 5786 | g6915 | i0 | 42 | 13.4739884393064 | 112 | 65 | 97.1 | 0 | 7 | 342 | 65 | 176 | XP_003284923.1 uncharacterized protein DICPUDRAFT_148738 [Dictyostelium purpureum] | diamond | 4662 | 96.7 | 0.995863495346432 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 26972307 | 26972307 | PRJNA1068513_S_NODE_7782_length_326_cov_1.308300_g7736_i0 | PRJNA1068513 | 7782 | 326 | 1.3083 | 4.265058 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 53.5 | 8.47e-6 | NR | XP_020432752.1 | 670386 | g7736 | i0 | 29.3 | 0.754601226993865 | 82 | 58 | 75.5 | 0 | 282 | 37 | 67 | 148 | XP_020432752.1 hypothetical protein PPL_06215 [Heterostelium album PN500] | diamond | 246 | 53.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 27035692 | 27035692 | PRJNA1068513_S_NODE_9762_length_287_cov_1.948598_g9716_i0 | PRJNA1068513 | 9762 | 287 | 1.948598 | 5.59247626 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 57 | 5.8e-7 | NR | XP_012755435.1 | 1410327 | g9716 | i0 | 53.5 | 0.449477351916376 | 43 | 20 | 44.9 | 0 | 282 | 154 | 359 | 401 | XP_012755435.1 hypothetical protein SAMD00019534_044910, partial [Acytostelium subglobosum LB1] | diamond | 129 | 57 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 27067229 | 27067229 | PRJNA1068513_S_NODE_5142_length_400_cov_4.226300_g5097_i0 | PRJNA1068513 | 5142 | 400 | 4.2263 | 16.9052 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 75.9 | 4.65e-13 | NR | XP_012755435.1 | 1410327 | g5097 | i0 | 51.6 | 2.505 | 64 | 31 | 48 | 0 | 382 | 191 | 338 | 401 | XP_012755435.1 hypothetical protein SAMD00019534_044910, partial [Acytostelium subglobosum LB1] | diamond | 1002 | 75.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 27193600 | 27193600 | PRJNA1068513_S_NODE_12242_length_251_cov_1.786517_g12196_i0 | PRJNA1068513 | 12242 | 251 | 1.786517 | 4.48415767 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 67.4 | 5.1e-11 | NR | PRP80682.1 | 1890364 | g12196 | i0 | 46.2 | 0.776892430278884 | 65 | 35 | 77.7 | 0 | 2 | 196 | 220 | 284 | PRP80682.1 RNA polymerase II core subunit [Planoprotostelium fungivorum] | diamond | 195 | 67.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27636103 | 27636103 | PRJNA1068513_S_NODE_3964_length_449_cov_3.154255_g3919_i0 | PRJNA1068513 | 3964 | 449 | 3.154255 | 14.16260495 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 74.7 | 2.83e-13 | NR | KAF2074283.1 | 133409 | g3919 | i0 | 46.4 | 2.26503340757238 | 84 | 43 | 55.5 | 2 | 65 | 313 | 117 | 199 | KAF2074283.1 hypothetical protein CYY_004416 [Polysphondylium violaceum] | diamond | 1017 | 74.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 28235614 | 28235614 | PRJNA1068513_S_NODE_9626_length_289_cov_4.731481_g9580_i0 | PRJNA1068513 | 9626 | 289 | 4.731481 | 13.67398009 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 67.4 | 1.32e-10 | NR | XP_004337146.1 | 1257118 | g9580 | i0 | 44 | 3.31141868512111 | 75 | 37 | 77.9 | 1 | 272 | 48 | 449 | 518 | XP_004337146.1 EF hand domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 957 | 67.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28930582 | 28930582 | PRJNA1068513_S_NODE_5028_length_404_cov_2.181269_g4983_i0 | PRJNA1068513 | 5028 | 404 | 2.181269 | 8.81232676 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 70.5 | 6.2e-13 | NR | KYQ92041.1 | 361077 | g4983 | i0 | 36 | 0.660891089108911 | 89 | 54 | 66.1 | 1 | 313 | 47 | 5 | 90 | KYQ92041.1 cytoplasmic dynein light chain [Tieghemostelium lacteum] | diamond | 267 | 70.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 30509641 | 30509641 | PRJNA1068513_S_NODE_7793_length_325_cov_4.392857_g7747_i0 | PRJNA1068513 | 7793 | 325 | 4.392857 | 14.27678525 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 89 | 5.56e-18 | NR | XP_004259455.1 | 370355 | g7747 | i0 | 55.8 | 0.710769230769231 | 77 | 34 | 71.1 | 0 | 1 | 231 | 456 | 532 | XP_004259455.1 T-complex protein 1 subunit epsilon, putative [Entamoeba invadens IP1] | diamond | 231 | 89 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens |
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);;