contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24009167 | 24009167 | PRJNA263496_P_NODE_18859_length_178_cov_2.767442_g18606_i0 | PRJNA263496 | 18859 | 178 | 2.767442 | 4.92604676 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 4.39e-19 | NR | CDW80370.1 | 5949 | g18606 | i0 | 70.7 | 15.8595505617978 | 58 | 17 | 97.8 | 0 | 5 | 178 | 788 | 845 | CDW80370.1 elongation factor domain iv family protein [Stylonychia lemnae] | diamond | 2823 | 90.5 | 0.991160220994475 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 26630883 | 26630883 | PRJNA263496_P_NODE_22421_length_165_cov_0.879310_g22168_i0 | PRJNA263496 | 22421 | 165 | 0.87931 | 1.4508615 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 2.92e-20 | NR | CCI41832.1 | 65357 | g22168 | i0 | 77.8 | 1.94545454545455 | 54 | 12 | 98.2 | 0 | 163 | 2 | 183 | 236 | CCI41832.1 unnamed protein product [Albugo candida] | diamond | 321 | 92.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 27832083 | 27832083 | PRJNA263496_P_NODE_23544_length_164_cov_0.886957_g23291_i0 | PRJNA263496 | 23544 | 164 | 0.886957 | 1.45460948 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 2.05e-9 | NR | KAJ1439331.1 | 483371 | g23291 | i0 | 60 | 0.823170731707317 | 45 | 18 | 82.3 | 0 | 137 | 3 | 50 | 94 | KAJ1439331.1 hypothetical protein B484DRAFT_476943 [Ochromonadaceae sp. CCMP2298] | diamond | 135 | 61.2 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28653099 | 28653099 | PRJNA263496_P_NODE_25607_length_161_cov_0.910714_g25354_i0 | PRJNA263496 | 25607 | 161 | 0.910714 | 1.46624954 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 2.32e-21 | NR | KAJ0409191.1 | 114742 | g25354 | i0 | 84.9 | 1.97515527950311 | 53 | 8 | 98.8 | 0 | 2 | 160 | 965 | 1017 | KAJ0409191.1 hypothetical protein ATCC90586_010272 [Pythium insidiosum] | diamond | 318 | 95.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 28779221 | 28779221 | PRJNA263496_P_NODE_2147_length_631_cov_2.628866_g1921_i0 | PRJNA263496 | 2147 | 631 | 2.628866 | 16.58814446 | Arachnula sp. CL12 | 862247 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 1.3e-62 | NR | ADK90073.1 | 862247 | g1921 | i0 | 53 | 1.75435816164818 | 198 | 69 | 94.1 | 3 | 629 | 36 | 274 | 447 | ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12] | diamond | 1107 | 211 | 1 | Eukaryota | Sar | Endomyxa | Vampyrellida | Leptophryidae | Arachnula | Arachnula sp. CL12 | |||
| 28779222 | 28779222 | PRJNA263496_P_NODE_23167_length_164_cov_0.886957_g22914_i0 | PRJNA263496 | 23167 | 164 | 0.886957 | 1.45460948 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.17e-7 | NR | TYZ57306.1 | 1485010 | g22914 | i0 | 64.1 | 1.42682926829268 | 39 | 14 | 71.3 | 0 | 162 | 46 | 236 | 274 | TYZ57306.1 hypothetical protein PybrP1_008020 [[Pythium] brassicae (nom. inval.)] | diamond | 234 | 57 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 29252707 | 29252707 | PRJNA263496_P_NODE_22089_length_166_cov_0.871795_g21836_i0 | PRJNA263496 | 22089 | 166 | 0.871795 | 1.4471797 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.26e-20 | NR | CCA15626.1 | 890382 | g21836 | i0 | 81.1 | 0.957831325301205 | 53 | 10 | 95.8 | 0 | 6 | 164 | 375 | 427 | CCA15626.1 Dlactate dehydrogenase putative [Albugo laibachii Nc14] | diamond | 159 | 93.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 29252709 | 29252709 | PRJNA263496_P_NODE_8669_length_270_cov_0.914027_g8416_i0 | PRJNA263496 | 8669 | 270 | 0.914027 | 2.4678729 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 5.15e-9 | NR | KAF4676629.1 | 330153 | g8416 | i0 | 51.9 | 0.6 | 54 | 25 | 60 | 1 | 184 | 23 | 24 | 76 | KAF4676629.1 hypothetical protein FOL47_005782 [Perkinsus chesapeaki] | diamond | 162 | 62.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29965474 | 29965474 | PRJNA263496_P_NODE_12911_length_218_cov_1.207101_g12658_i0 | PRJNA263496 | 12911 | 218 | 1.207101 | 2.63148018 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 8.84e-17 | NR | XP_001425443.1 | 5888 | g12658 | i0 | 60.9 | 11.3669724770642 | 64 | 24 | 88.1 | 1 | 5 | 196 | 167 | 229 | XP_001425443.1 uncharacterized protein GSPATT00029080001 [Paramecium tetraurelia] | diamond | 2478 | 84 | 0.990476190476191 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 30376552 | 30376552 | PRJNA263496_P_NODE_21032_length_167_cov_1.118644_g20779_i0 | PRJNA263496 | 21032 | 167 | 1.118644 | 1.86813548 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0038 | NR | TNV86175.1 | 5974 | g20779 | i0 | 46 | 13.3652694610778 | 50 | 25 | 86.2 | 2 | 7 | 150 | 73 | 122 | TNV86175.1 hypothetical protein FGO68_gene11281 [Halteria grandinella] | diamond | 2232 | 44.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 30502535 | 30502535 | PRJNA263496_P_NODE_24033_length_163_cov_0.894737_g23780_i0 | PRJNA263496 | 24033 | 163 | 0.894737 | 1.45842131 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.46e-12 | NR | POM75922.1 | 4796 | g23780 | i0 | 55.6 | 6.95705521472393 | 54 | 24 | 99.4 | 0 | 162 | 1 | 357 | 410 | POM75922.1 Hypothetical protein PHPALM_6909 [Phytophthora palmivora] | diamond | 1134 | 71.6 | 0.990223463687151 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 31591207 | 31591207 | PRJNA263496_P_NODE_10016_length_249_cov_1.895000_g9763_i0 | PRJNA263496 | 10016 | 249 | 1.895 | 4.71855 | Chrysophaeum taylorii | 2483200 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.67e-11 | NR | KAJ8601885.1 | 2483200 | g9763 | i0 | 64.3 | 1.33734939759036 | 56 | 20 | 67.5 | 0 | 18 | 185 | 419 | 474 | KAJ8601885.1 hypothetical protein CTAYLR_002641 [Chrysophaeum taylorii] | diamond | 333 | 69.3 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Chrysophaeum | Chrysophaeum taylorii | |||
| 31685753 | 31685753 | PRJNA263496_P_NODE_24297_length_163_cov_0.894737_g24044_i0 | PRJNA263496 | 24297 | 163 | 0.894737 | 1.45842131 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 3.19e-13 | NR | KAJ1431642.1 | 483371 | g24044 | i0 | 67.9 | 0.975460122699387 | 53 | 17 | 97.5 | 0 | 163 | 5 | 384 | 436 | KAJ1431642.1 major facilitator superfamily domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 159 | 72.8 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31970579 | 31970579 | PRJNA263496_P_NODE_25558_length_161_cov_0.910714_g25305_i0 | PRJNA263496 | 25558 | 161 | 0.910714 | 1.46624954 | Vitrella brassicaformis CCMP3155 | 1169540 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 1.11e-4 | NR | CEM16823.1 | 1169540 | g25305 | i0 | 54.3 | 3.48447204968944 | 46 | 21 | 85.7 | 0 | 4 | 141 | 220 | 265 | CEM16823.1 unnamed protein product [Vitrella brassicaformis CCMP3155] | diamond | 561 | 48.5 | 1 | Eukaryota | Sar | Vitrellaceae | Vitrella | Vitrella brassicaformis | |||||
| 32791962 | 32791962 | PRJNA263496_P_NODE_22880_length_165_cov_0.879310_g22627_i0 | PRJNA263496 | 22880 | 165 | 0.87931 | 1.4508615 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 8.62e-6 | NR | XP_013251295.1 | 5801 | g22627 | i0 | 76.3 | 1.38181818181818 | 38 | 9 | 69.1 | 0 | 164 | 51 | 173 | 210 | XP_013251295.1 60S ribosomal protein L13, related [Eimeria acervulina] | diamond | 228 | 51.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;