contig_metadata
17 rows where bioproject = "PRJNA453567", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18293483 | 18293483 | PRJNA453567_P_NODE_235_length_1937_cov_5.711053_g216_i0 | PRJNA453567 | 235 | 1937 | 5.711053 | 110.62309661 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 480 | 5.819999999999998e-161 | NR | KAF4687968.1 | 32597 | g216 | i0 | 55.4 | 12.5064532782654 | 475 | 185 | 72 | 11 | 60 | 1454 | 3 | 460 | KAF4687968.1 Protein transport protein Sec61 subunit alpha [Perkinsus olseni] | diamond | 24225 | 481 | 0.997920997920998 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26791376 | 26791376 | PRJNA453567_P_NODE_20021_length_198_cov_1.105590_g19784_i0 | PRJNA453567 | 20021 | 198 | 1.10559 | 2.1890682 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 4.79e-15 | NR | XP_002777422.1 | 423536 | g19784 | i0 | 54.7 | 0.96969696969697 | 64 | 29 | 97 | 0 | 2 | 193 | 190 | 253 | XP_002777422.1 conserved hypothetical protein [Perkinsus marinus ATCC 50983] | diamond | 192 | 78.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 27044531 | 27044531 | PRJNA453567_P_NODE_18982_length_204_cov_1.041916_g18745_i0 | PRJNA453567 | 18982 | 204 | 1.041916 | 2.12550864 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 4.72e-11 | NR | KAF4661621.1 | 32597 | g18745 | i0 | 49.3 | 4.92647058823529 | 67 | 33 | 97.1 | 1 | 198 | 1 | 3969 | 4035 | KAF4661621.1 hypothetical protein FOZ61_003069 [Perkinsus olseni] | diamond | 1005 | 67.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28339424 | 28339424 | PRJNA453567_P_NODE_20306_length_196_cov_1.635220_g20069_i0 | PRJNA453567 | 20306 | 196 | 1.63522 | 3.2050312 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.96e-16 | NR | KAF4677256.1 | 330153 | g20069 | i0 | 70.2 | 0.719387755102041 | 47 | 14 | 71.9 | 0 | 2 | 142 | 416 | 462 | KAF4677256.1 Cytosolic seryl-tRNA synthetase [Perkinsus chesapeaki] | diamond | 141 | 82.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28370946 | 28370946 | PRJNA453567_P_NODE_17526_length_213_cov_1.772727_g17289_i0 | PRJNA453567 | 17526 | 213 | 1.772727 | 3.77590851 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00996 | NR | KAF4747594.1 | 32597 | g17289 | i0 | 40 | 1.69014084507042 | 60 | 34 | 81.7 | 1 | 202 | 29 | 1127 | 1186 | KAF4747594.1 hypothetical protein FOZ62_014249, partial [Perkinsus olseni] | diamond | 360 | 43.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28844407 | 28844407 | PRJNA453567_P_NODE_16708_length_219_cov_1.615385_g16471_i0 | PRJNA453567 | 16708 | 219 | 1.615385 | 3.53769315 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00225 | NR | KAF4747594.1 | 32597 | g16471 | i0 | 38.3 | 3.23287671232877 | 60 | 35 | 79.5 | 1 | 215 | 42 | 1127 | 1186 | KAF4747594.1 hypothetical protein FOZ62_014249, partial [Perkinsus olseni] | diamond | 708 | 45.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28892176 | 28892176 | PRJNA453567_P_NODE_25908_length_172_cov_1.725926_g25671_i0 | PRJNA453567 | 25908 | 172 | 1.725926 | 2.96859272 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 1.27e-4 | NR | KAF4706967.1 | 32597 | g25671 | i0 | 51.9 | 5.65116279069767 | 54 | 25 | 94.2 | 1 | 164 | 3 | 810 | 862 | KAF4706967.1 COP9 signalosome complex subunit 2 [Perkinsus olseni] | diamond | 972 | 48.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28923810 | 28923810 | PRJNA453567_P_NODE_27128_length_168_cov_1.488550_g26891_i0 | PRJNA453567 | 27128 | 168 | 1.48855 | 2.500764 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 6.15e-4 | NR | KAF4677207.1 | 330153 | g26891 | i0 | 33.3 | 6.53571428571429 | 54 | 36 | 96.4 | 0 | 7 | 168 | 1443 | 1496 | KAF4677207.1 choline dehydrogenase 7 [Perkinsus chesapeaki] | diamond | 1098 | 46.6 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29286509 | 29286509 | PRJNA453567_P_NODE_21529_length_190_cov_1.013072_g21292_i0 | PRJNA453567 | 21529 | 190 | 1.013072 | 1.9248368 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 1.23e-19 | NR | KAF4657466.1 | 330153 | g21292 | i0 | 73.3 | 6.67894736842105 | 60 | 16 | 94.7 | 0 | 181 | 2 | 22 | 81 | KAF4657466.1 DnaJ (Hsp40), sub A, member 4 [Perkinsus chesapeaki] | diamond | 1269 | 91.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29934559 | 29934559 | PRJNA453567_P_NODE_25411_length_174_cov_1.357664_g25174_i0 | PRJNA453567 | 25411 | 174 | 1.357664 | 2.36233536 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 1.39e-12 | NR | KAF4662747.1 | 32597 | g25174 | i0 | 57.9 | 9.82758620689655 | 57 | 24 | 98.3 | 0 | 173 | 3 | 100 | 156 | KAF4662747.1 Caltractin ICL1e [Perkinsus olseni] | diamond | 1710 | 68.9 | 0.995645863570392 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30282281 | 30282281 | PRJNA453567_P_NODE_30332_length_159_cov_1.278689_g30095_i0 | PRJNA453567 | 30332 | 159 | 1.278689 | 2.03311551 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 1.03e-12 | NR | KAF4680848.1 | 32597 | g30095 | i0 | 58.8 | 9.62264150943396 | 51 | 21 | 96.2 | 0 | 2 | 154 | 3247 | 3297 | KAF4680848.1 hypothetical protein FOZ60_012879 [Perkinsus olseni] | diamond | 1530 | 71.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30297780 | 30297780 | PRJNA453567_P_NODE_10872_length_284_cov_1.251012_g10635_i0 | PRJNA453567 | 10872 | 284 | 1.251012 | 3.55287408 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.51e-26 | NR | KAF4665974.1 | 32597 | g10635 | i0 | 65.9 | 10.9647887323944 | 85 | 26 | 86.6 | 1 | 282 | 37 | 1991 | 2075 | KAF4665974.1 hypothetical protein FOL46_003338 [Perkinsus olseni] | diamond | 3114 | 112 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30661036 | 30661036 | PRJNA453567_P_NODE_6133_length_404_cov_2.550409_g5897_i0 | PRJNA453567 | 6133 | 404 | 2.550409 | 10.30365236 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.013 | NR | KAF4654357.1 | 32597 | g5897 | i0 | 43.9 | 5.21287128712871 | 66 | 32 | 49 | 2 | 31 | 228 | 136 | 196 | KAF4654357.1 dual specificity protein kinase yak1 [Perkinsus olseni] | diamond | 2106 | 46.6 | 0.991416309012876 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31514699 | 31514699 | PRJNA453567_P_NODE_16956_length_217_cov_1.872222_g16719_i0 | PRJNA453567 | 16956 | 217 | 1.872222 | 4.06272174 | Perkinsida | 27998 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.59e-23 | NR | KAF4689043.1 | 32597 | g16719 | i0 | 66.2 | 2.93087557603687 | 71 | 24 | 98.2 | 0 | 214 | 2 | 20 | 90 | KAF4689043.1 hypothetical protein FOZ60_002144 [Perkinsus olseni] | diamond | 636 | 103 | 0.990291262135922 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32115633 | 32115633 | PRJNA453567_P_NODE_4718_length_478_cov_2.369615_g4485_i0 | PRJNA453567 | 4718 | 478 | 2.369615 | 11.3267597 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 2.23e-5 | NR | KAF4652944.1 | 330153 | g4485 | i0 | 46.8 | 1.91422594142259 | 62 | 27 | 36.4 | 2 | 175 | 2 | 721 | 780 | KAF4652944.1 Cullin-4A, partial [Perkinsus chesapeaki] | diamond | 915 | 55.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 32605383 | 32605383 | PRJNA453567_P_NODE_6960_length_374_cov_1.851632_g6723_i0 | PRJNA453567 | 6960 | 374 | 1.851632 | 6.92510368 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.63e-33 | NR | KAF4685574.1 | 32597 | g6723 | i0 | 59.6 | 4.5 | 94 | 38 | 75.4 | 0 | 285 | 4 | 107 | 200 | KAF4685574.1 hypothetical protein FOZ62_006760, partial [Perkinsus olseni] | diamond | 1683 | 128 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32731377 | 32731377 | PRJNA453567_P_NODE_30680_length_158_cov_1.289256_g30443_i0 | PRJNA453567 | 30680 | 158 | 1.289256 | 2.03702448 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 6.97e-4 | NR | XP_002777841.1 | 423536 | g30443 | i0 | 50 | 0.873417721518987 | 46 | 19 | 85.4 | 2 | 158 | 24 | 197 | 239 | XP_002777841.1 hypothetical protein Pmar_PMAR008776 [Perkinsus marinus ATCC 50983] | diamond | 138 | 46.2 | 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);;