contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1808338 | 1808338 | PRJNA556992_P_NODE_764402_length_248_cov_0.880000_g762213_i0 | PRJNA556992 | 764402 | 248 | 0.88 | 2.1824 | Macbrideola oblonga | 410620 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|118577476|gb|DQ903682.1| | 410620 | g762213 | i0 | 96.97 | 0.245967741935484 | 33 | 1 | 13 | 0 | 216 | 248 | 2389 | 2421 | Macbrideola oblonga voucher M. Schnittler small subunit ribosomal RNA gene, partial sequence | blastn | 61 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Macbrideola | Macbrideola oblonga | |||
| 6227976 | 6227976 | PRJNA556992_P_NODE_1042525_length_226_cov_3.019608_g1040335_i0 | PRJNA556992 | 1042525 | 226 | 3.019608 | 6.82431408 | Phalansterium | 136498 | Evosea | other_Eukaryota | 87.9 | 5.51e-13 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g1040335 | i0 | 96.226 | 374.778761061947 | 53 | 2 | 42 | 0 | 1 | 53 | 3611 | 3559 | Phalansterium solitarium 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 84700 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 6231569 | 6231569 | PRJNA556992_P_NODE_895985_length_241_cov_0.916667_g893795_i0 | PRJNA556992 | 895985 | 241 | 0.916667 | 2.20916747 | Stemonitidae | 137615 | Evosea | other_Eukaryota | 446 | 8.519999999999999e-121 | NTclustered | gi|5712220|gb|AF093247.1|AF093247 | 101284 | g893795 | i0 | 100 | 77.2448132780083 | 241 | 0 | 100 | 0 | 1 | 241 | 255 | 495 | Hyperamoeba sp. ATCC50750 small subunit ribosomal RNA gene, complete sequence | blastn | 18616 | 446 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Hyperamoeba | Hyperamoeba sp. ATCC50750 | ||||
| 7504764 | 7504764 | PRJNA556992_P_NODE_550026_length_263_cov_1.610526_g547837_i0 | PRJNA556992 | 550026 | 263 | 1.610526 | 4.23568338 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|66812543|ref|XM_635359.1| | 352472 | g547837 | i0 | 90.476 | 0.269961977186312 | 42 | 2 | 16 | 2 | 29 | 69 | 453 | 493 | Dictyostelium discoideum AX4 WD40 repeat-containing protein (DDB_G0281839) mRNA, complete cds | blastn | 71 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 8177108 | 8177108 | PRJNA556992_P_NODE_136147_length_369_cov_1.402027_g133960_i0 | PRJNA556992 | 136147 | 369 | 1.402027 | 5.17347963 | Entamoeba moshkovskii | 41668 | Evosea | other_Eukaryota | 82.4 | 4.47e-11 | NTclustered | gi|148923319|gb|EF421373.1| | 41668 | g133960 | i0 | 92.857 | 0.151761517615176 | 56 | 4 | 15 | 0 | 228 | 283 | 223 | 278 | Entamoeba moshkovskii strain GAH tRNA array unit GAHNK1 genomic sequence | blastn | 56 | 82.4 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba moshkovskii | |||
| 15829611 | 15829611 | PRJNA556992_P_NODE_296533_length_289_cov_2.495370_g294344_i0 | PRJNA556992 | 296533 | 289 | 2.49537 | 7.2116193 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 198 | 3.25e-46 | NTclustered | gi|66807078|ref|XM_632170.1| | 352472 | g294344 | i0 | 79.298 | 6.44636678200692 | 285 | 57 | 98 | 2 | 6 | 289 | 1144 | 1427 | Dictyostelium discoideum AX4 DEAD/DEAH box helicase (ddx41) mRNA, complete cds | blastn | 1863 | 198 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 18377521 | 18377521 | PRJNA556992_P_NODE_224515_length_314_cov_3.726141_g222327_i0 | PRJNA556992 | 224515 | 314 | 3.726141 | 11.70008274 | Echinostelium bisporum | 1973072 | Evosea | other_Eukaryota | 472 | 1.9e-128 | NTclustered | gi|1465309735|gb|MH809395.1| | 1973072 | g222327 | i0 | 93.949 | 58.031847133758 | 314 | 15 | 99 | 3 | 2 | 314 | 477 | 167 | Echinostelium bisporum isolate Nx14-A1 small subunit ribosomal RNA gene, partial sequence | blastn | 18222 | 472 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium bisporum | ||
| 18378994 | 18378994 | PRJNA556992_P_NODE_322875_length_285_cov_4.400943_g320686_i0 | PRJNA556992 | 322875 | 285 | 4.400943 | 12.54268755 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 97.1 | 1.2e-15 | NTclustered | gi|19172041|gb|AF474342.1| | 44689 | g320686 | i0 | 89.873 | 6.68421052631579 | 79 | 3 | 26 | 5 | 105 | 179 | 8180 | 8103 | Dictyostelium discoideum ABC transporter ABCC.10 (abcC10) gene, complete cds | blastn | 1905 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 20935404 | 20935404 | PRJNA556992_P_NODE_812617_length_245_cov_2.308140_g810427_i0 | PRJNA556992 | 812617 | 245 | 2.30814 | 5.654943 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 67.6 | 7.9e-7 | NTclustered | gi|1160572636|ref|XM_020576496.1| | 670386 | g810427 | i0 | 97.436 | 0.697959183673469 | 39 | 1 | 16 | 0 | 81 | 119 | 1389 | 1427 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 171 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 20937364 | 20937364 | PRJNA556992_P_NODE_970557_length_233_cov_5.143750_g968367_i0 | PRJNA556992 | 970557 | 233 | 5.14375 | 11.9849375 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 176 | 1.19e-39 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g968367 | i0 | 82.547 | 11.1158798283262 | 212 | 26 | 90 | 8 | 1 | 210 | 7228 | 7026 | Mucilago crustacea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 2590 | 176 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 21527950 | 21527950 | PRJNA556992_P_NODE_342737_length_283_cov_1.466667_g340548_i0 | PRJNA556992 | 342737 | 283 | 1.466667 | 4.15066761 | Physarum | 5790 | Evosea | other_Eukaryota | 501 | 2.1599999999999998e-137 | NTclustered | gi|1275019482|gb|MG429806.1| | 2052661 | g340548 | i0 | 98.587 | 93.6996466431095 | 283 | 4 | 100 | 0 | 1 | 283 | 205 | 487 | Physaraceae sp. isolate s40262/1 small subunit ribosomal RNA gene, partial sequence | blastn | 26517 | 501 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physaraceae sp. |
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);;