RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA492406 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
452741 452741 PRJNA492406_P_NODE_32261_length_240_cov_2.323353_g31962_i0 PRJNA492406 32261 240 2.323353 5.5760472 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 58.4 4.64e-4   NTclustered gi|2729072214|ref|XM_065198259.1| 499914 g31962 i0 100 0.129166666666667 31 0 13 0 17 47 1907 1877 PREDICTED: Rhopilema esculentum huntingtin-interacting protein 1-like (LOC135683099), mRNA blastn 31 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
3002908 3002908 PRJNA492406_P_NODE_10663_length_378_cov_1.947541_g10364_i0 PRJNA492406 10663 378 1.947541 7.36170498 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 617 2.83e-172   NTclustered gi|681870004|gb|KM001687.1| 1542451 g10364 i0 99.704 42.531746031746 338 0 89 1 1 338 337 1 Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence blastn 16077 617 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri
6830341 6830341 PRJNA492406_P_NODE_6566_length_469_cov_2.818182_g6267_i0 PRJNA492406 6566 469 2.818182 13.21727358 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 861 0   NTclustered gi|681870004|gb|KM001687.1| 1542451 g6267 i0 99.787 6.62473347547974 469 1 100 0 1 469 1531 1063 Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence blastn 3107 861 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri
9380473 9380473 PRJNA492406_P_NODE_28668_length_247_cov_0.885057_g28369_i0 PRJNA492406 28668 247 0.885057 2.18609079 Eunicea flexuosa 437162 Cnidaria other_Eukaryota 87.9 6.12e-13   NTclustered gi|2689317196|gb|PP410695.1| 437162 g28369 i0 88 0.607287449392713 75 5 30 4 174 247 2068 2139 Eunicea flexuosa voucher USNM:1606843 large subunit ribosomal RNA gene, partial sequence blastn 150 87.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Eunicea Eunicea flexuosa
15127277 15127277 PRJNA492406_P_NODE_24792_length_259_cov_16.736559_g24493_i0 PRJNA492406 24792 259 16.736559 43.34768781 Cnidaria 6073 Cnidaria other_Eukaryota 78.7 3.89e-10   NTclustered gi|167507753|gb|EU262856.1| 44304 g24493 i0 100 16.1853281853282 42 0 16 0 218 259 151 192 Favia fragum isolate 164 28S large subunit ribosomal RNA gene, partial sequence blastn 4192 78.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Mussidae Favia Favia fragum
17029503 17029503 PRJNA492406_P_NODE_12034_length_358_cov_9.136842_g11735_i0 PRJNA492406 12034 358 9.136842 32.70989436 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 662 0   NTclustered gi|681870001|gb|KM001684.1| 1542451 g11735 i0 100 17.0083798882682 358 0 100 0 1 358 1964 2321 Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence blastn 6089 662 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri
17676952 17676952 PRJNA492406_P_NODE_3054_length_689_cov_22.543831_g2765_i0 PRJNA492406 3054 689 22.543831 155.32699559 Myxobolus 35588 Cnidaria other_Eukaryota 215 8.29e-51   NTclustered gi|1896054819|gb|MT919695.1| 2766936 g2765 i0 74.923 25.4484760522496 646 75 92 47 59 689 400 973 Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence blastn 17534 215 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Myxobolus Myxobolus cloutmani

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