contig_metadata
12 rows where bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13688492 | 13688492 | PRJNA951412_P_NODE_691_length_549_cov_1.920168_g606_i0 | PRJNA951412 | 691 | 549 | 1.920168 | 10.54172232 | root | 1 | Root_unresolved | Root_unresolved | 302 | 3.0399999999999996e-99 | NR | ADK90072.1 | 438413 | g606 | i0 | 79.6 | 10.9289617486339 | 181 | 37 | 98.9 | 0 | 548 | 6 | 64 | 244 | ADK90072.1 elongation factor 1 alpha, partial [Corallomyxa tenera] | diamond | 6000 | 302 | 1 | Eukaryota | Amoebozoa | Corallomyxa | Corallomyxa tenera | ||||||
| 14962634 | 14962634 | PRJNA951412_P_NODE_2452_length_303_cov_1.660870_g2367_i0 | PRJNA951412 | 2452 | 303 | 1.66087 | 5.0324361 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 233 | 9.39e-57 | NTclustered | gi|167859713|gb|EU273436.1| | 1346289 | g2367 | i0 | 80.667 | 74.7491749174917 | 300 | 58 | 99 | 0 | 4 | 303 | 671 | 372 | Telaepolella tubasferens clone 2 actin gene, partial cds | blastn | 22649 | 233 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 22611812 | 22611812 | PRJNA951412_P_NODE_338_length_844_cov_2.184176_g261_i0 | PRJNA951412 | 338 | 844 | 2.184176 | 18.43444544 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 387 | 2.85e-131 | NR | KYQ94315.1 | 361077 | g261 | i0 | 77.5 | 0.867298578199052 | 244 | 55 | 86.7 | 0 | 733 | 2 | 5 | 248 | KYQ94315.1 S-adenosylmethionine synthetase [Tieghemostelium lacteum] | diamond | 732 | 387 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 27562485 | 27562485 | PRJNA951412_P_NODE_7884_length_242_cov_0.917160_g7799_i0 | PRJNA951412 | 7884 | 242 | 0.91716 | 2.2195272 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 117 | 1.99e-28 | NR | KAH3746252.1 | 1580589 | g7799 | i0 | 67.9 | 1.93388429752066 | 78 | 25 | 96.7 | 0 | 238 | 5 | 449 | 526 | KAH3746252.1 Adaptor protein complex AP-2 alpha subunit [Pelomyxa schiedti] | diamond | 468 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28194017 | 28194017 | PRJNA951412_P_NODE_6106_length_247_cov_0.885057_g6021_i0 | PRJNA951412 | 6106 | 247 | 0.885057 | 2.18609079 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 48.5 | 3.54e-4 | NR | PRP89471.1 | 1890364 | g6021 | i0 | 40.7 | 0.65587044534413 | 54 | 32 | 65.6 | 0 | 211 | 50 | 320 | 373 | PRP89471.1 hypothetical protein PROFUN_01334 [Planoprotostelium fungivorum] | diamond | 162 | 48.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28358504 | 28358504 | PRJNA951412_P_NODE_8106_length_236_cov_2.245399_g8021_i0 | PRJNA951412 | 8106 | 236 | 2.245399 | 5.29914164 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.0446 | NR | XP_643741.1 | 352472 | g8021 | i0 | 48.8 | 1.14406779661017 | 43 | 20 | 54.7 | 1 | 6 | 134 | 118 | 158 | XP_643741.1 hypothetical protein DDB_G0275119 [Dictyostelium discoideum AX4] | diamond | 270 | 42 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 28509993 | 28509993 | PRJNA951412_P_NODE_4407_length_252_cov_0.865922_g4322_i0 | PRJNA951412 | 4407 | 252 | 0.865922 | 2.18212344 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 47.4 | 9.57e-4 | NR | KAH3758330.1 | 1580589 | g4322 | i0 | 41.9 | 2.41666666666667 | 74 | 37 | 86.9 | 3 | 30 | 248 | 73 | 141 | KAH3758330.1 hypothetical protein Pelo_9868 [Pelomyxa schiedti] | diamond | 609 | 47.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28731024 | 28731024 | PRJNA951412_P_NODE_5867_length_247_cov_0.896552_g5782_i0 | PRJNA951412 | 5867 | 247 | 0.896552 | 2.21448344 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 82.4 | 4.26e-16 | NR | XP_004334260.1 | 1257118 | g5782 | i0 | 49.3 | 3.66801619433198 | 73 | 37 | 88.7 | 0 | 2 | 220 | 427 | 499 | XP_004334260.1 protein kinase, putative [Acanthamoeba castellanii str. Neff] | diamond | 906 | 82.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29962462 | 29962462 | PRJNA951412_P_NODE_4231_length_252_cov_0.871508_g4146_i0 | PRJNA951412 | 4231 | 252 | 0.871508 | 2.19620016 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 81.3 | 1.05e-15 | NR | XP_012750578.1 | 1410327 | g4146 | i0 | 46.6 | 3.42857142857143 | 73 | 39 | 86.9 | 0 | 26 | 244 | 402 | 474 | XP_012750578.1 hypothetical protein SAMD00019534_096570 [Acytostelium subglobosum LB1] | diamond | 864 | 81.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 30720611 | 30720611 | PRJNA951412_P_NODE_6934_length_244_cov_1.754386_g6849_i0 | PRJNA951412 | 6934 | 244 | 1.754386 | 4.28070184 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 107 | 6.78e-25 | NR | PRP89409.1 | 1890364 | g6849 | i0 | 65.8 | 1.95491803278689 | 79 | 27 | 97.1 | 0 | 5 | 241 | 201 | 279 | PRP89409.1 hypothetical protein PROFUN_01272 [Planoprotostelium fungivorum] | diamond | 477 | 107 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32048680 | 32048680 | PRJNA951412_P_NODE_1718_length_347_cov_1.901460_g1633_i0 | PRJNA951412 | 1718 | 347 | 1.90146 | 6.5980662 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 127 | 1.23e-33 | NR | XP_003295033.1 | 5786 | g1633 | i0 | 58.6 | 1.7463976945245 | 99 | 40 | 84.7 | 1 | 295 | 2 | 2 | 100 | XP_003295033.1 uncharacterized protein DICPUDRAFT_51857 [Dictyostelium purpureum] | diamond | 606 | 127 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32206937 | 32206937 | PRJNA951412_P_NODE_1558_length_361_cov_1.350694_g1473_i0 | PRJNA951412 | 1558 | 361 | 1.350694 | 4.87600534 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 99.4 | 1.8199999999999994e-23 | NR | KYQ92788.1 | 361077 | g1473 | i0 | 47.1 | 0.864265927977839 | 104 | 44 | 78.1 | 3 | 283 | 2 | 21 | 123 | KYQ92788.1 lysozyme [Tieghemostelium lacteum] | diamond | 312 | 99.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum |
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);;