contig_metadata
18 rows where bioproject = "PRJNA559720" and tax_phylum = "Placozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26871852 | 26871852 | PRJNA559720_P_NODE_12761_length_261_cov_3.111702_g12622_i0 | PRJNA559720 | 12761 | 261 | 3.111702 | 8.12154222 | Metazoa | 33208 | Placozoa | other_Eukaryota | 80.5 | 1.78e-15 | NR | XP_002113673.1 | 10228 | g12622 | i0 | 54.5 | 4.35632183908046 | 66 | 30 | 75.9 | 0 | 198 | 1 | 131 | 196 | XP_002113673.1 uncharacterized protein TRIADDRAFT_26628 [Trichoplax adhaerens] | diamond | 1137 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26920787 | 26920787 | PRJNA559720_P_NODE_5422_length_444_cov_1.231806_g5283_i0 | PRJNA559720 | 5422 | 444 | 1.231806 | 5.46921864 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 187 | 3.03e-53 | NR | XP_002108960.1 | 10228 | g5283 | i0 | 67.2 | 3.31756756756757 | 116 | 38 | 78.4 | 0 | 93 | 440 | 480 | 595 | XP_002108960.1 uncharacterized protein TRIADDRAFT_52481 [Trichoplax adhaerens] | diamond | 1473 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26997883 | 26997883 | PRJNA559720_P_NODE_2442_length_651_cov_2.207612_g2324_i0 | PRJNA559720 | 2442 | 651 | 2.207612 | 14.37155412 | Metazoa | 33208 | Placozoa | other_Eukaryota | 280 | 1.02e-92 | NR | XP_002109400.1 | 10228 | g2324 | i0 | 64.1 | 59.5115207373272 | 195 | 65 | 87.6 | 1 | 586 | 17 | 2 | 196 | XP_002109400.1 protein kinase Ck2-beta, partial [Trichoplax adhaerens] | diamond | 38742 | 281 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26997884 | 26997884 | PRJNA559720_P_NODE_4882_length_469_cov_3.419192_g4744_i0 | PRJNA559720 | 4882 | 469 | 3.419192 | 16.03601048 | Metazoa | 33208 | Placozoa | other_Eukaryota | 165 | 2e-49 | NR | XP_002111299.1 | 10228 | g4744 | i0 | 61.8 | 26.0277185501066 | 123 | 47 | 78.7 | 0 | 64 | 432 | 4 | 126 | XP_002111299.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 12207 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 27472296 | 27472296 | PRJNA559720_P_NODE_5543_length_439_cov_1.792350_g5404_i0 | PRJNA559720 | 5543 | 439 | 1.79235 | 7.8684165 | Metazoa | 33208 | Placozoa | other_Eukaryota | 65.9 | 1.95e-9 | NR | XP_002108054.1 | 10228 | g5404 | i0 | 41 | 4.10706150341686 | 83 | 49 | 56.7 | 0 | 186 | 434 | 183 | 265 | XP_002108054.1 uncharacterized protein TRIADDRAFT_20152 [Trichoplax adhaerens] | diamond | 1803 | 66.2 | 0.995468277945619 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 27742665 | 27742665 | PRJNA559720_P_NODE_304_length_1358_cov_3.496498_g274_i0 | PRJNA559720 | 304 | 1358 | 3.496498 | 47.48244284 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 563 | 2.1499999999999994e-194 | NR | XP_002113591.1 | 10228 | g274 | i0 | 62.4 | 31.000736377025 | 452 | 162 | 99.9 | 2 | 2 | 1357 | 107 | 550 | XP_002113591.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 42099 | 563 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28215725 | 28215725 | PRJNA559720_P_NODE_5446_length_443_cov_1.348649_g5307_i0 | PRJNA559720 | 5446 | 443 | 1.348649 | 5.97451507 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 181 | 1.3299999999999995e-55 | NR | RDD46168.1 | 287889 | g5307 | i0 | 55.6 | 2.88487584650113 | 142 | 60 | 94.1 | 1 | 1 | 417 | 11 | 152 | RDD46168.1 putative ubiquitin-conjugating enzyme E2 W-A [Trichoplax sp. H2] | diamond | 1278 | 181 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 28451153 | 28451153 | PRJNA559720_P_NODE_7286_length_375_cov_1.917219_g7147_i0 | PRJNA559720 | 7286 | 375 | 1.917219 | 7.18957125 | Metazoa | 33208 | Placozoa | other_Eukaryota | 162 | 3.72e-46 | NR | XP_002110768.1 | 10228 | g7147 | i0 | 67.6 | 3.6 | 111 | 36 | 88.8 | 0 | 41 | 373 | 46 | 156 | XP_002110768.1 uncharacterized protein TRIADDRAFT_54013 [Trichoplax adhaerens] | diamond | 1350 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29131753 | 29131753 | PRJNA559720_P_NODE_3569_length_548_cov_1.821053_g3441_i0 | PRJNA559720 | 3569 | 548 | 1.821053 | 9.97937044 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 121 | 3.0899999999999998e-28 | NR | XP_002117163.1 | 10228 | g3441 | i0 | 78.6 | 13.9489051094891 | 182 | 38 | 99.6 | 1 | 546 | 1 | 318 | 498 | XP_002117163.1 uncharacterized protein TRIADDRAFT_51004 [Trichoplax adhaerens] | diamond | 7644 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29447127 | 29447127 | PRJNA559720_P_NODE_3450_length_558_cov_1.769072_g3323_i0 | PRJNA559720 | 3450 | 558 | 1.769072 | 9.87142176 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 180 | 1.02e-48 | NR | XP_002114338.1 | 10228 | g3323 | i0 | 54.6 | 0.876344086021505 | 163 | 71 | 87.6 | 1 | 9 | 497 | 1559 | 1718 | XP_002114338.1 uncharacterized protein TRIADDRAFT_27970 [Trichoplax adhaerens] | diamond | 489 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29604882 | 29604882 | PRJNA559720_P_NODE_6010_length_419_cov_2.121387_g5871_i0 | PRJNA559720 | 6010 | 419 | 2.121387 | 8.88861153 | Placozoa sp. H4 | 1034858 | Placozoa | other_Eukaryota | 110 | 2.28e-27 | NR | AGH70142.1 | 1034858 | g5871 | i0 | 48 | 0.909307875894988 | 127 | 62 | 90.9 | 2 | 393 | 13 | 3 | 125 | AGH70142.1 eukaryotic translation elongation factor 1 gamma, partial [Placozoa sp. H4] | diamond | 381 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Placozoa sp. H4 | |||||
| 29636416 | 29636416 | PRJNA559720_P_NODE_5810_length_427_cov_1.957627_g5671_i0 | PRJNA559720 | 5810 | 427 | 1.957627 | 8.35906729 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 120 | 1.35e-28 | NR | XP_002108910.1 | 10228 | g5671 | i0 | 47.9 | 1.01170960187354 | 144 | 72 | 99.8 | 2 | 1 | 426 | 140 | 282 | XP_002108910.1 uncharacterized protein TRIADDRAFT_12520, partial [Trichoplax adhaerens] | diamond | 432 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29731253 | 29731253 | PRJNA559720_P_NODE_7410_length_372_cov_1.478261_g7271_i0 | PRJNA559720 | 7410 | 372 | 1.478261 | 5.49913092 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 56.2 | 1.62e-7 | NR | RDD46310.1 | 287889 | g7271 | i0 | 49.3 | 0.911290322580645 | 69 | 27 | 55.6 | 2 | 65 | 271 | 28 | 88 | RDD46310.1 cAMP-regulated phosphoprotein 19 [Trichoplax sp. H2] | diamond | 339 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 29984217 | 29984217 | PRJNA559720_P_NODE_3491_length_554_cov_1.752599_g3363_i0 | PRJNA559720 | 3491 | 554 | 1.752599 | 9.70939846 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 140 | 6.1e-38 | NR | XP_002115236.1 | 10228 | g3363 | i0 | 43.9 | 0.925992779783393 | 171 | 96 | 92.6 | 0 | 2 | 514 | 39 | 209 | XP_002115236.1 uncharacterized protein TRIADDRAFT_28979 [Trichoplax adhaerens] | diamond | 513 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30851228 | 30851228 | PRJNA559720_P_NODE_3474_length_555_cov_8.315353_g3346_i0 | PRJNA559720 | 3474 | 555 | 8.315353 | 46.15020915 | Metazoa | 33208 | Placozoa | other_Eukaryota | 172 | 2.53e-51 | NR | XP_002108521.1 | 10228 | g3346 | i0 | 51 | 4.81081081081081 | 151 | 74 | 81.6 | 0 | 12 | 464 | 1 | 151 | XP_002108521.1 uncharacterized protein TRIADDRAFT_19187 [Trichoplax adhaerens] | diamond | 2670 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30995277 | 30995277 | PRJNA559720_P_NODE_5954_length_422_cov_1.318052_g5815_i0 | PRJNA559720 | 5954 | 422 | 1.318052 | 5.56217944 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 134 | 9.99e-36 | NR | RDD47564.1 | 287889 | g5815 | i0 | 49.6 | 1.75592417061611 | 123 | 61 | 87.4 | 1 | 7 | 375 | 169 | 290 | RDD47564.1 Ribosome biogenesis protein BRX1-like protein [Trichoplax sp. H2] | diamond | 741 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 31230260 | 31230260 | PRJNA559720_P_NODE_1855_length_736_cov_1.788839_g1747_i0 | PRJNA559720 | 1855 | 736 | 1.788839 | 13.16585504 | Metazoa | 33208 | Placozoa | other_Eukaryota | 107 | 2.08e-22 | NR | XP_002114918.1 | 10228 | g1747 | i0 | 42.5 | 16.9279891304348 | 127 | 71 | 51 | 1 | 403 | 29 | 1451 | 1577 | XP_002114918.1 uncharacterized protein TRIADDRAFT_10137, partial [Trichoplax adhaerens] | diamond | 12459 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31230261 | 31230261 | PRJNA559720_P_NODE_3395_length_562_cov_2.157464_g3269_i0 | PRJNA559720 | 3395 | 562 | 2.157464 | 12.12494768 | Metazoa | 33208 | Placozoa | other_Eukaryota | 189 | 4.0799999999999994e-57 | NR | XP_002109991.1 | 10228 | g3269 | i0 | 49.2 | 1.99110320284698 | 185 | 94 | 98.8 | 0 | 558 | 4 | 7 | 191 | XP_002109991.1 uncharacterized protein TRIADDRAFT_20955 [Trichoplax adhaerens] | diamond | 1119 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens |
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);;