RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJEB17675", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJEB17675 · 14 ✖

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
3847894 3847894 PRJEB17675_P_NODE_504_length_1261_cov_4.531811_g406_i0 PRJEB17675 504 1261 4.531811 57.14613671 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 427 1.1099999999999996e-145   NR XP_002774056.1 423536 g406 i0 66.3 1.46312450436162 309 101 72.8 2 77 994 6 314 XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] diamond 1845 427 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
6399835 6399835 PRJEB17675_P_NODE_606_length_1167_cov_5.205830_g406_i1 PRJEB17675 606 1167 5.20583 60.7520361 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 427 1.7099999999999996e-146   NR XP_002774056.1 423536 g406 i1 66.8 1.57583547557841 307 99 78.1 2 77 988 6 312 XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] diamond 1839 427 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
7673956 7673956 PRJEB17675_P_NODE_4967_length_435_cov_1.895000_g4669_i0 PRJEB17675 4967 435 1.895 8.24325 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 188 3.59e-53   NR XP_002788182.1 423536 g4669 i0 66.9 25.7793103448276 145 42 99.3 2 3 434 220 359 XP_002788182.1 heat shock protein, putative [Perkinsus marinus ATCC 50983] diamond 11214 189 0.994708994708995 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
8948727 8948727 PRJEB17675_P_NODE_7888_length_325_cov_1.034483_g7584_i0 PRJEB17675 7888 325 1.034483 3.36206975 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 162 1.4699999999999999e-43   NR KAF4680848.1 32597 g7584 i0 67.6 11.9353846153846 108 35 99.7 0 324 1 3248 3355 KAF4680848.1 hypothetical protein FOZ60_012879 [Perkinsus olseni] diamond 3879 162 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
11499724 11499724 PRJEB17675_P_NODE_7210_length_345_cov_2.519355_g6906_i0 PRJEB17675 7210 345 2.519355 8.69177475 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 231 2.08e-73   NR KAF4670898.1 32597 g6906 i0 87.7 158.55652173913 114 14 99.1 0 2 343 120 233 KAF4670898.1 Serine/threonine-protein phosphatase PP1-gamma catalytic subunit [Perkinsus olseni] diamond 54702 233 0.991416309012876 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
22973674 22973674 PRJEB17675_P_NODE_6279_length_376_cov_1.821114_g5978_i0 PRJEB17675 6279 376 1.821114 6.84738864 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 159 1.7e-42   NR KAF4718682.1 32597 g5978 i0 71.3 8.25 115 33 91.8 0 3 347 184 298 KAF4718682.1 hypothetical protein FOZ63_025302, partial [Perkinsus olseni] diamond 3102 160 0.99375 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
27127571 27127571 PRJEB17675_P_NODE_11362_length_253_cov_1.279817_g11058_i0 PRJEB17675 11362 253 1.279817 3.23793701 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 70.9 3.52e-12   NR KAF4653780.1 330153 g11058 i0 51.4 3.61660079051383 72 31 81.8 2 6 212 166 236 KAF4653780.1 hypothetical protein FOL47_010292 [Perkinsus chesapeaki] diamond 915 70.9 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
28549302 28549302 PRJEB17675_P_NODE_15307_length_207_cov_1.232558_g15003_i0 PRJEB17675 15307 207 1.232558 2.55139506 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 62 3.69e-9   NR XP_002784359.1 423536 g15003 i0 51.5 0.985507246376812 68 27 92.8 3 8 199 306 371 XP_002784359.1 Acetylcholinesterase precursor, putative [Perkinsus marinus ATCC 50983] diamond 204 62 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
29268666 29268666 PRJEB17675_P_NODE_5469_length_410_cov_1.645333_g5170_i0 PRJEB17675 5469 410 1.645333 6.7458653 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 193 5.47e-54   NR KAF4672633.1 32597 g5170 i0 57.1 7.06829268292683 161 44 99.5 1 408 1 265 425 KAF4672633.1 hypothetical protein FOL46_008688 [Perkinsus olseni] diamond 2898 193 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
29300446 29300446 PRJEB17675_P_NODE_12829_length_233_cov_1.409091_g12525_i0 PRJEB17675 12829 233 1.409091 3.28318203 Dinophyceae 2864 SAR_Eukaryotes SAR_Eukaryotes 93.2 1.2e-20   NR KAF4726240.1 32597 g12525 i0 61 6.86266094420601 77 30 99.1 0 232 2 176 252 KAF4726240.1 hypothetical protein FOZ62_001949, partial [Perkinsus olseni] diamond 1599 93.2 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30381102 30381102 PRJEB17675_P_NODE_13993_length_220_cov_1.535135_g13689_i0 PRJEB17675 13993 220 1.535135 3.377297 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.04e-7   NR XP_002777698.1 423536 g13689 i0 58.3 1.45909090909091 48 20 65.5 0 76 219 960 1007 XP_002777698.1 plasma membrane calcium-transporting ATPase, putative [Perkinsus marinus ATCC 50983] diamond 321 58.2 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
30412622 30412622 PRJEB17675_P_NODE_16653_length_196_cov_1.739130_g16349_i0 PRJEB17675 16653 196 1.73913 3.4086948 Perkinsus sp. BL_2 28001 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0074400000000000004   NR TEB19254.1 2494336 g16349 i0 44 0.76530612244898 50 28 76.5 0 44 193 138 187 TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] diamond 150 43.9 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus sp. BL_2016
32214522 32214522 PRJEB17675_P_NODE_22538_length_161_cov_1.269841_g22234_i0 PRJEB17675 22538 161 1.269841 2.04444401 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 60.5 6.76e-9   NR KAF4654168.1 330153 g22234 i0 49.1 2.94409937888199 53 27 98.8 0 1 159 129 181 KAF4654168.1 hypothetical protein FOL47_010106 [Perkinsus chesapeaki] diamond 474 60.5 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
32492958 32492958 PRJEB17675_P_NODE_7579_length_334_cov_2.665552_g7275_i0 PRJEB17675 7579 334 2.665552 8.90294368 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57.4 7.08e-7   NR KAF4688775.1 32597 g7275 i0 57.4 4.2125748502994 47 20 42.2 0 332 192 360 406 KAF4688775.1 hypothetical protein FOZ60_002441 [Perkinsus olseni] diamond 1407 57.8 0.993079584775087 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);;