contig_metadata
19 rows where bioproject = "PRJNA416866", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14448561 | 14448561 | PRJNA416866_P_NODE_9952_length_207_cov_1.787671_g9808_i0 | PRJNA416866 | 9952 | 207 | 1.787671 | 3.70047897 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 100 | 5.78e-25 | NR | XP_031557202.1 | 6105 | g9808 | i0 | 68.7 | 1.94202898550725 | 67 | 21 | 97.1 | 0 | 202 | 2 | 78 | 144 | XP_031557202.1 60S ribosomal protein L27a-like [Actinia tenebrosa] | diamond | 402 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 18271286 | 18271286 | PRJNA416866_P_NODE_2915_length_396_cov_2.202985_g2772_i0 | PRJNA416866 | 2915 | 396 | 2.202985 | 8.7238206 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 207 | 7.64e-49 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g2772 | i0 | 82.627 | 5.01010101010101 | 236 | 39 | 59 | 2 | 38 | 272 | 197853 | 198087 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 1984 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 20821381 | 20821381 | PRJNA416866_P_NODE_2177_length_465_cov_1.500000_g2034_i0 | PRJNA416866 | 2177 | 465 | 1.5 | 6.975 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 97.1 | 2.06e-15 | NTclustered | gi|2729058829|ref|XR_010517322.1| | 499914 | g2034 | i0 | 93.846 | 15.5096774193548 | 65 | 3 | 14 | 1 | 1 | 65 | 3607 | 3544 | PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA | blastn | 7212 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 21485483 | 21485483 | PRJNA416866_P_NODE_857_length_792_cov_2.659371_g729_i0 | PRJNA416866 | 857 | 792 | 2.659371 | 21.06221832 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 313 | 2.35e-100 | NR | XP_020614734.1 | 48498 | g729 | i0 | 68.5 | 32.6704545454545 | 219 | 69 | 83 | 0 | 135 | 791 | 35 | 253 | XP_020614734.1 propionyl-CoA carboxylase alpha chain, mitochondrial-like [Orbicella faveolata] | diamond | 25875 | 315 | 0.993650793650794 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 23371784 | 23371784 | PRJNA416866_P_NODE_6319_length_259_cov_1.292929_g6175_i0 | PRJNA416866 | 6319 | 259 | 1.292929 | 3.34868611 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 148 | 2.9199999999999998e-31 | NTclustered | gi|2782908311|ref|XM_067070165.1| | 252671 | g6175 | i0 | 78.543 | 10.2046332046332 | 247 | 38 | 94 | 13 | 5 | 248 | 420 | 654 | PREDICTED: Clytia hemisphaerica small ribosomal subunit protein RACK1 (LOC136813665), mRNA | blastn | 2643 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 26871073 | 26871073 | PRJNA416866_P_NODE_5961_length_267_cov_1.310680_g5817_i0 | PRJNA416866 | 5961 | 267 | 1.31068 | 3.4995156 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 44.3 | 0.0152 | NR | XP_044168355.1 | 45264 | g5817 | i0 | 48.8 | 2.04494382022472 | 43 | 20 | 48.3 | 1 | 144 | 16 | 17 | 57 | XP_044168355.1 myoferlin-like isoform X3 [Acropora millepora] | diamond | 546 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27739323 | 27739323 | PRJNA416866_P_NODE_2784_length_406_cov_1.017391_g2641_i0 | PRJNA416866 | 2784 | 406 | 1.017391 | 4.13060746 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 155 | 3.9799999999999985e-43 | NR | PFX25498.1 | 50429 | g2641 | i0 | 59.2 | 5.83743842364532 | 142 | 48 | 97.5 | 3 | 2 | 397 | 191 | 332 | PFX25498.1 40S ribosomal protein S10 [Stylophora pistillata] | diamond | 2370 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 28039815 | 28039815 | PRJNA416866_P_NODE_11865_length_201_cov_0.914286_g11721_i0 | PRJNA416866 | 11865 | 201 | 0.914286 | 1.83771486 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 94.4 | 1.41e-20 | NR | XP_029185288.2 | 45264 | g11721 | i0 | 66.7 | 6.8955223880597 | 66 | 21 | 98.5 | 1 | 199 | 2 | 376 | 440 | XP_029185288.2 nucleolar GTP-binding protein 2-like isoform X1 [Acropora millepora] | diamond | 1386 | 94.7 | 0.996832101372756 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28102750 | 28102750 | PRJNA416866_P_NODE_10585_length_205_cov_0.888889_g10441_i0 | PRJNA416866 | 10585 | 205 | 0.888889 | 1.82222245 | Porites | 46719 | Cnidaria | other_Eukaryota | 92.8 | 5.39e-20 | NR | CAH3174368.1 | 104178 | g10441 | i0 | 63.5 | 8.48780487804878 | 63 | 23 | 92.2 | 0 | 13 | 201 | 1070 | 1132 | CAH3174368.1 unnamed protein product [Porites evermanni] | diamond | 1740 | 93.2 | 0.995708154506438 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 28212332 | 28212332 | PRJNA416866_P_NODE_10406_length_206_cov_0.882759_g10262_i0 | PRJNA416866 | 10406 | 206 | 0.882759 | 1.81848354 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 58.9 | 3.95e-8 | NR | XP_020896456.1 | 2652724 | g10262 | i0 | 51.9 | 0.786407766990291 | 54 | 17 | 65.5 | 1 | 72 | 206 | 73 | 126 | XP_020896456.1 alternative oxidase, mitochondrial isoform X2 [Exaiptasia diaphana] | diamond | 162 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 28402019 | 28402019 | PRJNA416866_P_NODE_11026_length_204_cov_0.895105_g10882_i0 | PRJNA416866 | 11026 | 204 | 0.895105 | 1.8260142 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 46.2 | 0.00131 | NR | XP_020631459.1 | 48498 | g10882 | i0 | 34.5 | 1.70588235294118 | 58 | 38 | 85.3 | 0 | 182 | 9 | 195 | 252 | XP_020631459.1 fibroblast growth factor receptor 2-like [Orbicella faveolata] | diamond | 348 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 29776215 | 29776215 | PRJNA416866_P_NODE_4691_length_304_cov_1.399177_g4547_i0 | PRJNA416866 | 4691 | 304 | 1.399177 | 4.25349808 | Acropora | 6127 | Cnidaria | other_Eukaryota | 57 | 7.29e-7 | NR | KAK2567112.1 | 6130 | g4547 | i0 | 44.1 | 1.34210526315789 | 68 | 32 | 64.1 | 2 | 17 | 211 | 405 | 469 | KAK2567112.1 putative ankyrin repeat protein [Acropora cervicornis] | diamond | 408 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 29949291 | 29949291 | PRJNA416866_P_NODE_7691_length_233_cov_1.366279_g7547_i0 | PRJNA416866 | 7691 | 233 | 1.366279 | 3.18343007 | Pocillopora damicornis | 46731 | Cnidaria | other_Eukaryota | 50.1 | 4.91e-5 | NR | XP_027058343.1 | 46731 | g7547 | i0 | 40.3 | 0.927038626609442 | 72 | 37 | 92.7 | 3 | 12 | 227 | 67 | 132 | XP_027058343.1 THAP domain-containing protein 4-like isoform X1 [Pocillopora damicornis] | diamond | 216 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 29980833 | 29980833 | PRJNA416866_P_NODE_4631_length_306_cov_1.044898_g4487_i0 | PRJNA416866 | 4631 | 306 | 1.044898 | 3.19738788 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 92 | 2.76e-20 | NR | XP_022803701.1 | 50429 | g4487 | i0 | 56.8 | 1.45098039215686 | 74 | 32 | 72.5 | 0 | 223 | 2 | 59 | 132 | XP_022803701.1 polynucleotide 3'-phosphatase ZDP-like [Stylophora pistillata] | diamond | 444 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30376977 | 30376977 | PRJNA416866_P_NODE_4432_length_313_cov_1.269841_g4289_i0 | PRJNA416866 | 4432 | 313 | 1.269841 | 3.97460233 | Montipora | 46703 | Cnidaria | other_Eukaryota | 68.2 | 9.83e-11 | NR | XP_068754229.1 | 246305 | g4289 | i0 | 34.7 | 3.87220447284345 | 101 | 66 | 96.8 | 0 | 4 | 306 | 163 | 263 | XP_068754229.1 tripartite motif-containing protein 2-like isoform X1 [Montipora capricornis] | diamond | 1212 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 30833872 | 30833872 | PRJNA416866_P_NODE_6894_length_247_cov_1.720430_g6750_i0 | PRJNA416866 | 6894 | 247 | 1.72043 | 4.2494621 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 42.7 | 0.0394 | NR | XP_065057994.1 | 499914 | g6750 | i0 | 37.3 | 0.716599190283401 | 59 | 37 | 71.7 | 0 | 246 | 70 | 446 | 504 | XP_065057994.1 gamma-taxilin-like isoform X2 [Rhopilema esculentum] | diamond | 177 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31624154 | 31624154 | PRJNA416866_P_NODE_11836_length_201_cov_0.914286_g11692_i0 | PRJNA416866 | 11836 | 201 | 0.914286 | 1.83771486 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 58.5 | 5.46e-8 | NR | XP_046860551.1 | 2897299 | g11692 | i0 | 40.6 | 0.955223880597015 | 64 | 38 | 95.5 | 0 | 201 | 10 | 122 | 185 | XP_046860551.1 LETM1 domain-containing protein 1-like [Xenia sp. Carnegie-2017] | diamond | 192 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 31704078 | 31704078 | PRJNA416866_P_NODE_10977_length_204_cov_0.895105_g10833_i0 | PRJNA416866 | 10977 | 204 | 0.895105 | 1.8260142 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 6.41e-6 | NR | XP_032232630.2 | 45351 | g10833 | i0 | 35.4 | 2.86764705882353 | 65 | 42 | 95.6 | 0 | 3 | 197 | 618 | 682 | XP_032232630.2 protein-glucosylgalactosylhydroxylysine glucosidase [Nematostella vectensis] | diamond | 585 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31782184 | 31782184 | PRJNA416866_P_NODE_10797_length_204_cov_2.286713_g10653_i0 | PRJNA416866 | 10797 | 204 | 2.286713 | 4.66489452 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 47 | 7.33e-4 | NR | XP_031561042.1 | 6105 | g10653 | i0 | 60.7 | 0.411764705882353 | 28 | 11 | 41.2 | 0 | 4 | 87 | 211 | 238 | XP_031561042.1 zinc finger CCHC domain-containing protein 8-like [Actinia tenebrosa] | diamond | 84 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa |
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);;