contig_metadata
9 rows where bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6366804 | 6366804 | PRJNA951388_S_NODE_1745_length_536_cov_27.678186_g1623_i0 | PRJNA951388 | 1745 | 536 | 27.678186 | 148.35507696 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 235 | 1.36e-75 | NR | XP_020430508.1 | 670386 | g1623 | i0 | 68.6 | 4.38246268656716 | 156 | 49 | 87.3 | 0 | 534 | 67 | 38 | 193 | XP_020430508.1 Rho GTPase [Heterostelium album PN500] | diamond | 2349 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 18786501 | 18786501 | PRJNA951388_S_NODE_7055_length_320_cov_3.230769_g6928_i0 | PRJNA951388 | 7055 | 320 | 3.230769 | 10.3384608 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 119 | 2.92e-22 | NTclustered | gi|262262923|gb|FJ766466.1| | 472931 | g6928 | i0 | 79.213 | 48.503125 | 178 | 31 | 55 | 6 | 142 | 318 | 722 | 894 | Protostelium mycophagum strain QE07-15-1 small subunit ribosomal RNA gene, partial sequence | blastn | 15521 | 119 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 27151576 | 27151576 | PRJNA951388_S_NODE_6962_length_322_cov_4.638554_g6835_i0 | PRJNA951388 | 6962 | 322 | 4.638554 | 14.93614388 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 80.1 | 7.03e-15 | NR | XP_004355164.1 | 261658 | g6835 | i0 | 42.3 | 0.968944099378882 | 104 | 56 | 96.9 | 3 | 6 | 317 | 317 | 416 | XP_004355164.1 uncharacterized protein DFA_07668 [Cavenderia fasciculata] | diamond | 312 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 27664189 | 27664189 | PRJNA951388_S_NODE_3584_length_423_cov_5.342857_g3457_i0 | PRJNA951388 | 3584 | 423 | 5.342857 | 22.60028511 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.6 | 2.5e-12 | NR | XP_003291214.1 | 5786 | g3457 | i0 | 37.1 | 5.61702127659574 | 105 | 66 | 74.5 | 0 | 404 | 90 | 191 | 295 | XP_003291214.1 uncharacterized protein DICPUDRAFT_81895 [Dictyostelium purpureum] | diamond | 2376 | 73.9 | 0.995940460081191 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27822074 | 27822074 | PRJNA951388_S_NODE_9784_length_265_cov_1.203125_g9657_i0 | PRJNA951388 | 9784 | 265 | 1.203125 | 3.18828125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 42.7 | 0.0137 | NR | KYQ93011.1 | 361077 | g9657 | i0 | 34.4 | 2.24150943396226 | 64 | 34 | 72.5 | 2 | 66 | 257 | 27 | 82 | KYQ93011.1 autophagy protein 10 [Tieghemostelium lacteum] | diamond | 594 | 43.1 | 0.990719257540603 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 28036432 | 28036432 | PRJNA951388_S_NODE_2525_length_476_cov_11.578164_g2398_i0 | PRJNA951388 | 2525 | 476 | 11.578164 | 55.11206064 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 94 | 6.25e-19 | NR | KAF2069394.1 | 133409 | g2398 | i0 | 45.9 | 0.850840336134454 | 135 | 57 | 82.6 | 6 | 3 | 395 | 672 | 794 | KAF2069394.1 hypothetical protein CYY_009286 [Polysphondylium violaceum] | diamond | 405 | 94 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 30562442 | 30562442 | PRJNA951388_S_NODE_7853_length_302_cov_1.122271_g7726_i0 | PRJNA951388 | 7853 | 302 | 1.122271 | 3.38925842 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 132 | 1.89e-37 | NR | 1PRQ_A | 5755 | g7726 | i0 | 62.6 | 0.983443708609272 | 99 | 37 | 98.3 | 0 | 2 | 298 | 9 | 107 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 297 | 132 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31106280 | 31106280 | PRJNA951388_S_NODE_7315_length_314_cov_6.672199_g7188_i0 | PRJNA951388 | 7315 | 314 | 6.672199 | 20.95070486 | Entamoeba | 5758 | Evosea | other_Eukaryota | 59.7 | 2.95e-8 | NR | 5XCK_A | 5759 | g7188 | i0 | 39.4 | 2.78980891719745 | 66 | 40 | 63.1 | 0 | 293 | 96 | 107 | 172 | 5XCK_A Chain A, Vacuolar protein sorting-associated protein 29 [Entamoeba histolytica] | diamond | 876 | 59.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 31384528 | 31384528 | PRJNA951388_S_NODE_7896_length_301_cov_2.096491_g7769_i0 | PRJNA951388 | 7896 | 301 | 2.096491 | 6.31043791 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 72.4 | 2.62e-12 | NR | PRP79145.1 | 1890364 | g7769 | i0 | 41.5 | 0.93687707641196 | 94 | 52 | 92.7 | 2 | 282 | 4 | 328 | 419 | PRP79145.1 aspartic proteinase-like protein 2 isoform 2 [Planoprotostelium fungivorum] | diamond | 282 | 72.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;