contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671230 | 671230 | PRJNA690592_S_NODE_17761_length_704_cov_14.825674_g16826_i0 | PRJNA690592 | 17761 | 704 | 14.825674 | 104.37274496 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 2.39e-41 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g16826 | i0 | 84.375 | 3.58238636363636 | 192 | 25 | 27 | 5 | 1 | 188 | 3711 | 3901 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 2522 | 183 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 671582 | 671582 | PRJNA690592_S_NODE_219941_length_227_cov_7.383117_g218927_i0 | PRJNA690592 | 219941 | 227 | 7.383117 | 16.75967559 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 2.35e-76 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g218927 | i0 | 90.435 | 173.84140969163 | 230 | 17 | 100 | 4 | 1 | 227 | 2585 | 2812 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 39462 | 298 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 1947578 | 1947578 | PRJNA690592_S_NODE_216962_length_238_cov_4.400000_g215948_i0 | PRJNA690592 | 216962 | 238 | 4.4 | 10.472 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.309999999999999e-55 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g215948 | i0 | 84.082 | 35.0882352941176 | 245 | 29 | 99 | 7 | 1 | 236 | 2297 | 2054 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 8351 | 228 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 1947705 | 1947705 | PRJNA690592_S_NODE_35622_length_510_cov_17.464531_g34613_i0 | PRJNA690592 | 35622 | 510 | 17.464531 | 89.0691081 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 876 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g34613 | i0 | 97.647 | 94.3843137254902 | 510 | 12 | 100 | 0 | 1 | 510 | 783 | 274 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 48136 | 876 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1947956 | 1947956 | PRJNA690592_S_NODE_68922_length_382_cov_3.258900_g67908_i0 | PRJNA690592 | 68922 | 382 | 3.2589 | 12.448998 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 1.46e-105 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g67908 | i0 | 97.414 | 43.6230366492147 | 232 | 6 | 61 | 0 | 151 | 382 | 1 | 232 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 16664 | 396 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4499434 | 4499434 | PRJNA690592_S_NODE_198904_length_246_cov_14.849711_g197890_i0 | PRJNA690592 | 198904 | 246 | 14.849711 | 36.53028906 | Bodomorpha sp. Panama105 | 555789 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|219524917|gb|EU709280.1| | 555789 | g197890 | i0 | 100 | 85.7886178861789 | 246 | 0 | 100 | 0 | 1 | 246 | 1372 | 1617 | Bodomorpha sp. Panama105 18S ribosomal RNA gene, partial sequence | blastn | 21104 | 455 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. Panama105 | |||
| 4499636 | 4499636 | PRJNA690592_S_NODE_25464_length_596_cov_3.967495_g24472_i0 | PRJNA690592 | 25464 | 596 | 3.967495 | 23.6462702 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 990 | 0 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g24472 | i0 | 96.644 | 88.6124161073825 | 596 | 20 | 100 | 0 | 1 | 596 | 845 | 250 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 52813 | 990 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4499677 | 4499677 | PRJNA690592_S_NODE_30264_length_550_cov_3.882600_g29260_i0 | PRJNA690592 | 30264 | 550 | 3.8826 | 21.3543 | Paulinella chromatophora | 39717 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 5.04e-52 | NTclustered | gi|302563026|dbj|AB546336.1| | 39717 | g29260 | i0 | 77.604 | 55.4418181818182 | 384 | 70 | 68 | 14 | 167 | 542 | 1273 | 898 | Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds | blastn | 30493 | 219 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella chromatophora | ||
| 4499837 | 4499837 | PRJNA690592_S_NODE_51584_length_433_cov_3.050000_g50570_i0 | PRJNA690592 | 51584 | 433 | 3.05 | 13.2065 | Kraken carinae | 1756194 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 8.92e-9 | NTclustered | gi|1178873522|gb|KY069277.1| | 1756194 | g50570 | i0 | 97.674 | 7.34642032332563 | 43 | 1 | 10 | 0 | 387 | 429 | 1933 | 1975 | Kraken carinae isolate KD0248 28S ribosomal RNA gene, partial sequence | blastn | 3181 | 75 | 1 | Eukaryota | Sar | Cercozoa | Kraken | Kraken carinae | |||||
| 5775019 | 5775019 | PRJNA690592_S_NODE_204745_length_244_cov_3.385965_g203731_i0 | PRJNA690592 | 204745 | 244 | 3.385965 | 8.2617546 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.17e-105 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g203731 | i0 | 97.021 | 99.0450819672131 | 235 | 6 | 96 | 1 | 11 | 244 | 1120 | 886 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 24167 | 394 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7050245 | 7050245 | PRJNA690592_S_NODE_25946_length_591_cov_6.762548_g24954_i0 | PRJNA690592 | 25946 | 591 | 6.762548 | 39.96665868 | Capsellina sp. ATCC 50039 | 862254 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 2.91e-134 | NTclustered | gi|300676728|gb|GQ377659.1| | 862254 | g24954 | i0 | 81.942 | 95.4179357021997 | 587 | 100 | 99 | 6 | 3 | 586 | 167 | 750 | Capsellina sp. ATCC 50039 alpha-tubulin (Atub) gene, partial cds | blastn | 56392 | 492 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Rhogostomidae | Capsellina | Capsellina sp. ATCC 50039 | ||
| 7050391 | 7050391 | PRJNA690592_S_NODE_42766_length_470_cov_6.430730_g41752_i0 | PRJNA690592 | 42766 | 470 | 6.43073 | 30.224431 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 610 | 6.009999999999997e-170 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g41752 | i0 | 90 | 100.397872340426 | 470 | 47 | 100 | 0 | 1 | 470 | 1621 | 2090 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 47187 | 610 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 10875471 | 10875471 | PRJNA690592_S_NODE_199929_length_246_cov_1.335260_g198915_i0 | PRJNA690592 | 199929 | 246 | 1.33526 | 3.2847396 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 3.25e-95 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g198915 | i0 | 93.089 | 90.3739837398374 | 246 | 17 | 100 | 0 | 1 | 246 | 344 | 589 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 22232 | 361 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 14700280 | 14700280 | PRJNA690592_S_NODE_192952_length_249_cov_0.875000_g191938_i0 | PRJNA690592 | 192952 | 249 | 0.875 | 2.17875 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 394 | 3.25e-105 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g191938 | i0 | 95.181 | 101.33734939759 | 249 | 12 | 100 | 0 | 1 | 249 | 1321 | 1569 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 25233 | 394 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 14700898 | 14700898 | PRJNA690592_S_NODE_66912_length_387_cov_2.222930_g65898_i0 | PRJNA690592 | 66912 | 387 | 2.22293 | 8.6027391 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 2.9299999999999992e-167 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g65898 | i0 | 94.629 | 1.60981912144703 | 391 | 16 | 100 | 5 | 1 | 387 | 804 | 415 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 623 | 601 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15974190 | 15974190 | PRJNA690592_S_NODE_207693_length_244_cov_0.859649_g206679_i0 | PRJNA690592 | 207693 | 244 | 0.859649 | 2.09754356 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 4.44e-49 | NTclustered | gi|116222286|gb|DQ980529.1| | 407209 | g206679 | i0 | 81.967 | 62.905737704918 | 244 | 44 | 100 | 0 | 1 | 244 | 674 | 917 | Thaumatomonas sp. TMT002 beta tubulin gene, partial cds | blastn | 15349 | 207 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 17756967 | 17756967 | PRJNA690592_S_NODE_87614_length_345_cov_47.628676_g86600_i0 | PRJNA690592 | 87614 | 345 | 47.628676 | 164.3189322 | Viridiuvalis | 2040448 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 3.989999999999999e-41 | NTclustered | gi|220983374|dbj|AB453010.1| | 467061 | g86600 | i0 | 99.01 | 29.1884057971014 | 101 | 1 | 29 | 0 | 245 | 345 | 1881 | 1781 | Chlorarachniophyceae sp. P329 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 10070 | 182 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Chlorarachniophyceae sp. P329 | |||||
| 18523468 | 18523468 | PRJNA690592_S_NODE_206195_length_244_cov_1.122807_g205181_i0 | PRJNA690592 | 206195 | 244 | 1.1228070000000001 | 2.73964908 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 3.36e-65 | NTclustered | gi|300676716|gb|GQ377714.1| | 323453 | g205181 | i0 | 87.124 | 60.9016393442623 | 233 | 26 | 95 | 3 | 12 | 244 | 43 | 271 | Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds | blastn | 14860 | 261 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 18523672 | 18523672 | PRJNA690592_S_NODE_34295_length_519_cov_18.033632_g33288_i0 | PRJNA690592 | 34295 | 519 | 18.033632 | 93.59455008 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 776 | 0 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g33288 | i0 | 93.642 | 100.194605009634 | 519 | 33 | 100 | 0 | 1 | 519 | 165 | 683 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 52001 | 776 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 21074196 | 21074196 | PRJNA690592_S_NODE_3957_length_1309_cov_8.705502_g3531_i0 | PRJNA690592 | 3957 | 1309 | 8.705502 | 113.95502118 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1284 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g3531 | i0 | 95.844 | 66.3292589763178 | 794 | 33 | 61 | 0 | 516 | 1309 | 893 | 100 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 86825 | 1284 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23624320 | 23624320 | PRJNA690592_S_NODE_219119_length_230_cov_15.057325_g218105_i0 | PRJNA690592 | 219119 | 230 | 15.057325 | 34.6318475 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.4799999999999999e-53 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g218105 | i0 | 84.348 | 86.6913043478261 | 230 | 33 | 99 | 3 | 1 | 227 | 216 | 445 | Paulinella micropora gene for actin, complete cds | blastn | 19939 | 222 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 23624553 | 23624553 | PRJNA690592_S_NODE_50439_length_437_cov_13.233516_g49425_i0 | PRJNA690592 | 50439 | 437 | 13.233516 | 57.83046492 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 1.3400000000000002e-91 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g49425 | i0 | 83.5 | 48.1372997711671 | 400 | 41 | 91 | 18 | 41 | 437 | 4039 | 3662 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21036 | 350 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 24131013 | 24131013 | PRJNA690592_S_NODE_85819_length_348_cov_7.341818_g84805_i0 | PRJNA690592 | 85819 | 348 | 7.341818 | 25.54952664 | Gymnochlora | 67808 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 1.1399999999999999e-31 | NTclustered | gi|220983370|dbj|AB453006.1| | 67809 | g84805 | i0 | 82.123 | 50.7844827586207 | 179 | 29 | 51 | 3 | 1 | 176 | 2882 | 3060 | Gymnochlora stellata gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 17673 | 150 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 25405554 | 25405554 | PRJNA690592_S_NODE_59540_length_407_cov_16.287425_g58526_i0 | PRJNA690592 | 59540 | 407 | 16.287425 | 66.28981975 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 741 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g58526 | i0 | 99.509 | 100.479115479115 | 407 | 2 | 100 | 0 | 1 | 407 | 625 | 1031 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 40895 | 747 | 0.991967871485944 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;