contig_metadata
22 rows where bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2108611 | 2108611 | PRJNA846110_P_NODE_4122_length_511_cov_2.623288_g3878_i0 | PRJNA846110 | 4122 | 511 | 2.623288 | 13.40500168 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 944 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g3878 | i0 | 100 | 5.09393346379648 | 511 | 0 | 100 | 0 | 1 | 511 | 558 | 48 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 2603 | 944 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 3783221 | 3783221 | PRJNA846110_P_NODE_2983_length_603_cov_1.503774_g2746_i0 | PRJNA846110 | 2983 | 603 | 1.503774 | 9.06775722 | Verrucomonas | 2545269 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.5599999999999999e-47 | NTclustered | gi|290760488|gb|GQ144691.1| | 629763 | g2746 | i0 | 82.041 | 25.2437810945274 | 245 | 38 | 40 | 6 | 221 | 463 | 1487 | 1247 | Cercozoa sp. CC-2009e large subunit ribosomal RNA gene, partial sequence | blastn | 15222 | 204 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas bifida | |||
| 7211151 | 7211151 | PRJNA846110_P_NODE_21406_length_256_cov_1.415301_g21161_i0 | PRJNA846110 | 21406 | 256 | 1.415301 | 3.62317056 | Frontonia depressa | 3042678 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.69e-62 | NTclustered | gi|2496410947|gb|OQ869835.1| | 3042678 | g21161 | i0 | 85.141 | 90.9296875 | 249 | 31 | 96 | 4 | 1 | 246 | 1549 | 1794 | Frontonia depressa isolate S229 large subunit ribosomal RNA gene, partial sequence | blastn | 23278 | 250 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia depressa | ||
| 9760990 | 9760990 | PRJNA846110_P_NODE_12848_length_305_cov_2.086207_g12603_i0 | PRJNA846110 | 12848 | 305 | 2.086207 | 6.36293135 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.58e-54 | NTclustered | gi|1620114052|ref|XM_028670187.1| | 5849 | g12603 | i0 | 83.401 | 20.783606557377 | 247 | 38 | 81 | 3 | 27 | 272 | 704 | 460 | Plasmodium gallinaceum tubulin beta chain, putative (PGAL8A_00384800), partial mRNA | blastn | 6339 | 226 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 9761102 | 9761102 | PRJNA846110_P_NODE_2308_length_682_cov_2.003284_g2080_i0 | PRJNA846110 | 2308 | 682 | 2.003284 | 13.66239688 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 1146 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g2080 | i0 | 96.816 | 16.9780058651026 | 691 | 12 | 100 | 8 | 1 | 682 | 704 | 1393 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 11579 | 1146 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 23785471 | 23785471 | PRJNA846110_P_NODE_6099_length_423_cov_1.974286_g5855_i0 | PRJNA846110 | 6099 | 423 | 1.974286 | 8.35122978 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 782 | 0 | NTclustered | gi|1402550473|gb|MH488759.1| | 2231160 | g5855 | i0 | 100 | 48.5886524822695 | 423 | 0 | 100 | 0 | 1 | 423 | 2108 | 1686 | Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 20553 | 782 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 26841882 | 26841882 | PRJNA846110_P_NODE_28261_length_243_cov_1.664706_g28016_i0 | PRJNA846110 | 28261 | 243 | 1.664706 | 4.04523558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 2.66e-18 | NR | KAF4700468.1 | 32597 | g28016 | i0 | 58.4 | 19.962962962963 | 77 | 32 | 95.1 | 0 | 12 | 242 | 40 | 116 | KAF4700468.1 26S protease regulatory subunit 7, partial [Perkinsus olseni] | diamond | 4851 | 84.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27063147 | 27063147 | PRJNA846110_P_NODE_29362_length_242_cov_0.911243_g29117_i0 | PRJNA846110 | 29362 | 242 | 0.911243 | 2.20520806 | Symbiodinium | 2949 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00312 | NR | OLP81348.1 | 2951 | g29117 | i0 | 35.9 | 1.58677685950413 | 64 | 41 | 79.3 | 0 | 49 | 240 | 443 | 506 | OLP81348.1 Teneurin-3 [Symbiodinium microadriaticum] | diamond | 384 | 45.8 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 27086433 | 27086433 | PRJNA846110_P_NODE_27022_length_245_cov_0.895349_g26777_i0 | PRJNA846110 | 27022 | 245 | 0.895349 | 2.19360505 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 7.22e-11 | NR | GBG31315.1 | 2315210 | g26777 | i0 | 50 | 0.73469387755102 | 60 | 30 | 73.5 | 0 | 57 | 236 | 6 | 65 | GBG31315.1 NADH dehydrogenase ubiquinone 1 beta subcomplex subunit 10 [Hondaea fermentalgiana] | diamond | 180 | 63.5 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 27212609 | 27212609 | PRJNA846110_P_NODE_29942_length_241_cov_0.916667_g29697_i0 | PRJNA846110 | 29942 | 241 | 0.916667 | 2.20916747 | Discostella pseudostelligera | 259834 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 3.01e-10 | NR | KAL3759661.1 | 259834 | g29697 | i0 | 64.7 | 0.634854771784232 | 51 | 17 | 63.5 | 1 | 5 | 157 | 230 | 279 | KAL3759661.1 hypothetical protein ACHAWU_009808 [Discostella pseudostelligera] | diamond | 153 | 65.1 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Discostella | Discostella pseudostelligera | ||
| 27813116 | 27813116 | PRJNA846110_P_NODE_28204_length_243_cov_3.294118_g27959_i0 | PRJNA846110 | 28204 | 243 | 3.294118 | 8.00470674 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 5.700000000000001e-30 | NR | GBG31771.1 | 2315210 | g27959 | i0 | 78.8 | 0.987654320987654 | 80 | 17 | 98.8 | 0 | 4 | 243 | 50 | 129 | GBG31771.1 GDT1-like protein 3 [Hondaea fermentalgiana] | diamond | 240 | 116 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 28042361 | 28042361 | PRJNA846110_P_NODE_28305_length_243_cov_1.435294_g28060_i0 | PRJNA846110 | 28305 | 243 | 1.435294 | 3.48776442 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.74e-29 | NR | XP_004035755.1 | 5932 | g28060 | i0 | 69.6 | 4.90123456790123 | 79 | 24 | 97.5 | 0 | 239 | 3 | 110 | 188 | XP_004035755.1 hypothetical protein IMG5_090680 [Ichthyophthirius multifiliis] | diamond | 1191 | 119 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28570583 | 28570583 | PRJNA846110_P_NODE_29787_length_241_cov_1.428571_g29542_i0 | PRJNA846110 | 29787 | 241 | 1.428571 | 3.44285611 | Symbiodinium pilosum | 2952 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0498 | NR | CAE7230285.1 | 2952 | g29542 | i0 | 38.4 | 0.908713692946058 | 73 | 40 | 84.6 | 1 | 212 | 9 | 328 | 400 | CAE7230285.1 PHYB [Symbiodinium pilosum] | diamond | 219 | 42.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium pilosum | |||
| 29336880 | 29336880 | PRJNA846110_P_NODE_30329_length_241_cov_0.916667_g30084_i0 | PRJNA846110 | 30329 | 241 | 0.916667 | 2.20916747 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.71e-33 | NR | XP_001024675.2 | 312017 | g30084 | i0 | 78.2 | 1.94190871369295 | 78 | 17 | 97.1 | 0 | 5 | 238 | 473 | 550 | XP_001024675.2 aspartyl-tRNA synthetase protein [Tetrahymena thermophila SB210] | diamond | 468 | 130 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29360062 | 29360062 | PRJNA846110_P_NODE_19809_length_264_cov_1.350785_g19564_i0 | PRJNA846110 | 19809 | 264 | 1.350785 | 3.5660724 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 1.44e-18 | NR | CAK8994696.1 | 1381693 | g19564 | i0 | 58.7 | 1.57954545454545 | 75 | 28 | 81.8 | 1 | 5 | 220 | 1445 | 1519 | CAK8994696.1 Negative elongation factor B (NELF-B) (Cofactor of BRCA1) [Durusdinium trenchii] | diamond | 417 | 89.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 29494721 | 29494721 | PRJNA846110_P_NODE_26730_length_246_cov_0.884393_g26485_i0 | PRJNA846110 | 26730 | 246 | 0.884393 | 2.17560678 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00229 | NR | UKJ88767.2 | 68886 | g26485 | i0 | 43.3 | 1.47560975609756 | 60 | 23 | 73.2 | 2 | 66 | 245 | 397 | 445 | UKJ88767.2 hypothetical protein MACJ_002013 [Theileria orientalis] | diamond | 363 | 46.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 29517772 | 29517772 | PRJNA846110_P_NODE_15070_length_287_cov_1.299065_g14825_i0 | PRJNA846110 | 15070 | 287 | 1.299065 | 3.72831655 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 1.96e-35 | NR | CAK9068637.1 | 1381693 | g14825 | i0 | 73.2 | 1.8397212543554 | 82 | 21 | 85.7 | 1 | 41 | 286 | 95 | 175 | CAK9068637.1 Probable aspartoacylase [Durusdinium trenchii] | diamond | 528 | 133 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 29928548 | 29928548 | PRJNA846110_P_NODE_15231_length_286_cov_1.483568_g14986_i0 | PRJNA846110 | 15231 | 286 | 1.483568 | 4.24300448 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 8.91e-7 | NR | CAD8166097.1 | 43137 | g14986 | i0 | 36.3 | 2.21328671328671 | 102 | 53 | 96.5 | 4 | 278 | 3 | 11 | 110 | CAD8166097.1 unnamed protein product [Paramecium octaurelia] | diamond | 633 | 55.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 30654937 | 30654937 | PRJNA846110_P_NODE_25813_length_247_cov_0.885057_g25568_i0 | PRJNA846110 | 25813 | 247 | 0.885057 | 2.18609079 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.2499999999999996e-23 | NR | GBG31154.1 | 2315210 | g25568 | i0 | 65.9 | 0.995951417004049 | 82 | 28 | 99.6 | 0 | 246 | 1 | 175 | 256 | GBG31154.1 Sodium-dependent serotonin transporter [Hondaea fermentalgiana] | diamond | 246 | 102 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 31761487 | 31761487 | PRJNA846110_P_NODE_28257_length_243_cov_1.735294_g28012_i0 | PRJNA846110 | 28257 | 243 | 1.735294 | 4.21676442 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.43e-30 | NR | GBG24075.1 | 2315210 | g28012 | i0 | 76.9 | 0.962962962962963 | 78 | 18 | 96.3 | 0 | 241 | 8 | 519 | 596 | GBG24075.1 Phosphoglycerate mutase 1 [Hondaea fermentalgiana] | diamond | 234 | 122 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana | |||
| 31919704 | 31919704 | PRJNA846110_P_NODE_6177_length_420_cov_2.193084_g5933_i0 | PRJNA846110 | 6177 | 420 | 2.193084 | 9.2109528 | Phaeodactylum tricornutum CCAP 1 | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 6.23e-4 | NR | XP_002185646.1 | 556484 | g5933 | i0 | 43.1 | 0.414285714285714 | 58 | 31 | 40 | 1 | 142 | 309 | 275 | 332 | XP_002185646.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] | diamond | 174 | 50.1 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 32141230 | 32141230 | PRJNA846110_P_NODE_19198_length_267_cov_1.458763_g18953_i0 | PRJNA846110 | 19198 | 267 | 1.458763 | 3.89489721 | Hondaea fermentalgiana | 2315210 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.15e-26 | NR | GBG34482.1 | 2315210 | g18953 | i0 | 60.7 | 1 | 89 | 34 | 100 | 1 | 267 | 1 | 72 | 159 | GBG34482.1 Asparagine synthetase glutamine-hydrolyzing [Hondaea fermentalgiana] | diamond | 267 | 108 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Hondaea | Hondaea fermentalgiana |
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);;