contig_metadata
22 rows where bioproject = "PRJNA602115" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1851510 | 1851510 | PRJNA602115_P_NODE_6062_length_258_cov_1.380711_g6037_i0 | PRJNA602115 | 6062 | 258 | 1.380711 | 3.56223438 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 8.099999999999999e-32 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g6037 | i0 | 96.667 | 5.55813953488372 | 90 | 3 | 35 | 0 | 169 | 258 | 1238 | 1149 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 1434 | 150 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 10779917 | 10779917 | PRJNA602115_P_NODE_10909_length_203_cov_0.901408_g10884_i0 | PRJNA602115 | 10909 | 203 | 0.901408 | 1.82985824 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 9.369999999999999e-90 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g10884 | i0 | 97.044 | 3.49753694581281 | 203 | 6 | 100 | 0 | 1 | 203 | 15755 | 15553 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 710 | 342 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 17720785 | 17720785 | PRJNA602115_P_NODE_8254_length_217_cov_1.634615_g8229_i0 | PRJNA602115 | 8254 | 217 | 1.634615 | 3.54711455 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.6499999999999994e-107 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g8229 | i0 | 100 | 99.9907834101382 | 217 | 0 | 100 | 0 | 1 | 217 | 811 | 1027 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 21698 | 401 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 20269356 | 20269356 | PRJNA602115_P_NODE_4756_length_288_cov_1.105727_g4731_i0 | PRJNA602115 | 4756 | 288 | 1.105727 | 3.18449376 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 531 | 2.81e-146 | NTclustered | gi|14495562|gb|L21708.2|PFA34K | 5821 | g4731 | i0 | 100 | 98.1458333333333 | 287 | 0 | 99 | 0 | 1 | 287 | 1025 | 1311 | Plasmodium berghei p23-like protein mRNA, partial cds | blastn | 28266 | 532 | 0.99812030075188 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 22252708 | 22252708 | PRJNA602115_P_NODE_11598_length_201_cov_1.371429_g11573_i0 | PRJNA602115 | 11598 | 201 | 1.371429 | 2.75657229 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 4.28e-30 | NR | KAJ1435056.1 | 483371 | g11573 | i0 | 80.3 | 3.94029850746269 | 66 | 13 | 98.5 | 0 | 3 | 200 | 18 | 83 | KAJ1435056.1 WD40-repeat-containing domain protein [Ochromonadaceae sp. CCMP2298] | diamond | 792 | 115 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 22252864 | 22252864 | PRJNA602115_P_NODE_6618_length_247_cov_1.032258_g6593_i0 | PRJNA602115 | 6618 | 247 | 1.032258 | 2.54967726 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 7.24e-38 | NR | KAJ1443365.1 | 483371 | g6593 | i0 | 98.6 | 1.8582995951417 | 72 | 1 | 87.4 | 0 | 247 | 32 | 10 | 81 | KAJ1443365.1 hypothetical protein B484DRAFT_474516 [Ochromonadaceae sp. CCMP2298] | diamond | 459 | 132 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 26636698 | 26636698 | PRJNA602115_P_NODE_9241_length_208_cov_0.870748_g9216_i0 | PRJNA602115 | 9241 | 208 | 0.870748 | 1.81115584 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 2.54e-11 | NR | KRX04630.1 | 266149 | g9216 | i0 | 55.4 | 0.9375 | 65 | 27 | 92.3 | 2 | 192 | 1 | 211 | 274 | KRX04630.1 hypothetical protein PPERSA_04445 [Pseudocohnilembus persalinus] | diamond | 195 | 68.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 26953210 | 26953210 | PRJNA602115_P_NODE_9602_length_207_cov_0.876712_g9577_i0 | PRJNA602115 | 9602 | 207 | 0.876712 | 1.81479384 | Symbiodinium sp. KB8 | 230985 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.28e-26 | NR | CAE7939593.1 | 230985 | g9577 | i0 | 63.8 | 1 | 69 | 25 | 100 | 0 | 207 | 1 | 57 | 125 | CAE7939593.1 ALAD, partial [Symbiodinium sp. KB8] | diamond | 207 | 103 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. KB8 | |||
| 27061570 | 27061570 | PRJNA602115_P_NODE_8722_length_209_cov_1.445946_g8697_i0 | PRJNA602115 | 8722 | 209 | 1.445946 | 3.02202714 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 7.75e-12 | NR | CAE7269494.1 | 2951 | g8697 | i0 | 59.6 | 11.8564593301435 | 52 | 21 | 74.6 | 0 | 207 | 52 | 44 | 95 | CAE7269494.1 RPL27A [Symbiodinium microadriaticum] | diamond | 2478 | 67 | 0.994029850746269 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 27756854 | 27756854 | PRJNA602115_P_NODE_7224_length_235_cov_1.459770_g7199_i0 | PRJNA602115 | 7224 | 235 | 1.45977 | 3.4304595 | root | 1 | Root_unresolved | Root_unresolved | 122 | 1.6499999999999999e-32 | NR | KAJ1393185.1 | 483371 | g7199 | i0 | 78.2 | 7.96595744680851 | 78 | 17 | 99.6 | 0 | 1 | 234 | 38 | 115 | KAJ1393185.1 peptidase M17, leucyl aminopeptidase, partial [Ochromonadaceae sp. CCMP2298] | diamond | 1872 | 123 | 0.991869918699187 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 27869474 | 27869474 | PRJNA602115_P_NODE_7665_length_228_cov_1.353293_g7640_i0 | PRJNA602115 | 7665 | 228 | 1.353293 | 3.08550804 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 7.22e-20 | NR | CAD8053185.1 | 5886 | g7640 | i0 | 67.2 | 1.60526315789474 | 61 | 20 | 80.3 | 0 | 185 | 3 | 2 | 62 | CAD8053185.1 unnamed protein product [Paramecium primaurelia] | diamond | 366 | 89 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 28248319 | 28248319 | PRJNA602115_P_NODE_6586_length_247_cov_1.537634_g6561_i0 | PRJNA602115 | 6586 | 247 | 1.537634 | 3.79795598 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.95e-30 | NR | KAJ1429413.1 | 483371 | g6561 | i0 | 70.4 | 1.96761133603239 | 81 | 24 | 98.4 | 0 | 245 | 3 | 299 | 379 | KAJ1429413.1 molecular chaperones HSP70/HSC70, HSP70 superfamily [Ochromonadaceae sp. CCMP2298] | diamond | 486 | 122 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28501178 | 28501178 | PRJNA602115_P_NODE_10367_length_205_cov_0.888889_g10342_i0 | PRJNA602115 | 10367 | 205 | 0.888889 | 1.82222245 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 2.2e-10 | NR | KAJ1432993.1 | 483371 | g10342 | i0 | 70.6 | 0.995121951219512 | 68 | 20 | 99.5 | 0 | 1 | 204 | 498 | 565 | KAJ1432993.1 regulator of chromosome condensation 1/beta-lactamase-inhibitor protein II [Ochromonadaceae sp. CCMP2298] | diamond | 204 | 65.5 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28564296 | 28564296 | PRJNA602115_P_NODE_6027_length_259_cov_1.242424_g6002_i0 | PRJNA602115 | 6027 | 259 | 1.242424 | 3.21787816 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 9.9899999999999993e-24 | NR | KAL4475992.1 | 2486642 | g6002 | i0 | 61.6 | 0.996138996138996 | 86 | 31 | 97.3 | 2 | 253 | 2 | 4 | 89 | KAL4475992.1 hypothetical protein ABPG72_007878 [Tetrahymena utriculariae] | diamond | 258 | 97.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 28924690 | 28924690 | PRJNA602115_P_NODE_5888_length_262_cov_1.273632_g5863_i0 | PRJNA602115 | 5888 | 262 | 1.273632 | 3.33691584 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0019 | NR | KAJ1439360.1 | 483371 | g5863 | i0 | 77.8 | 0.824427480916031 | 27 | 6 | 30.9 | 0 | 92 | 172 | 90 | 116 | KAJ1439360.1 60s acidic ribosomal protein-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 216 | 45.1 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29209162 | 29209162 | PRJNA602115_P_NODE_8589_length_212_cov_0.874172_g8564_i0 | PRJNA602115 | 8589 | 212 | 0.874172 | 1.85324464 | Pelagomonadaceae | 3235057 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 1.81e-24 | NR | CAH0377005.1 | 35677 | g8564 | i0 | 72.5 | 4.88207547169811 | 69 | 19 | 97.6 | 0 | 211 | 5 | 450 | 518 | CAH0377005.1 unnamed protein product [Pelagomonas calceolata] | diamond | 1035 | 105 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata | |||
| 29479575 | 29479575 | PRJNA602115_P_NODE_9450_length_207_cov_1.315068_g9425_i0 | PRJNA602115 | 9450 | 207 | 1.315068 | 2.72219076 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 2.2099999999999998e-32 | NR | KAJ1411071.1 | 483371 | g9425 | i0 | 79.7 | 1 | 69 | 14 | 100 | 0 | 207 | 1 | 29 | 97 | KAJ1411071.1 50S ribosomal protein L30e-like protein [Ochromonadaceae sp. CCMP2298] | diamond | 207 | 118 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30333195 | 30333195 | PRJNA602115_P_NODE_7432_length_232_cov_1.122807_g7407_i0 | PRJNA602115 | 7432 | 232 | 1.1228070000000001 | 2.60491224 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0424 | NR | CAD8213220.1 | 43137 | g7407 | i0 | 31.2 | 0.995689655172414 | 77 | 37 | 99.6 | 1 | 231 | 1 | 15 | 75 | CAD8213220.1 unnamed protein product [Paramecium octaurelia] | diamond | 231 | 42.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 30711801 | 30711801 | PRJNA602115_P_NODE_11134_length_203_cov_0.901408_g11109_i0 | PRJNA602115 | 11134 | 203 | 0.901408 | 1.82985824 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 4.12e-14 | NR | ETO09453.1 | 46433 | g11109 | i0 | 58.6 | 0.857142857142857 | 58 | 24 | 85.7 | 0 | 203 | 30 | 265 | 322 | ETO09453.1 hypothetical protein RFI_27925 [Reticulomyxa filosa] | diamond | 174 | 75.9 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 31420433 | 31420433 | PRJNA602115_P_NODE_10696_length_204_cov_0.895105_g10671_i0 | PRJNA602115 | 10696 | 204 | 0.895105 | 1.8260142 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0165 | NR | CAD8189747.1 | 43138 | g10671 | i0 | 39.6 | 1.44117647058824 | 53 | 28 | 76.5 | 2 | 158 | 3 | 999 | 1048 | CAD8189747.1 unnamed protein product [Paramecium pentaurelia] | diamond | 294 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 32261613 | 32261613 | PRJNA602115_P_NODE_3438_length_329_cov_1.093284_g3413_i0 | PRJNA602115 | 3438 | 329 | 1.093284 | 3.59690436 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0417 | NR | XP_067920634.1 | 483139 | g3413 | i0 | 34.9 | 0.78419452887538 | 86 | 48 | 71.1 | 2 | 19 | 252 | 195 | 280 | XP_067920634.1 uncharacterized protein CSUI_007238, partial [Cystoisospora suis] | diamond | 258 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 32306550 | 32306550 | PRJNA602115_P_NODE_5459_length_272_cov_1.213270_g5434_i0 | PRJNA602115 | 5459 | 272 | 1.21327 | 3.3000944 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.85e-36 | NR | CAH0375206.1 | 35677 | g5434 | i0 | 71.9 | 19.8198529411765 | 89 | 25 | 98.2 | 0 | 3 | 269 | 214 | 302 | CAH0375206.1 unnamed protein product [Pelagomonas calceolata] | diamond | 5391 | 136 | 0.992647058823529 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata |
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);;