contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4560441 | 4560441 | PRJNA756891_P_NODE_4704_length_389_cov_1.218354_g4635_i0 | PRJNA756891 | 4704 | 389 | 1.218354 | 4.73939706 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|330789894|ref|XM_003282986.1| | 5786 | g4635 | i0 | 100 | 0.0719794344473008 | 28 | 0 | 7 | 0 | 345 | 372 | 94 | 121 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_146630), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 4560445 | 4560445 | PRJNA756891_P_NODE_5204_length_371_cov_1.795302_g5135_i0 | PRJNA756891 | 5204 | 371 | 1.795302 | 6.66057042 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 71.3 | 9.74e-8 | NTclustered | gi|66810172|ref|XM_633718.1| | 352472 | g5135 | i0 | 97.561 | 1.68194070080863 | 41 | 1 | 11 | 0 | 49 | 89 | 261 | 221 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0283999) mRNA, complete cds | blastn | 624 | 71.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5835580 | 5835580 | PRJNA756891_P_NODE_6565_length_334_cov_1.298851_g6496_i0 | PRJNA756891 | 6565 | 334 | 1.298851 | 4.33816234 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 239 | 2.25e-58 | NTclustered | gi|330790786|ref|XM_003283429.1| | 5786 | g6496 | i0 | 82.593 | 3.04790419161677 | 270 | 47 | 81 | 0 | 1 | 270 | 1002 | 1271 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91113), mRNA | blastn | 1018 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 5835581 | 5835581 | PRJNA756891_P_NODE_65_length_2101_cov_14.436884_g56_i0 | PRJNA756891 | 65 | 2101 | 14.436884 | 303.31893284 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 983 | 0 | NTclustered | gi|330818764|ref|XM_003291461.1| | 5786 | g56 | i0 | 77.887 | 70.7891480247501 | 1628 | 329 | 77 | 28 | 48 | 1661 | 13 | 1623 | Dictyostelium purpureum heat shock protein (DICPUDRAFT_49867), partial mRNA | blastn | 148728 | 983 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7110709 | 7110709 | PRJNA756891_P_NODE_2106_length_572_cov_4.553106_g2038_i0 | PRJNA756891 | 2106 | 572 | 4.553106 | 26.04376632 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 337 | 1.3899999999999996e-87 | NTclustered | gi|470252539|ref|XM_004359310.1| | 261658 | g2038 | i0 | 79.15 | 54.8916083916084 | 494 | 98 | 86 | 5 | 46 | 537 | 33 | 523 | Cavenderia fasciculata ADP-ribosylation factor (arfA), partial mRNA | blastn | 31398 | 337 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 7110710 | 7110710 | PRJNA756891_P_NODE_2126_length_569_cov_9.116935_g2058_i0 | PRJNA756891 | 2126 | 569 | 9.116935 | 51.87536015 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 327 | 8.33e-85 | NTclustered | gi|330845407|ref|XM_003294531.1| | 5786 | g2058 | i0 | 79.526 | 14.8558875219684 | 464 | 91 | 81 | 4 | 88 | 549 | 526 | 65 | Dictyostelium purpureum uncharacterized protein (rapA), mRNA | blastn | 8453 | 327 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7110736 | 7110736 | PRJNA756891_P_NODE_6366_length_338_cov_3.256604_g6297_i0 | PRJNA756891 | 6366 | 338 | 3.256604 | 11.00732152 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 248 | 3.7899999999999995e-61 | NTclustered | gi|330802353|ref|XM_003289135.1| | 5786 | g6297 | i0 | 83.333 | 19.301775147929 | 270 | 43 | 80 | 2 | 3 | 272 | 318 | 51 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_88388), partial mRNA | blastn | 6524 | 248 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8385355 | 8385355 | PRJNA756891_P_NODE_967_length_813_cov_4.393243_g907_i0 | PRJNA756891 | 967 | 813 | 4.393243 | 35.71706559 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 368 | 7.14e-97 | NTclustered | gi|330822609|ref|XM_003291694.1| | 5786 | g907 | i0 | 79.883 | 0.677736777367774 | 512 | 95 | 62 | 7 | 265 | 771 | 645 | 137 | Dictyostelium purpureum uncharacterized protein (rasG), mRNA | blastn | 551 | 368 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13485786 | 13485786 | PRJNA756891_P_NODE_1631_length_642_cov_14.855888_g1565_i0 | PRJNA756891 | 1631 | 642 | 14.855888 | 95.37480096 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 370 | 1.55e-97 | NTclustered | gi|1160573488|ref|XM_020576922.1| | 670386 | g1565 | i0 | 81.9 | 2.08722741433022 | 442 | 76 | 69 | 4 | 197 | 636 | 440 | 1 | Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA | blastn | 1340 | 370 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 13485789 | 13485789 | PRJNA756891_P_NODE_16811_length_228_cov_4.780645_g16742_i0 | PRJNA756891 | 16811 | 228 | 4.780645 | 10.8998706 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 58.4 | 4.37e-4 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g16742 | i0 | 100 | 0.267543859649123 | 31 | 0 | 14 | 0 | 146 | 176 | 4802 | 4772 | Phalansterium solitarium 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 61 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 13956235 | 13956235 | PRJNA756891_P_NODE_7671_length_312_cov_1.933054_g7602_i0 | PRJNA756891 | 7671 | 312 | 1.933054 | 6.03112848 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|470236543|ref|XM_004350175.1| | 261658 | g7602 | i0 | 100 | 0.544871794871795 | 29 | 0 | 9 | 0 | 137 | 165 | 341 | 313 | Cavenderia fasciculata uncharacterized protein (DFA_11282), partial mRNA | blastn | 170 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 14760978 | 14760978 | PRJNA756891_P_NODE_7012_length_324_cov_2.274900_g6943_i0 | PRJNA756891 | 7012 | 324 | 2.2749 | 7.370676 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 193 | 1.72e-44 | NTclustered | gi|330796067|ref|XM_003286043.1| | 5786 | g6943 | i0 | 79.63 | 0.833333333333333 | 270 | 53 | 83 | 2 | 46 | 314 | 54 | 322 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_54025), partial mRNA | blastn | 270 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18583859 | 18583859 | PRJNA756891_P_NODE_1115_length_761_cov_7.827035_g1053_i0 | PRJNA756891 | 1115 | 761 | 7.827035 | 59.56373635 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 503 | 1.75e-137 | NTclustered | gi|330801204|ref|XM_003288572.1| | 5786 | g1053 | i0 | 84.423 | 55.4362680683311 | 520 | 72 | 68 | 8 | 222 | 736 | 534 | 19 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA | blastn | 42187 | 503 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18583869 | 18583869 | PRJNA756891_P_NODE_12935_length_249_cov_0.875000_g12866_i0 | PRJNA756891 | 12935 | 249 | 0.875 | 2.17875 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 193 | 1.27e-44 | NTclustered | gi|330840803|ref|XM_003292351.1| | 5786 | g12866 | i0 | 81.224 | 1.57429718875502 | 245 | 41 | 98 | 5 | 5 | 247 | 695 | 454 | Dictyostelium purpureum protein serine/threonine kinase (DICPUDRAFT_92862), mRNA | blastn | 392 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 19859084 | 19859084 | PRJNA756891_P_NODE_896_length_845_cov_1.051813_g840_i0 | PRJNA756891 | 896 | 845 | 1.051813 | 8.88781985 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 63.9 | 3.93e-5 | NTclustered | gi|66807638|ref|XM_632450.1| | 352472 | g840 | i0 | 100 | 2.2603550295858 | 34 | 0 | 4 | 0 | 359 | 392 | 1571 | 1538 | Dictyostelium discoideum AX4 hypothetical protein (dnaja5) mRNA, complete cds | blastn | 1910 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 20328701 | 20328701 | PRJNA756891_P_NODE_3076_length_476_cov_2.732010_g3008_i0 | PRJNA756891 | 3076 | 476 | 2.73201 | 13.0043676 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 353 | 1.13e-92 | NTclustered | gi|167946|gb|M23753.1|DDIUBIQF | 44689 | g3008 | i0 | 80.335 | 102.897058823529 | 478 | 84 | 99 | 10 | 4 | 476 | 1400 | 928 | D.discoideum ubiquitin mRNA, complete cds, clone DCUB14 | blastn | 48979 | 353 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22409371 | 22409371 | PRJNA756891_P_NODE_12198_length_251_cov_0.865169_g12129_i0 | PRJNA756891 | 12198 | 251 | 0.865169 | 2.17157419 | Dictyostelium giganteum | 5787 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|324329891|gb|GU904431.1| | 5787 | g12129 | i0 | 96.97 | 0.474103585657371 | 33 | 1 | 13 | 0 | 1 | 33 | 104 | 136 | Dictyostelium giganteum clone Dicty_1A23 microsatellite sequence | blastn | 119 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium giganteum | ||
| 22409398 | 22409398 | PRJNA756891_P_NODE_178_length_1531_cov_2.772291_g158_i0 | PRJNA756891 | 178 | 1531 | 2.772291 | 42.44377521 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 58.4 | 0.003 | NTclustered | gi|330842512|ref|XM_003293173.1| | 5786 | g158 | i0 | 92.683 | 0.0267798824297845 | 41 | 2 | 3 | 1 | 264 | 304 | 4011 | 3972 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_95779), partial mRNA | blastn | 41 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;