RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA630162 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27681269 27681269 PRJNA630162_P_NODE_152284_length_164_cov_0.904348_g150761_i0 PRJNA630162 152284 164 0.904348 1.48313072 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.68e-6   NR KAF4734972.1 32597 g150761 i0 44.2 1.90243902439024 52 29 95.1 0 7 162 238 289 KAF4734972.1 hypothetical protein FOZ62_007319, partial [Perkinsus olseni] diamond 312 53.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28009559 28009559 PRJNA630162_P_NODE_130245_length_169_cov_2.041667_g128722_i0 PRJNA630162 130245 169 2.041667 3.45041723 root 1 Root_unresolved Root_unresolved 45.4 0.00158   NR KAF4676391.1 330153 g128722 i0 57.1 2.66272189349112 35 15 62.1 0 61 165 606 640 KAF4676391.1 hypothetical protein FOL47_006305 [Perkinsus chesapeaki] diamond 450 45.4 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
28059767 28059767 PRJNA630162_P_NODE_155965_length_163_cov_0.912281_g154442_i0 PRJNA630162 155965 163 0.912281 1.48701803 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00665   NR XP_002772932.1 423536 g154442 i0 38 1.84049079754601 50 31 92 0 158 9 462 511 XP_002772932.1 hypothetical protein Pmar_PMAR013275 [Perkinsus marinus ATCC 50983] diamond 300 43.5 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
31262495 31262495 PRJNA630162_P_NODE_113255_length_178_cov_1.387597_g111732_i0 PRJNA630162 113255 178 1.387597 2.46992266 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 49.3 3.05e-5   NR KAF4701249.1 32597 g111732 i0 53.8 3.9438202247191 39 18 65.7 0 8 124 34 72 KAF4701249.1 hypothetical protein FOZ63_016284, partial [Perkinsus olseni] diamond 702 49.3 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
32546991 32546991 PRJNA630162_P_NODE_112879_length_178_cov_1.589147_g111356_i0 PRJNA630162 112879 178 1.589147 2.82868166 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00321   NR KAF4708041.1 32597 g111356 i0 46.9 1.65168539325843 49 25 80.9 1 173 30 924 972 KAF4708041.1 hypothetical protein FOZ63_029828 [Perkinsus olseni] diamond 294 44.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
32704191 32704191 PRJNA630162_P_NODE_143280_length_166_cov_0.897436_g141757_i0 PRJNA630162 143280 166 0.897436 1.48974376 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 52.8 3.35e-6   NR KAF4740879.1 32597 g141757 i0 40.4 1.86144578313253 52 31 94 0 157 2 107 158 KAF4740879.1 hypothetical protein FOZ62_024698, partial [Perkinsus olseni] diamond 309 52.8 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);;