contig_metadata
23 rows where bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940537 | 2940537 | PRJNA330616_P_NODE_7523_length_303_cov_1.968504_g7114_i0 | PRJNA330616 | 7523 | 303 | 1.968504 | 5.96456712 | Obelia longissima | 32570 | Cnidaria | other_Eukaryota | 309 | 1.5200000000000002e-79 | NTclustered | gi|62825455|gb|AY789864.1| | 32570 | g7114 | i0 | 85.382 | 91.5280528052805 | 301 | 40 | 99 | 4 | 4 | 302 | 56 | 354 | Obelia longissima voucher 656AN calmodulin gene, partial cds | blastn | 27733 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Obeliidae | Obelia | Obelia longissima | |
| 9317817 | 9317817 | PRJNA330616_P_NODE_30948_length_162_cov_0.902655_g30539_i0 | PRJNA330616 | 30948 | 162 | 0.902655 | 1.4623011 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 97.4 | 3.87e-22 | NR | XP_065667066.1 | 6087 | g30539 | i0 | 84.9 | 15.7037037037037 | 53 | 8 | 98.1 | 0 | 160 | 2 | 105 | 157 | XP_065667066.1 26S proteasome regulatory subunit 8 isoform X2 [Hydra vulgaris] | diamond | 2544 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 10593289 | 10593289 | PRJNA330616_P_NODE_16209_length_208_cov_1.283019_g15800_i0 | PRJNA330616 | 16209 | 208 | 1.283019 | 2.66867952 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 110 | 2.62e-28 | NR | XP_066917241.1 | 252671 | g15800 | i0 | 81.5 | 1.90384615384615 | 65 | 12 | 93.8 | 0 | 8 | 202 | 1 | 65 | XP_066917241.1 large ribosomal subunit protein eL19-like [Clytia hemisphaerica] | diamond | 396 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 10593492 | 10593492 | PRJNA330616_P_NODE_31009_length_162_cov_0.902655_g30600_i0 | PRJNA330616 | 31009 | 162 | 0.902655 | 1.4623011 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 86.7 | 3.54e-19 | NR | XP_065065388.1 | 499914 | g30600 | i0 | 76.9 | 9.62962962962963 | 52 | 12 | 96.3 | 0 | 161 | 6 | 120 | 171 | XP_065065388.1 polyadenylate-binding protein 2-B-like [Rhopilema esculentum] | diamond | 1560 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 13822885 | 13822885 | PRJNA330616_P_NODE_3571_length_457_cov_28.306373_g3164_i0 | PRJNA330616 | 3571 | 457 | 28.306373 | 129.36012461 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 135 | 4.28e-27 | NTclustered | gi|2862235116|gb|PQ647263.1| | 880218 | g3164 | i0 | 90.385 | 23.1203501094092 | 104 | 9 | 23 | 1 | 19 | 121 | 6909 | 6806 | Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10566 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Cepheidae | Cephea | Cephea cephea | |
| 18920906 | 18920906 | PRJNA330616_P_NODE_32555_length_161_cov_0.910714_g32146_i0 | PRJNA330616 | 32555 | 161 | 0.910714 | 1.46624954 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 94.4 | 7.580000000000001e-21 | NR | XP_066928988.1 | 252671 | g32146 | i0 | 83 | 10.8447204968944 | 53 | 9 | 98.8 | 0 | 161 | 3 | 109 | 161 | XP_066928988.1 cystathionine beta-synthase-like protein [Clytia hemisphaerica] | diamond | 1746 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 18920912 | 18920912 | PRJNA330616_P_NODE_3555_length_458_cov_47.014670_g3149_i0 | PRJNA330616 | 3555 | 458 | 47.01467 | 215.3271886 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 135 | 4.2900000000000005e-27 | NTclustered | gi|2862235116|gb|PQ647263.1| | 880218 | g3149 | i0 | 90.385 | 22.9519650655022 | 104 | 9 | 22 | 1 | 19 | 121 | 6909 | 6806 | Cephea cephea isolate AGC18069 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10512 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Cepheidae | Cephea | Cephea cephea | |
| 22065950 | 22065950 | PRJNA330616_P_NODE_11398_length_245_cov_1.040816_g10989_i0 | PRJNA330616 | 11398 | 245 | 1.040816 | 2.5499992 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 72.8 | 5.98e-15 | NR | CAH3117927.1 | 104759 | g10989 | i0 | 82.9 | 0.502040816326531 | 41 | 7 | 50.2 | 0 | 245 | 123 | 14 | 54 | CAH3117927.1 unnamed protein product [Porites lobata] | diamond | 123 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 22066003 | 22066003 | PRJNA330616_P_NODE_15298_length_213_cov_2.213415_g14889_i0 | PRJNA330616 | 15298 | 213 | 2.213415 | 4.71457395 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 108 | 3.94e-19 | NTclustered | gi|2257899224|ref|XM_001632976.3| | 45351 | g14889 | i0 | 81.538 | 52.9953051643192 | 130 | 24 | 61 | 0 | 84 | 213 | 887 | 758 | PREDICTED: Nematostella vectensis 60S ribosomal protein L8 (LOC5512708), mRNA | blastn | 11288 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 22066356 | 22066356 | PRJNA330616_P_NODE_9338_length_272_cov_0.910314_g8929_i0 | PRJNA330616 | 9338 | 272 | 0.910314 | 2.47605408 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 115 | 3.9699999999999995e-30 | NR | XP_048581820.1 | 45351 | g8929 | i0 | 65.9 | 7.09191176470588 | 91 | 30 | 99.3 | 1 | 2 | 271 | 27 | 117 | XP_048581820.1 40S ribosomal protein S7-like [Nematostella vectensis] | diamond | 1929 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 22746309 | 22746309 | PRJNA330616_P_NODE_29578_length_163_cov_1.649123_g29169_i0 | PRJNA330616 | 29578 | 163 | 1.649123 | 2.68807049 | Obelia | 32569 | Cnidaria | other_Eukaryota | 200 | 4.589999999999999e-47 | NTclustered | gi|62825455|gb|AY789864.1| | 32570 | g29169 | i0 | 88.889 | 93.5153374233129 | 162 | 18 | 99 | 0 | 2 | 163 | 225 | 64 | Obelia longissima voucher 656AN calmodulin gene, partial cds | blastn | 15243 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Obeliidae | Obelia | Obelia longissima | |
| 26757964 | 26757964 | PRJNA330616_P_NODE_20861_length_185_cov_1.463235_g20452_i0 | PRJNA330616 | 20861 | 185 | 1.463235 | 2.70698475 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 59.7 | 1.82e-9 | NR | XP_020908807.1 | 2652724 | g20452 | i0 | 65.2 | 0.745945945945946 | 46 | 15 | 73 | 1 | 47 | 181 | 1 | 46 | XP_020908807.1 profilin-2 [Exaiptasia diaphana] | diamond | 138 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 27154698 | 27154698 | PRJNA330616_P_NODE_26742_length_166_cov_0.871795_g26333_i0 | PRJNA330616 | 26742 | 166 | 0.871795 | 1.4471797 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 88.6 | 8.03e-19 | NR | XP_068745649.1 | 246305 | g26333 | i0 | 74.5 | 13.8975903614458 | 55 | 14 | 99.4 | 0 | 2 | 166 | 290 | 344 | XP_068745649.1 annexin A5-like isoform X2 [Montipora capricornis] | diamond | 2307 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 28653681 | 28653681 | PRJNA330616_P_NODE_18267_length_197_cov_1.135135_g17858_i0 | PRJNA330616 | 18267 | 197 | 1.135135 | 2.23621595 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 90.9 | 4.9e-20 | NR | XP_065068984.1 | 499914 | g17858 | i0 | 63.1 | 0.989847715736041 | 65 | 24 | 99 | 0 | 195 | 1 | 179 | 243 | XP_065068984.1 large ribosomal subunit protein uL18-like [Rhopilema esculentum] | diamond | 195 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 29127486 | 29127486 | PRJNA330616_P_NODE_23849_length_173_cov_1.564516_g23440_i0 | PRJNA330616 | 23849 | 173 | 1.564516 | 2.70661268 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 67.8 | 3.2e-12 | NR | XP_068705947.1 | 591990 | g23440 | i0 | 78.4 | 2.53179190751445 | 37 | 8 | 64.2 | 0 | 2 | 112 | 142 | 178 | XP_068705947.1 large ribosomal subunit protein uL30-like [Montipora foliosa] | diamond | 438 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 29997278 | 29997278 | PRJNA330616_P_NODE_15871_length_210_cov_1.267081_g15462_i0 | PRJNA330616 | 15871 | 210 | 1.267081 | 2.6608701 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 137 | 1.5499999999999998e-37 | NR | KAK2573205.1 | 6130 | g15462 | i0 | 82.6 | 29.5714285714286 | 69 | 12 | 98.6 | 0 | 209 | 3 | 149 | 217 | KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis] | diamond | 6210 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30091715 | 30091715 | PRJNA330616_P_NODE_31332_length_162_cov_0.902655_g30923_i0 | PRJNA330616 | 31332 | 162 | 0.902655 | 1.4623011 | root | 1 | Root_unresolved | Root_unresolved | 80.1 | 5.01e-16 | NR | XP_028406296.1 | 151771 | g30923 | i0 | 63 | 7.98148148148148 | 54 | 20 | 100 | 0 | 1 | 162 | 31 | 84 | XP_028406296.1 UDP-glucose 4-epimerase-like isoform X2 [Dendronephthya gigantea] | diamond | 1293 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 30832885 | 30832885 | PRJNA330616_P_NODE_20114_length_188_cov_1.460432_g19705_i0 | PRJNA330616 | 20114 | 188 | 1.460432 | 2.74561216 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 85.5 | 1.17e-18 | NR | CAB4030084.1 | 317549 | g19705 | i0 | 57.1 | 2.01063829787234 | 63 | 24 | 95.7 | 1 | 4 | 183 | 19 | 81 | CAB4030084.1 plexin-A4-like [Paramuricea clavata] | diamond | 378 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 30850138 | 30850138 | PRJNA330616_P_NODE_25594_length_167_cov_0.864407_g25185_i0 | PRJNA330616 | 25594 | 167 | 0.864407 | 1.44355969 | Malacalcyonacea | 3028843 | Cnidaria | other_Eukaryota | 45.1 | 0.00206 | NR | XP_028409951.1 | 151771 | g25185 | i0 | 58.8 | 3.95209580838323 | 34 | 14 | 61.1 | 0 | 19 | 120 | 1105 | 1138 | XP_028409951.1 cleavage and polyadenylation specificity factor subunit 1-like [Dendronephthya gigantea] | diamond | 660 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31306878 | 31306878 | PRJNA330616_P_NODE_13995_length_222_cov_3.537572_g13586_i0 | PRJNA330616 | 13995 | 222 | 3.537572 | 7.85340984 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 44.7 | 0.0057 | NR | XP_068680545.1 | 591990 | g13586 | i0 | 52.3 | 2.37837837837838 | 44 | 21 | 59.5 | 0 | 7 | 138 | 240 | 283 | XP_068680545.1 uncharacterized protein [Montipora foliosa] | diamond | 528 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 31306892 | 31306892 | PRJNA330616_P_NODE_32895_length_156_cov_2.859813_g32486_i0 | PRJNA330616 | 32895 | 156 | 2.859813 | 4.46130828 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 92.4 | 1.56e-20 | NR | XP_031564938.1 | 6105 | g32486 | i0 | 78.8 | 4 | 52 | 11 | 100 | 0 | 156 | 1 | 85 | 136 | XP_031564938.1 gelsolin-like protein 1 isoform X2 [Actinia tenebrosa] | diamond | 624 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31813009 | 31813009 | PRJNA330616_P_NODE_25557_length_167_cov_0.864407_g25148_i0 | PRJNA330616 | 25557 | 167 | 0.864407 | 1.44355969 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 88.6 | 6.22e-19 | NR | KAJ7374632.1 | 174260 | g25148 | i0 | 76.4 | 3.95209580838323 | 55 | 13 | 98.8 | 0 | 166 | 2 | 36 | 90 | KAJ7374632.1 DnaJ sub A member 2 [Desmophyllum pertusum] | diamond | 660 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 32526741 | 32526741 | PRJNA330616_P_NODE_8119_length_291_cov_1.859504_g7710_i0 | PRJNA330616 | 8119 | 291 | 1.859504 | 5.41115664 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 146 | 2.41e-40 | NR | XP_031564938.1 | 6105 | g7710 | i0 | 68 | 11 | 97 | 31 | 100 | 0 | 1 | 291 | 16 | 112 | XP_031564938.1 gelsolin-like protein 1 isoform X2 [Actinia tenebrosa] | diamond | 3201 | 147 | 0.993197278911565 | 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);;