contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA484127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1723028 | 1723028 | PRJNA484127_P_NODE_13642_length_340_cov_1.164794_g13493_i0 | PRJNA484127 | 13642 | 340 | 1.164794 | 3.9602996 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.71e-25 | NR | CDW80281.1 | 5949 | g13493 | i0 | 48.1 | 7.47352941176471 | 106 | 54 | 93.5 | 1 | 3 | 320 | 226 | 330 | CDW80281.1 UNKNOWN [Stylonychia lemnae] | diamond | 2541 | 109 | 0.990825688073395 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 17025988 | 17025988 | PRJNA484127_P_NODE_38314_length_242_cov_2.579882_g38165_i0 | PRJNA484127 | 38314 | 242 | 2.579882 | 6.24331444 | root | 1 | Root_unresolved | Root_unresolved | 122 | 1.93e-30 | NR | XP_067925722.1 | 483139 | g38165 | i0 | 77.5 | 10.6487603305785 | 71 | 16 | 88 | 0 | 215 | 3 | 102 | 172 | XP_067925722.1 isocitrate dehydrogenase [Cystoisospora suis] | diamond | 2577 | 123 | 0.991869918699187 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 26839476 | 26839476 | PRJNA484127_P_NODE_11741_length_360_cov_1.358885_g11592_i0 | PRJNA484127 | 11741 | 360 | 1.358885 | 4.891986 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 2.76e-10 | NR | KAJ8578052.1 | 4785 | g11592 | i0 | 53.3 | 1.325 | 60 | 28 | 50 | 0 | 3 | 182 | 177 | 236 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 477 | 66.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 27455693 | 27455693 | PRJNA484127_P_NODE_18183_length_305_cov_2.379310_g18034_i0 | PRJNA484127 | 18183 | 305 | 2.37931 | 7.2568955 | Blastocystis sp. subtype 4 | 944170 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 1.75e-8 | NR | XP_014527687.1 | 944170 | g18034 | i0 | 50.9 | 0.99344262295082 | 55 | 27 | 54.1 | 0 | 212 | 48 | 155 | 209 | XP_014527687.1 high mobility group b protein 6-like protein [Blastocystis sp. subtype 4] | diamond | 303 | 61.6 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. subtype 4 | |||
| 27598068 | 27598068 | PRJNA484127_P_NODE_7504_length_429_cov_1.095506_g7356_i0 | PRJNA484127 | 7504 | 429 | 1.095506 | 4.69972074 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 6.78e-31 | NR | KAL3788302.1 | 29204 | g7356 | i0 | 49.3 | 4.99300699300699 | 142 | 66 | 99.3 | 3 | 427 | 2 | 166 | 301 | KAL3788302.1 hypothetical protein HJC23_002876 [Cyclotella cryptica] | diamond | 2142 | 123 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 27629634 | 27629634 | PRJNA484127_P_NODE_34104_length_247_cov_1.793103_g33955_i0 | PRJNA484127 | 34104 | 247 | 1.793103 | 4.42896441 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 1.26e-20 | NR | XP_002259675.1 | 5851 | g33955 | i0 | 53.7 | 34.8097165991903 | 82 | 37 | 99.6 | 1 | 246 | 1 | 19 | 99 | XP_002259675.1 ras-related protein Rab-1A, putative [Plasmodium knowlesi strain H] | diamond | 8598 | 91.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 28055291 | 28055291 | PRJNA484127_P_NODE_7165_length_437_cov_1.211538_g7017_i0 | PRJNA484127 | 7165 | 437 | 1.211538 | 5.29442106 | Blastocystis sp. Blastoise | 3128533 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.09e-34 | NR | KAK8790990.1 | 3128533 | g7017 | i0 | 51.2 | 0.88558352402746 | 129 | 63 | 88.6 | 0 | 392 | 6 | 81 | 209 | KAK8790990.1 hypothetical protein WA158_005621 [Blastocystis sp. Blastoise] | diamond | 387 | 130 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. Blastoise | |||
| 28292379 | 28292379 | PRJNA484127_P_NODE_16306_length_318_cov_1.273469_g16157_i0 | PRJNA484127 | 16306 | 318 | 1.273469 | 4.04963142 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 3.38e-34 | NR | TMW63526.1 | 41045 | g16157 | i0 | 61.9 | 12.7830188679245 | 105 | 40 | 99.1 | 0 | 2 | 316 | 302 | 406 | TMW63526.1 hypothetical protein Poli38472_002467 [Pythium oligandrum] | diamond | 4065 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29065923 | 29065923 | PRJNA484127_P_NODE_21468_length_287_cov_1.355140_g21319_i0 | PRJNA484127 | 21468 | 287 | 1.35514 | 3.8892518 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.17e-15 | NR | CEO98730.1 | 37360 | g21319 | i0 | 50 | 0.878048780487805 | 84 | 38 | 87.8 | 2 | 35 | 286 | 1 | 80 | CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae] | diamond | 252 | 78.6 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29065934 | 29065934 | PRJNA484127_P_NODE_36868_length_244_cov_0.912281_g36719_i0 | PRJNA484127 | 36868 | 244 | 0.912281 | 2.22596564 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 2.15e-5 | NR | OQR97629.1 | 1202772 | g36719 | i0 | 61.1 | 0.442622950819672 | 36 | 14 | 44.3 | 0 | 122 | 229 | 272 | 307 | OQR97629.1 N-acetylglucosamine-1-phosphotransferase subunits alpha/beta [Achlya hypogyna] | diamond | 108 | 52 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 29113548 | 29113548 | PRJNA484127_P_NODE_30528_length_252_cov_0.871508_g30379_i0 | PRJNA484127 | 30528 | 252 | 0.871508 | 2.19620016 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.5499999999999998e-35 | NR | XP_013228494.1 | 5802 | g30379 | i0 | 77.8 | 3.85714285714286 | 81 | 18 | 96.4 | 0 | 245 | 3 | 1 | 81 | XP_013228494.1 40S ribosomal protein S18, putative [Eimeria tenella] | diamond | 972 | 128 | 0.9921875 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 29192202 | 29192202 | PRJNA484127_P_NODE_25529_length_268_cov_1.600000_g25380_i0 | PRJNA484127 | 25529 | 268 | 1.6 | 4.288 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 1.23e-20 | NR | SPQ93309.1 | 37360 | g25380 | i0 | 64.2 | 0.75 | 67 | 24 | 75 | 0 | 3 | 203 | 460 | 526 | SPQ93309.1 unnamed protein product [Plasmodiophora brassicae] | diamond | 201 | 95.5 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29254986 | 29254986 | PRJNA484127_P_NODE_28849_length_255_cov_4.313187_g28700_i0 | PRJNA484127 | 28849 | 255 | 4.313187 | 10.99862685 | Symbiodinium natans | 878477 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 3.09e-5 | NR | CAE7481866.1 | 878477 | g28700 | i0 | 54.2 | 0.564705882352941 | 48 | 22 | 56.5 | 0 | 239 | 96 | 51 | 98 | CAE7481866.1 unnamed protein product [Symbiodinium natans] | diamond | 144 | 51.6 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans | |||
| 29318299 | 29318299 | PRJNA484127_P_NODE_23229_length_278_cov_1.687805_g23080_i0 | PRJNA484127 | 23229 | 278 | 1.687805 | 4.6920979 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 1.1e-18 | NR | CEL92077.1 | 1169540 | g23080 | i0 | 58.2 | 1.65107913669065 | 79 | 30 | 82 | 2 | 49 | 276 | 248 | 326 | CEL92077.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 459 | 89.7 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 29966071 | 29966071 | PRJNA484127_P_NODE_29751_length_253_cov_0.866667_g29602_i0 | PRJNA484127 | 29751 | 253 | 0.866667 | 2.19266751 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 5.47e-7 | NR | KAF0694440.1 | 120398 | g29602 | i0 | 37.5 | 3.699604743083 | 80 | 48 | 94.9 | 1 | 250 | 11 | 304 | 381 | KAF0694440.1 hypothetical protein As57867_014640 [Aphanomyces stellatus] | diamond | 936 | 57 | 0.992982456140351 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30139094 | 30139094 | PRJNA484127_P_NODE_3972_length_561_cov_1.739754_g3827_i0 | PRJNA484127 | 3972 | 561 | 1.739754 | 9.76001994 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 5.29e-11 | NR | MES1907185.1 | 1215613 | g3827 | i0 | 64 | 0.572192513368984 | 50 | 18 | 26.7 | 0 | 54 | 203 | 1 | 50 | MES1907185.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 321 | 70.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30992632 | 30992632 | PRJNA484127_P_NODE_29394_length_253_cov_3.577778_g29245_i0 | PRJNA484127 | 29394 | 253 | 3.577778 | 9.05177834 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 3e-12 | NR | CCA27654.1 | 890382 | g29245 | i0 | 57.9 | 2.62055335968379 | 57 | 20 | 62.8 | 1 | 161 | 3 | 69 | 125 | CCA27654.1 hypothetical protein ALNC14_137980 [Albugo laibachii Nc14] | diamond | 663 | 68.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 31356485 | 31356485 | PRJNA484127_P_NODE_34476_length_247_cov_0.896552_g34327_i0 | PRJNA484127 | 34476 | 247 | 0.896552 | 2.21448344 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 6.65e-21 | NR | XP_012650249.1 | 1133968 | g34327 | i0 | 59.5 | 2.72064777327935 | 74 | 23 | 81.4 | 1 | 242 | 42 | 248 | 321 | XP_012650249.1 guanine nucleotide-binding protein subunit beta-2-like 1 protein [Babesia microti strain RI] | diamond | 672 | 94.7 | 0.996832101372756 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 31388140 | 31388140 | PRJNA484127_P_NODE_35696_length_246_cov_0.901734_g35547_i0 | PRJNA484127 | 35696 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 7.94e-11 | NR | CEM33325.1 | 1169540 | g35547 | i0 | 48.8 | 3.89024390243902 | 80 | 39 | 95.1 | 1 | 245 | 12 | 619 | 698 | CEM33325.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 957 | 67.4 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 32415998 | 32415998 | PRJNA484127_P_NODE_34339_length_247_cov_0.896552_g34190_i0 | PRJNA484127 | 34339 | 247 | 0.896552 | 2.21448344 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 7.52e-10 | NR | CAI2383647.1 | 5936 | g34190 | i0 | 47.4 | 0.947368421052632 | 78 | 34 | 86.2 | 1 | 246 | 34 | 5696 | 5773 | CAI2383647.1 unnamed protein product [Moneuplotes crassus] | diamond | 234 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus |
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);;