contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA849646" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 838041 | 838041 | PRJNA849646_P_NODE_13821_length_280_cov_1.913043_g13703_i0 | PRJNA849646 | 13821 | 280 | 1.913043 | 5.3565204 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 4.32e-41 | NR | OQR97335.1 | 1202772 | g13703 | i0 | 75 | 6.83571428571429 | 92 | 23 | 98.6 | 0 | 3 | 278 | 128 | 219 | OQR97335.1 60S ribosomal protein L5 [Achlya hypogyna] | diamond | 1914 | 146 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 4666530 | 4666530 | PRJNA849646_P_NODE_15564_length_277_cov_1.323529_g15446_i0 | PRJNA849646 | 15564 | 277 | 1.323529 | 3.66617533 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 2.53e-51 | NR | XP_067817684.1 | 4779 | g15446 | i0 | 85.9 | 7.97111913357401 | 92 | 13 | 99.6 | 0 | 276 | 1 | 147 | 238 | XP_067817684.1 hypothetical protein CCR75_004102 [Bremia lactucae] | diamond | 2208 | 172 | 0.994186046511628 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 14866076 | 14866076 | PRJNA849646_P_NODE_17552_length_273_cov_1.540000_g17434_i0 | PRJNA849646 | 17552 | 273 | 1.54 | 4.2042 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 2.6799999999999996e-31 | NR | XP_024586207.1 | 4781 | g17434 | i0 | 85.5 | 9.32967032967033 | 69 | 10 | 75.8 | 0 | 208 | 2 | 4 | 72 | XP_024586207.1 40s ribosomal protein s16 [Plasmopara halstedii] | diamond | 2547 | 122 | 0.991803278688525 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 14866287 | 14866287 | PRJNA849646_P_NODE_33772_length_246_cov_1.780347_g33654_i0 | PRJNA849646 | 33772 | 246 | 1.780347 | 4.37965362 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 2.470000000000001e-44 | NR | XP_024577919.1 | 4781 | g33654 | i0 | 84.1 | 10 | 82 | 13 | 100 | 0 | 246 | 1 | 138 | 219 | XP_024577919.1 proteasome subunit alpha type [Plasmopara halstedii] | diamond | 2460 | 153 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 14866460 | 14866460 | PRJNA849646_P_NODE_7972_length_293_cov_1.400000_g7854_i0 | PRJNA849646 | 7972 | 293 | 1.4 | 4.102 | Blastocystis hominis | 12968 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 6.0699999999999986e-24 | NR | XP_012896670.1 | 12968 | g7854 | i0 | 55.1 | 5.01706484641638 | 98 | 43 | 99.3 | 1 | 2 | 292 | 648 | 745 | XP_012896670.1 uncharacterized protein [Blastocystis hominis] | diamond | 1470 | 105 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 16535980 | 16535980 | PRJNA849646_P_NODE_35113_length_245_cov_0.895349_g34995_i0 | PRJNA849646 | 35113 | 245 | 0.895349 | 2.19360505 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.4e-37 | NR | XP_024578065.1 | 4781 | g34995 | i0 | 88.9 | 22.8122448979592 | 81 | 9 | 99.2 | 0 | 1 | 243 | 440 | 520 | XP_024578065.1 heat shock protein 90 [Plasmopara halstedii] | diamond | 5589 | 143 | 0.993006993006993 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 18689393 | 18689393 | PRJNA849646_P_NODE_16595_length_275_cov_1.524752_g16477_i0 | PRJNA849646 | 16595 | 275 | 1.524752 | 4.193068 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.29e-36 | NR | ETM46751.1 | 4792 | g16477 | i0 | 84 | 4.90909090909091 | 75 | 12 | 81.8 | 0 | 273 | 49 | 10 | 84 | ETM46751.1 elongation factor 1-alpha, partial [Phytophthora nicotianae] | diamond | 1350 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 22515055 | 22515055 | PRJNA849646_P_NODE_32818_length_247_cov_1.770115_g32700_i0 | PRJNA849646 | 32818 | 247 | 1.770115 | 4.37218405 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 2.46e-35 | NR | KAK1942099.1 | 4793 | g32700 | i0 | 80 | 6.75303643724696 | 80 | 15 | 97.2 | 1 | 8 | 247 | 48 | 126 | KAK1942099.1 40S ribosomal protein S5-2 [Phytophthora citrophthora] | diamond | 1668 | 129 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 22910855 | 22910855 | PRJNA849646_P_NODE_20138_length_268_cov_1.579487_g20020_i0 | PRJNA849646 | 20138 | 268 | 1.579487 | 4.23302516 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 2.51e-33 | NR | KAG5179870.1 | 303371 | g20020 | i0 | 73 | 9.94029850746269 | 89 | 24 | 99.6 | 0 | 268 | 2 | 489 | 577 | KAG5179870.1 succinate dehydrogenase flavoprotein subunit [Tribonema minus] | diamond | 2664 | 132 | 0.992424242424242 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 26737935 | 26737935 | PRJNA849646_P_NODE_19541_length_269_cov_2.163265_g19423_i0 | PRJNA849646 | 19541 | 269 | 2.163265 | 5.81918285 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 4.74e-4 | NR | XP_011129914.1 | 110365 | g19423 | i0 | 39 | 0.91449814126394 | 82 | 45 | 91.4 | 2 | 248 | 3 | 390 | 466 | XP_011129914.1 putative pentatricopeptide repeat protein [Gregarina niphandrodes] | diamond | 246 | 48.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 26865331 | 26865331 | PRJNA849646_P_NODE_18221_length_272_cov_1.381910_g18103_i0 | PRJNA849646 | 18221 | 272 | 1.38191 | 3.7587952 | Peronospora effusa | 542832 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.05e-35 | NR | RQM08885.1 | 542832 | g18103 | i0 | 92.9 | 2.30514705882353 | 70 | 5 | 77.2 | 0 | 254 | 45 | 16 | 85 | RQM08885.1 hypothetical protein DD237_000613 [Peronospora effusa] | diamond | 627 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora effusa | ||
| 27276247 | 27276247 | PRJNA849646_P_NODE_15463_length_277_cov_1.509804_g15345_i0 | PRJNA849646 | 15463 | 277 | 1.509804 | 4.18215708 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.39e-22 | NR | XP_011132332.1 | 110365 | g15345 | i0 | 80.6 | 0.671480144404332 | 62 | 12 | 67.1 | 0 | 190 | 5 | 482 | 543 | XP_011132332.1 major facilitator superfamily transporter [Gregarina niphandrodes] | diamond | 186 | 101 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 27781561 | 27781561 | PRJNA849646_P_NODE_42124_length_226_cov_2.732026_g42006_i0 | PRJNA849646 | 42124 | 226 | 2.732026 | 6.17437876 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 1.95e-36 | NR | ETL93890.1 | 4792 | g42006 | i0 | 82.7 | 5.97345132743363 | 75 | 13 | 99.6 | 0 | 226 | 2 | 440 | 514 | ETL93890.1 6-phosphogluconate dehydrogenase (decarboxylating), partial [Phytophthora nicotianae] | diamond | 1350 | 138 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28002652 | 28002652 | PRJNA849646_P_NODE_25445_length_258_cov_1.664865_g25327_i0 | PRJNA849646 | 25445 | 258 | 1.664865 | 4.2953517 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 3.67e-11 | NR | TMW63146.1 | 41045 | g25327 | i0 | 38 | 0.918604651162791 | 79 | 48 | 90.7 | 1 | 22 | 255 | 386 | 464 | TMW63146.1 hypothetical protein Poli38472_002087 [Pythium oligandrum] | diamond | 237 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28191652 | 28191652 | PRJNA849646_P_NODE_27326_length_254_cov_2.425414_g27208_i0 | PRJNA849646 | 27326 | 254 | 2.425414 | 6.16055156 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.59e-37 | NR | KAJ1439145.1 | 483371 | g27208 | i0 | 83.3 | 0.992125984251969 | 84 | 14 | 99.2 | 0 | 2 | 253 | 634 | 717 | KAJ1439145.1 dynein heavy chain and region D6 of dynein motor-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 252 | 143 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28728703 | 28728703 | PRJNA849646_P_NODE_5327_length_310_cov_3.021097_g5209_i0 | PRJNA849646 | 5327 | 310 | 3.021097 | 9.3654007 | Nitzschia inconspicua | 303405 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.81e-25 | NR | KAG7373470.1 | 303405 | g5209 | i0 | 92.2 | 0.619354838709677 | 64 | 5 | 61.9 | 0 | 308 | 117 | 897 | 960 | KAG7373470.1 mechanosensitive ion channel [Nitzschia inconspicua] | diamond | 192 | 110 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia inconspicua | ||
| 30402904 | 30402904 | PRJNA849646_P_NODE_33593_length_246_cov_2.352601_g33475_i0 | PRJNA849646 | 33593 | 246 | 2.352601 | 5.78739846 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 9.84e-10 | NR | XP_011130027.1 | 110365 | g33475 | i0 | 73.8 | 0.51219512195122 | 42 | 11 | 51.2 | 0 | 245 | 120 | 2877 | 2918 | XP_011130027.1 hypothetical protein GNI_063170 [Gregarina niphandrodes] | diamond | 126 | 64.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30600198 | 30600198 | PRJNA849646_P_NODE_22733_length_263_cov_1.621053_g22615_i0 | PRJNA849646 | 22733 | 263 | 1.621053 | 4.26336939 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 8.500000000000001e-30 | NR | CAJ1941453.1 | 2856 | g22615 | i0 | 71.3 | 15.8783269961977 | 87 | 25 | 99.2 | 0 | 263 | 3 | 256 | 342 | CAJ1941453.1 unnamed protein product [Cylindrotheca closterium] | diamond | 4176 | 122 | 0.991803278688525 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 31350572 | 31350572 | PRJNA849646_P_NODE_18576_length_271_cov_1.555556_g18458_i0 | PRJNA849646 | 18576 | 271 | 1.555556 | 4.21555676 | Nannochloropsis gaditana | 72520 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 2.7e-10 | NR | EWM25424.1 | 72520 | g18458 | i0 | 40 | 1.61623616236162 | 90 | 41 | 85.2 | 2 | 270 | 40 | 332 | 421 | EWM25424.1 ring zinc finger-containing protein [Nannochloropsis gaditana] | diamond | 438 | 66.2 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis gaditana | |||
| 31793046 | 31793046 | PRJNA849646_P_NODE_38137_length_241_cov_1.833333_g38019_i0 | PRJNA849646 | 38137 | 241 | 1.833333 | 4.41833253 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.29e-7 | NR | KAJ1438177.1 | 483371 | g38019 | i0 | 86.7 | 0.809128630705394 | 30 | 4 | 37.3 | 0 | 150 | 239 | 458 | 487 | KAJ1438177.1 Tub family-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 195 | 58.2 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31864631 | 31864631 | PRJNA849646_P_NODE_29977_length_250_cov_1.740113_g29859_i0 | PRJNA849646 | 29977 | 250 | 1.740113 | 4.3502825 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.44e-11 | NR | SPQ94571.1 | 37360 | g29859 | i0 | 50.7 | 1.68 | 69 | 34 | 82.8 | 0 | 43 | 249 | 180 | 248 | SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 420 | 68.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32363044 | 32363044 | PRJNA849646_P_NODE_35459_length_244_cov_1.801170_g35341_i0 | PRJNA849646 | 35459 | 244 | 1.80117 | 4.3948548 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 5.88e-4 | NR | TYZ66219.1 | 1485010 | g35341 | i0 | 47.8 | 0.565573770491803 | 46 | 22 | 54.1 | 1 | 134 | 3 | 254 | 299 | TYZ66219.1 hypothetical protein PybrP1_005628 [[Pythium] brassicae (nom. inval.)] | diamond | 138 | 47.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) |
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);;