contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1644813 | 1644813 | PRJNA270367_P_NODE_24102_length_236_cov_0.946524_g23897_i0 | PRJNA270367 | 24102 | 236 | 0.946524 | 2.23379664 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 143 | 1.22e-29 | NTclustered | gi|831773908|ref|XM_012898598.1| | 1410327 | g23897 | i0 | 77.872 | 0.995762711864407 | 235 | 48 | 99 | 4 | 1 | 233 | 223 | 455 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 235 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 1645035 | 1645035 | PRJNA270367_P_NODE_5562_length_580_cov_1.768362_g5370_i0 | PRJNA270367 | 5562 | 580 | 1.768362 | 10.2564996 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 387 | 1.38e-102 | NTclustered | gi|831769071|ref|XM_012897140.1| | 1410327 | g5370 | i0 | 80.344 | 23.7396551724138 | 524 | 91 | 89 | 11 | 17 | 534 | 518 | 1 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 13769 | 387 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 2920710 | 2920710 | PRJNA270367_P_NODE_30783_length_200_cov_1.721854_g30578_i0 | PRJNA270367 | 30783 | 200 | 1.721854 | 3.443708 | Schizoplasmodiopsis vulgaris | 435421 | Evosea | other_Eukaryota | 134 | 6.03e-27 | NTclustered | gi|159082997|gb|EF513198.1| | 435421 | g30578 | i0 | 79.208 | 5.97 | 202 | 34 | 99 | 8 | 1 | 198 | 1224 | 1027 | Schizoplasmodiopsis vulgaris elongation factor 1A (EF1A) gene, partial cds | blastn | 1194 | 134 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Schizoplasmodiopsis | Schizoplasmodiopsis vulgaris | |||
| 5473219 | 5473219 | PRJNA270367_P_NODE_11765_length_384_cov_2.600000_g11563_i0 | PRJNA270367 | 11765 | 384 | 2.6 | 9.984 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 355 | 2.49e-93 | NTclustered | gi|470236159|ref|XM_004349983.1| | 261658 | g11563 | i0 | 83.42 | 232.322916666667 | 386 | 60 | 100 | 4 | 1 | 384 | 614 | 231 | Cavenderia fasciculata uncharacterized protein (DFA_11090), partial mRNA | blastn | 89212 | 355 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 5473375 | 5473375 | PRJNA270367_P_NODE_26225_length_223_cov_0.896552_g26020_i0 | PRJNA270367 | 26225 | 223 | 0.896552 | 1.99931096 | Rostrostelium ellipticum | 361140 | Evosea | other_Eukaryota | 254 | 5.06e-63 | NTclustered | gi|117413669|emb|AM168485.1| | 361140 | g26020 | i0 | 87.444 | 92.9372197309417 | 223 | 24 | 99 | 3 | 3 | 223 | 781 | 561 | Rostrostelium ellipticum partial tuba gene for alpha-tubulin, exon 1, isolate AE2 | blastn | 20725 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Rostrostelium | Rostrostelium ellipticum | ||
| 6747681 | 6747681 | PRJNA270367_P_NODE_23546_length_240_cov_1.089005_g23341_i0 | PRJNA270367 | 23546 | 240 | 1.089005 | 2.613612 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 182 | 2.64e-41 | NTclustered | gi|330793476|ref|XM_003284762.1| | 5786 | g23341 | i0 | 81.116 | 0.970833333333333 | 233 | 38 | 96 | 5 | 3 | 232 | 603 | 832 | Dictyostelium purpureum extracellular response kinase (DICPUDRAFT_93783), mRNA | blastn | 233 | 182 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7436130 | 7436130 | PRJNA270367_P_NODE_36366_length_179_cov_1.200000_g36161_i0 | PRJNA270367 | 36366 | 179 | 1.2 | 2.148 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 204 | 3.959999999999999e-48 | NTclustered | gi|470266101|ref|XM_004361626.1| | 261658 | g36161 | i0 | 87.293 | 92.8324022346369 | 181 | 19 | 100 | 4 | 1 | 179 | 58 | 236 | Cavenderia fasciculata uncharacterized protein (DFA_05968), partial mRNA | blastn | 16617 | 204 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 9298272 | 9298272 | PRJNA270367_P_NODE_608_length_1928_cov_5.425758_g502_i0 | PRJNA270367 | 608 | 1928 | 5.425758 | 104.60861424 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 1055 | 0 | NTclustered | gi|330818764|ref|XM_003291461.1| | 5786 | g502 | i0 | 78.792 | 75.423755186722 | 1622 | 307 | 83 | 32 | 307 | 1911 | 1614 | 13 | Dictyostelium purpureum heat shock protein (DICPUDRAFT_49867), partial mRNA | blastn | 145417 | 1055 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 11848646 | 11848646 | PRJNA270367_P_NODE_2710_length_840_cov_1.874842_g2538_i0 | PRJNA270367 | 2710 | 840 | 1.874842 | 15.7486728 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 414 | 9.36e-111 | NTclustered | gi|470263923|ref|XM_004360999.1| | 261658 | g2538 | i0 | 79.242 | 31.5547619047619 | 607 | 116 | 72 | 10 | 3 | 604 | 1030 | 1631 | Cavenderia fasciculata vacuolar H+-ATPase A subunit (vatA), partial mRNA | blastn | 26506 | 414 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 13123757 | 13123757 | PRJNA270367_P_NODE_20551_length_264_cov_1.539535_g20346_i0 | PRJNA270367 | 20551 | 264 | 1.539535 | 4.0643724 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 215 | 2.91e-51 | NTclustered | gi|330843266|ref|XM_003293532.1| | 5786 | g20346 | i0 | 81.609 | 32.9393939393939 | 261 | 46 | 98 | 2 | 2 | 261 | 258 | 517 | Dictyostelium purpureum ADP-ribosylation factor 1 (arfA), mRNA | blastn | 8696 | 215 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13124013 | 13124013 | PRJNA270367_P_NODE_46511_length_162_cov_0.920354_g46306_i0 | PRJNA270367 | 46511 | 162 | 0.920354 | 1.49097348 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.013 | NTclustered | gi|66803273|ref|XM_630388.1| | 352472 | g46306 | i0 | 100 | 0.172839506172839 | 28 | 0 | 17 | 0 | 79 | 106 | 311 | 284 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0290947) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 15672936 | 15672936 | PRJNA270367_P_NODE_5953_length_559_cov_5.031373_g5760_i0 | PRJNA270367 | 5953 | 559 | 5.031373 | 28.12537507 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 228 | 8.519999999999998e-55 | NTclustered | gi|330795848|ref|XM_003285935.1| | 5786 | g5760 | i0 | 76.85 | 8.75849731663685 | 419 | 88 | 74 | 8 | 46 | 458 | 425 | 10 | Dictyostelium purpureum vacuolar ATPase proteolipid subunit (DICPUDRAFT_30216), partial mRNA | blastn | 4896 | 228 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16947360 | 16947360 | PRJNA270367_P_NODE_26094_length_223_cov_2.431034_g25889_i0 | PRJNA270367 | 26094 | 223 | 2.431034 | 5.42120582 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 169 | 1.88e-37 | NTclustered | gi|111219439|ref|XM_641961.2| | 352472 | g25889 | i0 | 81.683 | 38.7533632286995 | 202 | 37 | 91 | 0 | 13 | 214 | 367 | 166 | Dictyostelium discoideum AX4 Rho GTPase (rac1B) mRNA, complete cds | blastn | 8642 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19496210 | 19496210 | PRJNA270367_P_NODE_8096_length_473_cov_2.226415_g7898_i0 | PRJNA270367 | 8096 | 473 | 2.226415 | 10.53094295 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 326 | 2.46e-84 | NTclustered | gi|1160573488|ref|XM_020576922.1| | 670386 | g7898 | i0 | 80.137 | 11.9260042283298 | 438 | 85 | 92 | 2 | 30 | 466 | 437 | 1 | Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA | blastn | 5641 | 326 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 20771585 | 20771585 | PRJNA270367_P_NODE_38937_length_170_cov_1.677686_g38732_i0 | PRJNA270367 | 38937 | 170 | 1.677686 | 2.8520662 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 145 | 2.28e-30 | NTclustered | gi|1160552074|ref|XM_020571371.1| | 670386 | g38732 | i0 | 86.822 | 6.28235294117647 | 129 | 17 | 76 | 0 | 39 | 167 | 25 | 153 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 1068 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 22046391 | 22046391 | PRJNA270367_P_NODE_10918_length_400_cov_16.065527_g10716_i0 | PRJNA270367 | 10918 | 400 | 16.065527 | 64.262108 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 254 | 9.79e-63 | NTclustered | gi|470267221|ref|XM_004361931.1| | 261658 | g10716 | i0 | 78.851 | 94.0725 | 383 | 75 | 96 | 4 | 4 | 385 | 1 | 378 | Cavenderia fasciculata ubiquitin/ribosomal protein L40 fusion protein (ubqB), partial mRNA | blastn | 37629 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 22046409 | 22046409 | PRJNA270367_P_NODE_12758_length_367_cov_1.748428_g12556_i0 | PRJNA270367 | 12758 | 367 | 1.748428 | 6.41673076 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 501 | 2.879999999999999e-137 | NTclustered | gi|167859713|gb|EU273436.1| | 1346289 | g12556 | i0 | 91.351 | 98.5286103542234 | 370 | 26 | 100 | 5 | 1 | 367 | 360 | 726 | Telaepolella tubasferens clone 2 actin gene, partial cds | blastn | 36160 | 501 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 22046418 | 22046418 | PRJNA270367_P_NODE_13598_length_352_cov_15.382838_g13393_i0 | PRJNA270367 | 13598 | 352 | 15.382838 | 54.14758976 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 67.6 | 1.19e-6 | NTclustered | gi|330790854|ref|XM_003283463.1| | 5786 | g13393 | i0 | 75.342 | 0.414772727272727 | 146 | 33 | 41 | 2 | 66 | 211 | 395 | 253 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93471), partial mRNA | blastn | 146 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 22046725 | 22046725 | PRJNA270367_P_NODE_46618_length_162_cov_0.920354_g46413_i0 | PRJNA270367 | 46618 | 162 | 0.920354 | 1.49097348 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 176 | 7.67e-40 | NTclustered | gi|470265124|ref|XM_004361351.1| | 261658 | g46413 | i0 | 86.335 | 13.4259259259259 | 161 | 22 | 99 | 0 | 2 | 162 | 566 | 406 | Cavenderia fasciculata 26S proteasome ATPase 2 subunit (psmC2), partial mRNA | blastn | 2175 | 176 | 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);;