contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21114495 | 21114495 | PRJNA725806_P_NODE_43797_length_258_cov_8.054299_g43500_i0 | PRJNA725806 | 43797 | 258 | 8.054299 | 20.78009142 | Pelagophyceae sp. CCMP2 | 1982007 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 9.82e-15 | NR | KAJ1449104.1 | 483370 | g43500 | i0 | 59.4 | 15.5348837209302 | 64 | 26 | 74.4 | 0 | 230 | 39 | 18 | 81 | KAJ1449104.1 hypothetical protein M885DRAFT_536881 [Pelagophyceae sp. CCMP2097] | diamond | 4008 | 77.8 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagophyceae sp. CCMP2097 | ||||||
| 26735343 | 26735343 | PRJNA725806_P_NODE_8861_length_386_cov_5.452722_g8576_i0 | PRJNA725806 | 8861 | 386 | 5.452722 | 21.04750692 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.0348 | NR | CAD8074060.1 | 65129 | g8576 | i0 | 51.4 | 0.272020725388601 | 35 | 17 | 27.2 | 0 | 145 | 41 | 124 | 158 | CAD8074060.1 unnamed protein product [Paramecium sonneborni] | diamond | 105 | 44.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 27431766 | 27431766 | PRJNA725806_P_NODE_45743_length_255_cov_5.293578_g45446_i0 | PRJNA725806 | 45743 | 255 | 5.293578 | 13.4986239 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0173 | NR | XP_028526556.1 | 5849 | g45446 | i0 | 30.3 | 0.776470588235294 | 66 | 46 | 77.6 | 0 | 246 | 49 | 352 | 417 | XP_028526556.1 GPI-anchored wall transfer protein 1, putative [Plasmodium gallinaceum] | diamond | 198 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 27463252 | 27463252 | PRJNA725806_P_NODE_46603_length_254_cov_2.764977_g46306_i0 | PRJNA725806 | 46603 | 254 | 2.764977 | 7.02304158 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 6.16e-5 | NR | CAK0895895.1 | 89957 | g46306 | i0 | 52.1 | 2.27952755905512 | 48 | 23 | 56.7 | 0 | 230 | 87 | 1602 | 1649 | CAK0895895.1 unnamed protein product [Polarella glacialis] | diamond | 579 | 50.8 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 27968250 | 27968250 | PRJNA725806_P_NODE_46965_length_253_cov_5.949074_g46668_i0 | PRJNA725806 | 46965 | 253 | 5.949074 | 15.05115722 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0224 | NR | XP_067713452.1 | 5871 | g46668 | i0 | 40 | 0.770750988142292 | 65 | 38 | 75.9 | 1 | 15 | 206 | 950 | 1014 | XP_067713452.1 variant erythrocyte surface antigen-1 family protein [Babesia caballi] | diamond | 195 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 28220649 | 28220649 | PRJNA725806_P_NODE_11906_length_359_cov_12.114907_g11618_i0 | PRJNA725806 | 11906 | 359 | 12.114907 | 43.49251613 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00563 | NR | GMF48050.1 | 1490495 | g11618 | i0 | 41.7 | 0.401114206128134 | 48 | 23 | 40.1 | 1 | 38 | 181 | 50 | 92 | GMF48050.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 144 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 28347134 | 28347134 | PRJNA725806_P_NODE_27946_length_292_cov_4.623529_g27649_i0 | PRJNA725806 | 27946 | 292 | 4.6235290000000004 | 13.50070468 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0235 | NR | YP_010049591.1 | 5974 | g27649 | i0 | 38.5 | 0.667808219178082 | 65 | 36 | 62.7 | 2 | 222 | 40 | 54 | 118 | YP_010049591.1 hypothetical protein J6764_mgp19 [Halteria grandinella] | diamond | 195 | 43.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 28410399 | 28410399 | PRJNA725806_P_NODE_67626_length_226_cov_1.751323_g67326_i0 | PRJNA725806 | 67626 | 226 | 1.751323 | 3.95798998 | Effrenium voratum | 2562239 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 9.29e-4 | NR | CAJ1449546.1 | 2562239 | g67326 | i0 | 34.3 | 1.85840707964602 | 70 | 46 | 92.9 | 0 | 11 | 220 | 35 | 104 | CAJ1449546.1 unnamed protein product, partial [Effrenium voratum] | diamond | 420 | 47 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Effrenium | Effrenium voratum | |||
| 28452363 | 28452363 | PRJNA725806_P_NODE_162806_length_163_cov_1.515873_g162504_i0 | PRJNA725806 | 162806 | 163 | 1.515873 | 2.47087299 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 2.74e-12 | NR | XP_004040044.1 | 5932 | g162504 | i0 | 68.1 | 2.55828220858896 | 47 | 15 | 86.5 | 0 | 158 | 18 | 792 | 838 | XP_004040044.1 valyl-tRNA synthetase, putative [Ichthyophthirius multifiliis] | diamond | 417 | 70.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28504997 | 28504997 | PRJNA725806_P_NODE_57807_length_237_cov_10.645000_g57510_i0 | PRJNA725806 | 57807 | 237 | 10.645 | 25.22865 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00536 | NR | CDW87724.1 | 5949 | g57510 | i0 | 36.4 | 0.69620253164557 | 55 | 35 | 69.6 | 0 | 191 | 27 | 501 | 555 | CDW87724.1 abc transporter family protein [Stylonychia lemnae] | diamond | 165 | 45.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28568075 | 28568075 | PRJNA725806_P_NODE_144867_length_171_cov_2.768657_g144565_i0 | PRJNA725806 | 144867 | 171 | 2.768657 | 4.73440347 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00217 | NR | KAL4167399.1 | 164328 | g144565 | i0 | 40.4 | 2 | 57 | 26 | 86 | 2 | 4 | 150 | 193 | 249 | KAL4167399.1 hypothetical protein KRP22_012885 [Phytophthora ramorum] | diamond | 342 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 28915189 | 28915189 | PRJNA725806_P_NODE_130368_length_178_cov_6.382979_g130066_i0 | PRJNA725806 | 130368 | 178 | 6.382979 | 11.36170262 | Symbiodinium sp. KB8 | 230985 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0397 | NR | CAE7277001.1 | 230985 | g130066 | i0 | 36.8 | 0.960674157303371 | 57 | 33 | 91 | 1 | 3 | 164 | 275 | 331 | CAE7277001.1 unnamed protein product [Symbiodinium sp. KB8] | diamond | 171 | 41.6 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. KB8 | |||
| 29073539 | 29073539 | PRJNA725806_P_NODE_139408_length_174_cov_1.065693_g139106_i0 | PRJNA725806 | 139408 | 174 | 1.065693 | 1.85430582 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 6.22e-11 | NR | KAF0734551.1 | 100861 | g139106 | i0 | 50 | 8.62068965517241 | 56 | 28 | 96.6 | 0 | 1 | 168 | 174 | 229 | KAF0734551.1 hypothetical protein Ae201684_008793 [Aphanomyces euteiches] | diamond | 1500 | 66.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29683266 | 29683266 | PRJNA725806_P_NODE_65710_length_228_cov_2.973822_g65411_i0 | PRJNA725806 | 65710 | 228 | 2.973822 | 6.78031416 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0227 | NR | SCL91577.1 | 5821 | g65411 | i0 | 40.7 | 1.55263157894737 | 59 | 33 | 76.3 | 2 | 27 | 200 | 724 | 781 | SCL91577.1 conserved Plasmodium membrane protein, unknown function, partial [Plasmodium berghei] | diamond | 354 | 43.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 29957434 | 29957434 | PRJNA725806_P_NODE_154191_length_167_cov_1.146154_g153889_i0 | PRJNA725806 | 154191 | 167 | 1.146154 | 1.91407718 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 3.49e-5 | NR | CAG9331923.1 | 1481888 | g153889 | i0 | 40.4 | 0.844311377245509 | 47 | 28 | 84.4 | 0 | 163 | 23 | 423 | 469 | CAG9331923.1 unnamed protein product [Blepharisma stoltei] | diamond | 141 | 50.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30062455 | 30062455 | PRJNA725806_P_NODE_29231_length_289_cov_1.980159_g28934_i0 | PRJNA725806 | 29231 | 289 | 1.980159 | 5.72265951 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 6.28e-4 | NR | CDW75723.1 | 5949 | g28934 | i0 | 47.5 | 3.25951557093426 | 59 | 29 | 61.2 | 1 | 95 | 271 | 491 | 547 | CDW75723.1 UNKNOWN [Stylonychia lemnae] | diamond | 942 | 48.9 | 0.991820040899796 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30083724 | 30083724 | PRJNA725806_P_NODE_28472_length_291_cov_1.216535_g28175_i0 | PRJNA725806 | 28472 | 291 | 1.216535 | 3.54011685 | Nannochloropsis salina CCMP1776 | 1027361 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 8.96e-7 | NR | TFJ81113.1 | 1027361 | g28175 | i0 | 58.7 | 0.474226804123711 | 46 | 19 | 47.4 | 0 | 2 | 139 | 1673 | 1718 | TFJ81113.1 hypothetical protein NSK_007755 [Nannochloropsis salina CCMP1776] | diamond | 138 | 56.6 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Microchloropsis | Microchloropsis salina | |||
| 30494751 | 30494751 | PRJNA725806_P_NODE_88473_length_206_cov_3.627219_g88171_i0 | PRJNA725806 | 88473 | 206 | 3.627219 | 7.47207114 | Blastocystis sp. Blastoise | 3128533 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0018 | NR | KAK8801912.1 | 3128533 | g88171 | i0 | 60.6 | 0.480582524271845 | 33 | 13 | 48.1 | 0 | 158 | 60 | 238 | 270 | KAK8801912.1 hypothetical protein WA158_006307 [Blastocystis sp. Blastoise] | diamond | 99 | 45.8 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. Blastoise | |||
| 30715694 | 30715694 | PRJNA725806_P_NODE_22454_length_309_cov_1.415441_g22158_i0 | PRJNA725806 | 22454 | 309 | 1.415441 | 4.37371269 | Effrenium voratum | 2562239 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 1.56e-19 | NR | CAJ1443076.1 | 2562239 | g22158 | i0 | 46.9 | 6.52427184466019 | 96 | 47 | 93.2 | 2 | 14 | 301 | 396 | 487 | CAJ1443076.1 unnamed protein product, partial [Effrenium voratum] | diamond | 2016 | 93.2 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Effrenium | Effrenium voratum | |||
| 30842269 | 30842269 | PRJNA725806_P_NODE_674_length_814_cov_29.480051_g527_i0 | PRJNA725806 | 674 | 814 | 29.480051 | 239.96761514 | Phytophthora pseudosyringae | 221518 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 1.14e-7 | NR | KAG7379737.1 | 221518 | g527 | i0 | 42.9 | 1.27149877149877 | 70 | 40 | 25.8 | 0 | 514 | 723 | 62 | 131 | KAG7379737.1 hypothetical protein PHYPSEUDO_008231 [Phytophthora pseudosyringae] | diamond | 1035 | 64.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora pseudosyringae | ||
| 31094861 | 31094861 | PRJNA725806_P_NODE_137275_length_175_cov_1.239130_g136973_i0 | PRJNA725806 | 137275 | 175 | 1.23913 | 2.1684775 | Pelagophyceae sp. CCMP2 | 1982007 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 4.7e-4 | NR | KAJ1455476.1 | 483370 | g136973 | i0 | 57.1 | 0.6 | 35 | 15 | 60 | 0 | 107 | 3 | 358 | 392 | KAJ1455476.1 REJ domain-containing protein [Pelagophyceae sp. CCMP2097] | diamond | 105 | 47 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagophyceae sp. CCMP2097 | ||||||
| 32518657 | 32518657 | PRJNA725806_P_NODE_49179_length_250_cov_1.708920_g48882_i0 | PRJNA725806 | 49179 | 250 | 1.70892 | 4.2723 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0402 | NR | GLD97074.1 | 114742 | g48882 | i0 | 32.7 | 0.66 | 55 | 34 | 66 | 1 | 10 | 174 | 91 | 142 | GLD97074.1 hypothetical protein PINS_up005757 [Pythium insidiosum] | diamond | 165 | 42 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32613016 | 32613016 | PRJNA725806_P_NODE_124320_length_182_cov_1.062069_g124018_i0 | PRJNA725806 | 124320 | 182 | 1.062069 | 1.93296558 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.49e-11 | NR | OMJ79734.1 | 5963 | g124018 | i0 | 49.2 | 1.03846153846154 | 63 | 29 | 98.9 | 1 | 1 | 180 | 42 | 104 | OMJ79734.1 hypothetical protein SteCoe_20161 [Stentor coeruleus] | diamond | 189 | 68.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus |
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);;