contig_metadata
24 rows where bioproject = "PRJNA950981", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2209144 | 2209144 | PRJNA950981_P_NODE_12862_length_287_cov_1.093458_g12686_i0 | PRJNA950981 | 12862 | 287 | 1.093458 | 3.13822446 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 63.9 | 1.23e-5 | NTclustered | gi|2729094309|ref|XM_065209959.1| | 499914 | g12686 | i0 | 81.25 | 3.46341463414634 | 80 | 13 | 28 | 2 | 79 | 157 | 2275 | 2197 | PREDICTED: Rhopilema esculentum serine-rich adhesin for platelets-like (LOC135691950), mRNA | blastn | 994 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 2209160 | 2209160 | PRJNA950981_P_NODE_19302_length_247_cov_0.896552_g19126_i0 | PRJNA950981 | 19302 | 247 | 0.896552 | 2.21448344 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 134 | 1.4100000000000001e-36 | NR | XP_031573371.1 | 6105 | g19126 | i0 | 70.7 | 2.98785425101215 | 82 | 24 | 99.6 | 0 | 1 | 246 | 127 | 208 | XP_031573371.1 U3 small nucleolar ribonucleoprotein protein IMP4-like [Actinia tenebrosa] | diamond | 738 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 3484501 | 3484501 | PRJNA950981_P_NODE_1203_length_844_cov_1.214008_g1058_i0 | PRJNA950981 | 1203 | 844 | 1.214008 | 10.24622752 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 427 | 1.3e-141 | NR | XP_047143150.1 | 6087 | g1058 | i0 | 74.3 | 22.8909952606635 | 280 | 72 | 99.5 | 0 | 2 | 841 | 414 | 693 | XP_047143150.1 probable aconitate hydratase, mitochondrial isoform X1 [Hydra vulgaris] | diamond | 19320 | 427 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 7311864 | 7311864 | PRJNA950981_P_NODE_13406_length_281_cov_1.750000_g13230_i0 | PRJNA950981 | 13406 | 281 | 1.75 | 4.9175 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 64.7 | 6.49e-11 | NR | XP_067057716.1 | 159855 | g13230 | i0 | 61.1 | 1.72953736654804 | 54 | 21 | 57.7 | 0 | 5 | 166 | 69 | 122 | XP_067057716.1 large ribosomal subunit protein uL29-like [Acropora muricata] | diamond | 486 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 8586820 | 8586820 | PRJNA950981_P_NODE_18107_length_249_cov_2.482955_g17931_i0 | PRJNA950981 | 18107 | 249 | 2.482955 | 6.18255795 | Parvicapsula minibicornis | 109801 | Cnidaria | other_Eukaryota | 132 | 2.81e-26 | NTclustered | gi|605060084|gb|KF874224.1| | 109801 | g17931 | i0 | 87.179 | 49.566265060241 | 117 | 13 | 47 | 2 | 3 | 119 | 347 | 233 | Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence | blastn | 12342 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula minibicornis | |
| 8586840 | 8586840 | PRJNA950981_P_NODE_447_length_1309_cov_3.970874_g371_i0 | PRJNA950981 | 447 | 1309 | 3.970874 | 51.97874066 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.01 | NTclustered | gi|2917940745|emb|OZ237569.1| | 6108 | g371 | i0 | 100 | 0.0229182582123759 | 30 | 0 | 2 | 0 | 1271 | 1300 | 7670100 | 7670129 | Anemonia sulcata genome assembly, chromosome: 15 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 9861856 | 9861856 | PRJNA950981_P_NODE_16548_length_253_cov_0.866667_g16372_i0 | PRJNA950981 | 16548 | 253 | 0.866667 | 2.19266751 | Actinia tenebrosa | 6105 | Cnidaria | other_Eukaryota | 90.5 | 1.52e-20 | NR | XP_031557058.1 | 6105 | g16372 | i0 | 56.9 | 0.853754940711462 | 72 | 31 | 85.4 | 0 | 253 | 38 | 110 | 181 | XP_031557058.1 ADP-ribosylation factor-like protein 3 [Actinia tenebrosa] | diamond | 216 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 16236671 | 16236671 | PRJNA950981_P_NODE_10973_length_308_cov_1.812766_g10797_i0 | PRJNA950981 | 10973 | 308 | 1.812766 | 5.58331928 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 161 | 1.36e-48 | NR | XP_020901306.1 | 2652724 | g10797 | i0 | 69.6 | 15.8961038961039 | 102 | 31 | 99.4 | 0 | 307 | 2 | 11 | 112 | XP_020901306.1 40S ribosomal protein S18 [Exaiptasia diaphana] | diamond | 4896 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 17512005 | 17512005 | PRJNA950981_P_NODE_11914_length_297_cov_1.602679_g11738_i0 | PRJNA950981 | 11914 | 297 | 1.602679 | 4.75995663 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 166 | 3.53e-50 | NR | XP_065052312.1 | 499914 | g11738 | i0 | 81.6 | 10.7979797979798 | 98 | 18 | 99 | 0 | 3 | 296 | 51 | 148 | XP_065052312.1 large ribosomal subunit protein uL5-like [Rhopilema esculentum] | diamond | 3207 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 17512026 | 17512026 | PRJNA950981_P_NODE_17654_length_250_cov_2.299435_g17478_i0 | PRJNA950981 | 17654 | 250 | 2.299435 | 5.7485875 | Sinuolinea arctica | 1483224 | Cnidaria | other_Eukaryota | 80.5 | 1.04e-10 | NTclustered | gi|605060087|gb|KF874227.1| | 1483224 | g17478 | i0 | 80.374 | 0.552 | 107 | 19 | 42 | 2 | 106 | 211 | 1273 | 1378 | Sinuolinea arctica 28S ribosomal RNA gene, partial sequence | blastn | 138 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sinuolineidae | Sinuolinea | Sinuolinea arctica | |
| 20060486 | 20060486 | PRJNA950981_P_NODE_1176_length_851_cov_4.651671_g1033_i0 | PRJNA950981 | 1176 | 851 | 4.651671 | 39.58572021 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 296 | 5.779999999999999e-92 | NR | XP_020625376.1 | 48498 | g1033 | i0 | 62.1 | 5.00235017626322 | 235 | 89 | 82.8 | 0 | 64 | 768 | 449 | 683 | XP_020625376.1 uncharacterized protein LOC110062769 [Orbicella faveolata] | diamond | 4257 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata | |
| 20060529 | 20060529 | PRJNA950981_P_NODE_5056_length_432_cov_1.303621_g4880_i0 | PRJNA950981 | 5056 | 432 | 1.303621 | 5.63164272 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 232 | 1.99e-74 | NR | XP_065063129.1 | 499914 | g4880 | i0 | 76.9 | 5.95833333333333 | 143 | 33 | 99.3 | 0 | 431 | 3 | 86 | 228 | XP_065063129.1 large ribosomal subunit protein uL30-like [Rhopilema esculentum] | diamond | 2574 | 232 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 21335965 | 21335965 | PRJNA950981_P_NODE_4197_length_471_cov_1.331658_g4022_i0 | PRJNA950981 | 4197 | 471 | 1.331658 | 6.27210918 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 217 | 5.22e-68 | NR | XP_065068387.1 | 499914 | g4022 | i0 | 67.5 | 0.980891719745223 | 154 | 50 | 98.1 | 0 | 9 | 470 | 37 | 190 | XP_065068387.1 large ribosomal subunit protein eL8-like [Rhopilema esculentum] | diamond | 462 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 26803934 | 26803934 | PRJNA950981_P_NODE_21201_length_243_cov_0.917647_g21025_i0 | PRJNA950981 | 21201 | 243 | 0.917647 | 2.22988221 | Pocillopora meandrina | 46732 | Cnidaria | other_Eukaryota | 55.8 | 9.15e-7 | NR | CAH3153693.1 | 46732 | g21025 | i0 | 33.8 | 1.72839506172839 | 71 | 45 | 87.7 | 2 | 239 | 27 | 2855 | 2923 | CAH3153693.1 unnamed protein product [Pocillopora meandrina] | diamond | 420 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora meandrina | |
| 27190041 | 27190041 | PRJNA950981_P_NODE_10602_length_313_cov_1.491667_g10426_i0 | PRJNA950981 | 10602 | 313 | 1.491667 | 4.66891771 | Acroporidae | 6126 | Cnidaria | other_Eukaryota | 140 | 1.29e-37 | NR | XP_029192128.2 | 45264 | g10426 | i0 | 66.3 | 1.99361022364217 | 104 | 35 | 99.7 | 0 | 313 | 2 | 138 | 241 | XP_029192128.2 lysosomal aspartic protease-like [Acropora millepora] | diamond | 624 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27878432 | 27878432 | PRJNA950981_P_NODE_2065_length_655_cov_1.450172_g1892_i0 | PRJNA950981 | 2065 | 655 | 1.450172 | 9.4986266 | Exaiptasia diaphana | 2652724 | Cnidaria | other_Eukaryota | 100 | 3.29e-21 | NR | KXJ13581.1 | 2652724 | g1892 | i0 | 36.8 | 2.43206106870229 | 163 | 101 | 74.7 | 1 | 653 | 165 | 131 | 291 | KXJ13581.1 Charged multivesicular body protein 4b [Exaiptasia diaphana] | diamond | 1593 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Aiptasiidae | Exaiptasia | Exaiptasia diaphana | |
| 27941674 | 27941674 | PRJNA950981_P_NODE_15005_length_266_cov_1.611399_g14829_i0 | PRJNA950981 | 15005 | 266 | 1.611399 | 4.28632134 | Pocillopora verrucosa | 203993 | Cnidaria | other_Eukaryota | 47.8 | 8.63e-4 | NR | XP_066020441.1 | 203993 | g14829 | i0 | 35.6 | 3.06766917293233 | 90 | 51 | 94.7 | 5 | 263 | 12 | 533 | 621 | XP_066020441.1 allene oxide synthase-lipoxygenase protein-like [Pocillopora verrucosa] | diamond | 816 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora verrucosa | |
| 28131190 | 28131190 | PRJNA950981_P_NODE_17805_length_250_cov_0.881356_g17629_i0 | PRJNA950981 | 17805 | 250 | 0.881356 | 2.20339 | Acropora millepora | 45264 | Cnidaria | other_Eukaryota | 50.8 | 5.82e-5 | NR | XP_044174721.1 | 45264 | g17629 | i0 | 37.2 | 2.7 | 78 | 49 | 93.6 | 0 | 11 | 244 | 559 | 636 | XP_044174721.1 LOW QUALITY PROTEIN: alpha-actinin-1-like [Acropora millepora] | diamond | 675 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 28863728 | 28863728 | PRJNA950981_P_NODE_5688_length_409_cov_2.169643_g5512_i0 | PRJNA950981 | 5688 | 409 | 2.169643 | 8.87383987 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.6 | 2.31e-17 | NR | KAK2562276.1 | 6130 | g5512 | i0 | 40.1 | 11.7139364303178 | 137 | 76 | 99.8 | 5 | 408 | 1 | 819 | 950 | KAK2562276.1 AP-2 complex subunit beta [Acropora cervicornis] | diamond | 4791 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30815410 | 30815410 | PRJNA950981_P_NODE_10334_length_317_cov_1.213115_g10158_i0 | PRJNA950981 | 10334 | 317 | 1.213115 | 3.84557455 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 58.5 | 1.77e-7 | NR | XP_001638649.2 | 45351 | g10158 | i0 | 37.1 | 1.44794952681388 | 97 | 48 | 87.1 | 3 | 4 | 279 | 64 | 152 | XP_001638649.2 lysM and putative peptidoglycan-binding domain-containing protein 2 [Nematostella vectensis] | diamond | 459 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 30917006 | 30917006 | PRJNA950981_P_NODE_12594_length_289_cov_3.578704_g12418_i0 | PRJNA950981 | 12594 | 289 | 3.578704 | 10.34245456 | root | 1 | Root_unresolved | Root_unresolved | 137 | 4.75e-37 | NR | KAK2573205.1 | 6130 | g12418 | i0 | 65.6 | 6.02076124567474 | 96 | 33 | 99.7 | 0 | 2 | 289 | 122 | 217 | KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis] | diamond | 1740 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 30942009 | 30942009 | PRJNA950981_P_NODE_14474_length_271_cov_1.464646_g14298_i0 | PRJNA950981 | 14474 | 271 | 1.464646 | 3.96919066 | Dendronephthya gigantea | 151771 | Cnidaria | other_Eukaryota | 65.1 | 7.33e-10 | NR | XP_028413058.1 | 151771 | g14298 | i0 | 32 | 9.49815498154982 | 97 | 59 | 99.6 | 3 | 2 | 271 | 671 | 767 | XP_028413058.1 ER membrane protein complex subunit 1-like [Dendronephthya gigantea] | diamond | 2574 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Nephtheidae | Dendronephthya | Dendronephthya gigantea | |
| 31352806 | 31352806 | PRJNA950981_P_NODE_18156_length_249_cov_1.727273_g17980_i0 | PRJNA950981 | 18156 | 249 | 1.727273 | 4.30090977 | Desmophyllum pertusum | 174260 | Cnidaria | other_Eukaryota | 94 | 9.9e-21 | NR | KAJ7382119.1 | 174260 | g17980 | i0 | 57.5 | 0.879518072289157 | 73 | 31 | 88 | 0 | 220 | 2 | 121 | 193 | KAJ7382119.1 Lysophospholipase D gdpd1 [Desmophyllum pertusum] | diamond | 219 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 32813366 | 32813366 | PRJNA950981_P_NODE_12400_length_292_cov_1.068493_g12224_i0 | PRJNA950981 | 12400 | 292 | 1.068493 | 3.11999956 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 78.6 | 1.75e-14 | NR | XP_020616436.1 | 48498 | g12224 | i0 | 45.3 | 6.16438356164384 | 75 | 40 | 76 | 1 | 288 | 67 | 749 | 823 | XP_020616436.1 vacuolar protein sorting-associated protein 41 homolog [Orbicella faveolata] | diamond | 1800 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Merulinidae | Orbicella | Orbicella faveolata |
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);;