contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 487107 | 487107 | PRJNA520845_P_NODE_100421_length_371_cov_1.412752_g98922_i0 | PRJNA520845 | 100421 | 371 | 1.412752 | 5.24130992 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 8.39e-113 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g98922 | i0 | 87.228 | 55.4851752021563 | 368 | 47 | 99 | 0 | 2 | 369 | 711 | 344 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 20585 | 420 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 487492 | 487492 | PRJNA520845_P_NODE_114801_length_348_cov_1.003636_g113302_i0 | PRJNA520845 | 114801 | 348 | 1.003636 | 3.49265328 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.7e-142 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g113302 | i0 | 93.642 | 94.4913793103448 | 346 | 22 | 99 | 0 | 3 | 348 | 711 | 366 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 32883 | 518 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 487773 | 487773 | PRJNA520845_P_NODE_125241_length_333_cov_3.115385_g123742_i0 | PRJNA520845 | 125241 | 333 | 3.115385 | 10.37423205 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 616 | 8.87e-172 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g123742 | i0 | 100 | 3.19219219219219 | 333 | 0 | 100 | 0 | 1 | 333 | 125 | 457 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1063 | 616 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 1111433 | 1111433 | PRJNA520845_P_NODE_182601_length_276_cov_1.004926_g181102_i0 | PRJNA520845 | 182601 | 276 | 1.004926 | 2.77359576 | Thaumatomastigidae | 45098 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 3.48e-140 | NTclustered | gi|33309605|gb|AF411259.1| | 188939 | g181102 | i0 | 100 | 99.6304347826087 | 276 | 0 | 100 | 0 | 1 | 276 | 98 | 373 | Thaumatomonas seravini 18S ribosomal RNA gene, complete sequence | blastn | 27498 | 510 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 1764206 | 1764206 | PRJNA520845_P_NODE_165822_length_289_cov_1.282407_g164323_i0 | PRJNA520845 | 165822 | 289 | 1.282407 | 3.70615623 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.7199999999999998e-133 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g164323 | i0 | 97.544 | 93.5432525951557 | 285 | 7 | 99 | 0 | 1 | 285 | 481 | 765 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 27034 | 488 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 3041712 | 3041712 | PRJNA520845_P_NODE_23183_length_801_cov_2.681319_g21836_i0 | PRJNA520845 | 23183 | 801 | 2.681319 | 21.47736519 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 957 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g21836 | i0 | 97.336 | 75.0861423220974 | 563 | 15 | 70 | 0 | 239 | 801 | 893 | 331 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 60144 | 957 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4314755 | 4314755 | PRJNA520845_P_NODE_126004_length_333_cov_0.800000_g124505_i0 | PRJNA520845 | 126004 | 333 | 0.8 | 2.664 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.32e-70 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g124505 | i0 | 82.789 | 52.6366366366366 | 337 | 34 | 99 | 17 | 2 | 333 | 3994 | 3677 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17528 | 279 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 5592171 | 5592171 | PRJNA520845_P_NODE_145725_length_309_cov_2.097458_g144226_i0 | PRJNA520845 | 145725 | 309 | 2.097458 | 6.48114522 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 571 | 1.7899999999999995e-158 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g144226 | i0 | 100 | 52.5566343042071 | 309 | 0 | 100 | 0 | 1 | 309 | 1803 | 2111 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 16240 | 571 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 5593017 | 5593017 | PRJNA520845_P_NODE_176645_length_280_cov_1.714976_g175146_i0 | PRJNA520845 | 176645 | 280 | 1.714976 | 4.8019328 | Massisteria marina | 127229 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 1.04e-100 | NTclustered | gi|300676725|gb|GQ377649.1| | 127229 | g175146 | i0 | 91.367 | 130.592857142857 | 278 | 22 | 99 | 2 | 3 | 279 | 1091 | 815 | Massisteria marina alpha-tubulin (Atub) gene, partial cds | blastn | 36566 | 379 | 1 | Eukaryota | Sar | Cercozoa | Massisteriidae | Massisteria | Massisteria marina | ||||
| 5593335 | 5593335 | PRJNA520845_P_NODE_187965_length_271_cov_1.808081_g186466_i0 | PRJNA520845 | 187965 | 271 | 1.808081 | 4.89989951 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 4.9100000000000005e-64 | NTclustered | gi|302563030|dbj|AB546338.1| | 717846 | g186466 | i0 | 83.088 | 20.5239852398524 | 272 | 40 | 99 | 4 | 3 | 271 | 631 | 899 | Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds | blastn | 5562 | 257 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 | ||
| 5596347 | 5596347 | PRJNA520845_P_NODE_60205_length_480_cov_2.665848_g58709_i0 | PRJNA520845 | 60205 | 480 | 2.665848 | 12.7960704 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 819 | 0 | NTclustered | gi|238617638|gb|FJ973398.1| | 646463 | g58709 | i0 | 97.495 | 100.445833333333 | 479 | 12 | 99 | 0 | 1 | 479 | 339 | 817 | Gymnophrys sp. ATCC 50923 actin (act) gene, partial cds | blastn | 48214 | 819 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 12590901 | 12590901 | PRJNA520845_P_NODE_56810_length_495_cov_1.118483_g55316_i0 | PRJNA520845 | 56810 | 495 | 1.118483 | 5.53649085 | Verrucomonas | 2545269 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.26e-47 | NTclustered | gi|290760488|gb|GQ144691.1| | 629763 | g55316 | i0 | 82.041 | 42.2606060606061 | 245 | 38 | 49 | 6 | 46 | 288 | 1487 | 1247 | Cercozoa sp. CC-2009e large subunit ribosomal RNA gene, partial sequence | blastn | 20919 | 204 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas bifida | |||
| 14519080 | 14519080 | PRJNA520845_P_NODE_210412_length_253_cov_1.444444_g208913_i0 | PRJNA520845 | 210412 | 253 | 1.444444 | 3.65444332 | Cercozoa sp. CC-2009d | 629762 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2799999999999999e-54 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g208913 | i0 | 82.89 | 36.0553359683794 | 263 | 33 | 99 | 9 | 2 | 253 | 2311 | 2050 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 9122 | 226 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 15790798 | 15790798 | PRJNA520845_P_NODE_136773_length_319_cov_2.341463_g135274_i0 | PRJNA520845 | 136773 | 319 | 2.341463 | 7.46926697 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 1.44e-159 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g135274 | i0 | 99.369 | 100.373040752351 | 317 | 2 | 99 | 0 | 3 | 319 | 12 | 328 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 32019 | 575 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 15794455 | 15794455 | PRJNA520845_P_NODE_31173_length_682_cov_2.732348_g29737_i0 | PRJNA520845 | 31173 | 682 | 2.732348 | 18.63461336 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1144 | 0 | NTclustered | gi|300676732|gb|GQ377662.1| | 188950 | g29737 | i0 | 96.921 | 92.7947214076246 | 682 | 21 | 100 | 0 | 1 | 682 | 816 | 135 | Bodomorpha minima alpha-tubulin (Atub) gene, partial cds | blastn | 63286 | 1144 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 17068495 | 17068495 | PRJNA520845_P_NODE_253514_length_243_cov_1.588235_g252015_i0 | PRJNA520845 | 253514 | 243 | 1.588235 | 3.85941105 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1099999999999995e-119 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g252015 | i0 | 99.587 | 41.2139917695473 | 242 | 1 | 99 | 0 | 2 | 243 | 2315 | 2074 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 10015 | 442 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 19616534 | 19616534 | PRJNA520845_P_NODE_223756_length_249_cov_0.965909_g222257_i0 | PRJNA520845 | 223756 | 249 | 0.965909 | 2.40511341 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.61e-47 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g222257 | i0 | 85.714 | 144.156626506024 | 189 | 27 | 76 | 0 | 61 | 249 | 1 | 189 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 35895 | 200 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 22167847 | 22167847 | PRJNA520845_P_NODE_245878_length_245_cov_0.895349_g244379_i0 | PRJNA520845 | 245878 | 245 | 0.895349 | 2.19360505 | Gymnophrys sp. ATCC 50923 | 646463 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 8.68e-121 | NTclustered | gi|238617604|gb|FJ973379.1| | 646463 | g244379 | i0 | 99.59 | 99.2979591836735 | 244 | 1 | 99 | 0 | 1 | 244 | 1827 | 2070 | Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence | blastn | 24328 | 446 | 1 | Eukaryota | Sar | Cercozoa | Gymnophrys | Gymnophrys sp. ATCC 50923 | |||||
| 24714451 | 24714451 | PRJNA520845_P_NODE_146520_length_308_cov_3.795745_g145021_i0 | PRJNA520845 | 146520 | 308 | 3.795745 | 11.6908946 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 569 | 6.419999999999998e-158 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g145021 | i0 | 100 | 11.5292207792208 | 308 | 0 | 100 | 0 | 1 | 308 | 810 | 1117 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 3551 | 569 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. |
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);;