RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA853194" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA853194 · 3 ✖

analysis 1

  • diamond · 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
15262462 15262462 PRJNA853194_S_NODE_26652_length_399_cov_19.812883_g25561_i0 PRJNA853194 26652 399 19.812883 79.05340317 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 58.9 3.65e-7   NR KAF4676629.1 330153 g25561 i0 53.1 0.368421052631579 49 22 36.8 1 131 277 24 71 KAF4676629.1 hypothetical protein FOL47_005782 [Perkinsus chesapeaki] diamond 147 58.9 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
26801759 26801759 PRJNA853194_S_NODE_74061_length_255_cov_1.532967_g72970_i0 PRJNA853194 74061 255 1.532967 3.90906585 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.71e-7   NR XP_002777239.1 423536 g72970 i0 38.3 2.21176470588235 94 45 95.3 3 8 250 153 246 XP_002777239.1 Transposable element Tc3 transposase, putative [Perkinsus marinus ATCC 50983] diamond 564 57.4 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
30528846 30528846 PRJNA853194_S_NODE_15553_length_495_cov_8.611374_g14465_i0 PRJNA853194 15553 495 8.611374 42.6263013 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 65.1 9.01e-9   NR KAF4691065.1 32597 g14465 i0 37.5 0.915151515151515 88 52 53.3 1 104 367 287 371 KAF4691065.1 Vacuolar protein sorting-associated protein 52 [Perkinsus olseni] diamond 453 65.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni

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