contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3957022 | 3957022 | PRJEB66218_P_NODE_127224_length_265_cov_1.906863_g124795_i0 | PRJEB66218 | 127224 | 265 | 1.906863 | 5.05318695 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|2782897622|ref|XM_067067727.1| | 252671 | g124795 | i0 | 92.308 | 0.147169811320755 | 39 | 0 | 15 | 2 | 2 | 40 | 4144 | 4109 | PREDICTED: Clytia hemisphaerica DNA topoisomerase 2-alpha-like (LOC136811122), mRNA | blastn | 39 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 6510481 | 6510481 | PRJEB66218_P_NODE_204566_length_209_cov_2.750000_g202136_i0 | PRJEB66218 | 204566 | 209 | 2.75 | 5.7475 | Kudoa carcharhini | 858677 | Cnidaria | other_Eukaryota | 63.9 | 8.46e-6 | NTclustered | gi|300089085|gb|GU446630.1| | 858677 | g202136 | i0 | 91.304 | 16.5263157894737 | 46 | 4 | 22 | 0 | 1 | 46 | 43 | 88 | Kudoa carcharhini isolate Cc1 28S ribosomal RNA gene, partial sequence | blastn | 3454 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Multivalvulida | Kudoidae | Kudoa | Kudoa carcharhini | |
| 7372826 | 7372826 | PRJEB66218_P_NODE_97646_length_311_cov_1.560000_g95218_i0 | PRJEB66218 | 97646 | 311 | 1.56 | 4.8516 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2917940724|emb|OZ237563.1| | 6108 | g95218 | i0 | 100 | 0.890675241157556 | 29 | 0 | 9 | 0 | 8 | 36 | 8902458 | 8902486 | Anemonia sulcata genome assembly, chromosome: 9 | blastn | 277 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 10333568 | 10333568 | PRJEB66218_P_NODE_109169_length_290_cov_106.266376_g106740_i0 | PRJEB66218 | 109169 | 290 | 106.266376 | 308.1724904 | Palliatus indecorus | 371550 | Cnidaria | other_Eukaryota | 119 | 2.61e-22 | NTclustered | gi|241911763|gb|FJ417069.1| | 371550 | g106740 | i0 | 91.765 | 30.0827586206897 | 85 | 7 | 29 | 0 | 206 | 290 | 101 | 17 | Palliatus indecorus isolate M0424 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8724 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaerosporidae | Palliatus | Palliatus indecorus | |
| 12473165 | 12473165 | PRJEB66218_P_NODE_138630_length_252_cov_2.041885_g136201_i0 | PRJEB66218 | 138630 | 252 | 2.041885 | 5.1455502 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 58.4 | 4.91e-4 | NTclustered | gi|2917940766|emb|OZ237573.1| | 6108 | g136201 | i0 | 97.059 | 0.424603174603175 | 34 | 1 | 13 | 0 | 219 | 252 | 4618547 | 4618514 | Anemonia sulcata genome assembly, chromosome: 19 | blastn | 107 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 12885790 | 12885790 | PRJEB66218_P_NODE_194511_length_212_cov_2.092715_g192081_i0 | PRJEB66218 | 194511 | 212 | 2.092715 | 4.4365558 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 219 | 1.74e-52 | NTclustered | gi|2782957080|ref|XM_067080290.1| | 252671 | g192081 | i0 | 86.139 | 26.4528301886792 | 202 | 28 | 95 | 0 | 1 | 202 | 5227 | 5428 | PREDICTED: Clytia hemisphaerica serine/threonine-protein phosphatase PP1-beta catalytic subunit (LOC136824125), transcript variant X2, mRNA | blastn | 5608 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 14159664 | 14159664 | PRJEB66218_P_NODE_143092_length_248_cov_1.219251_g140663_i0 | PRJEB66218 | 143092 | 248 | 1.219251 | 3.02374248 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 169 | 2.13e-37 | NTclustered | gi|2729081375|ref|XM_065203156.1| | 499914 | g140663 | i0 | 81.773 | 15.383064516129 | 203 | 35 | 81 | 2 | 15 | 216 | 603 | 402 | PREDICTED: Rhopilema esculentum ruvB-like 1 (LOC135686810), mRNA | blastn | 3815 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 16297134 | 16297134 | PRJEB66218_P_NODE_193773_length_213_cov_1.282895_g191343_i0 | PRJEB66218 | 193773 | 213 | 1.282895 | 2.73256635 | Montipora | 46703 | Cnidaria | other_Eukaryota | 93.5 | 1.1e-14 | NTclustered | gi|2812194374|ref|XM_068863792.1| | 246305 | g191343 | i0 | 80.992 | 1.13615023474178 | 121 | 20 | 56 | 3 | 80 | 198 | 109 | 228 | PREDICTED: Montipora capricornis E3 ubiquitin-protein ligase RBX1 (LOC138016610), mRNA | blastn | 242 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 16710537 | 16710537 | PRJEB66218_P_NODE_59654_length_426_cov_13.320548_g57233_i0 | PRJEB66218 | 59654 | 426 | 13.320548 | 56.74553448 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 60.2 | 2.45e-4 | NTclustered | gi|2663986569|emb|OY751524.1| | 275449 | g57233 | i0 | 100 | 1.56338028169014 | 32 | 0 | 8 | 0 | 130 | 161 | 6334 | 6365 | Sphaeromyxa zaharoni isolate 24.2.2011 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 666 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 16710994 | 16710994 | PRJEB66218_P_NODE_78854_length_356_cov_3.284746_g76428_i0 | PRJEB66218 | 78854 | 356 | 3.284746 | 11.69369576 | Clytia sp. 3 AFC-2016 | 1886627 | Cnidaria | other_Eukaryota | 73.1 | 2.59e-8 | NTclustered | gi|1069323992|gb|KX665509.1| | 1886627 | g76428 | i0 | 77.778 | 12.4915730337079 | 135 | 18 | 36 | 11 | 228 | 354 | 1735 | 1605 | Clytia sp. 3 AFC-2016 voucher MZUSP:2801 28S ribosomal RNA gene, partial sequence | blastn | 4447 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia sp. 3 AFC-2016 | |
| 19258877 | 19258877 | PRJEB66218_P_NODE_37216_length_582_cov_11.080614_g34827_i0 | PRJEB66218 | 37216 | 582 | 11.080614 | 64.48917348 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 67.6 | 2.05e-6 | NTclustered | gi|2918369537|emb|OZ237719.1| | 317547 | g34827 | i0 | 97.436 | 21.9020618556701 | 39 | 1 | 7 | 0 | 6 | 44 | 25307668 | 25307706 | Eunicella cavolini genome assembly, chromosome: 3 | blastn | 12747 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 19259839 | 19259839 | PRJEB66218_P_NODE_74516_length_369_cov_4.334416_g72091_i0 | PRJEB66218 | 74516 | 369 | 4.334416 | 15.99399504 | Buddenbrockia bryozoides | 3280430 | Cnidaria | other_Eukaryota | 62.1 | 5.83e-5 | NTclustered | gi|237512524|gb|FJ981817.1| | 3280430 | g72091 | i0 | 97.222 | 8.45257452574526 | 36 | 1 | 10 | 0 | 71 | 106 | 1765 | 1800 | Buddenbrockia plumatellae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 3119 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Malacovalvulida | Saccosporidae | Buddenbrockia | Buddenbrockia bryozoides | |
| 21809015 | 21809015 | PRJEB66218_P_NODE_203818_length_210_cov_0.872483_g201388_i0 | PRJEB66218 | 203818 | 210 | 0.872483 | 1.8322143 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2918369564|emb|OZ237730.1| | 317547 | g201388 | i0 | 96.97 | 0.423809523809524 | 33 | 1 | 16 | 0 | 146 | 178 | 13006051 | 13006083 | Eunicella cavolini genome assembly, chromosome: 14 | blastn | 89 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 21809363 | 21809363 | PRJEB66218_P_NODE_227978_length_204_cov_15.027972_g225548_i0 | PRJEB66218 | 227978 | 204 | 15.027972 | 30.65706288 | Sinuolinea arctica | 1483224 | Cnidaria | other_Eukaryota | 71.3 | 4.91e-8 | NTclustered | gi|605060087|gb|KF874227.1| | 1483224 | g225548 | i0 | 90.741 | 0.416666666666667 | 54 | 4 | 26 | 1 | 42 | 94 | 1326 | 1273 | Sinuolinea arctica 28S ribosomal RNA gene, partial sequence | blastn | 85 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sinuolineidae | Sinuolinea | Sinuolinea arctica | |
| 24358170 | 24358170 | PRJEB66218_P_NODE_207260_length_209_cov_0.878378_g204830_i0 | PRJEB66218 | 207260 | 209 | 0.878378 | 1.83581002 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 65.8 | 2.35e-6 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g204830 | i0 | 97.368 | 23.1722488038278 | 38 | 1 | 18 | 0 | 161 | 198 | 11015332 | 11015295 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 4843 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25220367 | 25220367 | PRJEB66218_P_NODE_147880_length_243_cov_1.785714_g145451_i0 | PRJEB66218 | 147880 | 243 | 1.785714 | 4.33928502 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 4.71e-4 | NTclustered | gi|2917940759|emb|OZ237572.1| | 6108 | g145451 | i0 | 92.683 | 13.0164609053498 | 41 | 2 | 17 | 1 | 9 | 49 | 10481395 | 10481434 | Anemonia sulcata genome assembly, chromosome: 18 | blastn | 3163 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 25221285 | 25221285 | PRJEB66218_P_NODE_79760_length_354_cov_1.331058_g77334_i0 | PRJEB66218 | 79760 | 354 | 1.331058 | 4.71194532 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 58.4 | 7.2e-4 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g77334 | i0 | 97.059 | 8.5819209039548 | 34 | 1 | 10 | 0 | 314 | 347 | 959244 | 959211 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 3038 | 58.4 | 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);;