contig_metadata
24 rows where bioproject = "PRJNA744060", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 722867 | 722867 | PRJNA744060_P_NODE_11781_length_466_cov_5.572519_g11453_i0 | PRJNA744060 | 11781 | 466 | 5.572519 | 25.96793854 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 2.36e-49 | NR | KAF4691797.1 | 32597 | g11453 | i0 | 58.3 | 20.8519313304721 | 144 | 54 | 92.7 | 2 | 464 | 33 | 29 | 166 | KAF4691797.1 40S ribosomal protein, variant 2 [Perkinsus olseni] | diamond | 9717 | 166 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 4551985 | 4551985 | PRJNA744060_P_NODE_42004_length_257_cov_2.793478_g41675_i0 | PRJNA744060 | 42004 | 257 | 2.793478 | 7.17923846 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.8000000000000002e-28 | NR | KAF4734497.1 | 32597 | g41675 | i0 | 65.1 | 6.75875486381323 | 83 | 26 | 96.9 | 1 | 251 | 3 | 255 | 334 | KAF4734497.1 Malic enzyme [Perkinsus olseni] | diamond | 1737 | 117 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 8377098 | 8377098 | PRJNA744060_P_NODE_9687_length_514_cov_27.120181_g9360_i0 | PRJNA744060 | 9687 | 514 | 27.120181 | 139.39773034 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 3.5e-78 | NTclustered | gi|294897197|ref|XM_002775826.1| | 423536 | g9360 | i0 | 79.817 | 49.591439688716 | 436 | 74 | 83 | 12 | 40 | 468 | 457 | 29 | Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA | blastn | 25490 | 305 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 12678100 | 12678100 | PRJNA744060_P_NODE_2590_length_952_cov_4.952218_g2347_i0 | PRJNA744060 | 2590 | 952 | 4.952218 | 47.14511536 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 432 | 2.38e-149 | NR | XP_002774056.1 | 423536 | g2347 | i0 | 73 | 1.77731092436975 | 282 | 76 | 88.9 | 0 | 3 | 848 | 34 | 315 | XP_002774056.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 1692 | 432 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 18575186 | 18575186 | PRJNA744060_P_NODE_43115_length_254_cov_3.364641_g42786_i0 | PRJNA744060 | 43115 | 254 | 3.364641 | 8.54618814 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.05e-31 | NR | KAF4743881.1 | 32597 | g42786 | i0 | 67.9 | 11.255905511811 | 78 | 25 | 92.1 | 0 | 239 | 6 | 8 | 85 | KAF4743881.1 hypothetical protein FOZ62_030752, partial [Perkinsus olseni] | diamond | 2859 | 119 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 24949677 | 24949677 | PRJNA744060_P_NODE_24620_length_327_cov_2.799213_g24291_i0 | PRJNA744060 | 24620 | 327 | 2.799213 | 9.15342651 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 214 | 6.82e-68 | NR | KAF4650434.1 | 330153 | g24291 | i0 | 85.3 | 38 | 109 | 16 | 100 | 0 | 1 | 327 | 145 | 253 | KAF4650434.1 serine threonine-protein phosphatase, partial [Perkinsus chesapeaki] | diamond | 12426 | 216 | 0.990740740740741 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 24949705 | 24949705 | PRJNA744060_P_NODE_2660_length_941_cov_3.307604_g2414_i0 | PRJNA744060 | 2660 | 941 | 3.307604 | 31.12455364 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 192 | 1.2799999999999999e-54 | NR | KAF4689488.1 | 32597 | g2414 | i0 | 41.7 | 4.63549415515409 | 235 | 126 | 74 | 5 | 939 | 244 | 138 | 364 | KAF4689488.1 hypothetical protein FOZ60_001611 [Perkinsus olseni] | diamond | 4362 | 192 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26999268 | 26999268 | PRJNA744060_P_NODE_51002_length_242_cov_1.822485_g50673_i0 | PRJNA744060 | 51002 | 242 | 1.822485 | 4.4104137 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.14e-28 | NR | XP_002781496.1 | 423536 | g50673 | i0 | 66.2 | 11.4917355371901 | 77 | 26 | 95.5 | 0 | 234 | 4 | 243 | 319 | XP_002781496.1 Aldehyde dehydrogenase, putative, partial [Perkinsus marinus ATCC 50983] | diamond | 2781 | 116 | 0.991379310344828 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27115658 | 27115658 | PRJNA744060_P_NODE_20622_length_356_cov_1.643110_g20293_i0 | PRJNA744060 | 20622 | 356 | 1.64311 | 5.8494716 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 179 | 6.259999999999999e-55 | NR | XP_002778466.1 | 423536 | g20293 | i0 | 72.9 | 0.99438202247191 | 118 | 32 | 99.4 | 0 | 355 | 2 | 24 | 141 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 354 | 179 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27347347 | 27347347 | PRJNA744060_P_NODE_23883_length_332_cov_2.096525_g23554_i0 | PRJNA744060 | 23883 | 332 | 2.096525 | 6.960463 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 1.62e-5 | NR | KAF4697153.1 | 32597 | g23554 | i0 | 50.7 | 2.87349397590361 | 75 | 34 | 67.8 | 1 | 19 | 243 | 253 | 324 | KAF4697153.1 hypothetical protein FOZ60_011825 [Perkinsus olseni] | diamond | 954 | 53.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27505274 | 27505274 | PRJNA744060_P_NODE_11063_length_482_cov_1.904645_g10735_i0 | PRJNA744060 | 11063 | 482 | 1.904645 | 9.1803889 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 8.99e-50 | NR | KAF4657204.1 | 32597 | g10735 | i0 | 51.2 | 6.29253112033195 | 170 | 69 | 99 | 4 | 3 | 479 | 188 | 354 | KAF4657204.1 hypothetical protein FOZ61_006415 [Perkinsus olseni] | diamond | 3033 | 182 | 0.994505494505495 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27915423 | 27915423 | PRJNA744060_P_NODE_46505_length_249_cov_0.886364_g46176_i0 | PRJNA744060 | 46505 | 249 | 0.886364 | 2.20704636 | root | 1 | Root_unresolved | Root_unresolved | 84.3 | 9.41e-17 | NR | KAF4677704.1 | 330153 | g46176 | i0 | 49.4 | 5 | 83 | 39 | 100 | 2 | 249 | 1 | 529 | 608 | KAF4677704.1 Malic enzyme [Perkinsus chesapeaki] | diamond | 1245 | 85.1 | 0.990599294947121 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28221103 | 28221103 | PRJNA744060_P_NODE_2886_length_907_cov_26.914868_g2631_i0 | PRJNA744060 | 2886 | 907 | 26.914868 | 244.11785276 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 5.389999999999999e-31 | NR | TEB19254.1 | 2494336 | g2631 | i0 | 33.7 | 0.883131201764057 | 267 | 155 | 82.4 | 7 | 843 | 97 | 1 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 801 | 127 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28862641 | 28862641 | PRJNA744060_P_NODE_4028_length_780_cov_2.852900_g3743_i0 | PRJNA744060 | 4028 | 780 | 2.8529 | 22.25262 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 5.43e-64 | NR | KAF4749074.1 | 32597 | g3743 | i0 | 56.6 | 2.18076923076923 | 189 | 71 | 71.5 | 5 | 731 | 174 | 174 | 354 | KAF4749074.1 hypothetical protein FOZ62_023133 [Perkinsus olseni] | diamond | 1701 | 222 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29484004 | 29484004 | PRJNA744060_P_NODE_43710_length_253_cov_1.600000_g43381_i0 | PRJNA744060 | 43710 | 253 | 1.6 | 4.048 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 3.46e-11 | NR | XP_002772922.1 | 423536 | g43381 | i0 | 53.8 | 1.81422924901186 | 80 | 31 | 87.7 | 1 | 223 | 2 | 1 | 80 | XP_002772922.1 polyadenylate-binding protein, putative [Perkinsus marinus ATCC 50983] | diamond | 459 | 68.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29904878 | 29904878 | PRJNA744060_P_NODE_41111_length_260_cov_1.358289_g40782_i0 | PRJNA744060 | 41111 | 260 | 1.358289 | 3.5315514 | Xanthophyceae | 2833 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 3.15e-26 | NR | KAF4708901.1 | 32597 | g40782 | i0 | 55.3 | 5.88461538461539 | 85 | 36 | 98.1 | 1 | 258 | 4 | 63 | 145 | KAF4708901.1 hypothetical protein FOZ62_022951, partial [Perkinsus olseni] | diamond | 1530 | 107 | 0.990654205607477 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30652836 | 30652836 | PRJNA744060_P_NODE_3973_length_785_cov_8.042135_g3689_i0 | PRJNA744060 | 3973 | 785 | 8.042135 | 63.13075975 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 251 | 8.05e-81 | NR | XP_002778466.1 | 423536 | g3689 | i0 | 66 | 0.729936305732484 | 191 | 59 | 72.6 | 3 | 42 | 611 | 6 | 191 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 573 | 251 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31189804 | 31189804 | PRJNA744060_P_NODE_6635_length_617_cov_2.827206_g6314_i0 | PRJNA744060 | 6635 | 617 | 2.827206 | 17.44386102 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.67e-84 | NR | XP_002778466.1 | 423536 | g6314 | i0 | 65.1 | 0.93354943273906 | 192 | 66 | 92.9 | 1 | 20 | 592 | 1 | 192 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 576 | 257 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31358380 | 31358380 | PRJNA744060_P_NODE_42436_length_256_cov_2.415301_g42107_i0 | PRJNA744060 | 42436 | 256 | 2.415301 | 6.18317056 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 1.98e-20 | NR | KAF4691366.1 | 32597 | g42107 | i0 | 86.5 | 4.3359375 | 52 | 7 | 60.9 | 0 | 256 | 101 | 119 | 170 | KAF4691366.1 Centrin-3 [Perkinsus olseni] | diamond | 1110 | 90.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31674418 | 31674418 | PRJNA744060_P_NODE_16077_length_401_cov_2.603659_g15748_i0 | PRJNA744060 | 16077 | 401 | 2.603659 | 10.44067259 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 1.95e-10 | NR | KAF4671217.1 | 330153 | g15748 | i0 | 55.3 | 3.41147132169576 | 47 | 21 | 35.2 | 0 | 166 | 26 | 2 | 48 | KAF4671217.1 hypothetical protein FOL47_001663 [Perkinsus chesapeaki] | diamond | 1368 | 64.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31769406 | 31769406 | PRJNA744060_P_NODE_48097_length_246_cov_2.156069_g47768_i0 | PRJNA744060 | 48097 | 246 | 2.156069 | 5.30392974 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 1.5e-38 | NR | KAF4705141.1 | 32597 | g47768 | i0 | 89.4 | 10.8170731707317 | 66 | 7 | 80.5 | 0 | 198 | 1 | 27 | 92 | KAF4705141.1 Ubiquitin-like 5 [Perkinsus olseni] | diamond | 2661 | 133 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31822523 | 31822523 | PRJNA744060_P_NODE_1197_length_1280_cov_20.874896_g1049_i0 | PRJNA744060 | 1197 | 1280 | 20.874896 | 267.1986688 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 4.91e-47 | NR | TEB19254.1 | 2494336 | g1049 | i0 | 43.2 | 0.61875 | 264 | 138 | 59.8 | 5 | 34 | 798 | 3 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 792 | 172 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 32012615 | 32012615 | PRJNA744060_P_NODE_9298_length_524_cov_5.181818_g8972_i0 | PRJNA744060 | 9298 | 524 | 5.181818 | 27.15272632 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 218 | 5.11e-69 | NR | XP_002778466.1 | 423536 | g8972 | i0 | 66.5 | 0.904580152671756 | 158 | 47 | 89.9 | 2 | 472 | 2 | 5 | 157 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 474 | 218 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32244397 | 32244397 | PRJNA744060_P_NODE_46578_length_249_cov_0.886364_g46249_i0 | PRJNA744060 | 46578 | 249 | 0.886364 | 2.20704636 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 5.41e-10 | NR | KAF4678253.1 | 32597 | g46249 | i0 | 50.8 | 1.56626506024096 | 65 | 31 | 77.1 | 1 | 58 | 249 | 226 | 290 | KAF4678253.1 hypothetical protein FOZ60_016886 [Perkinsus olseni] | diamond | 390 | 65.5 | 0.993893129770992 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni |
Advanced export
JSON shape: default, array, newline-delimited
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);;