contig_metadata
22 rows where bioproject = "PRJNA1105232", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4039334 | 4039334 | PRJNA1105232_S_NODE_1304_length_442_cov_19.445293_g1090_i0 | PRJNA1105232 | 1304 | 442 | 19.445293 | 85.94819506 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 213 | 6.199999999999999e-67 | NR | XP_065063129.1 | 499914 | g1090 | i0 | 73.1 | 1.77149321266968 | 130 | 35 | 88.2 | 0 | 419 | 30 | 116 | 245 | XP_065063129.1 large ribosomal subunit protein uL30-like [Rhopilema esculentum] | diamond | 783 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 6590703 | 6590703 | PRJNA1105232_S_NODE_806_length_524_cov_6.976842_g595_i0 | PRJNA1105232 | 806 | 524 | 6.976842 | 36.55865208 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 271 | 8.26e-89 | NR | XP_031554159.1 | 6105 | g595 | i0 | 74 | 67.1908396946565 | 173 | 45 | 99 | 0 | 4 | 522 | 83 | 255 | XP_031554159.1 40S ribosomal protein S2 [Actinia tenebrosa] | diamond | 35208 | 273 | 0.992673992673993 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 6590710 | 6590710 | PRJNA1105232_S_NODE_8806_length_212_cov_1.791411_g8590_i0 | PRJNA1105232 | 8806 | 212 | 1.791411 | 3.79779132 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 84.3 | 9.79e-19 | NR | CAH3027750.1 | 104178 | g8590 | i0 | 59.4 | 1.95283018867925 | 69 | 28 | 97.6 | 0 | 211 | 5 | 63 | 131 | CAH3027750.1 unnamed protein product [Porites evermanni] | diamond | 414 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 7398215 | 7398215 | PRJNA1105232_S_NODE_8686_length_213_cov_2.701220_g8470_i0 | PRJNA1105232 | 8686 | 213 | 2.70122 | 5.7535986 | Acropora | 6127 | Cnidaria | other_Eukaryota | 117 | 1.36e-31 | NR | XP_029193069.2 | 45264 | g8470 | i0 | 80 | 14.7887323943662 | 70 | 14 | 98.6 | 0 | 212 | 3 | 57 | 126 | XP_029193069.2 40S ribosomal protein S15a isoform X1 [Acropora millepora] | diamond | 3150 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 7865298 | 7865298 | PRJNA1105232_S_NODE_15007_length_170_cov_1.016529_g14791_i0 | PRJNA1105232 | 15007 | 170 | 1.016529 | 1.7280993 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 75.9 | 2.9e-14 | NR | XP_057307828.1 | 13093 | g14791 | i0 | 60.7 | 0.988235294117647 | 56 | 22 | 98.8 | 0 | 1 | 168 | 233 | 288 | XP_057307828.1 unconventional myosin-VI-like [Hydractinia symbiolongicarpus] | diamond | 168 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 7865320 | 7865320 | PRJNA1105232_S_NODE_2607_length_341_cov_2.349315_g2391_i0 | PRJNA1105232 | 2607 | 341 | 2.349315 | 8.01116415 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1603820535|ref|XM_028558927.1| | 151771 | g2391 | i0 | 96.774 | 0.363636363636364 | 31 | 1 | 9 | 0 | 3 | 33 | 6201 | 6231 | PREDICTED: Dendronephthya gigantea nuclear anchorage protein 1-like (LOC114537828), transcript variant X2, mRNA | blastn | 124 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 9140155 | 9140155 | PRJNA1105232_S_NODE_11128_length_193_cov_1.131944_g10912_i0 | PRJNA1105232 | 11128 | 193 | 1.131944 | 2.18465192 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2782931191|ref|XM_067074155.1| | 252671 | g10912 | i0 | 94.444 | 0.186528497409326 | 36 | 2 | 19 | 0 | 1 | 36 | 620 | 655 | PREDICTED: Clytia hemisphaerica ADP-ribosylation factor 2 (LOC136817831), mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 9140190 | 9140190 | PRJNA1105232_S_NODE_2568_length_343_cov_2.119048_g2352_i0 | PRJNA1105232 | 2568 | 343 | 2.119048 | 7.26833464 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 170 | 1.5199999999999999e-46 | NR | XP_027055485.1 | 46731 | g2352 | i0 | 76.6 | 5.45772594752187 | 107 | 25 | 93.6 | 0 | 342 | 22 | 746 | 852 | XP_027055485.1 ribonucleoside-diphosphate reductase large subunit-like [Pocillopora damicornis] | diamond | 1872 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 27162304 | 27162304 | PRJNA1105232_S_NODE_7082_length_231_cov_2.186813_g6866_i0 | PRJNA1105232 | 7082 | 231 | 2.186813 | 5.05153803 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 57.4 | 2.16e-7 | NR | XP_065060093.1 | 499914 | g6866 | i0 | 42.3 | 0.922077922077922 | 71 | 38 | 92.2 | 2 | 15 | 227 | 391 | 458 | XP_065060093.1 E3 ubiquitin-protein ligase TRIM71-like [Rhopilema esculentum] | diamond | 213 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 27280351 | 27280351 | PRJNA1105232_S_NODE_7003_length_232_cov_1.584699_g6787_i0 | PRJNA1105232 | 7003 | 232 | 1.584699 | 3.67650168 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 52.4 | 1.25e-5 | NR | RMX55819.1 | 46731 | g6787 | i0 | 41.3 | 4.88793103448276 | 80 | 42 | 98.3 | 3 | 228 | 1 | 245 | 323 | RMX55819.1 hypothetical protein pdam_00009583 [Pocillopora damicornis] | diamond | 1134 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 27668089 | 27668089 | PRJNA1105232_S_NODE_4424_length_278_cov_1.921397_g4208_i0 | PRJNA1105232 | 4424 | 278 | 1.921397 | 5.34148366 | Porites evermanni | 104178 | Cnidaria | other_Eukaryota | 79.3 | 7.69e-15 | NR | CAH3190796.1 | 104178 | g4208 | i0 | 40.9 | 3.93884892086331 | 93 | 53 | 99.3 | 2 | 276 | 1 | 654 | 745 | CAH3190796.1 unnamed protein product [Porites evermanni] | diamond | 1095 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 28836104 | 28836104 | PRJNA1105232_S_NODE_9028_length_210_cov_2.223602_g8812_i0 | PRJNA1105232 | 9028 | 210 | 2.223602 | 4.6695642 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 75.9 | 7.02e-15 | NR | CAH3145862.1 | 104759 | g8812 | i0 | 51.4 | 1.02857142857143 | 72 | 31 | 97.1 | 2 | 206 | 3 | 110 | 181 | CAH3145862.1 unnamed protein product [Porites lobata] | diamond | 216 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29057316 | 29057316 | PRJNA1105232_S_NODE_8028_length_220_cov_1.824561_g7812_i0 | PRJNA1105232 | 8028 | 220 | 1.824561 | 4.0140342 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 55.8 | 6.57e-7 | NR | XP_028519626.1 | 2652724 | g7812 | i0 | 52.5 | 5.91818181818182 | 61 | 27 | 80.5 | 1 | 39 | 215 | 408 | 468 | XP_028519626.1 nucleoprotein TPR [Exaiptasia diaphana] | diamond | 1302 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 29152294 | 29152294 | PRJNA1105232_S_NODE_10489_length_198_cov_1.355705_g10273_i0 | PRJNA1105232 | 10489 | 198 | 1.355705 | 2.6842959 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 62.8 | 1.78e-9 | NR | XP_020610351.1 | 48498 | g10273 | i0 | 47.8 | 1.04545454545455 | 69 | 30 | 95.5 | 2 | 10 | 198 | 390 | 458 | XP_020610351.1 equilibrative nucleoside transporter 1-like isoform X1 [Orbicella faveolata] | diamond | 207 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 30162259 | 30162259 | PRJNA1105232_S_NODE_14132_length_174_cov_1.872000_g13916_i0 | PRJNA1105232 | 14132 | 174 | 1.872 | 3.25728 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 41.2 | 0.0482 | NR | CAB3988695.1 | 317549 | g13916 | i0 | 29.8 | 1.96551724137931 | 57 | 38 | 98.3 | 1 | 172 | 2 | 159 | 213 | CAB3988695.1 NADPH oxidase 5, partial [Paramuricea clavata] | diamond | 342 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30384065 | 30384065 | PRJNA1105232_S_NODE_7333_length_228_cov_1.988827_g7117_i0 | PRJNA1105232 | 7333 | 228 | 1.988827 | 4.53452556 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 57.8 | 1.57e-7 | NR | XP_031557521.1 | 6105 | g7117 | i0 | 40.8 | 1 | 76 | 44 | 98.7 | 1 | 1 | 225 | 274 | 349 | XP_031557521.1 USP6 N-terminal-like protein [Actinia tenebrosa] | diamond | 228 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 30794308 | 30794308 | PRJNA1105232_S_NODE_4994_length_265_cov_3.199074_g4778_i0 | PRJNA1105232 | 4994 | 265 | 3.199074 | 8.4775461 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 54.3 | 4.15e-6 | NR | XP_044168215.1 | 45264 | g4778 | i0 | 34.1 | 0.962264150943396 | 85 | 55 | 96.2 | 1 | 263 | 9 | 1531 | 1614 | XP_044168215.1 dedicator of cytokinesis protein 1-like [Acropora millepora] | diamond | 255 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 31047452 | 31047452 | PRJNA1105232_S_NODE_7175_length_230_cov_1.436464_g6959_i0 | PRJNA1105232 | 7175 | 230 | 1.436464 | 3.3038672 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 51.6 | 2.39e-5 | NR | XP_048589319.1 | 45351 | g6959 | i0 | 62.9 | 3.48260869565217 | 35 | 13 | 45.7 | 0 | 226 | 122 | 1223 | 1257 | XP_048589319.1 ATP-dependent translocase ABCB1 isoform X3 [Nematostella vectensis] | diamond | 801 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31521568 | 31521568 | PRJNA1105232_S_NODE_10836_length_195_cov_1.780822_g10620_i0 | PRJNA1105232 | 10836 | 195 | 1.780822 | 3.4726029 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 48.5 | 1.78e-4 | NR | XP_022800961.1 | 50429 | g10620 | i0 | 40.7 | 0.830769230769231 | 54 | 32 | 83.1 | 0 | 21 | 182 | 390 | 443 | XP_022800961.1 E3 ubiquitin-protein ligase TRIM71-like [Stylophora pistillata] | diamond | 162 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31647751 | 31647751 | PRJNA1105232_S_NODE_12577_length_183_cov_1.805970_g12361_i0 | PRJNA1105232 | 12577 | 183 | 1.80597 | 3.3049251 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 49.3 | 8.39e-5 | NR | XP_015761237.1 | 70779 | g12361 | i0 | 46.9 | 0.80327868852459 | 49 | 26 | 80.3 | 0 | 150 | 4 | 420 | 468 | XP_015761237.1 PREDICTED: E3 ubiquitin-protein ligase TRIM71-like [Acropora digitifera] | diamond | 147 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 31670821 | 31670821 | PRJNA1105232_S_NODE_4157_length_285_cov_1.322034_g3941_i0 | PRJNA1105232 | 4157 | 285 | 1.322034 | 3.7677969 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 88.2 | 5.83e-18 | NR | XP_015751633.1 | 70779 | g3941 | i0 | 51.7 | 2.82105263157895 | 89 | 42 | 92.6 | 1 | 283 | 20 | 382 | 470 | XP_015751633.1 PREDICTED: retinoschisin-like isoform X2 [Acropora digitifera] | diamond | 804 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 31711227 | 31711227 | PRJNA1105232_S_NODE_6677_length_237_cov_1.106383_g6461_i0 | PRJNA1105232 | 6677 | 237 | 1.106383 | 2.62212771 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 76.6 | 2.63e-14 | NR | XP_044176098.1 | 45264 | g6461 | i0 | 57.3 | 1.0379746835443 | 82 | 31 | 98.7 | 3 | 236 | 3 | 228 | 309 | XP_044176098.1 uncharacterized protein LOC122959104 [Acropora millepora] | diamond | 246 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora |
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);;