contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA784298" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2041277 | 2041277 | PRJNA784298_P_NODE_23982_length_250_cov_1.129944_g23781_i0 | PRJNA784298 | 23982 | 250 | 1.129944 | 2.82486 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.91e-122 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g23781 | i0 | 99.2 | 103.388 | 250 | 2 | 100 | 0 | 1 | 250 | 14891 | 14642 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 25847 | 451 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 2041390 | 2041390 | PRJNA784298_P_NODE_7922_length_447_cov_4.318182_g7721_i0 | PRJNA784298 | 7922 | 447 | 4.318182 | 19.30227354 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 793 | 0 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g7721 | i0 | 98.661 | 81.1834451901566 | 448 | 5 | 100 | 1 | 1 | 447 | 611 | 164 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 36289 | 793 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 4593776 | 4593776 | PRJNA784298_P_NODE_9904_length_399_cov_2.671779_g9703_i0 | PRJNA784298 | 9904 | 399 | 2.671779 | 10.66039821 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g9703 | i0 | 97.264 | 108.666666666667 | 402 | 7 | 100 | 2 | 1 | 399 | 6323 | 5923 | Achlya hypogyna mitochondrion, complete genome | blastn | 43358 | 678 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 6317133 | 6317133 | PRJNA784298_P_NODE_11425_length_370_cov_25.771044_g11224_i0 | PRJNA784298 | 11425 | 370 | 25.771044 | 95.3528628 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g11224 | i0 | 99.73 | 99.9108108108108 | 370 | 1 | 100 | 0 | 1 | 370 | 720 | 351 | Aphanomyces stellatus strain GF 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 | 36967 | 684 | 0.991228070175439 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 6317282 | 6317282 | PRJNA784298_P_NODE_28165_length_223_cov_19.600000_g27964_i0 | PRJNA784298 | 28165 | 223 | 19.6 | 43.708 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.17e-14 | NTclustered | gi|220983376|dbj|AB453012.1| | 552662 | g27964 | i0 | 93.651 | 3.87443946188341 | 63 | 3 | 28 | 1 | 2 | 63 | 3610 | 3548 | Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 864 | 93.5 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. YPF501 | ||||||
| 8418555 | 8418555 | PRJNA784298_P_NODE_3647_length_668_cov_2.438655_g3451_i0 | PRJNA784298 | 3647 | 668 | 2.438655 | 16.2902154 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 966 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g3451 | i0 | 92.836 | 62.2065868263473 | 670 | 43 | 100 | 4 | 1 | 668 | 1965 | 1299 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 41554 | 966 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 10141865 | 10141865 | PRJNA784298_P_NODE_25868_length_244_cov_0.900585_g25667_i0 | PRJNA784298 | 25868 | 244 | 0.900585 | 2.1974274 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.9499999999999992e-87 | NTclustered | gi|1770647996|gb|MK941864.1| | 101203 | g25667 | i0 | 91.393 | 85.0901639344262 | 244 | 21 | 100 | 0 | 1 | 244 | 33 | 276 | Saprolegnia parasitica isolate S2 cytochrome c oxidase subunit II (Cox2) gene, partial cds; mitochondrial | blastn | 20762 | 335 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10969432 | 10969432 | PRJNA784298_P_NODE_17689_length_295_cov_1.090090_g17488_i0 | PRJNA784298 | 17689 | 295 | 1.09009 | 3.2157655 | Ochromonas danica | 2986 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 4.52e-10 | NTclustered | gi|11465862|ref|NC_002571.1| | 2986 | g17488 | i0 | 86.301 | 0.247457627118644 | 73 | 8 | 24 | 2 | 91 | 162 | 32869 | 32798 | Ochromonas danica mitochondrion, complete genome | blastn | 73 | 78.7 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 12244856 | 12244856 | PRJNA784298_P_NODE_14390_length_328_cov_3.890196_g14189_i0 | PRJNA784298 | 14390 | 328 | 3.890196 | 12.75984288 | Wilsoniana portulacae | 572137 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.249999999999998e-169 | NTclustered | gi|210164195|gb|EU826120.1| | 572137 | g14189 | i0 | 100 | 18.7560975609756 | 328 | 0 | 100 | 0 | 1 | 328 | 344 | 671 | Wilsoniana portulacae strain HUH 640 large subunit ribosomal RNA gene, partial sequence | blastn | 6152 | 606 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Wilsoniana | Wilsoniana portulacae | ||
| 12244951 | 12244951 | PRJNA784298_P_NODE_2310_length_837_cov_5.560209_g2130_i0 | PRJNA784298 | 2310 | 837 | 5.560209 | 46.53894933 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 1338 | 0 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g2130 | i0 | 95.59 | 27.5925925925926 | 839 | 29 | 100 | 7 | 1 | 837 | 2781 | 1949 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 23095 | 1338 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 12245002 | 12245002 | PRJNA784298_P_NODE_28150_length_225_cov_5.085526_g27949_i0 | PRJNA784298 | 28150 | 225 | 5.085526 | 11.4424335 | Stramenopiles sp. MAST-1C-sp1 | 2805718 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 1.19e-9 | NTclustered | gi|1960721522|gb|MW521824.1| | 2805718 | g27949 | i0 | 83.133 | 0.368888888888889 | 83 | 14 | 37 | 0 | 138 | 220 | 5519 | 5601 | Stramenopiles sp. MAST-1C-sp1 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 | 83 | 76.8 | 1 | Eukaryota | Sar | Stramenopiles sp. MAST-1C-sp1 | |||||||
| 12245079 | 12245079 | PRJNA784298_P_NODE_910_length_1362_cov_10.416602_g798_i0 | PRJNA784298 | 910 | 1362 | 10.416602 | 141.87411924 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 2169 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g798 | i0 | 95.401 | 107.412628487518 | 1370 | 49 | 100 | 14 | 1 | 1362 | 3075 | 1712 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 146296 | 2169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13519255 | 13519255 | PRJNA784298_P_NODE_6391_length_501_cov_2.593458_g6191_i0 | PRJNA784298 | 6391 | 501 | 2.593458 | 12.99322458 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 926 | 0 | NTclustered | gi|1186441155|gb|KY989960.1| | 1982524 | g6191 | i0 | 100 | 99.3872255489022 | 501 | 0 | 100 | 0 | 1 | 501 | 211 | 711 | Aphanomyces sp. isolate CNUaq 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 | 49793 | 926 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 16516189 | 16516189 | PRJNA784298_P_NODE_25953_length_243_cov_22.511765_g25752_i0 | PRJNA784298 | 25953 | 243 | 22.511765 | 54.70358895 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.66e-116 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g25752 | i0 | 99.16 | 88.6954732510288 | 238 | 2 | 98 | 0 | 1 | 238 | 402 | 165 | Aphanomyces euteiches cDNA | blastn | 21553 | 433 | 0.990762124711316 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 17343500 | 17343500 | PRJNA784298_P_NODE_14334_length_329_cov_3.851562_g14133_i0 | PRJNA784298 | 14334 | 329 | 3.851562 | 12.671638980000001 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 3.3099999999999994e-136 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14133 | i0 | 93.939 | 37.9088145896657 | 330 | 18 | 100 | 2 | 1 | 329 | 358 | 30 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 12472 | 497 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17343647 | 17343647 | PRJNA784298_P_NODE_27694_length_231_cov_2.202532_g27493_i0 | PRJNA784298 | 27694 | 231 | 2.202532 | 5.08784892 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.37e-113 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g27493 | i0 | 99.567 | 92.7792207792208 | 231 | 1 | 100 | 0 | 1 | 231 | 1867 | 2097 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 21432 | 422 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 18616943 | 18616943 | PRJNA784298_P_NODE_24615_length_248_cov_0.880000_g24414_i0 | PRJNA784298 | 24615 | 248 | 0.88 | 2.1824 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.13e-124 | NTclustered | gi|166046598|emb|CU367715.1| | 100861 | g24414 | i0 | 100 | 99.7620967741936 | 248 | 0 | 100 | 0 | 1 | 248 | 126 | 373 | Aphanomyces euteiches cDNA | blastn | 24741 | 459 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19892064 | 19892064 | PRJNA784298_P_NODE_11296_length_372_cov_5.735786_g11095_i0 | PRJNA784298 | 11296 | 372 | 5.735786 | 21.33712392 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 688 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g11095 | i0 | 100 | 1 | 372 | 0 | 100 | 0 | 1 | 372 | 401 | 772 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 372 | 688 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19892065 | 19892065 | PRJNA784298_P_NODE_1136_length_1222_cov_5.310705_g1010_i0 | PRJNA784298 | 1136 | 1222 | 5.310705 | 64.8968151 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 1670 | 0 | NTclustered | gi|11466252|ref|NC_000862.1| | 5908 | g1010 | i0 | 91.368 | 58.8011456628478 | 1228 | 95 | 99 | 10 | 2 | 1222 | 32604 | 33827 | Tetrahymena pyriformis mitochondrion, complete genome | blastn | 71855 | 1670 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 19892105 | 19892105 | PRJNA784298_P_NODE_15436_length_317_cov_1.110656_g15235_i0 | PRJNA784298 | 15436 | 317 | 1.110656 | 3.52077952 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 7.319999999999998e-88 | NTclustered | gi|118379397|ref|XM_001022864.1| | 312017 | g15235 | i0 | 85.893 | 1.00630914826498 | 319 | 41 | 100 | 4 | 1 | 317 | 168 | 484 | Tetrahymena thermophila SB210 60S ribosomal protein L13 partial mRNA | blastn | 319 | 337 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19892216 | 19892216 | PRJNA784298_P_NODE_25496_length_245_cov_0.895349_g25295_i0 | PRJNA784298 | 25496 | 245 | 0.895349 | 2.19360505 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 5.38e-98 | NTclustered | gi|673039884|ref|XM_008875681.1| | 157072 | g25295 | i0 | 93.878 | 47.269387755102 | 245 | 15 | 100 | 0 | 1 | 245 | 266 | 510 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 11581 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 23718166 | 23718166 | PRJNA784298_P_NODE_20839_length_269_cov_17.653061_g20638_i0 | PRJNA784298 | 20839 | 269 | 17.653061 | 47.48673409 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 4.66e-94 | NTclustered | gi|829158923|ref|XM_012796529.1| | 312017 | g20638 | i0 | 96.729 | 3.46468401486989 | 214 | 7 | 80 | 0 | 9 | 222 | 50 | 263 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 932 | 357 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23718235 | 23718235 | PRJNA784298_P_NODE_26799_length_241_cov_0.916667_g26598_i0 | PRJNA784298 | 26799 | 241 | 0.916667 | 2.20916747 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1843575955|ref|XM_034567978.1| | 5823 | g26598 | i0 | 100 | 0.240663900414938 | 30 | 0 | 12 | 0 | 196 | 225 | 1855 | 1884 | Plasmodium berghei ANKA clathrin adaptor domain-containing protein, putative (PBANKA_1459400), partial mRNA | blastn | 58 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 24164804 | 24164804 | PRJNA784298_P_NODE_14899_length_322_cov_11.746988_g14698_i0 | PRJNA784298 | 14899 | 322 | 11.746988 | 37.82530136 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 2.41e-162 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g14698 | i0 | 99.379 | 88.4503105590062 | 322 | 2 | 100 | 0 | 1 | 322 | 1597 | 1918 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 28481 | 584 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis |
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);;