contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA380416" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 402053 | 402053 | PRJNA380416_P_NODE_361_length_1062_cov_3.169793_g280_i0 | PRJNA380416 | 361 | 1062 | 3.169793 | 33.66320166 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 1720 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g280 | i0 | 98.463 | 35.9736346516008 | 976 | 15 | 92 | 0 | 87 | 1062 | 1238 | 263 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 38204 | 1720 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 402056 | 402056 | PRJNA380416_P_NODE_5561_length_246_cov_1.030457_g5414_i0 | PRJNA380416 | 5561 | 246 | 1.030457 | 2.53492422 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g5414 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 460 | 215 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 246 | 455 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 1074160 | 1074160 | PRJNA380416_P_NODE_1481_length_502_cov_7.960265_g1336_i0 | PRJNA380416 | 1481 | 502 | 7.960265 | 39.9605303 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 917 | 0 | NTclustered | gi|1409222726|gb|MH536660.1| | 88167 | g1336 | i0 | 99.602 | 98.9083665338645 | 503 | 1 | 100 | 1 | 1 | 502 | 1759 | 1257 | Poterioochromonas malhamensis strain CMBB008 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 49652 | 917 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 1676772 | 1676772 | PRJNA380416_P_NODE_1942_length_437_cov_3.048969_g1795_i0 | PRJNA380416 | 1942 | 437 | 3.048969 | 13.32399453 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 1.09e-57 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g1795 | i0 | 78.771 | 18.1350114416476 | 358 | 72 | 81 | 4 | 75 | 430 | 482 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7925 | 237 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 1676784 | 1676784 | PRJNA380416_P_NODE_8182_length_200_cov_1.006623_g8035_i0 | PRJNA380416 | 8182 | 200 | 1.006623 | 2.013246 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 1.99e-86 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g8035 | i0 | 96.5 | 30.565 | 200 | 7 | 100 | 0 | 1 | 200 | 367 | 566 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 6113 | 331 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2952636 | 2952636 | PRJNA380416_P_NODE_11723_length_166_cov_0.871795_g11576_i0 | PRJNA380416 | 11723 | 166 | 0.871795 | 1.4471797 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 8.08e-25 | NTclustered | gi|669140207|ref|XM_008607450.1| | 1156394 | g11576 | i0 | 81.132 | 0.957831325301205 | 159 | 28 | 95 | 2 | 2 | 159 | 1338 | 1181 | Saprolegnia diclina VS20 inositol-3-phosphate synthase mRNA | blastn | 159 | 126 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 2952650 | 2952650 | PRJNA380416_P_NODE_2903_length_354_cov_1.822951_g2756_i0 | PRJNA380416 | 2903 | 354 | 1.822951 | 6.45324654 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 2.26e-98 | NTclustered | gi|161015559|gb|EF577184.1| | 1117027 | g2756 | i0 | 85.634 | 99.2372881355932 | 355 | 49 | 100 | 2 | 1 | 354 | 575 | 928 | Spumella-like flagellate JBM10 beta-tubulin gene, partial cds | blastn | 35130 | 372 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 2952653 | 2952653 | PRJNA380416_P_NODE_5143_length_256_cov_1.724638_g4996_i0 | PRJNA380416 | 5143 | 256 | 1.724638 | 4.41507328 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.2599999999999995e-125 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g4996 | i0 | 99.216 | 97.6015625 | 255 | 2 | 99 | 0 | 1 | 255 | 1966 | 2220 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 24986 | 460 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 2952654 | 2952654 | PRJNA380416_P_NODE_6143_length_232_cov_2.087432_g5996_i0 | PRJNA380416 | 6143 | 232 | 2.087432 | 4.84284224 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.92e-57 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g5996 | i0 | 93.631 | 67.7715517241379 | 157 | 10 | 68 | 0 | 2 | 158 | 169 | 13 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 15723 | 235 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 4229184 | 4229184 | PRJNA380416_P_NODE_13624_length_162_cov_0.902655_g13477_i0 | PRJNA380416 | 13624 | 162 | 0.902655 | 1.4623011 | Diplophrys mutabilis | 1407010 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.39e-72 | NTclustered | gi|550533550|dbj|AB856527.1| | 1407010 | g13477 | i0 | 98.148 | 76.3950617283951 | 162 | 3 | 100 | 0 | 1 | 162 | 1730 | 1891 | Diplophrys mutabilis gene for 18S ribosomal RNA, partial sequence | blastn | 12376 | 283 | 1 | Eukaryota | Sar | Bigyra | Amphitremida | Diplophrys | Diplophrys mutabilis | ||||
| 4229192 | 4229192 | PRJNA380416_P_NODE_304_length_1132_cov_3.199446_g232_i0 | PRJNA380416 | 304 | 1132 | 3.199446 | 36.21772872 | Colpodella angusta | 1541798 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 8.6e-28 | NTclustered | gi|972268869|gb|KU159286.1| | 1541798 | g232 | i0 | 79.612 | 10.5980565371025 | 206 | 33 | 18 | 7 | 830 | 1031 | 3964 | 3764 | Colpodella angusta 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 | 11997 | 139 | 1 | Eukaryota | Sar | Colpodellaceae | Colpodella | Colpodella angusta | |||||
| 6779761 | 6779761 | PRJNA380416_P_NODE_9286_length_187_cov_1.471014_g9139_i0 | PRJNA380416 | 9286 | 187 | 1.471014 | 2.75079618 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 6.56e-91 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g9139 | i0 | 100 | 8.49197860962567 | 187 | 0 | 100 | 0 | 1 | 187 | 246 | 60 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 1588 | 346 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8726835 | 8726835 | PRJNA380416_P_NODE_8727_length_193_cov_1.263889_g8580_i0 | PRJNA380416 | 8727 | 193 | 1.263889 | 2.43930577 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.46e-92 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g8580 | i0 | 99.482 | 100.233160621762 | 193 | 1 | 100 | 0 | 1 | 193 | 1341 | 1149 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19345 | 351 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9330112 | 9330112 | PRJNA380416_P_NODE_7808_length_205_cov_0.897436_g7661_i0 | PRJNA380416 | 7808 | 205 | 0.897436 | 1.8397438 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 5.87e-67 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g7661 | i0 | 91.282 | 94.380487804878 | 195 | 17 | 95 | 0 | 10 | 204 | 1142 | 948 | Pyrocystis lunula actin mRNA, complete cds | blastn | 19348 | 267 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 10605758 | 10605758 | PRJNA380416_P_NODE_10609_length_173_cov_1.645161_g10462_i0 | PRJNA380416 | 10609 | 173 | 1.645161 | 2.84612853 | Leukarachnion sp. ATCC PRA-24 | 568390 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 8.38e-30 | NTclustered | gi|2727570083|gb|PP760457.1| | 568390 | g10462 | i0 | 85.211 | 3.15606936416185 | 142 | 18 | 80 | 3 | 1 | 139 | 2300 | 2441 | Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome | blastn | 546 | 143 | 1 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 11277325 | 11277325 | PRJNA380416_P_NODE_2649_length_370_cov_24.619938_g2502_i0 | PRJNA380416 | 2649 | 370 | 24.619938 | 91.0937706 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|1409949881|gb|MH542675.1| | 88167 | g2502 | i0 | 100 | 99.1189189189189 | 370 | 0 | 100 | 0 | 1 | 370 | 18 | 387 | Poterioochromonas malhamensis strain SAG933-9 small subunit ribosomal RNA gene, partial sequence | blastn | 36674 | 684 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 11880736 | 11880736 | PRJNA380416_P_NODE_13270_length_162_cov_1.761062_g13123_i0 | PRJNA380416 | 13270 | 162 | 1.761062 | 2.85292044 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|110644972|gb|DQ665918.1| | 151077 | g13123 | i0 | 100 | 76.5061728395062 | 162 | 0 | 100 | 0 | 1 | 162 | 526 | 365 | Chilodonella uncinata clone 1 beta-tubulin gene, partial cds | blastn | 12394 | 300 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14430775 | 14430775 | PRJNA380416_P_NODE_13292_length_162_cov_1.353982_g13145_i0 | PRJNA380416 | 13292 | 162 | 1.353982 | 2.19345084 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.39e-73 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g13145 | i0 | 98.758 | 103.70987654321 | 161 | 2 | 99 | 0 | 1 | 161 | 429 | 589 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 16801 | 287 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 14430788 | 14430788 | PRJNA380416_P_NODE_9492_length_185_cov_1.250000_g9345_i0 | PRJNA380416 | 9492 | 185 | 1.25 | 2.3125 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 8.430000000000001e-85 | NTclustered | gi|347439279|gb|JN111988.1| | 151077 | g9345 | i0 | 98.378 | 87.1405405405405 | 185 | 3 | 100 | 0 | 1 | 185 | 289 | 473 | Chilodonella uncinata strain USA_WH clone P1 beta tubulin (btub) gene, partial cds; macronuclear | blastn | 16121 | 326 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15704709 | 15704709 | PRJNA380416_P_NODE_11173_length_167_cov_1.533898_g11026_i0 | PRJNA380416 | 11173 | 167 | 1.533898 | 2.56160966 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.53e-80 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g11026 | i0 | 100 | 1 | 167 | 0 | 100 | 0 | 1 | 167 | 430 | 264 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 167 | 309 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15704735 | 15704735 | PRJNA380416_P_NODE_8873_length_191_cov_1.929577_g8726_i0 | PRJNA380416 | 8873 | 191 | 1.929577 | 3.68549207 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 4.05e-88 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g8726 | i0 | 98.429 | 100.335078534031 | 191 | 3 | 100 | 0 | 1 | 191 | 14659 | 14849 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 19164 | 337 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 22078539 | 22078539 | PRJNA380416_P_NODE_10958_length_169_cov_2.433333_g10811_i0 | PRJNA380416 | 10958 | 169 | 2.433333 | 4.11233277 | Spumella-like flagellate JBM18 | 293206 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.87e-44 | NTclustered | gi|161015626|gb|EF577224.1| | 293206 | g10811 | i0 | 86.982 | 85.4497041420118 | 169 | 22 | 100 | 0 | 1 | 169 | 1025 | 857 | Spumella-like flagellate JBM18 alpha-tubulin gene, partial cds | blastn | 14441 | 191 | 1 | Eukaryota | Sar | Chrysophyceae | Spumella-like flagellate JBM18 | ||||||
| 22078548 | 22078548 | PRJNA380416_P_NODE_13298_length_162_cov_1.353982_g13151_i0 | PRJNA380416 | 13298 | 162 | 1.353982 | 2.19345084 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g13151 | i0 | 100 | 101 | 162 | 0 | 100 | 0 | 1 | 162 | 1093 | 932 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 16362 | 300 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 23354060 | 23354060 | PRJNA380416_P_NODE_11539_length_166_cov_1.863248_g11392_i0 | PRJNA380416 | 11539 | 166 | 1.863248 | 3.09299168 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.26e-20 | NTclustered | gi|673017229|ref|XM_008864354.1| | 157072 | g11392 | i0 | 83.2 | 0.753012048192771 | 125 | 18 | 75 | 3 | 22 | 145 | 312 | 434 | Aphanomyces invadans hypothetical protein mRNA | blastn | 125 | 111 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 24628304 | 24628304 | PRJNA380416_P_NODE_10080_length_179_cov_1.161538_g9933_i0 | PRJNA380416 | 10080 | 179 | 1.161538 | 2.07915302 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 8.32e-65 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g9933 | i0 | 92.737 | 54.4301675977654 | 179 | 13 | 100 | 0 | 1 | 179 | 2037 | 1859 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 9743 | 259 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha |
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);;