RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA274362 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
13124203 13124203 PRJNA274362_S_NODE_14871_length_233_cov_1.092391_g14751_i0 PRJNA274362 14871 233 1.092391 2.54527103 Metazoa 33208 Cnidaria other_Eukaryota 92.8 6.29e-22   NR XP_031557202.1 6105 g14751 i0 67.7 26.7811158798283 65 21 83.7 0 6 200 84 148 XP_031557202.1 60S ribosomal protein L27a-like [Actinia tenebrosa] diamond 6240 92.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
19496681 19496681 PRJNA274362_S_NODE_32096_length_169_cov_0.866667_g31976_i0 PRJNA274362 32096 169 0.866667 1.46466723 root 1 Root_unresolved Root_unresolved 70.1 1.21e-12   NR EDO26728.1 45351 g31976 i0 65.3 10.4023668639053 49 17 87 0 147 1 175 223 EDO26728.1 predicted protein, partial [Nematostella vectensis] diamond 1758 70.5 0.994326241134752 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
22046900 22046900 PRJNA274362_S_NODE_1478_length_647_cov_1.414716_g1376_i0 PRJNA274362 1478 647 1.414716 9.15321252 Aurelia aurita 6145 Cnidaria other_Eukaryota 233 3.44e-72   NR AAX09920.1 6145 g1376 i0 61.9 22.0571870170015 215 72 99.7 2 646 2 140 344 AAX09920.1 heat shock protein Hsp70, partial [Aurelia aurita] diamond 14271 233 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Semaeostomeae Ulmaridae Aurelia Aurelia aurita
27042460 27042460 PRJNA274362_S_NODE_18362_length_213_cov_1.890244_g18242_i0 PRJNA274362 18362 213 1.890244 4.02621972 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 71.6 1.15e-12   NR XP_028516473.1 2652724 g18242 i0 48.5 8.29577464788732 66 33 93 1 5 202 155 219 XP_028516473.1 chymotrypsinogen B, partial [Exaiptasia diaphana] diamond 1767 71.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
27232075 27232075 PRJNA274362_S_NODE_16103_length_225_cov_1.181818_g15983_i0 PRJNA274362 16103 225 1.181818 2.6590905 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 65.5 1.21e-11   NR KAJ7387358.1 174260 g15983 i0 79.1 1.72 43 9 57.3 0 130 2 53 95 KAJ7387358.1 hypothetical protein OS493_004349 [Desmophyllum pertusum] diamond 387 65.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
28702505 28702505 PRJNA274362_S_NODE_1167_length_713_cov_2.819277_g1077_i0 PRJNA274362 1167 713 2.819277 20.10144501 Metazoa 33208 Cnidaria other_Eukaryota 176 8.23e-49   NR PFX18144.1 50429 g1077 i0 66.9 19.695652173913 127 42 53.4 0 97 477 331 457 PFX18144.1 60S ribosomal protein L23a [Stylophora pistillata] diamond 14043 177 0.994350282485876 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
30408036 30408036 PRJNA274362_S_NODE_30693_length_172_cov_1.211382_g30573_i0 PRJNA274362 30693 172 1.211382 2.08357704 Opisthokonta 33154 Cnidaria other_Eukaryota 64.3 1.16e-10   NR XP_031562005.1 6105 g30573 i0 64.3 3.62790697674419 42 15 73.3 0 171 46 7 48 XP_031562005.1 60S ribosomal protein L13-like [Actinia tenebrosa] diamond 624 64.7 0.993817619783617 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
30611053 30611053 PRJNA274362_S_NODE_15633_length_228_cov_1.128492_g15513_i0 PRJNA274362 15633 228 1.128492 2.57296176 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 47 8.04e-4   NR XP_065055258.1 499914 g15513 i0 87 0.302631578947368 23 3 30.3 0 30 98 217 239 XP_065055258.1 large ribosomal subunit protein eL6-like [Rhopilema esculentum] diamond 69 47 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
31179565 31179565 PRJNA274362_S_NODE_21855_length_199_cov_1.040000_g21735_i0 PRJNA274362 21855 199 1.04 2.0696 Nematostella vectensis 45351 Cnidaria other_Eukaryota 90.1 4.01e-19   NR XP_032229863.2 45351 g21735 i0 67.7 1.94472361809045 65 21 98 0 3 197 480 544 XP_032229863.2 ATP synthase subunit alpha, mitochondrial-like [Nematostella vectensis] diamond 387 90.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
31482549 31482549 PRJNA274362_S_NODE_21616_length_200_cov_0.993377_g21496_i0 PRJNA274362 21616 200 0.993377 1.986754 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 107 6.32e-26   NR KAK2573205.1 6130 g21496 i0 66.7 11.85 66 22 99 0 2 199 146 211 KAK2573205.1 Receptor of activated protein C kinase 1 [Acropora cervicornis] diamond 2370 107 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
31482550 31482550 PRJNA274362_S_NODE_29756_length_174_cov_1.392000_g29636_i0 PRJNA274362 29756 174 1.392 2.42208 Pocilloporidae 46729 Cnidaria other_Eukaryota 60.1 1.05e-8   NR XP_027039989.1 46731 g29636 i0 56.1 2.94827586206897 57 25 98.3 0 172 2 298 354 XP_027039989.1 60S ribosomal protein L4-B-like [Pocillopora damicornis] diamond 513 60.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
31956616 31956616 PRJNA274362_S_NODE_18497_length_213_cov_0.951220_g18377_i0 PRJNA274362 18497 213 0.95122 2.0260986 Metazoa 33208 Cnidaria other_Eukaryota 81.6 1.37e-16   NR XP_066935445.1 252671 g18377 i0 61.5 5.84507042253521 52 20 73.2 0 212 57 10 61 XP_066935445.1 LIM and SH3 domain protein 1-like [Clytia hemisphaerica] diamond 1245 81.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
31970614 31970614 PRJNA274362_S_NODE_35738_length_164_cov_1.095652_g35618_i0 PRJNA274362 35738 164 1.095652 1.79686928 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 67.4 1.36e-11   NR XP_028400527.1 151771 g35618 i0 50 0.98780487804878 54 27 98.8 0 163 2 123 176 XP_028400527.1 endoplasmic reticulum resident protein 29-like [Dendronephthya gigantea] diamond 162 67.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;