RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA896554" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA896554 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
30435123 30435123 PRJNA896554_P_NODE_93013_length_351_cov_1.320144_g85473_i0 PRJNA896554 93013 351 1.320144 4.63370544 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.49e-6   NR KAF4657987.1 32597 g85473 i0 38.3 0.512820512820513 60 36 51.3 1 338 159 1884 1942 KAF4657987.1 hypothetical protein FOZ61_005898 [Perkinsus olseni] diamond 180 56.2 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31888846 31888846 PRJNA896554_P_NODE_41497_length_849_cov_1.275773_g34434_i0 PRJNA896554 41497 849 1.275773 10.83131277 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 56.6 6.37e-5   NR XP_002777075.1 423536 g34434 i0 41.2 0.180212014134276 51 30 18 0 39 191 630 680 XP_002777075.1 neurogenic locus notch, putative [Perkinsus marinus ATCC 50983] diamond 153 56.6 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
32149908 32149908 PRJNA896554_P_NODE_53598_length_615_cov_4.223247_g46133_i0 PRJNA896554 53598 615 4.223247 25.97296905 Xanthophyceae 2833 SAR_Eukaryotes SAR_Eukaryotes 108 8.6e-26   NR KAF4744194.1 32597 g46133 i0 53.3 2.37073170731707 122 42 59 3 2 364 62 169 KAF4744194.1 70-kilodalton heat shock protein, partial [Perkinsus olseni] diamond 1458 108 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
32205398 32205398 PRJNA896554_P_NODE_161218_length_246_cov_2.080925_g153678_i0 PRJNA896554 161218 246 2.080925 5.1190755 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 129 7.38e-36   NR XP_002778466.1 423536 g153678 i0 76.5 0.98780487804878 81 19 98.8 0 2 244 62 142 XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] diamond 243 129 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus

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