contig_metadata
21 rows where bioproject = "PRJNA1180292", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9245787 | 9245787 | PRJNA1180292_P_NODE_6608_length_274_cov_1.164179_g6476_i0 | PRJNA1180292 | 6608 | 274 | 1.164179 | 3.18985046 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 202 | 2.3599999999999996e-47 | NTclustered | gi|2918369558|emb|OZ237728.1| | 317547 | g6476 | i0 | 81.423 | 7.00729927007299 | 253 | 41 | 91 | 5 | 1 | 249 | 3378862 | 3378612 | Eunicella cavolini genome assembly, chromosome: 12 | blastn | 1920 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 16895053 | 16895053 | PRJNA1180292_P_NODE_9334_length_250_cov_0.881356_g9202_i0 | PRJNA1180292 | 9334 | 250 | 0.881356 | 2.20339 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 99.4 | 4.8e-22 | NR | XP_020612968.1 | 48498 | g9202 | i0 | 78 | 13.212 | 59 | 13 | 70.8 | 0 | 248 | 72 | 658 | 716 | XP_020612968.1 pre-mRNA-splicing factor CWC22 homolog [Orbicella faveolata] | diamond | 3303 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 19443861 | 19443861 | PRJNA1180292_P_NODE_4396_length_330_cov_1.517510_g4264_i0 | PRJNA1180292 | 4396 | 330 | 1.51751 | 5.007783 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 217 | 1.04e-51 | NTclustered | gi|2918369565|emb|OZ237731.1| | 317547 | g4264 | i0 | 81.319 | 76.3787878787879 | 273 | 45 | 82 | 3 | 5 | 274 | 9680292 | 9680561 | Eunicella cavolini genome assembly, chromosome: 15 | blastn | 25205 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 19443904 | 19443904 | PRJNA1180292_P_NODE_7296_length_261_cov_2.191489_g7164_i0 | PRJNA1180292 | 7296 | 261 | 2.191489 | 5.71978629 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 119 | 2.8799999999999997e-32 | NR | XP_044172593.1 | 45264 | g7164 | i0 | 89.1 | 2.18390804597701 | 64 | 7 | 73.6 | 0 | 193 | 2 | 38 | 101 | XP_044172593.1 60S ribosomal protein L44-like [Acropora millepora] | diamond | 570 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 21994538 | 21994538 | PRJNA1180292_P_NODE_3638_length_359_cov_1.090909_g3506_i0 | PRJNA1180292 | 3638 | 359 | 1.090909 | 3.91636331 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 164 | 9.1e-45 | NR | XP_065644225.1 | 6087 | g3506 | i0 | 65.2 | 8.61559888579387 | 115 | 40 | 96.1 | 0 | 345 | 1 | 30 | 144 | XP_065644225.1 propionyl-CoA carboxylase alpha chain, mitochondrial isoform X2 [Hydra vulgaris] | diamond | 3093 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 21994554 | 21994554 | PRJNA1180292_P_NODE_5158_length_306_cov_3.562232_g5026_i0 | PRJNA1180292 | 5158 | 306 | 3.562232 | 10.90042992 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 191 | 8.649999999999999e-60 | NR | CAH3123479.1 | 104759 | g5026 | i0 | 87.1 | 7.92156862745098 | 101 | 13 | 99 | 0 | 303 | 1 | 40 | 140 | CAH3123479.1 unnamed protein product [Porites lobata] | diamond | 2424 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 21994560 | 21994560 | PRJNA1180292_P_NODE_5918_length_287_cov_1.855140_g5786_i0 | PRJNA1180292 | 5918 | 287 | 1.85514 | 5.3242518 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2744889029|ref|XM_065810454.1| | 6087 | g5786 | i0 | 100 | 0.202090592334495 | 29 | 0 | 10 | 0 | 221 | 249 | 2276 | 2248 | PREDICTED: Hydra vulgaris kinesin-like protein KIF28P (LOC100208423), transcript variant X3, mRNA | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 21994607 | 21994607 | PRJNA1180292_P_NODE_978_length_708_cov_2.431496_g850_i0 | PRJNA1180292 | 978 | 708 | 2.431496 | 17.21499168 | Calycella syringa | 314529 | Cnidaria | other_Eukaryota | 122 | 5.319999999999999e-23 | NTclustered | gi|256674468|gb|FJ550372.1| | 314529 | g850 | i0 | 86.087 | 14.1935028248588 | 115 | 14 | 16 | 2 | 526 | 639 | 1567 | 1454 | Calycella syringa 28S ribosomal RNA gene, partial sequence | blastn | 10049 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Campanulariidae | Calycella | Calycella syringa | |
| 24543885 | 24543885 | PRJNA1180292_P_NODE_7160_length_264_cov_1.319372_g7028_i0 | PRJNA1180292 | 7160 | 264 | 1.319372 | 3.48314208 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 161 | 3.84e-35 | NTclustered | gi|1270049062|ref|XM_022930896.1| | 50429 | g7028 | i0 | 85.806 | 3.97727272727273 | 155 | 18 | 58 | 4 | 20 | 172 | 334 | 486 | PREDICTED: Stylophora pistillata calreticulin-like (LOC111326816), partial mRNA | blastn | 1050 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27439290 | 27439290 | PRJNA1180292_P_NODE_10503_length_247_cov_0.896552_g10371_i0 | PRJNA1180292 | 10503 | 247 | 0.896552 | 2.21448344 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 62 | 6.25e-9 | NR | PFX20727.1 | 50429 | g10371 | i0 | 48.1 | 5.30769230769231 | 54 | 27 | 64.4 | 1 | 200 | 42 | 852 | 905 | PFX20727.1 5-hydroxytryptamine receptor 4 [Stylophora pistillata] | diamond | 1311 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 27691925 | 27691925 | PRJNA1180292_P_NODE_10944_length_246_cov_0.901734_g10812_i0 | PRJNA1180292 | 10944 | 246 | 0.901734 | 2.21826564 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 80.1 | 2.24e-15 | NR | XP_057297052.1 | 13093 | g10812 | i0 | 43.4 | 2.02439024390244 | 83 | 43 | 96.3 | 3 | 241 | 5 | 41 | 123 | XP_057297052.1 gamma-butyrobetaine dioxygenase-like [Hydractinia symbiolongicarpus] | diamond | 498 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 27912405 | 27912405 | PRJNA1180292_P_NODE_2425_length_437_cov_1.329670_g2293_i0 | PRJNA1180292 | 2425 | 437 | 1.32967 | 5.8106579 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 192 | 1.5799999999999998e-58 | NR | XP_057289659.1 | 13093 | g2293 | i0 | 66.9 | 5.97254004576659 | 145 | 48 | 99.5 | 0 | 1 | 435 | 55 | 199 | XP_057289659.1 60S ribosomal protein L7a-like [Hydractinia symbiolongicarpus] | diamond | 2610 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 28114351 | 28114351 | PRJNA1180292_P_NODE_7845_length_253_cov_0.866667_g7713_i0 | PRJNA1180292 | 7845 | 253 | 0.866667 | 2.19266751 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 90.9 | 4.81e-19 | NR | XP_065059000.1 | 499914 | g7713 | i0 | 53.1 | 2.90513833992095 | 81 | 38 | 96 | 0 | 244 | 2 | 118 | 198 | XP_065059000.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1-like [Rhopilema esculentum] | diamond | 735 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 28114352 | 28114352 | PRJNA1180292_P_NODE_8045_length_253_cov_0.866667_g7913_i0 | PRJNA1180292 | 8045 | 253 | 0.866667 | 2.19266751 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 80.1 | 2.34e-15 | NR | EDO35929.1 | 45351 | g7913 | i0 | 43.5 | 3.23715415019763 | 92 | 41 | 96 | 3 | 4 | 246 | 304 | 395 | EDO35929.1 predicted protein [Nematostella vectensis] | diamond | 819 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 28525110 | 28525110 | PRJNA1180292_P_NODE_11987_length_244_cov_0.912281_g11855_i0 | PRJNA1180292 | 11987 | 244 | 0.912281 | 2.22596564 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 52 | 2.03e-5 | NR | XP_046854557.1 | 2897299 | g11855 | i0 | 40.7 | 1.3155737704918 | 54 | 32 | 66.4 | 0 | 166 | 5 | 31 | 84 | XP_046854557.1 LOW QUALITY PROTEIN: protein asteroid homolog 1-like [Xenia sp. Carnegie-2017] | diamond | 321 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28575600 | 28575600 | PRJNA1180292_P_NODE_3947_length_346_cov_1.098901_g3815_i0 | PRJNA1180292 | 3947 | 346 | 1.098901 | 3.80219746 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 122 | 9.58e-32 | NR | XP_031558347.1 | 6105 | g3815 | i0 | 61.1 | 8.13294797687861 | 90 | 35 | 78 | 0 | 272 | 3 | 41 | 130 | XP_031558347.1 RNA-binding protein pno1 [Actinia tenebrosa] | diamond | 2814 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29648774 | 29648774 | PRJNA1180292_P_NODE_10810_length_247_cov_0.896552_g10678_i0 | PRJNA1180292 | 10810 | 247 | 0.896552 | 2.21448344 | Porites | 46719 | Cnidaria | other_Eukaryota | 85.5 | 2.51e-17 | NR | CAH3024144.1 | 104178 | g10678 | i0 | 78.9 | 1.38461538461538 | 57 | 9 | 65.6 | 1 | 162 | 1 | 19 | 75 | CAH3024144.1 unnamed protein product [Porites evermanni] | diamond | 342 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites evermanni | |
| 30482987 | 30482987 | PRJNA1180292_P_NODE_11653_length_245_cov_0.906977_g11521_i0 | PRJNA1180292 | 11653 | 245 | 0.906977 | 2.22209365 | Orbicella faveolata | 48498 | Cnidaria | other_Eukaryota | 52.4 | 1.46e-5 | NR | XP_020601002.1 | 48498 | g11521 | i0 | 40.5 | 0.96734693877551 | 79 | 31 | 77.1 | 1 | 191 | 3 | 1 | 79 | XP_020601002.1 ammonium transporter Rh type B-like isoform X5 [Orbicella faveolata] | diamond | 237 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 32000438 | 32000438 | PRJNA1180292_P_NODE_6498_length_276_cov_1.399015_g6366_i0 | PRJNA1180292 | 6498 | 276 | 1.399015 | 3.8612814 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 78.6 | 1.35e-14 | NR | XP_065058844.1 | 499914 | g6366 | i0 | 48.6 | 0.804347826086957 | 74 | 38 | 80.4 | 0 | 276 | 55 | 311 | 384 | XP_065058844.1 alpha-(1,3)-fucosyltransferase 10-like [Rhopilema esculentum] | diamond | 222 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 32272944 | 32272944 | PRJNA1180292_P_NODE_6438_length_277_cov_1.529412_g6306_i0 | PRJNA1180292 | 6438 | 277 | 1.529412 | 4.23647124 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94 | 5.39e-20 | NR | XP_065675414.1 | 6087 | g6306 | i0 | 75.8 | 11.0361010830325 | 62 | 15 | 67.1 | 0 | 87 | 272 | 7 | 68 | XP_065675414.1 vacuolar protein sorting-associated protein 35 isoform X3 [Hydra vulgaris] | diamond | 3057 | 94.4 | 0.995762711864407 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 32506944 | 32506944 | PRJNA1180292_P_NODE_8479_length_252_cov_0.871508_g8347_i0 | PRJNA1180292 | 8479 | 252 | 0.871508 | 2.19620016 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 49.7 | 1.44e-4 | NR | XP_065644275.1 | 6087 | g8347 | i0 | 36.4 | 1.83333333333333 | 77 | 45 | 91.7 | 2 | 5 | 235 | 267 | 339 | XP_065644275.1 renin receptor isoform X2 [Hydra vulgaris] | diamond | 462 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;