contig_metadata
17 rows where bioproject = "PRJNA556992", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4351263 | 4351263 | PRJNA556992_P_NODE_123044_length_380_cov_4.247557_g120857_i0 | PRJNA556992 | 123044 | 380 | 4.247557 | 16.1407166 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.95e-79 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g120857 | i0 | 81.794 | 99.8289473684211 | 379 | 59 | 99 | 10 | 5 | 380 | 1690 | 1319 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 37935 | 309 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 4952744 | 4952744 | PRJNA556992_P_NODE_1113424_length_209_cov_8.941176_g1111233_i0 | PRJNA556992 | 1113424 | 209 | 8.941176 | 18.68705784 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 4.42e-103 | NTclustered | gi|33309629|gb|AF411271.1| | 188955 | g1111233 | i0 | 100 | 98.6028708133971 | 209 | 0 | 100 | 0 | 1 | 209 | 113 | 321 | Cercomonas sp. (Tempisque) 18S ribosomal RNA gene, complete sequence | blastn | 20608 | 387 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. Tempisque | |||
| 5636073 | 5636073 | PRJNA556992_P_NODE_719505_length_250_cov_1.711864_g717316_i0 | PRJNA556992 | 719505 | 250 | 1.711864 | 4.27966 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 8.83e-126 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g717316 | i0 | 100 | 4.772 | 250 | 0 | 100 | 0 | 1 | 250 | 492 | 243 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1193 | 462 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 7502334 | 7502334 | PRJNA556992_P_NODE_1008086_length_229_cov_6.679487_g1005896_i0 | PRJNA556992 | 1008086 | 229 | 6.679487 | 15.29602523 | root | 1 | Root_unresolved | Root_unresolved | 359 | 1.07e-94 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g1005896 | i0 | 94.828 | 41.3973799126638 | 232 | 9 | 100 | 3 | 1 | 229 | 2150 | 2381 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 9480 | 361 | 0.994459833795014 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 8185725 | 8185725 | PRJNA556992_P_NODE_77187_length_439_cov_11.816940_g75008_i0 | PRJNA556992 | 77187 | 439 | 11.81694 | 51.8763666 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 811 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g75008 | i0 | 100 | 19.6082004555809 | 439 | 0 | 100 | 0 | 1 | 439 | 784 | 346 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8608 | 811 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14564032 | 14564032 | PRJNA556992_P_NODE_948952_length_236_cov_2.067485_g946762_i0 | PRJNA556992 | 948952 | 236 | 2.067485 | 4.8792646 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 4.18e-64 | NTclustered | gi|1402550486|gb|MH488772.1| | 2231170 | g946762 | i0 | 97.973 | 29.9364406779661 | 148 | 3 | 63 | 0 | 1 | 148 | 1393 | 1540 | Guttulinopsis rogosa isolate T1 small subunit ribosomal RNA gene, partial sequence | blastn | 7065 | 257 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 17112370 | 17112370 | PRJNA556992_P_NODE_91274_length_416_cov_8.690962_g89091_i0 | PRJNA556992 | 91274 | 416 | 8.690962 | 36.15440192 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 4.459999999999998e-106 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g89091 | i0 | 85.751 | 59.5384615384615 | 386 | 44 | 92 | 11 | 1 | 381 | 3660 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 24768 | 398 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19652815 | 19652815 | PRJNA556992_P_NODE_271856_length_296_cov_1.381166_g269667_i0 | PRJNA556992 | 271856 | 296 | 1.381166 | 4.08825136 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.03e-150 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g269667 | i0 | 100 | 19.7027027027027 | 295 | 0 | 99 | 0 | 1 | 295 | 1618 | 1912 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 5832 | 545 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 19655495 | 19655495 | PRJNA556992_P_NODE_475996_length_269_cov_2.576531_g473807_i0 | PRJNA556992 | 475996 | 269 | 2.576531 | 6.93086839 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.2499999999999994e-67 | NTclustered | gi|1767048364|dbj|LC490352.1| | 1928728 | g473807 | i0 | 87.607 | 71.3866171003718 | 234 | 25 | 86 | 3 | 13 | 244 | 13859 | 14090 | Paulinella micropora MYN1 mitochondrial DNA, complete sequence | blastn | 19203 | 268 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 21528680 | 21528680 | PRJNA556992_P_NODE_546377_length_263_cov_2.400000_g544188_i0 | PRJNA556992 | 546377 | 263 | 2.4 | 6.312 | root | 1 | Root_unresolved | Root_unresolved | 407 | 4.45e-109 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g544188 | i0 | 94.403 | 101.285171102662 | 268 | 10 | 100 | 4 | 1 | 263 | 2454 | 2187 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 26638 | 409 | 0.995110024449878 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 22201116 | 22201116 | PRJNA556992_P_NODE_123498_length_380_cov_2.172638_g121311_i0 | PRJNA556992 | 123498 | 380 | 2.172638 | 8.2560244 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 3.369999999999999e-52 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g121311 | i0 | 93.243 | 26.5631578947368 | 148 | 10 | 39 | 0 | 43 | 190 | 3691 | 3838 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 10094 | 219 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24752837 | 24752837 | PRJNA556992_P_NODE_280300_length_293_cov_1.400000_g278111_i0 | PRJNA556992 | 280300 | 293 | 1.4 | 4.102 | Rosculus philanguis | 2231163 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 5.289999999999999e-74 | NTclustered | gi|1402550480|gb|MH488766.1| | 2231163 | g278111 | i0 | 89.912 | 11.5631399317406 | 228 | 20 | 77 | 2 | 69 | 293 | 495 | 268 | Rosculus philanguis isolate HAS small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 3388 | 291 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus philanguis | ||||
| 24759828 | 24759828 | PRJNA556992_P_NODE_831100_length_244_cov_2.432749_g828910_i0 | PRJNA556992 | 831100 | 244 | 2.432749 | 5.93590756 | Cercomonas metabolicus | 352462 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.91e-28 | NTclustered | gi|161015704|gb|EF681938.1| | 352462 | g828910 | i0 | 77.966 | 1.93852459016393 | 236 | 41 | 95 | 8 | 6 | 237 | 318 | 546 | Cercomonas metabolicus strain HFCC88 28S ribosomal RNA gene, partial sequence | blastn | 473 | 137 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas metabolicus | |||
| 28973731 | 28973731 | PRJNA556992_P_NODE_987288_length_232_cov_2.238994_g985098_i0 | PRJNA556992 | 987288 | 232 | 2.238994 | 5.19446608 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 6.23e-5 | NR | MES1910244.1 | 1215613 | g985098 | i0 | 48.9 | 0.607758620689655 | 47 | 24 | 60.8 | 0 | 92 | 232 | 471 | 517 | MES1910244.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 141 | 50.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29036664 | 29036664 | PRJNA556992_P_NODE_455268_length_271_cov_2.171717_g453079_i0 | PRJNA556992 | 455268 | 271 | 2.171717 | 5.88535307 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 9.33e-25 | NR | MES1907663.1 | 1215613 | g453079 | i0 | 62.5 | 1.06273062730627 | 96 | 29 | 98.5 | 2 | 269 | 3 | 521 | 616 | MES1907663.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 288 | 107 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31374385 | 31374385 | PRJNA556992_P_NODE_694996_length_251_cov_2.831461_g692807_i0 | PRJNA556992 | 694996 | 251 | 2.831461 | 7.10696711 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 7.9e-5 | NR | MES1911702.1 | 1215613 | g692807 | i0 | 53.5 | 0.51394422310757 | 43 | 20 | 51.4 | 0 | 210 | 82 | 52 | 94 | MES1911702.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 129 | 50.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32513116 | 32513116 | PRJNA556992_P_NODE_1078799_length_217_cov_13.673611_g1076608_i0 | PRJNA556992 | 1078799 | 217 | 13.673611 | 29.67173587 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 1.21e-21 | NR | AAY21202.1 | 227086 | g1076608 | i0 | 70 | 1.65898617511521 | 60 | 17 | 82.9 | 1 | 183 | 4 | 16 | 74 | AAY21202.1 Rpl7A, partial [Bigelowiella natans] | diamond | 360 | 92.4 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans |
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);;