contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26987483 | 26987483 | PRJNA690592_S_NODE_52242_length_431_cov_2.086592_g51228_i0 | PRJNA690592 | 52242 | 431 | 2.086592 | 8.99321152 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 131 | 3.3399999999999996e-32 | NR | XP_063725880.1 | 84072 | g51228 | i0 | 41.5 | 2.96519721577726 | 142 | 80 | 98.8 | 1 | 3 | 428 | 700 | 838 | XP_063725880.1 transportin-2-like [Symsagittifera roscoffensis] | diamond | 1278 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27524919 | 27524919 | PRJNA690592_S_NODE_91963_length_339_cov_1.142857_g90949_i0 | PRJNA690592 | 91963 | 339 | 1.142857 | 3.87428523 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 77 | 6.59e-14 | NR | XP_063726269.1 | 84072 | g90949 | i0 | 42.3 | 1.8141592920354 | 97 | 51 | 81.4 | 1 | 303 | 28 | 187 | 283 | XP_063726269.1 nmrA-like family domain-containing protein 1 [Symsagittifera roscoffensis] | diamond | 615 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27651223 | 27651223 | PRJNA690592_S_NODE_14944_length_761_cov_18.059593_g14057_i0 | PRJNA690592 | 14944 | 761 | 18.059593 | 137.43350273 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 155 | 2.0799999999999994e-42 | NR | XP_063710558.1 | 84072 | g14057 | i0 | 37.1 | 0.977660972404731 | 248 | 150 | 97 | 4 | 753 | 16 | 7 | 250 | XP_063710558.1 carboxymethylenebutenolidase homolog [Symsagittifera roscoffensis] | diamond | 744 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27883455 | 27883455 | PRJNA690592_S_NODE_120785_length_303_cov_2.286957_g119771_i0 | PRJNA690592 | 120785 | 303 | 2.286957 | 6.92947971 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 110 | 2.57e-28 | NR | XP_063726206.1 | 84072 | g119771 | i0 | 64.9 | 1.51485148514851 | 77 | 27 | 76.2 | 0 | 5 | 235 | 100 | 176 | XP_063726206.1 flagellar calcium-binding protein TB-44A-like [Symsagittifera roscoffensis] | diamond | 459 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29115040 | 29115040 | PRJNA690592_S_NODE_29368_length_557_cov_4.227273_g28368_i0 | PRJNA690592 | 29368 | 557 | 4.227273 | 23.54591061 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 89.7 | 3.69e-17 | NR | XP_063715228.1 | 84072 | g28368 | i0 | 53.9 | 1.74506283662478 | 76 | 34 | 40.4 | 1 | 260 | 484 | 47 | 122 | XP_063715228.1 cytochrome b5 reductase 4-like [Symsagittifera roscoffensis] | diamond | 972 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29703067 | 29703067 | PRJNA690592_S_NODE_202770_length_245_cov_1.343023_g201756_i0 | PRJNA690592 | 202770 | 245 | 1.343023 | 3.29040635 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 119 | 4.85e-30 | NR | XP_063721600.1 | 84072 | g201756 | i0 | 65.4 | 0.991836734693878 | 81 | 28 | 99.2 | 0 | 1 | 243 | 142 | 222 | XP_063721600.1 palmitoyl-protein thioesterase 1-like [Symsagittifera roscoffensis] | diamond | 243 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30188546 | 30188546 | PRJNA690592_S_NODE_154092_length_274_cov_1.074627_g153078_i0 | PRJNA690592 | 154092 | 274 | 1.074627 | 2.94447798 | Sagittiferidae | 170511 | Xenacoelomorpha | other_Eukaryota | 57 | 5.39e-7 | NR | XP_063720741.1 | 84072 | g153078 | i0 | 44.6 | 1.60948905109489 | 65 | 34 | 69 | 1 | 82 | 270 | 518 | 582 | XP_063720741.1 oxysterol-binding protein-related protein 8-like [Symsagittifera roscoffensis] | diamond | 441 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30272323 | 30272323 | PRJNA690592_S_NODE_181392_length_254_cov_1.270718_g180378_i0 | PRJNA690592 | 181392 | 254 | 1.270718 | 3.22762372 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 77 | 2.79e-14 | NR | XP_063720533.1 | 84072 | g180378 | i0 | 50.8 | 1.55905511811024 | 61 | 29 | 72 | 1 | 185 | 3 | 140 | 199 | XP_063720533.1 endoplasmic reticulum-Golgi intermediate compartment protein 3-like [Symsagittifera roscoffensis] | diamond | 396 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30304121 | 30304121 | PRJNA690592_S_NODE_179512_length_255_cov_1.351648_g178498_i0 | PRJNA690592 | 179512 | 255 | 1.351648 | 3.4467024 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 97.8 | 1.87e-21 | NR | XP_063720384.1 | 84072 | g178498 | i0 | 54.9 | 2.89411764705882 | 82 | 37 | 96.5 | 0 | 8 | 253 | 4017 | 4098 | XP_063720384.1 dynein axonemal heavy chain 1-like [Symsagittifera roscoffensis] | diamond | 738 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30619477 | 30619477 | PRJNA690592_S_NODE_151513_length_276_cov_1.108374_g150499_i0 | PRJNA690592 | 151513 | 276 | 1.108374 | 3.05911224 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 47 | 0.00164 | NR | XP_063724662.1 | 84072 | g150499 | i0 | 39 | 2.52173913043478 | 82 | 49 | 89.1 | 1 | 248 | 3 | 141 | 221 | XP_063724662.1 uncharacterized protein LOC134852805 isoform X1 [Symsagittifera roscoffensis] | diamond | 696 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30619562 | 30619562 | PRJNA690592_S_NODE_47613_length_449_cov_1.614362_g46599_i0 | PRJNA690592 | 47613 | 449 | 1.614362 | 7.24848538 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 52.4 | 1.53e-4 | NR | XP_063715160.1 | 84072 | g46599 | i0 | 30.5 | 0.855233853006682 | 128 | 75 | 78.2 | 7 | 1 | 351 | 978 | 1102 | XP_063715160.1 multiple epidermal growth factor-like domains protein 8 isoform X1 [Symsagittifera roscoffensis] | diamond | 384 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30682670 | 30682670 | PRJNA690592_S_NODE_76453_length_366_cov_1.576792_g75439_i0 | PRJNA690592 | 76453 | 366 | 1.576792 | 5.77105872 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 55.1 | 7.82e-6 | NR | XP_063724141.1 | 84072 | g75439 | i0 | 41.1 | 0.598360655737705 | 73 | 39 | 56.6 | 3 | 7 | 213 | 1334 | 1406 | XP_063724141.1 E3 ubiquitin-protein ligase hyd-like isoform X1 [Symsagittifera roscoffensis] | diamond | 219 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30935648 | 30935648 | PRJNA690592_S_NODE_170014_length_262_cov_0.984127_g169000_i0 | PRJNA690592 | 170014 | 262 | 0.984127 | 2.57841274 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 66.2 | 2.63e-10 | NR | XP_063719575.1 | 84072 | g169000 | i0 | 46.5 | 4.23664122137405 | 71 | 35 | 81.3 | 2 | 5 | 217 | 4405 | 4472 | XP_063719575.1 dynein axonemal heavy chain 3-like [Symsagittifera roscoffensis] | diamond | 1110 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31030527 | 31030527 | PRJNA690592_S_NODE_120435_length_304_cov_1.129870_g119421_i0 | PRJNA690592 | 120435 | 304 | 1.12987 | 3.4348048 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 44.3 | 0.0217 | NR | XP_063714212.1 | 84072 | g119421 | i0 | 31.9 | 0.710526315789474 | 72 | 41 | 69.1 | 2 | 211 | 2 | 470 | 535 | XP_063714212.1 vacuolar protein sorting-associated protein 45-like [Symsagittifera roscoffensis] | diamond | 216 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31062248 | 31062248 | PRJNA690592_S_NODE_4815_length_1213_cov_3.227193_g4332_i0 | PRJNA690592 | 4815 | 1213 | 3.227193 | 39.14585109 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 167 | 2.05e-43 | NR | XP_063717070.1 | 84072 | g4332 | i0 | 33.2 | 0.870568837592745 | 352 | 198 | 82.4 | 10 | 104 | 1102 | 15 | 348 | XP_063717070.1 histone acetyltransferase type B catalytic subunit-like [Symsagittifera roscoffensis] | diamond | 1056 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31473067 | 31473067 | PRJNA690592_S_NODE_13896_length_788_cov_1.400000_g13029_i0 | PRJNA690592 | 13896 | 788 | 1.4 | 11.032 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 51.6 | 0.00175 | NR | XP_063710500.1 | 84072 | g13029 | i0 | 24.2 | 0.487309644670051 | 128 | 83 | 48 | 4 | 29 | 406 | 55 | 170 | XP_063710500.1 uncharacterized protein LOC134839035 [Symsagittifera roscoffensis] | diamond | 384 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32169221 | 32169221 | PRJNA690592_S_NODE_75998_length_367_cov_1.557823_g74984_i0 | PRJNA690592 | 75998 | 367 | 1.557823 | 5.71721041 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 75.5 | 5.41e-13 | NR | XP_063715495.1 | 84072 | g74984 | i0 | 38.5 | 0.891008174386921 | 109 | 60 | 85.8 | 3 | 52 | 366 | 128 | 233 | XP_063715495.1 alpha-mannosidase 2-like [Symsagittifera roscoffensis] | diamond | 327 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32212060 | 32212060 | PRJNA690592_S_NODE_18338_length_695_cov_2.435691_g17398_i0 | PRJNA690592 | 18338 | 695 | 2.435691 | 16.92805245 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 84.3 | 1.09e-14 | NR | XP_063729599.1 | 84072 | g17398 | i0 | 27.1 | 5.64604316546763 | 192 | 138 | 82.4 | 2 | 579 | 7 | 452 | 642 | XP_063729599.1 Bardet-Biedl syndrome 7 protein homolog [Symsagittifera roscoffensis] | diamond | 3924 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32243938 | 32243938 | PRJNA690592_S_NODE_155698_length_272_cov_1.934673_g154684_i0 | PRJNA690592 | 155698 | 272 | 1.934673 | 5.26231056 | Opisthokonta | 33154 | Xenacoelomorpha | other_Eukaryota | 118 | 3.8699999999999997e-31 | NR | XP_063722503.1 | 84072 | g154684 | i0 | 57.3 | 14.2941176470588 | 89 | 38 | 98.2 | 0 | 270 | 4 | 64 | 152 | XP_063722503.1 cell division control protein 42 homolog [Symsagittifera roscoffensis] | diamond | 3888 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32674489 | 32674489 | PRJNA690592_S_NODE_300_length_3064_cov_5.776663_g184_i0 | PRJNA690592 | 300 | 3064 | 5.776663 | 176.99695432 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 140 | 2.18e-33 | NR | XP_063719239.1 | 84072 | g184 | i0 | 37.4 | 0.222258485639687 | 227 | 122 | 21.4 | 6 | 1150 | 1806 | 33 | 247 | XP_063719239.1 putative carboxymethylenebutenolidase [Symsagittifera roscoffensis] | diamond | 681 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32780307 | 32780307 | PRJNA690592_S_NODE_6520_length_1082_cov_11.756194_g5934_i0 | PRJNA690592 | 6520 | 1082 | 11.756194 | 127.20201908 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 133 | 2.48e-33 | NR | XP_063726043.1 | 84072 | g5934 | i0 | 40.6 | 1.80499075785582 | 175 | 94 | 48.5 | 2 | 102 | 626 | 45 | 209 | XP_063726043.1 ras-related protein Rab-21-like [Symsagittifera roscoffensis] | diamond | 1953 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32832123 | 32832123 | PRJNA690592_S_NODE_43580_length_466_cov_3.842239_g42566_i0 | PRJNA690592 | 43580 | 466 | 3.842239 | 17.90483374 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 71.2 | 4.41e-11 | NR | XP_063713951.1 | 84072 | g42566 | i0 | 34.2 | 1.50643776824034 | 117 | 76 | 74.7 | 1 | 461 | 114 | 418 | 534 | XP_063713951.1 probable E3 ubiquitin-protein ligase HERC1 [Symsagittifera roscoffensis] | diamond | 702 | 71.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);;