RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1144090 · 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
1033009 1033009 PRJNA1144090_P_NODE_62301_length_321_cov_2.532258_g61766_i0 PRJNA1144090 62301 321 2.532258 8.12854818 root 1 Root_unresolved Root_unresolved 54.7 0.008   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g61766 i0 100 8.84423676012461 29 0 9 0 152 180 27339338 27339366 Anemonia sulcata genome assembly, chromosome: 1 blastn 2839 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
1033026 1033026 PRJNA1144090_P_NODE_71881_length_298_cov_1.875556_g71346_i0 PRJNA1144090 71881 298 1.875556 5.58915688 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.028   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g71346 i0 100 0.563758389261745 28 0 9 0 12 39 17499664 17499637 Anemonia sulcata genome assembly, chromosome: 1 blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
1561862 1561862 PRJNA1144090_P_NODE_35482_length_436_cov_5.201102_g34947_i0 PRJNA1144090 35482 436 5.201102 22.67680472 Orbicella faveolata 48498 Cnidaria other_Eukaryota 52.8 0.042   NTclustered gi|1176089628|ref|XM_020759535.1| 48498 g34947 i0 100 0.128440366972477 28 0 6 0 88 115 822 849 PREDICTED: Orbicella faveolata heterogeneous nuclear ribonucleoprotein K-like (LOC110053319), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
1562197 1562197 PRJNA1144090_P_NODE_6642_length_1108_cov_2.968116_g6306_i0 PRJNA1144090 6642 1108 2.968116 32.88672528 Eunicella cavolini 317547 Cnidaria other_Eukaryota 54.7 0.031   NTclustered gi|2918369537|emb|OZ237719.1| 317547 g6306 i0 100 0.026173285198556 29 0 3 0 267 295 55255105 55255077 Eunicella cavolini genome assembly, chromosome: 3 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
2838337 2838337 PRJNA1144090_P_NODE_62603_length_320_cov_6.028340_g62068_i0 PRJNA1144090 62603 320 6.02834 19.290688 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 281 3.52e-71   NTclustered gi|1778034411|ref|XM_031698677.1| 6105 g62068 i0 85.768 3.25625 267 36 83 2 18 283 383 118 PREDICTED: Actinia tenebrosa RING-box protein 1 (LOC116291507), mRNA blastn 1042 281 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
3583457 3583457 PRJNA1144090_P_NODE_17163_length_664_cov_3.849408_g16647_i0 PRJNA1144090 17163 664 3.849408 25.56006912 Leptothecata 500008 Cnidaria other_Eukaryota 122 4.969999999999999e-23   NTclustered gi|167858092|gb|EU305511.1| 308604 g16647 i0 82.192 12.5481927710843 146 23 22 2 10 153 1577 1721 Diphasia fallax large subunit 28S ribosomal RNA gene, partial sequence blastn 8332 122 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Sertulariidae Diphasia Diphasia fallax
4113963 4113963 PRJNA1144090_P_NODE_117644_length_237_cov_5.335366_g117109_i0 PRJNA1144090 117644 237 5.335366 12.64481742 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 224 4.26e-54   NTclustered gi|2782847677|ref|XM_067056512.1| 252671 g117109 i0 86.473 91.1181434599156 207 25 87 3 17 223 376 579 PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136799805), mRNA blastn 21595 224 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
7940922 7940922 PRJNA1144090_P_NODE_92267_length_261_cov_1.638298_g91732_i0 PRJNA1144090 92267 261 1.638298 4.27595778 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 52.8 0.024   NTclustered gi|2782954686|ref|XM_067079680.1| 252671 g91732 i0 100 0.21455938697318 28 0 11 0 211 238 588 561 PREDICTED: Clytia hemisphaerica uncharacterized protein DDB_G0290587-like (LOC136823492), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
9214956 9214956 PRJNA1144090_P_NODE_115488_length_241_cov_1.827381_g114953_i0 PRJNA1144090 115488 241 1.827381 4.40398821 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2918369535|emb|OZ237717.1| 317547 g114953 i0 100 0.232365145228216 28 0 12 0 174 201 49209330 49209357 Eunicella cavolini genome assembly, chromosome: 1 blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
9215133 9215133 PRJNA1144090_P_NODE_22748_length_564_cov_24.016293_g22221_i0 PRJNA1144090 22748 564 24.016293 135.45189252 Campanularia hincksii 314507 Cnidaria other_Eukaryota 259 3.0500000000000005e-64   NTclustered gi|62825401|gb|AY789837.1| 314507 g22221 i0 78.589 8.02659574468085 397 81 70 4 95 489 395 1 Campanularia hincksii voucher 37IT calmodulin gene, partial cds blastn 4527 259 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Campanulariidae Campanularia Campanularia hincksii
9961116 9961116 PRJNA1144090_P_NODE_15768_length_696_cov_3.926164_g15272_i0 PRJNA1144090 15768 696 3.926164 27.32610144 Metazoa 33208 Cnidaria other_Eukaryota 63.9 3.21e-5   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g15272 i0 95 0.413793103448276 40 2 6 0 362 401 12494333 12494372 Anemonia sulcata genome assembly, chromosome: 6 blastn 288 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
13041080 13041080 PRJNA1144090_P_NODE_49571_length_362_cov_4.470588_g49036_i0 PRJNA1144090 49571 362 4.470588 16.18352856 Montipora capricornis 246305 Cnidaria other_Eukaryota 130 1.54e-25   NTclustered gi|2812184880|ref|XM_068905253.1| 246305 g49036 i0 75.969 17.6022099447514 258 59 71 3 90 346 159 414 PREDICTED: Montipora capricornis histone H2B, gonadal-like (LOC138059638), mRNA blastn 6372 130 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
13786353 13786353 PRJNA1144090_P_NODE_44771_length_383_cov_2.400000_g44236_i0 PRJNA1144090 44771 383 2.4 9.192 Metazoa 33208 Cnidaria other_Eukaryota 311 5.46e-80   NTclustered gi|2782857206|ref|XM_067058063.1| 252671 g44236 i0 81.989 95.9190600522193 372 61 96 5 13 381 86 454 PREDICTED: Clytia hemisphaerica histone H3.3 (LOC136801426), mRNA blastn 36737 313 0.993610223642173 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
18884561 18884561 PRJNA1144090_P_NODE_17035_length_667_cov_1.909091_g16520_i0 PRJNA1144090 17035 667 1.909091 12.73363697 Opisthokonta 33154 Cnidaria other_Eukaryota 60.2 3.97e-4   NTclustered gi|2812171479|ref|XM_068898505.1| 246305 g16520 i0 97.143 1.59220389805097 35 1 5 0 1 35 379 345 PREDICTED: Montipora capricornis uncharacterized protein (LOC138052127), mRNA blastn 1062 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
20159410 20159410 PRJNA1144090_P_NODE_29996_length_481_cov_1.411765_g29462_i0 PRJNA1144090 29996 481 1.411765 6.79058965 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.8 0.047   NTclustered gi|2917940740|emb|OZ237567.1| 6108 g29462 i0 96.774 0.257796257796258 31 1 6 0 402 432 3519621 3519591 Anemonia sulcata genome assembly, chromosome: 13 blastn 124 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23239830 23239830 PRJNA1144090_P_NODE_5739_length_1198_cov_4.888000_g5424_i0 PRJNA1144090 5739 1198 4.888 58.55824 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 56.5 0.009   NTclustered gi|1619682972|ref|XM_021056003.2| 2652724 g5424 i0 88.889 0.0375626043405676 45 5 4 0 849 893 362 406 PREDICTED: Exaiptasia diaphana biogenesis of lysosome-related organelles complex 1 subunit 5 (LOC110249433), mRNA blastn 45 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
23239889 23239889 PRJNA1144090_P_NODE_62499_length_321_cov_1.342742_g61964_i0 PRJNA1144090 62499 321 1.342742 4.31020182 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 200 1.02e-46   NTclustered gi|2782891151|ref|XM_067066273.1| 252671 g61964 i0 78.689 12.6697819314642 305 62 95 3 18 321 497 195 PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136809726), mRNA blastn 4067 200 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
24512966 24512966 PRJNA1144090_P_NODE_19360_length_619_cov_2.653846_g18836_i0 PRJNA1144090 19360 619 2.653846 16.42730674 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.005   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g18836 i0 100 0.0484652665589661 30 0 5 0 216 245 8429539 8429510 Anemonia sulcata genome assembly, chromosome: 4 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata

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