contig_metadata
25 rows where bioproject = "PRJNA763243", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 742739 | 742739 | PRJNA763243_P_NODE_17501_length_373_cov_548.263333_g17156_i0 | PRJNA763243 | 17501 | 373 | 548.263333 | 2045.02223209 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.05e-29 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g17156 | i0 | 77.695 | 16.6595174262735 | 269 | 36 | 71 | 16 | 4 | 269 | 3792 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 6214 | 143 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 742818 | 742818 | PRJNA763243_P_NODE_20441_length_350_cov_17.660650_g20095_i0 | PRJNA763243 | 20441 | 350 | 17.66065 | 61.812275 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 3.87e-71 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g20095 | i0 | 82.133 | 46.8857142857143 | 347 | 45 | 98 | 10 | 7 | 350 | 4020 | 3688 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16410 | 281 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 743214 | 743214 | PRJNA763243_P_NODE_36601_length_286_cov_1.215962_g36255_i0 | PRJNA763243 | 36601 | 286 | 1.215962 | 3.47765132 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.68e-39 | NR | MES1907458.1 | 1215613 | g36255 | i0 | 75.8 | 0.954545454545455 | 91 | 22 | 95.5 | 0 | 284 | 12 | 44 | 134 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 273 | 142 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 743584 | 743584 | PRJNA763243_P_NODE_52541_length_250_cov_2.937853_g52195_i0 | PRJNA763243 | 52541 | 250 | 2.937853 | 7.3446325 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.3e-34 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g52195 | i0 | 87.324 | 36.268 | 142 | 14 | 55 | 2 | 1 | 138 | 2547 | 2406 | Rosculus vulgaris isolate CCA sequence | blastn | 9067 | 159 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 1205297 | 1205297 | PRJNA763243_P_NODE_9661_length_480_cov_317.373464_g9318_i0 | PRJNA763243 | 9661 | 480 | 317.373464 | 1523.3926272 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 627 | 6.109999999999999e-175 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g9318 | i0 | 94.189 | 100.335416666667 | 413 | 21 | 99 | 3 | 4 | 414 | 2148 | 2559 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 48161 | 627 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 4571695 | 4571695 | PRJNA763243_P_NODE_41764_length_272_cov_6.180905_g41418_i0 | PRJNA763243 | 41764 | 272 | 6.180905 | 16.8120616 | Bodomorpha sp. HFCC55 | 624126 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.69e-131 | NTclustered | gi|225216790|gb|FJ176705.1| | 624126 | g41418 | i0 | 98.885 | 94.9411764705882 | 269 | 3 | 99 | 0 | 4 | 272 | 666 | 934 | Bodomorpha sp. 28S ribosomal RNA gene, partial sequence | blastn | 25824 | 481 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC55 | |||
| 5846629 | 5846629 | PRJNA763243_P_NODE_30745_length_306_cov_4.145923_g30399_i0 | PRJNA763243 | 30745 | 306 | 4.145923 | 12.68652438 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 6.01e-19 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g30399 | i0 | 98.361 | 15.2418300653595 | 61 | 1 | 43 | 0 | 243 | 303 | 3839 | 3779 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4664 | 108 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 8396755 | 8396755 | PRJNA763243_P_NODE_49967_length_254_cov_3.066298_g49621_i0 | PRJNA763243 | 49967 | 254 | 3.066298 | 7.78839692 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 1.5499999999999998e-103 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g49621 | i0 | 94.444 | 100.129921259843 | 252 | 14 | 99 | 0 | 2 | 253 | 1811 | 2062 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 25433 | 388 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 9671163 | 9671163 | PRJNA763243_P_NODE_17428_length_374_cov_5.102990_g17083_i0 | PRJNA763243 | 17428 | 374 | 5.10299 | 19.0851826 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 9.15e-58 | NTclustered | gi|116222192|gb|DQ980477.1| | 407209 | g17083 | i0 | 80.058 | 80.8395721925134 | 346 | 48 | 91 | 17 | 33 | 374 | 1731 | 2059 | Thaumatomonas sp. TMT002 large subunit ribosomal RNA gene, partial sequence | blastn | 30234 | 237 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 9671980 | 9671980 | PRJNA763243_P_NODE_51668_length_251_cov_1.488764_g51322_i0 | PRJNA763243 | 51668 | 251 | 1.488764 | 3.73679764 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 7.31e-82 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g51322 | i0 | 99.425 | 98.2908366533864 | 174 | 1 | 69 | 0 | 75 | 248 | 1120 | 947 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 24671 | 316 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12222930 | 12222930 | PRJNA763243_P_NODE_39790_length_277_cov_3.401961_g39444_i0 | PRJNA763243 | 39790 | 277 | 3.401961 | 9.42343197 | Bodomorpha sp. HFCC55 | 624126 | SAR_Eukaryotes | SAR_Eukaryotes | 479 | 9.86e-131 | NTclustered | gi|225216790|gb|FJ176705.1| | 624126 | g39444 | i0 | 98.519 | 22.7689530685921 | 270 | 4 | 97 | 0 | 4 | 273 | 282 | 551 | Bodomorpha sp. 28S ribosomal RNA gene, partial sequence | blastn | 6307 | 479 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC55 | |||
| 12223281 | 12223281 | PRJNA763243_P_NODE_54610_length_248_cov_5.622857_g54264_i0 | PRJNA763243 | 54610 | 248 | 5.622857 | 13.94468536 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 3.38e-75 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g54264 | i0 | 89.167 | 50.8387096774194 | 240 | 21 | 95 | 4 | 10 | 245 | 2877 | 2639 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 12608 | 294 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 14771618 | 14771618 | PRJNA763243_P_NODE_16012_length_387_cov_2.382166_g15667_i0 | PRJNA763243 | 16012 | 387 | 2.382166 | 9.21898242 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 682 | 0 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g15667 | i0 | 98.95 | 12.1782945736434 | 381 | 2 | 98 | 1 | 6 | 386 | 1114 | 736 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 4713 | 682 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 17321710 | 17321710 | PRJNA763243_P_NODE_44934_length_265_cov_1.562500_g44588_i0 | PRJNA763243 | 44934 | 265 | 1.5625 | 4.140625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 6.42e-15 | NR | AAP72162.1 | 188940 | g44588 | i0 | 76.6 | 5.20754716981132 | 94 | 14 | 97.4 | 1 | 262 | 5 | 144 | 237 | AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)] | diamond | 1380 | 80.1 | 0.990012484394507 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. (SA) | ||
| 17322258 | 17322258 | PRJNA763243_P_NODE_68694_length_226_cov_5.660131_g68348_i0 | PRJNA763243 | 68694 | 226 | 5.660131 | 12.79189606 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.32e-38 | NTclustered | gi|194272422|gb|EU567215.1| | 175275 | g68348 | i0 | 83.243 | 69.6238938053097 | 185 | 31 | 82 | 0 | 37 | 221 | 790 | 974 | Uncultured cercozoan isolate op23 18S ribosomal RNA gene, partial sequence | blastn | 15735 | 171 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 18594849 | 18594849 | PRJNA763243_P_NODE_3635_length_713_cov_705.326563_g3348_i0 | PRJNA763243 | 3635 | 713 | 705.326563 | 5028.97839419 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 715 | 0 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g3348 | i0 | 85.077 | 77.8345021037868 | 717 | 90 | 99 | 12 | 4 | 709 | 1635 | 2345 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 55496 | 715 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 19870381 | 19870381 | PRJNA763243_P_NODE_51316_length_251_cov_96.061798_g50970_i0 | PRJNA763243 | 51316 | 251 | 96.061798 | 241.11511298 | Ebria tripartita | 361426 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.09e-62 | NTclustered | gi|290760481|gb|GQ144684.1| | 361426 | g50970 | i0 | 89.216 | 81.5816733067729 | 204 | 19 | 80 | 3 | 4 | 205 | 1339 | 1541 | Ebria tripartita large subunit ribosomal RNA gene, partial sequence | blastn | 20477 | 252 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ebriacea | Ebria | Ebria tripartita | |||
| 21145159 | 21145159 | PRJNA763243_P_NODE_11537_length_445_cov_649.456989_g11193_i0 | PRJNA763243 | 11537 | 445 | 649.456989 | 2890.08360105 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 5.08e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11193 | i0 | 92.896 | 43.0359550561798 | 183 | 11 | 41 | 2 | 4 | 184 | 3656 | 3838 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19151 | 265 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 23695630 | 23695630 | PRJNA763243_P_NODE_14859_length_399_cov_12.453988_g14514_i0 | PRJNA763243 | 14859 | 399 | 12.453988 | 49.69141212 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 8.9e-128 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g14514 | i0 | 88.325 | 99 | 394 | 42 | 98 | 4 | 4 | 396 | 1622 | 1232 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 39501 | 470 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 23695762 | 23695762 | PRJNA763243_P_NODE_20299_length_351_cov_5.733813_g19953_i0 | PRJNA763243 | 20299 | 351 | 5.733813 | 20.12568363 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 617 | 2.61e-172 | NTclustered | gi|48727804|gb|AY620294.1| | 175275 | g19953 | i0 | 98.847 | 98.6666666666667 | 347 | 3 | 99 | 1 | 4 | 349 | 18 | 364 | Uncultured cercozoan clone 9-4.6 small subunit ribosomal RNA gene, partial sequence | blastn | 34632 | 617 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 23696468 | 23696468 | PRJNA763243_P_NODE_49959_length_254_cov_3.209945_g49613_i0 | PRJNA763243 | 49959 | 254 | 3.209945 | 8.1532603 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 6.02e-48 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g49613 | i0 | 82.353 | 15.9606299212598 | 255 | 25 | 99 | 11 | 4 | 254 | 3770 | 4008 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4054 | 204 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24969711 | 24969711 | PRJNA763243_P_NODE_3180_length_757_cov_696.054094_g2904_i0 | PRJNA763243 | 3180 | 757 | 696.054094 | 5269.12949158 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1367 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2904 | i0 | 99.6 | 53.7344782034346 | 750 | 2 | 99 | 1 | 3 | 751 | 344 | 1093 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 40677 | 1367 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24970753 | 24970753 | PRJNA763243_P_NODE_8880_length_497_cov_1126.530660_g8538_i0 | PRJNA763243 | 8880 | 497 | 1126.53066 | 5598.8573802 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.92e-115 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g8538 | i0 | 86.75 | 46.1086519114688 | 400 | 36 | 80 | 10 | 98 | 495 | 4039 | 3655 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22916 | 429 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 28063804 | 28063804 | PRJNA763243_P_NODE_16685_length_381_cov_0.990260_g16340_i0 | PRJNA763243 | 16685 | 381 | 0.99026 | 3.7728906 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 2.16e-17 | NR | MES1909201.1 | 1215613 | g16340 | i0 | 47 | 1.03937007874016 | 132 | 62 | 97.6 | 4 | 373 | 2 | 133 | 264 | MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 396 | 88.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32171441 | 32171441 | PRJNA763243_P_NODE_8118_length_516_cov_2.550790_g7777_i0 | PRJNA763243 | 8118 | 516 | 2.55079 | 13.1620764 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.12e-36 | NR | MES1911029.1 | 1215613 | g7777 | i0 | 49.7 | 0.854651162790698 | 147 | 68 | 83.1 | 2 | 3 | 431 | 161 | 305 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 441 | 137 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;