RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJEB39643" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB39643 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
6435936 6435936 PRJEB39643_P_NODE_159746_length_202_cov_4.775194_g159552_i0 PRJEB39643 159746 202 4.775194 9.64589188 Acropora formosa 126732 Cnidaria other_Eukaryota 82.4 2.24e-11   NTclustered gi|692518457|gb|KJ648506.1| 126732 g159552 i0 86.667 37.0693069306931 75 8 37 2 3 76 393 466 Acropora formosa isolate HN14 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 7488 82.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora formosa
6436149 6436149 PRJEB39643_P_NODE_32926_length_323_cov_3.080000_g32733_i0 PRJEB39643 32926 323 3.08 9.9484 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 87.9 8.31e-13   NTclustered gi|1778067270|ref|XM_031715293.1| 6105 g32733 i0 86.42 1.42414860681115 81 10 25 1 18 98 676 597 PREDICTED: Actinia tenebrosa thioredoxin reductase 1, cytoplasmic-like (LOC116305390), mRNA blastn 460 87.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
6436791 6436791 PRJEB39643_P_NODE_94726_length_264_cov_1.612565_g94533_i0 PRJEB39643 94726 264 1.612565 4.2571716 Orbicella faveolata 48498 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|1176121097|ref|XM_020776188.1| 48498 g94533 i0 100 0.215909090909091 29 0 11 0 152 180 529 501 PREDICTED: Orbicella faveolata probable peptide chain release factor C12orf65 homolog, mitochondrial (LOC110068781), mRNA blastn 57 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
11536171 11536171 PRJEB39643_P_NODE_35050_length_314_cov_8.265560_g34857_i0 PRJEB39643 35050 314 8.26556 25.9538584 Silicularia rosea 314502 Cnidaria other_Eukaryota 193 1.66e-44   NTclustered gi|62825399|gb|AY789836.1| 314502 g34857 i0 78.247 5.56687898089172 308 59 97 8 11 314 1 304 Silicularia rosea voucher 152NZ calmodulin gene, partial cds blastn 1748 193 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Campanulariidae Silicularia Silicularia rosea
12811345 12811345 PRJEB39643_P_NODE_24691_length_367_cov_2.724490_g24498_i0 PRJEB39643 24691 367 2.72449 9.9988783 Montipora capricornis 246305 Cnidaria other_Eukaryota 52.8 0.035   NTclustered gi|2812118490|ref|XM_068872074.1| 246305 g24498 i0 100 0.0762942779291553 28 0 8 0 330 357 599 626 PREDICTED: Montipora capricornis sphingomyelinase phosphodiesterase D-like (LOC138024883), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
12811640 12811640 PRJEB39643_P_NODE_5011_length_933_cov_12.334884_g4879_i0 PRJEB39643 5011 933 12.334884 115.08446772 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.007   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g4879 i0 100 0.0632368703108253 30 0 3 0 646 675 21636077 21636106 Anemonia sulcata genome assembly, chromosome: 2 blastn 59 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
12811908 12811908 PRJEB39643_P_NODE_7711_length_732_cov_78.350531_g7543_i0 PRJEB39643 7711 732 78.350531 573.52588692 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 4.38e-4   NTclustered gi|2917940759|emb|OZ237572.1| 6108 g7543 i0 97.143 0.176229508196721 35 1 5 0 519 553 762103 762069 Anemonia sulcata genome assembly, chromosome: 18 blastn 129 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
20116121 20116121 PRJEB39643_P_NODE_7956_length_719_cov_3.171827_g7786_i0 PRJEB39643 7956 719 3.171827 22.80543613 Metazoa 33208 Cnidaria other_Eukaryota 56.5 0.006   NTclustered gi|2917940701|emb|OZ237558.1| 6108 g7786 i0 96.97 0.372739916550765 33 1 5 0 52 84 7199273 7199305 Anemonia sulcata genome assembly, chromosome: 4 blastn 268 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
21734592 21734592 PRJEB39643_P_NODE_28378_length_345_cov_1.981618_g28185_i0 PRJEB39643 28378 345 1.981618 6.8365821 Anemonia sulcata 6108 Cnidaria other_Eukaryota 63.9 1.51e-5   NTclustered gi|2917940735|emb|OZ237565.1| 6108 g28185 i0 100 0.51304347826087 34 0 10 0 84 117 13194280 13194313 Anemonia sulcata genome assembly, chromosome: 11 blastn 177 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23010116 23010116 PRJEB39643_P_NODE_47659_length_287_cov_1.953271_g47466_i0 PRJEB39643 47659 287 1.953271 5.60588777 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.007   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g47466 i0 100 0.101045296167247 29 0 10 0 10 38 21626767 21626739 Anemonia sulcata genome assembly, chromosome: 2 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
25215431 25215431 PRJEB39643_P_NODE_11200_length_580_cov_2.043393_g11013_i0 PRJEB39643 11200 580 2.043393 11.8516794 Montipora 46703 Cnidaria other_Eukaryota 73.1 4.4e-8   NTclustered gi|2812107742|ref|XM_068866392.1| 246305 g11013 i0 80.612 0.86551724137931 98 15 17 4 65 160 779 874 PREDICTED: Montipora capricornis vacuolar protein sorting-associated protein 4B-like (LOC138019550), mRNA blastn 502 73.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis

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