RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA315314" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA315314 · 3 ✖

tax_kingdom 0

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
6168197 6168197 PRJNA315314_S_NODE_3985_length_400_cov_4.919137_g3664_i0 PRJNA315314 3985 400 4.919137 19.676548 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 152 8.229999999999998e-42   NR KAF4730699.1 32597 g3664 i0 65.9 12.87 132 44 99 1 398 3 213 343 KAF4730699.1 70-kilodalton heat shock protein, partial [Perkinsus olseni] diamond 5148 152 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
22057447 22057447 PRJNA315314_S_NODE_3278_length_440_cov_12.143552_g2958_i0 PRJNA315314 3278 440 12.143552 53.4316288 Xcellia lamelliphila 2759750 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.003   NTclustered gi|2472915981|gb|OP293091.1| 2759750 g2958 i0 96.97 0.075 33 1 8 0 353 385 6356 6324 Xcellia lamelliphila voucher 11/145 external transcribed spacer, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 33 56.5 1 Eukaryota Sar   Perkinsozoa   Perkinsida Xcellidae Xcellia Xcellia lamelliphila
29333938 29333938 PRJNA315314_S_NODE_24769_length_168_cov_2.971223_g24448_i0 PRJNA315314 24769 168 2.971223 4.99165464 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.5300000000000003e-21   NR KAF4674911.1 330153 g24448 i0 76.4 2.94642857142857 55 13 98.2 0 2 166 629 683 KAF4674911.1 hypothetical protein FOL47_008500 [Perkinsus chesapeaki] diamond 495 96.7 0.991726990692865 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki

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