contig_metadata
13 rows where bioproject = "PRJNA1118794", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2780946 | 2780946 | PRJNA1118794_P_NODE_15983_length_367_cov_2.625850_g15233_i0 | PRJNA1118794 | 15983 | 367 | 2.62585 | 9.6368695 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 5.07e-43 | NR | XP_002778466.1 | 423536 | g15233 | i0 | 66.4 | 0.923705722070845 | 113 | 38 | 92.4 | 0 | 28 | 366 | 1 | 113 | XP_002778466.1 cyclophilin, putative [Perkinsus marinus ATCC 50983] | diamond | 339 | 149 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 2781221 | 2781221 | PRJNA1118794_P_NODE_37563_length_274_cov_1.383085_g36813_i0 | PRJNA1118794 | 37563 | 274 | 1.383085 | 3.7896529 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 6.529999999999999e-24 | NR | XP_002771800.1 | 423536 | g36813 | i0 | 68.7 | 1.46715328467153 | 67 | 21 | 73.4 | 0 | 273 | 73 | 772 | 838 | XP_002771800.1 elongation factor 2, putative [Perkinsus marinus ATCC 50983] | diamond | 402 | 105 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 6608755 | 6608755 | PRJNA1118794_P_NODE_40086_length_268_cov_5.466667_g39336_i0 | PRJNA1118794 | 40086 | 268 | 5.466667 | 14.65066756 | Phaeophyceae | 2870 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 2.71e-10 | NR | KAF4678364.1 | 330153 | g39336 | i0 | 51.7 | 3.21268656716418 | 60 | 29 | 67.2 | 0 | 190 | 11 | 387 | 446 | KAF4678364.1 ubiquitin-conjugating enzyme E2 Ze [Perkinsus chesapeaki] | diamond | 861 | 66.6 | 0.993993993993994 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 26688209 | 26688209 | PRJNA1118794_P_NODE_59241_length_247_cov_0.885057_g58491_i0 | PRJNA1118794 | 59241 | 247 | 0.885057 | 2.18609079 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.45e-8 | NR | KAF4733337.1 | 32597 | g58491 | i0 | 48.4 | 0.777327935222672 | 64 | 30 | 75.3 | 2 | 200 | 15 | 111 | 173 | KAF4733337.1 hypothetical protein FOZ62_006153 [Perkinsus olseni] | diamond | 192 | 60.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26719518 | 26719518 | PRJNA1118794_P_NODE_52581_length_249_cov_5.028409_g51831_i0 | PRJNA1118794 | 52581 | 249 | 5.028409 | 12.52073841 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 2.19e-13 | NR | KAF4689868.1 | 32597 | g51831 | i0 | 53.6 | 4.04819277108434 | 56 | 26 | 67.5 | 0 | 2 | 169 | 762 | 817 | KAF4689868.1 hypothetical protein FOZ60_001061 [Perkinsus olseni] | diamond | 1008 | 74.7 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27857663 | 27857663 | PRJNA1118794_P_NODE_30125_length_292_cov_1.406393_g29375_i0 | PRJNA1118794 | 30125 | 292 | 1.406393 | 4.10666756 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.0899999999999998e-28 | NR | KAF4729287.1 | 32597 | g29375 | i0 | 55.7 | 3.94520547945205 | 88 | 39 | 90.4 | 0 | 10 | 273 | 25 | 112 | KAF4729287.1 hypothetical protein FOZ63_024682, partial [Perkinsus olseni] | diamond | 1152 | 108 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29184020 | 29184020 | PRJNA1118794_P_NODE_16849_length_360_cov_1.243902_g16099_i0 | PRJNA1118794 | 16849 | 360 | 1.243902 | 4.4780472 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.64e-33 | NR | KAF4650290.1 | 32597 | g16099 | i0 | 66.7 | 2.4 | 96 | 31 | 79.2 | 1 | 357 | 73 | 20 | 115 | KAF4650290.1 60S ribosomal protein L6 [Perkinsus olseni] | diamond | 864 | 124 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29278441 | 29278441 | PRJNA1118794_P_NODE_58709_length_247_cov_0.885057_g57959_i0 | PRJNA1118794 | 58709 | 247 | 0.885057 | 2.18609079 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 2.52e-6 | NR | KAF4661184.1 | 32597 | g57959 | i0 | 66.7 | 0.801619433198381 | 33 | 11 | 40.1 | 0 | 125 | 223 | 77 | 109 | KAF4661184.1 hypothetical protein FOZ61_003450 [Perkinsus olseni] | diamond | 198 | 53.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 29783693 | 29783693 | PRJNA1118794_P_NODE_29271_length_295_cov_1.779279_g28521_i0 | PRJNA1118794 | 29271 | 295 | 1.779279 | 5.24887305 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 2.96e-5 | NR | TEB19254.1 | 2494336 | g28521 | i0 | 42.9 | 0.640677966101695 | 63 | 36 | 64.1 | 0 | 263 | 75 | 138 | 200 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 189 | 52 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 | |||
| 30004994 | 30004994 | PRJNA1118794_P_NODE_7231_length_522_cov_3.184855_g6491_i0 | PRJNA1118794 | 7231 | 522 | 3.184855 | 16.6249431 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 4.93e-15 | NR | XP_002784356.1 | 423536 | g6491 | i0 | 32 | 2.29885057471264 | 147 | 96 | 83.3 | 2 | 505 | 71 | 1 | 145 | XP_002784356.1 ubiquitin, putative [Perkinsus marinus ATCC 50983] | diamond | 1200 | 79 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30573358 | 30573358 | PRJNA1118794_P_NODE_75413_length_230_cov_3.350318_g74663_i0 | PRJNA1118794 | 75413 | 230 | 3.350318 | 7.7057314 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 2.88e-12 | NR | KAF4693773.1 | 32597 | g74663 | i0 | 71.4 | 3.19565217391304 | 49 | 14 | 63.9 | 0 | 81 | 227 | 50 | 98 | KAF4693773.1 Protein phosphatase PP2A regulatory subunit B [Perkinsus olseni] | diamond | 735 | 71.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32154518 | 32154518 | PRJNA1118794_P_NODE_26578_length_307_cov_0.974359_g25828_i0 | PRJNA1118794 | 26578 | 307 | 0.974359 | 2.99128213 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 1.25e-7 | NR | KAF4670609.1 | 330153 | g25828 | i0 | 37.5 | 0.938110749185668 | 96 | 50 | 90.9 | 5 | 286 | 8 | 607 | 695 | KAF4670609.1 hypothetical protein FOL47_001932 [Perkinsus chesapeaki] | diamond | 288 | 59.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32249744 | 32249744 | PRJNA1118794_P_NODE_14118_length_385_cov_1.592949_g13368_i0 | PRJNA1118794 | 14118 | 385 | 1.592949 | 6.13285365 | Perkinsus sp. BL_2 | 28001 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 8.93e-17 | NR | TEB19254.1 | 2494336 | g13368 | i0 | 43.9 | 1.02857142857143 | 132 | 66 | 96.6 | 2 | 13 | 384 | 44 | 175 | TEB19254.1 hypothetical protein C9890_0250 [Perkinsus sp. BL_2016] | diamond | 396 | 84.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus sp. BL_2016 |
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);;