RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB10140", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJEB10140 · 15 ✖

analysis 1

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
10214418 10214418 PRJEB10140_P_NODE_145069_length_255_cov_1.004854_g127761_i0 PRJEB10140 145069 255 1.004854 2.5623777 root 1 Root_unresolved Root_unresolved 105 2.5499999999999998e-24   NR KAF4737055.1 32597 g127761 i0 56.6 7.84705882352941 83 34 97.6 1 2 250 94 174 KAF4737055.1 Fibronectin type III and SPRY domain-containing protein 1, partial [Perkinsus olseni] diamond 2001 105 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
26646483 26646483 PRJEB10140_P_NODE_297221_length_153_cov_2.269231_g279912_i0 PRJEB10140 297221 153 2.269231 3.47192343 Perkinsida 27998 SAR_Eukaryotes SAR_Eukaryotes 84 3.18e-17   NR KAF4742451.1 32597 g279912 i0 78 3.92156862745098 50 11 98 0 2 151 495 544 KAF4742451.1 Proteasome subunit beta type-1 [Perkinsus olseni] diamond 600 84 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
26868596 26868596 PRJEB10140_P_NODE_297141_length_153_cov_2.442308_g279832_i0 PRJEB10140 297141 153 2.442308 3.73673124 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62 1.07e-9   NR KAF4692523.1 32597 g279832 i0 90 2.33333333333333 30 3 58.8 0 153 64 225 254 KAF4692523.1 hypothetical protein FOZ60_013192 [Perkinsus olseni] diamond 357 62 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
27089925 27089925 PRJEB10140_P_NODE_89942_length_407_cov_1.547486_g72654_i0 PRJEB10140 89942 407 1.547486 6.29826802 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 62 3.98e-8   NR KAF4758630.1 32597 g72654 i0 57.9 1.26044226044226 57 21 40.5 2 406 242 481 536 KAF4758630.1 heat shock protein 90, partial [Perkinsus olseni] diamond 513 62 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28132191 28132191 PRJEB10140_P_NODE_186045_length_207_cov_0.987342_g168736_i0 PRJEB10140 186045 207 0.987342 2.04379794 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 126 9.8e-32   NR KAF4747865.1 32597 g168736 i0 85.5 25 69 10 100 0 207 1 596 664 KAF4747865.1 ribonucleotide-diphosphate reductase subunit rnr1, partial [Perkinsus olseni] diamond 5175 126 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28232518 28232518 PRJEB10140_P_NODE_168726_length_224_cov_1.417143_g151417_i0 PRJEB10140 168726 224 1.417143 3.17440032 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 128 3.7099999999999997e-34   NR KAF4672014.1 330153 g151417 i0 77 9.91071428571429 74 17 99.1 0 2 223 52 125 KAF4672014.1 hypothetical protein FOL47_001025 [Perkinsus chesapeaki] diamond 2220 128 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
28321441 28321441 PRJEB10140_P_NODE_211446_length_188_cov_1.079137_g194137_i0 PRJEB10140 211446 188 1.079137 2.02877756 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 50.1 4.72e-5   NR KAF4696661.1 32597 g194137 i0 61.1 3.38297872340426 36 13 55.9 1 174 70 32 67 KAF4696661.1 hypothetical protein FOZ60_016671 [Perkinsus olseni] diamond 636 50.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
29211852 29211852 PRJEB10140_P_NODE_95289_length_384_cov_2.528358_g77995_i0 PRJEB10140 95289 384 2.528358 9.70889472 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 102 5.68e-26   NR XP_002780966.1 423536 g77995 i0 72.2 1.1015625 72 19 56.3 1 338 123 1 71 XP_002780966.1 40S ribosomal protein S28, putative [Perkinsus marinus ATCC 50983] diamond 423 102 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
30285714 30285714 PRJEB10140_P_NODE_103852_length_352_cov_2.000000_g86553_i0 PRJEB10140 103852 352 2 7.04 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 181 5.8199999999999984e-55   NR KAF4680559.1 32597 g86553 i0 75.4 1.00568181818182 118 27 98.9 1 351 4 107 224 KAF4680559.1 hypothetical protein FOZ60_013270 [Perkinsus olseni] diamond 354 181 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30317451 30317451 PRJEB10140_P_NODE_115992_length_315_cov_1.736842_g98686_i0 PRJEB10140 115992 315 1.736842 5.4710523 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 140 1.6399999999999999e-40   NR KAF4750720.1 32597 g98686 i0 72.4 3 105 29 100 0 1 315 22 126 KAF4750720.1 hypothetical protein FOZ62_006230, partial [Perkinsus olseni] diamond 945 140 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31227136 31227136 PRJEB10140_P_NODE_92675_length_395_cov_2.306358_g75382_i0 PRJEB10140 92675 395 2.306358 9.1101141 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 177 9.33e-53   NR KAF4657565.1 32597 g75382 i0 67.9 5.96962025316456 131 42 99.5 0 1 393 3 133 KAF4657565.1 60S ribosomal protein L12, partial [Perkinsus olseni] diamond 2358 178 0.99438202247191 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31233091 31233091 PRJEB10140_P_NODE_25935_length_1265_cov_4.687500_g15490_i0 PRJEB10140 25935 1265 4.6875 59.296875 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 340 2.36e-109   NR KAF4668894.1 32597 g15490 i0 46.1 1.01264822134387 427 193 99.8 7 1264 2 34 429 KAF4668894.1 DUF895 domain membrane protein [Perkinsus olseni] diamond 1281 340 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31486638 31486638 PRJEB10140_P_NODE_87516_length_418_cov_2.883469_g70238_i0 PRJEB10140 87516 418 2.883469 12.05290042 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 55.8 3.77e-6   NR KAF4665932.1 330153 g70238 i0 54.9 0.710526315789474 51 22 36.6 1 22 174 64 113 KAF4665932.1 E3 ubiquitin-protein ligase mib1 [Perkinsus chesapeaki] diamond 297 55.8 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
32024142 32024142 PRJEB10140_P_NODE_185258_length_207_cov_2.537975_g167949_i0 PRJEB10140 185258 207 2.537975 5.25360825 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 105 7.29e-25   NR KAF4676875.1 330153 g167949 i0 75 2.95652173913043 68 17 98.6 0 3 206 45 112 KAF4676875.1 phosphopyruvate hydratase eno2 [Perkinsus chesapeaki] diamond 612 105 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
32271332 32271332 PRJEB10140_P_NODE_74798_length_491_cov_1.690045_g57610_i0 PRJEB10140 74798 491 1.690045 8.29812095 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 212 6.82e-66   NR KAF4689453.1 32597 g57610 i0 61.4 22.6191446028513 153 59 93.5 0 3 461 79 231 KAF4689453.1 40S ribosomal protein S4, X isoform [Perkinsus olseni] diamond 11106 212 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);;