contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3026243 | 3026243 | PRJNA494251_P_NODE_28943_length_275_cov_6.168317_g28629_i0 | PRJNA494251 | 28943 | 275 | 6.168317 | 16.96287175 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 3.88e-60 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g28629 | i0 | 82.971 | 40.7054545454545 | 276 | 41 | 99 | 5 | 2 | 272 | 2304 | 2030 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 11194 | 244 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 4302495 | 4302495 | PRJNA494251_P_NODE_8164_length_460_cov_3.131783_g7861_i0 | PRJNA494251 | 8164 | 460 | 3.131783 | 14.4062018 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 3.5299999999999995e-167 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g7861 | i0 | 90.217 | 93.8217391304348 | 460 | 45 | 100 | 0 | 1 | 460 | 150 | 609 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 43158 | 601 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 6852736 | 6852736 | PRJNA494251_P_NODE_11246_length_402_cov_6.170213_g10940_i0 | PRJNA494251 | 11246 | 402 | 6.170213 | 24.80425626 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 3.35e-102 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g10940 | i0 | 85.6 | 54.863184079602 | 375 | 44 | 92 | 10 | 33 | 402 | 4039 | 3670 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22055 | 385 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6852741 | 6852741 | PRJNA494251_P_NODE_11666_length_396_cov_2.712074_g11360_i0 | PRJNA494251 | 11666 | 396 | 2.712074 | 10.73981304 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 4.6e-46 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g11360 | i0 | 93.893 | 42.2626262626263 | 131 | 8 | 33 | 0 | 3 | 133 | 638 | 768 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 16736 | 198 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 6853249 | 6853249 | PRJNA494251_P_NODE_8486_length_453_cov_4.473684_g8182_i0 | PRJNA494251 | 8486 | 453 | 4.473684 | 20.26578852 | Homocognata cf. vulgaris | 2231174 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 6.289999999999999e-110 | NTclustered | gi|1402550492|gb|MH488778.1| | 2231174 | g8182 | i0 | 84.471 | 90.3112582781457 | 425 | 56 | 93 | 6 | 30 | 451 | 2933 | 2516 | Homocognata cf. vulgaris isolate CGS2A sequence | blastn | 40911 | 411 | 1 | Eukaryota | Sar | Cercozoa | Homocognata | Homocognata cf. vulgaris | |||||
| 9403335 | 9403335 | PRJNA494251_P_NODE_31828_length_265_cov_8.489583_g31514_i0 | PRJNA494251 | 31828 | 265 | 8.489583 | 22.49739495 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 7.949999999999999e-67 | NTclustered | gi|33346934|gb|AY251797.1| | 1561963 | g31514 | i0 | 88.584 | 74.9056603773585 | 219 | 25 | 83 | 0 | 47 | 265 | 226 | 444 | Lotharella amoeboformis ubiquitin/actin fusion protein 2 gene, partial cds | blastn | 19850 | 267 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 10678895 | 10678895 | PRJNA494251_P_NODE_26529_length_284_cov_3.033175_g26215_i0 | PRJNA494251 | 26529 | 284 | 3.033175 | 8.614217 | Sandona mutans | 563755 | SAR_Eukaryotes | SAR_Eukaryotes | 525 | 1.2899999999999994e-144 | NTclustered | gi|2163362299|dbj|LC663795.1| | 563755 | g26215 | i0 | 100 | 100.707746478873 | 284 | 0 | 100 | 0 | 1 | 284 | 1539 | 1256 | Sandona mutans Flagella An1019C gene for 18S rRNA, partial sequence | blastn | 28601 | 525 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Sandonidae | Sandona | Sandona mutans | |||
| 10678938 | 10678938 | PRJNA494251_P_NODE_30069_length_271_cov_3.000000_g29755_i0 | PRJNA494251 | 30069 | 271 | 3 | 8.13 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 6.62e-33 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g29755 | i0 | 84.568 | 7.60885608856089 | 162 | 18 | 58 | 6 | 114 | 271 | 3900 | 3742 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 2062 | 154 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13228989 | 13228989 | PRJNA494251_P_NODE_15951_length_348_cov_4.250909_g15638_i0 | PRJNA494251 | 15951 | 348 | 4.250909 | 14.79316332 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 5.14e-50 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g15638 | i0 | 86.598 | 47.801724137931 | 194 | 22 | 55 | 4 | 158 | 348 | 3901 | 3709 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16635 | 211 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13229010 | 13229010 | PRJNA494251_P_NODE_17411_length_336_cov_1.376426_g17097_i0 | PRJNA494251 | 17411 | 336 | 1.376426 | 4.62479136 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 9.689999999999998e-117 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g17097 | i0 | 90.741 | 97.0178571428571 | 324 | 30 | 96 | 0 | 1 | 324 | 2069 | 1746 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 32598 | 433 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 13229029 | 13229029 | PRJNA494251_P_NODE_1891_length_865_cov_34.900253_g1661_i0 | PRJNA494251 | 1891 | 865 | 34.900253 | 301.88718845 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 968 | 0 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g1661 | i0 | 91.583 | 71.321387283237 | 701 | 59 | 81 | 0 | 1 | 701 | 68 | 768 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 61693 | 968 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 14504388 | 14504388 | PRJNA494251_S_NODE_712_length_256_cov_1.262295_g697_i0 | PRJNA494251 | 712 | 256 | 1.262295 | 3.2314752 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.65e-63 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g697 | i0 | 85.542 | 45.47265625 | 249 | 30 | 95 | 3 | 14 | 256 | 1631 | 1879 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 11641 | 255 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 15778260 | 15778260 | PRJNA494251_P_NODE_9013_length_442_cov_5.482385_g8709_i0 | PRJNA494251 | 9013 | 442 | 5.482385 | 24.2321417 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 5.699999999999998e-160 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g8709 | i0 | 90.293 | 100.599547511312 | 443 | 40 | 100 | 3 | 1 | 442 | 2069 | 1629 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 44465 | 577 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 16409644 | 16409644 | PRJNA494251_S_NODE_653_length_266_cov_0.129534_g638_i0 | PRJNA494251 | 653 | 266 | 0.129534 | 0.34456044 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 2.04e-127 | NTclustered | gi|219524794|gb|EU709157.1| | 175275 | g638 | i0 | 100 | 95.1127819548872 | 253 | 0 | 95 | 0 | 1 | 253 | 866 | 614 | Uncultured cercozoan isolate HetPan9 18S ribosomal RNA gene, partial sequence | blastn | 25300 | 468 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 18958499 | 18958499 | PRJNA494251_P_NODE_51895_length_226_cov_2.718954_g51581_i0 | PRJNA494251 | 51895 | 226 | 2.718954 | 6.14483604 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g51581 | i0 | 94.286 | 11.8849557522124 | 35 | 2 | 15 | 0 | 1 | 35 | 2383 | 2349 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 2686 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 19600974 | 19600974 | PRJNA494251_P_NODE_10736_length_410_cov_5.139466_g10430_i0 | PRJNA494251 | 10736 | 410 | 5.139466 | 21.0718106 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 3.67e-52 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g10430 | i0 | 83.898 | 49.3024390243902 | 236 | 30 | 56 | 7 | 180 | 410 | 3901 | 3669 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20214 | 219 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 20877448 | 20877448 | PRJNA494251_S_NODE_737_length_253_cov_1.500000_g722_i0 | PRJNA494251 | 737 | 253 | 1.5 | 3.795 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.63e-40 | NTclustered | gi|301014702|gb|GQ377715.1| | 323453 | g722 | i0 | 83.077 | 12.4703557312253 | 195 | 33 | 77 | 0 | 14 | 208 | 282 | 476 | Heteromita sp. PRA-74 ribosomal protein S23a (rps23a) mRNA, complete cds | blastn | 3155 | 178 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 23427955 | 23427955 | PRJNA494251_P_NODE_50059_length_241_cov_0.916667_g49745_i0 | PRJNA494251 | 50059 | 241 | 0.916667 | 2.20916747 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.63e-46 | NTclustered | gi|27734382|gb|AY099146.1| | 39714 | g49745 | i0 | 84.39 | 119.419087136929 | 205 | 28 | 84 | 4 | 9 | 211 | 394 | 192 | Euglypha rotunda isolate pub1 polyubiquitin gene, partial cds | blastn | 28780 | 198 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 24701534 | 24701534 | PRJNA494251_P_NODE_52160_length_217_cov_4.916667_g51846_i0 | PRJNA494251 | 52160 | 217 | 4.916667 | 10.66916739 | Cryothecomonas sp. APCC MC5-1Cryo | 741088 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 3.81e-59 | NTclustered | gi|290760480|gb|GQ144683.1| | 741088 | g51846 | i0 | 86.758 | 71.4055299539171 | 219 | 25 | 100 | 4 | 1 | 217 | 2576 | 2792 | Cryothecomonas sp. APCC MC5-1Cryo large subunit ribosomal RNA gene, partial sequence | blastn | 15495 | 241 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Cryomonadida | Protaspidae | Cryothecomonas | Cryothecomonas sp. APCC MC5-1Cryo |
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);;