contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1820537 | 1820537 | PRJNA560932_P_NODE_61762_length_244_cov_2.343849_g61406_i0 | PRJNA560932 | 61762 | 244 | 2.343849 | 5.71899156 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 134 | 8.65e-36 | NR | XP_002118061.1 | 10228 | g61406 | i0 | 77.5 | 11.7540983606557 | 80 | 18 | 98.4 | 0 | 240 | 1 | 127 | 206 | XP_002118061.1 uncharacterized protein TRIADDRAFT_33563 [Trichoplax adhaerens] | diamond | 2868 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 24770965 | 24770965 | PRJNA560932_P_NODE_39840_length_288_cov_1.879070_g39484_i0 | PRJNA560932 | 39840 | 288 | 1.87907 | 5.4117216 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 141 | 1.59e-36 | NR | RDD36748.1 | 287889 | g39484 | i0 | 68.8 | 0.96875 | 93 | 29 | 96.9 | 0 | 2 | 280 | 557 | 649 | RDD36748.1 Sodium/potassium-transporting ATPase subunit alpha [Trichoplax sp. H2] | diamond | 279 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 26618147 | 26618147 | PRJNA560932_P_NODE_21561_length_380_cov_2.006515_g21205_i0 | PRJNA560932 | 21561 | 380 | 2.006515 | 7.624757 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 62.8 | 1.03e-8 | NR | XP_002108444.1 | 10228 | g21205 | i0 | 36.8 | 1.62631578947368 | 95 | 55 | 75 | 2 | 90 | 374 | 24 | 113 | XP_002108444.1 uncharacterized protein TRIADDRAFT_18639 [Trichoplax adhaerens] | diamond | 618 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 26920826 | 26920826 | PRJNA560932_P_NODE_25062_length_355_cov_2.585106_g24706_i0 | PRJNA560932 | 25062 | 355 | 2.585106 | 9.1771263 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 64.3 | 1.76e-9 | NR | RDD47504.1 | 287889 | g24706 | i0 | 61.1 | 5.46760563380282 | 54 | 21 | 45.6 | 0 | 305 | 144 | 16 | 69 | RDD47504.1 14-3-3 protein epsilon [Trichoplax sp. H2] | diamond | 1941 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 27015669 | 27015669 | PRJNA560932_P_NODE_25122_length_355_cov_1.429078_g24766_i0 | PRJNA560932 | 25122 | 355 | 1.429078 | 5.0732269 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 113 | 3.0100000000000004e-27 | NR | RDD37143.1 | 287889 | g24766 | i0 | 46.2 | 0.988732394366197 | 117 | 61 | 97.2 | 1 | 353 | 9 | 5 | 121 | RDD37143.1 Dihydroflavonol-4-reductase [Trichoplax sp. H2] | diamond | 351 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 27661845 | 27661845 | PRJNA560932_P_NODE_61744_length_244_cov_3.730994_g61388_i0 | PRJNA560932 | 61744 | 244 | 3.730994 | 9.10362536 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 2.61e-24 | NR | XP_002117205.1 | 10228 | g61388 | i0 | 66.2 | 44.6680327868852 | 74 | 25 | 91 | 0 | 224 | 3 | 7 | 80 | XP_002117205.1 DEAD box ATP-dependent RNA helicase [Trichoplax adhaerens] | diamond | 10899 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28626731 | 28626731 | PRJNA560932_P_NODE_59287_length_246_cov_0.890173_g58931_i0 | PRJNA560932 | 59287 | 246 | 0.890173 | 2.18982558 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 66.2 | 1.96e-10 | NR | XP_002109902.1 | 10228 | g58931 | i0 | 44.4 | 2.96341463414634 | 81 | 43 | 98.8 | 2 | 3 | 245 | 393 | 471 | XP_002109902.1 uncharacterized protein TRIADDRAFT_53278 [Trichoplax adhaerens] | diamond | 729 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28798130 | 28798130 | PRJNA560932_P_NODE_38027_length_295_cov_1.112613_g37671_i0 | PRJNA560932 | 38027 | 295 | 1.112613 | 3.28220835 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 5.4e-35 | NR | XP_002117295.1 | 10228 | g37671 | i0 | 73.1 | 56.9084745762712 | 93 | 25 | 94.6 | 0 | 279 | 1 | 1 | 93 | XP_002117295.1 uncharacterized protein TRIADDRAFT_38421 [Trichoplax adhaerens] | diamond | 16788 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28924455 | 28924455 | PRJNA560932_P_NODE_46848_length_267_cov_1.190722_g46492_i0 | PRJNA560932 | 46848 | 267 | 1.190722 | 3.17922774 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 116 | 7.71e-30 | NR | XP_002109016.1 | 10228 | g46492 | i0 | 65.3 | 2.67415730337079 | 75 | 26 | 84.3 | 0 | 225 | 1 | 6 | 80 | XP_002109016.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 714 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28924457 | 28924457 | PRJNA560932_P_NODE_50748_length_254_cov_1.701657_g50392_i0 | PRJNA560932 | 50748 | 254 | 1.701657 | 4.32220878 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 43.5 | 0.0214 | NR | XP_002115183.1 | 10228 | g50392 | i0 | 33.3 | 2.26771653543307 | 96 | 42 | 94.5 | 3 | 2 | 241 | 173 | 262 | XP_002115183.1 uncharacterized protein TRIADDRAFT_28800 [Trichoplax adhaerens] | diamond | 576 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29114164 | 29114164 | PRJNA560932_P_NODE_27248_length_343_cov_1.829630_g26892_i0 | PRJNA560932 | 27248 | 343 | 1.82963 | 6.2756309 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 2.0399999999999998e-43 | NR | XP_002112452.1 | 10228 | g26892 | i0 | 67.9 | 9.33236151603499 | 106 | 34 | 92.7 | 0 | 321 | 4 | 1 | 106 | XP_002112452.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 3201 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29636493 | 29636493 | PRJNA560932_P_NODE_48830_length_260_cov_2.053476_g48474_i0 | PRJNA560932 | 48830 | 260 | 2.053476 | 5.3390376 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 133 | 7.49e-34 | NR | RDD43292.1 | 287889 | g48474 | i0 | 68.2 | 6.93461538461538 | 85 | 27 | 98.1 | 0 | 259 | 5 | 234 | 318 | RDD43292.1 WASH complex subunit strumpellin [Trichoplax sp. H2] | diamond | 1803 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30219321 | 30219321 | PRJNA560932_P_NODE_11172_length_521_cov_5.004464_g10818_i0 | PRJNA560932 | 11172 | 521 | 5.004464 | 26.07325744 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 218 | 6.24e-70 | NR | XP_002107880.1 | 10228 | g10818 | i0 | 72.1 | 14.4644913627639 | 140 | 39 | 80.6 | 0 | 24 | 443 | 2 | 141 | XP_002107880.1 uncharacterized protein TRIADDRAFT_35244 [Trichoplax adhaerens] | diamond | 7536 | 220 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30661706 | 30661706 | PRJNA560932_P_NODE_29913_length_329_cov_2.019531_g29557_i0 | PRJNA560932 | 29913 | 329 | 2.019531 | 6.64425699 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 145 | 5.16e-41 | NR | XP_002109744.1 | 10228 | g29557 | i0 | 71.4 | 3.83890577507599 | 105 | 29 | 94.8 | 1 | 13 | 324 | 46 | 150 | XP_002109744.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 1263 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 30679131 | 30679131 | PRJNA560932_P_NODE_26493_length_347_cov_2.200730_g26137_i0 | PRJNA560932 | 26493 | 347 | 2.20073 | 7.6365331 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 168 | 9.13e-46 | NR | XP_002110547.1 | 10228 | g26137 | i0 | 65.5 | 5.09221902017291 | 116 | 39 | 99.4 | 1 | 346 | 2 | 704 | 819 | XP_002110547.1 uncharacterized protein TRIADDRAFT_37398 [Trichoplax adhaerens] | diamond | 1767 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31027067 | 31027067 | PRJNA560932_P_NODE_46095_length_269_cov_1.520408_g45739_i0 | PRJNA560932 | 46095 | 269 | 1.520408 | 4.08989752 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 62.8 | 3.87e-9 | NR | XP_002110669.1 | 10228 | g45739 | i0 | 45.2 | 0.691449814126394 | 62 | 34 | 69.1 | 0 | 205 | 20 | 31 | 92 | XP_002110669.1 uncharacterized protein TRIADDRAFT_54918 [Trichoplax adhaerens] | diamond | 186 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31311252 | 31311252 | PRJNA560932_P_NODE_43195_length_278_cov_1.292683_g42839_i0 | PRJNA560932 | 43195 | 278 | 1.292683 | 3.59365874 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 82.4 | 1.82e-16 | NR | RDD44704.1 | 287889 | g42839 | i0 | 45.6 | 0.971223021582734 | 90 | 43 | 96 | 3 | 12 | 278 | 178 | 262 | RDD44704.1 Metallophosphoesterase domain-containing protein 1 [Trichoplax sp. H2] | diamond | 270 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 31501340 | 31501340 | PRJNA560932_P_NODE_56316_length_248_cov_0.880000_g55960_i0 | PRJNA560932 | 56316 | 248 | 0.88 | 2.1824 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 45.4 | 0.0045 | NR | RDD40195.1 | 287889 | g55960 | i0 | 38.7 | 0.907258064516129 | 75 | 38 | 85.9 | 5 | 244 | 32 | 429 | 499 | RDD40195.1 Leishmanolysin-like peptidase [Trichoplax sp. H2] | diamond | 225 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 31690858 | 31690858 | PRJNA560932_P_NODE_3797_length_870_cov_1.766625_g3512_i0 | PRJNA560932 | 3797 | 870 | 1.766625 | 15.3696375 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 82 | 2.41e-13 | NR | RDD40193.1 | 287889 | g3512 | i0 | 40.3 | 0.410344827586207 | 119 | 63 | 40 | 3 | 523 | 870 | 199 | 312 | RDD40193.1 Leishmanolysin-like peptidase [Trichoplax sp. H2] | diamond | 357 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 31704884 | 31704884 | PRJNA560932_P_NODE_13017_length_485_cov_1.220874_g12663_i0 | PRJNA560932 | 13017 | 485 | 1.220874 | 5.9212389 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 1.16e-29 | NR | XP_002111052.1 | 10228 | g12663 | i0 | 54.6 | 3.98350515463918 | 108 | 47 | 65.6 | 1 | 320 | 3 | 35 | 142 | XP_002111052.1 uncharacterized protein TRIADDRAFT_22609 [Trichoplax adhaerens] | diamond | 1932 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32052861 | 32052861 | PRJNA560932_P_NODE_36438_length_301_cov_1.350877_g36082_i0 | PRJNA560932 | 36438 | 301 | 1.350877 | 4.06613977 | Metazoa | 33208 | Placozoa | other_Eukaryota | 68.9 | 1.99e-11 | NR | XP_002116431.1 | 10228 | g36082 | i0 | 50.6 | 1.6046511627907 | 79 | 37 | 77.7 | 2 | 2 | 235 | 160 | 237 | XP_002116431.1 expressed hypothetical protein [Trichoplax adhaerens] | diamond | 483 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32496011 | 32496011 | PRJNA560932_P_NODE_28259_length_338_cov_1.120755_g27903_i0 | PRJNA560932 | 28259 | 338 | 1.120755 | 3.7881519 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 148 | 6.17e-41 | NR | XP_002111582.1 | 10228 | g27903 | i0 | 65.5 | 5.89349112426035 | 110 | 37 | 97.6 | 1 | 332 | 3 | 6 | 114 | XP_002111582.1 uncharacterized protein TRIADDRAFT_50221 [Trichoplax adhaerens] | diamond | 1992 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32796858 | 32796858 | PRJNA560932_P_NODE_12220_length_500_cov_1.323185_g11866_i0 | PRJNA560932 | 12220 | 500 | 1.323185 | 6.615925 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 114 | 5.24e-26 | NR | RDD43316.1 | 287889 | g11866 | i0 | 38.6 | 2.034 | 171 | 91 | 98.4 | 4 | 494 | 3 | 229 | 392 | RDD43316.1 NEDD8-activating enzyme E1 regulatory subunit [Trichoplax sp. H2] | diamond | 1017 | 114 | 1 | 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);;