contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax_phylum = "Xenacoelomorpha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27146957 | 27146957 | PRJNA743294_P_NODE_31722_length_296_cov_2.246637_g31266_i0 | PRJNA743294 | 31722 | 296 | 2.246637 | 6.65004552 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 47.4 | 0.00166 | NR | XP_063722157.1 | 84072 | g31266 | i0 | 44.9 | 0.496621621621622 | 49 | 24 | 49.7 | 2 | 203 | 57 | 129 | 174 | XP_063722157.1 uncharacterized protein LOC134848568 [Symsagittifera roscoffensis] | diamond | 147 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27568104 | 27568104 | PRJNA743294_P_NODE_47824_length_251_cov_1.337079_g47368_i0 | PRJNA743294 | 47824 | 251 | 1.337079 | 3.35606829 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 136 | 5.49e-35 | NR | XP_063724751.1 | 84072 | g47368 | i0 | 79.5 | 92.7490039840637 | 83 | 16 | 99.2 | 1 | 250 | 2 | 283 | 364 | XP_063724751.1 kinesin-like protein KIF17 [Symsagittifera roscoffensis] | diamond | 23280 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27810915 | 27810915 | PRJNA743294_P_NODE_25404_length_327_cov_1.511811_g24948_i0 | PRJNA743294 | 25404 | 327 | 1.511811 | 4.94362197 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 112 | 5.78e-27 | NR | XP_063719152.1 | 84072 | g24948 | i0 | 57 | 6.19266055045872 | 86 | 36 | 78 | 1 | 2 | 256 | 321 | 406 | XP_063719152.1 phospholipase B1, membrane-associated-like [Symsagittifera roscoffensis] | diamond | 2025 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27873890 | 27873890 | PRJNA743294_P_NODE_53745_length_245_cov_0.906977_g53289_i0 | PRJNA743294 | 53745 | 245 | 0.906977 | 2.22209365 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 42.7 | 0.0383 | NR | XP_063729139.1 | 84072 | g53289 | i0 | 35.6 | 0.893877551020408 | 73 | 44 | 85.7 | 2 | 210 | 1 | 195 | 267 | XP_063729139.1 WD and tetratricopeptide repeats protein 1-like [Symsagittifera roscoffensis] | diamond | 219 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28158298 | 28158298 | PRJNA743294_P_NODE_38345_length_274_cov_0.905473_g37889_i0 | PRJNA743294 | 38345 | 274 | 0.905473 | 2.48099602 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 58.5 | 1.41e-7 | NR | XP_063722551.1 | 84072 | g37889 | i0 | 57.7 | 0.569343065693431 | 52 | 17 | 56.9 | 1 | 50 | 205 | 208 | 254 | XP_063722551.1 rhomboid-related protein 4-like [Symsagittifera roscoffensis] | diamond | 156 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28884210 | 28884210 | PRJNA743294_P_NODE_8708_length_533_cov_3.219565_g8252_i0 | PRJNA743294 | 8708 | 533 | 3.219565 | 17.16028145 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 47.8 | 0.00924 | NR | XP_063715604.1 | 84072 | g8252 | i0 | 58.1 | 1.14821763602251 | 31 | 13 | 17.4 | 0 | 501 | 409 | 368 | 398 | XP_063715604.1 uncharacterized protein LOC134842980 [Symsagittifera roscoffensis] | diamond | 612 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29105474 | 29105474 | PRJNA743294_P_NODE_9828_length_504_cov_1.387471_g9372_i0 | PRJNA743294 | 9828 | 504 | 1.387471 | 6.99285384 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 65.9 | 4.52e-9 | NR | XP_063720490.1 | 84072 | g9372 | i0 | 42.3 | 1.2202380952381 | 71 | 38 | 42.3 | 1 | 285 | 73 | 278 | 345 | XP_063720490.1 uncharacterized protein LOC134846961 [Symsagittifera roscoffensis] | diamond | 615 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29294730 | 29294730 | PRJNA743294_P_NODE_6649_length_603_cov_13.524528_g6198_i0 | PRJNA743294 | 6649 | 603 | 13.524528 | 81.55290384 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 67 | 6.01e-10 | NR | XP_063719240.1 | 84072 | g6198 | i0 | 55.8 | 0.825870646766169 | 43 | 19 | 21.4 | 0 | 46 | 174 | 1 | 43 | XP_063719240.1 vacuolar protein sorting-associated protein 29-like [Symsagittifera roscoffensis] | diamond | 498 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29989475 | 29989475 | PRJNA743294_P_NODE_40911_length_266_cov_1.777202_g40455_i0 | PRJNA743294 | 40911 | 266 | 1.777202 | 4.72735732 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 63.9 | 1.3e-9 | NR | XP_063711854.1 | 84072 | g40455 | i0 | 61.4 | 0.496240601503759 | 44 | 17 | 49.6 | 0 | 247 | 116 | 19 | 62 | XP_063711854.1 uncharacterized protein LOC134840092 [Symsagittifera roscoffensis] | diamond | 132 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30084075 | 30084075 | PRJNA743294_P_NODE_23552_length_338_cov_1.445283_g23096_i0 | PRJNA743294 | 23552 | 338 | 1.445283 | 4.88505654 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 156 | 1.68e-44 | NR | XP_063711854.1 | 84072 | g23096 | i0 | 55.9 | 0.985207100591716 | 111 | 49 | 98.5 | 0 | 6 | 338 | 198 | 308 | XP_063711854.1 uncharacterized protein LOC134840092 [Symsagittifera roscoffensis] | diamond | 333 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31032323 | 31032323 | PRJNA743294_P_NODE_29115_length_308_cov_1.327660_g28659_i0 | PRJNA743294 | 29115 | 308 | 1.32766 | 4.0891928 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 51.2 | 8.6e-5 | NR | XP_063718499.1 | 84072 | g28659 | i0 | 42.3 | 1.12012987012987 | 71 | 37 | 69.2 | 1 | 94 | 306 | 166 | 232 | XP_063718499.1 transcription elongation factor SPT5-like [Symsagittifera roscoffensis] | diamond | 345 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis |
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);;