RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1195374 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
1042871 1042871 PRJNA1195374_P_NODE_63161_length_271_cov_1.555556_g62817_i0 PRJNA1195374 63161 271 1.555556 4.21555676 Metazoa 33208 Cnidaria other_Eukaryota 171 6.58e-38   NTclustered gi|2518975264|ref|XM_057438456.1| 13093 g62817 i0 80.909 12.1033210332103 220 38 80 4 7 224 521 304 PREDICTED: Hydractinia symbiolongicarpus T-complex protein 1 subunit zeta-like (LOC130622986), mRNA blastn 3280 172 0.994186046511628 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
6145766 6145766 PRJNA1195374_P_NODE_71825_length_250_cov_5.158192_g71481_i0 PRJNA1195374 71825 250 5.158192 12.89548 Metazoa 33208 Cnidaria other_Eukaryota 135 2.1900000000000003e-27   NTclustered gi|605060084|gb|KF874224.1| 109801 g71481 i0 86.885 50.6 122 14 49 2 1 122 352 233 Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence blastn 12650 135 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Parvicapsulidae Parvicapsula Parvicapsula minibicornis
6698936 6698936 PRJNA1195374_P_NODE_14946_length_584_cov_1.765166_g14606_i0 PRJNA1195374 14946 584 1.765166 10.30856944 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 163 2.55e-35   NTclustered gi|1619698364|ref|XM_021060348.2| 2652724 g14606 i0 78.346 29.0359589041096 254 53 43 2 113 365 831 1083 PREDICTED: Exaiptasia diaphana electron transfer flavoprotein subunit alpha, mitochondrial (LOC110253437), mRNA blastn 16957 163 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
9249959 9249959 PRJNA1195374_P_NODE_65468_length_265_cov_1.395833_g65124_i0 PRJNA1195374 65468 265 1.395833 3.69895745 Orbicella faveolata 48498 Cnidaria other_Eukaryota 60.2 1.45e-4   NTclustered gi|1176100932|ref|XM_020765523.1| 48498 g65124 i0 97.143 0.132075471698113 35 1 13 0 102 136 60 94 PREDICTED: Orbicella faveolata 26S proteasome complex subunit SEM1-like (LOC110058861), mRNA blastn 35 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
10525797 10525797 PRJNA1195374_P_NODE_66389_length_263_cov_1.100000_g66045_i0 PRJNA1195374 66389 263 1.1 2.893 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g66045 i0 100 0.326996197718631 30 0 11 0 186 215 1643565 1643536 Anemonia sulcata genome assembly, chromosome: 14 blastn 86 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
11245960 11245960 PRJNA1195374_P_NODE_37469_length_366_cov_3.098976_g37125_i0 PRJNA1195374 37469 366 3.098976 11.34225216 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.5 0.003   NTclustered gi|2518989181|ref|XM_057445375.1| 13093 g37125 i0 94.444 1.33333333333333 36 2 10 0 163 198 3486 3451 PREDICTED: Hydractinia symbiolongicarpus cilia- and flagella-associated protein 44-like (LOC130635866), transcript variant X1, mRNA blastn 488 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
11246280 11246280 PRJNA1195374_P_NODE_83709_length_242_cov_0.911243_g83365_i0 PRJNA1195374 83709 242 0.911243 2.20520806 root 1 Root_unresolved Root_unresolved 67.6 7.78e-7   NTclustered gi|2917940696|emb|OZ237557.1| 6108 g83365 i0 100 53.5082644628099 36 0 15 0 167 202 17566370 17566405 Anemonia sulcata genome assembly, chromosome: 3 blastn 12949 67.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
11799951 11799951 PRJNA1195374_P_NODE_31090_length_405_cov_3.774096_g30746_i0 PRJNA1195374 31090 405 3.774096 15.2850888 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 298 4.52e-76   NTclustered gi|2518991437|ref|XM_057446583.1| 13093 g30746 i0 83.333 80.0222222222222 330 47 80 7 3 328 186 511 PREDICTED: Hydractinia symbiolongicarpus ubiquitin-60S ribosomal protein L40 (LOC130636750), mRNA blastn 32409 298 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
15624778 15624778 PRJNA1195374_P_NODE_61973_length_275_cov_0.920792_g61629_i0 PRJNA1195374 61973 275 0.920792 2.532178 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|1778022353|ref|XM_031719386.1| 6105 g61629 i0 89.13 2.61454545454545 46 2 16 3 54 97 2094 2050 PREDICTED: Actinia tenebrosa serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit C-like (LOC116308875), transcript variant X3, mRNA blastn 719 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
18173301 18173301 PRJNA1195374_P_NODE_44995_length_330_cov_1.797665_g44651_i0 PRJNA1195374 44995 330 1.797665 5.9322945 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g44651 i0 94.444 0.109090909090909 36 2 11 0 24 59 4336999 4337034 Anemonia sulcata genome assembly, chromosome: 2 blastn 36 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
21998535 21998535 PRJNA1195374_P_NODE_50438_length_309_cov_1.656780_g50094_i0 PRJNA1195374 50438 309 1.65678 5.1194502 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 226 1.6099999999999998e-54   NTclustered gi|2729060861|ref|XM_065202165.1| 499914 g50094 i0 81.455 17.3171521035599 275 51 89 0 22 296 1020 746 PREDICTED: Rhopilema esculentum serine/threonine-protein phosphatase PP1-beta catalytic subunit (LOC135686017), mRNA blastn 5351 226 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
23274366 23274366 PRJNA1195374_P_NODE_7039_length_810_cov_4.029851_g6741_i0 PRJNA1195374 7039 810 4.029851 32.6417931 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 202 7.639999999999999e-47   NTclustered gi|2782929037|ref|XM_067073665.1| 252671 g6741 i0 77.049 5.2962962962963 366 75 45 8 439 801 1163 804 PREDICTED: Clytia hemisphaerica calreticulin-like (LOC136817322), mRNA blastn 4290 202 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);;