contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8210443 | 8210443 | PRJNA565584_P_NODE_69167_length_357_cov_1.897887_g68016_i0 | PRJNA565584 | 69167 | 357 | 1.897887 | 6.77545659 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 172 | 1.22e-47 | NR | XP_063715816.1 | 84072 | g68016 | i0 | 73.3 | 10.7226890756303 | 116 | 31 | 97.5 | 0 | 3 | 350 | 268 | 383 | XP_063715816.1 endoplasmic reticulum chaperone BiP-like [Symsagittifera roscoffensis] | diamond | 3828 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 23507909 | 23507909 | PRJNA565584_P_NODE_166499_length_251_cov_1.730337_g165347_i0 | PRJNA565584 | 166499 | 251 | 1.730337 | 4.34314587 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.4 | 7.84e-11 | NR | XP_063719084.1 | 84072 | g165347 | i0 | 60.4 | 8.86852589641434 | 53 | 15 | 63.3 | 1 | 211 | 53 | 145 | 191 | XP_063719084.1 eukaryotic initiation factor 4A-III [Symsagittifera roscoffensis] | diamond | 2226 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26636222 | 26636222 | PRJNA565584_P_NODE_70761_length_353_cov_1.860714_g69610_i0 | PRJNA565584 | 70761 | 353 | 1.860714 | 6.56832042 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 47.4 | 0.00286 | NR | XP_063723580.1 | 84072 | g69610 | i0 | 31.8 | 0.560906515580737 | 66 | 44 | 56.1 | 1 | 328 | 131 | 347 | 411 | XP_063723580.1 paladin-like [Symsagittifera roscoffensis] | diamond | 198 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26744518 | 26744518 | PRJNA565584_P_NODE_139321_length_269_cov_1.571429_g138169_i0 | PRJNA565584 | 139321 | 269 | 1.571429 | 4.22714401 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 115 | 9.919999999999999e-28 | NR | XP_063727797.1 | 84072 | g138169 | i0 | 59.6 | 7.33828996282528 | 89 | 36 | 99.3 | 0 | 269 | 3 | 616 | 704 | XP_063727797.1 GTP-binding protein 1-like [Symsagittifera roscoffensis] | diamond | 1974 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27346149 | 27346149 | PRJNA565584_P_NODE_37083_length_495_cov_1.888626_g35932_i0 | PRJNA565584 | 37083 | 495 | 1.888626 | 9.3486987 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 180 | 5.04e-52 | NR | XP_063711112.1 | 84072 | g35932 | i0 | 58.4 | 4.48484848484848 | 149 | 59 | 88.5 | 3 | 439 | 2 | 1 | 149 | XP_063711112.1 calreticulin-like [Symsagittifera roscoffensis] | diamond | 2220 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27868988 | 27868988 | PRJNA565584_P_NODE_83225_length_326_cov_1.213439_g82073_i0 | PRJNA565584 | 83225 | 326 | 1.213439 | 3.95581114 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 60.5 | 1.6e-8 | NR | XP_063716883.1 | 84072 | g82073 | i0 | 33.6 | 1.96932515337423 | 107 | 20 | 98.5 | 2 | 6 | 326 | 12 | 67 | XP_063716883.1 N-alpha-acetyltransferase 50-like [Symsagittifera roscoffensis] | diamond | 642 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28798236 | 28798236 | PRJNA565584_P_NODE_90887_length_311_cov_2.928571_g89735_i0 | PRJNA565584 | 90887 | 311 | 2.928571 | 9.10785581 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 79 | 4.56e-15 | NR | XP_063710526.1 | 84072 | g89735 | i0 | 41.7 | 10.4083601286174 | 96 | 54 | 91.6 | 2 | 310 | 26 | 120 | 214 | XP_063710526.1 eukaryotic translation initiation factor 4E type 2-like [Symsagittifera roscoffensis] | diamond | 3237 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29921617 | 29921617 | PRJNA565584_P_NODE_19711_length_717_cov_2.245342_g18611_i0 | PRJNA565584 | 19711 | 717 | 2.245342 | 16.09910214 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 149 | 3.2e-40 | NR | XP_063710558.1 | 84072 | g18611 | i0 | 36.8 | 1 | 239 | 145 | 99.2 | 4 | 715 | 5 | 7 | 241 | XP_063710558.1 carboxymethylenebutenolidase homolog [Symsagittifera roscoffensis] | diamond | 717 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32811129 | 32811129 | PRJNA565584_P_NODE_212920_length_241_cov_1.375000_g211768_i0 | PRJNA565584 | 212920 | 241 | 1.375 | 3.31375 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 6.59e-28 | NR | XP_063722507.1 | 84072 | g211768 | i0 | 64.6 | 3.93360995850622 | 79 | 28 | 98.3 | 0 | 3 | 239 | 251 | 329 | XP_063722507.1 major vault protein-like [Symsagittifera roscoffensis] | diamond | 948 | 116 | 0.991379310344828 | 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);;