contig_metadata
19 rows where bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12075068 | 12075068 | PRJNA615351_P_NODE_33330_length_1047_cov_11.698617_g24498_i0 | PRJNA615351 | 33330 | 1047 | 11.698617 | 122.48451999 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 285 | 1.4999999999999998e-91 | NR | XP_002112585.1 | 10228 | g24498 | i0 | 51.6 | 4.85959885386819 | 273 | 125 | 77.1 | 3 | 945 | 139 | 16 | 285 | XP_002112585.1 uncharacterized protein TRIADDRAFT_50332 [Trichoplax adhaerens] | diamond | 5088 | 286 | 0.996503496503496 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26966708 | 26966708 | PRJNA615351_P_NODE_166182_length_169_cov_2.089552_g152082_i0 | PRJNA615351 | 166182 | 169 | 2.089552 | 3.53134288 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 1.04e-29 | NR | XP_002109121.1 | 10228 | g152082 | i0 | 92.9 | 55.6686390532544 | 56 | 4 | 99.4 | 0 | 168 | 1 | 65 | 120 | XP_002109121.1 GTP-binding protein o-rab1 [Trichoplax adhaerens] | diamond | 9408 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 27662186 | 27662186 | PRJNA615351_P_NODE_70724_length_495_cov_1.971739_g56823_i0 | PRJNA615351 | 70724 | 495 | 1.971739 | 9.76010805 | Metazoa | 33208 | Placozoa | other_Eukaryota | 84.7 | 1.43e-15 | NR | RDD43655.1 | 287889 | g56823 | i0 | 43.8 | 1.59393939393939 | 89 | 44 | 50.3 | 2 | 291 | 43 | 424 | 512 | RDD43655.1 ATP-binding cassette sub-family A member 1 [Trichoplax sp. H2] | diamond | 789 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 28059437 | 28059437 | PRJNA615351_P_NODE_152905_length_186_cov_1.324503_g138805_i0 | PRJNA615351 | 152905 | 186 | 1.324503 | 2.46357558 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 58.5 | 1.43e-8 | NR | XP_002107775.1 | 10228 | g138805 | i0 | 78.9 | 4.46774193548387 | 38 | 7 | 61.3 | 1 | 116 | 3 | 1 | 37 | XP_002107775.1 uncharacterized protein TRIADDRAFT_51633 [Trichoplax adhaerens] | diamond | 831 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29133138 | 29133138 | PRJNA615351_P_NODE_105929_length_294_cov_2.482625_g91830_i0 | PRJNA615351 | 105929 | 294 | 2.482625 | 7.2989175 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 79 | 1.29e-14 | NR | XP_002108979.1 | 10228 | g91830 | i0 | 44.4 | 1.64285714285714 | 81 | 45 | 82.7 | 0 | 289 | 47 | 662 | 742 | XP_002108979.1 uncharacterized protein TRIADDRAFT_18255 [Trichoplax adhaerens] | diamond | 483 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29808889 | 29808889 | PRJNA615351_P_NODE_111091_length_276_cov_3.838174_g96992_i0 | PRJNA615351 | 111091 | 276 | 3.838174 | 10.59336024 | Metazoa | 33208 | Placozoa | other_Eukaryota | 82 | 6.86e-16 | NR | XP_002115207.1 | 10228 | g96992 | i0 | 47.8 | 12.7826086956522 | 90 | 45 | 97.8 | 1 | 5 | 274 | 325 | 412 | XP_002115207.1 uncharacterized protein TRIADDRAFT_28705 [Trichoplax adhaerens] | diamond | 3528 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29808890 | 29808890 | PRJNA615351_P_NODE_113811_length_268_cov_1.545064_g99712_i0 | PRJNA615351 | 113811 | 268 | 1.545064 | 4.14077152 | Metazoa | 33208 | Placozoa | other_Eukaryota | 106 | 6.640000000000001e-26 | NR | XP_002111467.1 | 10228 | g99712 | i0 | 62.8 | 2.93283582089552 | 86 | 32 | 96.3 | 0 | 260 | 3 | 9 | 94 | XP_002111467.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 786 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30522759 | 30522759 | PRJNA615351_P_NODE_57033_length_632_cov_3.881072_g44072_i0 | PRJNA615351 | 57033 | 632 | 3.881072 | 24.52837504 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 98.2 | 2.5e-20 | NR | XP_002108248.1 | 10228 | g44072 | i0 | 36.4 | 0.873417721518987 | 184 | 99 | 86.4 | 5 | 632 | 87 | 101 | 268 | XP_002108248.1 uncharacterized protein TRIADDRAFT_52543 [Trichoplax adhaerens] | diamond | 552 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30598700 | 30598700 | PRJNA615351_P_NODE_103713_length_302_cov_8.940075_g89614_i0 | PRJNA615351 | 103713 | 302 | 8.940075 | 26.9990265 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.7 | 3.12e-19 | NR | XP_002116901.1 | 10228 | g89614 | i0 | 61.6 | 40.8973509933775 | 73 | 28 | 72.5 | 0 | 279 | 61 | 1 | 73 | XP_002116901.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 12351 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30902014 | 30902014 | PRJNA615351_P_NODE_37434_length_952_cov_9.332606_g27705_i0 | PRJNA615351 | 37434 | 952 | 9.332606 | 88.84640912 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 128 | 3.0399999999999996e-31 | NR | RDD44073.1 | 287889 | g27705 | i0 | 33.8 | 0.690126050420168 | 219 | 127 | 65.2 | 4 | 896 | 276 | 16 | 228 | RDD44073.1 COP9 signalosome complex subunit 7b [Trichoplax sp. H2] | diamond | 657 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30946586 | 30946586 | PRJNA615351_P_NODE_183194_length_153_cov_1.694915_g169094_i0 | PRJNA615351 | 183194 | 153 | 1.694915 | 2.59321995 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 49.7 | 3.78e-5 | NR | XP_002117932.1 | 10228 | g169094 | i0 | 40 | 3.90196078431373 | 50 | 30 | 98 | 0 | 2 | 151 | 125 | 174 | XP_002117932.1 uncharacterized protein TRIADDRAFT_33274 [Trichoplax adhaerens] | diamond | 597 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31198690 | 31198690 | PRJNA615351_P_NODE_10315_length_2012_cov_16.203844_g7377_i1 | PRJNA615351 | 10315 | 2012 | 16.203844 | 326.02134128 | Metazoa | 33208 | Placozoa | other_Eukaryota | 63.5 | 1.09e-6 | NR | XP_002112083.1 | 10228 | g7377 | i1 | 27.3 | 1.61779324055666 | 165 | 104 | 22.4 | 4 | 1761 | 1312 | 83 | 246 | XP_002112083.1 uncharacterized protein TRIADDRAFT_63876 [Trichoplax adhaerens] | diamond | 3255 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31230605 | 31230605 | PRJNA615351_P_NODE_117755_length_256_cov_2.714932_g103656_i0 | PRJNA615351 | 117755 | 256 | 2.714932 | 6.95022592 | Metazoa | 33208 | Placozoa | other_Eukaryota | 59.7 | 1.07e-8 | NR | XP_002108656.1 | 10228 | g103656 | i0 | 41.8 | 4.30078125 | 55 | 32 | 64.5 | 0 | 81 | 245 | 83 | 137 | XP_002108656.1 uncharacterized protein TRIADDRAFT_5340, partial [Trichoplax adhaerens] | diamond | 1101 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31736685 | 31736685 | PRJNA615351_P_NODE_10297_length_2013_cov_16.885743_g7377_i0 | PRJNA615351 | 10297 | 2013 | 16.885743 | 339.91000659 | Metazoa | 33208 | Placozoa | other_Eukaryota | 63.5 | 1.09e-6 | NR | XP_002112083.1 | 10228 | g7377 | i0 | 27.3 | 1.61698956780924 | 165 | 104 | 22.4 | 4 | 1762 | 1313 | 83 | 246 | XP_002112083.1 uncharacterized protein TRIADDRAFT_63876 [Trichoplax adhaerens] | diamond | 3255 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32103537 | 32103537 | PRJNA615351_P_NODE_25118_length_1276_cov_3.976632_g18289_i0 | PRJNA615351 | 25118 | 1276 | 3.976632 | 50.74182432 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 155 | 8.159999999999999e-37 | NR | XP_002108283.1 | 10228 | g18289 | i0 | 35 | 1.51175548589342 | 326 | 185 | 75.9 | 8 | 1188 | 220 | 881 | 1182 | XP_002108283.1 uncharacterized protein TRIADDRAFT_49802 [Trichoplax adhaerens] | diamond | 1929 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32325520 | 32325520 | PRJNA615351_P_NODE_83059_length_406_cov_1.654987_g69005_i0 | PRJNA615351 | 83059 | 406 | 1.654987 | 6.71924722 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 146 | 1.59e-42 | NR | XP_002116073.1 | 10228 | g69005 | i0 | 61.2 | 0.894088669950739 | 121 | 47 | 89.4 | 0 | 399 | 37 | 1 | 121 | XP_002116073.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 363 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32433113 | 32433113 | PRJNA615351_P_NODE_120779_length_248_cov_1.981221_g106679_i0 | PRJNA615351 | 120779 | 248 | 1.981221 | 4.91342808 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 93.6 | 6.550000000000001e-21 | NR | XP_002115366.1 | 10228 | g106679 | i0 | 69.8 | 1.5241935483871 | 63 | 19 | 76.2 | 0 | 59 | 247 | 1 | 63 | XP_002115366.1 uncharacterized protein TRIADDRAFT_59214 [Trichoplax adhaerens] | diamond | 378 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32546820 | 32546820 | PRJNA615351_P_NODE_48999_length_742_cov_2.038190_g37063_i0 | PRJNA615351 | 48999 | 742 | 2.03819 | 15.1233698 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 90.1 | 6.83e-18 | NR | XP_002111414.1 | 10228 | g37063 | i0 | 40.6 | 0.428571428571429 | 106 | 56 | 42.9 | 1 | 600 | 283 | 3 | 101 | XP_002111414.1 uncharacterized protein TRIADDRAFT_24368 [Trichoplax adhaerens] | diamond | 318 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32905759 | 32905759 | PRJNA615351_P_NODE_150100_length_190_cov_1.129032_g136000_i0 | PRJNA615351 | 150100 | 190 | 1.129032 | 2.1451608 | Metazoa | 33208 | Placozoa | other_Eukaryota | 85.5 | 1.52e-17 | NR | RDD44899.1 | 287889 | g136000 | i0 | 61.3 | 4.86315789473684 | 62 | 24 | 97.9 | 0 | 3 | 188 | 405 | 466 | RDD44899.1 Stress-induced-phosphoprotein 1 [Trichoplax sp. H2] | diamond | 924 | 85.9 | 0.9953434225844 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 |
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);;