contig_metadata
20 rows where bioproject = "PRJNA560029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3094626 | 3094626 | PRJNA560029_S_NODE_11343_length_356_cov_1.787986_g11119_i0 | PRJNA560029 | 11343 | 356 | 1.787986 | 6.36523016 | Hematodinium sp. | 173654 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.034 | NTclustered | gi|357196844|emb|HE610736.1| | 173654 | g11119 | i0 | 100 | 0.0786516853932584 | 28 | 0 | 8 | 0 | 329 | 356 | 29 | 2 | Hematodinium sp. mitochondrial partial small subunit ribosomal RNA (ssu rRNA gene), clone 16 | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Dinophyceae | Syndiniales | Syndiniaceae | Hematodinium | Hematodinium sp. | |||
| 4371558 | 4371558 | PRJNA560029_S_NODE_3344_length_493_cov_2.295238_g3122_i0 | PRJNA560029 | 3344 | 493 | 2.295238 | 11.31552334 | uncultured marine diatom | 285226 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|223047888|gb|FJ032658.1| | 285226 | g3122 | i0 | 100 | 1.33874239350913 | 31 | 0 | 6 | 0 | 35 | 65 | 1591 | 1621 | Uncultured marine diatom clone DH22_2A36 28S ribosomal RNA gene, partial sequence | blastn | 660 | 58.4 | 1 | Eukaryota | Sar | Bacillariophyta | uncultured marine diatom | ||||||
| 10748056 | 10748056 | PRJNA560029_S_NODE_14769_length_332_cov_2.837838_g14545_i0 | PRJNA560029 | 14769 | 332 | 2.837838 | 9.42162216 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|820693004|tpe|LN714485.1| | 572307 | g14545 | i0 | 100 | 0.168674698795181 | 28 | 0 | 8 | 0 | 202 | 229 | 5186453 | 5186426 | TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 12022751 | 12022751 | PRJNA560029_S_NODE_10210_length_365_cov_3.551370_g9986_i0 | PRJNA560029 | 10210 | 365 | 3.55137 | 12.9625005 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 8.17e-46 | NR | KAF0701708.1 | 120398 | g9986 | i0 | 65.5 | 15.172602739726 | 119 | 41 | 97.8 | 0 | 8 | 364 | 13 | 131 | KAF0701708.1 hypothetical protein As57867_007844 [Aphanomyces stellatus] | diamond | 5538 | 162 | 0.993827160493827 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 12023010 | 12023010 | PRJNA560029_S_NODE_23970_length_284_cov_2.232227_g23746_i0 | PRJNA560029 | 23970 | 284 | 2.232227 | 6.33952468 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1620167712|ref|XM_028681606.1| | 880535 | g23746 | i0 | 94.595 | 0.130281690140845 | 37 | 1 | 13 | 1 | 223 | 258 | 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 | ||
| 15158481 | 15158481 | PRJNA560029_S_NODE_38052_length_196_cov_65.512195_g37828_i0 | PRJNA560029 | 38052 | 196 | 65.512195 | 128.4039022 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.49e-92 | NTclustered | gi|27764590|gb|AY180902.1| | 5821 | g37828 | i0 | 98.98 | 99.8979591836735 | 196 | 2 | 100 | 0 | 1 | 196 | 917 | 722 | Plasmodium berghei 31 kDa antigen mRNA, complete cds | blastn | 19580 | 351 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 18396169 | 18396169 | PRJNA560029_S_NODE_8515_length_381_cov_5.542208_g8291_i0 | PRJNA560029 | 8515 | 381 | 5.542208 | 21.11581248 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.036 | NTclustered | gi|1472911924|ref|XM_022736577.2| | 88456 | g8291 | i0 | 100 | 0.073490813648294 | 28 | 0 | 7 | 0 | 269 | 296 | 805 | 778 | PREDICTED: Cyclospora cayetanensis lissencephaly-1 homolog (LOC34623454), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 26794201 | 26794201 | PRJNA560029_S_NODE_15461_length_327_cov_5.677165_g15237_i0 | PRJNA560029 | 15461 | 327 | 5.677165 | 18.56432955 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 5.67e-8 | NR | DBA04470.1 | 4803 | g15237 | i0 | 44.7 | 0.697247706422018 | 76 | 42 | 69.7 | 0 | 320 | 93 | 426 | 501 | DBA04470.1 TPA: hypothetical protein N0F65_010066 [Lagenidium giganteum] | diamond | 228 | 60.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 26857830 | 26857830 | PRJNA560029_S_NODE_23301_length_287_cov_2.186916_g23077_i0 | PRJNA560029 | 23301 | 287 | 2.186916 | 6.27644892 | Pelagomonas calceolata | 35677 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0453 | NR | CAH0375798.1 | 35677 | g23077 | i0 | 38.8 | 0.700348432055749 | 67 | 40 | 70 | 1 | 203 | 3 | 4 | 69 | CAH0375798.1 unnamed protein product [Pelagomonas calceolata] | diamond | 201 | 43.1 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata | |||
| 26857831 | 26857831 | PRJNA560029_S_NODE_30741_length_256_cov_1.584699_g30517_i0 | PRJNA560029 | 30741 | 256 | 1.584699 | 4.05682944 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0158 | NR | CAG9328855.1 | 1481888 | g30517 | i0 | 43.2 | 0.515625 | 44 | 24 | 51.6 | 1 | 105 | 236 | 114 | 156 | CAG9328855.1 unnamed protein product [Blepharisma stoltei] | diamond | 132 | 43.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 27250975 | 27250975 | PRJNA560029_S_NODE_4763_length_442_cov_6.398374_g4539_i0 | PRJNA560029 | 4763 | 442 | 6.398374 | 28.28081308 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 2.54e-18 | NR | TNV78386.1 | 5974 | g4539 | i0 | 43.2 | 7.21493212669683 | 95 | 53 | 64.5 | 1 | 441 | 157 | 238 | 331 | TNV78386.1 hypothetical protein FGO68_gene15615 [Halteria grandinella] | diamond | 3189 | 91.3 | 0.991237677984666 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 27693501 | 27693501 | PRJNA560029_S_NODE_33484_length_246_cov_3.971098_g33260_i0 | PRJNA560029 | 33484 | 246 | 3.971098 | 9.76890108 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 2.7e-15 | NR | SPQ93309.1 | 37360 | g33260 | i0 | 64.9 | 1.39024390243902 | 57 | 20 | 69.5 | 0 | 240 | 70 | 470 | 526 | SPQ93309.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 342 | 80.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28261356 | 28261356 | PRJNA560029_S_NODE_17726_length_314_cov_4.431535_g17502_i0 | PRJNA560029 | 17726 | 314 | 4.431535 | 13.9150199 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 2.94e-7 | NR | RLN99890.1 | 112090 | g17502 | i0 | 33.3 | 1.61464968152866 | 87 | 52 | 82.2 | 2 | 40 | 297 | 256 | 337 | RLN99890.1 hypothetical protein DYB28_012959, partial [Aphanomyces astaci] | diamond | 507 | 58.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 29208934 | 29208934 | PRJNA560029_S_NODE_23749_length_285_cov_2.080189_g23525_i0 | PRJNA560029 | 23749 | 285 | 2.080189 | 5.92853865 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 7.53e-4 | NR | CAD8047472.1 | 5886 | g23525 | i0 | 70.8 | 1.01052631578947 | 24 | 7 | 25.3 | 0 | 20 | 91 | 33 | 56 | CAD8047472.1 unnamed protein product [Paramecium primaurelia] | diamond | 288 | 46.6 | 0.991416309012876 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 29429536 | 29429536 | PRJNA560029_S_NODE_35129_length_242_cov_1.218935_g34905_i0 | PRJNA560029 | 35129 | 242 | 1.218935 | 2.9498227 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00173 | NR | CAE7541831.1 | 2951 | g34905 | i0 | 56.3 | 3 | 32 | 14 | 39.7 | 0 | 74 | 169 | 143 | 174 | CAE7541831.1 unnamed protein product [Symbiodinium microadriaticum] | diamond | 726 | 45.8 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 30314659 | 30314659 | PRJNA560029_S_NODE_7772_length_390_cov_6.340694_g7548_i0 | PRJNA560029 | 7772 | 390 | 6.340694 | 24.7287066 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 2.19e-14 | NR | KAG1709295.1 | 4784 | g7548 | i0 | 63.5 | 7.97692307692308 | 74 | 16 | 55.4 | 3 | 5 | 220 | 642 | 706 | KAG1709295.1 hypothetical protein DVH05_019938 [Phytophthora capsici] | diamond | 3111 | 80.5 | 0.990062111801242 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30458520 | 30458520 | PRJNA560029_S_NODE_17053_length_318_cov_1.885714_g16829_i0 | PRJNA560029 | 17053 | 318 | 1.885714 | 5.99657052 | Fragilaria crotonensis | 210448 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 3.06e-13 | NR | KAI2496705.1 | 210448 | g16829 | i0 | 54.4 | 0.641509433962264 | 68 | 29 | 64.2 | 1 | 4 | 207 | 1594 | 1659 | KAI2496705.1 DNA dependent RNA polymerase [Fragilaria crotonensis] | diamond | 204 | 75.5 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Fragilariales | Fragilariaceae | Fragilaria | Fragilaria crotonensis | ||
| 30914606 | 30914606 | PRJNA560029_S_NODE_18654_length_309_cov_4.368644_g18430_i0 | PRJNA560029 | 18654 | 309 | 4.368644 | 13.49910996 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.69e-15 | NR | OMJ77313.1 | 5963 | g18430 | i0 | 57.6 | 2.7378640776699 | 66 | 28 | 64.1 | 0 | 305 | 108 | 472 | 537 | OMJ77313.1 hypothetical protein SteCoe_23141 [Stentor coeruleus] | diamond | 846 | 82 | 0.995121951219512 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 30977785 | 30977785 | PRJNA560029_S_NODE_8294_length_384_cov_4.610932_g8070_i0 | PRJNA560029 | 8294 | 384 | 4.610932 | 17.70597888 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 3.41e-15 | NR | CEO95116.1 | 37360 | g8070 | i0 | 66.7 | 0.8984375 | 57 | 19 | 44.5 | 0 | 81 | 251 | 2362 | 2418 | CEO95116.1 hypothetical protein PBRA_003882 [Plasmodiophora brassicae] | diamond | 345 | 82 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32513758 | 32513758 | PRJNA560029_S_NODE_12639_length_346_cov_2.637363_g12415_i0 | PRJNA560029 | 12639 | 346 | 2.637363 | 9.12527598 | Blastocystis sp. subtype 4 | 944170 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 8.67e-7 | NR | XP_014527687.1 | 944170 | g12415 | i0 | 55.3 | 0.407514450867052 | 47 | 21 | 40.8 | 0 | 1 | 141 | 163 | 209 | XP_014527687.1 high mobility group b protein 6-like protein [Blastocystis sp. subtype 4] | diamond | 141 | 57.4 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. subtype 4 |
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);;