contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5899102 | 5899102 | PRJNA799842_P_NODE_7345_length_1149_cov_2.985130_g6409_i0 | PRJNA799842 | 7345 | 1149 | 2.98513 | 34.2991437 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 86.1 | 1.15e-11 | NTclustered | gi|2692952344|ref|NC_086769.1| | 669202 | g6409 | i0 | 75.789 | 0.165361183637946 | 190 | 35 | 16 | 8 | 584 | 766 | 732 | 547 | Thelohanellus kitauei isolate A1 complete mitochondrial genome | blastn | 190 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 5899361 | 5899361 | PRJNA799842_P_NODE_85605_length_312_cov_2.753138_g84032_i0 | PRJNA799842 | 85605 | 312 | 2.753138 | 8.58979056 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 62.1 | 4.85e-5 | NTclustered | gi|2918369538|emb|OZ237720.1| | 317547 | g84032 | i0 | 97.297 | 1.24679487179487 | 37 | 0 | 12 | 1 | 264 | 299 | 46207240 | 46207204 | Eunicella cavolini genome assembly, chromosome: 4 | blastn | 389 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 8448026 | 8448026 | PRJNA799842_P_NODE_44707_length_426_cov_0.776204_g43134_i0 | PRJNA799842 | 44707 | 426 | 0.776204 | 3.30662904 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.041 | NTclustered | gi|2917940731|emb|OZ237564.1| | 6108 | g43134 | i0 | 100 | 0.0657276995305164 | 28 | 0 | 7 | 0 | 348 | 375 | 1448266 | 1448293 | Anemonia sulcata genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 9721030 | 9721030 | PRJNA799842_P_NODE_112108_length_277_cov_0.872549_g110535_i0 | PRJNA799842 | 112108 | 277 | 0.872549 | 2.41696073 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2744881915|ref|XM_065807122.1| | 6087 | g110535 | i0 | 100 | 0.108303249097473 | 30 | 0 | 11 | 0 | 136 | 165 | 396 | 425 | PREDICTED: Hydra vulgaris uncharacterized LOC136085746 (LOC136085746), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 10997697 | 10997697 | PRJNA799842_P_NODE_15729_length_778_cov_24.019858_g14336_i0 | PRJNA799842 | 15729 | 778 | 24.019858 | 186.87449524 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 815 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g14336 | i0 | 99.775 | 26.5552699228792 | 445 | 0 | 57 | 1 | 1 | 445 | 444 | 1 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20660 | 815 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 10999796 | 10999796 | PRJNA799842_P_NODE_89349_length_307_cov_0.944444_g87776_i0 | PRJNA799842 | 89349 | 307 | 0.944444 | 2.89944308 | Acropora digitifera | 70779 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|1005418929|ref|XR_001566870.1| | 70779 | g87776 | i0 | 100 | 0.0944625407166124 | 29 | 0 | 9 | 0 | 200 | 228 | 1500 | 1528 | PREDICTED: Acropora digitifera uncharacterized LOC107354594 (LOC107354594), ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 12273338 | 12273338 | PRJNA799842_P_NODE_168290_length_245_cov_0.895349_g166717_i0 | PRJNA799842 | 168290 | 245 | 0.895349 | 2.19360505 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g166717 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 67 | 94 | 6769183 | 6769210 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 12274891 | 12274891 | PRJNA799842_P_NODE_68230_length_346_cov_1.007326_g66657_i0 | PRJNA799842 | 68230 | 346 | 1.007326 | 3.48534796 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 135 | 3.1600000000000003e-27 | NTclustered | gi|2744840495|ref|XR_010635829.1| | 6087 | g66657 | i0 | 97.468 | 0.228323699421965 | 79 | 2 | 23 | 0 | 1 | 79 | 389 | 311 | PREDICTED: Hydra vulgaris uncharacterized LOC136075315 (LOC136075315), ncRNA | blastn | 79 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 14822986 | 14822986 | PRJNA799842_P_NODE_3092_length_1635_cov_3.521127_g2562_i0 | PRJNA799842 | 3092 | 1635 | 3.521127 | 57.57042645 | Myxobolus wulii | 649408 | Cnidaria | other_Eukaryota | 145 | 2.7e-29 | NTclustered | gi|2692952329|ref|NC_086768.1| | 649408 | g2562 | i0 | 75 | 0.21039755351682 | 344 | 70 | 20 | 14 | 986 | 1317 | 6510 | 6171 | Myxobolus wulii isolate C1 complete mitochondrial genome | blastn | 344 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus wulii | |
| 17796199 | 17796199 | PRJNA799842_P_NODE_113894_length_274_cov_1.915423_g112321_i0 | PRJNA799842 | 113894 | 274 | 1.915423 | 5.24825902 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 82.4 | 3.21e-11 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g112321 | i0 | 77.64 | 39.5547445255474 | 161 | 19 | 53 | 14 | 129 | 274 | 676 | 518 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 10838 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 21196793 | 21196793 | PRJNA799842_P_NODE_19417_length_687_cov_3.728013_g17923_i0 | PRJNA799842 | 19417 | 687 | 3.728013 | 25.61144931 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|1519156033|gb|MK087050.1| | 59785 | g17923 | i0 | 100 | 0.219796215429403 | 31 | 0 | 5 | 0 | 523 | 553 | 13204 | 13174 | Myxobolus squamalis mitochondrion, complete genome | blastn | 151 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis |
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);;