contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA492280" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26617574 | 26617574 | PRJNA492280_P_NODE_21841_length_164_cov_3.000000_g21734_i0 | PRJNA492280 | 21841 | 164 | 3 | 4.92 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0336 | NR | XP_013250559.1 | 5801 | g21734 | i0 | 48.7 | 2.3780487804878 | 39 | 20 | 71.3 | 0 | 45 | 161 | 1114 | 1152 | XP_013250559.1 hypothetical protein EAH_00010500, partial [Eimeria acervulina] | diamond | 390 | 42 | 0.990476190476191 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 27123701 | 27123701 | PRJNA492280_P_NODE_18122_length_164_cov_3.677165_g18015_i0 | PRJNA492280 | 18122 | 164 | 3.677165 | 6.0305506 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 2.08e-11 | NR | KAJ1447720.1 | 483370 | g18015 | i0 | 58 | 3.85975609756098 | 69 | 12 | 95.1 | 1 | 157 | 2 | 105 | 173 | KAJ1447720.1 ribosomal protein S6e-domain-containing protein [Pelagophyceae sp. CCMP2097] | diamond | 633 | 66.6 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagophyceae sp. CCMP2097 | ||||||
| 27361064 | 27361064 | PRJNA492280_P_NODE_11683_length_164_cov_8.795276_g11576_i0 | PRJNA492280 | 11683 | 164 | 8.795276 | 14.42425264 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 2.21e-7 | NR | KAJ1420219.1 | 483371 | g11576 | i0 | 100 | 1.31707317073171 | 24 | 0 | 43.9 | 0 | 92 | 163 | 659 | 682 | KAJ1420219.1 V-type ATPase, V0 complex, 116kDa subunit family, partial [Ochromonadaceae sp. CCMP2298] | diamond | 216 | 56.2 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 27424264 | 27424264 | PRJNA492280_P_NODE_20143_length_164_cov_3.307087_g20036_i0 | PRJNA492280 | 20143 | 164 | 3.307087 | 5.42362268 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0131 | NR | CEO98004.1 | 37360 | g20036 | i0 | 94.4 | 0.329268292682927 | 18 | 1 | 32.9 | 0 | 71 | 18 | 2209 | 2226 | CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] | diamond | 54 | 42.7 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27487192 | 27487192 | PRJNA492280_P_NODE_17063_length_164_cov_3.937008_g16956_i0 | PRJNA492280 | 17063 | 164 | 3.937008 | 6.45669312 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0115 | NR | OWZ01316.1 | 4795 | g16956 | i0 | 33.3 | 1.09756097560976 | 60 | 33 | 97 | 1 | 4 | 162 | 101 | 160 | OWZ01316.1 hypothetical protein PHMEG_00027324 [Phytophthora megakarya] | diamond | 180 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 27865936 | 27865936 | PRJNA492280_P_NODE_27865_length_159_cov_8.016393_g27758_i0 | PRJNA492280 | 27865 | 159 | 8.016393 | 12.74606487 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.85e-21 | NR | KAJ1436162.1 | 483371 | g27758 | i0 | 88 | 0.943396226415094 | 50 | 6 | 94.3 | 0 | 156 | 7 | 35 | 84 | KAJ1436162.1 ribosomal protein S25 [Ochromonadaceae sp. CCMP2298] | diamond | 150 | 89.4 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28734632 | 28734632 | PRJNA492280_P_NODE_10967_length_165_cov_4.710938_g10860_i0 | PRJNA492280 | 10967 | 165 | 4.710938 | 7.7730477 | root | 1 | Root_unresolved | Root_unresolved | 85.9 | 7.7e-18 | NR | GFH48659.1 | 426638 | g10860 | i0 | 73.7 | 5.18181818181818 | 57 | 10 | 94.5 | 1 | 161 | 6 | 365 | 421 | GFH48659.1 hypothetical protein CTEN210_05135 [Chaetoceros tenuissimus] | diamond | 855 | 86.3 | 0.995365005793743 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 28844691 | 28844691 | PRJNA492280_P_NODE_12148_length_164_cov_7.102362_g12041_i0 | PRJNA492280 | 12148 | 164 | 7.102362 | 11.64787368 | Mayamaea pseudoterrestris | 2872254 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 1.06e-6 | NR | GKY93619.1 | 2872254 | g12041 | i0 | 91.7 | 0.439024390243902 | 24 | 2 | 43.9 | 0 | 93 | 164 | 258 | 281 | GKY93619.1 hypothetical protein MPSEU_000329300 [Mayamaea pseudoterrestris] | diamond | 72 | 54.3 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Mayamaea | Mayamaea pseudoterrestris | ||
| 29176809 | 29176809 | PRJNA492280_P_NODE_7189_length_195_cov_3.329114_g7082_i0 | PRJNA492280 | 7189 | 195 | 3.329114 | 6.4917723 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.00214 | NR | NP_038188.1 | 47573 | g7082 | i0 | 62.9 | 1.55384615384615 | 35 | 12 | 53.8 | 1 | 110 | 6 | 44 | 77 | NP_038188.1 ribosomal protein S19 [Synura synuroidea] | diamond | 303 | 43.9 | 0.990888382687927 | Eukaryota | Sar | Synurophyceae | Synurales | Mallomonadaceae | Synura | Synura synuroidea | |||
| 29366125 | 29366125 | PRJNA492280_P_NODE_7029_length_197_cov_3.075000_g6922_i0 | PRJNA492280 | 7029 | 197 | 3.075 | 6.05775 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 5.42e-24 | NR | KAG1694345.1 | 4784 | g6922 | i0 | 70.4 | 3.24365482233503 | 71 | 15 | 99 | 1 | 195 | 1 | 64 | 134 | KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici] | diamond | 639 | 99.8 | 0.991983967935872 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 29696986 | 29696986 | PRJNA492280_P_NODE_31230_length_151_cov_3.315789_g31123_i0 | PRJNA492280 | 31230 | 151 | 3.315789 | 5.00684139 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 1.27e-4 | NR | KAJ1392417.1 | 483371 | g31123 | i0 | 72 | 1.01324503311258 | 25 | 7 | 49.7 | 0 | 6 | 80 | 8 | 32 | KAJ1392417.1 hypothetical protein B484DRAFT_459420 [Ochromonadaceae sp. CCMP2298] | diamond | 153 | 48.1 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29902978 | 29902978 | PRJNA492280_P_NODE_19751_length_164_cov_3.377953_g19644_i0 | PRJNA492280 | 19751 | 164 | 3.377953 | 5.53984292 | Bacillariophyceae | 33849 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00362 | NR | CAB9507415.1 | 568900 | g19644 | i0 | 73.9 | 2.54268292682927 | 23 | 6 | 42.1 | 0 | 94 | 162 | 302 | 324 | CAB9507415.1 pyrophosphokinase 3, chloroplastic [Seminavis robusta] | diamond | 417 | 44.3 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta | ||
| 30361230 | 30361230 | PRJNA492280_P_NODE_25752_length_164_cov_2.377953_g25645_i0 | PRJNA492280 | 25752 | 164 | 2.377953 | 3.89984292 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00268 | NR | KAJ1440286.1 | 483371 | g25645 | i0 | 55.9 | 0.621951219512195 | 34 | 15 | 62.2 | 0 | 161 | 60 | 278 | 311 | KAJ1440286.1 peptidase family M1-domain-containing protein, partial [Ochromonadaceae sp. CCMP2298] | diamond | 102 | 44.7 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30487216 | 30487216 | PRJNA492280_P_NODE_10793_length_165_cov_7.125000_g10686_i0 | PRJNA492280 | 10793 | 165 | 7.125 | 11.75625 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 4.38e-20 | NR | XP_012196500.1 | 695850 | g10686 | i0 | 77.4 | 6.72727272727273 | 53 | 12 | 96.4 | 0 | 161 | 3 | 40 | 92 | XP_012196500.1 60S ribosomal protein L31 [Saprolegnia parasitica CBS 223.65] | diamond | 1110 | 86.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 30771664 | 30771664 | PRJNA492280_P_NODE_34474_length_150_cov_3.026549_g34367_i0 | PRJNA492280 | 34474 | 150 | 3.026549 | 4.5398235 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 1.04e-12 | NR | KAJ1436502.1 | 483371 | g34367 | i0 | 62.3 | 1.06 | 53 | 15 | 96 | 1 | 6 | 149 | 21 | 73 | KAJ1436502.1 hypothetical protein B484DRAFT_428587, partial [Ochromonadaceae sp. CCMP2298] | diamond | 159 | 67.8 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31467039 | 31467039 | PRJNA492280_P_NODE_18256_length_164_cov_3.637795_g18149_i0 | PRJNA492280 | 18256 | 164 | 3.637795 | 5.9659838 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 2.97e-4 | NR | KAJ1438586.1 | 483371 | g18149 | i0 | 73.9 | 0.420731707317073 | 23 | 6 | 42.1 | 0 | 93 | 161 | 498 | 520 | KAJ1438586.1 cactus-binding C-terminus of cactin protein-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 69 | 47.4 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31483126 | 31483126 | PRJNA492280_P_NODE_23656_length_164_cov_2.779528_g23549_i0 | PRJNA492280 | 23656 | 164 | 2.779528 | 4.55842592 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00115 | NR | KAJ1422796.1 | 483371 | g23549 | i0 | 83.3 | 2.72560975609756 | 24 | 4 | 43.9 | 0 | 89 | 160 | 50 | 73 | KAJ1422796.1 HisG, C-terminal domain-containing protein, partial [Ochromonadaceae sp. CCMP2298] | diamond | 447 | 44.3 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31783007 | 31783007 | PRJNA492280_P_NODE_33337_length_150_cov_4.123894_g33230_i0 | PRJNA492280 | 33337 | 150 | 4.123894 | 6.185841 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0265 | NR | CAE8730362.1 | 89957 | g33230 | i0 | 72 | 1 | 25 | 7 | 50 | 0 | 149 | 75 | 187 | 211 | CAE8730362.1 unnamed protein product [Polarella glacialis] | diamond | 150 | 41.6 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 32004653 | 32004653 | PRJNA492280_P_NODE_19338_length_164_cov_3.448819_g19231_i0 | PRJNA492280 | 19338 | 164 | 3.448819 | 5.65606316 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 6.64e-12 | NR | KAJ1402924.1 | 483371 | g19231 | i0 | 55.4 | 2.3780487804878 | 65 | 16 | 95.1 | 1 | 6 | 161 | 6 | 70 | KAJ1402924.1 hypothetical protein B484DRAFT_338555 [Ochromonadaceae sp. CCMP2298] | diamond | 390 | 64.7 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 32067789 | 32067789 | PRJNA492280_P_NODE_20018_length_164_cov_3.330709_g19911_i0 | PRJNA492280 | 20018 | 164 | 3.330709 | 5.46236276 | Pseudo-nitzschia multistriata | 183589 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 5.36e-5 | NR | VEU44921.1 | 183589 | g19911 | i0 | 46.9 | 1.33536585365854 | 49 | 20 | 78.7 | 1 | 35 | 163 | 55 | 103 | VEU44921.1 unnamed protein product [Pseudo-nitzschia multistriata] | diamond | 219 | 49.3 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Pseudo-nitzschia | Pseudo-nitzschia multistriata | ||
| 32668494 | 32668494 | PRJNA492280_P_NODE_18260_length_164_cov_3.637795_g18153_i0 | PRJNA492280 | 18260 | 164 | 3.637795 | 5.9659838 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 4.24e-5 | NR | KAJ1409643.1 | 483371 | g18153 | i0 | 76 | 1.3719512195122 | 25 | 6 | 45.7 | 0 | 89 | 163 | 44 | 68 | KAJ1409643.1 ribosomal protein L35A [Ochromonadaceae sp. CCMP2298] | diamond | 225 | 47.8 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 32747501 | 32747501 | PRJNA492280_P_NODE_22760_length_164_cov_2.897638_g22653_i0 | PRJNA492280 | 22760 | 164 | 2.897638 | 4.75212632 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 6.35e-8 | NR | XP_024582876.1 | 4781 | g22653 | i0 | 50 | 21.1463414634146 | 68 | 20 | 98.8 | 1 | 163 | 2 | 677 | 744 | XP_024582876.1 cellulose synthase 3 [Plasmopara halstedii] | diamond | 3468 | 57.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32857477 | 32857477 | PRJNA492280_P_NODE_19560_length_164_cov_3.409449_g19453_i0 | PRJNA492280 | 19560 | 164 | 3.409449 | 5.59149636 | Ectocarpus siliculosus | 2880 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 2.7e-4 | NR | CBN74803.1 | 2880 | g19453 | i0 | 56.5 | 0.841463414634146 | 46 | 19 | 82.3 | 1 | 158 | 24 | 210 | 255 | CBN74803.1 conserved unknown protein [Ectocarpus siliculosus] | diamond | 138 | 47.4 | 1 | Eukaryota | Sar | Phaeophyceae | Ectocarpales | Ectocarpaceae | Ectocarpus | Ectocarpus siliculosus |
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);;