contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA760904" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2480410 | 2480410 | PRJNA760904_P_NODE_15762_length_249_cov_0.875000_g15705_i0 | PRJNA760904 | 15762 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 217 | 7.55e-52 | NTclustered | gi|1160556590|ref|XM_020574120.1| | 670386 | g15705 | i0 | 87.302 | 65.6626506024096 | 189 | 24 | 76 | 0 | 7 | 195 | 682 | 870 | Polysphondylium pallidum PN500 S-adenosylmethionine synthetase (metK), partial mRNA | blastn | 16350 | 219 | 0.990867579908676 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 4570624 | 4570624 | PRJNA760904_P_NODE_4204_length_409_cov_1.372024_g4147_i0 | PRJNA760904 | 4204 | 409 | 1.372024 | 5.61157816 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 438 | 2.5799999999999998e-118 | NTclustered | gi|330840543|ref|XM_003292226.1| | 5786 | g4147 | i0 | 89.368 | 80.0757946210269 | 348 | 37 | 85 | 0 | 62 | 409 | 30 | 377 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92832), mRNA | blastn | 32751 | 438 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 5845854 | 5845854 | PRJNA760904_P_NODE_8105_length_313_cov_1.283333_g8048_i0 | PRJNA760904 | 8105 | 313 | 1.283333 | 4.01683229 | Diachea leucopodia | 385471 | Evosea | other_Eukaryota | 239 | 2.09e-58 | NTclustered | gi|2805783493|gb|PP796513.1| | 385471 | g8048 | i0 | 81.356 | 95.9488817891374 | 295 | 53 | 94 | 2 | 20 | 313 | 1 | 294 | Diachea leucopodia translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 30032 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Diachea | Diachea leucopodia | ||
| 7582948 | 7582948 | PRJNA760904_P_NODE_14806_length_251_cov_0.865169_g14749_i0 | PRJNA760904 | 14806 | 251 | 0.865169 | 2.17157419 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 215 | 2.74e-51 | NTclustered | gi|5759300|gb|AF176121.1|AF176121 | 44689 | g14749 | i0 | 82.4 | 72.5059760956175 | 250 | 40 | 99 | 3 | 1 | 248 | 402 | 649 | Dictyostelium discoideum protein phosphatase 6 catalytic subunit (pppD) mRNA, complete cds | blastn | 18199 | 215 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 10946399 | 10946399 | PRJNA760904_P_NODE_849_length_813_cov_5.545946_g799_i0 | PRJNA760904 | 849 | 813 | 5.545946 | 45.08854098 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 337 | 2.0099999999999996e-87 | NTclustered | gi|1160575900|ref|XM_020582690.1| | 670386 | g799 | i0 | 78.812 | 40.8683886838868 | 505 | 103 | 62 | 4 | 65 | 567 | 13 | 515 | Polysphondylium pallidum PN500 Rab GTPase (rab7A), partial mRNA | blastn | 33226 | 337 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 17320546 | 17320546 | PRJNA760904_P_NODE_18894_length_244_cov_0.900585_g18837_i0 | PRJNA760904 | 18894 | 244 | 0.900585 | 2.1974274 | Planoprotostelium aurantium | 65008 | Evosea | other_Eukaryota | 329 | 9.08e-86 | NTclustered | gi|2367628|gb|AF016241.1| | 65008 | g18837 | i0 | 91.02 | 96.8032786885246 | 245 | 21 | 100 | 1 | 1 | 244 | 437 | 681 | Planoprotostelium aurantium protein synthesis elongation factor 1-alpha (tef2) gene, partial cds | blastn | 23620 | 329 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium aurantium | ||
| 18593919 | 18593919 | PRJNA760904_P_NODE_16175_length_248_cov_2.697143_g16118_i0 | PRJNA760904 | 16175 | 248 | 2.697143 | 6.68891464 | Planoprotostelium aurantium | 65008 | Evosea | other_Eukaryota | 303 | 5.61e-78 | NTclustered | gi|2367628|gb|AF016241.1| | 65008 | g16118 | i0 | 88.71 | 95.9354838709677 | 248 | 28 | 100 | 0 | 1 | 248 | 142 | 389 | Planoprotostelium aurantium protein synthesis elongation factor 1-alpha (tef2) gene, partial cds | blastn | 23792 | 303 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium aurantium | ||
| 21144844 | 21144844 | PRJNA760904_P_NODE_9037_length_298_cov_1.568889_g8980_i0 | PRJNA760904 | 9037 | 298 | 1.568889 | 4.67528922 | Acramoeba dendroida | 633159 | Evosea | other_Eukaryota | 237 | 7.12e-58 | NTclustered | gi|146448853|gb|EF513194.1| | 633159 | g8980 | i0 | 81.507 | 89.496644295302 | 292 | 50 | 97 | 4 | 7 | 296 | 783 | 1072 | Acramoeba dendroida elongation factor 1A (EF1A) gene, partial cds | blastn | 26670 | 237 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Acramoebidae | Acramoeba | Acramoeba dendroida |
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);;