contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA827593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 821203 | 821203 | PRJNA827593_P_NODE_35421_length_344_cov_1.623616_g35122_i0 | PRJNA827593 | 35421 | 344 | 1.623616 | 5.58523904 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 1.09e-51 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g35122 | i0 | 82.52 | 4.61627906976744 | 246 | 43 | 72 | 0 | 2 | 247 | 46499 | 46744 | Achlya hypogyna mitochondrion, complete genome | blastn | 1588 | 217 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 2097108 | 2097108 | PRJNA827593_P_NODE_60962_length_251_cov_1.713483_g60663_i0 | PRJNA827593 | 60962 | 251 | 1.713483 | 4.30084233 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.89e-4 | NTclustered | gi|698779808|ref|XM_009824646.1| | 112090 | g60663 | i0 | 97.059 | 0.135458167330677 | 34 | 1 | 14 | 0 | 198 | 231 | 578 | 545 | Aphanomyces astaci hypothetical protein mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 2097266 | 2097266 | PRJNA827593_P_NODE_7302_length_828_cov_4.384106_g7033_i0 | PRJNA827593 | 7302 | 828 | 4.384106 | 36.30039768 | Ochromonas sp. SAG 933.10 | 984272 | SAR_Eukaryotes | SAR_Eukaryotes | 1308 | 0 | NTclustered | gi|323690578|gb|GU935637.1| | 984272 | g7033 | i0 | 95.198 | 89.2838164251208 | 833 | 31 | 100 | 7 | 1 | 828 | 1193 | 2021 | Ochromonas sp. SAG 933.10 28S ribosomal RNA gene, partial sequence | blastn | 73927 | 1308 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas sp. SAG 933.10 | |||
| 3372285 | 3372285 | PRJNA827593_P_NODE_52123_length_276_cov_1.418719_g51824_i0 | PRJNA827593 | 52123 | 276 | 1.418719 | 3.91566444 | Undaria pinnatifida | 74381 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.17e-5 | NTclustered | gi|1193824004|gb|KY400176.1| | 74381 | g51824 | i0 | 97.297 | 0.134057971014493 | 37 | 1 | 13 | 0 | 151 | 187 | 211 | 175 | Undaria pinnatifida microsatellite UPN4151 sequence | blastn | 37 | 63.9 | 1 | Eukaryota | Sar | Phaeophyceae | Laminariales | Alariaceae | Undaria | Undaria pinnatifida | |||
| 3780189 | 3780189 | PRJNA827593_P_NODE_13143_length_600_cov_5.106262_g12849_i0 | PRJNA827593 | 13143 | 600 | 5.106262 | 30.637572 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 3.4e-34 | NTclustered | gi|93139321|gb|DQ361206.1| | 127442 | g12849 | i0 | 86.395 | 16.9683333333333 | 147 | 19 | 25 | 1 | 407 | 553 | 614 | 469 | Phytophthora insolita strain MG 41-3 NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial | blastn | 10181 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora insolita | ||
| 5924263 | 5924263 | PRJNA827593_P_NODE_30025_length_378_cov_1.465574_g29726_i0 | PRJNA827593 | 30025 | 378 | 1.465574 | 5.53986972 | Phalacroma oxytoxoides | 447216 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2742502725|gb|PP905714.1| | 447216 | g29726 | i0 | 96.97 | 0.174603174603175 | 33 | 1 | 9 | 0 | 345 | 377 | 1155 | 1187 | Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence | blastn | 66 | 56.5 | 1 | Eukaryota | Sar | Dinophyceae | Dinophysales | Dinophysaceae | Phalacroma | Phalacroma oxytoxoides | |||
| 5924713 | 5924713 | PRJNA827593_P_NODE_56025_length_264_cov_4.575916_g55726_i0 | PRJNA827593 | 56025 | 264 | 4.575916 | 12.08041824 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.5599999999999998e-128 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g55726 | i0 | 98.864 | 82.125 | 264 | 3 | 100 | 0 | 1 | 264 | 4257 | 4520 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 21681 | 472 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 7199041 | 7199041 | PRJNA827593_P_NODE_21026_length_462_cov_2.778920_g20728_i0 | PRJNA827593 | 21026 | 462 | 2.77892 | 12.8386104 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.045 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g20728 | i0 | 100 | 0.0606060606060606 | 28 | 0 | 6 | 0 | 1 | 28 | 13 | 40 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 7199946 | 7199946 | PRJNA827593_P_NODE_7306_length_828_cov_3.249007_g7037_i0 | PRJNA827593 | 7306 | 828 | 3.249007 | 26.90177796 | Eucampia zodiacus | 444606 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 3.5799999999999995e-55 | NTclustered | gi|2026158947|ref|NC_054334.1| | 444606 | g7037 | i0 | 78.329 | 50.1630434782609 | 383 | 64 | 45 | 16 | 454 | 824 | 30221 | 29846 | Eucampia zodiacus strain CNS00060 mitochondrion, complete genome | blastn | 41535 | 230 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Hemiaulales | Hemiaulaceae | Eucampia | Eucampia zodiacus | ||
| 9749456 | 9749456 | PRJNA827593_P_NODE_50488_length_281_cov_2.216346_g50189_i0 | PRJNA827593 | 50488 | 281 | 2.216346 | 6.22793226 | Trieres regia | 1335017 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.9499999999999994e-23 | NTclustered | gi|2055417059|ref|NC_056371.1| | 1335017 | g50189 | i0 | 87.619 | 5.02491103202847 | 105 | 13 | 37 | 0 | 111 | 215 | 4369 | 4473 | Odontella regia mitochondrion, complete genome | blastn | 1412 | 122 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Eupodiscales | Parodontellaceae | Trieres | Trieres regia | ||
| 10156897 | 10156897 | PRJNA827593_P_NODE_37368_length_333_cov_2.346154_g37069_i0 | PRJNA827593 | 37368 | 333 | 2.346154 | 7.81269282 | Heterotrichida | 5957 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.09e-26 | NTclustered | gi|1820251590|gb|MT175584.1| | 219168 | g37069 | i0 | 86.29 | 25.0840840840841 | 124 | 15 | 37 | 2 | 8 | 130 | 749 | 871 | Peritromus kahli isolate CY2018101501 large subunit ribosomal RNA gene, partial sequence | blastn | 8353 | 135 | 0.992592592592593 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Peritromidae | Peritromus | Peritromus kahli | ||
| 11025461 | 11025461 | PRJNA827593_P_NODE_67369_length_242_cov_0.911243_g67070_i0 | PRJNA827593 | 67369 | 242 | 0.911243 | 2.20520806 | Polymyxa graminis | 70182 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.45e-40 | NTclustered | gi|20372910|emb|AJ457970.1| | 70182 | g67070 | i0 | 89.116 | 0.607438016528926 | 147 | 11 | 61 | 5 | 96 | 242 | 367 | 226 | Polymyxa graminis ORF1 DNA for hypothetical protein, clone pgV/4-9 | blastn | 147 | 178 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa graminis | ||
| 11432203 | 11432203 | PRJNA827593_P_NODE_50829_length_280_cov_1.859903_g50530_i0 | PRJNA827593 | 50829 | 280 | 1.859903 | 5.2077284 | Poteriospumella | 1117026 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 9.92e-136 | NTclustered | gi|685431582|gb|KF697341.1| | 1117027 | g50530 | i0 | 98.571 | 53.6214285714286 | 280 | 4 | 100 | 0 | 1 | 280 | 330 | 609 | Poteriospumella lacustris strain JBC07 28S ribosomal RNA gene, partial sequence | blastn | 15014 | 496 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 14849068 | 14849068 | PRJNA827593_P_NODE_2912_length_1370_cov_5.294526_g2712_i0 | PRJNA827593 | 2912 | 1370 | 5.294526 | 72.5350062 | Lithodesmium undulatum | 59812 | SAR_Eukaryotes | SAR_Eukaryotes | 641 | 6.549999999999999e-179 | NTclustered | gi|2088237800|ref|NC_056903.1| | 59812 | g2712 | i0 | 78.178 | 79.7496350364963 | 1054 | 196 | 76 | 28 | 24 | 1060 | 2034 | 3070 | Lithodesmium undulatum mitochondrion, complete genome | blastn | 109257 | 641 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Lithodesmiales | Lithodesmiaceae | Lithodesmium | Lithodesmium undulatum | ||
| 15256283 | 15256283 | PRJNA827593_P_NODE_13052_length_603_cov_3.183019_g12759_i0 | PRJNA827593 | 13052 | 603 | 3.183019 | 19.19360457 | root | 1 | Root_unresolved | Root_unresolved | 1051 | 0 | NTclustered | gi|937182978|gb|KR051079.1| | 5865 | g12759 | i0 | 99.312 | 68.4875621890547 | 581 | 4 | 96 | 0 | 1 | 581 | 3293 | 3873 | Babesia bovis transgenic clone Segment23 elongation factor 1 alpha (ef-1a) gene, complete cds; gfp-bsd gene, complete sequence; and exon | blastn | 41298 | 1057 | 0.994323557237465 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 16123421 | 16123421 | PRJNA827593_P_NODE_16973_length_522_cov_1.494432_g16676_i0 | PRJNA827593 | 16973 | 522 | 1.494432 | 7.80093504 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 7.279999999999998e-115 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g16676 | i0 | 81.992 | 62.2241379310345 | 522 | 77 | 98 | 15 | 10 | 522 | 6586 | 6073 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 32481 | 427 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 16123855 | 16123855 | PRJNA827593_P_NODE_40993_length_316_cov_8.045267_g40694_i0 | PRJNA827593 | 40993 | 316 | 8.045267 | 25.42304372 | Poteriospumella sp. | 2003111 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.0999999999999999e-160 | NTclustered | gi|1209404931|gb|KX442736.1| | 2003111 | g40694 | i0 | 99.684 | 96.0632911392405 | 316 | 1 | 100 | 0 | 1 | 316 | 1444 | 1129 | Poteriospumella sp. strain JBAS36 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 30356 | 579 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella sp. | |||
| 17399785 | 17399785 | PRJNA827593_P_NODE_52614_length_274_cov_2.199005_g52315_i0 | PRJNA827593 | 52614 | 274 | 2.199005 | 6.0252737 | Placocista sp. CC-Grouse Mountain | 741089 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.11e-35 | NTclustered | gi|290760485|gb|GQ144688.1| | 741089 | g52315 | i0 | 89.922 | 44.2846715328467 | 129 | 10 | 63 | 3 | 148 | 274 | 2163 | 2036 | Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence | blastn | 12134 | 163 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Placocista | Placocista sp. CC-Grouse Mountain | ||
| 17805898 | 17805898 | PRJNA827593_P_NODE_34814_length_347_cov_2.032847_g34515_i0 | PRJNA827593 | 34814 | 347 | 2.032847 | 7.05397909 | Bacillariophyceae | 33849 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 5.2e-40 | NTclustered | gi|699008555|ref|NC_024928.1| | 1458866 | g34515 | i0 | 86.792 | 43.2881844380403 | 159 | 21 | 46 | 0 | 165 | 323 | 67547 | 67705 | Eunotia naegelii chloroplast, complete genome | blastn | 15021 | 178 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Eunotiales | Eunotiaceae | Eunotia | Eunotia naegelii | ||
| 19080098 | 19080098 | PRJNA827593_P_NODE_64015_length_246_cov_4.468208_g63716_i0 | PRJNA827593 | 64015 | 246 | 4.468208 | 10.99179168 | Cercozoa | 136419 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 7.82e-17 | NTclustered | gi|2008101406|gb|MW774215.1| | 104657 | g63716 | i0 | 82.203 | 47.2764227642276 | 118 | 19 | 48 | 2 | 63 | 179 | 1783 | 1667 | Wobblia lunata strain NIES-1015 large subunit ribosomal RNA gene, partial sequence | blastn | 11630 | 100 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidiaceae | Wobblia | Wobblia lunata | |||
| 19947758 | 19947758 | PRJNA827593_P_NODE_3876_length_1171_cov_2.469035_g3661_i0 | PRJNA827593 | 3876 | 1171 | 2.469035 | 28.91239985 | Nothophytophthora sp. | 2853999 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 5.070000000000001e-65 | NTclustered | gi|2240249467|gb|MW648547.1| | 2853999 | g3661 | i0 | 81.677 | 23.6618274978651 | 322 | 54 | 27 | 5 | 5 | 325 | 10091 | 10408 | Nothophytophthora sp. culture ICMP:18719 mitochondrion, complete genome | blastn | 27708 | 263 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. | ||
| 21223390 | 21223390 | PRJNA827593_P_NODE_46077_length_296_cov_36.085202_g45778_i0 | PRJNA827593 | 46077 | 296 | 36.085202 | 106.81219792 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.36e-139 | NTclustered | gi|325194239|emb|FR825095.1| | 890382 | g45778 | i0 | 98.611 | 102.060810810811 | 288 | 3 | 97 | 1 | 1 | 288 | 1176 | 890 | Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 | blastn | 30210 | 508 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 22906009 | 22906009 | PRJNA827593_P_NODE_59538_length_255_cov_1.631868_g59239_i0 | PRJNA827593 | 59538 | 255 | 1.631868 | 4.1612634 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 9.49e-91 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g59239 | i0 | 93.191 | 5.62352941176471 | 235 | 16 | 92 | 0 | 1 | 235 | 304 | 70 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1434 | 346 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24180034 | 24180034 | PRJNA827593_P_NODE_48039_length_289_cov_3.194444_g47740_i0 | PRJNA827593 | 48039 | 289 | 3.194444 | 9.23194316 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.21e-137 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g47740 | i0 | 97.931 | 99.2768166089965 | 290 | 5 | 100 | 1 | 1 | 289 | 2667 | 2956 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 28691 | 501 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 25047966 | 25047966 | PRJNA827593_P_NODE_64160_length_246_cov_1.786127_g63861_i0 | PRJNA827593 | 64160 | 246 | 1.786127 | 4.39387242 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 6.889999999999999e-107 | NTclustered | gi|90655144|gb|DQ361265.1| | 907947 | g63861 | i0 | 95.935 | 100 | 246 | 10 | 100 | 0 | 1 | 246 | 520 | 275 | Pythium vexans large subunit ribosomal RNA gene, partial sequence | blastn | 24600 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans |
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);;