contig_metadata
17 rows where bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9524256 | 9524256 | PRJNA615351_P_NODE_53868_length_672_cov_8.274725_g41275_i0 | PRJNA615351 | 53868 | 672 | 8.274725 | 55.606152 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 129 | 7.01e-32 | NR | XP_063726494.1 | 84072 | g41275 | i0 | 43.5 | 5.07589285714286 | 168 | 89 | 73.7 | 3 | 125 | 619 | 35 | 199 | XP_063726494.1 store-operated calcium entry-associated regulatory factor-like [Symsagittifera roscoffensis] | diamond | 3411 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 13350012 | 13350012 | PRJNA615351_P_NODE_54431_length_665_cov_7.309524_g41275_i1 | PRJNA615351 | 54431 | 665 | 7.309524 | 48.6083346 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 123 | 1.02e-29 | NR | XP_063726494.1 | 84072 | g41275 | i1 | 42.9 | 4.55187969924812 | 168 | 90 | 74.4 | 3 | 118 | 612 | 35 | 199 | XP_063726494.1 store-operated calcium entry-associated regulatory factor-like [Symsagittifera roscoffensis] | diamond | 3027 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 15898408 | 15898408 | PRJNA615351_P_NODE_124673_length_238_cov_1.970443_g110573_i0 | PRJNA615351 | 124673 | 238 | 1.970443 | 4.68965434 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 148 | 2.6499999999999996e-31 | NTclustered | gi|2701354757|ref|XM_063863014.1| | 84072 | g110573 | i0 | 82.456 | 5.84873949579832 | 171 | 28 | 71 | 2 | 3 | 172 | 837 | 668 | PREDICTED: Symsagittifera roscoffensis eukaryotic initiation factor 4A-III (LOC134845892), mRNA | blastn | 1392 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26935120 | 26935120 | PRJNA615351_P_NODE_59302_length_605_cov_1.736842_g46136_i0 | PRJNA615351 | 59302 | 605 | 1.736842 | 10.5078941 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 63.2 | 7.22e-8 | NR | XP_063715688.1 | 84072 | g46136 | i0 | 44.6 | 1.97851239669421 | 65 | 33 | 31.7 | 2 | 199 | 8 | 20 | 82 | XP_063715688.1 gelsolin-like protein 1 [Symsagittifera roscoffensis] | diamond | 1197 | 63.5 | 0.995275590551181 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27188005 | 27188005 | PRJNA615351_P_NODE_27402_length_1207_cov_25.606655_g19957_i0 | PRJNA615351 | 27402 | 1207 | 25.606655 | 309.07232585 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 148 | 4.52e-38 | NR | XP_063719239.1 | 84072 | g19957 | i0 | 35 | 1.89146644573322 | 246 | 156 | 60.6 | 4 | 756 | 25 | 4 | 247 | XP_063719239.1 putative carboxymethylenebutenolidase [Symsagittifera roscoffensis] | diamond | 2283 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27775519 | 27775519 | PRJNA615351_P_NODE_157904_length_179_cov_1.944444_g143804_i0 | PRJNA615351 | 157904 | 179 | 1.944444 | 3.48055476 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 94.4 | 6.51e-22 | NR | XP_063713583.1 | 84072 | g143804 | i0 | 59.7 | 1.0391061452514 | 62 | 22 | 98.9 | 1 | 177 | 1 | 67 | 128 | XP_063713583.1 uncharacterized protein LOC134841490 [Symsagittifera roscoffensis] | diamond | 186 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28451515 | 28451515 | PRJNA615351_P_NODE_28866_length_1167_cov_7.035336_g21055_i0 | PRJNA615351 | 28866 | 1167 | 7.035336 | 82.10237112 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 7.790000000000001e-21 | NR | XP_063710602.1 | 84072 | g21055 | i0 | 31.5 | 2.29048843187661 | 213 | 134 | 53 | 6 | 686 | 69 | 162 | 369 | XP_063710602.1 vacuolar protein-sorting-associated protein 36-like [Symsagittifera roscoffensis] | diamond | 2673 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29209297 | 29209297 | PRJNA615351_P_NODE_62949_length_566_cov_4.384181_g12571_i3 | PRJNA615351 | 62949 | 566 | 4.384181 | 24.81446446 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 62.8 | 8.58e-8 | NR | XP_063712593.1 | 84072 | g12571 | i3 | 28 | 3.98586572438163 | 132 | 81 | 65.2 | 4 | 166 | 534 | 305 | 431 | XP_063712593.1 F-box/LRR-repeat protein 2-like [Symsagittifera roscoffensis] | diamond | 2256 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29637812 | 29637812 | PRJNA615351_P_NODE_131910_length_222_cov_1.395722_g117810_i0 | PRJNA615351 | 131910 | 222 | 1.395722 | 3.09850284 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 56.6 | 3.62e-7 | NR | XP_063710276.1 | 84072 | g117810 | i0 | 38.3 | 1.82432432432432 | 81 | 42 | 98.6 | 2 | 221 | 3 | 347 | 427 | XP_063710276.1 chloride channel protein D-like isoform X1 [Symsagittifera roscoffensis] | diamond | 405 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30630328 | 30630328 | PRJNA615351_P_NODE_53333_length_679_cov_5.818323_g21055_i1 | PRJNA615351 | 53333 | 679 | 5.818323 | 39.50641317 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 5.040000000000001e-21 | NR | XP_063710602.1 | 84072 | g21055 | i1 | 31.1 | 1.83357879234168 | 209 | 132 | 89.2 | 6 | 674 | 69 | 166 | 369 | XP_063710602.1 vacuolar protein-sorting-associated protein 36-like [Symsagittifera roscoffensis] | diamond | 1245 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30914938 | 30914938 | PRJNA615351_P_NODE_119734_length_251_cov_1.634259_g105634_i0 | PRJNA615351 | 119734 | 251 | 1.634259 | 4.10199009 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 46.6 | 0.00182 | NR | XP_063712801.1 | 84072 | g105634 | i0 | 35.4 | 3.45418326693227 | 82 | 48 | 93.2 | 2 | 251 | 18 | 544 | 624 | XP_063712801.1 uncharacterized protein LOC134840727 isoform X1 [Symsagittifera roscoffensis] | diamond | 867 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31376113 | 31376113 | PRJNA615351_P_NODE_21176_length_1417_cov_8.303184_g15383_i0 | PRJNA615351 | 21176 | 1417 | 8.303184 | 117.65611728 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 155 | 2.42e-38 | NR | XP_063717070.1 | 84072 | g15383 | i0 | 29 | 0.760056457304164 | 359 | 229 | 73.9 | 6 | 1301 | 255 | 6 | 348 | XP_063717070.1 histone acetyltransferase type B catalytic subunit-like [Symsagittifera roscoffensis] | diamond | 1077 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31660506 | 31660506 | PRJNA615351_P_NODE_25557_length_1262_cov_8.066830_g17552_i1 | PRJNA615351 | 25557 | 1262 | 8.06683 | 101.8033946 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 158 | 1.58e-39 | NR | XP_063722966.1 | 84072 | g17552 | i1 | 28.8 | 0.934231378763867 | 393 | 248 | 90.8 | 13 | 1189 | 44 | 96 | 467 | XP_063722966.1 lipase member J-like [Symsagittifera roscoffensis] | diamond | 1179 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31736701 | 31736701 | PRJNA615351_P_NODE_170337_length_165_cov_1.538462_g156237_i0 | PRJNA615351 | 170337 | 165 | 1.538462 | 2.5384623 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 53.1 | 7.3e-7 | NR | XP_063721786.1 | 84072 | g156237 | i0 | 53.2 | 1.70909090909091 | 47 | 22 | 85.5 | 0 | 165 | 25 | 88 | 134 | XP_063721786.1 plasminogen receptor (KT)-like [Symsagittifera roscoffensis] | diamond | 282 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31926617 | 31926617 | PRJNA615351_P_NODE_65357_length_543_cov_2.250000_g51704_i0 | PRJNA615351 | 65357 | 543 | 2.25 | 12.2175 | root | 1 | Root_unresolved | Root_unresolved | 269 | 9.52e-90 | NR | XP_063715977.1 | 84072 | g51704 | i0 | 81.8 | 6.38674033149171 | 159 | 29 | 87.8 | 0 | 65 | 541 | 4 | 162 | XP_063715977.1 peptidyl-prolyl cis-trans isomerase A-like [Symsagittifera roscoffensis] | diamond | 3468 | 271 | 0.992619926199262 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31958211 | 31958211 | PRJNA615351_P_NODE_106257_length_293_cov_2.112403_g92158_i0 | PRJNA615351 | 106257 | 293 | 2.112403 | 6.18934079 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 52 | 3.72e-5 | NR | XP_063713972.1 | 84072 | g92158 | i0 | 34.6 | 5.0580204778157 | 81 | 47 | 76.8 | 1 | 45 | 269 | 305 | 385 | XP_063713972.1 choline transporter-like protein 1 [Symsagittifera roscoffensis] | diamond | 1482 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32179928 | 32179928 | PRJNA615351_P_NODE_112578_length_272_cov_1.274262_g98479_i0 | PRJNA615351 | 112578 | 272 | 1.274262 | 3.46599264 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 6.47e-4 | NR | XP_063719260.1 | 84072 | g98479 | i0 | 35.4 | 2.12867647058824 | 65 | 42 | 71.7 | 0 | 267 | 73 | 150 | 214 | XP_063719260.1 glutathione S-transferase Mu 2-like [Symsagittifera roscoffensis] | diamond | 579 | 47.8 | 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);;