contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA540466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508000 | 508000 | PRJNA540466_S_NODE_29241_length_332_cov_2.513514_g28692_i0 | PRJNA540466 | 29241 | 332 | 2.513514 | 8.34486648 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 91.6 | 6.63e-14 | NTclustered | gi|2692952344|ref|NC_086769.1| | 669202 | g28692 | i0 | 76.316 | 0.572289156626506 | 190 | 34 | 55 | 8 | 93 | 275 | 732 | 547 | Thelohanellus kitauei isolate A1 complete mitochondrial genome | blastn | 190 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 508257 | 508257 | PRJNA540466_S_NODE_55801_length_253_cov_0.866667_g55252_i0 | PRJNA540466 | 55801 | 253 | 0.866667 | 2.19266751 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g55252 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 17 | 44 | 8294139 | 8294112 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 1783259 | 1783259 | PRJNA540466_S_NODE_17542_length_420_cov_2.827089_g16993_i0 | PRJNA540466 | 17542 | 420 | 2.827089 | 11.8737738 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 63.9 | 1.87e-5 | NTclustered | gi|2744783795|ref|XM_047278957.2| | 6087 | g16993 | i0 | 97.297 | 0.0880952380952381 | 37 | 1 | 9 | 0 | 142 | 178 | 1877 | 1913 | PREDICTED: Hydra vulgaris solute carrier family 53 member 1 (LOC100209536), transcript variant X1, mRNA | blastn | 37 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 3058712 | 3058712 | PRJNA540466_S_NODE_12223_length_491_cov_23.217703_g11679_i0 | PRJNA540466 | 12223 | 491 | 23.217703 | 113.99892173 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 274 | 9.39e-69 | NTclustered | gi|1778059731|ref|XM_031711301.1| | 6105 | g11679 | i0 | 80.054 | 30.2953156822811 | 371 | 71 | 75 | 3 | 2 | 369 | 211 | 581 | PREDICTED: Actinia tenebrosa ubiquitin-40S ribosomal protein S27a (LOC116302103), mRNA | blastn | 14875 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 4335170 | 4335170 | PRJNA540466_S_NODE_59724_length_247_cov_1.137931_g59175_i0 | PRJNA540466 | 59724 | 247 | 1.137931 | 2.81068957 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 165 | 2.75e-36 | NTclustered | gi|2202643733|ref|XM_046995772.1| | 2897299 | g59175 | i0 | 80.531 | 3.85425101214575 | 226 | 34 | 89 | 9 | 27 | 247 | 1346 | 1126 | PREDICTED: Xenia sp. Carnegie-2017 dihydrolipoyl dehydrogenase, mitochondrial-like (LOC124445064), mRNA | blastn | 952 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 4335246 | 4335246 | PRJNA540466_S_NODE_70664_length_210_cov_19.094891_g70115_i0 | PRJNA540466 | 70664 | 210 | 19.094891 | 40.0992711 | Myxobolus nagaraensis | 402991 | Cnidaria | other_Eukaryota | 207 | 3.72e-49 | NTclustered | gi|2806899035|dbj|LC764520.1| | 402991 | g70115 | i0 | 90.446 | 71.3571428571429 | 157 | 15 | 75 | 0 | 25 | 181 | 478 | 634 | Myxobolus nagaraensis mx18003 genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence, clone: mx18003its2 | blastn | 14985 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 7496615 | 7496615 | PRJNA540466_S_NODE_6386_length_625_cov_6.617754_g5934_i0 | PRJNA540466 | 6386 | 625 | 6.617754 | 41.3609625 | Henneguya | 35590 | Cnidaria | other_Eukaryota | 211 | 9.67e-50 | NTclustered | gi|2663986575|emb|OY756916.1| | 69463 | g5934 | i0 | 76.231 | 27.7728 | 467 | 72 | 73 | 27 | 54 | 511 | 4513 | 4949 | Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 17358 | 213 | 0.990610328638498 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 7496633 | 7496633 | PRJNA540466_S_NODE_72426_length_197_cov_6.298387_g71877_i0 | PRJNA540466 | 72426 | 197 | 6.298387 | 12.40782239 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2917940752|emb|OZ237570.1| | 6108 | g71877 | i0 | 100 | 0.873096446700508 | 28 | 0 | 14 | 0 | 70 | 97 | 6780376 | 6780403 | Anemonia sulcata genome assembly, chromosome: 16 | blastn | 172 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 8160571 | 8160571 | PRJNA540466_S_NODE_11407_length_505_cov_23459.127315_g10867_i0 | PRJNA540466 | 11407 | 505 | 23459.127315 | 118468.59294075 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 684 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g10867 | i0 | 100 | 15.9188118811881 | 370 | 0 | 73 | 0 | 1 | 370 | 643 | 1012 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 8039 | 684 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 8160667 | 8160667 | PRJNA540466_S_NODE_19887_length_396_cov_6.904025_g19338_i0 | PRJNA540466 | 19887 | 396 | 6.904025 | 27.339939 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 732 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g19338 | i0 | 100 | 46.0505050505051 | 396 | 0 | 100 | 0 | 1 | 396 | 53 | 448 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18236 | 732 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 9436106 | 9436106 | PRJNA540466_S_NODE_11948_length_496_cov_5.626478_g11405_i0 | PRJNA540466 | 11948 | 496 | 5.626478 | 27.90733088 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 911 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g11405 | i0 | 99.798 | 33.4415322580645 | 496 | 1 | 100 | 0 | 1 | 496 | 1616 | 1121 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16587 | 911 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 9436380 | 9436380 | PRJNA540466_S_NODE_43748_length_279_cov_2.344660_g43199_i0 | PRJNA540466 | 43748 | 279 | 2.34466 | 6.5416014 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|2918369536|emb|OZ237718.1| | 317547 | g43199 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 134 | 161 | 3125209 | 3125182 | Eunicella cavolini genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 10711928 | 10711928 | PRJNA540466_S_NODE_18229_length_412_cov_11.646018_g17680_i0 | PRJNA540466 | 18229 | 412 | 11.646018 | 47.98159416 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 723 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g17680 | i0 | 100 | 22.0266990291262 | 391 | 0 | 95 | 0 | 22 | 412 | 2369 | 1979 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 9075 | 723 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 11321551 | 11321551 | PRJNA540466_S_NODE_58609_length_248_cov_2.645714_g58060_i0 | PRJNA540466 | 58609 | 248 | 2.645714 | 6.56137072 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 62.1 | 3.73e-5 | NTclustered | gi|2917940712|emb|OZ237560.1| | 6108 | g58060 | i0 | 100 | 2.37903225806452 | 33 | 0 | 16 | 0 | 66 | 98 | 6685855 | 6685823 | Anemonia sulcata genome assembly, chromosome: 6 | blastn | 590 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11321561 | 11321561 | PRJNA540466_S_NODE_68529_length_227_cov_4.266234_g67980_i0 | PRJNA540466 | 68529 | 227 | 4.266234 | 9.68435118 | root | 1 | Root_unresolved | Root_unresolved | 58.4 | 4.35e-4 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g67980 | i0 | 100 | 55.3612334801762 | 31 | 0 | 14 | 0 | 197 | 227 | 8737164 | 8737134 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 12567 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 11986895 | 11986895 | PRJNA540466_S_NODE_51590_length_261_cov_1.234043_g51041_i0 | PRJNA540466 | 51590 | 261 | 1.234043 | 3.22085223 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 84.2 | 8.44e-12 | NTclustered | gi|2782899435|ref|XM_067068137.1| | 252671 | g51041 | i0 | 93.103 | 6.08045977011494 | 58 | 2 | 22 | 2 | 184 | 240 | 1031 | 975 | PREDICTED: Clytia hemisphaerica polyubiquitin-B (LOC136811514), mRNA | blastn | 1587 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 11986921 | 11986921 | PRJNA540466_S_NODE_54670_length_255_cov_1.263736_g54121_i0 | PRJNA540466 | 54670 | 255 | 1.263736 | 3.2225268 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 102 | 2.27e-17 | NTclustered | gi|2519016792|ref|XM_057459753.1| | 13093 | g54121 | i0 | 79.72 | 0.56078431372549 | 143 | 28 | 56 | 1 | 23 | 164 | 1301 | 1443 | PREDICTED: Hydractinia symbiolongicarpus 26S proteasome regulatory subunit 4 (LOC130656819), mRNA | blastn | 143 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 14536626 | 14536626 | PRJNA540466_S_NODE_12792_length_482_cov_7.432763_g12248_i0 | PRJNA540466 | 12792 | 482 | 7.432763 | 35.82591766 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g12248 | i0 | 100 | 3.39834024896266 | 30 | 0 | 6 | 0 | 350 | 379 | 787304 | 787275 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 1638 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 14537063 | 14537063 | PRJNA540466_S_NODE_64952_length_237_cov_9.981707_g64403_i0 | PRJNA540466 | 64952 | 237 | 9.981707 | 23.65664559 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.021 | NTclustered | gi|2918369554|emb|OZ237726.1| | 317547 | g64403 | i0 | 100 | 0.118143459915612 | 28 | 0 | 12 | 0 | 109 | 136 | 12468694 | 12468721 | Eunicella cavolini genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 15811082 | 15811082 | PRJNA540466_S_NODE_66433_length_233_cov_2.806250_g65884_i0 | PRJNA540466 | 66433 | 233 | 2.80625 | 6.5385625 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 342 | 1.0999999999999999e-89 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g65884 | i0 | 98.958 | 82.7896995708155 | 192 | 1 | 82 | 1 | 1 | 192 | 2353 | 2543 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19290 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 18359586 | 18359586 | PRJNA540466_S_NODE_40355_length_289_cov_1.425926_g39806_i0 | PRJNA540466 | 40355 | 289 | 1.425926 | 4.12092614 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 368 | 2.34e-97 | NTclustered | gi|2744884988|ref|XM_065808629.1| | 6087 | g39806 | i0 | 90.681 | 8.43598615916955 | 279 | 22 | 95 | 2 | 15 | 289 | 598 | 320 | PREDICTED: Hydra vulgaris uncharacterized LOC136086334 (LOC136086334), mRNA | blastn | 2438 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 20909934 | 20909934 | PRJNA540466_S_NODE_22037_length_378_cov_2.895082_g21488_i0 | PRJNA540466 | 22037 | 378 | 2.895082 | 10.94340996 | Myxobolus cloutmani | 2766936 | Cnidaria | other_Eukaryota | 161 | 5.73e-35 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g21488 | i0 | 98.889 | 17.9973544973545 | 90 | 1 | 24 | 0 | 1 | 90 | 2086 | 1997 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 6803 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 22184699 | 22184699 | PRJNA540466_S_NODE_25538_length_353_cov_3.475000_g24989_i0 | PRJNA540466 | 25538 | 353 | 3.475 | 12.26675 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 111 | 5.43e-20 | NTclustered | gi|2518994150|ref|XM_057448279.1| | 13093 | g24989 | i0 | 85.185 | 7.9773371104815904 | 108 | 16 | 31 | 0 | 3 | 110 | 1352 | 1459 | PREDICTED: Hydractinia symbiolongicarpus tubulin alpha-2/alpha-4 chain (LOC130641471), mRNA | blastn | 2816 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 22184895 | 22184895 | PRJNA540466_S_NODE_4778_length_682_cov_4.602627_g4374_i0 | PRJNA540466 | 4778 | 682 | 4.602627 | 31.38991614 | Myxobolus xiantaoensis | 2571166 | Cnidaria | other_Eukaryota | 113 | 3.08e-20 | NTclustered | gi|1887098227|gb|MT872001.1| | 2571166 | g4374 | i0 | 87.129 | 9.41642228739003 | 101 | 12 | 15 | 1 | 183 | 283 | 829 | 730 | Myxobolus xiantaoensis isolate Xiantao large subunit ribosomal RNA gene, partial sequence | blastn | 6422 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus xiantaoensis | |
| 23460417 | 23460417 | PRJNA540466_S_NODE_58219_length_249_cov_1.261364_g57670_i0 | PRJNA540466 | 58219 | 249 | 1.261364 | 3.14079636 | Myxobolus wulii | 649408 | Cnidaria | other_Eukaryota | 113 | 1.02e-20 | NTclustered | gi|2692952329|ref|NC_086768.1| | 649408 | g57670 | i0 | 75.709 | 0.991967871485944 | 247 | 49 | 96 | 9 | 4 | 242 | 6255 | 6498 | Myxobolus wulii isolate C1 complete mitochondrial genome | blastn | 247 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus wulii |
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);;