contig_metadata
24 rows where bioproject = "PRJNA577226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1137646 | 1137646 | PRJNA577226_S_NODE_62401_length_159_cov_1.868852_g61462_i0 | PRJNA577226 | 62401 | 159 | 1.868852 | 2.97147468 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 7.329999999999998e-55 | NTclustered | gi|324022090|gb|GU593707.1| | 5801 | g61462 | i0 | 94.558 | 92.0503144654088 | 147 | 7 | 92 | 1 | 1 | 146 | 1785 | 1639 | Eimeria acervulina strain Miska2 28S ribosomal RNA gene, partial sequence | blastn | 14636 | 226 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 4388949 | 4388949 | PRJNA577226_S_NODE_24224_length_255_cov_2.977064_g23285_i0 | PRJNA577226 | 24224 | 255 | 2.977064 | 7.5915132 | Hydrurus foetidus | 2996 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.58e-93 | NTclustered | gi|2550427459|gb|OR336050.1| | 2996 | g23285 | i0 | 92.063 | 97.0235294117647 | 252 | 20 | 99 | 0 | 4 | 255 | 2047 | 1796 | Hydrurus foetidus strain Fenhe 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24741 | 355 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus | |||
| 4965761 | 4965761 | PRJNA577226_S_NODE_60464_length_161_cov_3.798387_g59525_i0 | PRJNA577226 | 60464 | 161 | 3.798387 | 6.11540307 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 3.389999999999999e-68 | NTclustered | gi|174168|gb|M87332.1|CMIRRNAA | 2998 | g59525 | i0 | 96.894 | 98.6832298136646 | 161 | 5 | 100 | 0 | 1 | 161 | 1579 | 1419 | Chromulina chionophila small subunit ribosomal RNA gene, partial sequence | blastn | 15888 | 270 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Chromulina | Chromulina chionophila | |||
| 6939308 | 6939308 | PRJNA577226_S_NODE_14326_length_341_cov_7.125000_g13387_i0 | PRJNA577226 | 14326 | 341 | 7.125 | 24.29625 | Stramenopiles sp. MAST-4E-sp1 | 2805728 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.3899999999999995e-55 | NTclustered | gi|1960721538|gb|MW521834.1| | 2805728 | g13387 | i0 | 79.341 | 86.3343108504399 | 334 | 63 | 98 | 4 | 8 | 341 | 3528 | 3855 | Stramenopiles sp. MAST-4E-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 | 29440 | 230 | 1 | Eukaryota | Sar | Stramenopiles sp. MAST-4E-sp1 | |||||||
| 6940478 | 6940478 | PRJNA577226_S_NODE_55446_length_168_cov_1.480916_g54507_i0 | PRJNA577226 | 55446 | 168 | 1.480916 | 2.48793888 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 2.11e-80 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g54507 | i0 | 100 | 79.2619047619048 | 168 | 0 | 100 | 0 | 1 | 168 | 1968 | 1801 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 13316 | 311 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 6940716 | 6940716 | PRJNA577226_S_NODE_6466_length_539_cov_3.392430_g5541_i0 | PRJNA577226 | 6466 | 539 | 3.39243 | 18.2851977 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 874 | 0 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g5541 | i0 | 95.918 | 67.1094619666048 | 539 | 22 | 100 | 0 | 1 | 539 | 116692 | 116154 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 36172 | 874 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 8215513 | 8215513 | PRJNA577226_S_NODE_57807_length_165_cov_1.218750_g56868_i0 | PRJNA577226 | 57807 | 165 | 1.21875 | 2.0109375 | Cercozoa sp. CC-2009d | 629762 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 2.82e-39 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g56868 | i0 | 85.976 | 95.2121212121212 | 164 | 21 | 99 | 2 | 2 | 165 | 1434 | 1273 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 15710 | 174 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 10765635 | 10765635 | PRJNA577226_S_NODE_21089_length_276_cov_1.108787_g20150_i0 | PRJNA577226 | 21089 | 276 | 1.108787 | 3.06025212 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 6.21e-93 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g20150 | i0 | 91.44 | 7.25724637681159 | 257 | 22 | 100 | 0 | 1 | 257 | 117442 | 117698 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2003 | 353 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10766362 | 10766362 | PRJNA577226_S_NODE_46189_length_183_cov_2.136986_g45250_i0 | PRJNA577226 | 46189 | 183 | 2.136986 | 3.91068438 | Chrysophyceae sp. | 1955566 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 8.56e-65 | NTclustered | gi|1209183015|gb|KX100757.1| | 1955566 | g45250 | i0 | 92.896 | 100.491803278689 | 183 | 6 | 100 | 5 | 1 | 183 | 460 | 635 | Chrysophyceae sp. strain FU34KK 28S ribosomal RNA gene, partial sequence | blastn | 18390 | 259 | 1 | Eukaryota | Sar | Chrysophyceae | Chrysophyceae sp. | ||||||
| 12040621 | 12040621 | PRJNA577226_S_NODE_25870_length_246_cov_3.555024_g24931_i0 | PRJNA577226 | 25870 | 246 | 3.555024 | 8.74535904 | Chrysophyceae sp. | 1955566 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.11e-37 | NTclustered | gi|1209183015|gb|KX100757.1| | 1955566 | g24931 | i0 | 79.518 | 46.6463414634146 | 249 | 42 | 100 | 9 | 1 | 246 | 466 | 224 | Chrysophyceae sp. strain FU34KK 28S ribosomal RNA gene, partial sequence | blastn | 11475 | 169 | 1 | Eukaryota | Sar | Chrysophyceae | Chrysophyceae sp. | ||||||
| 13315786 | 13315786 | PRJNA577226_S_NODE_35471_length_209_cov_1.947674_g34532_i0 | PRJNA577226 | 35471 | 209 | 1.947674 | 4.07063866 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.61e-92 | NTclustered | gi|219524910|gb|EU709273.1| | 175275 | g34532 | i0 | 97.115 | 99.5311004784689 | 208 | 6 | 99 | 0 | 2 | 209 | 730 | 937 | Uncultured cercozoan isolate AH44p78p118t17 18S ribosomal RNA gene, partial sequence | blastn | 20802 | 351 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 13891369 | 13891369 | PRJNA577226_S_NODE_34751_length_211_cov_2.339080_g33812_i0 | PRJNA577226 | 34751 | 211 | 2.33908 | 4.9354588 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.04e-49 | NTclustered | gi|2285976|emb|Y07977.1| | 2986 | g33812 | i0 | 85.116 | 102.14691943128 | 215 | 21 | 100 | 8 | 1 | 211 | 2379 | 2586 | O.danica 28S rRNA gene and ITS2 DNA | blastn | 21553 | 211 | 0.990521327014218 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 13891749 | 13891749 | PRJNA577226_S_NODE_67651_length_154_cov_1.273504_g66712_i0 | PRJNA577226 | 67651 | 154 | 1.273504 | 1.96119616 | Spumella | 89043 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.48e-69 | NTclustered | gi|2055919761|gb|MZ420319.1| | 1841649 | g66712 | i0 | 98.701 | 79.8636363636364 | 154 | 2 | 100 | 0 | 1 | 154 | 1554 | 1401 | Spumella bureschii strain Saenggeunje120118A5 large subunit ribosomal RNA gene, partial sequence | blastn | 12299 | 274 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella bureschii | |||
| 15864525 | 15864525 | PRJNA577226_S_NODE_38253_length_201_cov_1.713415_g37314_i0 | PRJNA577226 | 38253 | 201 | 1.713415 | 3.44396415 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 372 | 1.18e-98 | NTclustered | gi|1402550488|gb|MH488774.1| | 2231170 | g37314 | i0 | 100 | 27.0199004975124 | 201 | 0 | 100 | 0 | 1 | 201 | 1516 | 1316 | Guttulinopsis rogosa isolate FOLDEDA sequence | blastn | 5431 | 372 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 18413087 | 18413087 | PRJNA577226_S_NODE_13335_length_354_cov_3.567823_g12396_i0 | PRJNA577226 | 13335 | 354 | 3.567823 | 12.63009342 | Chrysophyceae sp. | 1955566 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.5e-155 | NTclustered | gi|1209182845|gb|KX100587.1| | 1955566 | g12396 | i0 | 95.211 | 100.545197740113 | 355 | 15 | 100 | 2 | 1 | 354 | 461 | 814 | Chrysophyceae sp. strain FU34KF 18S ribosomal RNA gene, partial sequence | blastn | 35593 | 560 | 1 | Eukaryota | Sar | Chrysophyceae | Chrysophyceae sp. | ||||||
| 18988767 | 18988767 | PRJNA577226_S_NODE_43095_length_189_cov_2.940789_g42156_i0 | PRJNA577226 | 43095 | 189 | 2.940789 | 5.55809121 | Synura | 2991 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 7.39e-16 | NTclustered | gi|859809386|gb|KM590657.1| | 52555 | g42156 | i0 | 76.684 | 56.0529100529101 | 193 | 33 | 100 | 11 | 1 | 189 | 1856 | 2040 | Synura petersenii strain Buje100307A 26S ribosomal RNA gene, partial sequence | blastn | 10594 | 97.1 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura petersenii | |||
| 18988939 | 18988939 | PRJNA577226_S_NODE_57235_length_165_cov_4.078125_g56296_i0 | PRJNA577226 | 57235 | 165 | 4.078125 | 6.72890625 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.46e-77 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g56296 | i0 | 99.398 | 48.5393939393939 | 166 | 0 | 100 | 1 | 1 | 165 | 1153 | 988 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 8009 | 302 | 0.993377483443709 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 20964277 | 20964277 | PRJNA577226_S_NODE_45977_length_184_cov_1.183673_g45038_i0 | PRJNA577226 | 45977 | 184 | 1.183673 | 2.17795832 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 2.99e-89 | NTclustered | gi|1402550486|gb|MH488772.1| | 2231170 | g45038 | i0 | 100 | 14.9130434782609 | 184 | 0 | 100 | 0 | 1 | 184 | 589 | 406 | Guttulinopsis rogosa isolate T1 small subunit ribosomal RNA gene, partial sequence | blastn | 2744 | 340 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 20964327 | 20964327 | PRJNA577226_S_NODE_47697_length_180_cov_4.790210_g46758_i0 | PRJNA577226 | 47697 | 180 | 4.79021 | 8.622378 | Mallomonas asmundiae | 64709 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 5.04e-62 | NTclustered | gi|16326554|gb|AF409122.1| | 64709 | g46758 | i0 | 91.758 | 5.31666666666667 | 182 | 11 | 100 | 4 | 1 | 180 | 3898 | 3719 | Mallomonas asmundae internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 957 | 250 | 1 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Mallomonas | Mallomonas asmundiae | |||
| 23514611 | 23514611 | PRJNA577226_S_NODE_51599_length_174_cov_1.189781_g50660_i0 | PRJNA577226 | 51599 | 174 | 1.189781 | 2.07021894 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 4.91e-52 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g50660 | i0 | 89.08 | 2.00574712643678 | 174 | 19 | 100 | 0 | 1 | 174 | 80576 | 80749 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 349 | 217 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23514945 | 23514945 | PRJNA577226_S_NODE_64019_length_157_cov_2.916667_g63080_i0 | PRJNA577226 | 64019 | 157 | 2.916667 | 4.57916719 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 4.28e-62 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g63080 | i0 | 96.667 | 111.254777070064 | 150 | 5 | 96 | 0 | 4 | 153 | 3840 | 3691 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17467 | 250 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24788187 | 24788187 | PRJNA577226_S_NODE_45560_length_184_cov_3.360544_g44621_i0 | PRJNA577226 | 45560 | 184 | 3.360544 | 6.18340096 | Spumella sociabilis | 459038 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.47e-86 | NTclustered | gi|161015698|gb|EF681932.1| | 459038 | g44621 | i0 | 98.913 | 99.9130434782609 | 184 | 2 | 100 | 0 | 1 | 184 | 1063 | 880 | Spumella sociabilis strain HFCC76 28S ribosomal RNA gene, partial sequence | blastn | 18384 | 329 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sociabilis | |||
| 28342913 | 28342913 | PRJNA577226_S_NODE_3986_length_737_cov_3.170000_g3126_i0 | PRJNA577226 | 3986 | 737 | 3.17 | 23.3629 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.0321 | NR | XP_029220138.1 | 94643 | g3126 | i0 | 33.9 | 0.492537313432836 | 121 | 69 | 48.8 | 2 | 275 | 634 | 559 | 669 | XP_029220138.1 ankyrin repeat-containing protein [Besnoitia besnoiti] | diamond | 363 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 32842598 | 32842598 | PRJNA577226_S_NODE_7220_length_503_cov_3.098712_g6290_i0 | PRJNA577226 | 7220 | 503 | 3.098712 | 15.58652136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.92e-35 | NR | P25166.1 | 5949 | g6290 | i0 | 58.2 | 10.1153081510934 | 122 | 42 | 72.8 | 3 | 503 | 138 | 324 | 436 | P25166.1 RecName: Full=Elongation factor 1-alpha; Short=EF-1-alpha [Stylonychia lemnae] | diamond | 5088 | 137 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;