contig_metadata
11 rows where bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1820576 | 1820576 | PRJNA560932_P_NODE_7242_length_643_cov_1.138596_g6890_i0 | PRJNA560932 | 7242 | 643 | 1.138596 | 7.32117228 | root | 1 | Root_unresolved | Root_unresolved | 133 | 2.04e-32 | NR | XP_063720812.1 | 84072 | g6890 | i0 | 75.3 | 21.0933125972006 | 89 | 22 | 41.5 | 0 | 268 | 2 | 43 | 131 | XP_063720812.1 ATP synthase subunit beta, mitochondrial-like [Symsagittifera roscoffensis] | diamond | 13563 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 2405944 | 2405944 | PRJNA560932_P_NODE_28342_length_337_cov_1.750000_g27986_i0 | PRJNA560932 | 28342 | 337 | 1.75 | 5.8975 | Philactinoposthia | 84154 | Xenacoelomorpha | other_Eukaryota | 119 | 3.09e-22 | NTclustered | gi|333774890|emb|FR832402.1| | 996601 | g27986 | i0 | 82.482 | 41.106824925816 | 137 | 22 | 40 | 2 | 196 | 331 | 2678 | 2813 | Philactinoposthia brevis partial 28S rRNA gene, specimen voucher UJ10-11 | blastn | 13853 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Childiidae | Philactinoposthia | Philactinoposthia brevis | ||
| 17122208 | 17122208 | PRJNA560932_P_NODE_17194_length_424_cov_1.125356_g16838_i0 | PRJNA560932 | 17194 | 424 | 1.125356 | 4.77150944 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 138 | 8.55e-37 | NR | XP_063729560.1 | 84072 | g16838 | i0 | 78.9 | 64.5283018867924 | 76 | 16 | 53.8 | 0 | 2 | 229 | 241 | 316 | XP_063729560.1 serine/threonine-protein phosphatase 2A catalytic subunit beta isoform [Symsagittifera roscoffensis] | diamond | 27360 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27616274 | 27616274 | PRJNA560932_P_NODE_8224_length_606_cov_1.442777_g7871_i0 | PRJNA560932 | 8224 | 606 | 1.442777 | 8.74322862 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 115 | 1.84e-27 | NR | XP_063718751.1 | 84072 | g7871 | i0 | 38.3 | 0.97029702970297 | 196 | 113 | 96 | 5 | 21 | 602 | 85 | 274 | XP_063718751.1 protein lifeguard 3-like [Symsagittifera roscoffensis] | diamond | 588 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27679645 | 27679645 | PRJNA560932_P_NODE_9344_length_569_cov_1.852823_g8991_i0 | PRJNA560932 | 9344 | 569 | 1.852823 | 10.54256287 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 156 | 5.94e-42 | NR | XP_063723322.1 | 84072 | g8991 | i0 | 46.1 | 0.880492091388401 | 167 | 81 | 85.9 | 3 | 489 | 1 | 47 | 208 | XP_063723322.1 uncharacterized protein LOC134851252 [Symsagittifera roscoffensis] | diamond | 501 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28058104 | 28058104 | PRJNA560932_P_NODE_39065_length_291_cov_1.059633_g38709_i0 | PRJNA560932 | 39065 | 291 | 1.059633 | 3.08353203 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 144 | 1.42e-39 | NR | XP_063718829.1 | 84072 | g38709 | i0 | 63.5 | 5.93814432989691 | 96 | 35 | 99 | 0 | 290 | 3 | 172 | 267 | XP_063718829.1 cyclin-dependent kinase 7-like [Symsagittifera roscoffensis] | diamond | 1728 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28121306 | 28121306 | PRJNA560932_P_NODE_50185_length_256_cov_1.344262_g49829_i0 | PRJNA560932 | 50185 | 256 | 1.344262 | 3.44131072 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 48.5 | 4.07e-4 | NR | XP_063720614.1 | 84072 | g49829 | i0 | 39.2 | 0.8671875 | 74 | 38 | 78.5 | 2 | 47 | 247 | 172 | 245 | XP_063720614.1 eukaryotic elongation factor 2 kinase-like [Symsagittifera roscoffensis] | diamond | 222 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28752794 | 28752794 | PRJNA560932_P_NODE_62567_length_244_cov_0.900585_g62211_i0 | PRJNA560932 | 62567 | 244 | 0.900585 | 2.1974274 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 62.4 | 4.46e-9 | NR | XP_063724619.1 | 84072 | g62211 | i0 | 39.7 | 0.836065573770492 | 68 | 40 | 82.4 | 1 | 213 | 13 | 306 | 373 | XP_063724619.1 thioredoxin domain-containing protein 5-like [Symsagittifera roscoffensis] | diamond | 204 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28815655 | 28815655 | PRJNA560932_P_NODE_57528_length_247_cov_1.770115_g57172_i0 | PRJNA560932 | 57528 | 247 | 1.770115 | 4.37218405 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 60.5 | 2.32e-8 | NR | XP_063716157.1 | 84072 | g57172 | i0 | 40.7 | 0.983805668016194 | 81 | 46 | 97.2 | 2 | 247 | 8 | 2363 | 2442 | XP_063716157.1 uncharacterized protein LOC134843803 [Symsagittifera roscoffensis] | diamond | 243 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31754093 | 31754093 | PRJNA560932_P_NODE_13497_length_476_cov_1.833747_g13143_i0 | PRJNA560932 | 13497 | 476 | 1.833747 | 8.72863572 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 88.6 | 4.74e-17 | NR | XP_063723321.1 | 84072 | g13143 | i0 | 43.9 | 1.3172268907563 | 98 | 55 | 61.8 | 0 | 29 | 322 | 539 | 636 | XP_063723321.1 protein transport protein Sec23A-like [Symsagittifera roscoffensis] | diamond | 627 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31785580 | 31785580 | PRJNA560932_P_NODE_15577_length_444_cov_1.886792_g15222_i0 | PRJNA560932 | 15577 | 444 | 1.886792 | 8.37735648 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 159 | 8.46e-44 | NR | XP_063723322.1 | 84072 | g15222 | i0 | 53 | 2 | 149 | 67 | 98.6 | 2 | 440 | 3 | 265 | 413 | XP_063723322.1 uncharacterized protein LOC134851252 [Symsagittifera roscoffensis] | diamond | 888 | 159 | 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);;