contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26780636 | 26780636 | PRJEB64798_P_NODE_164261_length_181_cov_5.772727_g162495_i0 | PRJEB64798 | 164261 | 181 | 5.772727 | 10.44863587 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 73.9 | 5.58e-14 | NR | XP_002114943.1 | 10228 | g162495 | i0 | 62.5 | 6.64640883977901 | 56 | 21 | 92.8 | 0 | 5 | 172 | 182 | 237 | XP_002114943.1 uncharacterized protein TRIADDRAFT_28580 [Trichoplax adhaerens] | diamond | 1203 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 28195287 | 28195287 | PRJEB64798_P_NODE_188086_length_171_cov_3.040984_g186320_i0 | PRJEB64798 | 188086 | 171 | 3.040984 | 5.20008264 | Metazoa | 33208 | Placozoa | other_Eukaryota | 65.5 | 1.33e-10 | NR | RDD45105.1 | 287889 | g186320 | i0 | 73.7 | 22.8771929824561 | 38 | 10 | 66.7 | 0 | 27 | 140 | 3397 | 3434 | RDD45105.1 Dynein heavy chain 7, axonemal, partial [Trichoplax sp. H2] | diamond | 3912 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 28637710 | 28637710 | PRJEB64798_P_NODE_122827_length_204_cov_5.741935_g121061_i0 | PRJEB64798 | 122827 | 204 | 5.741935 | 11.7135474 | Metazoa | 33208 | Placozoa | other_Eukaryota | 68.6 | 1.83e-11 | NR | XP_002113869.1 | 10228 | g121061 | i0 | 50 | 1.92647058823529 | 66 | 33 | 97.1 | 0 | 198 | 1 | 224 | 289 | XP_002113869.1 uncharacterized protein TRIADDRAFT_26766 [Trichoplax adhaerens] | diamond | 393 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29212928 | 29212928 | PRJEB64798_P_NODE_183629_length_173_cov_1.774194_g181863_i0 | PRJEB64798 | 183629 | 173 | 1.774194 | 3.06935562 | Trichoplax adhaerens | 10228 | Placozoa | other_Eukaryota | 69.7 | 3.19e-12 | NR | XP_002113957.1 | 10228 | g181863 | i0 | 56.4 | 2.93063583815029 | 55 | 24 | 95.4 | 0 | 172 | 8 | 241 | 295 | XP_002113957.1 uncharacterized protein TRIADDRAFT_57914 [Trichoplax adhaerens] | diamond | 507 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29363838 | 29363838 | PRJEB64798_P_NODE_229989_length_158_cov_20.311927_g228223_i0 | PRJEB64798 | 229989 | 158 | 20.311927 | 32.09284466 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 43.9 | 8.92e-4 | NR | EDV20230.1 | 10228 | g228223 | i0 | 60 | 2.16455696202532 | 40 | 15 | 74.1 | 1 | 124 | 8 | 7 | 46 | EDV20230.1 hypothetical protein TRIADDRAFT_32270 [Trichoplax adhaerens] | diamond | 342 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 29402196 | 29402196 | PRJEB64798_P_NODE_206029_length_166_cov_0.888889_g204263_i0 | PRJEB64798 | 206029 | 166 | 0.888889 | 1.47555574 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 61.6 | 2.67e-9 | NR | RDD47835.1 | 287889 | g204263 | i0 | 51.9 | 1.8433734939759 | 52 | 25 | 94 | 0 | 161 | 6 | 255 | 306 | RDD47835.1 UV excision repair protein RAD23-like protein B [Trichoplax sp. H2] | diamond | 306 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30665613 | 30665613 | PRJEB64798_P_NODE_186073_length_172_cov_1.902439_g184307_i0 | PRJEB64798 | 186073 | 172 | 1.902439 | 3.27219508 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 58.9 | 2.72e-8 | NR | RDD41089.1 | 287889 | g184307 | i0 | 52.1 | 0.837209302325581 | 48 | 23 | 83.7 | 0 | 161 | 18 | 1361 | 1408 | RDD41089.1 Dynein heavy chain 10, axonemal [Trichoplax sp. H2] | diamond | 144 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30785105 | 30785105 | PRJEB64798_P_NODE_118034_length_207_cov_7.772152_g116268_i0 | PRJEB64798 | 118034 | 207 | 7.772152 | 16.08835464 | Metazoa | 33208 | Placozoa | other_Eukaryota | 48.5 | 2.05e-4 | NR | RDD38032.1 | 287889 | g116268 | i0 | 61.3 | 1.34782608695652 | 31 | 12 | 44.9 | 0 | 205 | 113 | 88 | 118 | RDD38032.1 Pre-mRNA-splicing factor RBM22 [Trichoplax sp. H2] | diamond | 279 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 30879873 | 30879873 | PRJEB64798_P_NODE_180754_length_174_cov_2.640000_g178988_i0 | PRJEB64798 | 180754 | 174 | 2.64 | 4.5936 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 40.8 | 0.0309 | NR | EDV19269.1 | 10228 | g178988 | i0 | 45.2 | 1.48275862068966 | 42 | 23 | 72.4 | 0 | 161 | 36 | 78 | 119 | EDV19269.1 senescence-associated protein [Trichoplax adhaerens] | diamond | 258 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 31670267 | 31670267 | PRJEB64798_P_NODE_140757_length_193_cov_3.236111_g138991_i0 | PRJEB64798 | 140757 | 193 | 3.236111 | 6.24569423 | Opisthokonta | 33154 | Placozoa | other_Eukaryota | 64.7 | 2.3e-10 | NR | XP_002118089.1 | 10228 | g138991 | i0 | 50 | 17.1761658031088 | 56 | 28 | 87 | 0 | 181 | 14 | 68 | 123 | XP_002118089.1 uncharacterized protein TRIADDRAFT_62139 [Trichoplax adhaerens] | diamond | 3315 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax adhaerens | |
| 32120278 | 32120278 | PRJEB64798_P_NODE_193398_length_169_cov_2.833333_g191632_i0 | PRJEB64798 | 193398 | 169 | 2.833333 | 4.78833277 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 66.6 | 5.19e-11 | NR | RDD45297.1 | 287889 | g191632 | i0 | 75.6 | 3.83431952662722 | 41 | 10 | 72.8 | 0 | 41 | 163 | 1 | 41 | RDD45297.1 V-type proton ATPase 116 kDa subunit a isoform 1 [Trichoplax sp. H2] | diamond | 648 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 32247117 | 32247117 | PRJEB64798_P_NODE_34678_length_335_cov_3.958042_g32920_i0 | PRJEB64798 | 34678 | 335 | 3.958042 | 13.2594407 | Trichoplax sp. H2 | 287889 | Placozoa | other_Eukaryota | 114 | 6.1500000000000005e-27 | NR | RDD38299.1 | 287889 | g32920 | i0 | 65.1 | 0.743283582089552 | 83 | 28 | 74.3 | 1 | 6 | 254 | 170 | 251 | RDD38299.1 Lysosomal alpha-mannosidase [Trichoplax sp. H2] | diamond | 249 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Placozoa | Uniplacotomia | Trichoplacea | Trichoplacidae | Trichoplax | Trichoplax sp. H2 | |
| 32745276 | 32745276 | PRJEB64798_P_NODE_225100_length_160_cov_10.765766_g223334_i0 | PRJEB64798 | 225100 | 160 | 10.765766 | 17.2252256 | Trichoplax | 10227 | Placozoa | other_Eukaryota | 45.1 | 3.14e-4 | NR | EDV20230.1 | 10228 | g223334 | i0 | 64.7 | 2.7 | 34 | 12 | 63.8 | 0 | 36 | 137 | 9 | 42 | EDV20230.1 hypothetical protein TRIADDRAFT_32270 [Trichoplax adhaerens] | diamond | 432 | 45.1 | 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);;