contig_metadata
26 rows where bioproject = "PRJNA1145997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1033571 | 1033571 | PRJNA1145997_P_NODE_51261_length_212_cov_11.424460_g48642_i0 | PRJNA1145997 | 51261 | 212 | 11.42446 | 24.2198552 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 5.15e-8 | NTclustered | gi|387177844|gb|JX001492.1| | 400756 | g48642 | i0 | 100 | 7.38207547169811 | 38 | 0 | 18 | 0 | 175 | 212 | 344 | 381 | Durinskia baltica clone C17903 cytochrome oxidase subunit 3 (cox3) pseudogene, partial sequence; mitochondrial | blastn | 1565 | 71.3 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Kryptoperidiniaceae | Durinskia | Durinskia baltica | |||
| 2840258 | 2840258 | PRJNA1145997_P_NODE_33883_length_322_cov_4.995984_g31264_i0 | PRJNA1145997 | 33883 | 322 | 4.995984 | 16.08706848 | Tribonema sp. | 2679974 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 7.35e-98 | NTclustered | gi|2518133535|gb|OQ243223.1| | 2679974 | g31264 | i0 | 88.673 | 94.4689440993789 | 309 | 27 | 94 | 6 | 21 | 322 | 2779 | 3086 | Tribonema sp. strain GXU-A10 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and 28S-18S ribosomal RNA intergenic spacer, complete sequence | blastn | 30419 | 370 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema sp. | |||
| 4116692 | 4116692 | PRJNA1145997_P_NODE_48324_length_243_cov_0.917647_g45705_i0 | PRJNA1145997 | 48324 | 243 | 0.917647 | 2.22988221 | Peronospora arvensis | 162115 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4399999999999996e-118 | NTclustered | gi|23306508|gb|AY035491.1| | 162115 | g45705 | i0 | 99.177 | 99.9259259259259 | 243 | 2 | 100 | 0 | 1 | 243 | 41 | 283 | Peronospora arvensis isolate MG 15-10 large subunit ribosomal RNA gene, partial sequence | blastn | 24282 | 438 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora arvensis | ||
| 7942569 | 7942569 | PRJNA1145997_P_NODE_37547_length_284_cov_7.597156_g34928_i0 | PRJNA1145997 | 37547 | 284 | 7.597156 | 21.57592304 | Stephanodiscus triporus | 2934178 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 3.5e-13 | NR | KAL3776289.1 | 2934178 | g34928 | i0 | 87.5 | 0.422535211267606 | 40 | 5 | 42.3 | 0 | 25 | 144 | 268 | 307 | KAL3776289.1 hypothetical protein ACHAW5_002598 [Stephanodiscus triporus] | diamond | 120 | 73.9 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Stephanodiscus | Stephanodiscus triporus | ||
| 10493109 | 10493109 | PRJNA1145997_P_NODE_33809_length_323_cov_3.704000_g31190_i0 | PRJNA1145997 | 33809 | 323 | 3.704 | 11.96392 | Pfiesteria piscicida | 71001 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 8.1999999999999994e-23 | NTclustered | gi|255965267|gb|FJ599885.1| | 71001 | g31190 | i0 | 93.75 | 0.795665634674923 | 80 | 5 | 25 | 0 | 90 | 169 | 141 | 62 | Pfiesteria piscicida clone Ppi+Rhod_cDNA14 unknown mRNA; mitochondrial | blastn | 257 | 121 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Pfiesteriaceae | Pfiesteria | Pfiesteria piscicida | |||
| 13043387 | 13043387 | PRJNA1145997_P_NODE_50791_length_224_cov_6.185430_g48172_i0 | PRJNA1145997 | 50791 | 224 | 6.18543 | 13.8553632 | Carchesium polypinum | 168244 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.89e-100 | NTclustered | gi|237502307|gb|FJ810403.1| | 168244 | g48172 | i0 | 100 | 91.1339285714286 | 204 | 0 | 91 | 0 | 1 | 204 | 820 | 617 | Carchesium polypinum isolate NR28 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 20414 | 377 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Carchesium | Carchesium polypinum | ||
| 15592364 | 15592364 | PRJNA1145997_P_NODE_34833_length_311_cov_3.071429_g32214_i0 | PRJNA1145997 | 34833 | 311 | 3.071429 | 9.55214419 | Pfiesteria-like sp. HR1SSeptA5 | 290075 | SAR_Eukaryotes | SAR_Eukaryotes | 523 | 5.1199999999999984e-144 | NTclustered | gi|51847969|gb|AY590483.1| | 290075 | g32214 | i0 | 99.308 | 92.2797427652733 | 289 | 2 | 93 | 0 | 2 | 290 | 2753 | 2465 | Pfiesteria-like sp. HR1SSeptA5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28699 | 523 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Pfiesteriaceae | Pfiesteria-like sp. HR1SSeptA5 | ||||
| 16335889 | 16335889 | PRJNA1145997_P_NODE_34753_length_312_cov_3.506276_g32134_i0 | PRJNA1145997 | 34753 | 312 | 3.506276 | 10.93958112 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 9.11e-102 | NTclustered | gi|1591473363|gb|MH286884.1| | 4787 | g32134 | i0 | 90.378 | 65.2467948717949 | 291 | 28 | 93 | 0 | 22 | 312 | 18125 | 18415 | Phytophthora infestans mitochondrion, complete genome | blastn | 20357 | 383 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 16335995 | 16335995 | PRJNA1145997_P_NODE_50013_length_234_cov_16.745342_g47394_i0 | PRJNA1145997 | 50013 | 234 | 16.745342 | 39.18410028 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|1673118409|ref|XM_029364605.1| | 94643 | g47394 | i0 | 100 | 4.18803418803419 | 28 | 0 | 12 | 0 | 15 | 42 | 195 | 168 | Besnoitia besnoiti uncharacterized protein (BESB_061910), partial mRNA | blastn | 980 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 16866558 | 16866558 | PRJNA1145997_P_NODE_32454_length_341_cov_9.473881_g29835_i0 | PRJNA1145997 | 32454 | 341 | 9.473881 | 32.30593421 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.93e-4 | NTclustered | gi|820700576|tpe|LN714500.1| | 432359 | g29835 | i0 | 100 | 0.483870967741935 | 31 | 0 | 9 | 0 | 302 | 332 | 3259770 | 3259800 | TPA_asm: Toxoplasma gondii VEG, chromosome chrX, complete genome | blastn | 165 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 18140919 | 18140919 | PRJNA1145997_P_NODE_22235_length_614_cov_14.909427_g19634_i0 | PRJNA1145997 | 22235 | 614 | 14.909427 | 91.54388178 | Bilabrum cf. latius | 3115832 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.005 | NTclustered | gi|2918369598|emb|OZ237764.1| | 3115832 | g19634 | i0 | 96.97 | 0.498371335504886 | 33 | 1 | 5 | 0 | 16 | 48 | 640594 | 640562 | Bilabrum cf. latius genome assembly, chromosome: 30 | blastn | 306 | 56.5 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Bilabrum | Bilabrum cf. latius | ||||
| 18141017 | 18141017 | PRJNA1145997_P_NODE_25895_length_490_cov_4.796163_g23279_i0 | PRJNA1145997 | 25895 | 490 | 4.796163 | 23.5011987 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 7.34e-39 | NR | KAF4142888.1 | 4787 | g23279 | i0 | 92.4 | 3.64285714285714 | 66 | 5 | 40.4 | 0 | 11 | 208 | 166 | 231 | KAF4142888.1 Rieske [2Fe-2S] domain, partial [Phytophthora infestans] | diamond | 1785 | 143 | 0.993006993006993 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 18884950 | 18884950 | PRJNA1145997_P_NODE_24055_length_550_cov_3.733753_g21444_i0 | PRJNA1145997 | 24055 | 550 | 3.733753 | 20.5356415 | Discostella pseudostelligera | 259834 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 4.9900000000000003e-36 | NR | KAL3760366.1 | 259834 | g21444 | i0 | 63.7 | 0.556363636363636 | 102 | 37 | 55.6 | 0 | 548 | 243 | 354 | 455 | KAL3760366.1 LOW QUALITY PROTEIN: hypothetical protein ACHAWU_000341 [Discostella pseudostelligera] | diamond | 306 | 142 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Discostella | Discostella pseudostelligera | ||
| 18885143 | 18885143 | PRJNA1145997_P_NODE_51395_length_209_cov_11.022059_g48776_i0 | PRJNA1145997 | 51395 | 209 | 11.022059 | 23.03610331 | Poteriospumella | 1117026 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.09e-91 | NTclustered | gi|685431582|gb|KF697341.1| | 1117027 | g48776 | i0 | 100 | 72.6985645933014 | 188 | 0 | 90 | 0 | 22 | 209 | 93 | 280 | Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence | blastn | 15194 | 348 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 21966268 | 21966268 | PRJNA1145997_P_NODE_32518_length_340_cov_14.509363_g29899_i0 | PRJNA1145997 | 32518 | 340 | 14.509363 | 49.3318342 | Ceratium furcoides | 1186198 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.6699999999999995e-104 | NTclustered | gi|387768997|gb|JQ639748.1| | 1186198 | g29899 | i0 | 91.349 | 93.9058823529412 | 289 | 21 | 84 | 3 | 52 | 338 | 8 | 294 | Ceratium furcoides voucher HBI:SC201002a large subunit ribosomal RNA gene, partial sequence | blastn | 31928 | 392 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Ceratiaceae | Ceratium | Ceratium furcoides | |||
| 24515294 | 24515294 | PRJNA1145997_P_NODE_32720_length_337_cov_5.443182_g30101_i0 | PRJNA1145997 | 32720 | 337 | 5.443182 | 18.34352334 | uncultured dinoflagellate | 187300 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 4.96e-50 | NTclustered | gi|309255479|gb|GU555415.1| | 187300 | g30101 | i0 | 80.615 | 0.964391691394659 | 325 | 19 | 94 | 9 | 17 | 334 | 1250 | 1537 | uncultured dinoflagellate clone ML2-17 mRNA sequence | blastn | 325 | 211 | 1 | Eukaryota | Sar | Dinophyceae | uncultured dinoflagellate | ||||||
| 27007135 | 27007135 | PRJNA1145997_P_NODE_24722_length_528_cov_4.540659_g22107_i0 | PRJNA1145997 | 24722 | 528 | 4.540659 | 23.97467952 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 2.11e-16 | NR | KAJ8525733.1 | 4785 | g22107 | i0 | 29.9 | 0.875 | 154 | 99 | 87.5 | 2 | 27 | 488 | 29 | 173 | KAJ8525733.1 hypothetical protein ON010_g15381 [Phytophthora cinnamomi] | diamond | 462 | 83.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 27249099 | 27249099 | PRJNA1145997_P_NODE_26783_length_462_cov_7.336761_g24166_i0 | PRJNA1145997 | 26783 | 462 | 7.336761 | 33.89583582 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.42e-4 | NR | CAE8650303.1 | 89957 | g24166 | i0 | 60 | 1.15584415584416 | 45 | 18 | 29.2 | 0 | 211 | 77 | 219 | 263 | CAE8650303.1 unnamed protein product, partial [Polarella glacialis] | diamond | 534 | 50.4 | 0.994047619047619 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 27639423 | 27639423 | PRJNA1145997_P_NODE_41204_length_258_cov_14.210811_g38585_i0 | PRJNA1145997 | 41204 | 258 | 14.210811 | 36.66389238 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 6.13e-17 | NR | CAE8593357.1 | 89957 | g38585 | i0 | 74.5 | 1.18604651162791 | 51 | 13 | 59.3 | 0 | 235 | 83 | 322 | 372 | CAE8593357.1 unnamed protein product [Polarella glacialis] | diamond | 306 | 84.3 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 29470228 | 29470228 | PRJNA1145997_P_NODE_49890_length_236_cov_3.006135_g47271_i0 | PRJNA1145997 | 49890 | 236 | 3.006135 | 7.0944786 | Symbiodinium pilosum | 2952 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 8.22e-7 | NR | CAE7727213.1 | 2952 | g47271 | i0 | 74.3 | 0.877118644067797 | 35 | 9 | 44.5 | 0 | 215 | 111 | 294 | 328 | CAE7727213.1 MMDHI [Symbiodinium pilosum] | diamond | 207 | 55.8 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium pilosum | |||
| 29975793 | 29975793 | PRJNA1145997_P_NODE_49691_length_238_cov_4.272727_g47072_i0 | PRJNA1145997 | 49691 | 238 | 4.272727 | 10.16909026 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.22e-4 | NR | XP_067795723.1 | 4785 | g47072 | i0 | 65.6 | 1.21008403361345 | 32 | 11 | 40.3 | 0 | 236 | 141 | 25 | 56 | XP_067795723.1 putative 26S proteasome non-ATPase regulatory subunit [Phytophthora cinnamomi] | diamond | 288 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30153980 | 30153980 | PRJNA1145997_P_NODE_22172_length_617_cov_6.452206_g19571_i0 | PRJNA1145997 | 22172 | 617 | 6.452206 | 39.81011102 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.53e-26 | NR | OQS05774.1 | 74557 | g19571 | i0 | 43.8 | 3.51539708265802 | 112 | 43 | 54.5 | 3 | 490 | 155 | 8 | 99 | OQS05774.1 RING-box protein 1 [Thraustotheca clavata] | diamond | 2169 | 108 | 0.990740740740741 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30196782 | 30196782 | PRJNA1145997_P_NODE_51432_length_209_cov_4.580882_g48813_i0 | PRJNA1145997 | 51432 | 209 | 4.580882 | 9.57404338 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.39e-8 | NR | CAE8699079.1 | 89957 | g48813 | i0 | 78.4 | 0.5311004784689 | 37 | 8 | 53.1 | 0 | 27 | 137 | 202 | 238 | CAE8699079.1 unnamed protein product [Polarella glacialis] | diamond | 111 | 59.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 30312760 | 30312760 | PRJNA1145997_P_NODE_30172_length_381_cov_19.191558_g27554_i0 | PRJNA1145997 | 30172 | 381 | 19.191558 | 73.11983598 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 0.00428 | NR | CAK0898487.1 | 89957 | g27554 | i0 | 33.3 | 1.75590551181102 | 72 | 48 | 56.7 | 0 | 278 | 63 | 2016 | 2087 | CAK0898487.1 unnamed protein product [Polarella glacialis] | diamond | 669 | 47.8 | 0.99163179916318 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 30375854 | 30375854 | PRJNA1145997_P_NODE_25132_length_515_cov_6.436652_g22516_i0 | PRJNA1145997 | 25132 | 515 | 6.436652 | 33.1487578 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 9.77e-36 | NR | POM57551.1 | 4796 | g22516 | i0 | 58.4 | 2.60970873786408 | 113 | 47 | 65.8 | 0 | 437 | 99 | 1 | 113 | POM57551.1 Serine protease family S28, partial [Phytophthora palmivora] | diamond | 1344 | 138 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 30596432 | 30596432 | PRJNA1145997_P_NODE_23433_length_573_cov_3.592000_g20825_i0 | PRJNA1145997 | 23433 | 573 | 3.592 | 20.58216 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 9.84e-53 | NR | KAJ0392104.1 | 114742 | g20825 | i0 | 50 | 11.3612565445026 | 182 | 82 | 95.3 | 1 | 2 | 547 | 4 | 176 | KAJ0392104.1 hypothetical protein P43SY_009801 [Pythium insidiosum] | diamond | 6510 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum |
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);;