contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA489308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 450451 | 450451 | PRJNA489308_P_NODE_9681_length_360_cov_3.846690_g9605_i0 | PRJNA489308 | 9681 | 360 | 3.84669 | 13.848084 | Entamoeba nuttalli | 412467 | Evosea | other_Eukaryota | 196 | 1.49e-45 | NTclustered | gi|672810997|ref|XM_008862315.1| | 1076696 | g9605 | i0 | 80.228 | 5.66111111111111 | 263 | 50 | 73 | 2 | 23 | 284 | 7 | 268 | Entamoeba nuttalli P19 ribosomal S17 protein partial mRNA | blastn | 2038 | 196 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba nuttalli | |||
| 1724895 | 1724895 | PRJNA489308_P_NODE_25042_length_268_cov_1.312821_g24966_i0 | PRJNA489308 | 25042 | 268 | 1.312821 | 3.51836028 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 147 | 1.09e-30 | NTclustered | gi|1160570380|ref|XM_020574684.1| | 670386 | g24966 | i0 | 82.53 | 5.35820895522388 | 166 | 29 | 62 | 0 | 43 | 208 | 487 | 322 | Polysphondylium pallidum PN500 vacuolar ATPase proteolipid subunit (vatP), partial mRNA | blastn | 1436 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 3000907 | 3000907 | PRJNA489308_P_NODE_2203_length_650_cov_2.620451_g2128_i0 | PRJNA489308 | 2203 | 650 | 2.620451 | 17.0329315 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 60.2 | 3.86e-4 | NTclustered | gi|268637935|ref|XM_635412.3| | 352472 | g2128 | i0 | 94.737 | 0.553846153846154 | 38 | 2 | 6 | 0 | 291 | 328 | 4595 | 4632 | Dictyostelium discoideum AX4 protein kinase, Atypical group (tra1) mRNA, complete cds | blastn | 360 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4277167 | 4277167 | PRJNA489308_P_NODE_16304_length_305_cov_1.961207_g16228_i0 | PRJNA489308 | 16304 | 305 | 1.961207 | 5.98168135 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 220 | 7.37e-53 | NTclustered | gi|330822624|ref|XM_003291701.1| | 5786 | g16228 | i0 | 82.353 | 23.1213114754098 | 255 | 43 | 83 | 2 | 30 | 283 | 424 | 677 | Dictyostelium purpureum vacuolar H+ ATPase B subunit (DICPUDRAFT_50012), mRNA | blastn | 7052 | 220 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8103413 | 8103413 | PRJNA489308_P_NODE_39867_length_234_cov_2.695652_g39791_i0 | PRJNA489308 | 39867 | 234 | 2.695652 | 6.30782568 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 62.1 | 3.48e-5 | NTclustered | gi|66827540|ref|XM_642033.1| | 352472 | g39791 | i0 | 95 | 2.94444444444444 | 40 | 0 | 17 | 2 | 55 | 93 | 373 | 335 | Dictyostelium discoideum AX4 SNF2-related domain-containing protein (DDB_G0267556) mRNA, complete cds | blastn | 689 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 10653972 | 10653972 | PRJNA489308_P_NODE_40689_length_227_cov_3.766234_g40613_i0 | PRJNA489308 | 40689 | 227 | 3.766234 | 8.54935118 | Entamoeba nuttalli | 412467 | Evosea | other_Eukaryota | 132 | 2.52e-26 | NTclustered | gi|672810997|ref|XM_008862315.1| | 1076696 | g40613 | i0 | 78.325 | 0.894273127753304 | 203 | 44 | 89 | 0 | 6 | 208 | 209 | 7 | Entamoeba nuttalli P19 ribosomal S17 protein partial mRNA | blastn | 203 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba nuttalli | |||
| 11928823 | 11928823 | PRJNA489308_P_NODE_2370_length_632_cov_1.865832_g2295_i0 | PRJNA489308 | 2370 | 632 | 1.865832 | 11.79205824 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 67.6 | 2.24e-6 | NTclustered | gi|831787218|ref|XM_012902905.1| | 1410327 | g2295 | i0 | 100 | 0.973101265822785 | 36 | 0 | 6 | 0 | 595 | 630 | 587 | 622 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 615 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 12577094 | 12577094 | PRJNA489308_P_NODE_3950_length_513_cov_8.052273_g3874_i0 | PRJNA489308 | 3950 | 513 | 8.052273 | 41.30816049 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 586 | 1.1099999999999997e-162 | NTclustered | gi|167394534|ref|XM_001740954.1| | 370354 | g3874 | i0 | 87.403 | 100.352826510721 | 516 | 57 | 99 | 5 | 1 | 512 | 524 | 13 | Entamoeba dispar SAW760 actin, putative (EDI_043510), partial mRNA | blastn | 51481 | 588 | 0.996598639455782 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 13204060 | 13204060 | PRJNA489308_P_NODE_9831_length_358_cov_2.435088_g9755_i0 | PRJNA489308 | 9831 | 358 | 2.435088 | 8.71761504 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 193 | 1.91e-44 | NTclustered | gi|831757457|ref|XM_012893582.1| | 1410327 | g9755 | i0 | 84.817 | 15.4106145251397 | 191 | 29 | 53 | 0 | 146 | 336 | 861 | 671 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 5517 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 14478621 | 14478621 | PRJNA489308_P_NODE_10452_length_351_cov_1.665468_g10376_i0 | PRJNA489308 | 10452 | 351 | 1.665468 | 5.84579268 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 331 | 3.8e-86 | NTclustered | gi|66815356|ref|XM_636603.1| | 352472 | g10376 | i0 | 87.075 | 73.1680911680912 | 294 | 36 | 83 | 2 | 1 | 293 | 314 | 22 | Dictyostelium discoideum AX4 hypothetical protein (calA) mRNA, complete cds | blastn | 25682 | 331 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14478650 | 14478650 | PRJNA489308_P_NODE_14052_length_320_cov_1.190283_g13976_i0 | PRJNA489308 | 14052 | 320 | 1.190283 | 3.8089056 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 183 | 1.02e-41 | NTclustered | gi|1160563236|ref|XM_020579833.1| | 670386 | g13976 | i0 | 80.932 | 23.44375 | 236 | 41 | 73 | 4 | 86 | 319 | 1 | 234 | Polysphondylium pallidum PN500 Rho GTPase (rac1B), partial mRNA | blastn | 7502 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 14478771 | 14478771 | PRJNA489308_P_NODE_26612_length_262_cov_3.603175_g26536_i0 | PRJNA489308 | 26612 | 262 | 3.603175 | 9.4403185 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 183 | 8.119999999999997e-42 | NTclustered | gi|470237759|ref|XM_004350786.1| | 261658 | g26536 | i0 | 80.162 | 94.6412213740458 | 247 | 47 | 94 | 2 | 17 | 262 | 850 | 1095 | Cavenderia fasciculata actin (DFA_11894), partial mRNA | blastn | 24796 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 15752879 | 15752879 | PRJNA489308_P_NODE_29853_length_253_cov_1.555556_g29777_i0 | PRJNA489308 | 29853 | 253 | 1.555556 | 3.93555668 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 202 | 2.15e-47 | NTclustered | gi|66800080|ref|XM_628964.1| | 352472 | g29777 | i0 | 81.25 | 17.802371541502 | 256 | 42 | 100 | 4 | 1 | 253 | 290 | 542 | Dictyostelium discoideum AX4 proteasome subunit beta type 5 (psmB5) mRNA, complete cds | blastn | 4504 | 202 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 17027615 | 17027615 | PRJNA489308_P_NODE_5874_length_438_cov_2.668493_g5798_i0 | PRJNA489308 | 5874 | 438 | 2.668493 | 11.68799934 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 145 | 6.79e-30 | NTclustered | gi|831788452|ref|XM_012903297.1| | 1410327 | g5798 | i0 | 75.078 | 9.72602739726027 | 321 | 74 | 73 | 5 | 1 | 318 | 1590 | 1907 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 4260 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 18301785 | 18301785 | PRJNA489308_P_NODE_23755_length_272_cov_1.703518_g23679_i0 | PRJNA489308 | 23755 | 272 | 1.703518 | 4.63356896 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 204 | 6.509999999999999e-48 | NTclustered | gi|330796796|ref|XM_003286403.1| | 5786 | g23679 | i0 | 81.323 | 23.9963235294118 | 257 | 42 | 93 | 6 | 19 | 272 | 393 | 140 | Dictyostelium purpureum ranA, RAN GTPase (ranA), partial mRNA | blastn | 6527 | 204 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18949608 | 18949608 | PRJNA489308_P_NODE_3415_length_544_cov_4.012739_g3339_i0 | PRJNA489308 | 3415 | 544 | 4.012739 | 21.82930016 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|470245538|ref|XM_004356856.1| | 261658 | g3339 | i0 | 94.595 | 3.5625 | 37 | 2 | 7 | 0 | 324 | 360 | 146 | 110 | Cavenderia fasciculata GRAM domain-containing protein (DFA_06683), partial mRNA | blastn | 1938 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 23402378 | 23402378 | PRJNA489308_P_NODE_15159_length_312_cov_2.276151_g15083_i0 | PRJNA489308 | 15159 | 312 | 2.276151 | 7.10159112 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 243 | 1.61e-59 | NTclustered | gi|470240647|ref|XM_004354263.1| | 261658 | g15083 | i0 | 80.707 | 190.75 | 311 | 60 | 99 | 0 | 1 | 311 | 386 | 76 | Cavenderia fasciculata ubiquitin (ubqA), partial mRNA | blastn | 59514 | 243 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 23402572 | 23402572 | PRJNA489308_P_NODE_4939_length_471_cov_1.354271_g4863_i0 | PRJNA489308 | 4939 | 471 | 1.354271 | 6.37861641 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 241 | 9.11e-59 | NTclustered | gi|330797305|ref|XM_003286654.1| | 5786 | g4863 | i0 | 78.261 | 4.58811040339703 | 391 | 73 | 82 | 8 | 13 | 397 | 612 | 228 | Dictyostelium purpureum enoyl-CoA hydratase (DICPUDRAFT_54444), partial mRNA | blastn | 2161 | 241 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 24050018 | 24050018 | PRJNA489308_P_NODE_7159_length_403_cov_5.090909_g7083_i0 | PRJNA489308 | 7159 | 403 | 5.090909 | 20.51636327 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 268 | 3.52e-67 | NTclustered | gi|167938|gb|M23749.1|DDIUBIQB | 44689 | g7083 | i0 | 79.894 | 87.9081885856079 | 378 | 67 | 93 | 9 | 29 | 403 | 385 | 14 | D.discoideum ubiquitin mRNA, complete cds, clone DCUBV45 | blastn | 35427 | 268 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 24676243 | 24676243 | PRJNA489308_P_NODE_31980_length_249_cov_2.204545_g31904_i0 | PRJNA489308 | 31980 | 249 | 2.204545 | 5.48931705 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 137 | 6.0499999999999996e-28 | NTclustered | gi|470266348|ref|XM_004361672.1| | 261658 | g31904 | i0 | 81.988 | 27.0441767068273 | 161 | 29 | 65 | 0 | 85 | 245 | 322 | 482 | Cavenderia fasciculata Rab GTPase (rab7A), partial mRNA | blastn | 6734 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata |
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);;