RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1041773" 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

  • PRJNA1041773 · 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
4836320 4836320 PRJNA1041773_P_NODE_21844_length_444_cov_235.530997_g21514_i0 PRJNA1041773 21844 444 235.530997 1045.75762668 Siphonophorae 42759 Cnidaria other_Eukaryota 684 0   NTclustered gi|185179262|gb|EU448095.1| 168775 g21514 i0 97.494 89.5382882882883 399 9 90 1 44 442 1539 1936 Physalia physalis 28S large subunit ribosomal RNA gene, partial sequence blastn 39755 684 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Siphonophorae Physaliidae Physalia Physalia physalis
6548702 6548702 PRJNA1041773_P_NODE_67486_length_266_cov_1.984456_g67153_i0 PRJNA1041773 67486 266 1.984456 5.27865296 Muggiaea atlantica 316203 Cnidaria other_Eukaryota 71.3 6.72e-8   NTclustered gi|2041343125|gb|MZ230484.1| 316203 g67153 i0 100 0.428571428571429 38 0 14 0 229 266 621 584 Muggiaea atlantica isolate MA1 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 114 71.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Siphonophorae Diphyidae Muggiaea Muggiaea atlantica
8661807 8661807 PRJNA1041773_P_NODE_76007_length_252_cov_46.128492_g75674_i0 PRJNA1041773 76007 252 46.128492 116.24379984 Diphyidae 168754 Cnidaria other_Eukaryota 412 9.099999999999999e-111   NTclustered gi|166407178|gb|EU272594.1| 316191 g75674 i0 98.298 94.5793650793651 235 4 93 0 3 237 235 1 Sulculeolaria quadrivalvis voucher Yale Peabody Museum No. 35357 28S large subunit ribosomal RNA gene, partial sequence blastn 23834 416 0.990384615384615 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Siphonophorae Diphyidae Sulculeolaria Sulculeolaria quadrivalvis
9097586 9097586 PRJNA1041773_P_NODE_21808_length_445_cov_1.774194_g21478_i0 PRJNA1041773 21808 445 1.774194 7.8951633 Montipora capricornis 246305 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2812114944|ref|XM_068870257.1| 246305 g21478 i0 97.059 1.08314606741573 34 1 8 0 214 247 178 145 PREDICTED: Montipora capricornis nucleolar transcription factor 1-A-like (LOC138023236), mRNA blastn 482 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
9098598 9098598 PRJNA1041773_P_NODE_91048_length_245_cov_0.895349_g90715_i0 PRJNA1041773 91048 245 0.895349 2.19360505 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g90715 i0 100 0.114285714285714 28 0 11 0 20 47 39125712 39125739 Eunicella cavolini genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
10373346 10373346 PRJNA1041773_P_NODE_31049_length_375_cov_4.178808_g30717_i0 PRJNA1041773 31049 375 4.178808 15.67053 Hydra vulgaris 6087 Cnidaria other_Eukaryota 298 4.15e-76   NTclustered gi|2744837714|ref|XM_065786831.1| 6087 g30717 i0 82.84 92.72 338 52 89 5 1 335 28 362 PREDICTED: Hydra vulgaris late histone H2A.2.2 (LOC136074505), mRNA blastn 34770 298 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
10374077 10374077 PRJNA1041773_P_NODE_79969_length_250_cov_0.870056_g79636_i0 PRJNA1041773 79969 250 0.870056 2.17514 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2918369537|emb|OZ237719.1| 317547 g79636 i0 100 0.112 28 0 11 0 158 185 53524377 53524350 Eunicella cavolini genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
11649242 11649242 PRJNA1041773_P_NODE_72430_length_258_cov_1.664865_g72097_i0 PRJNA1041773 72430 258 1.664865 4.2953517 Acropora millepora 45264 Cnidaria other_Eukaryota 87.9 6.44e-13   NTclustered gi|2113718509|ref|XR_006393933.1| 45264 g72097 i0 86.42 1.46124031007752 81 10 31 1 13 92 3326 3246 PREDICTED: Acropora millepora large subunit ribosomal RNA (LOC122955186), rRNA blastn 377 87.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
14199540 14199540 PRJNA1041773_P_NODE_84132_length_248_cov_0.880000_g83799_i0 PRJNA1041773 84132 248 0.88 2.1824 Acropora millepora 45264 Cnidaria other_Eukaryota 62.1 3.73e-5   NTclustered gi|2113916788|ref|XM_044307386.1| 45264 g83799 i0 100 0.266129032258065 33 0 13 0 49 81 10837 10805 PREDICTED: Acropora millepora ubiquitin carboxyl-terminal hydrolase 34-like (LOC114969381), transcript variant X1, mRNA blastn 66 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
16310685 16310685 PRJNA1041773_P_NODE_25273_length_413_cov_28.529412_g24942_i0 PRJNA1041773 25273 413 28.529412 117.82647156 Siphonophorae 42759 Cnidaria other_Eukaryota 745 0   NTclustered gi|167858098|gb|EU305517.1| 168745 g24942 i0 99.274 100.004842615012 413 2 100 1 1 413 2421 2832 Hippopodius hippopus large subunit 28S ribosomal RNA gene, partial sequence blastn 41302 752 0.990691489361702 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Siphonophorae Hippopodiidae Hippopodius Hippopodius hippopus
16747493 16747493 PRJNA1041773_P_NODE_57454_length_285_cov_1.089623_g57121_i0 PRJNA1041773 57454 285 1.089623 3.10542555 Millepora sp. EK-2011 1104536 Cnidaria other_Eukaryota 150 9.08e-32   NTclustered gi|355331580|gb|JN700943.1| 1104536 g57121 i0 80 20.1438596491228 215 33 74 9 5 214 12456 12665 Millepora sp. EK-2011 mitochondrion, partial genome blastn 5741 150 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Milleporidae Millepora Millepora sp. EK-2011
16747682 16747682 PRJNA1041773_P_NODE_70034_length_262_cov_1.624339_g69701_i0 PRJNA1041773 70034 262 1.624339 4.25576818 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.024   NTclustered gi|2917940724|emb|OZ237563.1| 6108 g69701 i0 100 0.106870229007634 28 0 11 0 122 149 12285964 12285937 Anemonia sulcata genome assembly, chromosome: 9 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
18022192 18022192 PRJNA1041773_P_NODE_45215_length_316_cov_3.633745_g44882_i0 PRJNA1041773 45215 316 3.633745 11.4826342 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 167 1.01e-36   NTclustered gi|2729060960|ref|XM_065202733.1| 499914 g44882 i0 78.74 66.246835443038 254 50 79 4 66 316 142 394 PREDICTED: Rhopilema esculentum histone H2B, gonadal (LOC135686485), mRNA blastn 20934 167 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
23123077 23123077 PRJNA1041773_P_NODE_77399_length_251_cov_0.865169_g77066_i0 PRJNA1041773 77399 251 0.865169 2.17157419 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 161 3.62e-35   NTclustered gi|2782869019|ref|XM_067060607.1| 252671 g77066 i0 79.911 4.72908366533865 224 41 88 3 2 223 2082 2303 PREDICTED: Clytia hemisphaerica DNA polymerase delta catalytic subunit-like (LOC136803884), mRNA blastn 1187 161 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
23123162 23123162 PRJNA1041773_P_NODE_83339_length_249_cov_0.869318_g83006_i0 PRJNA1041773 83339 249 0.869318 2.16460182 Eunicella cavolini 317547 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2918369536|emb|OZ237718.1| 317547 g83006 i0 100 0.614457831325301 29 0 12 0 94 122 28573982 28573954 Eunicella cavolini genome assembly, chromosome: 2 blastn 153 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini

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