contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 400887 | 400887 | PRJNA379145_P_NODE_34381_length_359_cov_2.975460_g32236_i0 | PRJNA379145 | 34381 | 359 | 2.97546 | 10.6819014 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 62.1 | 5.65e-5 | NTclustered | gi|2744895155|ref|XM_065813350.1| | 6087 | g32236 | i0 | 88.679 | 0.275766016713092 | 53 | 3 | 14 | 3 | 284 | 335 | 3571 | 3621 | PREDICTED: Hydra vulgaris F-actin-monooxygenase MICAL3 (LOC100203435), transcript variant X2, mRNA | blastn | 99 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 1675585 | 1675585 | PRJNA379145_P_NODE_4022_length_1464_cov_3.904962_g3511_i0 | PRJNA379145 | 4022 | 1464 | 3.904962 | 57.16864368 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.012 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g3511 | i0 | 96.97 | 0.0225409836065574 | 33 | 1 | 2 | 0 | 1431 | 1463 | 13503378 | 13503346 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 1675657 | 1675657 | PRJNA379145_P_NODE_47482_length_248_cov_2.418605_g45329_i0 | PRJNA379145 | 47482 | 248 | 2.418605 | 5.9981404 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 156 | 1.66e-33 | NTclustered | gi|2744801688|ref|XM_047266880.2| | 6087 | g45329 | i0 | 79.724 | 5.41129032258065 | 217 | 42 | 87 | 2 | 30 | 245 | 1881 | 2096 | PREDICTED: Hydra vulgaris ATP-binding cassette sub-family D member 3 (LOC100208653), transcript variant X1, mRNA | blastn | 1342 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 2951188 | 2951188 | PRJNA379145_P_NODE_13143_length_804_cov_6.880674_g11695_i0 | PRJNA379145 | 13143 | 804 | 6.880674 | 55.32061896 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1485 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g11695 | i0 | 100 | 65.2674129353234 | 804 | 0 | 100 | 0 | 1 | 804 | 2673 | 1870 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 52475 | 1485 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 2951761 | 2951761 | PRJNA379145_P_NODE_6823_length_1166_cov_1.992056_g6008_i0 | PRJNA379145 | 6823 | 1166 | 1.992056 | 23.22737296 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 126 | 6.899999999999999e-24 | NTclustered | gi|2518962675|ref|XM_057435247.1| | 13093 | g6008 | i0 | 73.367 | 2.64493996569468 | 398 | 83 | 33 | 18 | 297 | 681 | 971 | 584 | PREDICTED: Hydractinia symbiolongicarpus vacuolar protein sorting-associated protein 4-like (LOC130613891), transcript variant X2, mRNA | blastn | 3084 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 4901928 | 4901928 | PRJNA379145_P_NODE_30424_length_410_cov_7.082228_g28301_i0 | PRJNA379145 | 30424 | 410 | 7.082228 | 29.0371348 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 180 | 1.7299999999999999e-40 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g28301 | i0 | 90.977 | 30.0853658536585 | 133 | 12 | 32 | 0 | 39 | 171 | 6424 | 6556 | 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 | |
| 6176935 | 6176935 | PRJNA379145_P_NODE_21625_length_559_cov_6.792776_g19698_i0 | PRJNA379145 | 21625 | 559 | 6.792776 | 37.97161784 | Henneguya | 35590 | Cnidaria | other_Eukaryota | 119 | 5.35e-22 | NTclustered | gi|241911747|gb|FJ417053.1| | 35592 | g19698 | i0 | 89.474 | 14.2862254025045 | 95 | 9 | 29 | 1 | 1 | 95 | 342 | 435 | Henneguya zschokkei isolate M0630 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7986 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya zschokkei | |
| 6778414 | 6778414 | PRJNA379145_P_NODE_24246_length_509_cov_2.214286_g22236_i0 | PRJNA379145 | 24246 | 509 | 2.214286 | 11.27071574 | Dichotella gemmacea | 767270 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|2714796602|gb|PP584627.1| | 767270 | g22236 | i0 | 100 | 0.449901768172888 | 30 | 0 | 6 | 0 | 480 | 509 | 55064 | 55093 | Dichotella gemmacea SDH1, CYP, cembrene 19-hydroxylase, cembrene b terpene cyclase, and cembrene 7-hydroxylase genes, complete cds | blastn | 229 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleralcyonacea | Ellisellidae | Dichotella | Dichotella gemmacea | |
| 8726759 | 8726759 | PRJNA379145_P_NODE_6647_length_1180_cov_4.811683_g5847_i0 | PRJNA379145 | 6647 | 1180 | 4.811683 | 56.7778594 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 110 | 7.04e-19 | NTclustered | gi|1778069945|ref|XM_031716691.1| | 6105 | g5847 | i0 | 85.577 | 8.07372881355932 | 104 | 15 | 9 | 0 | 932 | 1035 | 1123 | 1226 | PREDICTED: Actinia tenebrosa arginine/serine-rich coiled-coil protein 2-like (LOC116306609), mRNA | blastn | 9527 | 111 | 0.990990990990991 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 9328700 | 9328700 | PRJNA379145_P_NODE_1668_length_2014_cov_10.530035_g1417_i0 | PRJNA379145 | 1668 | 2014 | 10.530035 | 212.0749049 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 2.67e-5 | NTclustered | gi|2917940701|emb|OZ237558.1| | 6108 | g1417 | i0 | 88.679 | 0.217974180734856 | 53 | 6 | 3 | 0 | 24 | 76 | 1927288 | 1927340 | Anemonia sulcata genome assembly, chromosome: 4 | blastn | 439 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 9328741 | 9328741 | PRJNA379145_P_NODE_1988_length_1894_cov_4.878560_g1699_i0 | PRJNA379145 | 1988 | 1894 | 4.87856 | 92.3999264 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 73.1 | 1.5e-7 | NTclustered | gi|2917940687|emb|OZ237555.1| | 6108 | g1699 | i0 | 92.157 | 1.26821541710665 | 51 | 4 | 3 | 0 | 41 | 91 | 18837712 | 18837762 | Anemonia sulcata genome assembly, chromosome: 1 | blastn | 2402 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 9328982 | 9328982 | PRJNA379145_P_NODE_43208_length_277_cov_1.807377_g41056_i0 | PRJNA379145 | 43208 | 277 | 1.807377 | 5.00643429 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|1603808482|ref|XM_028552610.1| | 151771 | g41056 | i0 | 94.286 | 0.126353790613718 | 35 | 1 | 12 | 1 | 29 | 62 | 14953 | 14987 | PREDICTED: Dendronephthya gigantea uncharacterized LOC114530985 (LOC114530985), mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 9329120 | 9329120 | PRJNA379145_P_NODE_58368_length_195_cov_1.740741_g56214_i0 | PRJNA379145 | 58368 | 195 | 1.740741 | 3.39444495 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 176 | 9.58e-40 | NTclustered | gi|2918369539|emb|OZ237721.1| | 317547 | g56214 | i0 | 83.077 | 152.025641025641 | 195 | 31 | 99 | 2 | 1 | 194 | 241115 | 241308 | Eunicella cavolini genome assembly, chromosome: 5 | blastn | 29645 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 10604600 | 10604600 | PRJNA379145_P_NODE_34409_length_359_cov_2.092025_g32264_i0 | PRJNA379145 | 34409 | 359 | 2.092025 | 7.51036975 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 309 | 1.83e-79 | NTclustered | gi|2202638579|ref|XM_046994382.1| | 2897299 | g32264 | i0 | 82.849 | 18.7019498607242 | 344 | 59 | 96 | 0 | 1 | 344 | 1024 | 681 | PREDICTED: Xenia sp. Carnegie-2017 V-type proton ATPase subunit B (LOC124443845), mRNA | blastn | 6714 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 11879827 | 11879827 | PRJNA379145_P_NODE_62110_length_181_cov_4.195946_g59956_i0 | PRJNA379145 | 62110 | 181 | 4.195946 | 7.59466226 | Myxobolus nagaraensis | 402991 | Cnidaria | other_Eukaryota | 172 | 1.13e-38 | NTclustered | gi|2806899035|dbj|LC764520.1| | 402991 | g59956 | i0 | 89.13 | 64.5138121546961 | 138 | 15 | 76 | 0 | 1 | 138 | 497 | 634 | Myxobolus nagaraensis mx18003 genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence, clone: mx18003its2 | blastn | 11677 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 13827417 | 13827417 | PRJNA379145_P_NODE_12391_length_837_cov_3.064677_g10998_i0 | PRJNA379145 | 12391 | 837 | 3.064677 | 25.65134649 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 555 | 5.269999999999998e-153 | NTclustered | gi|2784653869|ref|XM_067201797.1| | 159855 | g10998 | i0 | 80 | 89.1206690561529 | 755 | 147 | 90 | 4 | 81 | 833 | 132 | 884 | PREDICTED: Acropora muricata tubulin beta-4B chain (LOC136931925), mRNA | blastn | 74594 | 560 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 14429473 | 14429473 | PRJNA379145_P_NODE_26192_length_475_cov_2.312217_g24139_i0 | PRJNA379145 | 26192 | 475 | 2.312217 | 10.98303075 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.8 | 0.046 | NTclustered | gi|2782881583|ref|XM_067063598.1| | 252671 | g24139 | i0 | 96.875 | 0.0673684210526316 | 32 | 0 | 7 | 1 | 65 | 95 | 2190 | 2221 | PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136807029), mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 15703297 | 15703297 | PRJNA379145_P_NODE_15373_length_723_cov_2.431884_g13738_i0 | PRJNA379145 | 15373 | 723 | 2.431884 | 17.58252132 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 62.1 | 1.2e-4 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g13738 | i0 | 100 | 0.177040110650069 | 33 | 0 | 5 | 0 | 1 | 33 | 45618681 | 45618713 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 128 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 15703766 | 15703766 | PRJNA379145_P_NODE_57613_length_198_cov_1.739394_g55459_i0 | PRJNA379145 | 57613 | 198 | 1.739394 | 3.44400012 | Montipora foliosa | 591990 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2812066736|ref|XM_068851394.1| | 591990 | g55459 | i0 | 96.774 | 0.156565656565657 | 31 | 1 | 16 | 0 | 127 | 157 | 459 | 429 | PREDICTED: Montipora foliosa sarcolemmal membrane-associated protein-like (LOC138005117), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora foliosa | |
| 16978040 | 16978040 | PRJNA379145_P_NODE_23094_length_530_cov_5.947686_g21119_i0 | PRJNA379145 | 23094 | 530 | 5.947686 | 31.5227358 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 819 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g21119 | i0 | 99.776 | 38.6018867924528 | 447 | 0 | 84 | 1 | 1 | 447 | 446 | 1 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20459 | 819 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 20802525 | 20802525 | PRJNA379145_P_NODE_63197_length_178_cov_1.448276_g61043_i0 | PRJNA379145 | 63197 | 178 | 1.448276 | 2.57793128 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 89.8 | 1.15e-13 | NTclustered | gi|1603801937|ref|XM_028549118.1| | 151771 | g61043 | i0 | 82.692 | 1.02808988764045 | 104 | 14 | 57 | 3 | 77 | 178 | 386 | 285 | PREDICTED: Dendronephthya gigantea 60S ribosomal protein L30-like (LOC114527464), mRNA | blastn | 183 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 21475786 | 21475786 | PRJNA379145_P_NODE_8797_length_1024_cov_4.023209_g7771_i0 | PRJNA379145 | 8797 | 1024 | 4.023209 | 41.19766016 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 396 | 4.17e-105 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g7771 | i0 | 97.414 | 29.58203125 | 232 | 6 | 30 | 0 | 1 | 232 | 3329 | 3098 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 30292 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 24626838 | 24626838 | PRJNA379145_P_NODE_15380_length_722_cov_43.262700_g13745_i0 | PRJNA379145 | 15380 | 722 | 43.2627 | 312.356694 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 289 | 5.059999999999999e-73 | NTclustered | gi|2202604722|ref|XM_047007584.1| | 2897299 | g13745 | i0 | 79.236 | 50.6108033240997 | 419 | 84 | 58 | 3 | 214 | 631 | 501 | 85 | PREDICTED: Xenia sp. Carnegie-2017 histone H3.3 (LOC124457306), mRNA | blastn | 36541 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 24627154 | 24627154 | PRJNA379145_P_NODE_4180_length_1442_cov_2.997871_g3649_i0 | PRJNA379145 | 4180 | 1442 | 2.997871 | 43.22929982 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 67.6 | 5.28e-6 | NTclustered | gi|2519004231|ref|XM_057453791.1| | 13093 | g3649 | i0 | 78.704 | 0.0748959778085992 | 108 | 18 | 7 | 5 | 1214 | 1318 | 380 | 275 | PREDICTED: Hydractinia symbiolongicarpus WD repeat-containing protein 48-like (LOC130647809), mRNA | blastn | 108 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 25300235 | 25300235 | PRJNA379145_P_NODE_42240_length_285_cov_1.527778_g40088_i0 | PRJNA379145 | 42240 | 285 | 1.527778 | 4.3541673 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g40088 | i0 | 94.286 | 1.31578947368421 | 35 | 2 | 12 | 0 | 14 | 48 | 5370558 | 5370592 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 375 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata |
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);;