contig_metadata
15 rows where bioproject = "PRJNA638138", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2430418 | 2430418 | PRJNA638138_P_NODE_18722_length_253_cov_2.288889_g18507_i0 | PRJNA638138 | 18722 | 253 | 2.288889 | 5.79088917 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 106 | 1.74e-18 | NTclustered | gi|2917940737|emb|OZ237566.1| | 6108 | g18507 | i0 | 100 | 36.7272727272727 | 57 | 0 | 25 | 0 | 1 | 57 | 6792504 | 6792448 | Anemonia sulcata genome assembly, chromosome: 12 | blastn | 9292 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 4437051 | 4437051 | PRJNA638138_P_NODE_20104_length_251_cov_0.865169_g19889_i0 | PRJNA638138 | 20104 | 251 | 0.865169 | 2.17157419 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|2812123817|ref|XR_011127449.1| | 246305 | g19889 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 15 | 43 | 1046 | 1018 | PREDICTED: Montipora capricornis uncharacterized lncRNA (LOC138027322), ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 19736021 | 19736021 | PRJNA638138_P_NODE_14796_length_284_cov_1.094787_g14581_i0 | PRJNA638138 | 14796 | 284 | 1.094787 | 3.10919508 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 132 | 2.32e-33 | NR | XP_047125076.1 | 6087 | g14581 | i0 | 66.3 | 17.0176056338028 | 95 | 31 | 99.3 | 1 | 284 | 3 | 432 | 526 | XP_047125076.1 heat shock protein HSP 90-alpha [Hydra vulgaris] | diamond | 4833 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 22286340 | 22286340 | PRJNA638138_P_NODE_10458_length_326_cov_0.905138_g10243_i0 | PRJNA638138 | 10458 | 326 | 0.905138 | 2.95074988 | Eunicella cavolini | 317547 | Cnidaria | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|2918369535|emb|OZ237717.1| | 317547 | g10243 | i0 | 100 | 0.0858895705521472 | 28 | 0 | 9 | 0 | 164 | 191 | 35648373 | 35648400 | Eunicella cavolini genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Eunicellidae | Eunicella | Eunicella cavolini | |
| 26700994 | 26700994 | PRJNA638138_P_NODE_14721_length_284_cov_1.985782_g14506_i0 | PRJNA638138 | 14721 | 284 | 1.985782 | 5.63962088 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 48.5 | 1.62e-4 | NR | KAF1741564.1 | 59785 | g14506 | i0 | 33.3 | 0.982394366197183 | 93 | 56 | 91.9 | 3 | 266 | 6 | 22 | 114 | KAF1741564.1 hypothetical protein MXB_77 [Myxobolus squamalis] | diamond | 279 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 27283193 | 27283193 | PRJNA638138_P_NODE_12403_length_305_cov_1.137931_g12188_i0 | PRJNA638138 | 12403 | 305 | 1.137931 | 3.47068955 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 125 | 1.89e-33 | NR | KAF1741977.1 | 59785 | g12188 | i0 | 59.6 | 2.01639344262295 | 104 | 38 | 98.4 | 2 | 5 | 304 | 3 | 106 | KAF1741977.1 hypothetical protein MXB_2971 [Myxobolus squamalis] | diamond | 615 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 28217733 | 28217733 | PRJNA638138_P_NODE_25626_length_247_cov_0.885057_g25411_i0 | PRJNA638138 | 25626 | 247 | 0.885057 | 2.18609079 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 87 | 9.77e-18 | NR | KAF0991045.1 | 69463 | g25411 | i0 | 48.1 | 0.983805668016194 | 81 | 42 | 98.4 | 0 | 245 | 3 | 623 | 703 | KAF0991045.1 hypothetical protein HZS_5737 [Henneguya salminicola] | diamond | 243 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 29177810 | 29177810 | PRJNA638138_P_NODE_13709_length_293_cov_1.150000_g13494_i0 | PRJNA638138 | 13709 | 293 | 1.15 | 3.3695 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 104 | 2.99e-25 | NR | KAF1745144.1 | 59785 | g13494 | i0 | 48.4 | 1.94539249146758 | 95 | 49 | 97.3 | 0 | 288 | 4 | 133 | 227 | KAF1745144.1 hypothetical protein MXB_1698 [Myxobolus squamalis] | diamond | 570 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 29859810 | 29859810 | PRJNA638138_P_NODE_16671_length_269_cov_1.260204_g16456_i0 | PRJNA638138 | 16671 | 269 | 1.260204 | 3.38994876 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 142 | 6e-41 | NR | KAF1742241.1 | 59785 | g16456 | i0 | 85.6 | 3.02230483271375 | 90 | 12 | 99.3 | 1 | 268 | 2 | 46 | 135 | KAF1742241.1 hypothetical protein MXB_1441 [Myxobolus squamalis] | diamond | 813 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 30270840 | 30270840 | PRJNA638138_P_NODE_28692_length_245_cov_0.895349_g28477_i0 | PRJNA638138 | 28692 | 245 | 0.895349 | 2.19360505 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 55.5 | 7.18e-7 | NR | XP_001625526.2 | 45351 | g28477 | i0 | 50 | 2.52244897959184 | 50 | 25 | 61.2 | 0 | 96 | 245 | 22 | 71 | XP_001625526.2 prostamide/prostaglandin F synthase-like [Nematostella vectensis] | diamond | 618 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30807740 | 30807740 | PRJNA638138_P_NODE_17874_length_260_cov_1.470588_g17659_i0 | PRJNA638138 | 17874 | 260 | 1.470588 | 3.8235288 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 139 | 9.07e-37 | NR | KAF1745269.1 | 59785 | g17659 | i0 | 72.1 | 0.992307692307692 | 86 | 24 | 99.2 | 0 | 260 | 3 | 372 | 457 | KAF1745269.1 hypothetical protein MXB_427 [Myxobolus squamalis] | diamond | 258 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 30870863 | 30870863 | PRJNA638138_P_NODE_33954_length_242_cov_0.911243_g33739_i0 | PRJNA638138 | 33954 | 242 | 0.911243 | 2.20520806 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 85.5 | 3.29e-17 | NR | KAF0988752.1 | 69463 | g33739 | i0 | 53.8 | 0.991735537190083 | 80 | 37 | 99.2 | 0 | 1 | 240 | 447 | 526 | KAF0988752.1 hypothetical protein HZS_5333, partial [Henneguya salminicola] | diamond | 240 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31060747 | 31060747 | PRJNA638138_P_NODE_33615_length_242_cov_0.911243_g33400_i0 | PRJNA638138 | 33615 | 242 | 0.911243 | 2.20520806 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 54.3 | 1.96e-6 | NR | KAF0986681.1 | 69463 | g33400 | i0 | 52.6 | 0.706611570247934 | 57 | 27 | 70.7 | 0 | 69 | 239 | 171 | 227 | KAF0986681.1 hypothetical protein HZS_984 [Henneguya salminicola] | diamond | 171 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31566632 | 31566632 | PRJNA638138_P_NODE_26716_length_246_cov_1.641618_g26501_i0 | PRJNA638138 | 26716 | 246 | 1.641618 | 4.03838028 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 105 | 1.8999999999999998e-24 | NR | KAF0987888.1 | 69463 | g26501 | i0 | 66.3 | 0.975609756097561 | 80 | 27 | 97.6 | 0 | 245 | 6 | 430 | 509 | KAF0987888.1 hypothetical protein HZS_1699 [Henneguya salminicola] | diamond | 240 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 31724437 | 31724437 | PRJNA638138_P_NODE_31497_length_243_cov_0.905882_g31282_i0 | PRJNA638138 | 31497 | 243 | 0.905882 | 2.20129326 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 89.7 | 1.11e-18 | NR | XP_066931820.1 | 252671 | g31282 | i0 | 50 | 2.61728395061728 | 70 | 32 | 82.7 | 1 | 237 | 37 | 627 | 696 | XP_066931820.1 uncharacterized protein [Clytia hemisphaerica] | diamond | 636 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica |
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);;