contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18562609 | 18562609 | PRJNA724011_P_NODE_74135_length_290_cov_1.751152_g73112_i0 | PRJNA724011 | 74135 | 290 | 1.751152 | 5.0783408 | Placozoa sp. H4 | 1034858 | Placozoa | other_Eukaryota | 157 | 2.3e-46 | NR | AGH70213.1 | 1034858 | g73112 | i0 | 77.1 | 4.9551724137931 | 96 | 22 | 99.3 | 0 | 2 | 289 | 58 | 153 | AGH70213.1 40S ribosomal protein SA, partial [Placozoa sp. H4] | diamond | 1437 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Placozoa sp. H4 | |||||
| 20320445 | 20320445 | PRJNA724011_P_NODE_74096_length_290_cov_1.907834_g73073_i0 | PRJNA724011 | 74096 | 290 | 1.907834 | 5.5327186 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 3.35e-22 | NR | XP_002114869.1 | 10228 | g73073 | i0 | 50.5 | 12.5379310344828 | 95 | 46 | 97.2 | 1 | 286 | 5 | 823 | 917 | XP_002114869.1 uncharacterized protein TRIADDRAFT_58816 [Trichoplax adhaerens] | diamond | 3636 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26988713 | 26988713 | PRJNA724011_P_NODE_77422_length_283_cov_1.342857_g76399_i0 | PRJNA724011 | 77422 | 283 | 1.342857 | 3.80028531 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 94 | 4.13e-20 | NR | XP_002117513.1 | 10228 | g76399 | i0 | 47.3 | 0.964664310954064 | 91 | 47 | 96.5 | 1 | 281 | 9 | 339 | 428 | XP_002117513.1 uncharacterized protein TRIADDRAFT_61540 [Trichoplax adhaerens] | diamond | 273 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 27463151 | 27463151 | PRJNA724011_P_NODE_71743_length_296_cov_1.381166_g70720_i0 | PRJNA724011 | 71743 | 296 | 1.381166 | 4.08825136 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 62.4 | 8.74e-9 | NR | RDD46485.1 | 287889 | g70720 | i0 | 41.6 | 0.780405405405405 | 77 | 45 | 78 | 0 | 1 | 231 | 663 | 739 | RDD46485.1 WD repeat-containing protein 27 [Trichoplax sp. H2] | diamond | 231 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 27789171 | 27789171 | PRJNA724011_P_NODE_19944_length_657_cov_3.013699_g18934_i0 | PRJNA724011 | 19944 | 657 | 3.013699 | 19.80000243 | Metazoa | 33208 | Placozoa | other_Eukaryota | 149 | 1.02e-41 | NR | XP_002114836.1 | 10228 | g18934 | i0 | 54.7 | 7.24200913242009 | 128 | 55 | 58.4 | 2 | 243 | 626 | 30 | 154 | XP_002114836.1 uncharacterized protein TRIADDRAFT_58731 [Trichoplax adhaerens] | diamond | 4758 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28010360 | 28010360 | PRJNA724011_P_NODE_82665_length_272_cov_1.140704_g81642_i0 | PRJNA724011 | 82665 | 272 | 1.140704 | 3.10271488 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 62 | 4.82e-9 | NR | XP_002108973.1 | 10228 | g81642 | i0 | 40.8 | 2.16176470588235 | 98 | 42 | 99.3 | 5 | 2 | 271 | 112 | 201 | XP_002108973.1 uncharacterized protein TRIADDRAFT_52506 [Trichoplax adhaerens] | diamond | 588 | 62.4 | 0.993589743589744 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28315554 | 28315554 | PRJNA724011_P_NODE_53486_length_352_cov_1.376344_g52463_i0 | PRJNA724011 | 53486 | 352 | 1.376344 | 4.84473088 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 103 | 2.1e-23 | NR | RDD46965.1 | 287889 | g52463 | i0 | 50.5 | 0.84375 | 99 | 49 | 84.4 | 0 | 4 | 300 | 275 | 373 | RDD46965.1 DnaJ-like protein subfamily A member 2 [Trichoplax sp. H2] | diamond | 297 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 28631396 | 28631396 | PRJNA724011_P_NODE_22787_length_602_cov_1.697543_g21773_i0 | PRJNA724011 | 22787 | 602 | 1.697543 | 10.21920886 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 50.4 | 0.00197 | NR | XP_002109935.1 | 10228 | g21773 | i0 | 34.9 | 1.84883720930233 | 63 | 41 | 31.4 | 0 | 279 | 467 | 40 | 102 | XP_002109935.1 uncharacterized protein TRIADDRAFT_53345 [Trichoplax adhaerens] | diamond | 1113 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28883708 | 28883708 | PRJNA724011_P_NODE_45248_length_389_cov_2.436709_g44225_i0 | PRJNA724011 | 45248 | 389 | 2.436709 | 9.47879801 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 50.4 | 3.84e-4 | NR | RDD40781.1 | 287889 | g44225 | i0 | 33.8 | 1.03341902313625 | 77 | 44 | 58.6 | 2 | 386 | 159 | 841 | 911 | RDD40781.1 WD repeat-containing protein 60 [Trichoplax sp. H2] | diamond | 402 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 29241544 | 29241544 | PRJNA724011_P_NODE_66129_length_311_cov_1.294118_g65106_i0 | PRJNA724011 | 66129 | 311 | 1.294118 | 4.02470698 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 0.0015 | NR | XP_002108278.1 | 10228 | g65106 | i0 | 47.5 | 1.67845659163987 | 40 | 21 | 38.6 | 0 | 11 | 130 | 175 | 214 | XP_002108278.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 522 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29925980 | 29925980 | PRJNA724011_P_NODE_78391_length_281_cov_1.110577_g77368_i0 | PRJNA724011 | 78391 | 281 | 1.110577 | 3.12072137 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 54.7 | 3.82e-6 | NR | RDD41829.1 | 287889 | g77368 | i0 | 33 | 1.95373665480427 | 91 | 59 | 95 | 1 | 8 | 274 | 473 | 563 | RDD41829.1 Nuclear pore membrane glycoprotein 210 [Trichoplax sp. H2] | diamond | 549 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 29936288 | 29936288 | PRJNA724011_P_NODE_32211_length_483_cov_2.148780_g31192_i0 | PRJNA724011 | 32211 | 483 | 2.14878 | 10.3786074 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 156 | 2.2099999999999993e-43 | NR | XP_002115320.1 | 10228 | g31192 | i0 | 46.1 | 4.93167701863354 | 165 | 79 | 99.4 | 4 | 483 | 4 | 73 | 232 | XP_002115320.1 uncharacterized protein TRIADDRAFT_29280 [Trichoplax adhaerens] | diamond | 2382 | 157 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30694445 | 30694445 | PRJNA724011_P_NODE_4793_length_1428_cov_4.422140_g4280_i0 | PRJNA724011 | 4793 | 1428 | 4.42214 | 63.1481592 | Metazoa | 33208 | Placozoa | other_Eukaryota | 405 | 4.31e-134 | NR | XP_002108773.1 | 10228 | g4280 | i0 | 54.8 | 7.51050420168067 | 392 | 160 | 82.4 | 8 | 253 | 1428 | 8 | 382 | XP_002108773.1 uncharacterized protein TRIADDRAFT_52087 [Trichoplax adhaerens] | diamond | 10725 | 409 | 0.990220048899755 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30715513 | 30715513 | PRJNA724011_P_NODE_103294_length_245_cov_0.895349_g102271_i0 | PRJNA724011 | 103294 | 245 | 0.895349 | 2.19360505 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 44.3 | 0.0108 | NR | XP_002114868.1 | 10228 | g102271 | i0 | 35 | 0.979591836734694 | 80 | 45 | 95.5 | 4 | 4 | 237 | 354 | 428 | XP_002114868.1 uncharacterized protein TRIADDRAFT_28582, partial [Trichoplax adhaerens] | diamond | 240 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30778907 | 30778907 | PRJNA724011_P_NODE_69874_length_301_cov_1.293860_g68851_i0 | PRJNA724011 | 69874 | 301 | 1.29386 | 3.8945186 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 74.7 | 4.61e-13 | NR | XP_002108913.1 | 10228 | g68851 | i0 | 46.5 | 3.88704318936877 | 99 | 53 | 98.7 | 0 | 300 | 4 | 2712 | 2810 | XP_002108913.1 uncharacterized protein TRIADDRAFT_18356 [Trichoplax adhaerens] | diamond | 1170 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31010358 | 31010358 | PRJNA724011_P_NODE_101834_length_246_cov_0.890173_g100811_i0 | PRJNA724011 | 101834 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.6 | 2.8e-5 | NR | XP_002110503.1 | 10228 | g100811 | i0 | 53.8 | 3.17073170731707 | 39 | 18 | 47.6 | 0 | 122 | 6 | 181 | 219 | XP_002110503.1 uncharacterized protein TRIADDRAFT_22351, partial [Trichoplax adhaerens] | diamond | 780 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31073698 | 31073698 | PRJNA724011_P_NODE_86135_length_265_cov_1.453125_g85112_i0 | PRJNA724011 | 86135 | 265 | 1.453125 | 3.85078125 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 125 | 2.1699999999999997e-31 | NR | XP_002107894.1 | 10228 | g85112 | i0 | 78.2 | 2.75094339622642 | 78 | 16 | 88.3 | 1 | 235 | 2 | 71 | 147 | XP_002107894.1 uncharacterized protein TRIADDRAFT_63495 [Trichoplax adhaerens] | diamond | 729 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31189212 | 31189212 | PRJNA724011_P_NODE_34475_length_463_cov_3.284615_g33456_i0 | PRJNA724011 | 34475 | 463 | 3.284615 | 15.20776745 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 55.8 | 1.04e-5 | NR | RDD40440.1 | 287889 | g33456 | i0 | 31.9 | 0.913606911447084 | 72 | 48 | 46.7 | 1 | 463 | 248 | 786 | 856 | RDD40440.1 Kinesin-like protein KIF28P [Trichoplax sp. H2] | diamond | 423 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 31263250 | 31263250 | PRJNA724011_P_NODE_85155_length_267_cov_1.262887_g84132_i0 | PRJNA724011 | 85155 | 267 | 1.262887 | 3.37190829 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 107 | 6.76e-25 | NR | XP_002111828.1 | 10228 | g84132 | i0 | 56.3 | 3.87640449438202 | 87 | 38 | 97.8 | 0 | 265 | 5 | 59 | 145 | XP_002111828.1 uncharacterized protein TRIADDRAFT_23475 [Trichoplax adhaerens] | diamond | 1035 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31411058 | 31411058 | PRJNA724011_P_NODE_58116_length_335_cov_2.187023_g57093_i0 | PRJNA724011 | 58116 | 335 | 2.187023 | 7.32652705 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 71.2 | 1.1e-11 | NR | RDD40195.1 | 287889 | g57093 | i0 | 37.6 | 1.04776119402985 | 117 | 55 | 98.5 | 5 | 335 | 6 | 282 | 387 | RDD40195.1 Leishmanolysin-like peptidase [Trichoplax sp. H2] | diamond | 351 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 32339080 | 32339080 | PRJNA724011_P_NODE_77819_length_282_cov_1.468900_g76796_i0 | PRJNA724011 | 77819 | 282 | 1.4689 | 4.142298 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.1 | 1.69e-19 | NR | XP_002116901.1 | 10228 | g76796 | i0 | 61.6 | 33.3085106382979 | 73 | 28 | 77.7 | 0 | 18 | 236 | 1 | 73 | XP_002116901.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 9393 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32686111 | 32686111 | PRJNA724011_P_NODE_2920_length_1747_cov_21.584827_g2555_i0 | PRJNA724011 | 2920 | 1747 | 21.584827 | 377.08692769 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 251 | 4.86e-72 | NR | RDD44899.1 | 287889 | g2555 | i0 | 36.6 | 2.93989696622782 | 577 | 333 | 96.7 | 8 | 1743 | 55 | 6 | 563 | RDD44899.1 Stress-induced-phosphoprotein 1 [Trichoplax sp. H2] | diamond | 5136 | 253 | 0.992094861660079 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 32717792 | 32717792 | PRJNA724011_P_NODE_1680_length_2136_cov_3.865730_g1434_i0 | PRJNA724011 | 1680 | 2136 | 3.86573 | 82.5719928 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 84.7 | 6.57e-15 | NR | XP_002108656.1 | 10228 | g1434 | i0 | 36.1 | 0.976123595505618 | 166 | 97 | 23 | 4 | 2093 | 1602 | 3 | 161 | XP_002108656.1 uncharacterized protein TRIADDRAFT_5340, partial [Trichoplax adhaerens] | diamond | 2085 | 84.7 | 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);;