RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1067370 · 22 ✖

analysis 1

  • blastn · 22 ✖
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
181107 181107 PRJNA1067370_P_NODE_7441_length_656_cov_14.101201_g6919_i0 PRJNA1067370 7441 656 14.101201 92.50387856 Hydra vulgaris 6087 Cnidaria other_Eukaryota 305 4.54e-78   NTclustered gi|2744794010|ref|XM_012698561.3| 6087 g6919 i0 81.432 14.7713414634146 377 66 57 4 160 534 591 217 PREDICTED: Hydra vulgaris small ribosomal subunit protein uS11 (LOC100201565), transcript variant X1, mRNA blastn 9690 305 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
1013383 1013383 PRJNA1067370_P_NODE_97981_length_246_cov_0.890173_g97432_i0 PRJNA1067370 97981 246 0.890173 2.18982558 Acropora 6127 Cnidaria other_Eukaryota 99 2.81e-16   NTclustered gi|2113791169|ref|XM_029334382.2| 45264 g97432 i0 80.451 7.54471544715447 133 22 53 4 1 131 1442 1572 PREDICTED: Acropora millepora putative adenosylhomocysteinase 3 (LOC114957064), transcript variant X1, mRNA blastn 1856 99 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
1455698 1455698 PRJNA1067370_P_NODE_66362_length_270_cov_1.502538_g65813_i0 PRJNA1067370 66362 270 1.502538 4.0568526 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2917940703|emb|OZ237559.1| 6108 g65813 i0 94.286 0.7 35 2 13 0 120 154 16498891 16498925 Anemonia sulcata genome assembly, chromosome: 5 blastn 189 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
2731517 2731517 PRJNA1067370_P_NODE_64083_length_274_cov_0.815920_g63534_i0 PRJNA1067370 64083 274 0.81592 2.2356208 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.025   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g63534 i0 100 0.102189781021898 28 0 10 0 36 63 3475102 3475075 Anemonia sulcata genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
4007535 4007535 PRJNA1067370_P_NODE_73644_length_259_cov_1.623656_g73095_i0 PRJNA1067370 73644 259 1.623656 4.20526904 Stylophora pistillata 50429 Cnidaria other_Eukaryota 178 3.73e-40   NTclustered gi|1270064662|ref|XM_022939253.1| 50429 g73095 i0 79.231 95.1235521235521 260 50 99 4 2 259 1953 1696 PREDICTED: Stylophora pistillata dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3A (LOC111333632), mRNA blastn 24637 178 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
7833155 7833155 PRJNA1067370_P_NODE_108127_length_243_cov_0.905882_g107578_i0 PRJNA1067370 108127 243 0.905882 2.20129326 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g107578 i0 100 0.11522633744856 28 0 12 0 150 177 21551997 21552024 Anemonia sulcata genome assembly, chromosome: 2 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
7833722 7833722 PRJNA1067370_P_NODE_8907_length_606_cov_1.988743_g8377_i0 PRJNA1067370 8907 606 1.988743 12.05178258 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 381 6.739999999999999e-101   NTclustered gi|2782931191|ref|XM_067074155.1| 252671 g8377 i0 80.077 78.963696369637 522 96 85 7 30 547 666 149 PREDICTED: Clytia hemisphaerica ADP-ribosylation factor 2 (LOC136817831), mRNA blastn 47852 381 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
10384067 10384067 PRJNA1067370_P_NODE_32029_length_347_cov_1.401460_g31481_i0 PRJNA1067370 32029 347 1.40146 4.8630662 Eunicella cavolini 317547 Cnidaria other_Eukaryota 62.1 5.46e-5   NTclustered gi|2918369535|emb|OZ237717.1| 317547 g31481 i0 87.273 0.15850144092219 55 6 16 1 97 150 21387729 21387783 Eunicella cavolini genome assembly, chromosome: 1 blastn 55 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
10384204 10384204 PRJNA1067370_P_NODE_51509_length_293_cov_1.400000_g50960_i0 PRJNA1067370 51509 293 1.4 4.102 Hydra vulgaris 6087 Cnidaria other_Eukaryota 226 1.5099999999999998e-54   NTclustered gi|2744808319|ref|XM_047276280.2| 6087 g50960 i0 81.429 23.3890784982935 280 48 95 4 3 280 565 288 PREDICTED: Hydra vulgaris ras-related protein Rab-11B (LOC100212746), transcript variant X1, mRNA blastn 6853 226 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
10384213 10384213 PRJNA1067370_P_NODE_52989_length_290_cov_1.594470_g52440_i0 PRJNA1067370 52989 290 1.59447 4.623963 Calycella syringa 314529 Cnidaria other_Eukaryota 122 2.0199999999999994e-23   NTclustered gi|256674468|gb|FJ550372.1| 314529 g52440 i0 86.087 34.651724137931 115 14 39 2 30 143 1567 1454 Calycella syringa 28S ribosomal RNA gene, partial sequence blastn 10049 122 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Campanulariidae Calycella Calycella syringa
14209743 14209743 PRJNA1067370_P_NODE_6952_length_676_cov_3.421227_g6438_i0 PRJNA1067370 6952 676 3.421227 23.12749452 Anemonia sulcata 6108 Cnidaria other_Eukaryota 65.8 8.66e-6   NTclustered gi|2917940744|emb|OZ237568.1| 6108 g6438 i0 95.122 0.113905325443787 41 2 6 0 38 78 10110930 10110890 Anemonia sulcata genome assembly, chromosome: 14 blastn 77 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
16315739 16315739 PRJNA1067370_P_NODE_74033_length_258_cov_5.713514_g73484_i0 PRJNA1067370 74033 258 5.713514 14.74086612 Montipora 46703 Cnidaria other_Eukaryota 56.5 0.002   NTclustered gi|2812143746|ref|XM_068884282.1| 246305 g73484 i0 94.444 0.418604651162791 36 2 14 0 64 99 1994 1959 PREDICTED: Montipora capricornis chromatin assembly factor 1 subunit A-like (LOC138038422), mRNA blastn 108 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
16757924 16757924 PRJNA1067370_P_NODE_65414_length_272_cov_0.804020_g64865_i0 PRJNA1067370 65414 272 0.80402 2.1869344 Hydra vulgaris 6087 Cnidaria other_Eukaryota 276 1.36e-69   NTclustered gi|2744890083|ref|XR_010641937.1| 6087 g64865 i0 85.824 16.6801470588235 261 36 96 1 5 264 377 637 PREDICTED: Hydra vulgaris uncharacterized LOC136087622 (LOC136087622), transcript variant X1, ncRNA blastn 4537 276 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
19306284 19306284 PRJNA1067370_P_NODE_14396_length_486_cov_2.067797_g13849_i0 PRJNA1067370 14396 486 2.067797 10.04949342 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 143 2.73e-29   NTclustered gi|2729080245|ref|XM_065202558.1| 499914 g13849 i0 82.424 4.55349794238683 165 27 34 2 16 179 1377 1540 PREDICTED: Rhopilema esculentum protein transport protein Sec61 subunit alpha (LOC135686348), mRNA blastn 2213 143 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
20582393 20582393 PRJNA1067370_P_NODE_98457_length_246_cov_0.890173_g97908_i0 PRJNA1067370 98457 246 0.890173 2.18982558 Calycella syringa 314529 Cnidaria other_Eukaryota 137 5.96e-28   NTclustered gi|62825485|gb|AY789879.1| 314529 g97908 i0 77.178 16.9959349593496 241 51 97 4 5 243 265 27 Calycella syringa voucher 664MA calmodulin gene, partial cds blastn 4181 137 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Campanulariidae Calycella Calycella syringa
21415269 21415269 PRJNA1067370_P_NODE_48477_length_300_cov_1.105727_g47929_i0 PRJNA1067370 48477 300 1.105727 3.317181 Scleractinia 6125 Cnidaria other_Eukaryota 52.8 0.028   NTclustered gi|1270074434|ref|XM_022944495.1| 50429 g47929 i0 100 0.653333333333333 28 0 9 0 268 295 235 262 PREDICTED: Stylophora pistillata uncharacterized LOC111338080 (LOC111338080), mRNA blastn 196 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
21857755 21857755 PRJNA1067370_P_NODE_53738_length_289_cov_1.425926_g53189_i0 PRJNA1067370 53738 289 1.425926 4.12092614 Pocillopora verrucosa 203993 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2751512817|ref|XM_059085946.2| 203993 g53189 i0 96.875 0.110726643598616 32 1 11 0 51 82 5952 5983 PREDICTED: Pocillopora verrucosa NLR family CARD domain-containing protein 3 (LOC131770231), mRNA blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora verrucosa
22689976 22689976 PRJNA1067370_P_NODE_109338_length_242_cov_1.473373_g108789_i0 PRJNA1067370 109338 242 1.473373 3.56556266 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 54.7 0.006   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g108789 i0 100 0.239669421487603 29 0 12 0 142 170 14068934 14068962 Anemonia sulcata genome assembly, chromosome: 4 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23133062 23133062 PRJNA1067370_P_NODE_26979_length_371_cov_1.013423_g26431_i0 PRJNA1067370 26979 371 1.013423 3.75979933 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 237 9.07e-58   NTclustered gi|1619658217|ref|XM_021048564.2| 2652724 g26431 i0 78.4 29.3989218328841 375 74 100 7 1 371 668 1039 PREDICTED: Exaiptasia diaphana 26S proteasome regulatory subunit 6A-B (LOC110242556), mRNA blastn 10907 237 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
23133203 23133203 PRJNA1067370_P_NODE_47259_length_303_cov_1.347826_g46711_i0 PRJNA1067370 47259 303 1.347826 4.08391278 Hydra vulgaris 6087 Cnidaria other_Eukaryota 243 1.56e-59   NTclustered gi|2744890083|ref|XR_010641937.1| 6087 g46711 i0 83.712 15.2772277227723 264 36 87 4 34 296 637 380 PREDICTED: Hydra vulgaris uncharacterized LOC136087622 (LOC136087622), transcript variant X1, ncRNA blastn 4629 243 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
23133326 23133326 PRJNA1067370_P_NODE_67439_length_268_cov_2.794872_g66890_i0 PRJNA1067370 67439 268 2.794872 7.49025696 Acropora millepora 45264 Cnidaria other_Eukaryota 60.2 1.47e-4   NTclustered gi|2113967914|ref|XM_029327713.2| 45264 g66890 i0 97.143 0.130597014925373 35 1 13 0 35 69 698 732 PREDICTED: Acropora millepora NADH-ubiquinone oxidoreductase 49 kDa subunit-like (LOC114951529), mRNA blastn 35 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
23133444 23133444 PRJNA1067370_P_NODE_86139_length_249_cov_0.875000_g85590_i0 PRJNA1067370 86139 249 0.875 2.17875 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2518947781|ref|XM_057444456.1| 13093 g85590 i0 100 0.72289156626506 28 0 11 0 177 204 670 643 PREDICTED: Hydractinia symbiolongicarpus nephrocystin-1-like (LOC130632197), transcript variant X2, mRNA blastn 180 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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