contig_metadata
10 rows where bioproject = "PRJNA1111448" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9145829 | 9145829 | PRJNA1111448_S_NODE_60148_length_327_cov_2.421260_g59325_i0 | PRJNA1111448 | 60148 | 327 | 2.42126 | 7.9175202 | Ophiotheca pedata | 1680578 | Evosea | other_Eukaryota | 484 | 2.5599999999999998e-132 | NTclustered | gi|2250222264|gb|ON713372.1| | 1680578 | g59325 | i0 | 94.044 | 94.9755351681957 | 319 | 19 | 98 | 0 | 2 | 320 | 915 | 1233 | Perichaena pedata voucher MA81941 small subunit ribosomal RNA gene, partial sequence | blastn | 31057 | 484 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Ophiotheca | Ophiotheca pedata | ||
| 16794348 | 16794348 | PRJNA1111448_S_NODE_101914_length_269_cov_2.841837_g101091_i0 | PRJNA1111448 | 101914 | 269 | 2.841837 | 7.64454153 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 2e-34 | NR | XP_003293531.1 | 5786 | g101091 | i0 | 68.3 | 8.4089219330855 | 82 | 26 | 91.4 | 0 | 269 | 24 | 102 | 183 | XP_003293531.1 ribosomal protein L11 [Dictyostelium purpureum] | diamond | 2262 | 127 | 0.992125984251969 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28015523 | 28015523 | PRJNA1111448_S_NODE_108105_length_263_cov_1.215789_g107282_i0 | PRJNA1111448 | 108105 | 263 | 1.215789 | 3.19752507 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 51.6 | 3.69e-5 | NR | XP_640711.1 | 352472 | g107282 | i0 | 32.8 | 0.695817490494297 | 61 | 41 | 69.6 | 0 | 5 | 187 | 1098 | 1158 | XP_640711.1 hypothetical protein DDB_G0281485 [Dictyostelium discoideum AX4] | diamond | 183 | 51.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 28583862 | 28583862 | PRJNA1111448_S_NODE_80727_length_295_cov_1.162162_g79904_i0 | PRJNA1111448 | 80727 | 295 | 1.162162 | 3.4283779 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 73.6 | 4.84e-13 | NR | XP_003287614.1 | 5786 | g79904 | i0 | 78.4 | 0.51864406779661 | 51 | 11 | 51.9 | 0 | 293 | 141 | 189 | 239 | XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum] | diamond | 153 | 73.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 29332735 | 29332735 | PRJNA1111448_S_NODE_128989_length_246_cov_1.578035_g128166_i0 | PRJNA1111448 | 128989 | 246 | 1.578035 | 3.8819661 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 89.4 | 1.6e-18 | NR | PRP88103.1 | 1890364 | g128166 | i0 | 49.4 | 1.89024390243902 | 79 | 39 | 96.3 | 1 | 1 | 237 | 1634 | 1711 | PRP88103.1 intraflagellar transport protein [Planoprotostelium fungivorum] | diamond | 465 | 89.7 | 0.996655518394649 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30668119 | 30668119 | PRJNA1111448_S_NODE_28273_length_417_cov_2.415698_g27450_i0 | PRJNA1111448 | 28273 | 417 | 2.415698 | 10.07346066 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 114 | 1.78e-26 | NR | PRP74799.1 | 1890364 | g27450 | i0 | 48 | 0.884892086330935 | 123 | 62 | 88.5 | 1 | 415 | 47 | 392 | 512 | PRP74799.1 actin binding protein [Planoprotostelium fungivorum] | diamond | 369 | 114 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31015687 | 31015687 | PRJNA1111448_S_NODE_80035_length_296_cov_1.035874_g79212_i0 | PRJNA1111448 | 80035 | 296 | 1.035874 | 3.06618704 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 65.1 | 1.01e-9 | NR | XP_020436557.1 | 670386 | g79212 | i0 | 51.5 | 0.668918918918919 | 66 | 32 | 66.9 | 0 | 1 | 198 | 1263 | 1328 | XP_020436557.1 elongation protein 1 [Heterostelium album PN500] | diamond | 198 | 65.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 31837688 | 31837688 | PRJNA1111448_S_NODE_86577_length_287_cov_2.093458_g85754_i0 | PRJNA1111448 | 86577 | 287 | 2.093458 | 6.00822446 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 119 | 2.0899999999999996e-31 | NR | KYQ91511.1 | 361077 | g85754 | i0 | 60.4 | 0.951219512195122 | 91 | 36 | 95.1 | 0 | 285 | 13 | 127 | 217 | KYQ91511.1 elongation factor 1b [Tieghemostelium lacteum] | diamond | 273 | 119 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32588521 | 32588521 | PRJNA1111448_S_NODE_104119_length_267_cov_1.484536_g103296_i0 | PRJNA1111448 | 104119 | 267 | 1.484536 | 3.96371112 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 3.63e-5 | NR | KAH3765792.1 | 1580589 | g103296 | i0 | 37.5 | 3.70786516853933 | 88 | 54 | 98.9 | 1 | 2 | 265 | 376 | 462 | KAH3765792.1 Poly(ADP-ribose) polymerase, regulatory domain [Pelomyxa schiedti] | diamond | 990 | 51.6 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32723084 | 32723084 | PRJNA1111448_S_NODE_121620_length_250_cov_1.740113_g120797_i0 | PRJNA1111448 | 121620 | 250 | 1.740113 | 4.3502825 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 70.5 | 2.02e-12 | NR | XP_020437626.1 | 670386 | g120797 | i0 | 47.9 | 0.852 | 71 | 35 | 82.8 | 1 | 2 | 208 | 154 | 224 | XP_020437626.1 vacuolar H+-ATPase E subunit [Heterostelium album PN500] | diamond | 213 | 70.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;