contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA290839" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 372904 | 372904 | PRJNA290839_P_NODE_1501_length_244_cov_0.912281_g1480_i0 | PRJNA290839 | 1501 | 244 | 0.912281 | 2.22596564 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 9.88e-26 | NTclustered | gi|156098780|ref|XM_001615356.1| | 5855 | g1480 | i0 | 87.5 | 1.68032786885246 | 112 | 14 | 46 | 0 | 2 | 113 | 945 | 834 | Plasmodium vivax spermidine synthase, putative (PVX_092065), mRNA | blastn | 410 | 130 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 10576833 | 10576833 | PRJNA290839_P_NODE_329_length_469_cov_1.659091_g308_i0 | PRJNA290839 | 329 | 469 | 1.659091 | 7.78113679 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|1620167712|ref|XM_028681606.1| | 880535 | g308 | i0 | 94.595 | 0.0788912579957356 | 37 | 1 | 8 | 1 | 27 | 62 | 14964 | 15000 | Plasmodium sp. gorilla clade G2 E3 ubiquitin-protein ligase, putative (PADL01_0825300), partial mRNA | blastn | 37 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 13126719 | 13126719 | PRJNA290839_P_NODE_591_length_333_cov_1.196154_g570_i0 | PRJNA290839 | 591 | 333 | 1.196154 | 3.98319282 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 9.389999999999999e-132 | NTclustered | gi|829187607|ref|XM_001011429.3| | 312017 | g570 | i0 | 95.96 | 6.8018018018018 | 297 | 12 | 89 | 0 | 1 | 297 | 297 | 1 | Tetrahymena thermophila SB210 40S ribosomal protein S23 partial mRNA | blastn | 2265 | 483 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13126720 | 13126720 | PRJNA290839_P_NODE_71_length_1116_cov_2.725791_g53_i0 | PRJNA290839 | 71 | 1116 | 2.725791 | 30.41982756 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 1450 | 0 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g53 | i0 | 90.161 | 98.3440860215054 | 1118 | 105 | 100 | 5 | 1 | 1116 | 1135 | 21 | Pyrocystis lunula actin mRNA, complete cds | blastn | 109752 | 1450 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 15675638 | 15675638 | PRJNA290839_P_NODE_653_length_317_cov_1.135246_g632_i0 | PRJNA290839 | 653 | 317 | 1.135246 | 3.59872982 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 2.0399999999999995e-88 | NTclustered | gi|829143070|ref|XM_001009843.3| | 312017 | g632 | i0 | 88.809 | 0.873817034700315 | 277 | 29 | 87 | 2 | 40 | 315 | 849 | 1124 | Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA | blastn | 277 | 339 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19498822 | 19498822 | PRJNA290839_P_NODE_716_length_303_cov_1.013043_g695_i0 | PRJNA290839 | 716 | 303 | 1.013043 | 3.06952029 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 353 | 6.91e-93 | NTclustered | gi|161015559|gb|EF577184.1| | 1117027 | g695 | i0 | 88 | 37.2541254125413 | 300 | 34 | 99 | 2 | 2 | 300 | 514 | 812 | Spumella-like flagellate JBM10 beta-tubulin gene, partial cds | blastn | 11288 | 353 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 24599009 | 24599009 | PRJNA290839_P_NODE_840_length_280_cov_1.130435_g819_i0 | PRJNA290839 | 840 | 280 | 1.130435 | 3.165218 | Actinosphaerium nucleofilum | 238767 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 2.19e-117 | NTclustered | gi|33089895|gb|AY283757.1| | 238767 | g819 | i0 | 94.643 | 99.0285714285714 | 280 | 15 | 100 | 0 | 1 | 280 | 365 | 86 | Actinosphaerium nucleofilum isolate Anu4_3 actin gene, partial cds | blastn | 27728 | 435 | 1 | Eukaryota | Sar | Actinophryidae | Actinosphaerium | Actinosphaerium nucleofilum |
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);;