contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA980585" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2229877 | 2229877 | PRJNA980585_P_NODE_18242_length_334_cov_2.471264_g17988_i0 | PRJNA980585 | 18242 | 334 | 2.471264 | 8.25402176 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 3.69e-71 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g17988 | i0 | 93.229 | 58.0479041916168 | 192 | 12 | 57 | 1 | 1 | 191 | 3665 | 3856 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 19388 | 281 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 2545131 | 2545131 | PRJNA980585_P_NODE_9222_length_437_cov_1.925824_g8968_i0 | PRJNA980585 | 9222 | 437 | 1.925824 | 8.41585088 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 532 | 1.2399999999999999e-146 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g8968 | i0 | 88.761 | 100.485125858124 | 436 | 48 | 99 | 1 | 1 | 436 | 1208 | 1642 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 43912 | 532 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 7332176 | 7332176 | PRJNA980585_P_NODE_13806_length_371_cov_3.416107_g13552_i0 | PRJNA980585 | 13806 | 371 | 3.416107 | 12.67375697 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.99e-44 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g13552 | i0 | 95.798 | 26.1509433962264 | 119 | 5 | 51 | 0 | 1 | 119 | 3721 | 3839 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 9702 | 193 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 8922201 | 8922201 | PRJNA980585_P_NODE_22387_length_309_cov_2.283898_g22133_i0 | PRJNA980585 | 22387 | 309 | 2.283898 | 7.05724482 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 571 | 1.7899999999999995e-158 | NTclustered | gi|82547952|gb|DQ211594.1| | 188950 | g22133 | i0 | 100 | 98.3042071197411 | 309 | 0 | 100 | 0 | 1 | 309 | 542 | 850 | Bodomorpha minima strain HFCC55 18S ribosomal RNA gene, partial sequence | blastn | 30376 | 571 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9882551 | 9882551 | PRJNA980585_P_NODE_1648_length_906_cov_2.864346_g1435_i0 | PRJNA980585 | 1648 | 906 | 2.864346 | 25.95097476 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 2.15e-122 | NTclustered | gi|116222178|gb|DQ980465.1| | 407209 | g1435 | i0 | 78.551 | 25.8763796909492 | 704 | 139 | 77 | 6 | 24 | 717 | 611 | 1312 | Thaumatomonas sp. TMT002 Hsp90 mRNA, partial cds | blastn | 23444 | 453 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 9882617 | 9882617 | PRJNA980585_P_NODE_19388_length_327_cov_1.720472_g19134_i0 | PRJNA980585 | 19388 | 327 | 1.720472 | 5.62594344 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 2.14e-78 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g19134 | i0 | 95.767 | 72.7675840978593 | 189 | 8 | 58 | 0 | 1 | 189 | 649 | 837 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 23795 | 305 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11157836 | 11157836 | PRJNA980585_P_NODE_12129_length_391_cov_1.396226_g11875_i0 | PRJNA980585 | 12129 | 391 | 1.396226 | 5.45924366 | Thaumatomonas coloniensis | 352461 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 3.07e-142 | NTclustered | gi|160688657|gb|EU138879.1| | 352461 | g11875 | i0 | 91.799 | 93.8618925831202 | 378 | 22 | 95 | 5 | 1 | 372 | 1504 | 1878 | Thaumatomonas coloniensis strain HFCC59 28S ribosomal RNA gene, partial sequence | blastn | 36700 | 518 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas coloniensis | ||
| 12433527 | 12433527 | PRJNA980585_P_NODE_10190_length_420_cov_1.659942_g9936_i0 | PRJNA980585 | 10190 | 420 | 1.659942 | 6.9717564 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 1.55e-135 | NTclustered | gi|1389527545|dbj|LC383945.1| | 1928728 | g9936 | i0 | 88.038 | 98.1 | 418 | 50 | 99 | 0 | 3 | 420 | 1144 | 727 | Paulinella micropora gene for actin, complete cds | blastn | 41202 | 496 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 12433569 | 12433569 | PRJNA980585_P_NODE_12110_length_391_cov_2.034591_g11856_i0 | PRJNA980585 | 12110 | 391 | 2.034591 | 7.95525081 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.13e-126 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g11856 | i0 | 88.265 | 100.281329923274 | 392 | 42 | 100 | 4 | 1 | 391 | 1249 | 1637 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 39210 | 466 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12433578 | 12433578 | PRJNA980585_P_NODE_12670_length_384_cov_2.652733_g12416_i0 | PRJNA980585 | 12670 | 384 | 2.652733 | 10.18649472 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 4.8899999999999984e-160 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g12416 | i0 | 93.75 | 100.893229166667 | 384 | 24 | 100 | 0 | 1 | 384 | 1599 | 1216 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 38743 | 577 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12433882 | 12433882 | PRJNA980585_P_NODE_28390_length_284_cov_1.407583_g28136_i0 | PRJNA980585 | 28390 | 284 | 1.407583 | 3.99753572 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.849999999999998e-132 | NTclustered | gi|48727795|gb|AY620285.1| | 175275 | g28136 | i0 | 97.527 | 99.7394366197183 | 283 | 6 | 99 | 1 | 2 | 284 | 291 | 10 | Uncultured cercozoan clone 4-5.2 small subunit ribosomal RNA gene, partial sequence | blastn | 28326 | 483 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 14982265 | 14982265 | PRJNA980585_P_NODE_11932_length_393_cov_30.906250_g11678_i0 | PRJNA980585 | 11932 | 393 | 30.90625 | 121.4615625 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 5.54e-90 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11678 | i0 | 83.854 | 53.8091603053435 | 384 | 39 | 97 | 16 | 14 | 393 | 4020 | 3656 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21147 | 344 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14982451 | 14982451 | PRJNA980585_P_NODE_21772_length_313_cov_1.283333_g21518_i0 | PRJNA980585 | 21772 | 313 | 1.283333 | 4.01683229 | Mesofila limnetica | 1979842 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 6.82e-128 | NTclustered | gi|88792585|gb|DQ386166.1| | 1979842 | g21518 | i0 | 94.006 | 90.591054313099 | 317 | 8 | 100 | 7 | 1 | 313 | 1816 | 1507 | Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence | blastn | 28355 | 470 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila limnetica | ||||
| 16257318 | 16257318 | PRJNA980585_P_NODE_13993_length_369_cov_5.689189_g13739_i0 | PRJNA980585 | 13993 | 369 | 5.689189 | 20.99310741 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 1.13e-81 | NTclustered | gi|160337323|gb|EF455755.1| | 188939 | g13739 | i0 | 82.258 | 100.40379403794 | 372 | 60 | 100 | 6 | 1 | 369 | 323 | 691 | Thaumatomonas seravini actin gene, partial cds | blastn | 37049 | 316 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 18806816 | 18806816 | PRJNA980585_P_NODE_4775_length_576_cov_18.322068_g4521_i0 | PRJNA980585 | 4775 | 576 | 18.322068 | 105.53511168 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 2.14e-150 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g4521 | i0 | 84.192 | 97.8194444444444 | 563 | 87 | 98 | 2 | 15 | 576 | 765 | 204 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 56344 | 545 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 19120695 | 19120695 | PRJNA980585_P_NODE_26775_length_288_cov_5.125581_g26521_i0 | PRJNA980585 | 26775 | 288 | 5.125581 | 14.76167328 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 532 | 7.8e-147 | NTclustered | gi|319659368|gb|GU320605.1| | 943207 | g26521 | i0 | 100 | 99.4444444444444 | 288 | 0 | 100 | 0 | 1 | 288 | 1528 | 1815 | Reticulamoeba sp. COHH 9 18S ribosomal RNA gene, partial sequence | blastn | 28640 | 532 | 1 | Eukaryota | Sar | Cercozoa | Reticulamoeba | Reticulamoeba sp. COHH 9 | |||||
| 20080979 | 20080979 | PRJNA980585_P_NODE_14796_length_361_cov_10.732639_g14542_i0 | PRJNA980585 | 14796 | 361 | 10.732639 | 38.74482679 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 1.37e-105 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g14542 | i0 | 86.612 | 58.0969529085873 | 366 | 39 | 100 | 10 | 1 | 361 | 4021 | 3661 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20973 | 396 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20395660 | 20395660 | PRJNA980585_P_NODE_12376_length_388_cov_1.517460_g12122_i0 | PRJNA980585 | 12376 | 388 | 1.51746 | 5.8877448 | Mesofilidae | 1938512 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.3e-21 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g12122 | i0 | 92.771 | 21.6546391752577 | 83 | 3 | 21 | 3 | 305 | 386 | 2008 | 2088 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 8402 | 117 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 21356894 | 21356894 | PRJNA980585_P_NODE_39337_length_254_cov_1.066298_g39083_i0 | PRJNA980585 | 39337 | 254 | 1.066298 | 2.70839692 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 1.21e-94 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g39083 | i0 | 92.126 | 44.3622047244095 | 254 | 20 | 100 | 0 | 1 | 254 | 749 | 496 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 11268 | 359 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 21356996 | 21356996 | PRJNA980585_P_NODE_46137_length_248_cov_1.645714_g45883_i0 | PRJNA980585 | 46137 | 248 | 1.645714 | 4.08137072 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.73e-63 | NTclustered | gi|33346934|gb|AY251797.1| | 1561963 | g45883 | i0 | 88.208 | 76.2298387096774 | 212 | 25 | 85 | 0 | 36 | 247 | 226 | 437 | Lotharella amoeboformis ubiquitin/actin fusion protein 2 gene, partial cds | blastn | 18905 | 254 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 21357090 | 21357090 | PRJNA980585_P_NODE_5277_length_552_cov_2.265136_g5023_i0 | PRJNA980585 | 5277 | 552 | 2.265136 | 12.50355072 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 739 | 0 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g5023 | i0 | 90.909 | 78.2336956521739 | 550 | 50 | 99 | 0 | 1 | 550 | 92 | 641 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 43185 | 739 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 21671681 | 21671681 | PRJNA980585_P_NODE_14557_length_364_cov_0.996564_g14303_i0 | PRJNA980585 | 14557 | 364 | 0.996564 | 3.62749296 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 4.1e-61 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g14303 | i0 | 85.593 | 41.967032967033 | 236 | 34 | 65 | 0 | 2 | 237 | 236 | 1 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 15276 | 248 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23906941 | 23906941 | PRJNA980585_P_NODE_1379_length_978_cov_3.188950_g1192_i0 | PRJNA980585 | 1379 | 978 | 3.18895 | 31.187931 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 725 | 0 | NTclustered | gi|302026152|gb|GQ377656.1| | 646463 | g1192 | i0 | 82.801 | 81.8711656441718 | 814 | 136 | 83 | 4 | 151 | 962 | 892 | 81 | Gymnophrys sp. ATCC 50923 beta-tubulin (Btub) gene, partial cds | blastn | 80070 | 725 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 23907227 | 23907227 | PRJNA980585_P_NODE_30299_length_279_cov_1.213592_g30045_i0 | PRJNA980585 | 30299 | 279 | 1.213592 | 3.38592168 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.6999999999999998e-113 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g30045 | i0 | 93.907 | 25.5806451612903 | 279 | 17 | 100 | 0 | 1 | 279 | 427 | 705 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 7137 | 422 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 23907748 | 23907748 | PRJNA980585_P_NODE_7979_length_463_cov_5.379487_g7725_i0 | PRJNA980585 | 7979 | 463 | 5.379487 | 24.90702481 | Bodomorpha sp. HFCC55 | 624126 | SAR_Eukaryotes | SAR_Eukaryotes | 833 | 0 | NTclustered | gi|225216790|gb|FJ176705.1| | 624126 | g7725 | i0 | 99.134 | 22.1641468682505 | 462 | 4 | 99 | 0 | 2 | 463 | 708 | 247 | Bodomorpha sp. 28S ribosomal RNA gene, partial sequence | blastn | 10262 | 833 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC55 |
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);;