RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA657343" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA657343 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
1899300 1899300 PRJNA657343_P_NODE_40662_length_165_cov_0.896552_g40638_i0 PRJNA657343 40662 165 0.896552 1.4793108 Hydra vulgaris 6087 Cnidaria other_Eukaryota 93.6 1.57e-20   NR XP_047145598.1 6087 g40638 i0 81.5 3.92727272727273 54 10 98.2 0 3 164 645 698 XP_047145598.1 pumilio homolog 2 isoform X3 [Hydra vulgaris] diamond 648 93.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
3173798 3173798 PRJNA657343_P_NODE_23103_length_196_cov_2.551020_g23079_i0 PRJNA657343 23103 196 2.55102 4.9999992 Hydra vulgaris 6087 Cnidaria other_Eukaryota 90.5 5.29e-22   NR XP_002161016.1 6087 g23079 i0 62.9 16.8979591836735 62 23 94.9 0 6 191 2 63 XP_002161016.1 small ribosomal subunit protein eS27-like [Hydra vulgaris] diamond 3312 90.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
24849406 24849406 PRJNA657343_P_NODE_33940_length_171_cov_1.196721_g33916_i0 PRJNA657343 33940 171 1.196721 2.04639291 root 1 Root_unresolved Root_unresolved 89 7.48e-19   NR XP_057298406.1 13093 g33916 i0 74.5 3.85964912280702 55 14 96.5 0 1 165 390 444 XP_057298406.1 isocitrate dehydrogenase [NADP] cytoplasmic-like [Hydractinia symbiolongicarpus] diamond 660 89.7 0.992196209587514 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
27175961 27175961 PRJNA657343_P_NODE_28362_length_183_cov_1.111940_g28338_i0 PRJNA657343 28362 183 1.11194 2.0348502 Hydra vulgaris 6087 Cnidaria other_Eukaryota 53.1 2.48e-6   NR XP_047137741.1 6087 g28338 i0 73.3 2.86885245901639 30 8 49.2 0 1 90 164 193 XP_047137741.1 uncharacterized protein LOC124814272 isoform X1 [Hydra vulgaris] diamond 525 53.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
27523696 27523696 PRJNA657343_P_NODE_28143_length_183_cov_1.865672_g28119_i0 PRJNA657343 28143 183 1.865672 3.41417976 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 49.3 2.19e-5   NR XP_057307804.1 13093 g28119 i0 49.1 0.901639344262295 55 27 88.5 1 176 15 32 86 XP_057307804.1 NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 13-like [Hydractinia symbiolongicarpus] diamond 165 49.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
27586964 27586964 PRJNA657343_P_NODE_32664_length_173_cov_2.016129_g32640_i0 PRJNA657343 32664 173 2.016129 3.48790317 Thelohanellus kitauei 669202 Cnidaria other_Eukaryota 70.9 1.22e-12   NR KII66927.1 669202 g32640 i0 61.8 3.91907514450867 55 20 93.6 1 171 10 158 212 KII66927.1 Retrovirus-related Pol polyprotein [Thelohanellus kitauei] diamond 678 70.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Thelohanellus Thelohanellus kitauei
27630824 27630824 PRJNA657343_P_NODE_20304_length_206_cov_2.745223_g20280_i0 PRJNA657343 20304 206 2.745223 5.65515938 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 72.4 7.95e-13   NR XP_029207832.2 45264 g20280 i0 54.7 3.3495145631068 53 24 77.2 0 195 37 575 627 XP_029207832.2 protein disulfide-isomerase A4-like [Acropora millepora] diamond 690 72.8 0.994505494505495 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
27694115 27694115 PRJNA657343_P_NODE_24904_length_191_cov_1.556338_g24880_i0 PRJNA657343 24904 191 1.556338 2.97260558 Metazoa 33208 Cnidaria other_Eukaryota 100 8.52e-23   NR XP_031566990.1 6105 g24880 i0 67.7 36.0314136125654 62 20 97.4 0 1 186 418 479 XP_031566990.1 mannosyl-oligosaccharide glucosidase-like [Actinia tenebrosa] diamond 6882 100 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
28261957 28261957 PRJNA657343_P_NODE_9646_length_271_cov_5.509009_g9622_i0 PRJNA657343 9646 271 5.509009 14.92941439 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 71.2 8.27e-14   NR XP_001640117.2 45351 g9622 i0 56.7 10.5055350553506 67 28 74.2 1 15 215 27 92 XP_001640117.2 60S ribosomal protein L38 [Nematostella vectensis] diamond 2847 71.6 0.994413407821229 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
28293608 28293608 PRJNA657343_P_NODE_27046_length_186_cov_1.416058_g27022_i0 PRJNA657343 27046 186 1.416058 2.63386788 Metazoa 33208 Cnidaria other_Eukaryota 58.2 6.27e-8   NR XP_047134564.1 6087 g27022 i0 59.6 6.48387096774194 52 20 83.9 1 26 181 739 789 XP_047134564.1 valine--tRNA ligase isoform X2 [Hydra vulgaris] diamond 1206 58.5 0.994871794871795 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
28325201 28325201 PRJNA657343_P_NODE_25846_length_189_cov_1.178571_g25822_i0 PRJNA657343 25846 189 1.178571 2.22749919 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 80.5 8.79e-16   NR XP_032240819.2 45351 g25822 i0 53.2 9.82539682539683 62 29 98.4 0 187 2 120 181 XP_032240819.2 folylpolyglutamate synthase, mitochondrial [Nematostella vectensis] diamond 1857 80.9 0.995055624227441 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
28881321 28881321 PRJNA657343_P_NODE_45988_length_157_cov_4.351852_g45964_i0 PRJNA657343 45988 157 4.351852 6.83240764 Nematostella vectensis 45351 Cnidaria other_Eukaryota 65.9 7e-11   NR XP_001626688.3 45351 g45964 i0 61.5 1.98726114649682 52 20 99.4 0 1 156 200 251 XP_001626688.3 cathepsin B [Nematostella vectensis] diamond 312 65.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
28925049 28925049 PRJNA657343_P_NODE_19248_length_210_cov_2.397516_g19224_i0 PRJNA657343 19248 210 2.397516 5.0347836 Scleractinia 6125 Cnidaria other_Eukaryota 122 1.2099999999999999e-31   NR CAH3105477.1 104759 g19224 i0 89.6 28.7142857142857 67 7 95.7 0 203 3 218 284 CAH3105477.1 unnamed protein product [Porites lobata] diamond 6030 122 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
29102547 29102547 PRJNA657343_P_NODE_15428_length_228_cov_3.357542_g15404_i0 PRJNA657343 15428 228 3.357542 7.65519576 Acropora digitifera 70779 Cnidaria other_Eukaryota 98.6 1.49e-23   NR XP_015780666.1 70779 g15404 i0 66.7 8.80263157894737 75 25 98.7 0 227 3 49 123 XP_015780666.1 PREDICTED: 60S ribosomal protein L13-like [Acropora digitifera] diamond 2007 98.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
29240981 29240981 PRJNA657343_P_NODE_39889_length_165_cov_1.741379_g39865_i0 PRJNA657343 39889 165 1.741379 2.87327535 Metazoa 33208 Cnidaria other_Eukaryota 65.9 8.9e-11   NR XP_031556809.1 6105 g39865 i0 62.7 9.29090909090909 51 19 92.7 0 3 155 128 178 XP_031556809.1 dihydropyrimidine dehydrogenase [NADP(+)]-like [Actinia tenebrosa] diamond 1533 65.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
29272310 29272310 PRJNA657343_P_NODE_19589_length_209_cov_1.831250_g19565_i0 PRJNA657343 19589 209 1.83125 3.8273125 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 69.7 7.49e-12   NR CAH3165163.1 104759 g19565 i0 56.9 12.8612440191388 58 22 83.3 2 1 174 1335 1389 CAH3165163.1 unnamed protein product [Porites lobata] diamond 2688 69.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
29796931 29796931 PRJNA657343_P_NODE_28071_length_183_cov_2.343284_g28047_i0 PRJNA657343 28071 183 2.343284 4.28820972 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 42.7 0.0167   NR KAJ7337121.1 174260 g28047 i0 47.2 0.590163934426229 36 19 59 0 22 129 204 239 KAJ7337121.1 hypothetical protein OS493_009973 [Desmophyllum pertusum] diamond 108 42.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
30409890 30409890 PRJNA657343_P_NODE_24213_length_193_cov_1.402778_g24189_i0 PRJNA657343 24213 193 1.402778 2.70736154 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.2 3.06e-7   NR CAB4006899.1 317549 g24189 i0 47.4 5.47150259067358 57 27 83.9 2 30 191 208 264 CAB4006899.1 Cathepsin B [Paramuricea clavata] diamond 1056 56.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
30966199 30966199 PRJNA657343_P_NODE_3074_length_416_cov_4.029973_g3051_i0 PRJNA657343 3074 416 4.029973 16.76468768 Paramuricea clavata 317549 Cnidaria other_Eukaryota 55.5 9.24e-6   NR CAB3980651.1 317549 g3051 i0 35.7 1.71634615384615 98 56 70.7 1 30 323 1008 1098 CAB3980651.1 Transposon Ty3-I Gag-Pol poly [Paramuricea clavata] diamond 714 55.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
31357662 31357662 PRJNA657343_P_NODE_41836_length_164_cov_0.904348_g41812_i0 PRJNA657343 41836 164 0.904348 1.48313072 Opisthokonta 33154 Cnidaria other_Eukaryota 43.5 0.00689   NR KAJ7337131.1 174260 g41812 i0 46.2 2.19512195121951 39 21 71.3 0 10 126 8 46 KAJ7337131.1 hypothetical protein OS493_009985 [Desmophyllum pertusum] diamond 360 43.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
32041289 32041289 PRJNA657343_P_NODE_37298_length_167_cov_1.728814_g37274_i0 PRJNA657343 37298 167 1.728814 2.88711938 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 76.3 1.53e-14   NR XP_066923102.1 252671 g37274 i0 59.6 0.934131736526946 52 21 93.4 0 8 163 8 59 XP_066923102.1 gelsolin-like protein 1 [Clytia hemisphaerica] diamond 156 76.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica

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