contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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);;