contig_metadata
7 rows where bioproject = "PRJNA397733" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6789873 | 6789873 | PRJNA397733_S_NODE_5586_length_256_cov_3.198238_g5498_i0 | PRJNA397733 | 5586 | 256 | 3.198238 | 8.18748928 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2751572571|ref|XM_059097252.2| | 203993 | g5498 | i0 | 100 | 0.109375 | 28 | 0 | 11 | 0 | 91 | 118 | 4012 | 4039 | PREDICTED: Pocillopora verrucosa exportin-4 (LOC131780638), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 28797222 | 28797222 | PRJNA397733_S_NODE_1367_length_562_cov_5.868668_g1291_i0 | PRJNA397733 | 1367 | 562 | 5.868668 | 32.98191416 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 358 | 2.8399999999999996e-112 | NR | XP_065665842.1 | 6087 | g1291 | i0 | 98.4 | 416.268683274021 | 187 | 3 | 99.8 | 0 | 1 | 561 | 539 | 725 | XP_065665842.1 splicing factor 3B subunit 1 isoform X3 [Hydra vulgaris] | diamond | 233943 | 361 | 0.991689750692521 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29759346 | 29759346 | PRJNA397733_S_NODE_12771_length_170_cov_3.978723_g12683_i0 | PRJNA397733 | 12771 | 170 | 3.978723 | 6.7638291 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 67.4 | 2.39e-12 | NR | CAB3995342.1 | 317549 | g12683 | i0 | 78.9 | 0.670588235294118 | 38 | 8 | 67.1 | 0 | 169 | 56 | 111 | 148 | CAB3995342.1 transposase [Paramuricea clavata] | diamond | 114 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30155035 | 30155035 | PRJNA397733_S_NODE_6192_length_242_cov_4.276995_g6104_i0 | PRJNA397733 | 6192 | 242 | 4.276995 | 10.3503279 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 157 | 3.14e-44 | NR | KAK2561358.1 | 6130 | g6104 | i0 | 98.8 | 79.1280991735537 | 80 | 1 | 99.2 | 0 | 242 | 3 | 267 | 346 | KAK2561358.1 26S proteasome regulatory subunit 8 [Acropora cervicornis] | diamond | 19149 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30850346 | 30850346 | PRJNA397733_S_NODE_16154_length_153_cov_3.822581_g16066_i0 | PRJNA397733 | 16154 | 153 | 3.822581 | 5.84854893 | root | 1 | Root_unresolved | Root_unresolved | 109 | 1.43e-26 | NR | XP_031569504.1 | 6105 | g16066 | i0 | 98 | 358.980392156863 | 51 | 1 | 100 | 0 | 153 | 1 | 44 | 94 | XP_031569504.1 spliceosome RNA helicase Ddx39b [Actinia tenebrosa] | diamond | 54924 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31166065 | 31166065 | PRJNA397733_S_NODE_13455_length_166_cov_3.240876_g13367_i0 | PRJNA397733 | 13455 | 166 | 3.240876 | 5.37985416 | root | 1 | Root_unresolved | Root_unresolved | 114 | 2.21e-29 | NR | XP_031569126.1 | 6105 | g13367 | i0 | 98.1 | 137.277108433735 | 54 | 1 | 97.6 | 0 | 164 | 3 | 122 | 175 | XP_031569126.1 F-actin-capping protein subunit beta-like isoform X1 [Actinia tenebrosa] | diamond | 22788 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31971903 | 31971903 | PRJNA397733_S_NODE_10478_length_186_cov_3.929936_g10390_i0 | PRJNA397733 | 10478 | 186 | 3.929936 | 7.30968096 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 41.2 | 0.0177 | NR | RMX44967.1 | 46731 | g10390 | i0 | 38.6 | 0.919354838709677 | 57 | 35 | 91.9 | 0 | 173 | 3 | 2 | 58 | RMX44967.1 hypothetical protein pdam_00018189 [Pocillopora damicornis] | diamond | 171 | 41.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);;