contig_metadata
23 rows where bioproject = "PRJNA700095", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5786578 | 5786578 | PRJNA700095_P_NODE_13525_length_512_cov_0.977221_g12270_i0 | PRJNA700095 | 13525 | 512 | 0.977221 | 5.00337152 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 84.3 | 1.99e-15 | NR | KAJ7380757.1 | 174260 | g12270 | i0 | 38.7 | 4.3828125 | 124 | 59 | 72.7 | 4 | 503 | 132 | 424 | 530 | KAJ7380757.1 hypothetical protein OS493_007135 [Desmophyllum pertusum] | diamond | 2244 | 85.1 | 0.990599294947121 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 6288306 | 6288306 | PRJNA700095_P_NODE_66945_length_236_cov_5.723926_g65681_i0 | PRJNA700095 | 66945 | 236 | 5.723926 | 13.50846536 | Ellisella | 328399 | Cnidaria | other_Eukaryota | 97.1 | 9.64e-16 | NTclustered | gi|2689317297|gb|PP410744.1| | 2751895 | g65681 | i0 | 95.161 | 24.0042372881356 | 62 | 2 | 26 | 1 | 155 | 216 | 3528 | 3588 | Ellisella elongata voucher USNM:1660444 large subunit ribosomal RNA gene, partial sequence | blastn | 5665 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Ellisellidae | Ellisella | Ellisella elongata | |
| 8336280 | 8336280 | PRJNA700095_P_NODE_17507_length_430_cov_19.109244_g16244_i0 | PRJNA700095 | 17507 | 430 | 19.109244 | 82.1697492 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 207 | 8.37e-49 | NTclustered | gi|2918369552|emb|OZ237724.1| | 317547 | g16244 | i0 | 82.627 | 4.61395348837209 | 236 | 39 | 55 | 2 | 125 | 359 | 198087 | 197853 | Eunicella cavolini genome assembly, chromosome: 8 | blastn | 1984 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 9611647 | 9611647 | PRJNA700095_P_NODE_30548_length_309_cov_2.576271_g29284_i0 | PRJNA700095 | 30548 | 309 | 2.576271 | 7.96067739 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 75 | 6.16e-9 | NTclustered | gi|2202626640|ref|XM_046990664.1| | 2897299 | g29284 | i0 | 86.567 | 0.867313915857605 | 67 | 9 | 22 | 0 | 135 | 201 | 2534 | 2600 | PREDICTED: Xenia sp. Carnegie-2017 deleted in malignant brain tumors 1 protein-like (LOC124440303), transcript variant X4, mRNA | blastn | 268 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 15212781 | 15212781 | PRJNA700095_P_NODE_40332_length_275_cov_1.450495_g39068_i0 | PRJNA700095 | 40332 | 275 | 1.450495 | 3.98886125 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 91.6 | 5.36e-14 | NTclustered | gi|2744908866|ref|XM_065819693.1| | 6087 | g39068 | i0 | 98.077 | 11.3345454545455 | 52 | 1 | 19 | 0 | 217 | 268 | 434 | 485 | PREDICTED: Hydra vulgaris uncharacterized LOC136091973 (LOC136091973), mRNA | blastn | 3117 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 22861650 | 22861650 | PRJNA700095_P_NODE_17138_length_437_cov_1.527473_g15875_i0 | PRJNA700095 | 17138 | 437 | 1.527473 | 6.67505701 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 200 | 8.08e-59 | NR | XP_020896554.1 | 2652724 | g15875 | i0 | 64 | 3.85812356979405 | 139 | 50 | 95.4 | 0 | 21 | 437 | 116 | 254 | XP_020896554.1 serine/threonine-protein kinase 3 [Exaiptasia diaphana] | diamond | 1686 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 26734166 | 26734166 | PRJNA700095_P_NODE_46581_length_260_cov_2.058824_g45317_i0 | PRJNA700095 | 46581 | 260 | 2.058824 | 5.3529424 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 47.4 | 0.00106 | NR | XP_065057994.1 | 499914 | g45317 | i0 | 38.1 | 0.726923076923077 | 63 | 39 | 72.7 | 0 | 36 | 224 | 442 | 504 | XP_065057994.1 gamma-taxilin-like isoform X2 [Rhopilema esculentum] | diamond | 189 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 26766275 | 26766275 | PRJNA700095_P_NODE_34941_length_289_cov_1.888889_g33677_i0 | PRJNA700095 | 34941 | 289 | 1.888889 | 5.45888921 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 62.4 | 7.92e-9 | NR | XP_028408705.1 | 151771 | g33677 | i0 | 32.4 | 1.50519031141869 | 145 | 46 | 96.5 | 4 | 281 | 3 | 498 | 642 | XP_028408705.1 uncharacterized protein LOC114531265 [Dendronephthya gigantea] | diamond | 435 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 27714973 | 27714973 | PRJNA700095_P_NODE_21924_length_373_cov_1.526667_g20660_i0 | PRJNA700095 | 21924 | 373 | 1.526667 | 5.69446791 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 74.3 | 1.68e-13 | NR | KAJ7381634.1 | 174260 | g20660 | i0 | 39.8 | 0.74798927613941 | 93 | 54 | 73.2 | 1 | 279 | 7 | 13 | 105 | KAJ7381634.1 Importin subunit alpha-7 [Desmophyllum pertusum] | diamond | 279 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 27777842 | 27777842 | PRJNA700095_P_NODE_34444_length_291_cov_1.486239_g33180_i0 | PRJNA700095 | 34444 | 291 | 1.486239 | 4.32495549 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 73.2 | 1.32e-12 | NR | XP_057314264.1 | 13093 | g33180 | i0 | 46.2 | 0.938144329896907 | 91 | 46 | 93.8 | 2 | 278 | 6 | 365 | 452 | XP_057314264.1 WD repeat-containing protein 36-like isoform X2 [Hydractinia symbiolongicarpus] | diamond | 273 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 27935643 | 27935643 | PRJNA700095_P_NODE_44345_length_265_cov_1.604167_g43081_i0 | PRJNA700095 | 44345 | 265 | 1.604167 | 4.25104255 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 49.7 | 1.8e-4 | NR | XP_044175714.1 | 45264 | g43081 | i0 | 37.3 | 0.849056603773585 | 75 | 45 | 84.9 | 2 | 232 | 8 | 1 | 73 | XP_044175714.1 LOW QUALITY PROTEIN: uncharacterized protein LOC114957777 [Acropora millepora] | diamond | 225 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28925445 | 28925445 | PRJNA700095_P_NODE_30808_length_308_cov_2.017021_g29544_i0 | PRJNA700095 | 30808 | 308 | 2.017021 | 6.21242468 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 107 | 7.37e-25 | NR | XP_065057734.1 | 499914 | g29544 | i0 | 47.5 | 3.93506493506493 | 101 | 50 | 98.4 | 1 | 305 | 3 | 156 | 253 | XP_065057734.1 endoglycoceramidase-like [Rhopilema esculentum] | diamond | 1212 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 28946198 | 28946198 | PRJNA700095_P_NODE_15648_length_465_cov_1.413265_g14386_i0 | PRJNA700095 | 15648 | 465 | 1.413265 | 6.57168225 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 60.5 | 2.68e-7 | NR | XP_029198432.2 | 45264 | g14386 | i0 | 37 | 0.941935483870968 | 73 | 46 | 47.1 | 0 | 107 | 325 | 627 | 699 | XP_029198432.2 LOW QUALITY PROTEIN: ankyrin and armadillo repeat-containing protein-like [Acropora millepora] | diamond | 438 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 29450832 | 29450832 | PRJNA700095_P_NODE_22510_length_367_cov_1.476190_g21246_i0 | PRJNA700095 | 22510 | 367 | 1.47619 | 5.4176173 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 51.6 | 1.21e-4 | NR | CAH3185006.1 | 104759 | g21246 | i0 | 40.5 | 1.65122615803815 | 74 | 41 | 59.7 | 3 | 5 | 223 | 125 | 196 | CAH3185006.1 unnamed protein product [Porites lobata] | diamond | 606 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29671833 | 29671833 | PRJNA700095_P_NODE_21490_length_378_cov_1.511475_g20226_i0 | PRJNA700095 | 21490 | 378 | 1.511475 | 5.7133755 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 3.72e-5 | NR | XP_028411069.1 | 151771 | g20226 | i0 | 40.3 | 1.79365079365079 | 67 | 38 | 53.2 | 2 | 174 | 374 | 63 | 127 | XP_028411069.1 uncharacterized protein LOC114533673 [Dendronephthya gigantea] | diamond | 678 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 29988010 | 29988010 | PRJNA700095_P_NODE_24991_length_344_cov_1.416974_g23727_i0 | PRJNA700095 | 24991 | 344 | 1.416974 | 4.87439056 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 56.2 | 9.85e-7 | NR | XP_046848062.1 | 2897299 | g23727 | i0 | 34 | 1.21220930232558 | 94 | 54 | 77.6 | 3 | 344 | 78 | 6 | 96 | XP_046848062.1 secreted RxLR effector protein 161-like [Xenia sp. Carnegie-2017] | diamond | 417 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 30125299 | 30125299 | PRJNA700095_P_NODE_38572_length_279_cov_3.126214_g37308_i0 | PRJNA700095 | 38572 | 279 | 3.126214 | 8.72213706 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.1 | 2.69e-6 | NR | KAJ7370535.1 | 174260 | g37308 | i0 | 59.5 | 0.870967741935484 | 37 | 15 | 39.8 | 0 | 258 | 148 | 481 | 517 | KAJ7370535.1 Sperm-associated antigen 16 protein [Desmophyllum pertusum] | diamond | 243 | 55.5 | 0.992792792792793 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 30777894 | 30777894 | PRJNA700095_P_NODE_28734_length_317_cov_2.110656_g27470_i0 | PRJNA700095 | 28734 | 317 | 2.110656 | 6.69077952 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 59.7 | 9.85e-8 | NR | XP_065072389.1 | 499914 | g27470 | i0 | 29 | 0.8801261829653 | 93 | 54 | 88 | 2 | 38 | 316 | 529 | 609 | XP_065072389.1 uncharacterized protein LOC135696802 [Rhopilema esculentum] | diamond | 279 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 30872581 | 30872581 | PRJNA700095_P_NODE_10254_length_607_cov_3.617978_g9019_i0 | PRJNA700095 | 10254 | 607 | 3.617978 | 21.96112646 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 153 | 1.6299999999999999e-43 | NR | XP_047130929.1 | 6087 | g9019 | i0 | 51 | 1.58154859967051 | 153 | 71 | 75.6 | 2 | 501 | 43 | 9 | 157 | XP_047130929.1 N-alpha-acetyltransferase 50 isoform X1 [Hydra vulgaris] | diamond | 960 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 31473371 | 31473371 | PRJNA700095_P_NODE_13596_length_510_cov_3.263158_g12341_i0 | PRJNA700095 | 13596 | 510 | 3.263158 | 16.6421058 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 96.7 | 1.04e-19 | NR | XP_046846003.1 | 2897299 | g12341 | i0 | 39.9 | 1.66470588235294 | 138 | 64 | 81.2 | 2 | 59 | 472 | 198 | 316 | XP_046846003.1 WD repeat-containing protein 75-like [Xenia sp. Carnegie-2017] | diamond | 849 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 31852683 | 31852683 | PRJNA700095_P_NODE_26537_length_332_cov_2.235521_g25273_i0 | PRJNA700095 | 26537 | 332 | 2.235521 | 7.42192972 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 88.6 | 8.14e-18 | NR | XP_032234487.2 | 45351 | g25273 | i0 | 45.8 | 2.89156626506024 | 107 | 54 | 93.1 | 1 | 327 | 19 | 221 | 327 | XP_032234487.2 dual oxidase 2 [Nematostella vectensis] | diamond | 960 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32212133 | 32212133 | PRJNA700095_P_NODE_10558_length_596_cov_3.594646_g9320_i0 | PRJNA700095 | 10558 | 596 | 3.594646 | 21.42409016 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 77.8 | 8.99e-13 | NR | XP_031554103.1 | 6105 | g9320 | i0 | 34.4 | 6.97651006711409 | 131 | 73 | 65.9 | 2 | 190 | 582 | 160 | 277 | XP_031554103.1 CCAAT/enhancer-binding protein zeta-like [Actinia tenebrosa] | diamond | 4158 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32580663 | 32580663 | PRJNA700095_P_NODE_11059_length_580_cov_4.575937_g9818_i0 | PRJNA700095 | 11059 | 580 | 4.575937 | 26.5404346 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 80.9 | 7.86e-16 | NR | XP_046858773.1 | 2897299 | g9818 | i0 | 58.8 | 2.66379310344828 | 68 | 27 | 35.2 | 1 | 170 | 373 | 59 | 125 | XP_046858773.1 activated RNA polymerase II transcriptional coactivator p15-like [Xenia sp. Carnegie-2017] | diamond | 1545 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 |
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);;