contig_metadata
21 rows where bioproject = "PRJEB2333" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7363876 | 7363876 | PRJEB2333_P_NODE_3846_length_199_cov_3.709877_g3069_i0 | PRJEB2333 | 3846 | 199 | 3.709877 | 7.38265523 | Leptopharynx | 502089 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.019999999999998e-96 | NTclustered | gi|2125425273|gb|OK663150.1| | 187299 | g3069 | i0 | 99.497 | 96.2763819095477 | 199 | 1 | 100 | 0 | 1 | 199 | 575 | 377 | Uncultured ciliate isolate DGGE gel band clone C81 small subunit ribosomal RNA gene, partial sequence | blastn | 19159 | 363 | 1 | Eukaryota | Sar | Ciliophora | uncultured ciliate | ||||||
| 8949880 | 8949880 | PRJEB2333_P_NODE_2908_length_460_cov_1.997636_g2136_i0 | PRJEB2333 | 2908 | 460 | 1.997636 | 9.1891256 | Nannochloropsis salina CCMP1776 | 1027361 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 6.22e-47 | NR | TFJ85726.1 | 1027361 | g2136 | i0 | 55.2 | 1.92391304347826 | 145 | 60 | 91.3 | 1 | 436 | 17 | 7 | 151 | TFJ85726.1 hypothetical protein NSK_003230 [Nannochloropsis salina CCMP1776] | diamond | 885 | 160 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Microchloropsis | Microchloropsis salina | |||
| 9914316 | 9914316 | PRJEB2333_P_NODE_3648_length_226_cov_3.365079_g2871_i0 | PRJEB2333 | 3648 | 226 | 3.365079 | 7.60507854 | root | 1 | Root_unresolved | Root_unresolved | 102 | 1.97e-17 | NTclustered | gi|219903754|emb|FM955257.1| | 2996 | g2871 | i0 | 90.909 | 34.216814159292 | 77 | 6 | 34 | 1 | 55 | 130 | 1774 | 1850 | Hydrurus foetidus partial 28S rRNA gene | blastn | 7733 | 102 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus | |||
| 10225637 | 10225637 | PRJEB2333_P_NODE_3149_length_424_cov_1.873385_g2374_i0 | PRJEB2333 | 3149 | 424 | 1.873385 | 7.9431524 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 5.38e-62 | NR | XP_026191109.1 | 88456 | g2374 | i0 | 74.4 | 59.2712264150943 | 133 | 34 | 94.1 | 0 | 3 | 401 | 61 | 193 | XP_026191109.1 40S ribosomal protein S5 [Cyclospora cayetanensis] | diamond | 25131 | 198 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 10225638 | 10225638 | PRJEB2333_P_NODE_3469_length_313_cov_2.119565_g2692_i0 | PRJEB2333 | 3469 | 313 | 2.119565 | 6.63423845 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 2.42e-38 | NR | CEO98457.1 | 37360 | g2692 | i0 | 64.4 | 0.996805111821086 | 104 | 37 | 99.7 | 0 | 313 | 2 | 43 | 146 | CEO98457.1 hypothetical protein PBRA_006571 [Plasmodiophora brassicae] | diamond | 312 | 137 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 15014037 | 15014037 | PRJEB2333_P_NODE_4132_length_178_cov_1.503546_g3355_i0 | PRJEB2333 | 4132 | 178 | 1.503546 | 2.67631188 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 5.26e-22 | NTclustered | gi|166042668|emb|CU350907.1| | 100861 | g3355 | i0 | 78.977 | 97.1685393258427 | 176 | 33 | 98 | 3 | 5 | 178 | 621 | 794 | Aphanomyces euteiches cDNA | blastn | 17296 | 117 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 15325037 | 15325037 | PRJEB2333_P_NODE_3893_length_195_cov_2.626582_g3116_i0 | PRJEB2333 | 3893 | 195 | 2.626582 | 5.1218349 | Schizochytrium aggregatum | 4773 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 4.49e-33 | NTclustered | gi|85822990|gb|DQ356661.1| | 4773 | g3116 | i0 | 81.25 | 87.3384615384615 | 192 | 34 | 98 | 2 | 5 | 195 | 632 | 822 | Schizochytrium aggregatum actin gene, partial cds | blastn | 17031 | 154 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Schizochytrium | Schizochytrium aggregatum | |||
| 17564021 | 17564021 | PRJEB2333_P_NODE_3314_length_403_cov_0.825137_g2538_i0 | PRJEB2333 | 3314 | 403 | 0.825137 | 3.32530211 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.72e-30 | NTclustered | gi|16326556|gb|AF409124.1| | 2829 | g2538 | i0 | 96.591 | 38.0967741935484 | 88 | 3 | 39 | 0 | 316 | 403 | 3431 | 3518 | Heterosigma akashiwo internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 15353 | 147 | 1 | Eukaryota | Sar | Raphidophyceae | Chattonellales | Chattonellaceae | Heterosigma | Heterosigma akashiwo | |||
| 20112712 | 20112712 | PRJEB2333_P_NODE_4436_length_164_cov_1.724409_g3659_i0 | PRJEB2333 | 4436 | 164 | 1.724409 | 2.82803076 | Leptopharynx | 502089 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.59e-76 | NTclustered | gi|318083432|gb|HQ668467.1| | 502090 | g3659 | i0 | 99.39 | 93.140243902439 | 164 | 1 | 100 | 0 | 1 | 164 | 1614 | 1451 | Leptopharynx costatus 18S ribosomal RNA gene, partial sequence; macronuclear | blastn | 15275 | 298 | 1 | Eukaryota | Sar | Ciliophora | Nassophorea | Microthoracida | Microthoracidae | Leptopharynx | Leptopharynx costatus | ||
| 24248690 | 24248690 | PRJEB2333_P_NODE_1340_length_1769_cov_2.827945_g801_i0 | PRJEB2333 | 1340 | 1769 | 2.827945 | 50.02634705 | Pygsuia | 1401266 | SAR_Eukaryotes | SAR_Eukaryotes | 430 | 1.6e-142 | NR | MES1909605.1 | 1215613 | g801 | i0 | 47.4 | 26.7693612210288 | 506 | 139 | 85 | 6 | 2 | 1504 | 54 | 437 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 47355 | 430 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 25212282 | 25212282 | PRJEB2333_P_NODE_4860_length_151_cov_1.578947_g4083_i0 | PRJEB2333 | 4860 | 151 | 1.578947 | 2.38420997 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 5.19e-71 | NTclustered | gi|111035921|emb|AJ781306.1| | 5908 | g4083 | i0 | 100 | 84.9470198675497 | 151 | 0 | 100 | 0 | 1 | 151 | 465 | 315 | Tetrahymena pyriformis partial 23S rRNA gene, strain CCAP 1630/1W | blastn | 12827 | 279 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 27121232 | 27121232 | PRJEB2333_P_NODE_2502_length_589_cov_1.336957_g1735_i0 | PRJEB2333 | 2502 | 589 | 1.336957 | 7.87467673 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.62e-19 | NR | KAJ8578052.1 | 4785 | g1735 | i0 | 42.2 | 5.25127334465195 | 116 | 64 | 59.1 | 2 | 588 | 241 | 133 | 245 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 3093 | 94.7 | 0.992608236536431 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 27633569 | 27633569 | PRJEB2333_P_NODE_4724_length_155_cov_0.991525_g3947_i0 | PRJEB2333 | 4724 | 155 | 0.991525 | 1.53686375 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 40.8 | 0.0316 | NR | CEO99081.1 | 37360 | g3947 | i0 | 60.6 | 0.638709677419355 | 33 | 13 | 63.9 | 0 | 15 | 113 | 109 | 141 | CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] | diamond | 99 | 40.8 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 28454577 | 28454577 | PRJEB2333_P_NODE_3906_length_194_cov_1.719745_g3129_i0 | PRJEB2333 | 3906 | 194 | 1.719745 | 3.3363053 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 2.38e-12 | NR | DAZ96502.1 | 4803 | g3129 | i0 | 54 | 2.92268041237113 | 63 | 29 | 97.4 | 0 | 192 | 4 | 2045 | 2107 | DAZ96502.1 TPA: hypothetical protein N0F65_008053 [Lagenidium giganteum] | diamond | 567 | 70.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28984985 | 28984985 | PRJEB2333_P_NODE_2428_length_629_cov_1.658784_g1666_i0 | PRJEB2333 | 2428 | 629 | 1.658784 | 10.43375136 | Blastocystis | 12967 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 6.18e-12 | NR | KAK8817403.1 | 478820 | g1666 | i0 | 59 | 1.75039745627981 | 61 | 25 | 29.1 | 0 | 6 | 188 | 84 | 144 | KAK8817403.1 hypothetical protein WA556_003296 [Blastocystis sp. ATCC 50177/Nand II] | diamond | 1101 | 73.6 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 29653810 | 29653810 | PRJEB2333_P_NODE_4590_length_159_cov_0.959016_g3813_i0 | PRJEB2333 | 4590 | 159 | 0.959016 | 1.52483544 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 5.32e-13 | NR | XP_067069864.1 | 117008 | g3813 | i0 | 64.2 | 2 | 53 | 19 | 100 | 0 | 159 | 1 | 19 | 71 | XP_067069864.1 60s ribosomal protein L13A [Cryptosporidium andersoni] | diamond | 318 | 70.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 30349686 | 30349686 | PRJEB2333_P_NODE_2572_length_556_cov_2.377649_g1803_i0 | PRJEB2333 | 2572 | 556 | 2.377649 | 13.21972844 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 4.88e-71 | NR | ADK26624.1 | 323453 | g1803 | i0 | 60.9 | 0.992805755395683 | 184 | 72 | 99.3 | 0 | 554 | 3 | 89 | 272 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 552 | 226 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 30437754 | 30437754 | PRJEB2333_P_NODE_2513_length_583_cov_1.879121_g1746_i0 | PRJEB2333 | 2513 | 583 | 1.879121 | 10.95527543 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.15e-62 | NR | KAG1694345.1 | 4784 | g1746 | i0 | 53.6 | 3.99313893653516 | 194 | 64 | 99.8 | 1 | 583 | 2 | 28 | 195 | KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici] | diamond | 2328 | 203 | 0.995073891625616 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30759939 | 30759939 | PRJEB2333_P_NODE_2514_length_583_cov_1.600733_g1747_i0 | PRJEB2333 | 2514 | 583 | 1.600733 | 9.33227339 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 5.58e-30 | NR | XP_021338074.1 | 1133968 | g1747 | i0 | 59.1 | 4.77530017152659 | 93 | 38 | 47.9 | 0 | 379 | 101 | 52 | 144 | XP_021338074.1 small subunit ribosomal protein S18e [Babesia microti strain RI] | diamond | 2784 | 118 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 31480746 | 31480746 | PRJEB2333_P_NODE_2396_length_650_cov_1.499184_g1636_i0 | PRJEB2333 | 2396 | 650 | 1.499184 | 9.744696 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 179 | 2.69e-52 | NR | GLD96418.1 | 114742 | g1636 | i0 | 59.1 | 3.32307692307692 | 149 | 60 | 68.8 | 1 | 2 | 448 | 45 | 192 | GLD96418.1 hypothetical protein PINS_up005101 [Pythium insidiosum] | diamond | 2160 | 179 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31676530 | 31676530 | PRJEB2333_P_NODE_3137_length_427_cov_0.789744_g2362_i0 | PRJEB2333 | 3137 | 427 | 0.789744 | 3.37220688 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 8.82e-9 | NR | CEO95161.1 | 37360 | g2362 | i0 | 78.8 | 0.231850117096019 | 33 | 7 | 23.2 | 0 | 398 | 300 | 1 | 33 | CEO95161.1 hypothetical protein PBRA_003927 [Plasmodiophora brassicae] | diamond | 99 | 61.2 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae |
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);;