contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26637941 | 26637941 | PRJNA641707_P_NODE_318501_length_158_cov_6.192661_g315838_i0 | PRJNA641707 | 318501 | 158 | 6.192661 | 9.78440438 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 54.3 | 9.47e-7 | NR | XP_063727152.1 | 84072 | g315838 | i0 | 51.9 | 1.9746835443038 | 52 | 21 | 98.7 | 1 | 156 | 1 | 156 | 203 | XP_063727152.1 uncharacterized protein LOC134854726 [Symsagittifera roscoffensis] | diamond | 312 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26669239 | 26669239 | PRJNA641707_P_NODE_101041_length_246_cov_4.081218_g98378_i0 | PRJNA641707 | 101041 | 246 | 4.081218 | 10.03979628 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 50.4 | 4.65e-5 | NR | XP_063722828.1 | 84072 | g98378 | i0 | 55.9 | 0.829268292682927 | 34 | 15 | 41.5 | 0 | 102 | 1 | 73 | 106 | XP_063722828.1 ras-related protein Rab-6A-like [Symsagittifera roscoffensis] | diamond | 204 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26808789 | 26808789 | PRJNA641707_P_NODE_247641_length_183_cov_5.440299_g244978_i0 | PRJNA641707 | 247641 | 183 | 5.440299 | 9.95574717 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 89.7 | 1.06e-20 | NR | XP_063726206.1 | 84072 | g244978 | i0 | 64.4 | 1.9344262295082 | 59 | 21 | 96.7 | 0 | 177 | 1 | 115 | 173 | XP_063726206.1 flagellar calcium-binding protein TB-44A-like [Symsagittifera roscoffensis] | diamond | 354 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27681619 | 27681619 | PRJNA641707_P_NODE_128484_length_244_cov_7.743590_g125821_i0 | PRJNA641707 | 128484 | 244 | 7.74359 | 18.8943596 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 46.2 | 0.00238 | NR | XP_063712779.1 | 84072 | g125821 | i0 | 81.8 | 0.270491803278689 | 22 | 4 | 27 | 0 | 34 | 99 | 3569 | 3590 | XP_063712779.1 dynein axonemal heavy chain 2-like isoform X1 [Symsagittifera roscoffensis] | diamond | 66 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27965529 | 27965529 | PRJNA641707_P_NODE_337605_length_151_cov_6.882353_g334942_i0 | PRJNA641707 | 337605 | 151 | 6.882353 | 10.39235303 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 55.8 | 2.08e-7 | NR | XP_063714449.1 | 84072 | g334942 | i0 | 49.1 | 2.80132450331126 | 55 | 21 | 95.4 | 1 | 145 | 2 | 132 | 186 | XP_063714449.1 uncharacterized protein LOC134842165 [Symsagittifera roscoffensis] | diamond | 423 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30378283 | 30378283 | PRJNA641707_P_NODE_39432_length_346_cov_18.521886_g36792_i0 | PRJNA641707 | 39432 | 346 | 18.521886 | 64.08572556 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 68.6 | 1.14e-10 | NR | XP_063715761.1 | 84072 | g36792 | i0 | 88.6 | 3.92774566473988 | 35 | 4 | 30.3 | 0 | 241 | 345 | 534 | 568 | XP_063715761.1 protein strawberry notch homolog 1-like [Symsagittifera roscoffensis] | diamond | 1359 | 68.9 | 0.995645863570392 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31313386 | 31313386 | PRJNA641707_P_NODE_181935_length_200_cov_3.112583_g179272_i0 | PRJNA641707 | 181935 | 200 | 3.112583 | 6.225166 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 48.9 | 1.44e-4 | NR | XP_063720072.1 | 84072 | g179272 | i0 | 58.6 | 0.885 | 29 | 12 | 43.5 | 0 | 194 | 108 | 1255 | 1283 | XP_063720072.1 uncharacterized protein LOC134846617 [Symsagittifera roscoffensis] | diamond | 177 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31534980 | 31534980 | PRJNA641707_P_NODE_122496_length_245_cov_5.714286_g119833_i0 | PRJNA641707 | 122496 | 245 | 5.714286 | 14.0000007 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 45.4 | 0.00421 | NR | XP_063720462.1 | 84072 | g119833 | i0 | 64.5 | 1.9469387755102 | 31 | 11 | 38 | 0 | 94 | 2 | 498 | 528 | XP_063720462.1 annexin A4-like [Symsagittifera roscoffensis] | diamond | 477 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31736912 | 31736912 | PRJNA641707_P_NODE_57777_length_281_cov_2.935345_g55116_i0 | PRJNA641707 | 57777 | 281 | 2.935345 | 8.24831945 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 84.7 | 1.04e-16 | NR | XP_063718554.1 | 84072 | g55116 | i0 | 62.3 | 5.8932384341637 | 69 | 26 | 73.7 | 0 | 207 | 1 | 249 | 317 | XP_063718554.1 RNA cytidine acetyltransferase-like [Symsagittifera roscoffensis] | diamond | 1656 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32420754 | 32420754 | PRJNA641707_P_NODE_204239_length_196_cov_13.591837_g201576_i0 | PRJNA641707 | 204239 | 196 | 13.591837 | 26.64000052 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 42.4 | 0.0281 | NR | XP_063719064.1 | 84072 | g201576 | i0 | 64.3 | 1.30102040816327 | 28 | 10 | 42.9 | 0 | 7 | 90 | 616 | 643 | XP_063719064.1 adenylyl cyclase-associated protein 1-like [Symsagittifera roscoffensis] | diamond | 255 | 42.7 | 0.992974238875878 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32452716 | 32452716 | PRJNA641707_P_NODE_83199_length_246_cov_7.213198_g80536_i0 | PRJNA641707 | 83199 | 246 | 7.213198 | 17.74446708 | Hofstenia miamia | 442651 | Xenacoelomorpha | other_Eukaryota | 60.5 | 2.18e-8 | NR | UEC49170.1 | 442651 | g80536 | i0 | 87.1 | 1.51219512195122 | 31 | 4 | 37.8 | 0 | 7 | 99 | 71 | 101 | UEC49170.1 nlk [Hofstenia miamia] | diamond | 372 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Hofsteniidae | Hofstenia | Hofstenia miamia |
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);;