RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA745553 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
2474033 2474033 PRJNA745553_S_NODE_19802_length_278_cov_1.434146_g19607_i0 PRJNA745553 19802 278 1.434146 3.98692588 Demospongiae 6042 Porifera other_Eukaryota 172 1.8799999999999998e-38   NTclustered gi|512765266|gb|KC869504.1| 283510 g19607 i0 88.811 47.6762589928058 143 12 50 4 59 198 1999 2140 Spirastrella hartmani voucher P21 28S ribosomal RNA gene, partial sequence blastn 13254 172 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Clionaida Spirastrellidae Spirastrella Spirastrella hartmani
22876167 22876167 PRJNA745553_S_NODE_20058_length_276_cov_2.216749_g19863_i0 PRJNA745553 20058 276 2.216749 6.11822724 Metazoa 33208 Porifera other_Eukaryota 171 6.72e-38   NTclustered gi|54639914|gb|AY626288.1| 297660 g19863 i0 82.323 71.1739130434783 198 32 71 3 77 273 778 973 Cliona sp. UCMPWC1066 28S ribosomal RNA gene, partial sequence blastn 19644 172 0.994186046511628 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Clionaida Clionaidae Cliona Cliona sp. UCMPWC1066

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