contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668718 | 668718 | PRJNA689790_S_NODE_15841_length_154_cov_1.000000_g15726_i0 | PRJNA689790 | 15841 | 154 | 1 | 1.54 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 100 | 4.45e-17 | NTclustered | gi|1160560754|ref|XM_020578592.1| | 670386 | g15726 | i0 | 92.754 | 6.42207792207792 | 69 | 5 | 45 | 0 | 4 | 72 | 22 | 90 | Polysphondylium pallidum PN500 Tubulin alpha-1B chain partial mRNA | blastn | 989 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 668719 | 668719 | PRJNA689790_S_NODE_15881_length_153_cov_4.008621_g15766_i0 | PRJNA689790 | 15881 | 153 | 4.008621 | 6.13319013 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 226 | 6.979999999999998e-55 | NTclustered | gi|167377343|ref|XM_001734312.1| | 370354 | g15766 | i0 | 94.521 | 46.7124183006536 | 146 | 8 | 95 | 0 | 8 | 153 | 289 | 144 | Entamoeba dispar SAW760 ADP-ribosylation factor, arf, putative (EDI_275790), partial mRNA | blastn | 7147 | 226 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 1944750 | 1944750 | PRJNA689790_S_NODE_14282_length_160_cov_1.292683_g14167_i0 | PRJNA689790 | 14282 | 160 | 1.292683 | 2.0682928 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 143 | 7.649999999999998e-30 | NTclustered | gi|831779201|ref|XM_012900195.1| | 1410327 | g14167 | i0 | 82.911 | 17.55625 | 158 | 27 | 99 | 0 | 3 | 160 | 791 | 634 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 2809 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 3219591 | 3219591 | PRJNA689790_S_NODE_2763_length_381_cov_3.186047_g2648_i0 | PRJNA689790 | 2763 | 381 | 3.186047 | 12.13883907 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 279 | 1.53e-70 | NTclustered | gi|330792832|ref|XM_003284443.1| | 5786 | g2648 | i0 | 80.366 | 64.2677165354331 | 382 | 64 | 100 | 6 | 1 | 381 | 1200 | 829 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_52984), mRNA | blastn | 24486 | 279 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8321851 | 8321851 | PRJNA689790_S_NODE_15007_length_157_cov_1.283333_g14892_i0 | PRJNA689790 | 15007 | 157 | 1.283333 | 2.01483281 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 104 | 3.53e-18 | NTclustered | gi|831767409|ref|XM_012896638.1| | 1410327 | g14892 | i0 | 80 | 2.78343949044586 | 140 | 28 | 89 | 0 | 15 | 154 | 1111 | 972 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 437 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 9597245 | 9597245 | PRJNA689790_S_NODE_11528_length_175_cov_1.978261_g11413_i0 | PRJNA689790 | 11528 | 175 | 1.978261 | 3.46195675 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 62.1 | 2.45e-5 | NTclustered | gi|330802402|ref|XM_003289159.1| | 5786 | g11413 | i0 | 93.023 | 0.462857142857143 | 43 | 2 | 24 | 1 | 17 | 58 | 1842 | 1884 | Dictyostelium purpureum actin bundling protein (DICPUDRAFT_92251), mRNA | blastn | 81 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 10106787 | 10106787 | PRJNA689790_S_NODE_2308_length_425_cov_7.381443_g2193_i0 | PRJNA689790 | 2308 | 425 | 7.381443 | 31.37113275 | Evosea | 2605435 | Evosea | other_Eukaryota | 318 | 3.6599999999999996e-82 | NTclustered | gi|2714663864|gb|OR759944.1| | 410605 | g2193 | i0 | 80.282 | 54.5129411764706 | 426 | 80 | 99 | 4 | 1 | 424 | 959 | 536 | Comatricha nigra translation elongation factor EF-1 subunit alpha (EF1A) gene, partial cds | blastn | 23168 | 318 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Comatricha | Comatricha nigra | ||
| 10872812 | 10872812 | PRJNA689790_S_NODE_6949_length_225_cov_1.659574_g6834_i0 | PRJNA689790 | 6949 | 225 | 1.659574 | 3.7340415 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 62.1 | 3.32e-5 | NTclustered | gi|470263919|ref|XM_004360998.1| | 261658 | g6834 | i0 | 97.222 | 5.6 | 36 | 1 | 16 | 0 | 1 | 36 | 456 | 491 | Cavenderia fasciculata RabGAP/TBC domain-containing protein (DFA_05336), partial mRNA | blastn | 1260 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 13422603 | 13422603 | PRJNA689790_S_NODE_13631_length_163_cov_1.547619_g13516_i0 | PRJNA689790 | 13631 | 163 | 1.547619 | 2.52261897 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 108 | 2.86e-19 | NTclustered | gi|66826498|ref|XM_641512.1| | 352472 | g13516 | i0 | 81.618 | 0.834355828220859 | 136 | 19 | 82 | 6 | 12 | 144 | 288 | 156 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0270184) mRNA, complete cds | blastn | 136 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 15971471 | 15971471 | PRJNA689790_S_NODE_4813_length_276_cov_1.443515_g4698_i0 | PRJNA689790 | 4813 | 276 | 1.443515 | 3.9841014 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|66816706|ref|XM_637271.1| | 352472 | g4698 | i0 | 94.444 | 0.952898550724638 | 36 | 1 | 13 | 1 | 17 | 52 | 295 | 329 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0278433) mRNA, complete cds | blastn | 263 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19029820 | 19029820 | PRJNA689790_S_NODE_6375_length_236_cov_4.718593_g6260_i0 | PRJNA689790 | 6375 | 236 | 4.718593 | 11.13587948 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.4 | 2.7e-11 | NTclustered | gi|18032239|gb|AF219108.1|AF219108 | 13642 | g6260 | i0 | 93.103 | 18.6016949152542 | 58 | 1 | 24 | 2 | 180 | 236 | 152 | 97 | Polysphondylium pallidum 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 | 4390 | 82.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium pallidum | ||
| 22346060 | 22346060 | PRJNA689790_S_NODE_1078_length_642_cov_27.856198_g989_i0 | PRJNA689790 | 1078 | 642 | 27.856198 | 178.83679116 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 448 | 6.969999999999998e-121 | NTclustered | gi|66804710|ref|XM_630996.1| | 352472 | g989 | i0 | 79.348 | 93.9844236760125 | 644 | 127 | 99 | 6 | 2 | 642 | 1034 | 394 | Dictyostelium discoideum AX4 hypothetical protein (act5) mRNA, complete cds | blastn | 60338 | 448 | 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);;