contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1604129 | 1604129 | PRJNA1204310_P_NODE_4262_length_812_cov_2.560217_g4011_i0 | PRJNA1204310 | 4262 | 812 | 2.560217 | 20.78896204 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 514 | 8.66e-141 | NTclustered | gi|831769224|ref|XM_012897186.1| | 1410327 | g4011 | i0 | 79.106 | 49.0504926108374 | 761 | 148 | 93 | 10 | 4 | 757 | 776 | 20 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 39829 | 514 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 6707587 | 6707587 | PRJNA1204310_P_NODE_62826_length_242_cov_0.923077_g62529_i0 | PRJNA1204310 | 62826 | 242 | 0.923077 | 2.23384634 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 195 | 3.42e-45 | NTclustered | gi|470252539|ref|XM_004359310.1| | 261658 | g62529 | i0 | 83.178 | 4.68181818181818 | 214 | 35 | 88 | 1 | 25 | 237 | 312 | 525 | Cavenderia fasciculata ADP-ribosylation factor (arfA), partial mRNA | blastn | 1133 | 195 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 7982591 | 7982591 | PRJNA1204310_P_NODE_32167_length_329_cov_1.218750_g31870_i0 | PRJNA1204310 | 32167 | 329 | 1.21875 | 4.0096875 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 206 | 2.25e-48 | NTclustered | gi|831757058|ref|XM_012893458.1| | 1410327 | g31870 | i0 | 78.261 | 4.60182370820669 | 345 | 58 | 100 | 9 | 1 | 329 | 300 | 643 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 1514 | 206 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10533243 | 10533243 | PRJNA1204310_P_NODE_45329_length_274_cov_1.467662_g45032_i0 | PRJNA1204310 | 45329 | 274 | 1.467662 | 4.02139388 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 159 | 1.4399999999999999e-34 | NTclustered | gi|167388768|ref|XM_001738637.1| | 370354 | g45032 | i0 | 77.737 | 7.63138686131387 | 274 | 52 | 99 | 9 | 1 | 271 | 872 | 1139 | Entamoeba dispar SAW760 26S protease regulatory subunit 6A, putative (EDI_316920), partial mRNA | blastn | 2091 | 159 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 11248428 | 11248428 | PRJNA1204310_P_NODE_6629_length_668_cov_1.586555_g6349_i0 | PRJNA1204310 | 6629 | 668 | 1.586555 | 10.5981874 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 477 | 9.259999999999999e-130 | NTclustered | gi|2329703236|gb|MW239988.1| | 218861 | g6349 | i0 | 80.625 | 96.2769461077844 | 640 | 104 | 94 | 17 | 23 | 652 | 631 | 2 | Physarum didermoides strain MA-Fungi 57262 alpha tubulin (aTUB) gene, partial cds | blastn | 64313 | 477 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum didermoides | ||
| 11808325 | 11808325 | PRJNA1204310_P_NODE_58990_length_245_cov_1.808140_g58693_i0 | PRJNA1204310 | 58990 | 245 | 1.80814 | 4.429943 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 165 | 2.72e-36 | NTclustered | gi|330822609|ref|XM_003291694.1| | 5786 | g58693 | i0 | 79.913 | 7.19183673469388 | 229 | 43 | 93 | 3 | 1 | 228 | 380 | 154 | Dictyostelium purpureum uncharacterized protein (rasG), mRNA | blastn | 1762 | 165 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13082382 | 13082382 | PRJNA1204310_P_NODE_18571_length_417_cov_1.401163_g18274_i0 | PRJNA1204310 | 18571 | 417 | 1.401163 | 5.84284971 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 52.8 | 0.04 | NTclustered | gi|1160557250|ref|XM_020574450.1| | 670386 | g18274 | i0 | 100 | 0.0671462829736211 | 28 | 0 | 7 | 0 | 214 | 241 | 1377 | 1350 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 13083230 | 13083230 | PRJNA1204310_P_NODE_52851_length_251_cov_0.876404_g52554_i0 | PRJNA1204310 | 52851 | 251 | 0.876404 | 2.19977404 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 169 | 2.1599999999999996e-37 | NTclustered | gi|831782418|ref|XM_012901225.1| | 1410327 | g52554 | i0 | 80.444 | 4.70119521912351 | 225 | 40 | 89 | 4 | 29 | 251 | 618 | 396 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 1180 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 15632004 | 15632004 | PRJNA1204310_P_NODE_33633_length_322_cov_1.240964_g33336_i0 | PRJNA1204310 | 33633 | 322 | 1.240964 | 3.99590408 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 67.6 | 1.08e-6 | NTclustered | gi|66826678|ref|XM_641602.1| | 352472 | g33336 | i0 | 100 | 6.14906832298137 | 36 | 0 | 11 | 0 | 271 | 306 | 763 | 728 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0270310) mRNA, complete cds | blastn | 1980 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 16906210 | 16906210 | PRJNA1204310_P_NODE_30634_length_336_cov_2.178707_g30337_i0 | PRJNA1204310 | 30634 | 336 | 2.178707 | 7.32045552 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 206 | 2.3e-48 | NTclustered | gi|167393850|ref|XM_001740688.1| | 370354 | g30337 | i0 | 79.016 | 19.1011904761905 | 305 | 60 | 90 | 4 | 34 | 336 | 1598 | 1296 | Entamoeba dispar SAW760 cation-transporting ATPase, putative (EDI_082290), partial mRNA | blastn | 6418 | 206 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 16906976 | 16906976 | PRJNA1204310_P_NODE_7194_length_644_cov_1.775832_g6910_i0 | PRJNA1204310 | 7194 | 644 | 1.775832 | 11.43635808 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 339 | 4.39e-88 | NTclustered | gi|330844711|ref|XM_003294212.1| | 5786 | g6910 | i0 | 77.738 | 10.7173913043478 | 557 | 120 | 86 | 4 | 83 | 637 | 61 | 615 | Dictyostelium purpureum succinyl coenzyme A synthetase alpha subunit (DICPUDRAFT_159229), partial mRNA | blastn | 6902 | 339 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18180794 | 18180794 | PRJNA1204310_P_NODE_35855_length_312_cov_0.916318_g35558_i0 | PRJNA1204310 | 35855 | 312 | 0.916318 | 2.85891216 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 237 | 7.5e-58 | NTclustered | gi|330803517|ref|XM_003289704.1| | 5786 | g35558 | i0 | 87.081 | 66.875 | 209 | 27 | 67 | 0 | 63 | 271 | 4 | 212 | Dictyostelium purpureum rac1B, RHO family GTPase (rac1B), partial mRNA | blastn | 20865 | 237 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 19454892 | 19454892 | PRJNA1204310_P_NODE_18656_length_416_cov_2.262391_g18359_i0 | PRJNA1204310 | 18656 | 416 | 2.262391 | 9.41154656 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 303 | 1e-77 | NTclustered | gi|831772403|ref|XM_012898140.1| | 1410327 | g18359 | i0 | 81.768 | 71.71875 | 362 | 66 | 87 | 0 | 8 | 369 | 1 | 362 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 29835 | 303 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 19455444 | 19455444 | PRJNA1204310_P_NODE_43096_length_282_cov_1.803828_g42799_i0 | PRJNA1204310 | 43096 | 282 | 1.803828 | 5.08679496 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 169 | 2.48e-37 | NTclustered | gi|831768659|ref|XM_012897017.1| | 1410327 | g42799 | i0 | 86.076 | 1.65248226950355 | 158 | 20 | 56 | 2 | 126 | 282 | 819 | 663 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 466 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 22005504 | 22005504 | PRJNA1204310_P_NODE_15358_length_454_cov_1.246719_g15061_i0 | PRJNA1204310 | 15358 | 454 | 1.246719 | 5.66010426 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 52.8 | 0.044 | NTclustered | gi|470250106|ref|XM_004367228.1| | 261658 | g15061 | i0 | 100 | 0.0616740088105727 | 28 | 0 | 6 | 0 | 381 | 408 | 1219 | 1192 | Cavenderia fasciculata MAP kinase phosphatase (mkpA), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 22721811 | 22721811 | PRJNA1204310_P_NODE_1278_length_1305_cov_33.933442_g1142_i0 | PRJNA1204310 | 1278 | 1305 | 33.933442 | 442.8314181 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 856 | 0 | NTclustered | gi|511083902|dbj|AK419160.1| | 5759 | g1142 | i0 | 80.694 | 84.1808429118774 | 1124 | 197 | 85 | 18 | 69 | 1182 | 29 | 1142 | Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS | blastn | 109856 | 863 | 0.99188876013905 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 22721815 | 22721815 | PRJNA1204310_P_NODE_13238_length_485_cov_2.563107_g12941_i0 | PRJNA1204310 | 13238 | 485 | 2.563107 | 12.43106895 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 207 | 9.53e-49 | NTclustered | gi|167940|gb|M23750.1|DDIUBIQC | 44689 | g12941 | i0 | 82.969 | 55.7835051546392 | 229 | 39 | 47 | 0 | 257 | 485 | 229 | 1 | D.discoideum ubiquitin mRNA, complete cds, clone DCUBV20 | blastn | 27055 | 207 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 24555332 | 24555332 | PRJNA1204310_P_NODE_37100_length_306_cov_1.206009_g36803_i0 | PRJNA1204310 | 37100 | 306 | 1.206009 | 3.69038754 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 222 | 2.06e-53 | NTclustered | gi|119552593|gb|EF140724.1| | 5791 | g36803 | i0 | 86.275 | 64.3366013071895 | 204 | 28 | 67 | 0 | 35 | 238 | 342 | 139 | Physarum polycephalum 14-3-3-like protein mRNA, complete cds | blastn | 19687 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum |
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);;