contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA450343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1713923 | 1713923 | PRJNA450343_P_NODE_262_length_1085_cov_3.783784_g228_i0 | PRJNA450343 | 262 | 1085 | 3.783784 | 41.0540564 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1993 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g228 | i0 | 99.816 | 37.7990783410138 | 1085 | 2 | 100 | 0 | 1 | 1085 | 711 | 1795 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 41012 | 1993 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 3643522 | 3643522 | PRJNA450343_P_NODE_13043_length_163_cov_0.894737_g12975_i0 | PRJNA450343 | 13043 | 163 | 0.894737 | 1.45842131 | Acropora | 6127 | Cnidaria | other_Eukaryota | 115 | 1.7100000000000003e-21 | NTclustered | gi|2114087731|ref|XM_029335314.2| | 45264 | g12975 | i0 | 86.111 | 5.43558282208589 | 108 | 14 | 66 | 1 | 57 | 163 | 600 | 493 | PREDICTED: Acropora millepora procathepsin L-like (LOC114957778), mRNA | blastn | 886 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 5542807 | 5542807 | PRJNA450343_P_NODE_1045_length_555_cov_2.958498_g979_i0 | PRJNA450343 | 1045 | 555 | 2.958498 | 16.4196639 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 143 | 3.15e-29 | NTclustered | gi|2782875686|ref|XM_067062107.1| | 252671 | g979 | i0 | 88.889 | 1.32612612612613 | 117 | 11 | 21 | 2 | 182 | 297 | 240 | 355 | PREDICTED: Clytia hemisphaerica protein transport protein Sec61 subunit beta-like (LOC136805538), mRNA | blastn | 736 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 5542824 | 5542824 | PRJNA450343_P_NODE_1385_length_475_cov_3.692488_g1317_i0 | PRJNA450343 | 1385 | 475 | 3.692488 | 17.539318 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 795 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g1317 | i0 | 99.77 | 42.3221052631579 | 434 | 0 | 91 | 1 | 1 | 434 | 433 | 1 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20103 | 795 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 7470470 | 7470470 | PRJNA450343_P_NODE_11506_length_166_cov_0.871795_g11438_i0 | PRJNA450343 | 11506 | 166 | 0.871795 | 1.4471797 | Montipora | 46703 | Cnidaria | other_Eukaryota | 102 | 1.36e-17 | NTclustered | gi|2812139601|ref|XM_068874760.1| | 246305 | g11438 | i0 | 89.024 | 14.8253012048193 | 82 | 9 | 49 | 0 | 31 | 112 | 1329 | 1248 | PREDICTED: Montipora capricornis AP-3 complex subunit mu-1-like (LOC138027211), mRNA | blastn | 2461 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 11295638 | 11295638 | PRJNA450343_P_NODE_8069_length_191_cov_0.845070_g8001_i0 | PRJNA450343 | 8069 | 191 | 0.84507 | 1.6140837 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g8001 | i0 | 100 | 0.43979057591623 | 28 | 0 | 15 | 0 | 79 | 106 | 11157097 | 11157070 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 13192596 | 13192596 | PRJNA450343_P_NODE_1271_length_496_cov_13.029083_g1203_i0 | PRJNA450343 | 1271 | 496 | 13.029083 | 64.62425168 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 374 | 9.1e-99 | NTclustered | gi|1603792345|ref|XM_028543960.1| | 151771 | g1203 | i0 | 82.701 | 36.4697580645161 | 422 | 72 | 85 | 1 | 50 | 470 | 117 | 538 | PREDICTED: Dendronephthya gigantea 40S ribosomal protein S14 (LOC114523117), mRNA | blastn | 18089 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 17016364 | 17016364 | PRJNA450343_P_NODE_3414_length_289_cov_8.008333_g3346_i0 | PRJNA450343 | 3414 | 289 | 8.008333 | 23.14408237 | Myxobolus sp. 'branchicola' | 1446104 | Cnidaria | other_Eukaryota | 228 | 4.139999999999999e-55 | NTclustered | gi|573041015|gb|JN616264.1| | 1446104 | g3346 | i0 | 89.071 | 58.7439446366782 | 183 | 20 | 63 | 0 | 107 | 289 | 3584 | 3766 | Myxobolus sp. 'branchicola' voucher CQ-20090225 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16977 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. 'branchicola' | |
| 18943984 | 18943984 | PRJNA450343_P_NODE_1975_length_391_cov_7.982456_g1907_i0 | PRJNA450343 | 1975 | 391 | 7.982456 | 31.21140296 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 180 | 1.6399999999999999e-40 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g1907 | i0 | 90.977 | 31.5473145780051 | 133 | 12 | 34 | 0 | 200 | 332 | 6556 | 6424 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 12335 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 20218711 | 20218711 | PRJNA450343_P_NODE_1096_length_537_cov_4.356557_g1029_i0 | PRJNA450343 | 1096 | 537 | 4.356557 | 23.39471109 | Henneguya | 35590 | Cnidaria | other_Eukaryota | 145 | 8.46e-30 | NTclustered | gi|241911747|gb|FJ417053.1| | 35592 | g1029 | i0 | 89.565 | 17.4823091247672 | 115 | 11 | 21 | 1 | 1 | 115 | 322 | 435 | Henneguya zschokkei isolate M0630 28S large subunit ribosomal RNA gene, partial sequence | blastn | 9388 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya zschokkei | |
| 20840710 | 20840710 | PRJNA450343_P_NODE_837_length_622_cov_2.347295_g776_i0 | PRJNA450343 | 837 | 622 | 2.347295 | 14.6001749 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 110 | 3.61e-19 | NTclustered | gi|2202646665|ref|XM_046996690.1| | 2897299 | g776 | i0 | 83.193 | 0.191318327974277 | 119 | 20 | 19 | 0 | 504 | 622 | 1529 | 1411 | PREDICTED: Xenia sp. Carnegie-2017 protein transport protein Sec61 subunit alpha (LOC124445904), mRNA | blastn | 119 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 22115584 | 22115584 | PRJNA450343_P_NODE_2838_length_320_cov_1.125461_g2770_i0 | PRJNA450343 | 2838 | 320 | 1.125461 | 3.6014752 | Myxobolus nagaraensis | 402991 | Cnidaria | other_Eukaryota | 207 | 6.05e-49 | NTclustered | gi|2806899035|dbj|LC764520.1| | 402991 | g2770 | i0 | 90.062 | 47.359375 | 161 | 15 | 50 | 1 | 25 | 185 | 634 | 475 | Myxobolus nagaraensis mx18003 genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence, clone: mx18003its2 | blastn | 15155 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 22115597 | 22115597 | PRJNA450343_P_NODE_498_length_806_cov_3.836196_g451_i0 | PRJNA450343 | 498 | 806 | 3.836196 | 30.91973976 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1489 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g451 | i0 | 100 | 64.4255583126551 | 806 | 0 | 100 | 0 | 1 | 806 | 1869 | 2674 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 51927 | 1489 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 23391265 | 23391265 | PRJNA450343_P_NODE_13379_length_162_cov_0.902655_g13311_i0 | PRJNA450343 | 13379 | 162 | 0.902655 | 1.4623011 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 150 | 4.65e-32 | NTclustered | gi|1778025572|ref|XM_031694062.1| | 6105 | g13311 | i0 | 84.416 | 2.79012345679012 | 154 | 22 | 94 | 2 | 10 | 162 | 1113 | 961 | PREDICTED: Actinia tenebrosa dynein intermediate chain 2, ciliary-like (LOC116287389), mRNA | blastn | 452 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 24044361 | 24044361 | PRJNA450343_P_NODE_299_length_1022_cov_5.721480_g262_i0 | PRJNA450343 | 299 | 1022 | 5.72148 | 58.4735256 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 396 | 4.16e-105 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g262 | i0 | 97.414 | 29.4461839530333 | 232 | 6 | 29 | 0 | 791 | 1022 | 3098 | 3329 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 30094 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis |
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);;