contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 622808 | 622808 | PRJNA657343_P_NODE_1561_length_526_cov_2.348008_g1538_i0 | PRJNA657343 | 1561 | 526 | 2.348008 | 12.35052208 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 320 | 1.2799999999999998e-82 | NTclustered | gi|1160561646|ref|XM_020579038.1| | 670386 | g1538 | i0 | 77.883 | 28.9980988593156 | 529 | 107 | 99 | 8 | 3 | 526 | 916 | 1439 | Polysphondylium pallidum PN500 cell division cycle protein 48 (cdcD), partial mRNA | blastn | 15253 | 320 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 3173684 | 3173684 | PRJNA657343_P_NODE_1503_length_534_cov_2.428866_g1480_i0 | PRJNA657343 | 1503 | 534 | 2.428866 | 12.97014444 | Didymium quitense | 2059305 | Evosea | other_Eukaryota | 385 | 4.55e-102 | NTclustered | gi|2329703132|gb|MW239927.1| | 2059305 | g1480 | i0 | 81.585 | 98.8801498127341 | 467 | 84 | 87 | 2 | 68 | 533 | 533 | 68 | Didymium quitense strain MA-Fungi 88326 alpha tubulin (aTUB) gene, partial cds | blastn | 52802 | 385 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium quitense | ||
| 7538310 | 7538310 | PRJNA657343_P_NODE_39086_length_166_cov_0.888889_g39062_i0 | PRJNA657343 | 39086 | 166 | 0.888889 | 1.47555574 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 156 | 1.03e-33 | NTclustered | gi|3186|emb|X07792.1| | 5791 | g39062 | i0 | 91.228 | 69.3795180722892 | 114 | 10 | 69 | 0 | 51 | 164 | 1506 | 1393 | Physarum polycephalum actin gene | blastn | 11517 | 156 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 10827028 | 10827028 | PRJNA657343_P_NODE_10569_length_262_cov_10.474178_g10545_i0 | PRJNA657343 | 10569 | 262 | 10.474178 | 27.44234636 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 215 | 2.88e-51 | NTclustered | gi|161207|gb|M21500.1|SLMACT35 | 5791 | g10545 | i0 | 91.139 | 59.5419847328244 | 158 | 14 | 60 | 0 | 1 | 158 | 1009 | 1166 | P.polycephalum actin (Ppa35) mRNA, complete cds | blastn | 15600 | 215 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 10827096 | 10827096 | PRJNA657343_P_NODE_15649_length_227_cov_2.241573_g15625_i0 | PRJNA657343 | 15649 | 227 | 2.241573 | 5.08837071 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 137 | 5.43e-28 | NTclustered | gi|1160571874|ref|XM_020575431.1| | 670386 | g15625 | i0 | 92.632 | 39.625550660793 | 95 | 7 | 42 | 0 | 118 | 212 | 242 | 148 | Polysphondylium pallidum PN500 S60 ribosomal protein L36a (rpl36a), partial mRNA | blastn | 8995 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 13377321 | 13377321 | PRJNA657343_P_NODE_6271_length_318_cov_5.836431_g6247_i0 | PRJNA657343 | 6271 | 318 | 5.836431 | 18.55985058 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 231 | 3.57e-56 | NTclustered | gi|1160556308|ref|XM_020573979.1| | 670386 | g6247 | i0 | 84.1 | 0.751572327044025 | 239 | 38 | 75 | 0 | 38 | 276 | 620 | 382 | Polysphondylium pallidum PN500 actin bundling protein (abpB), partial mRNA | blastn | 239 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 16463191 | 16463191 | PRJNA657343_P_NODE_27513_length_185_cov_1.117647_g27489_i0 | PRJNA657343 | 27513 | 185 | 1.117647 | 2.06764695 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 7.039999999999999e-31 | NTclustered | gi|330797960|ref|XM_003286977.1| | 5786 | g27489 | i0 | 81.461 | 8.04864864864865 | 178 | 33 | 96 | 0 | 2 | 179 | 413 | 236 | Dictyostelium purpureum ubiquitin (DICPUDRAFT_94309), mRNA | blastn | 1489 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 22300062 | 22300062 | PRJNA657343_P_NODE_13978_length_237_cov_1.569149_g13954_i0 | PRJNA657343 | 13978 | 237 | 1.569149 | 3.71888313 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 135 | 2.0500000000000003e-27 | NTclustered | gi|1160564538|ref|XM_020583061.1| | 670386 | g13954 | i0 | 83.108 | 13.253164556962 | 148 | 25 | 62 | 0 | 6 | 153 | 658 | 511 | Polysphondylium pallidum PN500 DEAD/DEAH box helicase domain-containing protein (ifdA), partial mRNA | blastn | 3141 | 135 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 23575507 | 23575507 | PRJNA657343_P_NODE_16379_length_223_cov_2.781609_g16355_i0 | PRJNA657343 | 16379 | 223 | 2.781609 | 6.20298807 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 152 | 1.9e-32 | NTclustered | gi|1160566122|ref|XM_020580683.1| | 670386 | g16355 | i0 | 82.584 | 6.3677130044843 | 178 | 25 | 78 | 6 | 36 | 210 | 1305 | 1131 | Polysphondylium pallidum PN500 inositol-3-phosphate synthase (ino1), partial mRNA | blastn | 1420 | 152 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 23575908 | 23575908 | PRJNA657343_P_NODE_599_length_702_cov_6.995406_g586_i0 | PRJNA657343 | 599 | 702 | 6.995406 | 49.10775012 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 662 | 0 | NTclustered | gi|1160557950|ref|XM_020575808.1| | 670386 | g586 | i0 | 84.992 | 306.878917378917 | 653 | 96 | 93 | 2 | 49 | 700 | 1332 | 681 | Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA | blastn | 215429 | 662 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 24849566 | 24849566 | PRJNA657343_P_NODE_580_length_710_cov_4.291982_g567_i0 | PRJNA657343 | 580 | 710 | 4.291982 | 30.4730722 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 390 | 1.32e-103 | NTclustered | gi|1160551744|ref|XM_020571206.1| | 670386 | g567 | i0 | 78.037 | 88.9267605633803 | 642 | 125 | 89 | 13 | 12 | 645 | 1465 | 2098 | Polysphondylium pallidum PN500 heat shock protein (hspB), partial mRNA | blastn | 63138 | 390 | 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);;