contig_metadata
22 rows where bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96341 | 96341 | PRJEB49404_P_NODE_198061_length_354_cov_5.184127_g184262_i0 | PRJEB49404 | 198061 | 354 | 5.184127 | 18.35180958 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 638 | 2.02e-178 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g184262 | 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 | ||
| 99984 | 99984 | PRJEB49404_P_NODE_277081_length_279_cov_2.150000_g263280_i0 | PRJEB49404 | 277081 | 279 | 2.15 | 5.9985 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 6.11e-113 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g263280 | i0 | 93.885 | 28.0143369175627 | 278 | 17 | 99 | 0 | 1 | 278 | 352 | 629 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 7816 | 420 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 115680 | 115680 | PRJEB49404_P_NODE_604281_length_158_cov_2.537815_g590480_i0 | PRJEB49404 | 604281 | 158 | 2.537815 | 4.0097477 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 1.5399999999999998e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g590480 | 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 | |||
| 990916 | 990916 | PRJEB49404_P_NODE_221621_length_327_cov_2.479167_g207822_i0 | PRJEB49404 | 221621 | 327 | 2.479167 | 8.10687609 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 8.08e-43 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g207822 | 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 | ||
| 3940485 | 3940485 | PRJEB49404_P_NODE_576484_length_164_cov_1.312000_g562683_i0 | PRJEB49404 | 576484 | 164 | 1.312 | 2.15168 | Schizostauron trachyderma | 2770866 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.18e-5 | NTclustered | gi|2125739626|gb|MZ520767.1| | 2770866 | g562683 | 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 | ||
| 4819025 | 4819025 | PRJEB49404_P_NODE_526324_length_175_cov_1.632353_g512523_i0 | PRJEB49404 | 526324 | 175 | 1.632353 | 2.85661775 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.13e-81 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g512523 | 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 | ||
| 5204166 | 5204166 | PRJEB49404_P_NODE_314945_length_255_cov_1.138889_g301144_i0 | PRJEB49404 | 314945 | 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 | g301144 | 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 | |||||
| 5214898 | 5214898 | PRJEB49404_P_NODE_537145_length_172_cov_4.007519_g523344_i0 | PRJEB49404 | 537145 | 172 | 4.007519 | 6.89293268 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 6.25e-51 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g523344 | 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 | ||
| 6477323 | 6477323 | PRJEB49404_P_NODE_258926_length_293_cov_1.885827_g245125_i0 | PRJEB49404 | 258926 | 293 | 1.885827 | 5.52547311 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 2.92e-131 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g245125 | i0 | 96.259 | 92.4505119453925 | 294 | 10 | 100 | 1 | 1 | 293 | 1805 | 1512 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 27088 | 481 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 10297746 | 10297746 | PRJEB49404_P_NODE_163209_length_406_cov_5.362398_g149423_i0 | PRJEB49404 | 163209 | 406 | 5.362398 | 21.77133588 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.45e-160 | NTclustered | gi|146762526|gb|EF553458.1| | 2850 | g149423 | 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 | ||
| 11584858 | 11584858 | PRJEB49404_P_NODE_415330_length_208_cov_1.633136_g401529_i0 | PRJEB49404 | 415330 | 208 | 1.633136 | 3.39692288 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 7.68e-71 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g401529 | 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 | ||
| 12469938 | 12469938 | PRJEB49404_P_NODE_207830_length_342_cov_7.396040_g194031_i0 | PRJEB49404 | 207830 | 342 | 7.39604 | 25.2944568 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 627 | 4.22e-175 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g194031 | i0 | 99.708 | 99.8771929824561 | 342 | 1 | 100 | 0 | 1 | 342 | 720 | 379 | 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 | 34158 | 632 | 0.992088607594937 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 14144987 | 14144987 | PRJEB49404_P_NODE_623752_length_155_cov_1.387931_g609951_i0 | PRJEB49404 | 623752 | 155 | 1.387931 | 2.15129305 | Naviculales sp. | 2126271 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 1.53e-56 | NTclustered | gi|2785082235|gb|PQ157946.1| | 2126271 | g609951 | 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. | ||||
| 15409222 | 15409222 | PRJEB49404_P_NODE_421453_length_206_cov_1.413174_g407652_i0 | PRJEB49404 | 421453 | 206 | 1.413174 | 2.91113844 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.6700000000000003e-85 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g407652 | i0 | 95.588 | 85.5922330097087 | 204 | 9 | 99 | 0 | 3 | 206 | 1307 | 1510 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 17632 | 327 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 16293612 | 16293612 | PRJEB49404_P_NODE_234533_length_314_cov_2.709091_g220732_i0 | PRJEB49404 | 234533 | 314 | 2.709091 | 8.50654574 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.72e-57 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g220732 | 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 | ||
| 16678820 | 16678820 | PRJEB49404_P_NODE_322094_length_251_cov_1.037736_g308293_i0 | PRJEB49404 | 322094 | 251 | 1.037736 | 2.60471736 | Entomoneis sp. | 186043 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.23e-17 | NTclustered | gi|1372147530|gb|MF997419.1| | 186043 | g308293 | 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. | |||
| 17568944 | 17568944 | PRJEB49404_P_NODE_559874_length_167_cov_2.398438_g546073_i0 | PRJEB49404 | 559874 | 167 | 2.398438 | 4.00539146 | Thalassiosirales | 33847 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.5e-78 | NTclustered | gi|2739942923|dbj|LC814783.1| | 41457 | g546073 | 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 | ||
| 21787081 | 21787081 | PRJEB49404_P_NODE_493418_length_183_cov_3.236111_g479617_i0 | PRJEB49404 | 493418 | 183 | 3.236111 | 5.92208313 | Sellaphora blackfordensis | 433383 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 8.8e-45 | NTclustered | gi|1829658070|gb|MN319622.1| | 433383 | g479617 | 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 | ||
| 21789898 | 21789898 | PRJEB49404_P_NODE_551878_length_169_cov_1.776923_g538077_i0 | PRJEB49404 | 551878 | 169 | 1.776923 | 3.00299987 | Cyclidium glaucoma | 35100 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.14e-70 | NTclustered | gi|90657152|gb|DQ442810.1| | 35100 | g538077 | 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 | ||
| 23943220 | 23943220 | PRJEB49404_P_NODE_264179_length_289_cov_1.600000_g250378_i0 | PRJEB49404 | 264179 | 289 | 1.6 | 4.624 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.01e-145 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g250378 | 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 | |||
| 27159668 | 27159668 | PRJEB49404_P_NODE_594202_length_160_cov_2.363636_g580401_i0 | PRJEB49404 | 594202 | 160 | 2.363636 | 3.7818176 | Seminavis robusta | 568900 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0321 | NR | CAB9497903.1 | 568900 | g580401 | i0 | 43.9 | 0.76875 | 41 | 23 | 76.9 | 0 | 37 | 159 | 1770 | 1810 | CAB9497903.1 expressed unknown protein [Seminavis robusta] | diamond | 123 | 41.6 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta | ||
| 28012887 | 28012887 | PRJEB49404_P_NODE_619085_length_156_cov_1.051282_g605284_i0 | PRJEB49404 | 619085 | 156 | 1.051282 | 1.63999992 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 7.48e-5 | NR | KAF0724015.1 | 100861 | g605284 | 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);;