contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2922506 | 2922506 | PRJNA285816_S_NODE_10163_length_229_cov_2.544444_g10061_i0 | PRJNA285816 | 10163 | 229 | 2.544444 | 5.8267767600000004 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 76.8 | 1.21e-9 | NTclustered | gi|1160570404|ref|XM_020574696.1| | 670386 | g10061 | i0 | 84.416 | 0.336244541484716 | 77 | 12 | 34 | 0 | 151 | 227 | 1727 | 1651 | Polysphondylium pallidum PN500 Physaropepsin partial mRNA | blastn | 77 | 76.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 2922534 | 2922534 | PRJNA285816_S_NODE_11903_length_217_cov_0.910714_g11801_i0 | PRJNA285816 | 11903 | 217 | 0.910714 | 1.97624938 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 159 | 1.1e-34 | NTclustered | gi|470247450|ref|XM_004357397.1| | 261658 | g11801 | i0 | 80.282 | 5.48387096774194 | 213 | 40 | 98 | 2 | 6 | 217 | 470 | 681 | Cavenderia fasciculata propionyl-CoA carboxylase (pccB), partial mRNA | blastn | 1190 | 159 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 2922733 | 2922733 | PRJNA285816_S_NODE_27083_length_165_cov_0.896552_g26981_i0 | PRJNA285816 | 27083 | 165 | 0.896552 | 1.4793108 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 113 | 6.240000000000001e-21 | NTclustered | gi|831754058|ref|XM_012892546.1| | 1410327 | g26981 | i0 | 89.011 | 5.2 | 91 | 10 | 55 | 0 | 72 | 162 | 672 | 582 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 858 | 113 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 5475279 | 5475279 | PRJNA285816_S_NODE_1185_length_600_cov_11.900181_g1094_i0 | PRJNA285816 | 1185 | 600 | 11.900181 | 71.401086 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 390 | 1.11e-103 | NTclustered | gi|831754130|ref|XM_012892568.1| | 1410327 | g1094 | i0 | 81.996 | 54.5133333333333 | 461 | 81 | 77 | 2 | 41 | 500 | 51 | 510 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 32708 | 390 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 6749861 | 6749861 | PRJNA285816_S_NODE_7806_length_254_cov_19.443902_g7704_i0 | PRJNA285816 | 7806 | 254 | 19.443902 | 49.38751108 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 259 | 1.27e-64 | NTclustered | gi|470266101|ref|XM_004361626.1| | 261658 | g7704 | i0 | 86.441 | 91.6889763779528 | 236 | 32 | 93 | 0 | 1 | 236 | 740 | 975 | Cavenderia fasciculata uncharacterized protein (DFA_05968), partial mRNA | blastn | 23289 | 259 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 9300174 | 9300174 | PRJNA285816_S_NODE_29808_length_160_cov_13.576577_g29706_i0 | PRJNA285816 | 29808 | 160 | 13.576577 | 21.7225232 | Lycogala epidendrum | 300236 | Evosea | other_Eukaryota | 237 | 3.4100000000000004e-58 | NTclustered | gi|426281756|gb|JX681131.1| | 300236 | g29706 | i0 | 93.711 | 98.59375 | 159 | 8 | 99 | 2 | 3 | 160 | 331 | 174 | Lycogala epidendrum actin gene, partial cds | blastn | 15775 | 237 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Liceales | Enteridiidae | Lycogala | Lycogala epidendrum | ||
| 11850775 | 11850775 | PRJNA285816_S_NODE_5530_length_294_cov_1.253061_g5428_i0 | PRJNA285816 | 5530 | 294 | 1.253061 | 3.68399934 | Arcyria incarnata | 1165849 | Evosea | other_Eukaryota | 231 | 3.26e-56 | NTclustered | gi|2698738400|gb|PP491466.1| | 1165849 | g5428 | i0 | 94.079 | 1.58843537414966 | 152 | 9 | 52 | 0 | 63 | 214 | 3551 | 3702 | Arcyria incarnata voucher TUF132339 internal transcribed spacer region, partial sequence | blastn | 467 | 231 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria incarnata | ||
| 13812523 | 13812523 | PRJNA285816_S_NODE_2291_length_439_cov_1.971795_g2189_i0 | PRJNA285816 | 2291 | 439 | 1.971795 | 8.65618005 | Viridiplantae | 33090 | Evosea | other_Eukaryota | 298 | 4.94e-76 | NTclustered | gi|2329703186|gb|MW239958.1| | 289991 | g2189 | i0 | 79.499 | 83.3986332574032 | 439 | 72 | 98 | 15 | 10 | 439 | 785 | 356 | Lepidoderma tigrinum strain MA-Fungi 52983 alpha tubulin (aTUB) gene, partial cds | blastn | 36612 | 298 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma tigrinum | ||
| 14400950 | 14400950 | PRJNA285816_S_NODE_19272_length_183_cov_1.111940_g19170_i0 | PRJNA285816 | 19272 | 183 | 1.11194 | 2.0348502 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 91.6 | 3.3e-14 | NTclustered | gi|831773947|ref|XM_012898609.1| | 1410327 | g19170 | i0 | 83.333 | 0.557377049180328 | 102 | 13 | 55 | 4 | 82 | 181 | 1636 | 1537 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 102 | 91.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 14401147 | 14401147 | PRJNA285816_S_NODE_8052_length_251_cov_5.183168_g7950_i0 | PRJNA285816 | 8052 | 251 | 5.183168 | 13.00975168 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 58.4 | 4.89e-4 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g7950 | i0 | 100 | 0.243027888446215 | 31 | 0 | 12 | 0 | 100 | 130 | 4772 | 4802 | 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 | 61 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 20185178 | 20185178 | PRJNA285816_S_NODE_2096_length_458_cov_14.870416_g1994_i0 | PRJNA285816 | 2096 | 458 | 14.870416 | 68.10650528 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 436 | 1.05e-117 | NTclustered | gi|2306687673|gb|MZ234286.1| | 1115720 | g1994 | i0 | 84.245 | 66.0087336244542 | 457 | 62 | 99 | 8 | 1 | 452 | 452 | 1 | Lamproderma scintillans voucher LE297459 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 30232 | 436 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans | ||
| 20773624 | 20773624 | PRJNA285816_S_NODE_517_length_846_cov_6.922208_g463_i0 | PRJNA285816 | 517 | 846 | 6.922208 | 58.56187968 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 387 | 2.06e-102 | NTclustered | gi|831769071|ref|XM_012897140.1| | 1410327 | g463 | i0 | 79.889 | 19.3238770685579 | 542 | 97 | 63 | 11 | 34 | 569 | 1 | 536 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 16348 | 387 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 22048355 | 22048355 | PRJNA285816_S_NODE_11938_length_216_cov_2.371257_g11836_i0 | PRJNA285816 | 11938 | 216 | 2.371257 | 5.12191512 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 163 | 8.44e-36 | NTclustered | gi|831754377|ref|XM_012892643.1| | 1410327 | g11836 | i0 | 81.463 | 6.06944444444444 | 205 | 33 | 94 | 4 | 14 | 216 | 1092 | 891 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 1311 | 163 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 23323928 | 23323928 | PRJNA285816_S_NODE_13679_length_206_cov_3.611465_g13577_i0 | PRJNA285816 | 13679 | 206 | 3.611465 | 7.4396179 | Cavenderia deminutiva | 361123 | Evosea | other_Eukaryota | 169 | 1.71e-37 | NTclustered | gi|1057487894|gb|KX539507.1| | 361123 | g13577 | i0 | 81.463 | 2.34466019417476 | 205 | 38 | 99 | 0 | 1 | 205 | 620 | 824 | Cavenderia deminutiva strain MexM19A succinate dehydrogenase (sdhA) gene, complete cds | blastn | 483 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia deminutiva | ||
| 23323988 | 23323988 | PRJNA285816_S_NODE_18259_length_186_cov_1.890511_g18157_i0 | PRJNA285816 | 18259 | 186 | 1.890511 | 3.51635046 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 60.2 | 9.5e-5 | NTclustered | gi|831777556|ref|XM_012899688.1| | 1410327 | g18157 | i0 | 97.143 | 0.188172043010753 | 35 | 1 | 19 | 0 | 117 | 151 | 402 | 368 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 24598218 | 24598218 | PRJNA285816_S_NODE_29080_length_162_cov_1.805310_g28978_i0 | PRJNA285816 | 29080 | 162 | 1.80531 | 2.9246022 | Synstelium polycarpum | 361085 | Evosea | other_Eukaryota | 80.5 | 6.18e-11 | NTclustered | gi|1057487789|gb|KX539455.1| | 361085 | g28978 | i0 | 94.231 | 0.320987654320988 | 52 | 3 | 32 | 0 | 93 | 144 | 1901 | 1850 | Dictyostelium polycarpum strain OhioWILDS phosphoenolpyruvate carboxykinase (gtp) gene, complete cds | blastn | 52 | 80.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Synstelium | Synstelium polycarpum |
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);;