RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA505329", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 3 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 3 ✖

bioproject 1

  • PRJNA505329 · 3 ✖

analysis 1

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
11962206 11962206 PRJNA505329_P_NODE_34670_length_180_cov_2.053435_g34199_i0 PRJNA505329 34670 180 2.053435 3.696183 Hydra oligactis 6088 Cnidaria other_Eukaryota 307 2.9500000000000003e-79   NTclustered gi|1032656003|gb|JN594041.2| 6088 g34199 i0 98.286 52.45 175 3 97 0 4 178 281 455 Hydra oligactis 28S ribosomal RNA gene, partial sequence blastn 9441 307 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra oligactis
18335049 18335049 PRJNA505329_P_NODE_32295_length_184_cov_1.518519_g31824_i0 PRJNA505329 32295 184 1.518519 2.79407496 Bougainvillia sp. PM JRH-2014 1483201 Cnidaria other_Eukaryota 73.1 1.2e-8   NTclustered gi|608606637|gb|KF962312.1| 1483201 g31824 i0 86.567 1.16304347826087 67 8 36 1 3 68 1980 2046 Bougainvillia sp. PM JRH-2014 voucher XMBP5 28S ribosomal RNA gene, partial sequence blastn 214 73.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Bougainvilliidae Bougainvillia Bougainvillia sp. PM JRH-2014
22787285 22787285 PRJNA505329_P_NODE_21678_length_201_cov_2.967105_g21207_i0 PRJNA505329 21678 201 2.967105 5.96388105 Acropora 6127 Cnidaria other_Eukaryota 75 3.73e-9   NTclustered gi|2113824168|ref|XM_029356570.2| 45264 g21207 i0 88.525 0.810945273631841 61 7 30 0 1 61 179 119 PREDICTED: Acropora millepora NEDD8 (LOC114976168), mRNA blastn 163 75 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora

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