contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2123390 | 2123390 | PRJNA867519_P_NODE_1322_length_831_cov_2.337731_g1184_i0 | PRJNA867519 | 1322 | 831 | 2.337731 | 19.42654461 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 150 | 2.88e-31 | NTclustered | gi|66826088|ref|XM_641307.1| | 352472 | g1184 | i0 | 83.234 | 0.536702767749699 | 167 | 24 | 26 | 2 | 557 | 720 | 669 | 834 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0269910) mRNA, complete cds | blastn | 446 | 150 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 2123605 | 2123605 | PRJNA867519_P_NODE_9242_length_370_cov_1.488215_g9088_i0 | PRJNA867519 | 9242 | 370 | 1.488215 | 5.5063955 | Flamella aegyptia | 490354 | Evosea | other_Eukaryota | 678 | 0 | NTclustered | gi|163943977|gb|EU186021.1| | 490354 | g9088 | i0 | 99.73 | 92.0108108108108 | 370 | 1 | 100 | 0 | 1 | 370 | 743 | 1112 | Flamella aegyptia 18S ribosomal RNA gene, partial sequence | blastn | 34044 | 678 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Flamella | Flamella aegyptia | |||
| 3398903 | 3398903 | PRJNA867519_P_NODE_28863_length_247_cov_0.885057_g28709_i0 | PRJNA867519 | 28863 | 247 | 0.885057 | 2.18609079 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 63.9 | 1.03e-5 | NTclustered | gi|66803053|ref|XM_630278.1| | 352472 | g28709 | i0 | 90.196 | 0.340080971659919 | 51 | 2 | 21 | 3 | 157 | 207 | 1395 | 1348 | Dictyostelium discoideum AX4 nucleoporin 155 (nup155) mRNA, complete cds | blastn | 84 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 3398994 | 3398994 | PRJNA867519_P_NODE_8843_length_376_cov_1.927393_g8689_i0 | PRJNA867519 | 8843 | 376 | 1.927393 | 7.24699768 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 252 | 3.2899999999999997e-62 | NTclustered | gi|330842214|ref|XM_003293030.1| | 5786 | g8689 | i0 | 80.712 | 35.5585106382979 | 337 | 54 | 88 | 9 | 4 | 335 | 137 | 467 | Dictyostelium purpureum uncharacterized protein (rac1A), mRNA | blastn | 13370 | 252 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 4676480 | 4676480 | PRJNA867519_P_NODE_18104_length_284_cov_1.393365_g17950_i0 | PRJNA867519 | 18104 | 284 | 1.393365 | 3.9571566 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 183 | 8.909999999999997e-42 | NTclustered | gi|831792076|ref|XM_012904471.1| | 1410327 | g17950 | i0 | 85.246 | 1.03169014084507 | 183 | 21 | 63 | 4 | 16 | 195 | 1464 | 1643 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 293 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 5065026 | 5065026 | PRJNA867519_P_NODE_12764_length_325_cov_3.865079_g12610_i0 | PRJNA867519 | 12764 | 325 | 3.865079 | 12.56150675 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 283 | 9.95e-72 | NTclustered | gi|167942|gb|M23751.1|DDIUBIQD | 44689 | g12610 | i0 | 85.821 | 115.018461538462 | 268 | 36 | 82 | 2 | 3 | 269 | 487 | 753 | D.discoideum ubiquitin mRNA, complete cds, clone DCUB18 | blastn | 37381 | 283 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13601823 | 13601823 | PRJNA867519_P_NODE_28791_length_247_cov_0.885057_g28637_i0 | PRJNA867519 | 28791 | 247 | 0.885057 | 2.18609079 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|330795342|ref|XM_003285685.1| | 5786 | g28637 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 54 | 81 | 3483 | 3456 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_76655), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13601841 | 13601841 | PRJNA867519_P_NODE_3151_length_582_cov_3.842829_g3000_i0 | PRJNA867519 | 3151 | 582 | 3.842829 | 22.36526478 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 78.7 | 9.48e-10 | NTclustered | gi|831789132|ref|XM_012903508.1| | 1410327 | g3000 | i0 | 95.833 | 0.0824742268041237 | 48 | 2 | 8 | 0 | 126 | 173 | 764 | 717 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 48 | 78.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 13601925 | 13601925 | PRJNA867519_P_NODE_8871_length_376_cov_1.082508_g8717_i0 | PRJNA867519 | 8871 | 376 | 1.082508 | 4.07023008 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 270 | 9.08e-68 | NTclustered | gi|330805165|ref|XM_003290509.1| | 5786 | g8717 | i0 | 82.736 | 80.3936170212766 | 307 | 49 | 81 | 3 | 2 | 306 | 274 | 578 | Dictyostelium purpureum NADH-ubiquinone oxidoreductase 23 kDa subunit (DICPUDRAFT_89000), partial mRNA | blastn | 30228 | 270 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16150765 | 16150765 | PRJNA867519_P_NODE_25973_length_250_cov_3.457627_g25819_i0 | PRJNA867519 | 25973 | 250 | 3.457627 | 8.6440675 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|111226656|ref|XM_001134571.1| | 352472 | g25819 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 165 | 192 | 1187 | 1160 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0279005) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 16150837 | 16150837 | PRJNA867519_P_NODE_33973_length_240_cov_2.323353_g33819_i0 | PRJNA867519 | 33973 | 240 | 2.323353 | 5.5760472 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 143 | 1.2499999999999998e-29 | NTclustered | gi|330804616|ref|XM_003290241.1| | 5786 | g33819 | i0 | 80.412 | 8.59583333333333 | 194 | 32 | 80 | 6 | 43 | 233 | 2281 | 2471 | Dictyostelium purpureum cobalamin-dependent methionine synthase (DICPUDRAFT_98639), partial mRNA | blastn | 2063 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16539516 | 16539516 | PRJNA867519_P_NODE_15353_length_301_cov_1.679825_g15199_i0 | PRJNA867519 | 15353 | 301 | 1.679825 | 5.05627325 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 340 | 5.339999999999999e-89 | NTclustered | gi|167942|gb|M23751.1|DDIUBIQD | 44689 | g15199 | i0 | 87.931 | 251.611295681063 | 290 | 33 | 100 | 2 | 1 | 289 | 389 | 677 | D.discoideum ubiquitin mRNA, complete cds, clone DCUB18 | blastn | 75735 | 340 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 18699409 | 18699409 | PRJNA867519_P_NODE_18735_length_281_cov_1.480769_g18581_i0 | PRJNA867519 | 18735 | 281 | 1.480769 | 4.16096089 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 222 | 1.87e-53 | NTclustered | gi|470241705|ref|XM_004352376.1| | 261658 | g18581 | i0 | 81.159 | 9.62277580071174 | 276 | 52 | 98 | 0 | 1 | 276 | 276 | 1 | Cavenderia fasciculata Ras-related GTP-binding protein (ragA), partial mRNA | blastn | 2704 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 19974616 | 19974616 | PRJNA867519_P_NODE_14896_length_305_cov_1.659483_g14742_i0 | PRJNA867519 | 14896 | 305 | 1.659483 | 5.06142315 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 71.3 | 7.85e-8 | NTclustered | gi|66807850|ref|XM_632556.1| | 352472 | g14742 | i0 | 92 | 12.4360655737705 | 50 | 4 | 16 | 0 | 73 | 122 | 1632 | 1583 | Dictyostelium discoideum AX4 hypothetical protein (hbx12) mRNA, complete cds | blastn | 3793 | 71.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19974661 | 19974661 | PRJNA867519_P_NODE_21856_length_267_cov_1.587629_g21702_i0 | PRJNA867519 | 21856 | 267 | 1.587629 | 4.23896943 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|470266375|ref|XM_004361681.1| | 261658 | g21702 | i0 | 100 | 0.228464419475655 | 29 | 0 | 11 | 0 | 186 | 214 | 304 | 276 | Cavenderia fasciculata S60 ribosomal protein L24 (rpl24), partial mRNA | blastn | 61 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 22524849 | 22524849 | PRJNA867519_P_NODE_28258_length_248_cov_0.880000_g28104_i0 | PRJNA867519 | 28258 | 248 | 0.88 | 2.1824 | Rostrostelium ellipticum | 361140 | Evosea | other_Eukaryota | 169 | 2.13e-37 | NTclustered | gi|1057487723|gb|KX539422.1| | 361140 | g28104 | i0 | 79.498 | 0.963709677419355 | 239 | 47 | 96 | 2 | 3 | 240 | 525 | 288 | Rostrostelium ellipticum strain AE2 ATP citrate lyase (acly) gene, complete cds | blastn | 239 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Rostrostelium | Rostrostelium ellipticum | ||
| 23800283 | 23800283 | PRJNA867519_P_NODE_18299_length_283_cov_1.466667_g18145_i0 | PRJNA867519 | 18299 | 283 | 1.466667 | 4.15066761 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|66812301|ref|XM_635238.1| | 352472 | g18145 | i0 | 94.286 | 0.123674911660777 | 35 | 2 | 12 | 0 | 4 | 38 | 1968 | 2002 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0282151) mRNA, complete cds | blastn | 35 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 25074265 | 25074265 | PRJNA867519_P_NODE_360_length_1352_cov_63.537138_g279_i0 | PRJNA867519 | 360 | 1352 | 63.537138 | 859.02210576 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 928 | 0 | NTclustered | gi|66813933|ref|XM_636054.1| | 352472 | g279 | i0 | 81.802 | 83.0710059171598 | 1121 | 190 | 82 | 14 | 165 | 1278 | 1131 | 18 | Dictyostelium discoideum AX4 hypothetical protein (act7) mRNA, complete cds | blastn | 112312 | 928 | 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);;