RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA527965", 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

  • PRJNA527965 · 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
3047935 3047935 PRJNA527965_S_NODE_63_length_1042_cov_60.149950_g40_i0 PRJNA527965 63 1042 60.14995 626.762479 Halecium muricatum 308658 Cnidaria other_Eukaryota 137 2.8400000000000003e-27   NTclustered gi|256674504|gb|FJ550408.1| 308658 g40 i0 79.167 5.24856046065259 216 31 20 10 832 1042 1511 1305 Halecium muricatum voucher MHNG INVE29028 28S ribosomal RNA gene, partial sequence blastn 5469 137 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Haleciidae Halecium Halecium muricatum
6874533 6874533 PRJNA527965_S_NODE_2986_length_221_cov_2.344086_g2903_i0 PRJNA527965 2986 221 2.344086 5.18043006 Symplectoscyphus tricuspidatus 308614 Cnidaria other_Eukaryota 126 1.1399999999999999e-24   NTclustered gi|1006165264|gb|KT190774.1| 308614 g2903 i0 79.167 6.44796380090498 192 33 85 7 1 188 2350 2538 Symplectoscyphus tricuspidatus voucher MBM240558 clone STNB12P212-1, P213-1 28S ribosomal RNA gene, partial sequence blastn 1425 126 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Sertulariidae Symplectoscyphus Symplectoscyphus tricuspidatus
20240800 20240800 PRJNA527965_S_NODE_4696_length_173_cov_1.666667_g4613_i0 PRJNA527965 4696 173 1.666667 2.88333391 Chrysogorgiidae 44200 Cnidaria other_Eukaryota 65.8 1.87e-6   NTclustered gi|2689317345|gb|PP410768.1| 359998 g4613 i0 93.182 1.97687861271676 44 3 25 0 126 169 3537 3580 Metallogorgia melanotrichos voucher USNM:1660629 large subunit ribosomal RNA gene, partial sequence blastn 342 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleralcyonacea Chrysogorgiidae Metallogorgia Metallogorgia melanotrichos

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