contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3756756 | 3756756 | PRJNA760976_P_NODE_34763_length_286_cov_2.211268_g34442_i0 | PRJNA760976 | 34763 | 286 | 2.211268 | 6.32422648 | Physarum | 5790 | Evosea | other_Eukaryota | 246 | 1.13e-60 | NTclustered | gi|478735555|gb|KC473816.1| | 1158133 | g34442 | i0 | 82.332 | 95.5909090909091 | 283 | 50 | 99 | 0 | 4 | 286 | 124 | 406 | Physarum sp. MVO-2012 isolate LE 255712 elongation factor 1-alpha (tef1) gene, partial cds | blastn | 27339 | 246 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum pseudonotabile | ||
| 5846028 | 5846028 | PRJNA760976_P_NODE_6265_length_540_cov_1.128480_g5949_i0 | PRJNA760976 | 6265 | 540 | 1.12848 | 6.093792 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 610 | 6.98e-170 | NTclustered | gi|167859711|gb|EU273435.1| | 1346289 | g5949 | i0 | 87.037 | 100.874074074074 | 540 | 70 | 100 | 0 | 1 | 540 | 697 | 158 | Telaepolella tubasferens clone 1 actin gene, partial cds | blastn | 54472 | 610 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 6309085 | 6309085 | PRJNA760976_P_NODE_8865_length_471_cov_1.097990_g8546_i0 | PRJNA760976 | 8865 | 471 | 1.09799 | 5.1715329 | Diderma | 289935 | Evosea | other_Eukaryota | 348 | 5.220000000000001e-91 | NTclustered | gi|2785094397|gb|PP178614.1| | 289974 | g8546 | i0 | 83.777 | 77.9044585987261 | 376 | 51 | 79 | 7 | 54 | 424 | 441 | 71 | Diderma radiatum voucher HMJAU M10164-1 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 36693 | 348 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma radiatum | ||
| 7121161 | 7121161 | PRJNA760976_P_NODE_49286_length_248_cov_2.565714_g48965_i0 | PRJNA760976 | 49286 | 248 | 2.565714 | 6.36297072 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|66811303|ref|XM_634268.1| | 352472 | g48965 | i0 | 100 | 1.81451612903226 | 30 | 0 | 12 | 0 | 143 | 172 | 3569 | 3598 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0282851) mRNA, complete cds | blastn | 450 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 9670876 | 9670876 | PRJNA760976_P_NODE_7668_length_498_cov_1.251765_g7349_i0 | PRJNA760976 | 7668 | 498 | 1.251765 | 6.2337897 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 390 | 9.080000000000001e-104 | NTclustered | gi|1160574132|ref|XM_020577244.1| | 670386 | g7349 | i0 | 81.224 | 97.8333333333333 | 490 | 86 | 98 | 6 | 12 | 498 | 987 | 501 | Polysphondylium pallidum PN500 actin (act10), partial mRNA | blastn | 48721 | 390 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 21144893 | 21144893 | PRJNA760976_P_NODE_23577_length_329_cov_1.406250_g23256_i0 | PRJNA760976 | 23577 | 329 | 1.40625 | 4.6265625 | Physarum licheniforme | 2116612 | Evosea | other_Eukaryota | 289 | 2.17e-73 | NTclustered | gi|2049856367|gb|MG963525.1| | 2116612 | g23256 | i0 | 82.675 | 96.9756838905775 | 329 | 53 | 99 | 4 | 3 | 329 | 200 | 526 | Physarum licheniforme strain MA-Fungi 91207 elongation factor 1A (EF1a) gene, partial cds | blastn | 31905 | 289 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum licheniforme | ||
| 24968970 | 24968970 | PRJNA760976_P_NODE_35220_length_285_cov_1.400943_g34899_i0 | PRJNA760976 | 35220 | 285 | 1.400943 | 3.99268755 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 224 | 5.269999999999999e-54 | NTclustered | gi|1160552074|ref|XM_020571371.1| | 670386 | g34899 | i0 | 81.786 | 10.0070175438596 | 280 | 39 | 96 | 11 | 1 | 274 | 5 | 278 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 2852 | 224 | 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);;