RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA631119 · 18 ✖

analysis 1

  • blastn · 18 ✖
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
1151834 1151834 PRJNA631119_P_NODE_20661_length_293_cov_2.095455_g20543_i0 PRJNA631119 20661 293 2.095455 6.13968315 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.4 5.84e-4   NTclustered gi|2917940735|emb|OZ237565.1| 6108 g20543 i0 100 1.81569965870307 31 0 11 0 1 31 8531687 8531717 Anemonia sulcata genome assembly, chromosome: 11 blastn 532 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
1879374 1879374 PRJNA631119_P_NODE_23382_length_280_cov_2.231884_g23264_i0 PRJNA631119 23382 280 2.231884 6.2492752 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 198 3.13e-46   NTclustered gi|1778062832|ref|XM_031712947.1| 6105 g23264 i0 81.857 60.8714285714286 237 41 84 2 24 259 403 168 PREDICTED: Actinia tenebrosa ras-related C3 botulinum toxin substrate 1 (LOC116303415), mRNA blastn 17044 198 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
1879501 1879501 PRJNA631119_P_NODE_9662_length_388_cov_1.250794_g9544_i0 PRJNA631119 9662 388 1.250794 4.85308072 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 2.21e-4   NTclustered gi|2917940745|emb|OZ237569.1| 6108 g9544 i0 94.872 0.881443298969072 39 0 10 2 15 53 2086870 2086834 Anemonia sulcata genome assembly, chromosome: 15 blastn 342 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
3154016 3154016 PRJNA631119_P_NODE_12583_length_351_cov_2.280576_g12465_i0 PRJNA631119 12583 351 2.280576 8.00482176 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 195 5.21e-45   NTclustered gi|2782838984|ref|XM_067054804.1| 252671 g12465 i0 83.981 32.5868945868946 206 29 58 4 148 351 315 112 PREDICTED: Clytia hemisphaerica large ribosomal subunit protein uL15-like (LOC136798225), mRNA blastn 11438 195 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
4431040 4431040 PRJNA631119_P_NODE_5924_length_471_cov_2.673367_g5806_i0 PRJNA631119 5924 471 2.673367 12.59155857 Podocoryna carnea 6096 Cnidaria other_Eukaryota 241 9.11e-59   NTclustered gi|396251|emb|X71384.1| 6096 g5806 i0 78.378 54.4267515923567 370 80 79 0 2 371 493 124 P.carnea mRNA for 40S ribosomal protein S14 blastn 25635 241 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Podocoryna Podocoryna carnea
5706756 5706756 PRJNA631119_P_NODE_15105_length_329_cov_1.414062_g14987_i0 PRJNA631119 15105 329 1.414062 4.65226398 Anemonia sulcata 6108 Cnidaria other_Eukaryota 65.8 3.98e-6   NTclustered gi|2917940703|emb|OZ237559.1| 6108 g14987 i0 100 1.22188449848024 35 0 11 0 105 139 16343833 16343799 Anemonia sulcata genome assembly, chromosome: 5 blastn 402 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
6981671 6981671 PRJNA631119_P_NODE_27606_length_262_cov_2.407407_g27488_i0 PRJNA631119 27606 262 2.407407 6.30740634 Hydra vulgaris 6087 Cnidaria other_Eukaryota 176 1.36e-39   NTclustered gi|2744862703|ref|XM_065798250.1| 6087 g27488 i0 79.681 35.4312977099237 251 45 95 5 15 262 452 205 PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X2, mRNA blastn 9283 176 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
6981680 6981680 PRJNA631119_P_NODE_28986_length_257_cov_1.673913_g28868_i0 PRJNA631119 28986 257 1.673913 4.30195641 Anemonia sulcata 6108 Cnidaria other_Eukaryota 58.4 5.02e-4   NTclustered gi|2917940735|emb|OZ237565.1| 6108 g28868 i0 97.059 0.365758754863813 34 1 13 0 1 34 8531708 8531675 Anemonia sulcata genome assembly, chromosome: 11 blastn 94 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
6981695 6981695 PRJNA631119_P_NODE_32066_length_250_cov_0.870056_g31948_i0 PRJNA631119 32066 250 0.870056 2.17514 Anemonia sulcata 6108 Cnidaria other_Eukaryota 71.3 6.25e-8   NTclustered gi|2917940714|emb|OZ237561.1| 6108 g31948 i0 88.136 22.768 59 7 24 0 1 59 2481890 2481832 Anemonia sulcata genome assembly, chromosome: 7 blastn 5692 71.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
8256483 8256483 PRJNA631119_P_NODE_7887_length_420_cov_8.103746_g7769_i0 PRJNA631119 7887 420 8.103746 34.0357332 Eunicella cavolini 317547 Cnidaria other_Eukaryota 207 8.15e-49   NTclustered gi|2918369552|emb|OZ237724.1| 317547 g7769 i0 82.627 4.72380952380952 236 39 56 2 86 320 197853 198087 Eunicella cavolini genome assembly, chromosome: 8 blastn 1984 207 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
13357531 13357531 PRJNA631119_P_NODE_8211_length_414_cov_1.495601_g8093_i0 PRJNA631119 8211 414 1.495601 6.19178814 Hydra vulgaris 6087 Cnidaria other_Eukaryota 259 2.1800000000000003e-64   NTclustered gi|2744808636|ref|XM_012705840.3| 6087 g8093 i0 79.733 22.6666666666667 375 62 89 12 45 412 597 230 PREDICTED: Hydra vulgaris ras-related protein ORAB-1 (LOC100200826), transcript variant X1, mRNA blastn 9384 259 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
13905804 13905804 PRJNA631119_P_NODE_28111_length_260_cov_2.529412_g27993_i0 PRJNA631119 28111 260 2.529412 6.5764712 Pocillopora 46730 Cnidaria other_Eukaryota 62.1 3.94e-5   NTclustered gi|1524852042|ref|XM_027183588.1| 46731 g27993 i0 94.872 0.407692307692308 39 2 15 0 221 259 934 896 PREDICTED: Pocillopora damicornis serine/threonine-protein phosphatase PP1-beta catalytic subunit (LOC113667728), mRNA blastn 106 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
15906139 15906139 PRJNA631119_P_NODE_4333_length_536_cov_4.520518_g4218_i0 PRJNA631119 4333 536 4.520518 24.22997648 Eunicella cavolini 317547 Cnidaria other_Eukaryota 60.2 3.15e-4   NTclustered gi|2918369537|emb|OZ237719.1| 317547 g4218 i0 94.737 3.6660447761194 38 2 7 0 397 434 30561421 30561458 Eunicella cavolini genome assembly, chromosome: 3 blastn 1965 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
16454650 16454650 PRJNA631119_P_NODE_29393_length_256_cov_1.393443_g29275_i0 PRJNA631119 29393 256 1.393443 3.56721408 Metazoa 33208 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2917940740|emb|OZ237567.1| 6108 g29275 i0 94.286 0.9296875 35 2 14 0 1 35 11328050 11328084 Anemonia sulcata genome assembly, chromosome: 13 blastn 238 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
18455207 18455207 PRJNA631119_P_NODE_12635_length_351_cov_1.251799_g12517_i0 PRJNA631119 12635 351 1.251799 4.39381449 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 54.7 0.009   NTclustered gi|1603823984|ref|XM_028560689.1| 151771 g12517 i0 100 0.0826210826210826 29 0 8 0 157 185 1655 1627 PREDICTED: Dendronephthya gigantea paired mesoderm homeobox protein 1-like (LOC114540569), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
22829234 22829234 PRJNA631119_P_NODE_16278_length_320_cov_1.465587_g16160_i0 PRJNA631119 16278 320 1.465587 4.6898784 Montipora 46703 Cnidaria other_Eukaryota 52.8 0.03   NTclustered gi|2812161973|ref|XM_068893891.1| 246305 g16160 i0 100 0.175 28 0 9 0 31 58 440 467 PREDICTED: Montipora capricornis uncharacterized protein (LOC138047163), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
24829567 24829567 PRJNA631119_P_NODE_39640_length_240_cov_3.089820_g39522_i0 PRJNA631119 39640 240 3.08982 7.415568 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940766|emb|OZ237573.1| 6108 g39522 i0 100 1.25416666666667 30 0 13 0 23 52 11609381 11609410 Anemonia sulcata genome assembly, chromosome: 19 blastn 301 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
25378201 25378201 PRJNA631119_P_NODE_16340_length_319_cov_2.731707_g16222_i0 PRJNA631119 16340 319 2.731707 8.71414533 root 1 Root_unresolved Root_unresolved 54.7 0.008   NTclustered gi|1603783561|ref|XM_028539267.1| 151771 g16222 i0 92.308 1.93416927899687 39 2 12 1 153 190 2677 2715 PREDICTED: Dendronephthya gigantea uncharacterized LOC114519182 (LOC114519182), mRNA blastn 617 54.7 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);;