contig_metadata
12 rows where bioproject = "PRJNA415856" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11898289 | 11898289 | PRJNA415856_P_NODE_52050_length_161_cov_0.910714_g51789_i0 | PRJNA415856 | 52050 | 161 | 0.910714 | 1.46624954 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 67.6 | 4.78e-7 | NTclustered | gi|470251839|ref|XM_004358960.1| | 261658 | g51789 | i0 | 100 | 32.2422360248447 | 36 | 0 | 22 | 0 | 1 | 36 | 540 | 505 | Cavenderia fasciculata uncharacterized protein (DFA_01042), partial mRNA | blastn | 5191 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 19545090 | 19545090 | PRJNA415856_P_NODE_26276_length_181_cov_1.378788_g26015_i0 | PRJNA415856 | 26276 | 181 | 1.378788 | 2.49560628 | root | 1 | Root_unresolved | Root_unresolved | 107 | 7.890000000000001e-26 | NR | XP_004360479.1 | 261658 | g26015 | i0 | 83.3 | 3.97790055248619 | 60 | 10 | 99.4 | 0 | 1 | 180 | 57 | 116 | XP_004360479.1 S-adenosylmethionine synthetase [Cavenderia fasciculata] | diamond | 720 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 23371594 | 23371594 | PRJNA415856_P_NODE_53539_length_161_cov_0.875000_g53278_i0 | PRJNA415856 | 53539 | 161 | 0.875 | 1.40875 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 261 | 2.04e-65 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g53278 | i0 | 99.306 | 16.3416149068323 | 144 | 1 | 89 | 0 | 18 | 161 | 1516 | 1373 | D.iridis LSU rRNA gene | blastn | 2631 | 261 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 25309548 | 25309548 | PRJNA415856_P_NODE_21760_length_189_cov_2.150000_g21499_i0 | PRJNA415856 | 21760 | 189 | 2.15 | 4.0635 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 174 | 3.32e-39 | NTclustered | gi|470240647|ref|XM_004354263.1| | 261658 | g21499 | i0 | 83.511 | 111.878306878307 | 188 | 29 | 99 | 2 | 3 | 189 | 424 | 610 | Cavenderia fasciculata ubiquitin (ubqA), partial mRNA | blastn | 21145 | 174 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 26807455 | 26807455 | PRJNA415856_P_NODE_12101_length_251_cov_2.316832_g11840_i0 | PRJNA415856 | 12101 | 251 | 2.316832 | 5.81524832 | root | 1 | Root_unresolved | Root_unresolved | 92.8 | 5.670000000000001e-22 | NR | 7SOG_A | 5755 | g11840 | i0 | 48.2 | 1.99601593625498 | 83 | 43 | 99.2 | 0 | 249 | 1 | 24 | 106 | 7SOG_A Chain A, Actophorin [Acanthamoeba castellanii] | diamond | 501 | 92.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28654648 | 28654648 | PRJNA415856_P_NODE_34667_length_167_cov_1.728814_g34406_i0 | PRJNA415856 | 34667 | 167 | 1.728814 | 2.88711938 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 112 | 1.42e-27 | NR | PRP88645.1 | 1890364 | g34406 | i0 | 100 | 0.988023952095808 | 55 | 0 | 98.8 | 0 | 165 | 1 | 251 | 305 | PRP88645.1 SEC14-like protein 2-like [Planoprotostelium fungivorum] | diamond | 165 | 112 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29412264 | 29412264 | PRJNA415856_P_NODE_17109_length_210_cov_2.279503_g16848_i0 | PRJNA415856 | 17109 | 210 | 2.279503 | 4.7869563 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 107 | 2.27e-25 | NR | PRP75787.1 | 1890364 | g16848 | i0 | 69.1 | 1.94285714285714 | 68 | 21 | 97.1 | 0 | 208 | 5 | 114 | 181 | PRP75787.1 hypothetical protein PROFUN_08781 [Planoprotostelium fungivorum] | diamond | 408 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30297239 | 30297239 | PRJNA415856_P_NODE_36472_length_167_cov_0.864407_g36211_i0 | PRJNA415856 | 36472 | 167 | 0.864407 | 1.44355969 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 52 | 7.29e-6 | NR | XP_004359670.1 | 261658 | g36211 | i0 | 50.9 | 4.9940119760479 | 55 | 27 | 98.8 | 0 | 3 | 167 | 110 | 164 | XP_004359670.1 frizzled and smoothened-like protein [Cavenderia fasciculata] | diamond | 834 | 52 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30865391 | 30865391 | PRJNA415856_P_NODE_42814_length_164_cov_1.539130_g42553_i0 | PRJNA415856 | 42814 | 164 | 1.53913 | 2.5241732 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 43.9 | 0.00504 | NR | PRP74740.1 | 1890364 | g42553 | i0 | 37.9 | 1.0609756097561 | 58 | 31 | 98.8 | 2 | 1 | 162 | 327 | 383 | PRP74740.1 hypothetical protein PROFUN_15508 [Planoprotostelium fungivorum] | diamond | 174 | 43.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31434342 | 31434342 | PRJNA415856_P_NODE_38876_length_166_cov_0.871795_g38615_i0 | PRJNA415856 | 38876 | 166 | 0.871795 | 1.4471797 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 50.8 | 1.84e-5 | NR | PRP80950.1 | 1890364 | g38615 | i0 | 41.2 | 0.921686746987952 | 51 | 30 | 92.2 | 0 | 162 | 10 | 190 | 240 | PRP80950.1 hypothetical protein PROFUN_11279 [Planoprotostelium fungivorum] | diamond | 153 | 50.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31908896 | 31908896 | PRJNA415856_P_NODE_44117_length_164_cov_0.886957_g43856_i0 | PRJNA415856 | 44117 | 164 | 0.886957 | 1.45460948 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 49.3 | 6.21e-5 | NR | PRP86331.1 | 1890364 | g43856 | i0 | 42.6 | 0.98780487804878 | 54 | 29 | 98.8 | 1 | 162 | 1 | 83 | 134 | PRP86331.1 putative 1,3-beta-glucanosyltransferase [Planoprotostelium fungivorum] | diamond | 162 | 49.3 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32825234 | 32825234 | PRJNA415856_P_NODE_18880_length_201_cov_1.006579_g18619_i0 | PRJNA415856 | 18880 | 201 | 1.006579 | 2.02322379 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 97.1 | 2.58e-22 | NR | XP_020435746.1 | 670386 | g18619 | i0 | 75 | 2.85074626865672 | 64 | 16 | 95.5 | 0 | 194 | 3 | 1 | 64 | XP_020435746.1 ADP/ATP translocase [Heterostelium album PN500] | diamond | 573 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;