contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA909412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20017244 | 20017244 | PRJNA909412_P_NODE_17796_length_150_cov_1.909910_g17655_i0 | PRJNA909412 | 17796 | 150 | 1.90991 | 2.864865 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 92.4 | 4.15e-21 | NR | KAK2570311.1 | 6130 | g17655 | i0 | 100 | 219.24 | 42 | 0 | 84 | 0 | 24 | 149 | 222 | 263 | KAK2570311.1 ADP-ribosylation factor 1-like 2 [Acropora cervicornis] | diamond | 32886 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 21292625 | 21292625 | PRJNA909412_P_NODE_797_length_628_cov_17.967742_g686_i0 | PRJNA909412 | 797 | 628 | 17.967742 | 112.83741976 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 214 | 1.85e-67 | NR | ABC67745.1 | 6110 | g686 | i0 | 59.9 | 34.7770700636943 | 162 | 65 | 77.4 | 0 | 31 | 516 | 1 | 162 | ABC67745.1 ribosomal protein L12 [Anthopleura elegantissima] | diamond | 21840 | 214 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anthopleura | Anthopleura elegantissima | |
| 26968500 | 26968500 | PRJNA909412_P_NODE_14602_length_157_cov_1.050847_g14461_i0 | PRJNA909412 | 14602 | 157 | 1.050847 | 1.64982979 | Acropora | 6127 | Cnidaria | other_Eukaryota | 58.5 | 9e-9 | NR | XP_015766387.1 | 70779 | g14461 | i0 | 49 | 1.94904458598726 | 51 | 26 | 97.5 | 0 | 5 | 157 | 124 | 174 | XP_015766387.1 PREDICTED: acid phosphatase type 7-like [Acropora digitifera] | diamond | 306 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora digitifera | |
| 27221262 | 27221262 | PRJNA909412_P_NODE_2982_length_305_cov_2.661654_g2842_i0 | PRJNA909412 | 2982 | 305 | 2.661654 | 8.1180447 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 108 | 3.96e-25 | NR | XP_065680004.1 | 6087 | g2842 | i0 | 50.5 | 2.98032786885246 | 101 | 49 | 99.3 | 1 | 2 | 304 | 188 | 287 | XP_065680004.1 thioredoxin reductase 1, cytoplasmic isoform X2 [Hydra vulgaris] | diamond | 909 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 28224428 | 28224428 | PRJNA909412_P_NODE_6006_length_214_cov_1.422857_g5865_i0 | PRJNA909412 | 6006 | 214 | 1.422857 | 3.04491398 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 74.7 | 2.43e-15 | NR | XP_066934390.1 | 252671 | g5865 | i0 | 51.2 | 2.29906542056075 | 82 | 28 | 99.5 | 3 | 213 | 1 | 5 | 85 | XP_066934390.1 eukaryotic translation initiation factor 1-like [Clytia hemisphaerica] | diamond | 492 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30182382 | 30182382 | PRJNA909412_P_NODE_7872_length_189_cov_1.673333_g7731_i0 | PRJNA909412 | 7872 | 189 | 1.673333 | 3.16259937 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 79.3 | 2.03e-15 | NR | XP_020901898.1 | 2652724 | g7731 | i0 | 67.7 | 4.79365079365079 | 62 | 17 | 98.4 | 1 | 3 | 188 | 144 | 202 | XP_020901898.1 tryptophan--tRNA ligase, cytoplasmic [Exaiptasia diaphana] | diamond | 906 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 30814286 | 30814286 | PRJNA909412_P_NODE_2054_length_376_cov_5.320475_g1914_i0 | PRJNA909412 | 2054 | 376 | 5.320475 | 20.004986 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 63.2 | 3.66e-9 | NR | XP_022805251.1 | 50429 | g1914 | i0 | 48.1 | 1.26063829787234 | 81 | 39 | 62.2 | 2 | 376 | 143 | 129 | 209 | XP_022805251.1 glutathione S-transferase 1-like [Stylophora pistillata] | diamond | 474 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 30972417 | 30972417 | PRJNA909412_P_NODE_14114_length_158_cov_3.478992_g13973_i0 | PRJNA909412 | 14114 | 158 | 3.478992 | 5.49680736 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 68.6 | 9.13e-12 | NR | XP_001628323.2 | 45351 | g13973 | i0 | 57.9 | 3.26582278481013 | 57 | 17 | 94.9 | 1 | 8 | 157 | 121 | 177 | XP_001628323.2 protein DD3-3 [Nematostella vectensis] | diamond | 516 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31161576 | 31161576 | PRJNA909412_P_NODE_13035_length_161_cov_1.008197_g12894_i0 | PRJNA909412 | 13035 | 161 | 1.008197 | 1.62319717 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 42 | 0.0228 | NR | XP_065067298.1 | 499914 | g12894 | i0 | 47.1 | 2.04968944099379 | 34 | 18 | 63.4 | 0 | 58 | 159 | 25 | 58 | XP_065067298.1 mitochondrial basic amino acids transporter-like [Rhopilema esculentum] | diamond | 330 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 31636216 | 31636216 | PRJNA909412_P_NODE_6696_length_203_cov_2.878049_g6555_i0 | PRJNA909412 | 6696 | 203 | 2.878049 | 5.84243947 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 56.6 | 2.75e-7 | NR | XP_058952051.2 | 203993 | g6555 | i0 | 50.8 | 1.78817733990148 | 59 | 26 | 87.2 | 2 | 25 | 201 | 116 | 171 | XP_058952051.2 LOW QUALITY PROTEIN: uncharacterized protein [Pocillopora verrucosa] | diamond | 363 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 31762750 | 31762750 | PRJNA909412_P_NODE_5617_length_220_cov_2.353591_g5476_i0 | PRJNA909412 | 5617 | 220 | 2.353591 | 5.1779002 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 86.7 | 5.99e-18 | NR | XP_031563660.1 | 6105 | g5476 | i0 | 67.2 | 3.16363636363636 | 58 | 19 | 79.1 | 0 | 214 | 41 | 190 | 247 | XP_031563660.1 zinc metalloproteinase nas-4-like isoform X2 [Actinia tenebrosa] | diamond | 696 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31960007 | 31960007 | PRJNA909412_P_NODE_5497_length_222_cov_2.601093_g5356_i0 | PRJNA909412 | 5497 | 222 | 2.601093 | 5.77442646 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 95.9 | 1.07e-22 | NR | XP_001639879.2 | 45351 | g5356 | i0 | 65.7 | 10.8378378378378 | 67 | 23 | 90.5 | 0 | 203 | 3 | 37 | 103 | XP_001639879.2 40S ribosomal protein S11 [Nematostella vectensis] | diamond | 2406 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32110872 | 32110872 | PRJNA909412_P_NODE_2018_length_380_cov_2.677419_g1878_i0 | PRJNA909412 | 2018 | 380 | 2.677419 | 10.1741922 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 84 | 3.76e-17 | NR | XP_065672637.1 | 6087 | g1878 | i0 | 36.4 | 2.56578947368421 | 107 | 68 | 84.5 | 0 | 3 | 323 | 68 | 174 | XP_065672637.1 prostamide/prostaglandin F synthase isoform X2 [Hydra vulgaris] | diamond | 975 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;