RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA382357 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
403256 403256 PRJNA382357_P_NODE_16661_length_533_cov_2.500000_g15933_i0 PRJNA382357 16661 533 2.5 13.325 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 172 3.85e-38   NTclustered gi|2518992834|ref|XM_057447578.1| 13093 g15933 i0 77.703 1.69606003752345 296 57 54 8 235 524 266 558 PREDICTED: Hydractinia symbiolongicarpus charged multivesicular body protein 2a-like (LOC130640957), mRNA blastn 904 172 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
404689 404689 PRJNA382357_P_NODE_95581_length_247_cov_1.370968_g94842_i0 PRJNA382357 95581 247 1.370968 3.38629096 Eunicella cavolini 317547 Cnidaria other_Eukaryota 62.1 3.71e-5   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g94842 i0 97.222 15.4655870445344 36 1 15 0 57 92 11031859 11031894 Eunicella cavolini genome assembly, chromosome: 2 blastn 3820 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
2350771 2350771 PRJNA382357_P_NODE_66382_length_290_cov_0.934498_g65643_i0 PRJNA382357 66382 290 0.934498 2.7100442 Montipora 46703 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2812165377|ref|XM_068895515.1| 246305 g65643 i0 100 0.2 29 0 10 0 223 251 2098 2126 PREDICTED: Montipora capricornis NFX1-type zinc finger-containing protein 1-like (LOC138049299), mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
4903162 4903162 PRJNA382357_P_NODE_4684_length_905_cov_10.031991_g4079_i0 PRJNA382357 4684 905 10.031991 90.78951855 Anthoathecata 406427 Cnidaria other_Eukaryota 355 6.22e-93   NTclustered gi|429474262|gb|JQ410732.1| 13093 g4079 i0 82.227 80.4939226519337 422 66 79 8 345 763 1296 881 Hydractinia symbiolongicarpus isolate 075 28S ribosomal RNA gene, partial sequence blastn 72847 355 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
14433350 14433350 PRJNA382357_P_NODE_8872_length_691_cov_4.173016_g8184_i0 PRJNA382357 8872 691 4.173016 28.83554056 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 294 1.04e-74   NTclustered gi|2782938510|ref|XM_067075511.1| 252671 g8184 i0 83.077 10.0332850940666 325 53 47 2 351 674 516 193 PREDICTED: Clytia hemisphaerica small ribosomal subunit protein uS12 (LOC136819280), mRNA blastn 6933 294 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
15704997 15704997 PRJNA382357_P_NODE_10053_length_657_cov_2.392617_g9354_i0 PRJNA382357 10053 657 2.392617 15.71949369 Anemonia sulcata 6108 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g9354 i0 89.362 0.143074581430746 47 4 7 1 72 117 3974251 3974205 Anemonia sulcata genome assembly, chromosome: 14 blastn 94 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
15707454 15707454 PRJNA382357_P_NODE_97633_length_245_cov_0.815217_g96894_i0 PRJNA382357 97633 245 0.815217 1.99728165 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2729067314|ref|XM_065195609.1| 499914 g96894 i0 100 0.114285714285714 28 0 11 0 218 245 968 995 PREDICTED: Rhopilema esculentum kinesin-like protein KIF26B (LOC135681242), transcript variant X19, mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
16980660 16980660 PRJNA382357_P_NODE_16934_length_529_cov_12.480769_g16204_i0 PRJNA382357 16934 529 12.480769 66.02326801 Podocoryna carnea 6096 Cnidaria other_Eukaryota 329 2.14e-85   NTclustered gi|396251|emb|X71384.1| 6096 g16204 i0 81.22 23.6465028355388 410 75 77 2 98 506 502 94 P.carnea mRNA for 40S ribosomal protein S14 blastn 12509 329 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Podocoryna Podocoryna carnea
19529851 19529851 PRJNA382357_P_NODE_54936_length_315_cov_1.346457_g54197_i0 PRJNA382357 54936 315 1.346457 4.24133955 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 63.9 1.36e-5   NTclustered gi|2202624871|ref|XM_046990186.1| 2897299 g54197 i0 86.207 1.2952380952381 58 8 18 0 257 314 562 505 PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124439902 (LOC124439902), mRNA blastn 408 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
22079223 22079223 PRJNA382357_P_NODE_127078_length_217_cov_1.243590_g126339_i0 PRJNA382357 127078 217 1.24359 2.6985903 Hydra vulgaris 6087 Cnidaria other_Eukaryota 139 1.43e-28   NTclustered gi|2744820503|ref|XM_047270913.2| 6087 g126339 i0 86.614 23.258064516129 127 15 58 2 55 180 877 752 PREDICTED: Hydra vulgaris E3 ubiquitin ligase Rnf121 (LOC100200846), transcript variant X1, mRNA blastn 5047 139 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
22079730 22079730 PRJNA382357_P_NODE_163598_length_189_cov_4.226562_g162859_i0 PRJNA382357 163598 189 4.226562 7.98820218 Eunicella cavolini 317547 Cnidaria other_Eukaryota 54.7 0.005   NTclustered gi|2918369553|emb|OZ237725.1| 317547 g162859 i0 96.875 0.169312169312169 32 1 17 0 131 162 7590371 7590402 Eunicella cavolini genome assembly, chromosome: 9 blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
22080810 22080810 PRJNA382357_P_NODE_72698_length_278_cov_2.285714_g71959_i0 PRJNA382357 72698 278 2.285714 6.35428492 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g71959 i0 94.286 0.12589928057554 35 2 13 0 130 164 2347584 2347550 Anemonia sulcata genome assembly, chromosome: 1 blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
22080950 22080950 PRJNA382357_P_NODE_80738_length_266_cov_1.048780_g79999_i0 PRJNA382357 80738 266 1.04878 2.7897548 Eunicella cavolini 317547 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2918369552|emb|OZ237724.1| 317547 g79999 i0 100 0.327067669172932 30 0 11 0 184 213 16199093 16199064 Eunicella cavolini genome assembly, chromosome: 8 blastn 87 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
23356313 23356313 PRJNA382357_P_NODE_65659_length_291_cov_1.956522_g64920_i0 PRJNA382357 65659 291 1.956522 5.69347902 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|1619653278|ref|XM_028659904.1| 2652724 g64920 i0 100 0.0996563573883162 29 0 10 0 58 86 2753 2781 PREDICTED: Exaiptasia diaphana mucin-5AC (LOC110241839), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
24629997 24629997 PRJNA382357_P_NODE_33740_length_390_cov_39.680851_g33001_i0 PRJNA382357 33740 390 39.680851 154.7553189 Pocillopora damicornis 46731 Cnidaria other_Eukaryota 191 7.57e-44   NTclustered gi|2814122871|gb|PQ434673.1| 46731 g33001 i0 91.489 64.2923076923077 141 9 67 3 251 390 1508 1646 Pocillopora damicornis clone PD6 small subunit ribosomal RNA gene, partial sequence blastn 25074 191 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis

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