contig_metadata
18 rows where bioproject = "PRJNA1067370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11659498 | 11659498 | PRJNA1067370_P_NODE_44870_length_310_cov_0.974684_g44322_i0 | PRJNA1067370 | 44870 | 310 | 0.974684 | 3.0215204 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.14e-34 | NR | KAF4673710.1 | 330153 | g44322 | i0 | 60 | 10.858064516129 | 95 | 38 | 91.9 | 0 | 305 | 21 | 505 | 599 | KAF4673710.1 hypothetical protein FOL47_010191 [Perkinsus chesapeaki] | diamond | 3366 | 134 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 12934493 | 12934493 | PRJNA1067370_P_NODE_2631_length_1045_cov_6.765432_g2246_i0 | PRJNA1067370 | 2631 | 1045 | 6.765432 | 70.6987644 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 367 | 8.12e-123 | NR | KAF4682066.1 | 32597 | g2246 | i0 | 59.1 | 13.2602870813397 | 328 | 129 | 93.9 | 4 | 51 | 1031 | 8 | 331 | KAF4682066.1 hypothetical protein FOZ60_011196 [Perkinsus olseni] | diamond | 13857 | 370 | 0.991891891891892 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 23132805 | 23132805 | PRJNA1067370_P_NODE_100539_length_245_cov_0.895349_g99990_i0 | PRJNA1067370 | 100539 | 245 | 0.895349 | 2.19360505 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 8.55e-12 | NR | KAF4676519.1 | 330153 | g99990 | i0 | 86.1 | 8.37551020408163 | 36 | 5 | 44.1 | 0 | 244 | 137 | 290 | 325 | KAF4676519.1 suppressor of kinetochore protein mutant [Perkinsus chesapeaki] | diamond | 2052 | 69.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 24406549 | 24406549 | PRJNA1067370_P_NODE_11840_length_531_cov_1.685590_g11296_i0 | PRJNA1067370 | 11840 | 531 | 1.68559 | 8.9504829 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 1.75e-29 | NR | XP_002764690.1 | 423536 | g11296 | i0 | 66.3 | 7 | 95 | 31 | 53.7 | 1 | 531 | 247 | 9 | 102 | XP_002764690.1 eukaryotic translation initiation factor 1A, X-chromosomal, putative [Perkinsus marinus ATCC 50983] | diamond | 3717 | 116 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26623963 | 26623963 | PRJNA1067370_P_NODE_39961_length_319_cov_1.605691_g39413_i0 | PRJNA1067370 | 39961 | 319 | 1.605691 | 5.12215429 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 4.83e-33 | NR | TEB17008.1 | 2494336 | g39413 | i0 | 63.6 | 1.81504702194357 | 88 | 32 | 82.8 | 0 | 55 | 318 | 241 | 328 | TEB17008.1 translation initiation factor [Perkinsus sp. BL_2016] | diamond | 579 | 128 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 27541306 | 27541306 | PRJNA1067370_P_NODE_82364_length_250_cov_1.598870_g81815_i0 | PRJNA1067370 | 82364 | 250 | 1.59887 | 3.997175 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 3.09e-9 | NR | KAF4726765.1 | 32597 | g81815 | i0 | 43.8 | 4.8 | 80 | 42 | 92.4 | 2 | 19 | 249 | 129 | 208 | KAF4726765.1 hypothetical protein FOZ63_031558 [Perkinsus olseni] | diamond | 1200 | 62.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27699361 | 27699361 | PRJNA1067370_P_NODE_41764_length_314_cov_1.278008_g41216_i0 | PRJNA1067370 | 41764 | 314 | 1.278008 | 4.01294512 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 3.7e-6 | NR | KAF4724311.1 | 32597 | g41216 | i0 | 32 | 7.48089171974522 | 97 | 65 | 92.7 | 1 | 2 | 292 | 71 | 166 | KAF4724311.1 hypothetical protein FOZ62_010876, partial [Perkinsus olseni] | diamond | 2349 | 55.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29624613 | 29624613 | PRJNA1067370_P_NODE_88130_length_249_cov_0.875000_g87581_i0 | PRJNA1067370 | 88130 | 249 | 0.875 | 2.17875 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 2.01e-4 | NR | KAF4669620.1 | 32597 | g87581 | i0 | 39.7 | 6.02409638554217 | 58 | 35 | 69.9 | 0 | 174 | 1 | 115 | 172 | KAF4669620.1 hypothetical protein FOZ61_003547 [Perkinsus olseni] | diamond | 1500 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29877737 | 29877737 | PRJNA1067370_P_NODE_11451_length_539_cov_1.673820_g10908_i0 | PRJNA1067370 | 11451 | 539 | 1.67382 | 9.0218898 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 2.07e-14 | NR | XP_002771950.1 | 423536 | g10908 | i0 | 35.7 | 1.02968460111317 | 185 | 99 | 98 | 7 | 534 | 7 | 60 | 233 | XP_002771950.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 555 | 79.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29877746 | 29877746 | PRJNA1067370_P_NODE_15131_length_475_cov_1.915423_g14584_i0 | PRJNA1067370 | 15131 | 475 | 1.915423 | 9.09825925 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 8.37e-9 | NR | XP_002784250.1 | 423536 | g14584 | i0 | 34.2 | 0.941052631578947 | 149 | 87 | 89.7 | 4 | 42 | 467 | 73 | 217 | XP_002784250.1 kelch repeat protein, putative [Perkinsus marinus ATCC 50983] | diamond | 447 | 64.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29909414 | 29909414 | PRJNA1067370_P_NODE_53371_length_290_cov_1.064516_g52822_i0 | PRJNA1067370 | 53371 | 290 | 1.064516 | 3.0870964 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 5.87e-24 | NR | KAF4668158.1 | 330153 | g52822 | i0 | 53.6 | 1.00344827586207 | 97 | 42 | 98.3 | 2 | 288 | 4 | 549 | 644 | KAF4668158.1 Sorl1p [Perkinsus chesapeaki] | diamond | 291 | 105 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29932690 | 29932690 | PRJNA1067370_P_NODE_31631_length_348_cov_3.061818_g31083_i0 | PRJNA1067370 | 31631 | 348 | 3.061818 | 10.65512664 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.24e-5 | NR | XP_002784356.1 | 423536 | g31083 | i0 | 31.5 | 3.86206896551724 | 111 | 72 | 94 | 2 | 337 | 11 | 1 | 109 | XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 1344 | 51.2 | 0.9921875 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 29972447 | 29972447 | PRJNA1067370_P_NODE_63271_length_275_cov_1.143564_g62722_i0 | PRJNA1067370 | 63271 | 275 | 1.143564 | 3.144801 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.48e-7 | NR | KAF4662628.1 | 330153 | g62722 | i0 | 41.9 | 0.807272727272727 | 74 | 41 | 78.5 | 2 | 275 | 60 | 341 | 414 | KAF4662628.1 hypothetical protein FOL47_006168, partial [Perkinsus chesapeaki] | diamond | 222 | 58.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 30848765 | 30848765 | PRJNA1067370_P_NODE_76554_length_255_cov_1.269231_g76005_i0 | PRJNA1067370 | 76554 | 255 | 1.269231 | 3.23653905 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 3.99e-12 | NR | KAF4670880.1 | 32597 | g76005 | i0 | 48 | 6.07058823529412 | 75 | 36 | 87.1 | 2 | 226 | 5 | 508 | 580 | KAF4670880.1 Transcription initiation factor IIB [Perkinsus olseni] | diamond | 1548 | 71.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31394616 | 31394616 | PRJNA1067370_P_NODE_7556_length_652_cov_2.157168_g7032_i0 | PRJNA1067370 | 7556 | 652 | 2.157168 | 14.06473536 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.04e-38 | NR | KAF4675741.1 | 330153 | g7032 | i0 | 38.7 | 4.99233128834356 | 217 | 128 | 98.9 | 3 | 7 | 651 | 748 | 961 | KAF4675741.1 40S ribosomal protein S3-1 [Perkinsus chesapeaki] | diamond | 3255 | 152 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32122153 | 32122153 | PRJNA1067370_P_NODE_17958_length_440_cov_2.095368_g17410_i0 | PRJNA1067370 | 17958 | 440 | 2.095368 | 9.2196192 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 6.819999999999999e-40 | NR | XP_002778264.1 | 423536 | g17410 | i0 | 52.3 | 3.53863636363636 | 128 | 59 | 87.3 | 1 | 439 | 56 | 31 | 156 | XP_002778264.1 RAS small GTpases RIC1/ypt1, putative [Perkinsus marinus ATCC 50983] | diamond | 1557 | 141 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 32375181 | 32375181 | PRJNA1067370_P_NODE_115459_length_241_cov_0.886905_g114910_i0 | PRJNA1067370 | 115459 | 241 | 0.886905 | 2.13744105 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.14e-9 | NR | KAF4744263.1 | 32597 | g114910 | i0 | 58.5 | 0.510373443983402 | 41 | 17 | 51 | 0 | 239 | 117 | 420 | 460 | KAF4744263.1 U4 u6 small nuclear ribonucleoprotein, partial [Perkinsus olseni] | diamond | 123 | 62.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32375192 | 32375192 | PRJNA1067370_P_NODE_17019_length_451_cov_1.629630_g16471_i0 | PRJNA1067370 | 17019 | 451 | 1.62963 | 7.3496313 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.28e-67 | NR | XP_002778466.1 | 423536 | g16471 | i0 | 75.9 | 0.911308203991131 | 137 | 33 | 91.1 | 0 | 36 | 446 | 1 | 137 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 411 | 213 | 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);;