contig_metadata
19 rows where bioproject = "PRJNA492406", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452741 | 452741 | PRJNA492406_P_NODE_32261_length_240_cov_2.323353_g31962_i0 | PRJNA492406 | 32261 | 240 | 2.323353 | 5.5760472 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 58.4 | 4.64e-4 | NTclustered | gi|2729072214|ref|XM_065198259.1| | 499914 | g31962 | i0 | 100 | 0.129166666666667 | 31 | 0 | 13 | 0 | 17 | 47 | 1907 | 1877 | PREDICTED: Rhopilema esculentum huntingtin-interacting protein 1-like (LOC135683099), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 3002908 | 3002908 | PRJNA492406_P_NODE_10663_length_378_cov_1.947541_g10364_i0 | PRJNA492406 | 10663 | 378 | 1.947541 | 7.36170498 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 617 | 2.83e-172 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g10364 | i0 | 99.704 | 42.531746031746 | 338 | 0 | 89 | 1 | 1 | 338 | 337 | 1 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16077 | 617 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 4279923 | 4279923 | PRJNA492406_P_NODE_9564_length_397_cov_0.861111_g9265_i0 | PRJNA492406 | 9564 | 397 | 0.861111 | 3.41861067 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 141 | 7.81e-37 | NR | XP_065669973.1 | 6087 | g9265 | i0 | 66.4 | 6.50629722921914 | 110 | 37 | 83.1 | 0 | 2 | 331 | 395 | 504 | XP_065669973.1 annexin-B12-like isoform X2 [Hydra vulgaris] | diamond | 2583 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 6830341 | 6830341 | PRJNA492406_P_NODE_6566_length_469_cov_2.818182_g6267_i0 | PRJNA492406 | 6566 | 469 | 2.818182 | 13.21727358 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 861 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g6267 | i0 | 99.787 | 6.62473347547974 | 469 | 1 | 100 | 0 | 1 | 469 | 1531 | 1063 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 3107 | 861 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 9380473 | 9380473 | PRJNA492406_P_NODE_28668_length_247_cov_0.885057_g28369_i0 | PRJNA492406 | 28668 | 247 | 0.885057 | 2.18609079 | Eunicea flexuosa | 437162 | Cnidaria | other_Eukaryota | 87.9 | 6.12e-13 | NTclustered | gi|2689317196|gb|PP410695.1| | 437162 | g28369 | i0 | 88 | 0.607287449392713 | 75 | 5 | 30 | 4 | 174 | 247 | 2068 | 2139 | Eunicea flexuosa voucher USNM:1606843 large subunit ribosomal RNA gene, partial sequence | blastn | 150 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Eunicea | Eunicea flexuosa | |
| 15127277 | 15127277 | PRJNA492406_P_NODE_24792_length_259_cov_16.736559_g24493_i0 | PRJNA492406 | 24792 | 259 | 16.736559 | 43.34768781 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 78.7 | 3.89e-10 | NTclustered | gi|167507753|gb|EU262856.1| | 44304 | g24493 | i0 | 100 | 16.1853281853282 | 42 | 0 | 16 | 0 | 218 | 259 | 151 | 192 | Favia fragum isolate 164 28S large subunit ribosomal RNA gene, partial sequence | blastn | 4192 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Mussidae | Favia | Favia fragum | |
| 17029503 | 17029503 | PRJNA492406_P_NODE_12034_length_358_cov_9.136842_g11735_i0 | PRJNA492406 | 12034 | 358 | 9.136842 | 32.70989436 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 662 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g11735 | i0 | 100 | 17.0083798882682 | 358 | 0 | 100 | 0 | 1 | 358 | 1964 | 2321 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 6089 | 662 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 17676952 | 17676952 | PRJNA492406_P_NODE_3054_length_689_cov_22.543831_g2765_i0 | PRJNA492406 | 3054 | 689 | 22.543831 | 155.32699559 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 215 | 8.29e-51 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g2765 | i0 | 74.923 | 25.4484760522496 | 646 | 75 | 92 | 47 | 59 | 689 | 400 | 973 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 17534 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 26696465 | 26696465 | PRJNA492406_P_NODE_20941_length_279_cov_1.276699_g20642_i0 | PRJNA492406 | 20941 | 279 | 1.276699 | 3.56199021 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 59.7 | 6.3e-8 | NR | XP_065066914.1 | 499914 | g20642 | i0 | 39.1 | 3.88172043010753 | 64 | 31 | 68.8 | 1 | 275 | 84 | 1075 | 1130 | XP_065066914.1 FYVE, RhoGEF and PH domain-containing protein 1-like [Rhopilema esculentum] | diamond | 1083 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 26807687 | 26807687 | PRJNA492406_P_NODE_30241_length_244_cov_1.292398_g29942_i0 | PRJNA492406 | 30241 | 244 | 1.292398 | 3.15345112 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 55.8 | 9.45e-7 | NR | XP_031561034.1 | 6105 | g29942 | i0 | 35.4 | 5.72950819672131 | 79 | 50 | 97.1 | 1 | 8 | 244 | 1917 | 1994 | XP_031561034.1 WD repeat-containing protein 81-like isoform X1 [Actinia tenebrosa] | diamond | 1398 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 27645294 | 27645294 | PRJNA492406_P_NODE_29804_length_245_cov_0.895349_g29505_i0 | PRJNA492406 | 29804 | 245 | 0.895349 | 2.19360505 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 64.7 | 7.03e-10 | NR | XP_065060961.1 | 499914 | g29505 | i0 | 47.1 | 0.83265306122449 | 68 | 36 | 83.3 | 0 | 2 | 205 | 776 | 843 | XP_065060961.1 coatomer subunit beta'-like isoform X1 [Rhopilema esculentum] | diamond | 204 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 28055409 | 28055409 | PRJNA492406_P_NODE_22265_length_272_cov_1.557789_g21966_i0 | PRJNA492406 | 22265 | 272 | 1.557789 | 4.23718608 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 88.6 | 4.04e-18 | NR | CAH3162736.1 | 104759 | g21966 | i0 | 55.1 | 0.981617647058823 | 89 | 39 | 98.2 | 1 | 269 | 3 | 6 | 93 | CAH3162736.1 unnamed protein product [Porites lobata] | diamond | 267 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 29224002 | 29224002 | PRJNA492406_P_NODE_19449_length_286_cov_1.347418_g19150_i0 | PRJNA492406 | 19449 | 286 | 1.347418 | 3.85361548 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 50.1 | 1.74e-4 | NR | CAH3129810.1 | 46732 | g19150 | i0 | 52.4 | 3.14685314685315 | 42 | 20 | 44.1 | 0 | 160 | 285 | 1556 | 1597 | CAH3129810.1 unnamed protein product [Pocillopora meandrina] | diamond | 900 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 30329705 | 30329705 | PRJNA492406_P_NODE_31772_length_241_cov_1.726190_g31473_i0 | PRJNA492406 | 31772 | 241 | 1.72619 | 4.1601179 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 113 | 3.1699999999999998e-28 | NR | XP_028402690.1 | 151771 | g31473 | i0 | 67.5 | 2.02904564315353 | 83 | 24 | 99.6 | 1 | 2 | 241 | 119 | 201 | XP_028402690.1 protein FAM49B-like [Dendronephthya gigantea] | diamond | 489 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30345720 | 30345720 | PRJNA492406_P_NODE_16432_length_309_cov_1.305085_g16133_i0 | PRJNA492406 | 16432 | 309 | 1.305085 | 4.03271265 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 1.33e-39 | NR | KAF0990030.1 | 69463 | g16133 | i0 | 67 | 12.4757281553398 | 100 | 31 | 97.1 | 1 | 3 | 302 | 29 | 126 | KAF0990030.1 hypothetical protein HZS_7580, partial [Henneguya salminicola] | diamond | 3855 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31625012 | 31625012 | PRJNA492406_P_NODE_31576_length_242_cov_0.911243_g31277_i0 | PRJNA492406 | 31576 | 242 | 0.911243 | 2.20520806 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 45.4 | 0.00121 | NR | CAH3153049.1 | 46732 | g31277 | i0 | 32.1 | 1.99586776859504 | 81 | 43 | 96.7 | 3 | 241 | 8 | 45 | 116 | CAH3153049.1 unnamed protein product, partial [Pocillopora meandrina] | diamond | 483 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 31704276 | 31704276 | PRJNA492406_P_NODE_29217_length_246_cov_0.890173_g28918_i0 | PRJNA492406 | 29217 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 106 | 1.72e-24 | NR | XP_032242812.1 | 45351 | g28918 | i0 | 53.1 | 4.91463414634146 | 81 | 38 | 98.8 | 0 | 2 | 244 | 472 | 552 | XP_032242812.1 uncharacterized protein LOC5517012 [Nematostella vectensis] | diamond | 1209 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31941198 | 31941198 | PRJNA492406_P_NODE_21937_length_274_cov_1.288557_g21638_i0 | PRJNA492406 | 21937 | 274 | 1.288557 | 3.53064618 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 75.9 | 1.26e-13 | NR | XP_031552562.1 | 6105 | g21638 | i0 | 40 | 2.69343065693431 | 90 | 54 | 98.5 | 0 | 271 | 2 | 1211 | 1300 | XP_031552562.1 uncharacterized protein LOC116289757 [Actinia tenebrosa] | diamond | 738 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32163022 | 32163022 | PRJNA492406_P_NODE_18738_length_289_cov_1.328704_g18439_i0 | PRJNA492406 | 18738 | 289 | 1.328704 | 3.83995456 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 84.3 | 1.63e-16 | NR | XP_057316526.1 | 13093 | g18439 | i0 | 65.7 | 8.50173010380623 | 67 | 23 | 69.6 | 0 | 8 | 208 | 1485 | 1551 | XP_057316526.1 talin-2-like isoform X3 [Hydractinia symbiolongicarpus] | diamond | 2457 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus |
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);;