contig_metadata
13 rows where bioproject = "PRJNA399711", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6791200 | 6791200 | PRJNA399711_P_NODE_19386_length_163_cov_6.920635_g19320_i0 | PRJNA399711 | 19386 | 163 | 6.920635 | 11.28063505 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g19320 | i0 | 100 | 0.177914110429448 | 29 | 0 | 18 | 0 | 135 | 163 | 10980753 | 10980725 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 24639799 | 24639799 | PRJNA399711_P_NODE_13260_length_181_cov_1.541667_g13194_i0 | PRJNA399711 | 13260 | 181 | 1.541667 | 2.79041727 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 71.3 | 4.24e-8 | NTclustered | gi|2918369554|emb|OZ237726.1| | 317547 | g13194 | i0 | 89.286 | 1.79005524861878 | 56 | 6 | 31 | 0 | 2 | 57 | 14290104 | 14290159 | Eunicella cavolini genome assembly, chromosome: 10 | blastn | 324 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 25563095 | 25563095 | PRJNA399711_S_NODE_32945_length_231_cov_2.381443_g32803_i0 | PRJNA399711 | 32945 | 231 | 2.381443 | 5.50113333 | Atolla aff. wyvillei | 3126459 | Cnidaria | other_Eukaryota | 209 | 1.16e-49 | NTclustered | gi|2176177511|gb|OM214519.1| | 3126459 | g32803 | i0 | 84.234 | 94.5670995670996 | 222 | 27 | 94 | 5 | 14 | 230 | 665 | 447 | Atolla aff. wyvillei D712ss9 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 21845 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Coronatae | Atollidae | Atolla | Atolla aff. wyvillei | |
| 25624533 | 25624533 | PRJNA399711_S_NODE_19929_length_276_cov_3.631799_g19787_i0 | PRJNA399711 | 19929 | 276 | 3.631799 | 10.02376524 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2917940712|emb|OZ237560.1| | 6108 | g19787 | i0 | 100 | 2.33333333333333 | 28 | 0 | 10 | 0 | 141 | 168 | 6435022 | 6435049 | Anemonia sulcata genome assembly, chromosome: 6 | blastn | 644 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25698381 | 25698381 | PRJNA399711_S_NODE_15866_length_298_cov_5.030651_g15724_i0 | PRJNA399711 | 15866 | 298 | 5.030651 | 14.99133998 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 52.8 | 0.028 | NTclustered | gi|2751547462|ref|XM_066166458.1| | 203993 | g15724 | i0 | 100 | 0.0939597315436242 | 28 | 0 | 9 | 0 | 157 | 184 | 735 | 708 | PREDICTED: Pocillopora verrucosa uncharacterized protein (LOC136280768), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 25970521 | 25970521 | PRJNA399711_S_NODE_11828_length_328_cov_3.429553_g11686_i0 | PRJNA399711 | 11828 | 328 | 3.429553 | 11.24893384 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g11686 | i0 | 100 | 0.173780487804878 | 29 | 0 | 9 | 0 | 86 | 114 | 2496683 | 2496711 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 26169095 | 26169095 | PRJNA399711_S_NODE_45389_length_206_cov_3.822485_g45247_i0 | PRJNA399711 | 45389 | 206 | 3.822485 | 7.8743191 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 63.9 | 8.32e-6 | NTclustered | gi|2744778600|ref|XM_047274539.2| | 6087 | g45247 | i0 | 95.122 | 9.27184466019417 | 41 | 1 | 19 | 1 | 131 | 170 | 1605 | 1645 | PREDICTED: Hydra vulgaris amyloid-beta-like protein (LOC100201890), transcript variant X1, mRNA | blastn | 1910 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 26243056 | 26243056 | PRJNA399711_S_NODE_19390_length_278_cov_10.734440_g19248_i0 | PRJNA399711 | 19390 | 278 | 10.73444 | 29.8417432 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2751550226|ref|XM_066167317.1| | 203993 | g19248 | i0 | 96.97 | 0.118705035971223 | 33 | 0 | 12 | 1 | 118 | 149 | 770 | 802 | PREDICTED: Pocillopora verrucosa golgin subfamily A member 6-like protein 22 (LOC136281112), mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 33020401 | 33020401 | PRJNA399711_S_NODE_78716_length_169_cov_1.871212_g78574_i0 | PRJNA399711 | 78716 | 169 | 1.871212 | 3.16234828 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 47 | 4.48e-4 | NR | CAH3119332.1 | 104759 | g78574 | i0 | 50 | 3.53254437869822 | 30 | 14 | 53.3 | 1 | 68 | 157 | 1142 | 1170 | CAH3119332.1 unnamed protein product [Porites lobata] | diamond | 597 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 33054268 | 33054268 | PRJNA399711_S_NODE_36869_length_222_cov_3.005405_g36727_i0 | PRJNA399711 | 36869 | 222 | 3.005405 | 6.6719991 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 43.9 | 0.0118 | NR | CAB4025004.1 | 317549 | g36727 | i0 | 43.2 | 0.594594594594595 | 44 | 25 | 59.5 | 0 | 219 | 88 | 597 | 640 | CAB4025004.1 Transposon TX1 uncharacterized 149 kDa, partial [Paramuricea clavata] | diamond | 132 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 33111836 | 33111836 | PRJNA399711_S_NODE_53110_length_195_cov_1.512658_g52968_i0 | PRJNA399711 | 53110 | 195 | 1.512658 | 2.9496831 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.5 | 5.07e-8 | NR | XP_020605355.1 | 48498 | g52968 | i0 | 78.8 | 2.03076923076923 | 33 | 7 | 50.8 | 0 | 193 | 95 | 384 | 416 | XP_020605355.1 eukaryotic initiation factor 4A-I-like [Orbicella faveolata] | diamond | 396 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 33122782 | 33122782 | PRJNA399711_S_NODE_76311_length_171_cov_1.417910_g76169_i0 | PRJNA399711 | 76311 | 171 | 1.41791 | 2.4246261 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 58.2 | 1.65e-8 | NR | XP_029191643.2 | 45264 | g76169 | i0 | 60.5 | 3.78947368421053 | 43 | 10 | 75.4 | 1 | 168 | 40 | 143 | 178 | XP_029191643.2 ADP-ribosylation factor-like protein 3 [Acropora millepora] | diamond | 648 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 33173929 | 33173929 | PRJNA399711_S_NODE_58288_length_188_cov_4.423841_g58146_i0 | PRJNA399711 | 58288 | 188 | 4.423841 | 8.31682108 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 53.1 | 4.76e-7 | NR | CAH3019457.1 | 104178 | g58146 | i0 | 41 | 1.86702127659574 | 61 | 36 | 97.3 | 0 | 6 | 188 | 37 | 97 | CAH3019457.1 unnamed protein product, partial [Porites evermanni] | diamond | 351 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni |
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);;