RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA688931", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Perkinsozoa · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA688931 · 16 ✖

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
22855475 22855475 PRJNA688931_P_NODE_7618_length_392_cov_1.446064_g7405_i0 PRJNA688931 7618 392 1.446064 5.66857088 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 108 1.03e-25   NR KAF4685574.1 32597 g7405 i0 72.4 0.887755102040816 58 16 44.4 0 210 383 115 172 KAF4685574.1 hypothetical protein FOZ62_006760, partial [Perkinsus olseni] diamond 348 108 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
26777506 26777506 PRJNA688931_P_NODE_18341_length_239_cov_2.673684_g18128_i0 PRJNA688931 18341 239 2.673684 6.39010476 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82.4 4.25e-17   NR KAF4672005.1 330153 g18128 i0 61.9 1.59414225941423 63 24 79.1 0 189 1 14 76 KAF4672005.1 Fibronectin type III and SPRY domain-containing protein 1 [Perkinsus chesapeaki] diamond 381 82.4 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
27125050 27125050 PRJNA688931_P_NODE_32442_length_177_cov_1.500000_g32229_i0 PRJNA688931 32442 177 1.5 2.655 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00257   NR XP_002775259.1 423536 g32229 i0 63.6 4.20338983050847 44 13 74.6 2 134 3 18 58 XP_002775259.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] diamond 744 44.7 0.991051454138702 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
28124584 28124584 PRJNA688931_P_NODE_11245_length_313_cov_2.712121_g11032_i0 PRJNA688931 11245 313 2.712121 8.48893873 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 50.4 1.56e-4   NR KAF4711357.1 32597 g11032 i0 36.6 2.04153354632588 71 42 65.2 1 3 206 313 383 KAF4711357.1 hypothetical protein FOZ63_028272, partial [Perkinsus olseni] diamond 639 50.4 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28230554 28230554 PRJNA688931_P_NODE_32226_length_178_cov_1.162791_g32013_i0 PRJNA688931 32226 178 1.162791 2.06976798 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 90.1 3.08e-19   NR KAF4747297.1 32597 g32013 i0 80.7 11.6292134831461 57 11 96.1 0 3 173 227 283 KAF4747297.1 Sodium/potassium-transporting ATPase subunit alpha-1, partial [Perkinsus olseni] diamond 2070 90.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28566576 28566576 PRJNA688931_P_NODE_8267_length_374_cov_0.981538_g8054_i0 PRJNA688931 8267 374 0.981538 3.67095212 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.44e-12   NR KAF4690718.1 32597 g8054 i0 38.1 8.01336898395722 126 72 99.5 3 3 374 532 653 KAF4690718.1 (ABC) transporter, partial [Perkinsus olseni] diamond 2997 74.3 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
28945752 28945752 PRJNA688931_P_NODE_29668_length_186_cov_1.883212_g29455_i0 PRJNA688931 29668 186 1.883212 3.50277432 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 65.1 3.45e-11   NR XP_002772168.1 423536 g29455 i0 43.3 0.967741935483871 60 34 96.8 0 184 5 92 151 XP_002772168.1 MORN repeat protein, putative [Perkinsus marinus ATCC 50983] diamond 180 65.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
29103529 29103529 PRJNA688931_P_NODE_42048_length_163_cov_0.912281_g41835_i0 PRJNA688931 42048 163 0.912281 1.48701803 Perkinsus chesapeaki 330153 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.09e-9   NR KAF4664529.1 330153 g41835 i0 60 0.920245398773006 50 20 92 0 4 153 679 728 KAF4664529.1 VP, versatile peroxidase [Perkinsus chesapeaki] diamond 150 62.8 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus chesapeaki
29209730 29209730 PRJNA688931_P_NODE_42289_length_163_cov_0.903509_g42076_i0 PRJNA688931 42289 163 0.903509 1.47271967 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 94.4 4.69e-21   NR KAF4720670.1 32597 g42076 i0 72.2 10.9325153374233 54 15 99.4 0 162 1 213 266 KAF4720670.1 T-complex protein 1 subunit epsilon [Perkinsus olseni] diamond 1782 94.7 0.996832101372756 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
29924434 29924434 PRJNA688931_P_NODE_19411_length_232_cov_2.415301_g19198_i0 PRJNA688931 19411 232 2.415301 5.60349832 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 52.8 7.25e-6   NR KAF4656929.1 32597 g19198 i0 39.7 1.59051724137931 63 35 78.9 2 12 194 148 209 KAF4656929.1 hypothetical protein FOZ61_006606, partial [Perkinsus olseni] diamond 369 52.8 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30410126 30410126 PRJNA688931_P_NODE_13233_length_286_cov_1.088608_g13020_i0 PRJNA688931 13233 286 1.088608 3.1134188800000002 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0135   NR KAF4671986.1 32597 g13020 i0 54.8 1.62587412587413 31 14 32.5 0 271 179 61 91 KAF4671986.1 hypothetical protein FOL46_009662 [Perkinsus olseni] diamond 465 44.7 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30745786 30745786 PRJNA688931_P_NODE_13394_length_284_cov_1.255319_g13181_i0 PRJNA688931 13394 284 1.255319 3.56510596 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 48.1 7.88e-4   NR KAF4651201.1 32597 g13181 i0 30.4 2.36619718309859 56 39 59.2 0 172 5 976 1031 KAF4651201.1 hypothetical protein FOZ61_010671, partial [Perkinsus olseni] diamond 672 48.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30872106 30872106 PRJNA688931_P_NODE_11434_length_310_cov_2.601533_g11221_i0 PRJNA688931 11434 310 2.601533 8.0647523 Perkinsus marinus ATCC 5 31276 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00631   NR XP_002765022.1 423536 g11221 i0 60 2.32258064516129 30 12 29 0 3 92 91 120 XP_002765022.1 hypothetical protein Pmar_PMAR004478, partial [Perkinsus marinus ATCC 50983] diamond 720 45.1 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus marinus
31567915 31567915 PRJNA688931_P_NODE_23356_length_212_cov_0.944785_g23143_i0 PRJNA688931 23356 212 0.944785 2.0029442 Perkinsus olseni 32597 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.68e-13   NR KAF4661695.1 32597 g23143 i0 59.4 0.905660377358491 64 26 90.6 0 192 1 60 123 KAF4661695.1 hypothetical protein FOZ61_003029 [Perkinsus olseni] diamond 192 74.3 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
31958750 31958750 PRJNA688931_P_NODE_40237_length_164_cov_2.713043_g40024_i0 PRJNA688931 40237 164 2.713043 4.44939052 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 81.6 2.46e-16   NR KAF4729423.1 32597 g40024 i0 70.4 6.91463414634146 54 16 98.8 0 163 2 80 133 KAF4729423.1 putative tRNA (cytidine(32)/guanosine(34)-2'-O)-methyltransferase [Perkinsus olseni] diamond 1134 82 0.995121951219512 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
32874835 32874835 PRJNA688931_P_NODE_23540_length_211_cov_1.160494_g23327_i0 PRJNA688931 23540 211 1.160494 2.44864234 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 74.7 8.8e-15   NR KAF4740634.1 32597 g23327 i0 74 2.13270142180095 50 13 71.1 0 1 150 4 53 KAF4740634.1 40S ribosomal protein S6, partial [Perkinsus olseni] diamond 450 75.1 0.994673768308922 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);;