contig_metadata
22 rows where bioproject = "PRJNA971593", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944117 | 944117 | PRJNA971593_P_NODE_13221_length_331_cov_2.073643_g13072_i0 | PRJNA971593 | 13221 | 331 | 2.073643 | 6.86375833 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 3.24e-38 | NR | KAF4738314.1 | 32597 | g13072 | i0 | 69.7 | 4.50453172205438 | 99 | 28 | 89.7 | 1 | 34 | 330 | 2 | 98 | KAF4738314.1 hypothetical protein FOZ62_003910, partial [Perkinsus olseni] | diamond | 1491 | 135 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 2219419 | 2219419 | PRJNA971593_P_NODE_10062_length_382_cov_1.491909_g9913_i0 | PRJNA971593 | 10062 | 382 | 1.491909 | 5.69909238 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 5.35e-53 | NR | KAF4658028.1 | 330153 | g9913 | i0 | 71.2 | 3.92670157068063 | 125 | 35 | 97.4 | 1 | 374 | 3 | 820 | 944 | KAF4658028.1 ribonucleotide-diphosphate reductase subunit rnr1 [Perkinsus chesapeaki] | diamond | 1500 | 189 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 8597175 | 8597175 | PRJNA971593_P_NODE_17927_length_282_cov_1.033493_g17778_i0 | PRJNA971593 | 17927 | 282 | 1.033493 | 2.91445026 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.4099999999999998e-32 | NR | KAF4704039.1 | 32597 | g17778 | i0 | 61.1 | 3.03191489361702 | 95 | 35 | 100 | 2 | 282 | 1 | 47 | 140 | KAF4704039.1 Spliceosome RNA helicase ddx39b, partial [Perkinsus olseni] | diamond | 855 | 124 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 14972320 | 14972320 | PRJNA971593_P_NODE_3792_length_620_cov_8.029250_g3648_i0 | PRJNA971593 | 3792 | 620 | 8.02925 | 49.78135 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 7.800000000000001e-64 | NR | KAF4741663.1 | 32597 | g3648 | i0 | 67.7 | 12.3774193548387 | 155 | 50 | 75 | 0 | 588 | 124 | 1345 | 1499 | KAF4741663.1 nucleoside diphosphate kinase [Perkinsus olseni] | diamond | 7674 | 224 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 15294162 | 15294162 | PRJNA971593_P_NODE_12832_length_337_cov_0.973485_g12683_i0 | PRJNA971593 | 12832 | 337 | 0.973485 | 3.28064445 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 8.18e-58 | NTclustered | gi|294897197|ref|XM_002775826.1| | 423536 | g12683 | i0 | 81.107 | 63.8071216617211 | 307 | 48 | 90 | 8 | 2 | 303 | 330 | 29 | Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA | blastn | 21503 | 239 | 0.99163179916318 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 18795935 | 18795935 | PRJNA971593_P_NODE_1335_length_992_cov_13.387378_g1230_i0 | PRJNA971593 | 1335 | 992 | 13.387378 | 132.80278976 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.26e-20 | NTclustered | gi|294891730|ref|XM_002773664.1| | 423536 | g1230 | i0 | 86.667 | 0.44758064516129 | 105 | 13 | 11 | 1 | 63 | 167 | 43 | 146 | Perkinsus marinus ATCC 50983 40S ribosomal protein S25, putative, mRNA | blastn | 444 | 115 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 25170351 | 25170351 | PRJNA971593_P_NODE_1820_length_870_cov_1.164366_g1699_i0 | PRJNA971593 | 1820 | 870 | 1.164366 | 10.1299842 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 1.89e-79 | NR | KAF4757260.1 | 32597 | g1699 | i0 | 73.3 | 6.10689655172414 | 176 | 40 | 60 | 2 | 522 | 1 | 59 | 229 | KAF4757260.1 hypothetical protein FOZ63_034007 [Perkinsus olseni] | diamond | 5313 | 263 | 0.992395437262357 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27151943 | 27151943 | PRJNA971593_P_NODE_2022_length_829_cov_1.423280_g1897_i0 | PRJNA971593 | 2022 | 829 | 1.42328 | 11.7989912 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 7.07e-32 | NR | TEB19254.1 | 2494336 | g1897 | i0 | 36.3 | 0.948130277442702 | 262 | 140 | 85 | 6 | 31 | 735 | 2 | 263 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 786 | 129 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 27910101 | 27910101 | PRJNA971593_P_NODE_26345_length_245_cov_0.895349_g26196_i0 | PRJNA971593 | 26345 | 245 | 0.895349 | 2.19360505 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0346 | NR | TEB19254.1 | 2494336 | g26196 | i0 | 38.9 | 0.881632653061225 | 72 | 43 | 86.9 | 1 | 215 | 3 | 3 | 74 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 216 | 42.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28232136 | 28232136 | PRJNA971593_P_NODE_26746_length_244_cov_2.140351_g26597_i0 | PRJNA971593 | 26746 | 244 | 2.140351 | 5.22245644 | root | 1 | Root_unresolved | Root_unresolved | 47 | 0.00113 | NR | KAF4676951.1 | 330153 | g26597 | i0 | 30.4 | 2.34836065573771 | 56 | 39 | 68.9 | 0 | 200 | 33 | 96 | 151 | KAF4676951.1 hypothetical protein FOL47_004193 [Perkinsus chesapeaki] | diamond | 573 | 47.4 | 0.991561181434599 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28478770 | 28478770 | PRJNA971593_P_NODE_28246_length_242_cov_0.911243_g28097_i0 | PRJNA971593 | 28246 | 242 | 0.911243 | 2.20520806 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 5.1e-10 | NR | TEB19254.1 | 2494336 | g28097 | i0 | 45 | 0.991735537190083 | 80 | 41 | 99.2 | 2 | 2 | 241 | 180 | 256 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 240 | 64.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 28674538 | 28674538 | PRJNA971593_P_NODE_14647_length_314_cov_1.278008_g14498_i0 | PRJNA971593 | 14647 | 314 | 1.278008 | 4.01294512 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 5.79e-7 | NR | KAF4688775.1 | 32597 | g14498 | i0 | 57.4 | 4.48089171974522 | 47 | 20 | 44.9 | 0 | 3 | 143 | 360 | 406 | KAF4688775.1 hypothetical protein FOZ60_002441 [Perkinsus olseni] | diamond | 1407 | 57.8 | 0.993079584775087 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28832220 | 28832220 | PRJNA971593_P_NODE_5148_length_534_cov_4.995662_g5001_i0 | PRJNA971593 | 5148 | 534 | 4.995662 | 26.67683508 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.9e-30 | NR | KAF4660660.1 | 32597 | g5001 | i0 | 50.9 | 3.73033707865169 | 114 | 56 | 64 | 0 | 520 | 179 | 1 | 114 | KAF4660660.1 60S ribosomal protein L31 [Perkinsus olseni] | diamond | 1992 | 117 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28927023 | 28927023 | PRJNA971593_P_NODE_18028_length_281_cov_1.110577_g17879_i0 | PRJNA971593 | 18028 | 281 | 1.110577 | 3.12072137 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 4.08e-18 | NR | KAF4664571.1 | 330153 | g17879 | i0 | 61.2 | 1.36654804270463 | 67 | 26 | 71.5 | 0 | 203 | 3 | 253 | 319 | KAF4664571.1 Ras- protein Rab-23 [Perkinsus chesapeaki] | diamond | 384 | 89 | 0.995505617977528 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29047168 | 29047168 | PRJNA971593_P_NODE_16448_length_294_cov_1.303167_g16299_i0 | PRJNA971593 | 16448 | 294 | 1.303167 | 3.83131098 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 2.73e-23 | NR | KAF4677616.1 | 330153 | g16299 | i0 | 60.6 | 5.26530612244898 | 71 | 28 | 72.4 | 0 | 241 | 29 | 2 | 72 | KAF4677616.1 Histidine triad nucleotide-binding protein 2, mitochondrial [Perkinsus chesapeaki] | diamond | 1548 | 96.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29520623 | 29520623 | PRJNA971593_P_NODE_2370_length_772_cov_2.884120_g2236_i0 | PRJNA971593 | 2370 | 772 | 2.88412 | 22.2654064 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 2.11e-82 | NR | XP_002778466.1 | 423536 | g2236 | i0 | 64.9 | 0.742227979274611 | 191 | 66 | 73.8 | 1 | 762 | 193 | 1 | 191 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 573 | 255 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30632384 | 30632384 | PRJNA971593_P_NODE_26533_length_245_cov_0.895349_g26384_i0 | PRJNA971593 | 26533 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 2.05e-18 | NR | KAF4667033.1 | 32597 | g26384 | i0 | 67.2 | 2.88979591836735 | 61 | 20 | 74.7 | 0 | 56 | 238 | 254 | 314 | KAF4667033.1 hypothetical protein FOZ61_008883 [Perkinsus olseni] | diamond | 708 | 89 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31707303 | 31707303 | PRJNA971593_P_NODE_10977_length_365_cov_1.054795_g10828_i0 | PRJNA971593 | 10977 | 365 | 1.054795 | 3.85000175 | root | 1 | Root_unresolved | Root_unresolved | 72 | 4.55e-13 | NR | XP_002788661.1 | 423536 | g10828 | i0 | 30.8 | 1.91506849315068 | 120 | 60 | 83 | 2 | 334 | 32 | 8 | 123 | XP_002788661.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 699 | 72.4 | 0.994475138121547 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31833684 | 31833684 | PRJNA971593_P_NODE_8637_length_412_cov_2.271386_g8488_i0 | PRJNA971593 | 8637 | 412 | 2.271386 | 9.35811032 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 4.29e-25 | NR | KAF4660233.1 | 32597 | g8488 | i0 | 50.9 | 21.3495145631068 | 110 | 54 | 80.1 | 0 | 50 | 379 | 17 | 126 | KAF4660233.1 histone h2a [Perkinsus olseni] | diamond | 8796 | 102 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31922463 | 31922463 | PRJNA971593_P_NODE_23517_length_249_cov_0.875000_g23368_i0 | PRJNA971593 | 23517 | 249 | 0.875 | 2.17875 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 6.05e-6 | NR | KAF4716975.1 | 32597 | g23368 | i0 | 36.3 | 3.85542168674699 | 80 | 45 | 96.4 | 2 | 244 | 5 | 72 | 145 | KAF4716975.1 hypothetical protein FOZ62_014341 [Perkinsus olseni] | diamond | 960 | 53.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32112405 | 32112405 | PRJNA971593_P_NODE_9678_length_390_cov_1.917981_g9529_i0 | PRJNA971593 | 9678 | 390 | 1.917981 | 7.4801259 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 6.2900000000000006e-27 | NR | TEB19254.1 | 2494336 | g9529 | i0 | 56.1 | 0.823076923076923 | 107 | 47 | 82.3 | 0 | 63 | 383 | 94 | 200 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 321 | 110 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 32587015 | 32587015 | PRJNA971593_P_NODE_15999_length_299_cov_1.022124_g15850_i0 | PRJNA971593 | 15999 | 299 | 1.022124 | 3.05615076 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0343 | NR | XP_002774373.1 | 423536 | g15850 | i0 | 35.2 | 0.712374581939799 | 71 | 45 | 71.2 | 1 | 14 | 226 | 162 | 231 | XP_002774373.1 big MAP kinase BMK, putative [Perkinsus marinus ATCC 50983] | diamond | 213 | 43.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus |
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);;