contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1613363 | 1613363 | PRJNA1237347_P_NODE_212342_length_417_cov_1.063953_g205770_i0 | PRJNA1237347 | 212342 | 417 | 1.063953 | 4.43668401 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 147 | 1.02e-41 | NR | XP_063724020.1 | 84072 | g205770 | i0 | 52.2 | 6.64748201438849 | 134 | 63 | 96.4 | 1 | 11 | 412 | 1 | 133 | XP_063724020.1 uncharacterized protein LOC134851731 [Symsagittifera roscoffensis] | diamond | 2772 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 20745485 | 20745485 | PRJNA1237347_P_NODE_47817_length_1085_cov_2.570158_g43014_i0 | PRJNA1237347 | 47817 | 1085 | 2.570158 | 27.8862143 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 278 | 3.5e-80 | NR | XP_063722708.1 | 84072 | g43014 | i0 | 42.5 | 4.5926267281106 | 325 | 185 | 89.3 | 1 | 970 | 2 | 533 | 857 | XP_063722708.1 phospholipid-transporting ATPase ABCA1-like [Symsagittifera roscoffensis] | diamond | 4983 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26711485 | 26711485 | PRJNA1237347_P_NODE_446701_length_260_cov_2.240642_g440128_i0 | PRJNA1237347 | 446701 | 260 | 2.240642 | 5.8256692 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 127 | 7.2e-32 | NR | XP_063729601.1 | 84072 | g440128 | i0 | 67.4 | 32.4230769230769 | 86 | 28 | 99.2 | 0 | 3 | 260 | 237 | 322 | XP_063729601.1 lysine--tRNA ligase-like [Symsagittifera roscoffensis] | diamond | 8430 | 128 | 0.9921875 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27073195 | 27073195 | PRJNA1237347_P_NODE_443442_length_262_cov_1.216931_g436869_i0 | PRJNA1237347 | 443442 | 262 | 1.216931 | 3.18835922 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 54.3 | 4.18e-6 | NR | XP_063716157.1 | 84072 | g436869 | i0 | 44.9 | 1.58015267175573 | 69 | 36 | 77.9 | 2 | 47 | 250 | 2356 | 2423 | XP_063716157.1 uncharacterized protein LOC134843803 [Symsagittifera roscoffensis] | diamond | 414 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27483784 | 27483784 | PRJNA1237347_P_NODE_273663_length_354_cov_1.096085_g267090_i0 | PRJNA1237347 | 273663 | 354 | 1.096085 | 3.8801409 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 86.7 | 4.73e-17 | NR | XP_063712487.1 | 84072 | g267090 | i0 | 39.4 | 1.8135593220339 | 109 | 64 | 92.4 | 1 | 336 | 10 | 301 | 407 | XP_063712487.1 eukaryotic translation initiation factor 3 subunit E-like isoform X1 [Symsagittifera roscoffensis] | diamond | 642 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27881278 | 27881278 | PRJNA1237347_P_NODE_537225_length_243_cov_0.905882_g530652_i0 | PRJNA1237347 | 537225 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 68.9 | 2.19e-11 | NR | XP_063719062.1 | 84072 | g530652 | i0 | 40.5 | 11.5555555555556 | 74 | 43 | 90.1 | 1 | 220 | 2 | 156 | 229 | XP_063719062.1 X-linked retinitis pigmentosa GTPase regulator-like isoform X4 [Symsagittifera roscoffensis] | diamond | 2808 | 69.3 | 0.994227994227994 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28115360 | 28115360 | PRJNA1237347_P_NODE_431165_length_267_cov_1.190722_g424592_i0 | PRJNA1237347 | 431165 | 267 | 1.190722 | 3.17922774 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 70.5 | 6.42e-13 | NR | XP_063726204.1 | 84072 | g424592 | i0 | 56.1 | 1.28089887640449 | 57 | 25 | 64 | 0 | 171 | 1 | 21 | 77 | XP_063726204.1 calmodulin-A-like [Symsagittifera roscoffensis] | diamond | 342 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28147055 | 28147055 | PRJNA1237347_P_NODE_299125_length_334_cov_3.467433_g292552_i0 | PRJNA1237347 | 299125 | 334 | 3.467433 | 11.58122622 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 45.8 | 0.00868 | NR | XP_063719707.1 | 84072 | g292552 | i0 | 30.8 | 0.583832335329341 | 65 | 41 | 54.8 | 1 | 310 | 128 | 478 | 542 | XP_063719707.1 sodium- and chloride-dependent creatine transporter 1-like [Symsagittifera roscoffensis] | diamond | 195 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28178542 | 28178542 | PRJNA1237347_P_NODE_563106_length_232_cov_2.509434_g556532_i0 | PRJNA1237347 | 563106 | 232 | 2.509434 | 5.82188688 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 47.8 | 5.35e-4 | NR | XP_063725174.1 | 84072 | g556532 | i0 | 47.8 | 0.594827586206897 | 46 | 22 | 59.5 | 1 | 139 | 2 | 285 | 328 | XP_063725174.1 uncharacterized protein LOC134853149 [Symsagittifera roscoffensis] | diamond | 138 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28196842 | 28196842 | PRJNA1237347_P_NODE_314586_length_324_cov_1.685259_g308013_i0 | PRJNA1237347 | 314586 | 324 | 1.685259 | 5.46023916 | root | 1 | Root_unresolved | Root_unresolved | 119 | 5.18e-30 | NR | XP_063719320.1 | 84072 | g308013 | i0 | 58.3 | 9.7037037037037 | 103 | 43 | 95.4 | 0 | 3 | 311 | 78 | 180 | XP_063719320.1 retinol dehydrogenase 11-like [Symsagittifera roscoffensis] | diamond | 3144 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28399283 | 28399283 | PRJNA1237347_P_NODE_157246_length_508_cov_1.250575_g150687_i0 | PRJNA1237347 | 157246 | 508 | 1.250575 | 6.352921 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 59.3 | 9.61e-7 | NR | XP_063728832.1 | 84072 | g150687 | i0 | 29.4 | 2.78740157480315 | 160 | 90 | 86.2 | 6 | 4 | 441 | 21 | 171 | XP_063728832.1 E3 ubiquitin-protein ligase TRIM23-like [Symsagittifera roscoffensis] | diamond | 1416 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28544524 | 28544524 | PRJNA1237347_P_NODE_375367_length_290_cov_1.419355_g368794_i0 | PRJNA1237347 | 375367 | 290 | 1.419355 | 4.1161295 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47 | 0.00208 | NR | XP_063729719.1 | 84072 | g368794 | i0 | 62.1 | 0.620689655172414 | 29 | 11 | 30 | 0 | 254 | 168 | 583 | 611 | XP_063729719.1 protein CFAP20DC-like [Symsagittifera roscoffensis] | diamond | 180 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28955028 | 28955028 | PRJNA1237347_P_NODE_362608_length_296_cov_2.654709_g356035_i0 | PRJNA1237347 | 362608 | 296 | 2.654709 | 7.85793864 | root | 1 | Root_unresolved | Root_unresolved | 80.1 | 2.19e-15 | NR | XP_063718895.1 | 84072 | g356035 | i0 | 43.3 | 9.90202702702703 | 97 | 54 | 98.3 | 1 | 2 | 292 | 201 | 296 | XP_063718895.1 protein lifeguard 3-like [Symsagittifera roscoffensis] | diamond | 2931 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28967818 | 28967818 | PRJNA1237347_P_NODE_197248_length_437_cov_3.233516_g190676_i0 | PRJNA1237347 | 197248 | 437 | 3.233516 | 14.13046492 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 56.2 | 2.08e-6 | NR | XP_063712175.1 | 84072 | g190676 | i0 | 36.3 | 0.624713958810069 | 91 | 49 | 57 | 2 | 349 | 101 | 105 | 194 | XP_063712175.1 calbindin-32-like [Symsagittifera roscoffensis] | diamond | 273 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29347121 | 29347121 | PRJNA1237347_P_NODE_548309_length_242_cov_0.911243_g541736_i0 | PRJNA1237347 | 548309 | 242 | 0.911243 | 2.20520806 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 55.1 | 1.63e-6 | NR | XP_063714244.1 | 84072 | g541736 | i0 | 45.8 | 0.731404958677686 | 59 | 31 | 73.1 | 1 | 61 | 237 | 80 | 137 | XP_063714244.1 krev interaction trapped protein 1-like [Symsagittifera roscoffensis] | diamond | 177 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29694025 | 29694025 | PRJNA1237347_P_NODE_77510_length_802_cov_6.835391_g71464_i0 | PRJNA1237347 | 77510 | 802 | 6.835391 | 54.81983582 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 99 | 9.77e-21 | NR | XP_063719239.1 | 84072 | g71464 | i0 | 33.5 | 1.28678304239401 | 170 | 110 | 62.5 | 2 | 708 | 208 | 20 | 189 | XP_063719239.1 putative carboxymethylenebutenolidase [Symsagittifera roscoffensis] | diamond | 1032 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29883783 | 29883783 | PRJNA1237347_P_NODE_379991_length_288_cov_1.432558_g373418_i0 | PRJNA1237347 | 379991 | 288 | 1.432558 | 4.12576704 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 68.6 | 5.16e-11 | NR | XP_063729539.1 | 84072 | g373418 | i0 | 53.2 | 1.27083333333333 | 62 | 25 | 61.5 | 2 | 179 | 3 | 397 | 457 | XP_063729539.1 tyrosine-protein kinase SRK3-like [Symsagittifera roscoffensis] | diamond | 366 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29947051 | 29947051 | PRJNA1237347_P_NODE_549931_length_241_cov_2.619048_g543358_i0 | PRJNA1237347 | 549931 | 241 | 2.619048 | 6.31190568 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 44.7 | 0.00748 | NR | XP_063726618.1 | 84072 | g543358 | i0 | 43.5 | 1.89211618257261 | 46 | 25 | 57.3 | 1 | 59 | 196 | 120 | 164 | XP_063726618.1 F-box only protein 8-like [Symsagittifera roscoffensis] | diamond | 456 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30028493 | 30028493 | PRJNA1237347_P_NODE_178911_length_467_cov_1.238579_g172340_i0 | PRJNA1237347 | 178911 | 467 | 1.238579 | 5.78416393 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 101 | 1.7e-21 | NR | XP_063720072.1 | 84072 | g172340 | i0 | 51.5 | 1.86937901498929 | 97 | 46 | 61.7 | 1 | 292 | 5 | 460 | 556 | XP_063720072.1 uncharacterized protein LOC134846617 [Symsagittifera roscoffensis] | diamond | 873 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30136197 | 30136197 | PRJNA1237347_P_NODE_554912_length_241_cov_0.916667_g548339_i0 | PRJNA1237347 | 554912 | 241 | 0.916667 | 2.20916747 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 43.1 | 0.0244 | NR | XP_063728541.1 | 84072 | g548339 | i0 | 32.1 | 1.73029045643154 | 78 | 52 | 95.9 | 1 | 10 | 240 | 164 | 241 | XP_063728541.1 syntaxin-12-like [Symsagittifera roscoffensis] | diamond | 417 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30673136 | 30673136 | PRJNA1237347_P_NODE_246733_length_378_cov_0.885246_g240160_i0 | PRJNA1237347 | 246733 | 378 | 0.885246 | 3.34622988 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 130 | 1.0799999999999999e-32 | NR | XP_063712757.1 | 84072 | g240160 | i0 | 56.1 | 0.849206349206349 | 107 | 47 | 84.9 | 0 | 53 | 373 | 340 | 446 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 321 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31526853 | 31526853 | PRJNA1237347_P_NODE_289216_length_342_cov_0.858736_g282643_i0 | PRJNA1237347 | 289216 | 342 | 0.858736 | 2.93687712 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 105 | 1.2299999999999997e-23 | NR | XP_063724664.1 | 84072 | g282643 | i0 | 44.3 | 2 | 115 | 63 | 100 | 1 | 342 | 1 | 1743 | 1857 | XP_063724664.1 uncharacterized protein LOC134852807 [Symsagittifera roscoffensis] | diamond | 684 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32412814 | 32412814 | PRJNA1237347_P_NODE_370239_length_293_cov_0.827273_g363666_i0 | PRJNA1237347 | 370239 | 293 | 0.827273 | 2.42390989 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 72 | 3.52e-12 | NR | XP_063721574.1 | 84072 | g363666 | i0 | 40.4 | 36.6348122866894 | 89 | 47 | 91.1 | 3 | 6 | 272 | 245 | 327 | XP_063721574.1 uncharacterized protein LOC134848144 [Symsagittifera roscoffensis] | diamond | 10734 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32539536 | 32539536 | PRJNA1237347_P_NODE_413979_length_274_cov_1.149254_g407406_i0 | PRJNA1237347 | 413979 | 274 | 1.149254 | 3.14895596 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 56.2 | 9.61e-7 | NR | XP_063715654.1 | 84072 | g407406 | i0 | 38.9 | 1.56569343065693 | 72 | 43 | 77.7 | 1 | 12 | 224 | 826 | 897 | XP_063715654.1 uncharacterized protein LOC134843049 [Symsagittifera roscoffensis] | diamond | 429 | 56.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);;