contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1010780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155117 | 155117 | PRJNA1010780_S_NODE_23601_length_336_cov_3.398671_g22312_i0 | PRJNA1010780 | 23601 | 336 | 3.398671 | 11.41953456 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 117 | 1.11e-21 | NTclustered | gi|2744797358|ref|XM_002154426.5| | 6087 | g22312 | i0 | 92.683 | 3.67857142857143 | 82 | 4 | 24 | 2 | 18 | 98 | 1235 | 1315 | PREDICTED: Hydra vulgaris actin, non-muscle 6.2-like (LOC100202036), mRNA | blastn | 1236 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 1429884 | 1429884 | PRJNA1010780_S_NODE_25802_length_307_cov_3.077206_g24513_i0 | PRJNA1010780 | 25802 | 307 | 3.077206 | 9.44702242 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g24513 | i0 | 100 | 0.0912052117263844 | 28 | 0 | 9 | 0 | 15 | 42 | 20152496 | 20152523 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1429896 | 1429896 | PRJNA1010780_S_NODE_27922_length_284_cov_1.955823_g26633_i0 | PRJNA1010780 | 27922 | 284 | 1.955823 | 5.55453732 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 69.4 | 2.6e-7 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g26633 | i0 | 80.189 | 1.09859154929577 | 106 | 10 | 33 | 9 | 51 | 145 | 528328 | 528433 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 312 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 2705429 | 2705429 | PRJNA1010780_S_NODE_42163_length_198_cov_7.128834_g40874_i0 | PRJNA1010780 | 42163 | 198 | 7.128834 | 14.11509132 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 2.2e-6 | NTclustered | gi|2917940740|emb|OZ237567.1| | 6108 | g40874 | i0 | 95.122 | 44.9242424242424 | 41 | 2 | 21 | 0 | 157 | 197 | 3950004 | 3949964 | Anemonia sulcata genome assembly, chromosome: 13 | blastn | 8895 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 3981581 | 3981581 | PRJNA1010780_S_NODE_39684_length_208_cov_2.063584_g38395_i0 | PRJNA1010780 | 39684 | 208 | 2.063584 | 4.29225472 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 130 | 8.18e-26 | NTclustered | gi|2782878184|ref|XM_067062654.1| | 252671 | g38395 | i0 | 80 | 1.73076923076923 | 180 | 32 | 86 | 4 | 23 | 200 | 2012 | 2189 | PREDICTED: Clytia hemisphaerica major vault protein-like (LOC136806084), transcript variant X2, mRNA | blastn | 360 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 6533302 | 6533302 | PRJNA1010780_S_NODE_31066_length_257_cov_1.657658_g29777_i0 | PRJNA1010780 | 31066 | 257 | 1.657658 | 4.26018106 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g29777 | i0 | 88.636 | 0.171206225680934 | 44 | 5 | 17 | 0 | 15 | 58 | 30009430 | 30009387 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 44 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7807601 | 7807601 | PRJNA1010780_S_NODE_16867_length_481_cov_16.544843_g15606_i0 | PRJNA1010780 | 16867 | 481 | 16.544843 | 79.58069483 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 226 | 2.6099999999999998e-54 | NTclustered | gi|2744794010|ref|XM_012698561.3| | 6087 | g15606 | i0 | 81.119 | 18.6632016632017 | 286 | 50 | 59 | 4 | 1 | 284 | 307 | 590 | PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA | blastn | 8977 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 7807776 | 7807776 | PRJNA1010780_S_NODE_59947_length_155_cov_1.791667_g58658_i0 | PRJNA1010780 | 59947 | 155 | 1.791667 | 2.77708385 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 87.9 | 3.49e-13 | NTclustered | gi|2782862607|ref|XM_067059259.1| | 252671 | g58658 | i0 | 79.528 | 2.0258064516129 | 127 | 22 | 81 | 3 | 23 | 147 | 315 | 191 | PREDICTED: Clytia hemisphaerica large ribosomal subunit protein eL32-like (LOC136802519), transcript variant X2, mRNA | blastn | 314 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 12480343 | 12480343 | PRJNA1010780_S_NODE_24750_length_320_cov_3.452632_g23461_i0 | PRJNA1010780 | 24750 | 320 | 3.452632 | 11.0484224 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|1603808421|ref|XM_028552577.1| | 151771 | g23461 | i0 | 96.875 | 0.66875 | 32 | 1 | 10 | 0 | 2 | 33 | 588 | 619 | PREDICTED: Dendronephthya gigantea protein PFC0760c-like (LOC114530953), transcript variant X2, mRNA | blastn | 214 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 12908757 | 12908757 | PRJNA1010780_S_NODE_19911_length_404_cov_5.211382_g18623_i0 | PRJNA1010780 | 19911 | 404 | 5.211382 | 21.05398328 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 231 | 4.6399999999999995e-56 | NTclustered | gi|2202645792|ref|XM_046996420.1| | 2897299 | g18623 | i0 | 81.786 | 7.69306930693069 | 280 | 47 | 69 | 3 | 41 | 317 | 91 | 369 | PREDICTED: Xenia sp. Carnegie-2017 RING-box protein 1-like (LOC124445670), mRNA | blastn | 3108 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 12908934 | 12908934 | PRJNA1010780_S_NODE_6791_length_1019_cov_36.436992_g6102_i0 | PRJNA1010780 | 6791 | 1019 | 36.436992 | 371.29294848 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 56.5 | 0.008 | NTclustered | gi|2202619512|ref|XM_046988189.1| | 2897299 | g6102 | i0 | 100 | 0.0294406280667321 | 30 | 0 | 3 | 0 | 293 | 322 | 2171 | 2142 | PREDICTED: Xenia sp. Carnegie-2017 serine/threonine-protein kinase/endoribonuclease IRE2-like (LOC124438173), transcript variant X1, mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 16732082 | 16732082 | PRJNA1010780_S_NODE_47774_length_181_cov_1.445205_g46485_i0 | PRJNA1010780 | 47774 | 181 | 1.445205 | 2.61582105 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 60.2 | 9.19e-5 | NTclustered | gi|2744875551|ref|XM_065804233.1| | 6087 | g46485 | i0 | 97.222 | 0.596685082872928 | 36 | 0 | 19 | 1 | 144 | 178 | 278 | 313 | PREDICTED: Hydra vulgaris uncharacterized LOC136084085 (LOC136084085), transcript variant X1, mRNA | blastn | 108 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 18006929 | 18006929 | PRJNA1010780_S_NODE_42475_length_197_cov_2.660494_g41186_i0 | PRJNA1010780 | 42475 | 197 | 2.660494 | 5.24117318 | Lytocarpia phyteuma | 308672 | Cnidaria | other_Eukaryota | 99 | 2.16e-16 | NTclustered | gi|1560754620|gb|MH155638.1| | 308672 | g41186 | i0 | 77.439 | 13.3654822335025 | 164 | 37 | 83 | 0 | 25 | 188 | 169 | 6 | Lytocarpia phyteuma isolate GLO08-028 calmodulin gene, partial cds | blastn | 2633 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Aglaopheniidae | Lytocarpia | Lytocarpia phyteuma | |
| 18006933 | 18006933 | PRJNA1010780_S_NODE_43575_length_193_cov_3.563291_g42286_i0 | PRJNA1010780 | 43575 | 193 | 3.563291 | 6.87715163 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 93.5 | 9.8e-15 | NTclustered | gi|2518998737|ref|XM_057450856.1| | 13093 | g42286 | i0 | 90.141 | 9.35233160621762 | 71 | 7 | 37 | 0 | 1 | 71 | 1373 | 1443 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA | blastn | 1805 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 19280759 | 19280759 | PRJNA1010780_S_NODE_60576_length_154_cov_1.815126_g59287_i0 | PRJNA1010780 | 60576 | 154 | 1.815126 | 2.79529404 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 62.1 | 2.1e-5 | NTclustered | gi|2744883918|ref|XM_065808086.1| | 6087 | g59287 | i0 | 94.872 | 2.97402597402597 | 39 | 2 | 25 | 0 | 55 | 93 | 696 | 658 | PREDICTED: Hydra vulgaris MORN repeat-containing protein 3 (LOC100198910), transcript variant X2, mRNA | blastn | 458 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 20556256 | 20556256 | PRJNA1010780_S_NODE_23637_length_336_cov_1.973422_g22348_i0 | PRJNA1010780 | 23637 | 336 | 1.973422 | 6.63069792 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1778066117|ref|XM_031714681.1| | 6105 | g22348 | i0 | 100 | 0.0833333333333333 | 28 | 0 | 8 | 0 | 146 | 173 | 736 | 709 | PREDICTED: Actinia tenebrosa POC1 centriolar protein homolog A-like (LOC116304893), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 20556267 | 20556267 | PRJNA1010780_S_NODE_25217_length_314_cov_4.684588_g23928_i0 | PRJNA1010780 | 25217 | 314 | 4.684588 | 14.70960632 | Gymnangium allmani | 1673618 | Cnidaria | other_Eukaryota | 324 | 5.64e-84 | NTclustered | gi|857023377|gb|KM587274.1| | 1673618 | g23928 | i0 | 85.623 | 98.6624203821656 | 313 | 39 | 99 | 5 | 3 | 312 | 311 | 2 | Gymnangium allmani voucher NCLB048 Calmodulin (CAM) gene, partial cds | blastn | 30980 | 324 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Aglaopheniidae | Gymnangium | Gymnangium allmani | |
| 20556429 | 20556429 | PRJNA1010780_S_NODE_6517_length_1047_cov_6.352767_g4981_i1 | PRJNA1010780 | 6517 | 1047 | 6.352767 | 66.51347049 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 374 | 1.9999999999999992e-98 | NTclustered | gi|2202643314|ref|XM_046995644.1| | 2897299 | g4981 | i1 | 84.197 | 35.4231136580707 | 386 | 59 | 37 | 2 | 661 | 1045 | 1028 | 644 | PREDICTED: Xenia sp. Carnegie-2017 calmodulin-like protein 12 (LOC124444943), mRNA | blastn | 37088 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 24381277 | 24381277 | PRJNA1010780_S_NODE_63640_length_150_cov_1.243478_g62351_i0 | PRJNA1010780 | 63640 | 150 | 1.243478 | 1.865217 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.012 | NTclustered | gi|1603784044|ref|XM_028539526.1| | 151771 | g62351 | i0 | 100 | 0.373333333333333 | 28 | 0 | 19 | 0 | 34 | 61 | 1954 | 1981 | PREDICTED: Dendronephthya gigantea serine/threonine-protein kinase MRCK beta-like (LOC114519400), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea |
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);;