RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1247234 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
4178521 4178521 PRJNA1247234_P_NODE_14264_length_296_cov_1.399103_g14108_i0 PRJNA1247234 14264 296 1.399103 4.14134488 Unicauda fimbrethilae 1720082 Cnidaria other_Eukaryota 67.6 9.82e-7   NTclustered gi|2089706636|gb|OK030695.1| 1720082 g14108 i0 97.436 7.16216216216216 39 1 13 0 258 296 1938 1976 Unicauda fimbrethilae large subunit ribosomal RNA gene, partial sequence blastn 2120 67.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Unicauda Unicauda fimbrethilae
5454810 5454810 PRJNA1247234_P_NODE_17205_length_273_cov_1.905000_g17049_i0 PRJNA1247234 17205 273 1.905 5.20065 Henneguya salminicola 69463 Cnidaria other_Eukaryota 152 2.3999999999999999e-32   NTclustered gi|2663986575|emb|OY756916.1| 69463 g17049 i0 94 27.3589743589744 100 6 37 0 9 108 6547 6646 Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences blastn 7469 152 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Henneguya Henneguya salminicola
6729449 6729449 PRJNA1247234_P_NODE_9606_length_347_cov_1.693431_g9450_i0 PRJNA1247234 9606 347 1.693431 5.87620557 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 641 1.5299999999999996e-179   NTclustered gi|681870004|gb|KM001687.1| 1542451 g9450 i0 100 7.19596541786744 347 0 100 0 1 347 1185 1531 Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence blastn 2497 641 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri
15654575 15654575 PRJNA1247234_P_NODE_28153_length_237_cov_2.329268_g27997_i0 PRJNA1247234 28153 237 2.329268 5.52036516 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 438 1.4e-118   NTclustered gi|681870004|gb|KM001687.1| 1542451 g27997 i0 100 93.1476793248945 237 0 100 0 1 237 2532 2296 Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence blastn 22076 438 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri

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