contig_metadata
14 rows where bioproject = "PRJNA745553", tax_kingdom = "Metazoa" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2000436 | 2000436 | PRJNA745553_S_NODE_4562_length_520_cov_2.724832_g4372_i0 | PRJNA745553 | 4562 | 520 | 2.724832 | 14.1691264 | Ceratomyxa arcuata | 1578846 | Cnidaria | other_Eukaryota | 104 | 1.39e-17 | NTclustered | gi|728851402|gb|KJ419342.1| | 1578846 | g4372 | i0 | 87.097 | 0.178846153846154 | 93 | 10 | 18 | 2 | 54 | 146 | 399 | 309 | Ceratomyxa arcuata isolate 302 large subunit ribosomal RNA gene, partial sequence | blastn | 93 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa arcuata | |
| 3275463 | 3275463 | PRJNA745553_S_NODE_17983_length_291_cov_2.435780_g17788_i0 | PRJNA745553 | 17983 | 291 | 2.43578 | 7.0881198 | Ceratomyxa ayami | 1579381 | Cnidaria | other_Eukaryota | 58.4 | 5.79e-4 | NTclustered | gi|730837045|gb|KM392429.1| | 1579381 | g17788 | i0 | 100 | 0.302405498281787 | 31 | 0 | 11 | 0 | 75 | 105 | 1206 | 1236 | Ceratomyxa ayami isolate LJ-Lepto 28S ribosomal RNA gene, partial sequence | blastn | 88 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa ayami | |
| 3750434 | 3750434 | PRJNA745553_S_NODE_29823_length_213_cov_2.685714_g29628_i0 | PRJNA745553 | 29823 | 213 | 2.685714 | 5.72057082 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 84.2 | 6.65e-12 | NTclustered | gi|384482801|gb|JQ690376.1| | 378740 | g29628 | i0 | 88.571 | 28.5586854460094 | 70 | 6 | 32 | 2 | 79 | 147 | 2166 | 2098 | Henneguya doneci isolate 8-3 28S ribosomal RNA gene, partial sequence | blastn | 6083 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya doneci | |
| 4552819 | 4552819 | PRJNA745553_S_NODE_28264_length_231_cov_2.436709_g28069_i0 | PRJNA745553 | 28264 | 231 | 2.436709 | 5.62879779 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 1.23e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g28069 | i0 | 100 | 2.88311688311688 | 32 | 0 | 14 | 0 | 134 | 165 | 6365 | 6334 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 5827761 | 5827761 | PRJNA745553_S_NODE_18365_length_288_cov_3.209302_g18170_i0 | PRJNA745553 | 18365 | 288 | 3.209302 | 9.24278976 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 136 | 3.07e-36 | NR | XP_066933787.1 | 252671 | g18170 | i0 | 78.6 | 0.875 | 84 | 18 | 87.5 | 0 | 286 | 35 | 311 | 394 | XP_066933787.1 large ribosomal subunit protein uL3-like [Clytia hemisphaerica] | diamond | 252 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 5827787 | 5827787 | PRJNA745553_S_NODE_19785_length_278_cov_1.882927_g19590_i0 | PRJNA745553 | 19785 | 278 | 1.882927 | 5.23453706 | Kudoa carcharhini | 858677 | Cnidaria | other_Eukaryota | 73.1 | 1.96e-8 | NTclustered | gi|300089085|gb|GU446630.1| | 858677 | g19590 | i0 | 92.157 | 13.9352517985612 | 51 | 4 | 18 | 0 | 204 | 254 | 88 | 38 | Kudoa carcharhini isolate Cc1 28S ribosomal RNA gene, partial sequence | blastn | 3874 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Multivalvulida | Kudoidae | Kudoa | Kudoa carcharhini | |
| 8377762 | 8377762 | PRJNA745553_S_NODE_5667_length_482_cov_8.506112_g5473_i0 | PRJNA745553 | 5667 | 482 | 8.506112 | 40.99945984 | root | 1 | Root_unresolved | Root_unresolved | 79.3 | 6.51e-14 | NR | XP_047123121.1 | 6087 | g5473 | i0 | 58.7 | 5.39626556016598 | 92 | 24 | 48.5 | 1 | 7 | 240 | 254 | 345 | XP_047123121.1 calreticulin isoform X2 [Hydra vulgaris] | diamond | 2601 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 9652680 | 9652680 | PRJNA745553_S_NODE_23988_length_252_cov_4.000000_g23793_i0 | PRJNA745553 | 23988 | 252 | 4 | 10.08 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g23793 | i0 | 96.875 | 0.126984126984127 | 32 | 0 | 12 | 1 | 172 | 202 | 78621514 | 78621483 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 10928408 | 10928408 | PRJNA745553_S_NODE_7129_length_443_cov_4.305405_g6935_i0 | PRJNA745553 | 7129 | 443 | 4.305405 | 19.07294415 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 158 | 1.25e-46 | NR | XP_057312441.1 | 13093 | g6935 | i0 | 79.8 | 28.8893905191874 | 99 | 19 | 66.4 | 1 | 85 | 378 | 35 | 133 | XP_057312441.1 uncharacterized protein LOC130653961 [Hydractinia symbiolongicarpus] | diamond | 12798 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 22876197 | 22876197 | PRJNA745553_S_NODE_24958_length_248_cov_3.382857_g24763_i0 | PRJNA745553 | 24958 | 248 | 3.382857 | 8.38948536 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 63.9 | 1.04e-5 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g24763 | i0 | 100 | 134.286290322581 | 34 | 0 | 14 | 0 | 1 | 34 | 10560016 | 10560049 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 33303 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26799509 | 26799509 | PRJNA745553_S_NODE_15101_length_317_cov_2.315574_g14906_i0 | PRJNA745553 | 15101 | 317 | 2.315574 | 7.34036958 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 79 | 3.69e-16 | NR | XP_029195141.1 | 45264 | g14906 | i0 | 54.3 | 6.87066246056782 | 81 | 37 | 76.7 | 0 | 315 | 73 | 55 | 135 | XP_029195141.1 60S ribosomal protein L14-like [Acropora millepora] | diamond | 2178 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29683376 | 29683376 | PRJNA745553_S_NODE_7710_length_429_cov_4.042135_g7515_i0 | PRJNA745553 | 7710 | 429 | 4.042135 | 17.34075915 | root | 1 | Root_unresolved | Root_unresolved | 117 | 2.24e-27 | NR | XP_066918755.1 | 252671 | g7515 | i0 | 56.9 | 3.94405594405594 | 116 | 50 | 81.1 | 0 | 20 | 367 | 724 | 839 | XP_066918755.1 major vault protein-like isoform X2 [Clytia hemisphaerica] | diamond | 1692 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30747887 | 30747887 | PRJNA745553_S_NODE_29794_length_213_cov_4.600000_g29599_i0 | PRJNA745553 | 29794 | 213 | 4.6 | 9.798 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 48.5 | 2.32e-4 | NR | XP_022790761.1 | 50429 | g29599 | i0 | 59 | 2.19718309859155 | 39 | 16 | 54.9 | 0 | 179 | 63 | 2341 | 2379 | XP_022790761.1 supervillin-like isoform X1 [Stylophora pistillata] | diamond | 468 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30905978 | 30905978 | PRJNA745553_S_NODE_17474_length_295_cov_3.509009_g17279_i0 | PRJNA745553 | 17474 | 295 | 3.509009 | 10.35157655 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 46.2 | 0.00437 | NR | XP_027046295.1 | 46731 | g17279 | i0 | 54.1 | 1.49491525423729 | 37 | 17 | 37.6 | 0 | 10 | 120 | 571 | 607 | XP_027046295.1 uncharacterized protein LOC113674021 [Pocillopora damicornis] | diamond | 441 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis |
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);;