contig_metadata
25 rows where bioproject = "PRJNA438572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10639117 | 10639117 | PRJNA438572_P_NODE_9989_length_324_cov_1.860558_g9870_i0 | PRJNA438572 | 9989 | 324 | 1.860558 | 6.02820792 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g9870 | i0 | 100 | 0.929012345679012 | 30 | 0 | 9 | 0 | 201 | 230 | 11609381 | 11609410 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 301 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11913948 | 11913948 | PRJNA438572_P_NODE_7990_length_359_cov_3.262238_g7871_i0 | PRJNA438572 | 7990 | 359 | 3.262238 | 11.71143442 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 172 | 5.51e-52 | NR | XP_066913262.1 | 252671 | g7871 | i0 | 76.2 | 1.75487465181058 | 105 | 25 | 87.7 | 0 | 320 | 6 | 3 | 107 | XP_066913262.1 peroxiredoxin-1-like isoform X2 [Clytia hemisphaerica] | diamond | 630 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 18286872 | 18286872 | PRJNA438572_P_NODE_9535_length_331_cov_1.209302_g9416_i0 | PRJNA438572 | 9535 | 331 | 1.209302 | 4.00278962 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2782896838|ref|XM_067067573.1| | 252671 | g9416 | i0 | 88.889 | 0.344410876132931 | 45 | 5 | 14 | 0 | 243 | 287 | 526 | 482 | PREDICTED: Clytia hemisphaerica procathepsin L-like (LOC136810978), mRNA | blastn | 114 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 26600863 | 26600863 | PRJNA438572_P_NODE_6441_length_395_cov_1.211180_g6322_i0 | PRJNA438572 | 6441 | 395 | 1.21118 | 4.784161 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 100 | 4.829999999999999e-23 | NR | XP_057289324.1 | 13093 | g6322 | i0 | 41.1 | 0.941772151898734 | 124 | 72 | 94.2 | 1 | 22 | 393 | 5 | 127 | XP_057289324.1 uncharacterized protein LOC130612052 [Hydractinia symbiolongicarpus] | diamond | 372 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26696028 | 26696028 | PRJNA438572_P_NODE_14761_length_271_cov_1.181818_g14642_i0 | PRJNA438572 | 14761 | 271 | 1.181818 | 3.20272678 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 66.6 | 2.06e-10 | NR | XP_027040496.1 | 46731 | g14642 | i0 | 41.6 | 2.88929889298893 | 89 | 45 | 96.3 | 3 | 263 | 3 | 444 | 527 | XP_027040496.1 pappalysin-1-like isoform X2 [Pocillopora damicornis] | diamond | 783 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 26871176 | 26871176 | PRJNA438572_P_NODE_1181_length_859_cov_6.735369_g1089_i0 | PRJNA438572 | 1181 | 859 | 6.735369 | 57.85681971 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 215 | 3.63e-66 | NR | XP_001639879.2 | 45351 | g1089 | i0 | 66.7 | 8.82887077997672 | 159 | 51 | 54.8 | 2 | 41 | 511 | 37 | 195 | XP_001639879.2 40S ribosomal protein S11 [Nematostella vectensis] | diamond | 7584 | 216 | 0.99537037037037 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 27044390 | 27044390 | PRJNA438572_P_NODE_16362_length_256_cov_2.109290_g16243_i0 | PRJNA438572 | 16362 | 256 | 2.10929 | 5.3997824 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 77.4 | 2.35e-14 | NR | XP_066929766.1 | 252671 | g16243 | i0 | 51.4 | 1.6640625 | 70 | 33 | 80.9 | 1 | 48 | 254 | 5 | 74 | XP_066929766.1 calreticulin-like [Clytia hemisphaerica] | diamond | 426 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 28086573 | 28086573 | PRJNA438572_P_NODE_20225_length_248_cov_0.891429_g20106_i0 | PRJNA438572 | 20225 | 248 | 0.891429 | 2.21074392 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 53.1 | 8.38e-6 | NR | XP_046852899.1 | 2897299 | g20106 | i0 | 40.4 | 1.13709677419355 | 47 | 28 | 56.9 | 0 | 188 | 48 | 44 | 90 | XP_046852899.1 beta-hexosaminidase subunit beta-like [Xenia sp. Carnegie-2017] | diamond | 282 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28102850 | 28102850 | PRJNA438572_P_NODE_24525_length_242_cov_0.923077_g24406_i0 | PRJNA438572 | 24525 | 242 | 0.923077 | 2.23384634 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 53.5 | 5.74e-6 | NR | CAB4006755.1 | 317549 | g24406 | i0 | 59.5 | 8.33057851239669 | 37 | 15 | 45.9 | 0 | 236 | 126 | 24 | 60 | CAB4006755.1 Hypothetical predicted protein, partial [Paramuricea clavata] | diamond | 2016 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28102852 | 28102852 | PRJNA438572_P_NODE_5285_length_433_cov_1.300000_g5166_i0 | PRJNA438572 | 5285 | 433 | 1.3 | 5.629 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 84.3 | 8.65e-16 | NR | CAH3171531.1 | 104178 | g5166 | i0 | 53.4 | 3.67898383371824 | 88 | 20 | 61 | 2 | 1 | 264 | 552 | 618 | CAH3171531.1 unnamed protein product [Porites evermanni] | diamond | 1593 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 28244390 | 28244390 | PRJNA438572_P_NODE_16746_length_253_cov_1.522222_g16627_i0 | PRJNA438572 | 16746 | 253 | 1.522222 | 3.85122166 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 113 | 8.59e-31 | NR | XP_002161016.1 | 6087 | g16627 | i0 | 62 | 2.82213438735178 | 79 | 30 | 93.7 | 0 | 13 | 249 | 5 | 83 | XP_002161016.1 small ribosomal subunit protein eS27-like [Hydra vulgaris] | diamond | 714 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29113481 | 29113481 | PRJNA438572_P_NODE_23288_length_243_cov_1.676471_g23169_i0 | PRJNA438572 | 23288 | 243 | 1.676471 | 4.0738245300000004 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99.8 | 3.25e-22 | NR | XP_047142339.1 | 6087 | g23169 | i0 | 62.3 | 13.8641975308642 | 77 | 28 | 95.1 | 1 | 9 | 239 | 334 | 409 | XP_047142339.1 major vault protein [Hydra vulgaris] | diamond | 3369 | 100 | 0.998 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29191922 | 29191922 | PRJNA438572_P_NODE_6289_length_400_cov_1.431193_g6170_i0 | PRJNA438572 | 6289 | 400 | 1.431193 | 5.724772 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 53.1 | 4.78e-5 | NR | XP_020912270.1 | 2652724 | g6170 | i0 | 31.6 | 0.8775 | 117 | 66 | 81 | 4 | 354 | 31 | 28 | 139 | XP_020912270.1 cytosolic phospholipase A2 [Exaiptasia diaphana] | diamond | 351 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 29366023 | 29366023 | PRJNA438572_P_NODE_22089_length_245_cov_0.906977_g21970_i0 | PRJNA438572 | 22089 | 245 | 0.906977 | 2.22209365 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 49.3 | 1.77e-4 | NR | XP_028392552.1 | 151771 | g21970 | i0 | 48.8 | 6.22040816326531 | 43 | 22 | 52.7 | 0 | 1 | 129 | 157 | 199 | XP_028392552.1 protein XRP2-like [Dendronephthya gigantea] | diamond | 1524 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30660998 | 30660998 | PRJNA438572_P_NODE_7293_length_374_cov_1.807309_g7174_i0 | PRJNA438572 | 7293 | 374 | 1.807309 | 6.75933566 | root | 1 | Root_unresolved | Root_unresolved | 65.1 | 2.64e-9 | NR | XP_029194885.2 | 45264 | g7174 | i0 | 36.8 | 2.8716577540107 | 125 | 65 | 93 | 5 | 26 | 373 | 2212 | 2331 | XP_029194885.2 polycystin-1-like [Acropora millepora] | diamond | 1074 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 30787445 | 30787445 | PRJNA438572_P_NODE_22654_length_244_cov_1.368421_g22535_i0 | PRJNA438572 | 22654 | 244 | 1.368421 | 3.33894724 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 2.4499999999999997e-31 | NR | XP_002163391.2 | 6087 | g22535 | i0 | 71.3 | 61.9672131147541 | 80 | 23 | 98.4 | 0 | 3 | 242 | 68 | 147 | XP_002163391.2 cystathionine beta-synthase-like protein isoform X1 [Hydra vulgaris] | diamond | 15120 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 30929119 | 30929119 | PRJNA438572_P_NODE_22994_length_244_cov_0.912281_g22875_i0 | PRJNA438572 | 22994 | 244 | 0.912281 | 2.22596564 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 64.3 | 9.06e-10 | NR | XP_068681808.1 | 591990 | g22875 | i0 | 47.1 | 1.04508196721311 | 85 | 39 | 98.4 | 3 | 3 | 242 | 419 | 502 | XP_068681808.1 kelch-like protein 12 [Montipora foliosa] | diamond | 255 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 31181525 | 31181525 | PRJNA438572_P_NODE_19795_length_249_cov_0.886364_g19676_i0 | PRJNA438572 | 19795 | 249 | 0.886364 | 2.20704636 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 75.9 | 1.37e-14 | NR | XP_057309106.1 | 13093 | g19676 | i0 | 44.9 | 0.831325301204819 | 69 | 36 | 80.7 | 1 | 247 | 47 | 70 | 138 | XP_057309106.1 uncharacterized protein LOC130647320 [Hydractinia symbiolongicarpus] | diamond | 207 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 31292935 | 31292935 | PRJNA438572_P_NODE_17035_length_253_cov_0.866667_g16916_i0 | PRJNA438572 | 17035 | 253 | 0.866667 | 2.19266751 | Porites | 46719 | Cnidaria | other_Eukaryota | 79 | 2.18e-15 | NR | CAH3029182.1 | 104178 | g16916 | i0 | 48.7 | 2.65612648221344 | 78 | 39 | 91.3 | 1 | 249 | 19 | 189 | 266 | CAH3029182.1 unnamed protein product [Porites evermanni] | diamond | 672 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 31798893 | 31798893 | PRJNA438572_P_NODE_14037_length_278_cov_1.136585_g13918_i0 | PRJNA438572 | 14037 | 278 | 1.136585 | 3.1597063 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 2.74e-6 | NR | KAF1743799.1 | 59785 | g13918 | i0 | 43.1 | 5.37410071942446 | 65 | 32 | 66.9 | 2 | 275 | 90 | 115 | 177 | KAF1743799.1 LOW QUALITY PROTEIN: hypothetical protein MXB_5080 [Myxobolus squamalis] | diamond | 1494 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 31798899 | 31798899 | PRJNA438572_P_NODE_5917_length_411_cov_1.257396_g5798_i0 | PRJNA438572 | 5917 | 411 | 1.257396 | 5.16789756 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 145 | 2.4199999999999993e-40 | NR | CAH3139222.1 | 104759 | g5798 | i0 | 66.7 | 30.8248175182482 | 102 | 28 | 74.5 | 1 | 1 | 306 | 101 | 196 | CAH3139222.1 unnamed protein product [Porites lobata] | diamond | 12669 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 32099097 | 32099097 | PRJNA438572_P_NODE_16238_length_257_cov_2.543478_g16119_i0 | PRJNA438572 | 16238 | 257 | 2.543478 | 6.53673846 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 62 | 2.59e-9 | NR | XP_022805251.1 | 50429 | g16119 | i0 | 50 | 3.5136186770428 | 74 | 34 | 82.9 | 2 | 241 | 29 | 136 | 209 | XP_022805251.1 glutathione S-transferase 1-like [Stylophora pistillata] | diamond | 903 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32194142 | 32194142 | PRJNA438572_P_NODE_17358_length_252_cov_1.737430_g17239_i0 | PRJNA438572 | 17358 | 252 | 1.73743 | 4.3783236 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 58.5 | 1.18e-7 | NR | XP_066936525.1 | 252671 | g17239 | i0 | 34.6 | 3.85714285714286 | 81 | 39 | 96.4 | 1 | 4 | 246 | 237 | 303 | XP_066936525.1 cullin-associated NEDD8-dissociated protein 1-like [Clytia hemisphaerica] | diamond | 972 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 32210438 | 32210438 | PRJNA438572_P_NODE_23638_length_243_cov_0.917647_g23519_i0 | PRJNA438572 | 23638 | 243 | 0.917647 | 2.22988221 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 87.8 | 3.41e-18 | NR | CAH3024205.1 | 104178 | g23519 | i0 | 62.1 | 3.59259259259259 | 66 | 24 | 80.2 | 1 | 197 | 3 | 9 | 74 | CAH3024205.1 unnamed protein product [Porites evermanni] | diamond | 873 | 88.6 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 32447431 | 32447431 | PRJNA438572_P_NODE_15259_length_266_cov_1.616580_g15140_i0 | PRJNA438572 | 15259 | 266 | 1.61658 | 4.3001028 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 60.5 | 2.8e-8 | NR | CAB4017715.1 | 317549 | g15140 | i0 | 35.1 | 1.66917293233083 | 74 | 42 | 76.7 | 1 | 63 | 266 | 341 | 414 | CAB4017715.1 inositol 1,4,5-trisphosphate receptor-like, partial [Paramuricea clavata] | diamond | 444 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata |
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);;