contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2968135 | 2968135 | PRJNA407886_P_NODE_41823_length_337_cov_1.742424_g40129_i0 | PRJNA407886 | 41823 | 337 | 1.742424 | 5.87196888 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 222 | 2.29e-53 | NTclustered | gi|1160557950|ref|XM_020575808.1| | 670386 | g40129 | i0 | 89.655 | 61.1008902077151 | 174 | 18 | 52 | 0 | 146 | 319 | 1332 | 1159 | Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA | blastn | 20591 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 2968285 | 2968285 | PRJNA407886_P_NODE_49443_length_306_cov_1.789700_g47749_i0 | PRJNA407886 | 49443 | 306 | 1.7897 | 5.476482 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|66803509|ref|XM_630506.1| | 352472 | g47749 | i0 | 97.059 | 0.111111111111111 | 34 | 0 | 11 | 1 | 146 | 178 | 47 | 14 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0290691) mRNA, complete cds | blastn | 34 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 8071423 | 8071423 | PRJNA407886_P_NODE_78307_length_244_cov_0.900585_g76613_i0 | PRJNA407886 | 78307 | 244 | 0.900585 | 2.1974274 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 62.1 | 3.66e-5 | NTclustered | gi|831771740|ref|XM_012897941.1| | 1410327 | g76613 | i0 | 93.023 | 0.290983606557377 | 43 | 2 | 18 | 1 | 139 | 181 | 36 | 77 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 71 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 9346192 | 9346192 | PRJNA407886_P_NODE_75828_length_246_cov_0.890173_g74134_i0 | PRJNA407886 | 75828 | 246 | 0.890173 | 2.18982558 | Cavenderia medusoides | 361117 | Evosea | other_Eukaryota | 191 | 4.51e-44 | NTclustered | gi|169930320|gb|EU360785.1| | 361117 | g74134 | i0 | 81.328 | 44.4308943089431 | 241 | 40 | 97 | 5 | 2 | 240 | 553 | 790 | Cavenderia medusoides isolate OH592 elongation factor 1 alpha gene, partial cds | blastn | 10930 | 191 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia medusoides | ||
| 10621163 | 10621163 | PRJNA407886_P_NODE_33449_length_388_cov_2.596825_g31755_i0 | PRJNA407886 | 33449 | 388 | 2.596825 | 10.075681 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 235 | 3.43e-57 | NTclustered | gi|330845446|ref|XM_003294549.1| | 5786 | g31755 | i0 | 80.435 | 4.53865979381443 | 322 | 51 | 81 | 8 | 6 | 321 | 223 | 538 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93248), mRNA | blastn | 1761 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16995481 | 16995481 | PRJNA407886_P_NODE_71294_length_250_cov_0.870056_g69600_i0 | PRJNA407886 | 71294 | 250 | 0.870056 | 2.17514 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 143 | 1.31e-29 | NTclustered | gi|831771575|ref|XM_012897889.1| | 1410327 | g69600 | i0 | 77.5 | 59.704 | 240 | 52 | 96 | 2 | 10 | 248 | 401 | 163 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 14926 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 20819540 | 20819540 | PRJNA407886_P_NODE_65577_length_260_cov_1.647059_g63883_i0 | PRJNA407886 | 65577 | 260 | 1.647059 | 4.2823534 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 95.3 | 3.88e-15 | NTclustered | gi|831761070|ref|XM_012894692.1| | 1410327 | g63883 | i0 | 87.654 | 3.4 | 81 | 10 | 31 | 0 | 177 | 257 | 319 | 399 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 884 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;