contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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);;