contig_metadata
23 rows where bioproject = "PRJEB30004" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48970 | 48970 | PRJEB30004_P_NODE_573341_length_172_cov_3.962406_g557714_i0 | PRJEB30004 | 573341 | 172 | 3.962406 | 6.81533832 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 6.25e-51 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g557714 | i0 | 89.474 | 35.703488372093 | 171 | 14 | 98 | 4 | 4 | 172 | 1665 | 1497 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 6141 | 213 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 1321104 | 1321104 | PRJEB30004_P_NODE_528562_length_183_cov_3.236111_g512935_i0 | PRJEB30004 | 528562 | 183 | 3.236111 | 5.92208313 | Sellaphora blackfordensis | 433383 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 8.8e-45 | NTclustered | gi|1829658070|gb|MN319622.1| | 433383 | g512935 | i0 | 89.865 | 67.0491803278689 | 148 | 15 | 81 | 0 | 1 | 148 | 285 | 432 | Sellaphora blackfordensis voucher (Bfp04)02 28S ribosomal RNA gene, partial sequence | blastn | 12270 | 193 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Sellaphoraceae | Sellaphora | Sellaphora blackfordensis | ||
| 2263999 | 2263999 | PRJEB30004_P_NODE_596262_length_167_cov_2.882812_g580635_i0 | PRJEB30004 | 596262 | 167 | 2.882812 | 4.81429604 | Thalassiosirales | 33847 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.5e-78 | NTclustered | gi|2739942923|dbj|LC814783.1| | 41457 | g580635 | i0 | 99.401 | 197.928143712575 | 167 | 1 | 100 | 0 | 1 | 167 | 4647 | 4481 | Skeletonema pseudocostatum NIES-2843 chloroplast DNA, complete genome | blastn | 33054 | 303 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Skeletonemataceae | Skeletonema | Skeletonema pseudocostatum | ||
| 2587915 | 2587915 | PRJEB30004_P_NODE_343623_length_255_cov_1.138889_g327996_i0 | PRJEB30004 | 343623 | 255 | 1.138889 | 2.90416695 | Chlorarachniophyceae sp. P329 | 467061 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.38e-4 | NTclustered | gi|220983374|dbj|AB453010.1| | 467061 | g327996 | i0 | 100 | 11.5294117647059 | 32 | 0 | 13 | 0 | 202 | 233 | 1624 | 1593 | Chlorarachniophyceae sp. P329 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 2940 | 60.2 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Chlorarachniophyceae sp. P329 | |||||
| 6409741 | 6409741 | PRJEB30004_P_NODE_206006_length_370_cov_3.157100_g190380_i0 | PRJEB30004 | 206006 | 370 | 3.1571 | 11.68127 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 647 | 0 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g190380 | i0 | 99.717 | 88.9378378378378 | 353 | 1 | 95 | 0 | 18 | 370 | 1839 | 1487 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 32907 | 647 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 8978014 | 8978014 | PRJEB30004_P_NODE_613608_length_164_cov_1.312000_g597981_i0 | PRJEB30004 | 613608 | 164 | 1.312 | 2.15168 | Schizostauron trachyderma | 2770866 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.18e-5 | NTclustered | gi|2125739626|gb|MZ520767.1| | 2770866 | g597981 | i0 | 97.143 | 1.32317073170732 | 35 | 1 | 21 | 0 | 103 | 137 | 16520 | 16486 | Schizostauron trachyderma strain SZCZE1420 mitochondrion, complete genome | blastn | 217 | 60.2 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Stauroneidaceae | Schizostauron | Schizostauron trachyderma | ||
| 9916708 | 9916708 | PRJEB30004_P_NODE_258228_length_314_cov_2.709091_g242601_i0 | PRJEB30004 | 258228 | 314 | 2.709091 | 8.50654574 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.72e-57 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g242601 | i0 | 97.794 | 2.15923566878981 | 136 | 3 | 43 | 0 | 179 | 314 | 3082 | 2947 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 678 | 235 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10255963 | 10255963 | PRJEB30004_P_NODE_661469_length_155_cov_1.387931_g645842_i0 | PRJEB30004 | 661469 | 155 | 1.387931 | 2.15129305 | Naviculales sp. | 2126271 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 1.53e-56 | NTclustered | gi|2785082235|gb|PQ157946.1| | 2126271 | g645842 | i0 | 93.59 | 102.948387096774 | 156 | 8 | 100 | 2 | 1 | 155 | 5668 | 5514 | Naviculales sp. strain SZCZO2114 mitochondrion, complete genome | blastn | 15957 | 231 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculales sp. | ||||
| 12467600 | 12467600 | PRJEB30004_P_NODE_219010_length_354_cov_8.155556_g203383_i0 | PRJEB30004 | 219010 | 354 | 8.155556 | 28.87066824 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g203383 | i0 | 99.718 | 99.861581920904 | 354 | 1 | 100 | 0 | 1 | 354 | 721 | 368 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 35351 | 654 | 0.992354740061162 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 12792562 | 12792562 | PRJEB30004_P_NODE_367071_length_242_cov_2.408867_g351444_i0 | PRJEB30004 | 367071 | 242 | 2.408867 | 5.82945814 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 8.869999999999999e-96 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g351444 | i0 | 93.776 | 17.004132231405 | 241 | 15 | 99 | 0 | 1 | 241 | 389 | 629 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4115 | 363 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 14080592 | 14080592 | PRJEB30004_P_NODE_642732_length_158_cov_1.915966_g627105_i0 | PRJEB30004 | 642732 | 158 | 1.915966 | 3.02722628 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 1.5399999999999998e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g627105 | i0 | 97.436 | 104.158227848101 | 156 | 3 | 98 | 1 | 4 | 158 | 3856 | 3701 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 16457 | 265 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 15016319 | 15016319 | PRJEB30004_P_NODE_141132_length_488_cov_4.035635_g125598_i0 | PRJEB30004 | 141132 | 488 | 4.035635 | 19.6938988 | Bacillariophyta | 2836 | SAR_Eukaryotes | SAR_Eukaryotes | 846 | 0 | NTclustered | gi|2194766164|gb|OK505009.1| | 2856 | g125598 | i0 | 97.951 | 199 | 488 | 10 | 100 | 0 | 1 | 488 | 19116 | 19603 | Cylindrotheca closterium chloroplast, complete genome | blastn | 97112 | 852 | 0.992957746478873 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 16608919 | 16608919 | PRJEB30004_P_NODE_219034_length_354_cov_5.444444_g203407_i0 | PRJEB30004 | 219034 | 354 | 5.444444 | 19.27333176 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 638 | 2.02e-178 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g203407 | i0 | 99.153 | 101.635593220339 | 354 | 3 | 100 | 0 | 1 | 354 | 2508 | 2155 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 35979 | 638 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 17566390 | 17566390 | PRJEB30004_P_NODE_289874_length_289_cov_1.600000_g274247_i0 | PRJEB30004 | 289874 | 289 | 1.6 | 4.624 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.01e-145 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g274247 | i0 | 99.654 | 92.6955017301038 | 289 | 1 | 100 | 0 | 1 | 289 | 1443 | 1731 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 26789 | 529 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 17889899 | 17889899 | PRJEB30004_P_NODE_351095_length_251_cov_1.037736_g335468_i0 | PRJEB30004 | 351095 | 251 | 1.037736 | 2.60471736 | Entomoneis sp. | 186043 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.23e-17 | NTclustered | gi|1372147530|gb|MF997419.1| | 186043 | g335468 | i0 | 75.304 | 0.98406374501992 | 247 | 44 | 96 | 16 | 1 | 240 | 21460 | 21224 | Entomoneis sp. mitochondrion, complete genome | blastn | 247 | 102 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Entomoneidaceae | Entomoneis | Entomoneis sp. | |||
| 18840345 | 18840345 | PRJEB30004_P_NODE_562275_length_175_cov_1.632353_g546648_i0 | PRJEB30004 | 562275 | 175 | 1.632353 | 2.85661775 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.13e-81 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g546648 | i0 | 98.857 | 14.1885714285714 | 175 | 2 | 100 | 0 | 1 | 175 | 1500 | 1674 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2483 | 313 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20450456 | 20450456 | PRJEB30004_P_NODE_588477_length_169_cov_1.776923_g572850_i0 | PRJEB30004 | 588477 | 169 | 1.776923 | 3.00299987 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.14e-70 | NTclustered | gi|90657152|gb|DQ442810.1| | 35100 | g572850 | i0 | 96.45 | 40.9230769230769 | 169 | 4 | 99 | 2 | 1 | 168 | 417 | 584 | Cyclidium glaucoma isolate ES34 28S ribosomal RNA gene, partial sequence | blastn | 6916 | 278 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Cyclidiidae | Cyclidium | Cyclidium glaucoma | ||
| 21390654 | 21390654 | PRJEB30004_P_NODE_244337_length_327_cov_2.479167_g228710_i0 | PRJEB30004 | 244337 | 327 | 2.479167 | 8.10687609 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 8.08e-43 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g228710 | i0 | 89.726 | 44.3547400611621 | 146 | 15 | 45 | 0 | 180 | 325 | 3464 | 3319 | P.megasperma gene for 28S ribosomal RNA | blastn | 14504 | 187 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 22994882 | 22994882 | PRJEB30004_P_NODE_448259_length_208_cov_1.633136_g432632_i0 | PRJEB30004 | 448259 | 208 | 1.633136 | 3.39692288 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 7.68e-71 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g432632 | i0 | 90.909 | 6.36538461538461 | 209 | 17 | 100 | 2 | 1 | 208 | 107 | 314 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1324 | 279 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22997789 | 22997789 | PRJEB30004_P_NODE_508019_length_189_cov_1.846667_g492392_i0 | PRJEB30004 | 508019 | 189 | 1.846667 | 3.49020063 | Aphanomyces brasiliensis | 2525538 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.11e-84 | NTclustered | gi|2098511708|gb|OK235679.1| | 2525538 | g492392 | i0 | 98.895 | 98.5132275132275 | 181 | 2 | 96 | 0 | 1 | 181 | 252 | 72 | Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence | blastn | 18619 | 324 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces brasiliensis | ||
| 24256208 | 24256208 | PRJEB30004_P_NODE_181420_length_406_cov_5.362398_g165811_i0 | PRJEB30004 | 181420 | 406 | 5.362398 | 21.77133588 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.45e-160 | NTclustered | gi|146762526|gb|EF553458.1| | 2850 | g165811 | i0 | 92.593 | 100.137931034483 | 405 | 27 | 99 | 3 | 2 | 405 | 4085 | 4487 | Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 40656 | 579 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 30001838 | 30001838 | PRJEB30004_P_NODE_234091_length_338_cov_1.635452_g218464_i0 | PRJEB30004 | 234091 | 338 | 1.635452 | 5.52782776 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 2.31e-19 | NR | GBG33034.1 | 2315210 | g218464 | i0 | 43.5 | 0.958579881656805 | 108 | 59 | 94.1 | 1 | 330 | 13 | 109 | 216 | GBG33034.1 Pentafunctional AROM polypeptide [Hondaea fermentalgiana] | diamond | 324 | 89.7 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 30475742 | 30475742 | PRJEB30004_P_NODE_656433_length_156_cov_1.051282_g640806_i0 | PRJEB30004 | 656433 | 156 | 1.051282 | 1.63999992 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 7.48e-5 | NR | KAF0724015.1 | 100861 | g640806 | i0 | 57.6 | 4.55769230769231 | 33 | 14 | 63.5 | 0 | 101 | 3 | 993 | 1025 | KAF0724015.1 hypothetical protein Ae201684_017215 [Aphanomyces euteiches] | diamond | 711 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;