contig_metadata
19 rows where bioproject = "PRJNA715462", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14734342 | 14734342 | PRJNA715462_P_NODE_16672_length_468_cov_4.691139_g15876_i0 | PRJNA715462 | 16672 | 468 | 4.691139 | 21.95453052 | root | 1 | Root_unresolved | Root_unresolved | 225 | 5.88e-65 | NR | KAF4658562.1 | 32597 | g15876 | i0 | 71.1 | 5.83333333333333 | 152 | 42 | 97.4 | 1 | 456 | 1 | 979 | 1128 | KAF4658562.1 hypothetical protein FOL46_006904 [Perkinsus olseni] | diamond | 2730 | 227 | 0.991189427312775 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 18557665 | 18557665 | PRJNA715462_P_NODE_34755_length_300_cov_1.057269_g33959_i0 | PRJNA715462 | 34755 | 300 | 1.057269 | 3.171807 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 5.6e-42 | NR | KAF4672633.1 | 32597 | g33959 | i0 | 69.7 | 6.92 | 99 | 30 | 99 | 0 | 3 | 299 | 337 | 435 | KAF4672633.1 hypothetical protein FOL46_008688 [Perkinsus olseni] | diamond | 2076 | 157 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26608520 | 26608520 | PRJNA715462_P_NODE_50561_length_251_cov_0.865169_g49765_i0 | PRJNA715462 | 50561 | 251 | 0.865169 | 2.17157419 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.38e-25 | NR | KAF4653354.1 | 330153 | g49765 | i0 | 63.4 | 4.56573705179283 | 82 | 29 | 96.8 | 1 | 248 | 6 | 170 | 251 | KAF4653354.1 HIR complex subunit [Perkinsus chesapeaki] | diamond | 1146 | 108 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 26967483 | 26967483 | PRJNA715462_P_NODE_64802_length_243_cov_0.905882_g64006_i0 | PRJNA715462 | 64802 | 243 | 0.905882 | 2.20129326 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.42e-9 | NR | KAF4740959.1 | 32597 | g64006 | i0 | 45.2 | 6.30864197530864 | 73 | 40 | 90.1 | 0 | 240 | 22 | 439 | 511 | KAF4740959.1 Prefoldin subunit 4 [Perkinsus olseni] | diamond | 1533 | 63.5 | 0.995275590551181 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27304909 | 27304909 | PRJNA715462_P_NODE_32463_length_312_cov_0.878661_g31667_i0 | PRJNA715462 | 32463 | 312 | 0.878661 | 2.74142232 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.75e-35 | NR | XP_002777422.1 | 423536 | g31667 | i0 | 60.4 | 3.91346153846154 | 101 | 40 | 97.1 | 0 | 5 | 307 | 161 | 261 | XP_002777422.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 1221 | 137 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27442018 | 27442018 | PRJNA715462_P_NODE_59703_length_246_cov_0.890173_g58907_i0 | PRJNA715462 | 59703 | 246 | 0.890173 | 2.18982558 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 1.7400000000000003e-21 | NR | KAF4720143.1 | 32597 | g58907 | i0 | 56.6 | 19.8658536585366 | 76 | 33 | 92.7 | 0 | 245 | 18 | 175 | 250 | KAF4720143.1 hypothetical protein FOZ62_013313, partial [Perkinsus olseni] | diamond | 4887 | 96.7 | 0.995863495346432 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27557271 | 27557271 | PRJNA715462_P_NODE_64224_length_244_cov_0.900585_g63428_i0 | PRJNA715462 | 64224 | 244 | 0.900585 | 2.1974274 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 2.7000000000000003e-28 | NR | KAF4674614.1 | 330153 | g63428 | i0 | 73.4 | 6.83606557377049 | 79 | 21 | 97.1 | 0 | 242 | 6 | 204 | 282 | KAF4674614.1 hypothetical protein FOL47_009005 [Perkinsus chesapeaki] | diamond | 1668 | 117 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27599799 | 27599799 | PRJNA715462_P_NODE_57824_length_247_cov_0.885057_g57028_i0 | PRJNA715462 | 57824 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 2.49e-6 | NR | KAF4669208.1 | 32597 | g57028 | i0 | 36.7 | 10.7975708502024 | 79 | 47 | 96 | 2 | 2 | 238 | 236 | 311 | KAF4669208.1 hypothetical protein FOZ61_004793 [Perkinsus olseni] | diamond | 2667 | 55.1 | 0.992740471869329 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27620742 | 27620742 | PRJNA715462_P_NODE_38684_length_285_cov_1.231132_g37888_i0 | PRJNA715462 | 38684 | 285 | 1.231132 | 3.5087262 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.5e-11 | NR | KAF4687771.1 | 32597 | g37888 | i0 | 46.2 | 2.05263157894737 | 65 | 35 | 68.4 | 0 | 200 | 6 | 100 | 164 | KAF4687771.1 hypothetical protein FOZ62_004224 [Perkinsus olseni] | diamond | 585 | 70.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27684136 | 27684136 | PRJNA715462_P_NODE_53744_length_249_cov_1.585227_g52948_i0 | PRJNA715462 | 53744 | 249 | 1.585227 | 3.94721523 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 8.15e-6 | NR | KAF4719822.1 | 32597 | g52948 | i0 | 34.8 | 0.795180722891566 | 66 | 43 | 79.5 | 0 | 47 | 244 | 78 | 143 | KAF4719822.1 hypothetical protein FOZ62_009297 [Perkinsus olseni] | diamond | 198 | 51.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29178441 | 29178441 | PRJNA715462_P_NODE_19089_length_427_cov_1.596045_g18293_i0 | PRJNA715462 | 19089 | 427 | 1.596045 | 6.81511215 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.06e-33 | NR | KAF4652412.1 | 32597 | g18293 | i0 | 45.7 | 13.8056206088993 | 140 | 71 | 98.4 | 2 | 8 | 427 | 474 | 608 | KAF4652412.1 Sorl1p [Perkinsus olseni] | diamond | 5895 | 135 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29262265 | 29262265 | PRJNA715462_P_NODE_36829_length_290_cov_1.778802_g36033_i0 | PRJNA715462 | 36829 | 290 | 1.778802 | 5.1585258 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 7.74e-11 | NR | KAF4693773.1 | 32597 | g36033 | i0 | 43.7 | 5.19310344827586 | 87 | 49 | 90 | 0 | 29 | 289 | 49 | 135 | KAF4693773.1 Protein phosphatase PP2A regulatory subunit B [Perkinsus olseni] | diamond | 1506 | 68.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29714697 | 29714697 | PRJNA715462_P_NODE_46910_length_260_cov_2.315508_g46114_i0 | PRJNA715462 | 46910 | 260 | 2.315508 | 6.0203208 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 2.29e-29 | NR | KAF4705659.1 | 32597 | g46114 | i0 | 66.7 | 2.90769230769231 | 84 | 28 | 96.9 | 0 | 252 | 1 | 5 | 88 | KAF4705659.1 X-prolyl aminopeptidase (Aminopeptidase P) [Perkinsus olseni] | diamond | 756 | 121 | 0.991735537190083 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30725950 | 30725950 | PRJNA715462_P_NODE_38514_length_285_cov_1.816038_g37718_i0 | PRJNA715462 | 38514 | 285 | 1.816038 | 5.1757083 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 1.1199999999999999e-38 | NR | KAF4664008.1 | 32597 | g37718 | i0 | 72.3 | 8.81052631578947 | 94 | 26 | 98.9 | 0 | 284 | 3 | 163 | 256 | KAF4664008.1 Neuropathy target esterase [Perkinsus olseni] | diamond | 2511 | 140 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30905121 | 30905121 | PRJNA715462_P_NODE_45954_length_263_cov_1.605263_g45158_i0 | PRJNA715462 | 45954 | 263 | 1.605263 | 4.22184169 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 7.69e-29 | NR | TEB18997.1 | 2494336 | g45158 | i0 | 59.8 | 0.992395437262357 | 87 | 35 | 99.2 | 0 | 261 | 1 | 703 | 789 | TEB18997.1 oxidoreductase [Perkinsus sp. BL_2016] | diamond | 261 | 119 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 31252594 | 31252594 | PRJNA715462_P_NODE_38055_length_287_cov_1.079439_g37259_i0 | PRJNA715462 | 38055 | 287 | 1.079439 | 3.09798993 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 3.48e-9 | NR | KAF4663720.1 | 32597 | g37259 | i0 | 35.1 | 4.05574912891986 | 97 | 35 | 72.1 | 1 | 53 | 259 | 85 | 181 | KAF4663720.1 hypothetical protein FOZ61_001413 [Perkinsus olseni] | diamond | 1164 | 62.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31484784 | 31484784 | PRJNA715462_P_NODE_39056_length_284_cov_1.094787_g38260_i0 | PRJNA715462 | 39056 | 284 | 1.094787 | 3.10919508 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 3.77e-16 | NR | KAF4676510.1 | 330153 | g38260 | i0 | 47.8 | 3.91901408450704 | 92 | 44 | 97.2 | 1 | 284 | 9 | 351 | 438 | KAF4676510.1 hypothetical protein FOL47_005946 [Perkinsus chesapeaki] | diamond | 1113 | 84 | 0.990476190476191 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 31663636 | 31663636 | PRJNA715462_P_NODE_14277_length_521_cov_4.946429_g13482_i0 | PRJNA715462 | 14277 | 521 | 4.946429 | 25.77089509 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 4.52e-16 | NR | XP_002784356.1 | 423536 | g13482 | i0 | 31.8 | 1.5489443378119 | 129 | 88 | 74.3 | 0 | 456 | 70 | 19 | 147 | XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 807 | 81.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 31705980 | 31705980 | PRJNA715462_P_NODE_44357_length_268_cov_1.282051_g43561_i0 | PRJNA715462 | 44357 | 268 | 1.282051 | 3.43589668 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 9.76e-5 | NR | KAF4706403.1 | 32597 | g43561 | i0 | 46.7 | 2.6865671641791 | 60 | 29 | 63.8 | 1 | 264 | 94 | 433 | 492 | KAF4706403.1 hypothetical protein FOZ63_015653 [Perkinsus olseni] | diamond | 720 | 50.4 | 1 | 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);;