contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 780588 | 780588 | PRJNA796753_P_NODE_16401_length_355_cov_2.120567_g16089_i0 | PRJNA796753 | 16401 | 355 | 2.120567 | 7.52801285 | Placozoa sp. H4 | 1034858 | Placozoa | other_Eukaryota | 182 | 5.71e-56 | NR | AGH70192.1 | 1034858 | g16089 | i0 | 76.3 | 2.89859154929577 | 114 | 27 | 96.3 | 0 | 346 | 5 | 1 | 114 | AGH70192.1 40S ribosomal protein S8 [Placozoa sp. H4] | diamond | 1029 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Placozoa sp. H4 | |||||
| 780618 | 780618 | PRJNA796753_P_NODE_22581_length_314_cov_0.958506_g22269_i0 | PRJNA796753 | 22581 | 314 | 0.958506 | 3.00970884 | Metazoa | 33208 | Placozoa | other_Eukaryota | 142 | 8.979999999999999e-37 | NR | XP_002109035.1 | 10228 | g22269 | i0 | 63.9 | 26.0636942675159 | 108 | 32 | 96.5 | 1 | 305 | 3 | 327 | 434 | XP_002109035.1 uncharacterized protein TRIADDRAFT_37096 [Trichoplax adhaerens] | diamond | 8184 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 13970698 | 13970698 | PRJNA796753_P_NODE_48271_length_245_cov_0.895349_g47959_i0 | PRJNA796753 | 48271 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 8.51e-39 | NR | XP_002115244.1 | 10228 | g47959 | i0 | 84 | 71.4122448979592 | 81 | 13 | 99.2 | 0 | 243 | 1 | 848 | 928 | XP_002115244.1 uncharacterized protein TRIADDRAFT_59226 [Trichoplax adhaerens] | diamond | 17496 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26642264 | 26642264 | PRJNA796753_P_NODE_11401_length_413_cov_1.585294_g11089_i0 | PRJNA796753 | 11401 | 413 | 1.585294 | 6.54726422 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 113 | 1.99e-28 | NR | RDD47936.1 | 287889 | g11089 | i0 | 45.9 | 0.980629539951574 | 135 | 69 | 97.3 | 3 | 409 | 8 | 72 | 203 | RDD47936.1 Thioredoxin-like protein AAED1 [Trichoplax sp. H2] | diamond | 405 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 26927280 | 26927280 | PRJNA796753_P_NODE_21442_length_320_cov_1.668016_g21130_i0 | PRJNA796753 | 21442 | 320 | 1.668016 | 5.3376512 | Placozoa sp. H4 | 1034858 | Placozoa | other_Eukaryota | 155 | 1.48e-45 | NR | AGH70192.1 | 1034858 | g21130 | i0 | 74.8 | 2.896875 | 103 | 26 | 96.6 | 0 | 10 | 318 | 1 | 103 | AGH70192.1 40S ribosomal protein S8 [Placozoa sp. H4] | diamond | 927 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Placozoa sp. H4 | |||||
| 27062973 | 27062973 | PRJNA796753_P_NODE_53482_length_241_cov_1.505952_g53170_i0 | PRJNA796753 | 53482 | 241 | 1.505952 | 3.62934432 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84 | 1.14e-16 | NR | RDD39148.1 | 287889 | g53170 | i0 | 48.8 | 4.80497925311203 | 86 | 38 | 99.6 | 2 | 1 | 240 | 568 | 653 | RDD39148.1 Importin-5 [Trichoplax sp. H2] | diamond | 1158 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 27180030 | 27180030 | PRJNA796753_P_NODE_25922_length_295_cov_1.387387_g25610_i0 | PRJNA796753 | 25922 | 295 | 1.387387 | 4.09279165 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 55.8 | 1.69e-6 | NR | RDD41986.1 | 287889 | g25610 | i0 | 37.6 | 2.68474576271186 | 85 | 53 | 86.4 | 0 | 12 | 266 | 266 | 350 | RDD41986.1 Transient receptor potential cation channel subfamily V member 6 [Trichoplax sp. H2] | diamond | 792 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 28484233 | 28484233 | PRJNA796753_P_NODE_48186_length_245_cov_0.895349_g47874_i0 | PRJNA796753 | 48186 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 4.630000000000001e-27 | NR | XP_002110045.1 | 10228 | g47874 | i0 | 64.2 | 7.75102040816327 | 81 | 29 | 99.2 | 0 | 243 | 1 | 368 | 448 | XP_002110045.1 uncharacterized protein TRIADDRAFT_63669 [Trichoplax adhaerens] | diamond | 1899 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28578990 | 28578990 | PRJNA796753_P_NODE_30507_length_278_cov_1.502439_g30195_i0 | PRJNA796753 | 30507 | 278 | 1.502439 | 4.17678042 | Metazoa | 33208 | Placozoa | other_Eukaryota | 92.8 | 1.45e-19 | NR | XP_002117957.1 | 10228 | g30195 | i0 | 53.3 | 34.1870503597122 | 92 | 42 | 99.3 | 1 | 1 | 276 | 284 | 374 | XP_002117957.1 uncharacterized protein TRIADDRAFT_51152 [Trichoplax adhaerens] | diamond | 9504 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28696262 | 28696262 | PRJNA796753_P_NODE_52327_length_242_cov_0.911243_g52015_i0 | PRJNA796753 | 52327 | 242 | 0.911243 | 2.20520806 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 77.8 | 1.51e-15 | NR | XP_002115889.1 | 10228 | g52015 | i0 | 52.7 | 5.50413223140496 | 74 | 35 | 91.7 | 0 | 222 | 1 | 118 | 191 | XP_002115889.1 uncharacterized protein TRIADDRAFT_6732, partial [Trichoplax adhaerens] | diamond | 1332 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29106616 | 29106616 | PRJNA796753_P_NODE_29268_length_282_cov_1.961722_g28956_i0 | PRJNA796753 | 29268 | 282 | 1.961722 | 5.53205604 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 93.6 | 8.6e-20 | NR | RDD46159.1 | 287889 | g28956 | i0 | 44 | 0.968085106382979 | 91 | 50 | 96.8 | 1 | 10 | 282 | 901 | 990 | RDD46159.1 Laminin subunit alpha-1 [Trichoplax sp. H2] | diamond | 273 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30726412 | 30726412 | PRJNA796753_P_NODE_36054_length_260_cov_1.251337_g35742_i0 | PRJNA796753 | 36054 | 260 | 1.251337 | 3.2534762 | Metazoa | 33208 | Placozoa | other_Eukaryota | 120 | 1.44e-29 | NR | XP_002114080.1 | 10228 | g35742 | i0 | 67.4 | 2.97692307692308 | 86 | 28 | 99.2 | 0 | 3 | 260 | 238 | 323 | XP_002114080.1 uncharacterized protein TRIADDRAFT_36216 [Trichoplax adhaerens] | diamond | 774 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30812074 | 30812074 | PRJNA796753_P_NODE_11594_length_410_cov_0.887240_g11282_i0 | PRJNA796753 | 11594 | 410 | 0.88724 | 3.637684 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 72 | 1.22e-11 | NR | XP_002118258.1 | 10228 | g11282 | i0 | 45.8 | 1.81463414634146 | 83 | 41 | 57.8 | 1 | 396 | 160 | 347 | 429 | XP_002118258.1 uncharacterized protein TRIADDRAFT_33849 [Trichoplax adhaerens] | diamond | 744 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31136942 | 31136942 | PRJNA796753_P_NODE_34715_length_264_cov_1.612565_g34403_i0 | PRJNA796753 | 34715 | 264 | 1.612565 | 4.2571716 | Metazoa | 33208 | Placozoa | other_Eukaryota | 69.7 | 8.34e-12 | NR | XP_002111032.1 | 10228 | g34403 | i0 | 41.4 | 5.90909090909091 | 87 | 49 | 98.9 | 1 | 262 | 2 | 40 | 124 | XP_002111032.1 uncharacterized protein TRIADDRAFT_22477 [Trichoplax adhaerens] | diamond | 1560 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31190952 | 31190952 | PRJNA796753_P_NODE_35715_length_261_cov_1.393617_g35403_i0 | PRJNA796753 | 35715 | 261 | 1.393617 | 3.63734037 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 111 | 3.71e-26 | NR | RDD44588.1 | 287889 | g35403 | i0 | 55.8 | 6.91954022988506 | 86 | 38 | 98.9 | 0 | 260 | 3 | 762 | 847 | RDD44588.1 Telomerase protein component 1 [Trichoplax sp. H2] | diamond | 1806 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 31295253 | 31295253 | PRJNA796753_P_NODE_32735_length_271_cov_1.505051_g32423_i0 | PRJNA796753 | 32735 | 271 | 1.505051 | 4.07868821 | Metazoa | 33208 | Placozoa | other_Eukaryota | 97.4 | 3.2500000000000003e-21 | NR | RDD42008.1 | 287889 | g32423 | i0 | 53 | 3.71955719557196 | 83 | 39 | 91.9 | 0 | 16 | 264 | 1072 | 1154 | RDD42008.1 Lipoxygenase homology domain-containing protein 1 [Trichoplax sp. H2] | diamond | 1008 | 97.8 | 0.995910020449898 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 32686579 | 32686579 | PRJNA796753_P_NODE_53340_length_241_cov_2.125000_g53028_i0 | PRJNA796753 | 53340 | 241 | 2.125 | 5.12125 | Metazoa | 33208 | Placozoa | other_Eukaryota | 124 | 9.83e-31 | NR | XP_002112294.1 | 10228 | g53028 | i0 | 68.4 | 38.3526970954357 | 79 | 25 | 98.3 | 0 | 239 | 3 | 652 | 730 | XP_002112294.1 uncharacterized protein TRIADDRAFT_24890 [Trichoplax adhaerens] | diamond | 9243 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32897883 | 32897883 | PRJNA796753_P_NODE_53900_length_241_cov_0.916667_g53588_i0 | PRJNA796753 | 53900 | 241 | 0.916667 | 2.20916747 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 58.5 | 1.02e-7 | NR | XP_002115244.1 | 10228 | g53588 | i0 | 43.8 | 2.96265560165975 | 80 | 41 | 99.6 | 2 | 241 | 2 | 421 | 496 | XP_002115244.1 uncharacterized protein TRIADDRAFT_59226 [Trichoplax adhaerens] | diamond | 714 | 58.5 | 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);;