contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2128632 | 2128632 | PRJNA876641_P_NODE_5462_length_341_cov_1.611940_g5388_i0 | PRJNA876641 | 5462 | 341 | 1.61194 | 5.4967154 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 359 | 1.7e-94 | NTclustered | gi|156151273|dbj|AB300196.1| | 5791 | g5388 | i0 | 85.673 | 95.9237536656891 | 342 | 47 | 100 | 2 | 1 | 341 | 1282 | 942 | Physarum polycephalum hsp90 mRNA for heat shock protein 90, partial cds | blastn | 32710 | 359 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 3403789 | 3403789 | PRJNA876641_P_NODE_10743_length_278_cov_1.209756_g10669_i0 | PRJNA876641 | 10743 | 278 | 1.209756 | 3.36312168 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 143 | 1.48e-29 | NTclustered | gi|66805324|ref|XM_631303.1| | 352472 | g10669 | i0 | 79.897 | 0.697841726618705 | 194 | 39 | 70 | 0 | 1 | 194 | 1342 | 1535 | Dictyostelium discoideum AX4 methylmalonate-semialdehyde dehydrogenase (mmsdh) mRNA, complete cds | blastn | 194 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 3404094 | 3404094 | PRJNA876641_P_NODE_6423_length_323_cov_1.232000_g6349_i0 | PRJNA876641 | 6423 | 323 | 1.232 | 3.97936 | Entamoeba invadens | 33085 | Evosea | other_Eukaryota | 62.1 | 5.04e-5 | NTclustered | gi|511091352|dbj|AK423018.1| | 33085 | g6349 | i0 | 78.723 | 10.4984520123839 | 94 | 18 | 29 | 2 | 147 | 239 | 857 | 765 | Entamoeba invadens cDNA clone: Xei-008C04, hypothetical protein, complete cds, strain: IP1 | blastn | 3391 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 7231236 | 7231236 | PRJNA876641_P_NODE_1006_length_647_cov_2.620209_g935_i0 | PRJNA876641 | 1006 | 647 | 2.620209 | 16.95275223 | Lamproderma scintillans | 1115720 | Evosea | other_Eukaryota | 603 | 1.4199999999999997e-167 | NTclustered | gi|2306687671|gb|MZ234285.1| | 1115720 | g935 | i0 | 83.614 | 98.6800618238022 | 653 | 95 | 100 | 11 | 1 | 647 | 658 | 12 | Lamproderma scintillans voucher LE284950 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 63846 | 603 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans | ||
| 7616494 | 7616494 | PRJNA876641_P_NODE_3806_length_386_cov_2.552716_g3732_i0 | PRJNA876641 | 3806 | 386 | 2.552716 | 9.85348376 | Physariida | 5789 | Evosea | other_Eukaryota | 459 | 1.86e-124 | NTclustered | gi|161207|gb|M21500.1|SLMACT35 | 5791 | g3732 | i0 | 88.083 | 98.8886010362694 | 386 | 46 | 100 | 0 | 1 | 386 | 932 | 547 | P.polycephalum actin (Ppa35) mRNA, complete cds | blastn | 38171 | 460 | 0.997826086956522 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 9781224 | 9781224 | PRJNA876641_P_NODE_9148_length_287_cov_1.238318_g9074_i0 | PRJNA876641 | 9148 | 287 | 1.238318 | 3.55397266 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 276 | 1.45e-69 | NTclustered | gi|161220|gb|M58521.1|SLMBETA | 5791 | g9074 | i0 | 84.342 | 91.6759581881533 | 281 | 44 | 98 | 0 | 1 | 281 | 420 | 700 | P.polycephalum beta-tubulin-1 (betA) mRNA, 5' end | blastn | 26311 | 276 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 11056743 | 11056743 | PRJNA876641_P_NODE_10189_length_281_cov_1.278846_g10115_i0 | PRJNA876641 | 10189 | 281 | 1.278846 | 3.59355726 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 230 | 1.1199999999999998e-55 | NTclustered | gi|1160553732|ref|XM_020572691.1| | 670386 | g10115 | i0 | 85.845 | 90.6975088967972 | 219 | 28 | 77 | 3 | 20 | 236 | 909 | 692 | Polysphondylium pallidum PN500 elongation factor 1 alpha (efaAI), partial mRNA | blastn | 25486 | 230 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 11056814 | 11056814 | PRJNA876641_P_NODE_14749_length_255_cov_2.175824_g14675_i0 | PRJNA876641 | 14749 | 255 | 2.175824 | 5.5483512 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 187 | 6.089999999999998e-43 | NTclustered | gi|119552593|gb|EF140724.1| | 5791 | g14675 | i0 | 80.237 | 14.2313725490196 | 253 | 47 | 98 | 3 | 1 | 251 | 187 | 438 | Physarum polycephalum 14-3-3-like protein mRNA, complete cds | blastn | 3629 | 187 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 11056818 | 11056818 | PRJNA876641_P_NODE_149_length_1318_cov_6.967871_g95_i1 | PRJNA876641 | 149 | 1318 | 6.967871 | 91.83653978 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 656 | 0 | NTclustered | gi|330792727|ref|XM_003284391.1| | 5786 | g95 | i1 | 77.066 | 43.931714719271604 | 1186 | 243 | 89 | 24 | 2 | 1168 | 178 | 1353 | Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA | blastn | 57902 | 656 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 12332331 | 12332331 | PRJNA876641_P_NODE_230_length_1126_cov_1.975309_g191_i0 | PRJNA876641 | 230 | 1126 | 1.975309 | 22.24197934 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 575 | 5.499999999999998e-159 | NTclustered | gi|831784126|ref|XM_012901914.1| | 1410327 | g191 | i0 | 77.515 | 66.1634103019538 | 1014 | 190 | 88 | 29 | 132 | 1121 | 1290 | 291 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 74500 | 575 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 12718081 | 12718081 | PRJNA876641_P_NODE_6130_length_327_cov_1.834646_g6056_i0 | PRJNA876641 | 6130 | 327 | 1.834646 | 5.99929242 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 241 | 6.11e-59 | NTclustered | gi|290048|gb|L11589.1|DDIRACIB | 44689 | g6056 | i0 | 84.49 | 63.0795107033639 | 245 | 36 | 75 | 2 | 7 | 250 | 248 | 5 | Slime mold Rac1B protein mRNA, complete cds | blastn | 20627 | 243 | 0.991769547325103 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19979730 | 19979730 | PRJNA876641_P_NODE_1136_length_615_cov_1.667897_g1064_i0 | PRJNA876641 | 1136 | 615 | 1.667897 | 10.25756655 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 422 | 4.03e-113 | NTclustered | gi|330801204|ref|XM_003288572.1| | 5786 | g1064 | i0 | 83.226 | 51.9658536585366 | 465 | 73 | 75 | 4 | 1 | 462 | 61 | 523 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA | blastn | 31959 | 422 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 20364769 | 20364769 | PRJNA876641_P_NODE_12436_length_268_cov_1.461538_g12362_i0 | PRJNA876641 | 12436 | 268 | 1.461538 | 3.91692184 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 235 | 2.27e-57 | NTclustered | gi|2274919|emb|AJ000063.1| | 44689 | g12362 | i0 | 85.909 | 18.9141791044776 | 220 | 31 | 82 | 0 | 1 | 220 | 324 | 105 | Dictyostelium discoideum mRNA for ADP-ribosylation factor 1 | blastn | 5069 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 20364796 | 20364796 | PRJNA876641_P_NODE_19436_length_246_cov_0.890173_g19362_i0 | PRJNA876641 | 19436 | 246 | 0.890173 | 2.18982558 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 132 | 2.77e-26 | NTclustered | gi|433874|emb|X75263.1| | 44689 | g19362 | i0 | 87.611 | 14.9471544715447 | 113 | 14 | 46 | 0 | 134 | 246 | 323 | 211 | D.discoideum (AX3) mRNA for heat shock cognate protein (hsc70) | blastn | 3677 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;